Rounding Robin

Home › Templates › Accounts Receivable Aging Template

Accounts Receivable Aging Template

An aging report for up to 300 open invoices and 50 customers. It ages each invoice by days past due, totals by customer, and calculates the allowance for doubtful accounts from rates you set.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsCompany details, dates and the source data. All entry cells are shaded.
ScheduleOpen invoices with due date, open balance, days past due and aging buckets, followed by a summary by customer with credit limit checks.
Journal EntryThe entry produced from the schedule, with a check that debits equal credits.
ReconciliationSchedule balances compared with the general ledger, with differences flagged.
ListsAccount mappings and dropdown values, editable to match your chart of accounts.

Features

Instructions

  1. On the Lists tab, enter customers, payment terms and credit limits.
  2. On the Inputs tab, set the aging date, loss rates and general ledger balances.
  3. On the Schedule tab, enter open invoices and payments received.
  4. Review the Journal Entry tab for the allowance adjustment.
  5. Explain any difference on the Reconciliation tab.

Notes

Invoices are aged from their due date. Loss rates should be based on your own collection history.

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.