Skip to main content

Invoice and payment reporting

Invoice and payment reports for small businesses

On Pro ($9/month), the Reports page shows what you invoiced, collected, spent and tracked for any date range up to 366 days, filtered by client or project, with every amount kept per currency. It includes a receivables aging snapshot by due date, a list of unbilled work and a CSV download for each table. On Business ($19/month), AI adds 3 to 5 written observations drawn only from those figures. On every plan, the dashboard shows all-time totals for collected, outstanding, invoices and clients.

Reports are on Pro ($9/month) and Business ($19/month); AI insights need Business. The dashboard, Payments page and Documents list are on every plan, so you can try free first.

Reports: last 90 days

Pro
Reports page for the last 90 days in USD: $6,590 invoiced, $3,250 collected, $3,340 outstanding with $960 overdue, $317.69 of expenses and $1,452.40 of unbilled work, above an AI insights panel with a Generate insights button
Actual InvoiceQuickly Reports page with synthetic example data. The totals are on Pro and draft invoices are left out; the AI insights panel below them is on Business. Open full size
  • Pro: any date range up to 366 days
  • Invoices, payments, expenses and time, per currency
  • Aging by due date, plus unbilled work
  • Business: AI insights from your own figures

Reporting

What reporting does InvoiceQuickly include?

Pro and Business add a Reports page; every plan has the dashboard, Payments page and Documents list. Together they answer "who owes me money?", "how much has come in?" and "what haven't I billed yet?" directly.

Reports page

Pro
Invoices issued, invoiced, collected, credited, outstanding and overdue; payments received, refunded and net by method; expenses by category; and hours tracked, billable, billed and unbilled. Pick a preset such as last month or year to date, or any range up to 366 days, and filter by client or project. Drafts are left out of the totals.

Aging and unbilled work

Pro
Open invoice balances in Current, 1-30, 31-60, 61-90 and 90+ day buckets by due date, as of today, plus the time and expenses you haven't billed yet. Each of these tables downloads as CSV.

Time valued like your invoices

Pro
Billable time is valued at each entry's hourly rate, the same way the Time page and invoices value it. Billable hours with no rate are shown separately instead of being guessed.

AI insights

Business
AI writes 3 to 5 short observations from the report's recalculated figures. An observation that cites a number not in those figures is dropped, and each run uses one of 200 premium AI operations a month.

Dashboard totals

All plans
Total collected, total outstanding, the number of invoices and the number of clients, plus your five most recent documents with their status.

Payments list

All plans
Every payment recorded against an invoice, by Stripe, PayPal or manual entry, with the invoice, client, method, date and amount after any refund. A Total Received figure sits on top, per currency.

Documents list with status

All plans
Every invoice, estimate and credit note with its client, status (draft, sent, viewed, overdue, paid or cancelled), issue date and total. Tabs filter by document type.

CSV export

Pro
One click on the Documents page downloads every document as a CSV file, ready for a spreadsheet, the aging report below or your accountant.

Reports cover invoices, payments, expenses and time. There is no profit and loss, balance sheet, cash flow or tax report, and currencies are never converted into one total. Those statements need a full ledger and bank balances; the accounting basics hub explains why, and the QuickBooks Online and Xero export gets your invoices into one.

CSV export

What's in the CSV export?

On Pro, the Documents page has a CSV button once you have at least one document. Anyone in your workspace can use it, whatever their role. The file, named invoices-YYYY-MM-DD.csv, holds every document you've created, newest first, with these 13 columns.

ColumnWhat it holds
Invoice NumberINV-, EST- or CN- number, so estimates and credit notes are in the file too
Statusdraft, sent, viewed, overdue, paid or cancelled for invoices
ClientClient name, or the name typed on the invoice
Client EmailClient email, if there is one
Issue DateYYYY-MM-DD
Due DateYYYY-MM-DD
CurrencyThree-letter code, for example USD
SubtotalBefore discount and tax
TaxTax amount
DiscountDiscount amount
TotalInvoice total
Paid AtDate the invoice became fully paid, if it has
Payment LinkThe Stripe or PayPal link, if one was created

Scroll sideways to see every column.

What the file doesn't hold. There is no amount-paid or balance column, so for a partly paid invoice, take the payments from the Payments page. The export always covers all documents; filter by date in your spreadsheet.

For tax time, the Tax and Issue Date columns give your accountant the tax charged on each invoice. The return itself is up to you or your accountant.

The dashboard

What does each dashboard figure count?

On every plan, the dashboard shows four all-time tiles above your five most recent documents, and the Payments page adds a Total Received figure, net of refunds. For a date range, use the Reports page on Pro.

Dashboard figureWhat it countsLimits
Total revenueAll payments recorded against invoices, full or partial, after refundsAll-time only. Cash received, not revenue earned.
OutstandingUnpaid balance of invoices that are sent, viewed or overdue, after payments and credit notesAll-time; drafts and cancelled invoices excluded
Total invoicesCount of invoices (not estimates or credit notes)No breakdown by month
ClientsCount of clients

Scroll sideways to see every column.

Each currency is totalled separately. If you bill in USD and EUR, the tile shows both, rounded to whole units, for example "$7,450 / €1,200". Nothing converts them.

"Total revenue" is cash. It adds up payments received, so an invoice issued in March and paid in May counts in May. For tax, that matches the cash method, not the accrual method; the accounting basics hub explains the difference.

Worked example

How do you build an AR aging report from your invoices?

An aging report groups unpaid balances by how far past their due date they are on a chosen date: Current (not yet due), 1-30, 31-60, 61-90 and over 90 days past due. Some systems age from the invoice date instead; aging from the due date shows lateness, which is what you'll act on. On Pro, the Reports page builds this table as of today. Example: six unpaid USD invoices as of 31 October 2026. INV-0024 was $2,400.00 with $1,000.00 already paid, so its balance is $1,400.00.

Unpaid invoices as of 31 October 2026
InvoiceClientDue dateBalanceDays past dueBucket
INV-0031Acme Ltd2026-11-141,200.00not yet dueCurrent
INV-0029Bluebird Co2026-10-30400.0011-30
INV-0027Bluebird Co2026-10-20850.00111-30
INV-0024Cobalt LLC2026-09-251,400.003631-60
INV-0019Acme Ltd2026-08-28600.006461-90
INV-0012Delta Inc2026-07-153,000.00108Over 90

Scroll sideways to see every column.

Totals by bucket
BucketBalanceShare of total
Current1,200.0016.1%
1-301,250.0016.8%
31-601,400.0018.8%
61-90600.008.1%
Over 903,000.0040.3%
Total7,450.00100%

Scroll sideways to see every column.

In a spreadsheet

Reproduce the aging report in six steps

Useful when you need an as-of date other than today, or you're on a plan without Reports and working from the CSV.

  1. Step 1: Set the as-of date

    Put it in a spare cell, say K1, for example 2026-10-31.

  2. Step 2: Paste and filter the CSV rows

    Export: Pro

    Keep rows starting with your invoice prefix (INV- by default). Remove EST- and CN- rows, and rows with status draft, cancelled or paid.

  3. Step 3: Add a Balance column

    For most rows it equals Total. For partly paid invoices, subtract the payments you recorded, because the export has no amount-paid column.

  4. Step 4: Add a Days column

    =$K$1-F2, where F2 is the Due Date.

  5. Step 5: Add a Bucket column

    =IF(G2<=0,"Current",IF(G2<=30,"1-30",IF(G2<=60,"31-60",IF(G2<=90,"61-90","Over 90"))))

  6. Step 6: Total by bucket

    Total the Balance column by Bucket with a pivot table or SUMIF.

Check your work against the dashboard. Aged as of today, your total should equal the dashboard's Outstanding figure for that currency, because both are the unpaid balance of sent, viewed and overdue invoices; in this example both would read $7,450 (the dashboard rounds to whole units). If they don't match, you've usually missed a partial payment or left a cancelled invoice in. Don't age by status: an invoice only becomes "overdue" when a Pro overdue reminder is sent for it, so an unpaid invoice past its due date can still say "sent". The due date is the reliable field.

Acting on it

What does the aging report tell you to do?

Read it by client, not just by bucket. There is no universal "good" aging percentage: compare the report with your own payment terms and watch the trend. If the share over 60 days grows from one month to the next, your collection process is slipping.

Delta Inc: call

40.3% of what you're owed is one invoice, 108 days late. That is a phone call, not another email.

Acme Ltd: ask about the old one

One current invoice and one 64 days late. Ask about the old one before the new one comes due.

Bluebird Co: a reminder

Two invoices only days late, so a reminder is enough.

On Pro, you can set scheduled reminders before and after the due date. They run when InvoiceQuickly's scheduled automation runs, or from the run button on the Recurring page. For one-off messages, the free payment reminder templates give you a gentle, a firm and a final wording, and the late fee calculator works out simple interest on an overdue balance. To track how fast clients pay over time, the getting paid hub shows how to work out days sales outstanding from these figures, and the accounts receivable turnover entry covers the related ratio.

Fit

When InvoiceQuickly's reporting isn't enough

A good fit when

  • You want to know who owes you money, what has come in and what you haven't billed yet.

  • Per-currency reports on invoices, payments, expenses and time are enough, and your accountant prepares the statements.

Look elsewhere when

  • You need a profit and loss statement. Reports show what you invoiced, collected and spent, but there is no ledger, depreciation or accrual adjustment; use accounting software.

  • You need a month-by-month chart. Reports total one date range at a time, so compare months by running each range.

  • You bill in several currencies and want one total. InvoiceQuickly keeps currencies apart and doesn't convert.

  • You're on the Free plan and need date ranges or a spreadsheet. Reports and the CSV export are on Pro ($9 a month). On Free, the dashboard shows all-time totals only.

  • Lenders or investors want statements. They'll expect statements prepared from full books, usually by an accountant.

If a report you need is missing, tell us what you'd need.

Questions

Frequently asked questions

What reports does InvoiceQuickly have?

On Pro and Business, a Reports page covers invoices, payments, expenses and time for any date range up to 366 days, filtered by client or project, with every amount per currency, an aging snapshot by due date and a list of unbilled work. Each table downloads as CSV, and Business adds AI insights. Every plan has the dashboard's all-time totals and the Payments page. There are no financial statements or tax reports.

How do you calculate the age of a receivable?

Subtract the invoice's due date from the date you're reporting on. A result of zero or less is current; otherwise it goes in the 1-30, 31-60, 61-90 or over-90-day bucket. Use the unpaid balance, not the original total, for partly paid invoices.

Does InvoiceQuickly show revenue by month?

Yes, on Pro: choose this month, last month or any range up to 366 days on the Reports page to see what you invoiced and collected in it, per currency. There is no month-by-month chart, so run one range per month or pivot the CSV export by Issue Date. On Free, the dashboard totals are all-time.

Does InvoiceQuickly produce a profit and loss statement?

No. Reports show what you invoiced, collected and spent, per currency, but there is no ledger, bank balances, depreciation or accrual adjustment, so there is no profit and loss, balance sheet or cash flow statement. Keep those in accounting software or with your accountant; on Business, reviewed invoices can be exported to QuickBooks Online or Xero.

Know who owes you, and what you haven't billed.

Pro at $9/month adds Reports, AR aging and the CSV export; Business at $19/month adds AI insights. The dashboard and payment tracking work on every plan.

Start with Pro

Or try free first: 5 invoices, no card.