What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Accounts Receivable in QuickBooks
QuickBooks Online

Accounts Receivable in QuickBooks: What the Number Means and Where It Comes From

Accounts receivable (A/R) is what customers owe you for invoices you've sent and haven't been paid for. QuickBooks keeps it for you: each invoice adds to it, each payment you receive against an invoice takes it down. You never type into it directly. You only need to know where to read it and what moves it.

Where to see accounts receivable

Who owes what, by age: run Accounts receivable aging summary. It splits each customer's balance into current, 1-30, 31-60, 61-90 and 91 days and over.

Reports Search "A/R aging summary"

The invoices behind it: run Accounts receivable aging detail to see each open invoice in each bucket.

Reports Search "A/R aging detail"

The total: the Accounts Receivable line on your Balance Sheet, or the account in your chart of accounts.

One customer: your Customers list shows each customer's open balance without running a report.

How one customer's balance is built

Every number in A/R comes from a transaction like these. When a balance looks wrong, one of these lines is missing or attached to the wrong invoice.

Example customer, one quarter
Invoice 1041, January work (adds to A/R) $2,400.00
Invoice 1052, February work + $1,850.00
Payment received, applied to 1041 (reduces A/R) − $2,400.00
Credit memo for a returned part (only clears once applied to an invoice) − $300.00
Still owed by this customer $1,550.00

If that payment had been recorded as a plain deposit instead of a payment against invoice 1041, the customer would still show $3,950 owed, and your income would be counted twice.

Reading the aging report without missing anything

  1. 1

    Run the summary as of today

    Reports Accounts receivable aging summary

    Look at the right-hand columns first. Anything in 61-90 or 91 and over is past a polite nudge.

  2. 2

    Click a customer's total

    QuickBooks drills into the invoices behind it. Check each one is real: an old invoice that was paid in cash and never recorded looks exactly like a debt.

  3. 3

    Compare the total to the balance sheet

    The aging report's grand total should equal the Accounts Receivable line on the balance sheet on the same date and basis. If they don't match, something was posted straight to A/R with a journal entry.

    Watch for: the cash vs accrual setting. On a cash basis report, A/R is usually zero, because nothing counts until it's paid.

  4. 4

    Decide what happens to each old invoice

    Chase it, send a statement, or write it off. Leaving it in the 91+ column overstates what you have coming in.

When the A/R number doesn't make sense

A customer shows a negative balance

How you'll know: A minus figure on the aging report or the customer list.

Fix: The customer paid more than they owe, or a payment or credit memo isn't applied to an invoice. Open the customer, find the unapplied payment or credit, and apply it to the right invoice, or refund the overpayment.

Invoices show open after the customer paid

How you'll know: The money is in the bank, but the invoice is still open and the deposit was categorized as income.

Fix: Undo the bank feed entry and match it to the payment instead, or record the payment with Receive payment first. See applying a payment to an invoice.

Payments stuck in Undeposited Funds

How you'll know: A/R looks right, but the bank account is short by a batch of payments.

Fix: The payments were received but never put on a deposit. Group them into a deposit that matches the bank line. Undeposited Funds explains how.

Journal entries posted straight to A/R

How you'll know: The aging report and the balance sheet disagree.

Fix: Find the journal entry hitting Accounts Receivable and tie it to a customer, or reverse it and use an invoice or credit memo instead.

What QuickBooks chases, and what it leaves to you

Built in

QuickBooks already does this

  • Automatic invoice reminders, up to three, before or after the due date (Settings, Account and settings, Sales, Reminders).
  • Reminders only go on invoices you emailed from QuickBooks.
  • Aging reports you can run or schedule.
Usually missing

What happens after a reminder is ignored

  • Someone on your side is told when an invoice passes the point you care about, not just the customer.
  • Your sales team sees the overdue balance in the CRM before they quote that customer again.
  • Card and bank payments from other systems land against the right invoice, so the aging report is true.

Turn on the built-in reminders first. If invoices still drift to 60 days, the gap is the follow-up by a person, which is the part n-frames builds.

Questions people ask

Why is my accounts receivable negative in QuickBooks?

A customer paid more than they owed, or a payment or credit memo was recorded but not applied to an invoice. Run the aging detail report, find the customer with the negative line, and apply or refund the payment or credit behind it.

Do I need to set up accounts receivable in QuickBooks myself?

No. QuickBooks creates the Accounts Receivable account for you once you start invoicing, and you never add money to it by hand. It moves only when you create an invoice or record a payment or credit against one.

How do I write off an uncollectible accounts receivable balance?

Set up a Bad Debt expense account and an item linked to it, then create a credit memo for the unpaid amount using that item and apply it to the invoice. The invoice closes and the loss is recorded as an expense, instead of deleting the invoice and losing the history. More in writing off bad debt.

What type of account is accounts receivable in QuickBooks?

An asset account of the Accounts Receivable type. It's money you're owed, so it sits with your assets on the balance sheet. On an accrual basis the income is counted when you invoice, not when the A/R is paid.

Does QuickBooks send reminders for overdue invoices?

Yes. Turn on automatic invoice reminders under Settings, Account and settings, Sales. You can schedule up to three, before or after the due date, for invoices you sent by email from QuickBooks.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.