Canonical page: https://bokeping.com/resources/tools/accounts-receivable-aging-calculator/

Markdown page: https://bokeping.com/resources/tools/accounts-receivable-aging-calculator.md

Source updated: 2026-11-16

Text version of the public page. Check the canonical page for current terms and interactive features.

Free business tool

# Accounts receivable aging calculator

List your unpaid invoices with their due dates. See how much is not yet due and how much is 1–30, 31–60, 61–90 and over 90 days late.

By [Bokeping Team](<https://bokeping.com/about/#content-team>)Updated November 16, 2026

Example

Past due

$1,570.00

75.8% of $2,070.00 owed across 4 invoices, as of Nov 16, 2026.

Current (not yet due)

$500.00 · 24.2%

1–30 days past due

$250.00 · 12.1%

31–60 days past due

$0.00 · 0%

61–90 days past due

$320.00 · 15.5%

Over 90 days past due

$1,000.00 · 48.3%

Total owed

$2,070.00

## How invoices are sorted

### Days past due

as-of date − due date

An invoice due October 20, looked at on November 16, is 27 days past due.

### The buckets

current · 1–30 · 31–60 · 61–90 · over 90

An invoice due today or later is current. Day 1 starts the day after the due date.

### Share of the total

bucket ÷ total owed × 100

Shows how much of what you are owed sits in each bucket.

## Reading the result

### The same report from your books

Bokeping builds the A/R Aging Summary from your invoices and payments, per customer, so nothing has to be typed in. If you keep the list in a spreadsheet, the free aging report template does the bucketing for you.

[Read the A/R aging guide](<https://bokeping.com/help/reports/ar-aging/>) [Get the aging report template](<https://bokeping.com/resources/learn/accounts-receivable-aging-report-template/>)

1.  1
    
    ### Enter what is still unpaid
    
    For a part-paid invoice, enter the balance left, not the original amount.
    
2.  2
    
    ### Age from the due date
    
    This calculator ages from the due date. Some reports age from the invoice date instead, which makes everything look older.
    
3.  3
    
    ### Watch the right-hand side
    
    The older the bucket, the less likely the money arrives without a call. Money over 90 days late usually needs a decision, not another reminder.
    
4.  4
    
    ### Leave out credits
    
    A customer’s unused credit or overpayment is not an unpaid invoice. Handle it separately.
    

## More free calculators and tools

-   [Sales tax calculatorAdd sales tax to a price, or take it back out of a total.](<https://bokeping.com/resources/tools/sales-tax-calculator/>)
-   [Late fee calculatorInterest or a flat fee on an overdue invoice.](<https://bokeping.com/resources/tools/late-fee-calculator/>)
-   [Invoice due date calculatorTurn Net 30 or any terms into a calendar date.](<https://bokeping.com/resources/tools/invoice-due-date-calculator/>)
-   [Profit margin calculatorMargin, markup and a selling price for your target.](<https://bokeping.com/resources/tools/profit-margin-calculator/>)
-   [Invoice generatorMake an invoice online and download a PDF.](<https://bokeping.com/invoice-generator/>)

FAQs

## Accounts receivable aging questions

### What is accounts receivable aging?

A list of what customers owe you, grouped by how long each invoice has been overdue: not yet due, 1–30 days, 31–60, 61–90 and over 90. It shows at a glance where collection effort is needed.

### How do I calculate the days past due?

Subtract the due date from the date you are looking at. An invoice due October 20 is 27 days past due on November 16. An invoice due today or in the future is current.

### How many invoices can I enter?

Up to 12. For a longer list, use the free aging report template in Excel, or run the report from your accounting software.

### What is a healthy aging report?

There is no single standard; it depends on your terms and your customers. Compare this month with last month: a growing share in the older buckets means collections are slipping.

### Are my numbers saved or sent anywhere?

No. The calculation runs in your browser. Nothing you type is sent to Bokeping or stored, and it does not change anything in a Bokeping account.

## Ready to know your money?

Free plan, no card needed. Bring your QuickBooks or spreadsheet history, invite your accountant, and start reading your own books today.

[Start for free →](<https://app.bokeping.com/auth/signup>)
