Kolumn

15 / 20 · Sales and invoicing

Accounts receivable tracker

Unpaid customer invoices and an ageing report.

SEK 99

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Who owes you money, how much and for how long? The template calculates the amount outstanding, days past due and splits debts into ageing buckets (not due, 1–30, 31–60, 61–90, over 90 days).

What you get

Sheets
Invoices, Ageing
Each file also has an instructions sheet and a lists sheet.
Formulas
957
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Add every customer invoice with amount incl. tax and due date.
  2. Enter the amount paid when money arrives (part payments work).
  3. Note the reminder date. The Ageing sheet shows totals per bucket and per client.