Canonical page: https://bokeping.com/resources/learn/accounts-receivable-aging-report-template/

Markdown page: https://bokeping.com/resources/learn/accounts-receivable-aging-report-template.md

Source updated: 2026-11-09

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

# Free Accounts Receivable Aging Report Template for Excel

Age open invoices by due date in Excel. Switch from September 30 to October 1 to see a $400 payment reduce a $1,000 invoice to $600.

[Download the Excel template](<https://bokeping.com/downloads/ar-aging/bokeping-accounts-receivable-aging-template.xlsx>)[Compare the two cutoff dates](<https://bokeping.com/resources/learn/accounts-receivable-aging-report-template/#cutoff-example>)

.xlsx · No signup required · Includes a worked example

The Aging sheet as it opens in Excel. Change the yellow date cell to update the report.

## Accounts receivable aging workbook

Enter posted USD invoices and their applied payments. Choose a cutoff date to calculate open balances in five aging buckets.

1.  On **Invoices**, enter a unique invoice ID, customer, invoice date, due date and original amount. Include invoices paid after the cutoff so you can reconstruct an earlier balance.
2.  On **Payments**, enter each amount applied to an invoice with its invoice ID and payment date. Multiple payments against one invoice get separate rows. For a split receipt, enter each invoice’s share.
3.  On **Aging**, change **As of date (B4)**. Leave **Customer (B5)** blank for everyone or enter one customer name. An invoice enters the report on its invoice date. Its due date determines the aging bucket. Check **Rows to review** if the totals are blank.

The template holds 100 invoices and 200 allocations for one company in USD. Replace the example rows before using your own figures. Keep unapplied cash, credit notes, refunds, write-offs and currency conversions separate.

[Download the Excel template](<https://bokeping.com/downloads/ar-aging/bokeping-accounts-receivable-aging-template.xlsx>)

## One invoice, two cutoff dates

Northline Studio Demo issued a $1,000 invoice to Alder Design Co. on September 1, due September 30. The customer paid $400 on October 1. Compare the two dates in the workbook and in the actual Bokeping reports from this demo company.

USD balances for invoice AR-1001 after payments through each cutoff

| As of | Paid by cutoff | Open | Aging bucket |
| --- | --- | --- | --- |
| September 30 | $0 | $1,000 | Current / Not Due |
| October 1 | $400 | $600 | 1–30 days |

September 30, 2026. Invoice AR-1001 is due today. Alder Design Co. has $1,000 open, all current.[View full size ↗](<https://bokeping.com/_astro/ar-aging-2026-09-30.CR184nH5.webp>)

October 1, 2026. The $400 payment is applied. The remaining $600 is one day overdue.[View full size ↗](<https://bokeping.com/_astro/ar-aging-2026-10-01.B8B7_30_.webp>)

## Run the same report for your customers

In Bokeping, open **Reports → A/R Aging Summary**. Set **As Date** to the workbook cutoff. Select the same customers and use four 30-day overdue periods. Invoices due on the cutoff are current. The overdue periods start at 1, 31, 61 and 91 days.

Compare the open invoice rows first. An unapplied customer payment can appear separately in the system report. For credits or a difference from the Balance Sheet, see the [A/R Aging Summary guide](<https://bokeping.com/help/reports/ar-aging/>).

To run your own report, create a company, record your invoices and apply any payments. You need access to that company and permission to view the report.

[Create my aging report in Bokeping](<https://app.bokeping.com/auth/signup?entry=ar_aging_template>)

Updated November 9, 2026

FAQs

## Accounts receivable aging template questions

### Can I download the Excel template without an account?

Yes. The .xlsx file is free to download without signing up. It opens with a fictional invoice and one partial payment. Replace the example rows with your own records.

### How does a partial payment affect an earlier aging report?

Only payments applied to the invoice and dated on or before the cutoff reduce its balance. The $400 receipt dated October 1 leaves the full $1,000 open on September 30. At the October 1 cutoff, $600 is open.

### Is an invoice overdue on its due date?

An invoice due on the cutoff date is current. The next calendar day is day one overdue. The workbook groups positive open balances into Current / Not Due, 1–30, 31–60, 61–90 and 91+ days.

### What belongs in the workbook?

Use one company and USD. Enter up to 100 posted invoices with unique invoice IDs and up to 200 payment allocations. Split a receipt across invoices when appropriate. Unapplied cash, credit notes, refunds, write-offs and foreign-currency adjustments are outside this worksheet.

### How do I compare the worksheet with Bokeping?

In your company, open Reports → A/R Aging Summary. Set As Date to the worksheet cutoff, use 30-day intervals and four overdue buckets, and select the same customers. Compare the invoice balances. Unapplied payments and other adjustments can affect the full system report.
