Accounts Receivable in QuickBooks Online: Invoicing, Collections, and Aging Reports Tutorial

Managing Accounts Receivable in QuickBooks Online

Knowing AR concepts is one thing—applying them correctly inside QuickBooks Online is what keeps cash flowing and records accurate. Follow this step-by-step tutorial to set up invoicing, manage collections, and run aging reports directly in QBO.

1. Create and Send Invoices

  1. Go to + New → Invoice.
  2. Select the customer (or add a new one).
  3. Add products or services from your item list.
  4. Set payment terms (e.g., Net 30).
  5. Click Save and Send to email the invoice directly.

Quick tip: Use recurring invoices for subscription or retainer customers to reduce manual work.

2. Apply Payments Accurately

  1. Go to + New → Receive Payment.
  2. Select the customer and choose the open invoice(s) being paid.
  3. Enter payment method (check, ACH, credit card) and deposit location.
  4. Click Save and Close. The invoice will be marked as paid and AR reduced.

3. Automate Collection Reminders

  • From Settings → Account and Settings → Sales, turn on Automatic Invoice Reminders.
  • Customize reminder emails (e.g., 7 days before due, on due date, 7 days after).
  • Polite automation improves collections without adding admin time.

4. Run AR Aging Reports

  1. Go to Reports → search “A/R Aging Summary.”
  2. Review balances grouped by 0–30, 31–60, 61–90, and 90+ days overdue.
  3. Follow up with slow-paying customers based on this report.

Example: If 20% of AR is 60+ days overdue, tighten credit policies or escalate collection efforts.

5. Handle Bad Debts

  1. Go to + New → Credit Memo.
  2. Enter the customer name and select a Bad Debt Expense account.
  3. Apply the memo against the unpaid invoice to clear the receivable.

QuickBooks Online AR Checklist

  • ✅ Invoices created and sent promptly
  • ✅ Payments applied to correct invoices
  • ✅ Automatic reminders enabled
  • ✅ Aging report reviewed monthly
  • ✅ Bad debts written off through credit memos
 

For detailed tutorials, visit our QuickBooks Online guides at excelinaccounting.com/category/quickbooks-tutorial.

 

Accounts Receivable: Invoicing, Collections, and Aging Reports Explained

Accounts receivable (AR) represents the money customers owe you for goods delivered or services rendered on credit. Managing AR properly ensures you get paid on time, maintain healthy cash flow, and keep accurate financial statements. This guide explains—in plain English—what AR is, how to set up an effective invoicing system, how to manage collections, and how to use aging reports to monitor outstanding balances.

What Is Accounts Receivable?

Accounts receivable is recorded as a current asset on your balance sheet because it represents cash you expect to receive within a year. When you issue an invoice, you record revenue and a receivable. When the customer pays, the receivable is cleared, and cash is increased.

Example: You provide $1,000 worth of services on credit. Entry: Debit Accounts Receivable $1,000; Credit Revenue $1,000. When paid: Debit Cash $1,000; Credit Accounts Receivable $1,000.

Why AR Management Matters

  • Cash flow: AR is only valuable if collected. Poor AR management can create liquidity problems.
  • Profitability: If receivables become uncollectible, they erode profit margins.
  • Compliance: Proper recognition of AR ensures accurate tax reporting.
  • Relationships: Clear invoicing and communication build trust with customers.

Setting Up an Effective Invoicing Process

1) Establish Credit Policies

Define who qualifies for credit, standard payment terms (e.g., net 30), and maximum outstanding balances. Document policies so staff and customers understand expectations.

2) Create Professional Invoices

Invoices should include:

  • Business name and contact info
  • Invoice number and date
  • Customer details
  • Clear description of goods/services
  • Payment terms and due date
  • Accepted payment methods

3) Send Invoices Promptly

The sooner invoices are sent, the sooner payment cycles begin. Automate reminders where possible to reduce delays.

4) Record Transactions Correctly

Each invoice increases Accounts Receivable and Revenue. Apply payments accurately to specific invoices to avoid confusion and duplicate balances.

Collections: How to Get Paid Faster

1) Monitor Due Dates

Use accounting software to track outstanding invoices and flag those nearing due dates.

2) Send Gentle Reminders

Polite reminders shortly before and after the due date often resolve issues quickly.

3) Offer Incentives

Consider small discounts for early payments. For example, “2/10, net 30” means a 2% discount if paid within 10 days.

4) Escalate When Necessary

If invoices remain unpaid, follow a structured escalation: second notice → phone call → final notice → collections agency/legal action. Keep communication professional and documented.

Accounts Receivable Aging Reports

An aging report categorizes AR by how long invoices have been outstanding—commonly in 0–30, 31–60, 61–90, and 90+ day buckets. This highlights slow-paying customers and helps estimate bad debts.

Example Aging Report:

  • 0–30 days: $25,000
  • 31–60 days: $8,000
  • 61–90 days: $3,000
  • 90+ days: $2,000

In this example, 20% of receivables are overdue beyond 30 days, signaling a need for tighter credit policies or more aggressive collections.

Credit Terms and Risk Management

Balancing sales growth with collection risk is key. If terms are too strict, you may lose customers; too lenient, and cash flow suffers. Review credit limits regularly and adjust terms for customers with late payment histories.

Bad Debt and Allowances

Not all receivables will be collected. Create an allowance for doubtful accounts to anticipate potential losses. Entry: Debit Bad Debt Expense; Credit Allowance for Doubtful Accounts. This maintains realistic financial statements.

Internal Controls for AR

  • Segregate duties: Separate invoice creation, payment collection, and reconciliation roles.
  • Number invoices sequentially to detect missing ones.
  • Review aging reports monthly to spot trends early.
  • Require approval for credit limit increases.

Examples of AR Journal Entries

Invoice issued: Debit Accounts Receivable $5,000; Credit Sales Revenue $5,000.

Payment received: Debit Cash $5,000; Credit Accounts Receivable $5,000.

Bad debt write-off: Debit Allowance for Doubtful Accounts; Credit Accounts Receivable.

Frequently Asked Questions

Should I extend credit to all customers? No. Assess creditworthiness based on history, references, and payment behavior.

How often should I run an aging report? Monthly is typical, but weekly reviews help for high-volume businesses.

What’s the difference between AR and cash sales? Cash sales record payment immediately. AR records revenue first, then payment later.

Best Practices Checklist

  • Set clear credit policies and communicate them upfront.
  • Invoice promptly and accurately.
  • Use software to automate reminders and track collections.
  • Run aging reports monthly and act on overdue balances.
  • Maintain an allowance for doubtful accounts.

Putting It All Together

Strong accounts receivable management ensures that sales turn into cash. By creating clear invoices, monitoring aging, and enforcing credit policies, you maintain steady cash flow and minimize bad debt. Small improvements in AR processes can have a major impact on liquidity and business stability.

Internal Link Suggestions (Add in WordPress)

From your homepage, add links to this article at these text snippets:
• “Managing accounts receivable …” (In-Depth Guides) → /accounts-receivable-setup-collections
Within this article, consider contextual links to: /accounts-payable-workflow (to show both sides of AR/AP), /cash-flow-management-methods (to connect AR to liquidity), /financial-statements-explained (to tie AR into balance sheet and income statement).