Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingAccounts Receivable Aging Report

SpreadsheetAccounting & BookkeepingFree

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

Shown with sample data

Colour

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

Total outstanding
$47,805
Overdue
$31,455
Over 60 days
$12,680
At risk of not being collected
High priority
3
Balance by age
  • Current$16,350
  • 1-30$16,625
  • 31-60$2,150
  • 61-90$10,700
  • 90+$1,980
Balance by customer
  • Cedar Health$12,600
  • Granite Partners$9,450
  • Acme Logistics$8,400
  • Evergreen Schools$6,900
  • Harbor Hotels$2,300
  • Delta Foods$2,275
  • Brightline Media$2,150
  • Fjord Design$1,980

How to use it

  1. 1Enter each unpaid or part-paid invoice with customer, invoice date, due date and amount.
  2. 2Record part payments in Paid; Balance updates.
  3. 3Work the list in Priority order and record the next action and date after every contact.
  4. 4Remove an invoice, or set Paid equal to Amount, once it is paid in full.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

List each open invoice with its amount, any part payment and its due date. The report works out the balance, days overdue and aging bucket every day, spreads balances into the standard aging columns your accountant and lender expect, ranks collection priority and records the next action, so you always know who to call first and how much cash is at risk.

Who it’s for

  • Weekly collections calls
  • Month-end reporting to a partner or lender
  • Estimating bad-debt risk

What’s included

  • Invoices sheet: Every open invoice with balance, age, priority and next step.
  • Aging summary sheet: Outstanding balance in each aging bucket.

How to use it

  1. 1Enter each unpaid or part-paid invoice with customer, invoice date, due date and amount.
  2. 2Record part payments in Paid; Balance updates.
  3. 3Work the list in Priority order and record the next action and date after every contact.
  4. 4Remove an invoice, or set Paid equal to Amount, once it is paid in full.

Tips

  • Call before an invoice is 30 days overdue; collection odds fall sharply after 90 days.
  • Agree a payment plan in writing for large balances.
  • Put persistent late payers on stricter terms or upfront payment.

Questions

How are buckets worked out?

From the due date: Current means not yet due; 1-30 means up to 30 days past due, and so on.

What does Priority mean?

A score based on how overdue and how large the balance is. High means call today.

Related searchesaccounts receivable agingar aging reportcollectionsoverdue invoicescredit controldays sales outstanding

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounting & BookkeepingFree

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More accounting & bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Invoice Tracker2 sheets

Outstanding

$9,940

Overdue

$8,690

Average days to pay

15

ABCD
1InvoiceClientSentDue
21001Harbor LogisticsSep 15Sep 29
31002Northwind StudioSep 22Oct 6
41003BluepeakSep 30Oct 14
51004Juniper & CoOct 8Oct 22
Invoices
SpreadsheetBilling & Receivables

Invoice Tracker

Every invoice you have sent with due dates, payments received, days late and who to chase.

10 min setupPreview
Petty Cash Log3 sheets

Book balance

$112

Spent this period

$188

Top-up needed

$188

ABCD
1DateReceipt #DescriptionType
2Nov 1PC-000Opening floatTop-up
3Nov 3PC-101Printer paper and pensExpense
4Nov 4PC-102Courier to clientExpense
5Nov 7PC-103Milk and coffeeExpense
Cash book
SpreadsheetAccounting & Bookkeeping

Petty Cash Log

An audit-ready petty cash book with running balance, cash count, shortages and the top-up needed.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ