Accounts Receivable Register
Track what each customer owes, receipts applied to each invoice, running balances and ageing. Excel workbook.
Download this template
Choose the file you need, then download it. No sign-up, no payment.
Preview this template
This is the actual first page of the file. Click the preview to see it larger, then download it below. The Sample card shows a completed example, filled in with sample details.
Accounts Receivable Register
Sample
What’s Included in This Resource
Every resource on The Office File provides a complete toolkit rather than an empty, unhelpful document shell:
- Editable Microsoft Excel (.xlsx) workbook with built-in formulas
Sample included: Example: Accounts Receivable Register in use. Track what each customer owes, receipts applied to each invoice, running balances and ageing. Excel workbook.
How to Use This Template
Follow these practical steps to customize and roll out this procedure with your team:
1. Download the file
Get the editable Excel workbook.
2. Replace the example rows
Overwrite the white input cells with your own invoices, and record receipts on the Receipts sheet against their invoice numbers.
3. Review the ageing
Check the Customer Summary and Summary sheets for running balances and overdue amounts to chase.
4. Save and share
Save your finished workbook, print it, or share it with your team or adviser.