The Transactions by Month report shows 12 months of estimates, invoices, credit notes and payments as charts and tables. Use it to follow the flow from quotes to invoices to payments, see how many estimates were accepted each month, and check how much cash came in.
Open the report
Go to Reports in the left menu. On the Standard tab, find Transactions by Month under Finance, or type "month" into Search.
Click the report to open it. The parameters are in the panel on the right. Change them, then click Preview to run the report again.
Choose what to include
- Calendar Year: the year to report on. It starts as the current year.
- Ending: the last of the 12 months, in the calendar year you chose. The default is December, which gives January to December. If your financial year runs from July to June, choose June.
- Include Financials (on by default): shows the invoices, credit notes and payments. Turn it off to hide them.
- Invoice Status: only count invoices in these statuses: Draft, Sent, Late, Partially Paid or Paid. Leave it empty to count invoices in every status. Credit notes and payments are always counted.
- Include Estimates (on by default): shows your estimates. Turn it off to hide them.
- Estimate Status: only count estimates in these statuses: Draft, Sent, Accepted, Rejected, Converted or Expired. Leave it empty to count them all.
Late means an invoice that is sent or partially paid and past its due date. Expired means a sent estimate that is past its expiry date.
Read the report
The report has two parts, and each has a chart and a table with one column per month and a Total.
- Estimate / Quotes: a stacked column chart, Estimate Breakdown by Status, splits each month's estimates by status. The table shows the amounts per status.
- Financial Transactions: the chart has a column for each transaction type in each month. The table shows the monthly totals of sales invoices, retainer invoices, credit notes and payments.
Transactions count in the month of their issue date. Amounts are the full totals of each estimate or transaction, including tax, in your account currency. Transactions in other currencies are converted: see currency conversion in reports.
Drill down to the transactions
Click an amount in either table to open a drill-down report for that month:
Report | Columns |
|---|---|
Estimate Drill Report | Customer, Issue Date, Expire Date, Est Number, Status, Subject, Amount |
Transaction Drill Report | Customer, Issue Date, Type, Tran Number, Subject, Status, Amount, Balance |
The drill-down amounts are in your account currency too. Click an Est Number or Tran Number to open the estimate, invoice, credit note or payment.
For revenue per customer, use the Revenue by Month report. For a full list of transactions with any grouping, use the Transaction List report.
Save, schedule or export
To keep your parameter choices, save the report as your own copy: see saving and sharing reports. On a paid plan, a saved report can be emailed to you on a schedule, for example every month: see scheduling reports for email delivery. To download the report as a file, see exporting data.
Who can see it
Finance reports are available to Administrators and Finance Managers. If you can't find the report, ask an Administrator to add the Finance Manager role under Assign Roles on your contact record. See managing users and contacts.