ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Accounts receivable aging
Excel template · Receivables

Accounts receivable aging template

Enter each invoice on one row: the template calculates the outstanding balance and days overdue and splits the debt into aging buckets. The summary shows which customer is late and by how much.

Updated:
Valtera_AR_aging_EN.xlsx · 36 KB · Sheets: Guide, Invoices, Summary
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_AR_aging_EN.xlsx — Invoices · Preview with sample data
Report date13.10.2026
CustomerInvoice no.Invoice datePayment terms, daysDue dateAmountPaidOutstanding
Kaspi Market LLCF-2026-10110.07.20263009.08.202612,00012,000-
Ganja Construction LLCF-2026-10422.07.20263021.08.202618,5006,00012,500
Nargiz PharmacyF-2026-10905.08.20261520.08.20264,200-4,200
Kaspi Market LLCF-2026-11218.08.20263017.09.20269,800-9,800
Shirvan LogisticsF-2026-11528.08.20264512.10.202615,6005,00010,600
Baku Office FurnitureF-2026-11803.09.20263003.10.20267,300-7,300
Khazar RestaurantsF-2026-12110.09.20261424.09.20263,900-3,900
Ganja Construction LLCF-2026-12415.09.20263015.10.202622,000-22,000
Nargiz PharmacyF-2026-12722.09.20261507.10.20263,600-3,600
Shirvan LogisticsF-2026-13030.09.20264514.11.202611,800-11,800
Kaspi Market LLCF-2026-13302.10.20263001.11.202614,200-14,200
Baku Office FurnitureF-2026-13606.10.20263005.11.20265,600-5,600
Khazar RestaurantsF-2026-13909.10.20261423.10.20264,100-4,100
Ganja Construction LLCF-2026-10202.06.20263002.07.20268,7002,7006,000

What the template includes

  • Invoices: customer, number, date, payment terms, amount, amount paid. Due date, outstanding balance and days overdue calculate automatically. 200 rows.
  • Aging buckets: not yet due, 1–30, 31–60, 61–90, 90+ days.
  • Summary: balance by customer, buckets, overdue share and a chart.

How to use it

  1. Enter the report date (usually today).
  2. Copy in open invoices and enter payments in the "Paid" column.
  3. Every week, check debts more than 30 days overdue and contact the customer.
  4. For debts more than 90 days overdue, consider stopping new sales and taking legal steps.

To see how debts affect cash flow: DSO calculator and cash gap calculator.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.