See who owes you and whom you owe

7 min · Beginner

Aging reports sort open invoices and bills by how overdue they are. A/R Aging tells you whom to chase, A/P Aging what to pay next, and two detail reports list each document with its due date, phone and email.

In this lesson you will

  • Read the A/R and A/P aging buckets
  • Open the open-invoice and open-bill detail
  • Use the Collections report to follow up

Before you start

A/R Aging Summary with three customers in the current, 1 to 30 and 31 to 60 day columns

A/R Aging

Step 1: Open Reports → A/R Aging

Each customer with an open balance gets one row, split into columns by days past the due date. The totals at the bottom match Accounts Receivable on the Balance Sheet for the same date.

  1. As of: age the balances on this date.
  2. Columns by days overdue: Current, 1–30, 31–60, 61–90 and over 90.
  3. Click a customer to open their statement.
  4. Write off… books a balance you won't collect to bad debt.
A/R Aging Summary with the As of date, an aging column, a customer name and the Write off button marked
Tip: Writing off is covered with the other customer tasks in the Sales track.

A/P Aging

Step 2: Open Reports → A/P Aging

The same layout for vendors: what you owe and how close each bill is to its due date. Click a vendor to see their statement. Pay from Vendors → Pay Bills.

  1. A vendor with open bills.
A/P Aging Summary with two vendors

The detail behind the totals

Step 3: A/R & A/P Detail

Reports → A/R & A/P Detail lists every open invoice (or, on the A/P tab, every open bill) with its number, date, due date, amount, open balance and days overdue.

A/R Detail listing three open invoices with their due dates and days overdue

Step 4: Collections

Reports → Collections lists only overdue invoices, oldest first within each customer, with the customer's phone and email so you can call or write. Send a statement from Reports → Customer Statement.

Collections report with two overdue invoices, the customers' phone numbers and the days overdue

Recap

  • You can read the A/R and A/P aging buckets.
  • You can list every open invoice and bill.
  • You can use Collections to follow up on overdue invoices.
Saved in this browser only. No account needed.

Questions

The A/R Aging total doesn't match the Balance Sheet.

Run both as of the same date. If they still differ, a journal entry may have been posted straight to Accounts Receivable without an invoice. Run Company → Check Data.

Can I export the aging to Excel?

Yes, with Export Excel / CSV at the top of the report.

Screenshots from AcboBooks 0.2.2 with the built-in sample company. Updated October 25, 2026. Your screens may differ slightly with another version or window size.

Get started

Learn it on your own books.

Everything in these lessons works in the free 15-day trial. Start with the sample company, then create yours.

No card. No account. Nothing to cancel.