Skip to main content

Accounts Receivable Reports

The A/R Aging Summary report offers a high-level view of total and overdue receivables.

Accounts Receivable reporting gives you clear and faster action on unpaid balances.

Find all these reports by clicking "Report" at the top of your screen the navigating down to the "Finance" section on your left.

A/R Aging Summary report

The A/R Aging Summary report offers a high-level view of total and overdue receivables

A/R Aging Detail report

The A/R Aging Detail report highlights invoice risk by showing how long balances have been outstanding.

A/R Aging Collection Report

The A/R Aging Collection Report helps you track open invoices and credits past their due date grouped by Customer.

In QuickBooks order, sorted your way

As of the 26.47.0 release, every aging report opens in customer name order, compared the way QuickBooks compares names: "10 Trucking" comes before "2 Trucking", and accented letters sort with their base letter. Click any column header to sort (names A to Z, money largest first, dates oldest first, Past Due largest first); the second click reverses it. Document numbers sort by number, so 99 comes before 100. Aging buckets keep their fixed order, and a header click sorts the rows inside each group. The sort holds while you stay on the report; opening it again starts A to Z.

Filter by customer, past due and location

Every report has one filter row: As of, Customer, Past due and Location.

  • Customer: tick one or several.

  • Past due: tick any of 1-30 days, 31-60 days, 61-90 days and 91+ days. The Detail and Collection reports keep only the invoices in those ranges, and always keep credits; the Summary lists the customers with an amount in those ranges, at their full balance.

  • Location: opens with every location ticked, so an untouched report shows the same organization-wide numbers as before. A Location column shows whenever two or more locations are in view.

  • The Totals row always adds up exactly the rows the filters leave. Clicking a customer on the Summary opens A/R Collection with the same as-of date, past due ranges and locations. Your filters are kept in the page address, so Back, a reload or a shared link brings them back.

A/R Collection as a call list

Each customer's row on A/R Collection shows "Phone:" and their number. Users with the 'View and Manage AP/AR Data' permission also see "Credit term:", or "COD" when none is set. Both appear in the exports too: the PDF prints them on each customer's line, and the CSV has Phone and Credit Term columns.

Exporting A/R Reports

The Print button is now an Export menu: the ⋯ button next to the title offers Download (PDF) and Download (CSV). Exports match the screen — same rows, same filters, same order — and state the as-of date, locations and any filters you picked. The CSV is one flat table with the aging bucket in its own column and a Totals row at the bottom. A PDF takes up to 2,000 rows (over that, download the CSV instead) and a CSV up to 50,000 rows. The PDF prints the as-of date you picked.

What changed in 26.47.0

  • A credit memo or deposit dated exactly on the as-of date now shows in Current with Past Due 0, the way QuickBooks ages it. Before, it showed in 1-30. Older credits still age from their own date.

  • The A/R Summary Totals row now adds up exactly the customer rows above it. Before, it also counted invoices paid for more than their amount, so a few customers' Totals change slightly; the rows don't change.

  • On A/R Collection, the Totals row now follows the customer filter.

  • Clicking a row no longer opens it: click the document number, or the customer name on the Summary. A document number links only when you can open it — an invoice at another location you work at asks "Switch location?" first, and credit memos and deposits have no page of their own.

  • Transaction Type names each kind of credit (Credit Memo or Deposit), dates read as dates (for example "Nov 4, 2026"), the date filter reads "As of", and Collapse all / Expand all opens or closes every customer group with the group you're scrolling pinned under the headings.

  • Viewing and exporting need Reports page access, as today. The reports stay organization-wide; the Location filter only narrows. Built for desktop: on screens narrower than 1024 pixels, the table scrolls sideways.

Did this answer your question?