Skip to main content

Financial Reports

The nine money reports - Invoice Aging, Time to Get Paid, Booked vs Collected, revenue by business unit and job type, Tax Summary, and more.

Written by Nick Stanisavljevic

Overview

Financial Reports answer the money questions: who owes you, how fast you get paid, what you sold against what you collected, and what you owe in tax.

This article covers what each report answers, how its numbers are calculated, and the decision it should drive.

Available in the Web App. See Reports: Overview and Where to Find What for the shared date range, filter, and export controls - and for the four dates that decide which period a dollar lands in.


When to Use This Group

  • You're chasing money and need to know who's overdue and by how much.

  • Cash feels tight even though you've been busy.

  • You're preparing for a sales tax filing.

  • You want to know whether one division or service type carries the business.

  • Your accountant asked for figures.


Invoice Aging Report

Unpaid invoices grouped by how overdue they are.

This is where collections start. Each row shows the invoice number, customer, linked job, the created, send, and due dates, a Late By count of days past due, the invoice total, and the Balance still owed after payments and credits.

Late By is what you sort by; Balance is what you chase. They're different - a large invoice mostly paid can matter less than a small one untouched for 90 days.

The Send Date stays blank until an invoice is actually sent - a quick way to spot invoices that were created and never went out.

For your complete receivables picture regardless of date range, there's an Open Invoices view covering everything still outstanding across all time. Unlike the rest of the Reports section, it ignores the date range - which is the point, since an unpaid invoice from last year is still money owed.


Invoice Payment Status Summary

Includes all Paid, Partially Paid, and Pending invoices.

A status-level view of your invoicing rather than an aging view. Use it to see the overall shape - how much of your billing is settled versus still moving.

Partially Paid is the row worth watching. Those are invoices with money already in, which behave differently from untouched ones. See Partial Payments on Invoices.


Time to Get Paid

Average number of days clients take to pay.

This works at three levels, and knowing which you're looking at matters:

  • Business-wide - your overall payment speed at a glance, filterable by service area and tag.

  • Per invoice - one line per invoice with its full timeline: dated, sent, due, and paid, plus Days To Get Paid, the elapsed days from invoice date to payment. Unpaid invoices show no paid date.

  • Per customer - each customer's invoice count, average, fastest, and slowest payment times, and total collected from them.

The per-customer view is where slow payers stop being a feeling and become a list. A customer whose slowest payment is 120 days is a known risk to price and schedule around — or to put on payment-method-at-approval. See Requiring Payment Details When a Client Approves a Proposal.

If your business-wide average is 45 days on 15-day terms, your terms aren't the problem - enforcement is.


Booked vs Collected Revenue

Compare accepted proposals value and received payments.

Per interval - week, month, or year - you get Booked Jobs and their value, Completed Jobs, Collected Value, and a Variance column: booked minus collected.

Variance is your early warning. A strong sales month with a growing variance means you're selling faster than you're collecting - the cash problem arrives later, and this column sees it first.

Three rules that explain most "why doesn't this match" questions:

  • Each figure lands on its own date. Booked counts on the acceptance date, Completed on the closed date, Collected on the payment date. One job can appear in three different months, legitimately.

  • Draft invoices never count. An invoice enters the numbers once it's real - Pending, Partially Paid, or Paid.

  • Recurring jobs contribute their upcoming scheduled invoices. A maintenance agreement shows expected revenue in the months it will bill, before those invoices exist. Forward months therefore include projected recurring revenue, not just history. See Recurring Jobs & Automatic Invoicing.

A by-account view breaks the same comparison out per customer, so you can see who is driving the variance. And for a single headline figure - total booked and total collected for the period - there's a Revenue Total view, useful for a quick month-end or year-end number.

This is a cash-timing report, not a profitability report. Booking $500k tells you nothing about whether those jobs made money - use Job Costing for that.


Revenue by Business Unit and Revenue by Job Type

See revenue breakdown by each of your business units / job types.

Both run on the same engine. Each row shows one business unit or job type with:

  • Total Accounts - customers with booked or collected value in the period. Accounts with neither are left out, so this means accounts with activity, not all accounts.

  • Booked - accepted job value, counted on the acceptance date.

  • Collected - successful payments, counted on the payment date.

  • Avg. Job Size - average job value across jobs whose start date falls in the period.

Click into any row to see the customers behind the number - each with their booked, collected, average job size, and Lifetime Value: the sum of all their paid invoice totals. Unpaid and draft invoices never count toward Lifetime Value, so it's money actually received, ever.

Accounts missing a business unit or job type are surfaced on the same page, so you can see what's uncategorised and fix it - an account without a category can't appear in the breakdown above it.

Business Unit tells you which team earns; Job Type tells you which work earns. Both are revenue, not profit - a division with high revenue and heavy labour costs can still be your weakest. Requires the categories to be set up and assigned. See Business Units & Job Types.


Transaction List

All transactions for your business.

Every payment across every account in one list - online and manually recorded, sales and refunds.

Use it when you're reconciling and need to find a specific payment, or when you want the full picture of a period rather than one invoice's history. For a single invoice's payments, the Transaction Log on the invoice is quicker. See Recording a Manual Payment.


Tax Summary

Accrual or Cash basis tax report.

Four variants - two bases, each summarized or detailed:

  • Accrual - tax counts when the invoice is issued. Every invoice except drafts, whether or not it's been paid.

  • Cash - tax counts when payment is received. Only invoices with payments, on the amount actually paid.

The two will not match, and shouldn't. An invoice issued in December and paid in January lands in December on accrual and January on cash. That's the entire difference between the bases, in one sentence — and why switching between them mid-year makes your filings look inconsistent.

Summarized gives totals per tax name and rate - the version for your accountant. Detailed gives one row per invoice (accrual) or per payment (cash) with the account, totals, taxable amount, and tax - the version for when a figure is questioned.

Use whichever basis your books and filings use; if you don't know, ask your accountant before filing from this report. Full detail in Tax Reporting, and setup in Setting Up Sales Tax.


PriceBook Items Sold

Units sold and revenue breakdown by PriceBook item.

Per item: the type, your unit price and unit cost, Units Sold, how many work orders included it, the total Booked Value, and the Avg Unit Value - booked value over units sold. Everything counts on the approval date, so this is what you sold, not what you've collected.

Avg Unit Value against your list price shows where discounting is happening in practice. An item listed at $400 averaging $310 is being negotiated down, item by item, and this is the only place that's visible.

An overview view splits your booked totals into Labor and Material - including one-off custom items that aren't in your PriceBook, so hand-typed line items aren't invisible here.

Two things to act on: items selling well that you could price better, and items that never sell and are cluttering the list your team scrolls through. See PriceBook.


Tips & Best Practices

  • Run three every month. Invoice Aging, Booked vs Collected, and Time to Get Paid together tell you most of what you need about cash.

  • Watch the Variance column, not just the totals. It's the earliest signal that sales and cash are diverging.

  • Confirm your tax basis once, then stick to it. Switching between accrual and cash between filings makes your records look inconsistent.

  • Use the per-customer payment times before taking on big work. A customer's slowest-ever payment is useful due diligence before a $40k job.

  • Don't read revenue reports as profit reports. Revenue by Business Unit and Revenue by Job Type both show what came in, not what you kept.

  • Export before your accountant meeting. CSV and XLS are more useful to them than a screen share.


Things to Know

  • Booked counts on the acceptance date, Completed on the closed date, Collected on the payment date, and Avg. Job Size on the job start date. The same job can legitimately appear in different periods across reports.

  • Draft invoices never appear in revenue figures. Invoices count once Pending, Partially Paid, or Paid.

  • Recurring jobs contribute their upcoming scheduled invoices to Booked vs Collected, so forward months include expected recurring revenue.

  • Lifetime Value is the sum of paid invoice totals only — unpaid and draft invoices never count.

  • Total Accounts in the revenue breakdowns means accounts with booked or collected activity in the period, not all accounts.

  • The Open Invoices view ignores the date range deliberately - it's your all-time receivables.

  • Invoice Aging's Send Date is blank until the invoice is actually sent.

  • PriceBook Items Sold counts on the approval date; its overview includes custom items not in your PriceBook.

  • Credit memos are included where relevant, so balances reflect credits you've issued.

  • All reports here export to CSV, XLS, and XLSX. Some are permission-gated by role.


Troubleshooting

My tax figure changed when I switched basis.
That's expected. Accrual counts invoices by issue date; cash counts payments by payment date. An invoice issued in December and paid in January is in December on one and January on the other.

Booked and collected are far apart and I don't know why.
Open the by-account view to see who's driving the variance, then Invoice Aging for the specific invoices. Usually it's work invoiced and unpaid rather than anything wrong with the report.

Next month already shows collected-side expectations I haven't billed.
Recurring jobs project their upcoming scheduled invoices forward. That's your maintenance agreements showing the revenue they're due to generate.

Two reports give different revenue for the same period.
Check which date each counts on. Booked, completed, collected, and job-start dates are four different days, and the same job lands in different periods depending on which one a report uses.

Revenue by Business Unit is missing accounts I expected.
Two possibilities: the account has no business unit assigned - check the uncategorised accounts shown on the page - or it had no booked or collected activity in the period.

A job isn't in PriceBook Items Sold.
Its line items were typed manually rather than pulled from the PriceBook. Check the overview's Labor and Material split, which includes custom items.

An invoice shows no Send Date.
It was created but never sent. That's worth acting on, not just noting.


Have questions? Reach out via the support chat or email support@motionops.com.

Did this answer your question?