Skip to content
Tutorials Center
My learning

Topics

Lesson 27 of 36 ยท Reports and Taxes

Aging Reports and Cash Flow

Use QuickBooks Accounts Receivable and Payable aging reports to chase late payers and plan bills, and understand the cash flow report with runnable aging and cash forecast stand-ins.

A business can be profitable and still run out of cash, because customers pay late while bills and payroll come due on time. Three reports help you manage this: A/R aging (who owes you), A/P aging (whom you owe) and the Statement of cash flows.

QuickBooks cannot run on this site. Menu paths are QuickBooks Online (Reports). The TryIts are JavaScript stand-ins with invented data that imitate the bucketing and forecasting logic.

Accounts Receivable aging

Run Reports > Accounts receivable aging summary (or detail). It groups unpaid invoices by how overdue they are, normally in buckets:

Bucket Meaning
Current Not yet due
1 - 30 1 to 30 days past due
31 - 60 31 to 60 days past due
61 - 90 61 to 90 days past due
91 and over Seriously overdue

The summary shows one row per customer. The detail lists each invoice with its due date, so you can contact the right person about the right document. Click a customer to open the invoice, send a reminder or record a payment.

Use it weekly: call the 31-60 group, escalate the 91-plus group, and consider stopping credit for repeat late payers. QuickBooks can also send automatic invoice reminders (Sales settings) before and after the due date.

The aging total must equal the Accounts Receivable balance on the balance sheet at the same date. If it does not, an invoice-related entry was posted directly to A/R with a journal entry (which can leave "unapplied" amounts). Unapplied customer payments or credits show as negative amounts; apply them to invoices.

Accounts Payable aging

Reports > Accounts payable aging summary works the same way for bills you owe. Use it to decide which bills to pay this week, to take early-payment discounts (for example "2/10 net 30" gives 2% off if paid within 10 days) and to avoid late fees. Pair it with the bill-payment workflow in the earlier vendor lessons of this course.

The total must match Accounts Payable on the balance sheet, so a mismatch is a bookkeeping error to chase.

Writing off bad debt

If a customer will never pay, do not just delete the invoice. Record a credit memo against a Bad debts expense account (or create the write-off entry your accountant recommends) so the receivable disappears but the loss is visible on the P&L. Accrual-basis books must do this; cash-basis books never recorded the income, so there is nothing to write off.

JS Bucket invoices into an aging report

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The statement of cash flows

Profit measures performance; cash flow measures money moving. Reports > Statement of cash flows reconciles net income to the change in cash in three parts:

  • Operating activities: cash from running the business. QuickBooks starts from net income and adjusts for non-cash items and changes in receivables, payables, inventory and so on. Rising receivables or inventory use cash even when profit is high.
  • Investing activities: buying or selling equipment and other long-term assets.
  • Financing activities: loans, owner contributions, draws.

The sum equals the change in your cash accounts for the period. Reading it tells you why cash moved. Example: net income 10,000, but receivables grew 8,000 and inventory grew 6,000, so operating cash flow is negative 4,000 even though the P&L shows a healthy profit.

A simple cash forecast

A forecast looks a few weeks ahead using expected receipts (A/R by due date) and payments (A/P by due date, payroll, rent).

JS Four-week cash forecast

Press Run (or Ctrl + Enter) to see the console output here.

No output.

If the forecast shows a dip, you have time to chase overdue invoices, negotiate payment terms or arrange a line of credit before payroll day.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What does the A/R aging report show?

    A/R aging groups open customer invoices into current and past-due buckets.
  2. 2. The A/R aging total should equal...

    Aging is a detailed breakdown of the A/R account, so the totals must agree on the same date.
  3. 3. A profitable company has negative operating cash flow. A likely reason is...

    Sales not yet collected and stock not yet sold tie up cash even though profit is recorded.
  4. 4. How should an uncollectible invoice be handled?

    Deleting hides the loss. A write-off removes the receivable and records the expense visibly.

Summary

  • A/R aging shows who is late; A/P aging shows what to pay and when.
  • Aging totals must agree with the balance sheet accounts.
  • The cash flow statement explains why cash differs from profit.
  • A short cash forecast reveals shortfalls early enough to act.

Next: Sales Tax in QuickBooks