Statement of Account Template Excel with Accounts Receivable Aging Report

Statement of Account & AR Aging Report keeps your sales ledger, customer statements and aging report in one Excel workbook. Record invoices, debit notes, payments, credit notes and write-offs on the Transactions tab, with the invoice number a payment or credit applies to. Every balance, statement and report follows from that single log, so the numbers always agree.

The Statement tab produces a customer statement of account in a familiar format: your company and bank details, the customer's address and terms, the balance brought forward from any start date, every invoice, payment and credit with a running balance, the balance due, the amounts current and overdue by age, a payment message and a remittance slip. Pick another customer and it rebuilds, ready to print or save as PDF.

The Accounts Receivable Aging Report splits each customer's open items into current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due, or by days since invoice if you prefer. Bucket limits are yours to set and the report can be run as at any date. Payments and credits that are not tied to an invoice are shown as unapplied credits, and each customer gets a credit limit check and a status from up to date to seriously overdue or over limit. A check confirms the aging total agrees with the ledger.

The Collections tab ranks customers by a priority score that weights older overdue debt more heavily, with contact details, the oldest overdue item, the last payment date and a suggested next step from a reminder email to a final notice. The Customers tab tracks balance, overdue amount, credit used, average days to pay and invoiced sales over the last 12 months. The Dashboard shows total receivables, overdue amount, DSO (days sales outstanding), an aging chart, invoiced against collected by month, the largest balances, who to chase first and data checks.

Capacity covers 100 customers and 3,000 transactions. Calculated cells are locked and sheet protection has no password. Sample data from a fictional print business is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.