Customer Account Tracking Excel
A statement table that tracks the debit–credit balance per customer or supplier account across all transactions and gives due-date warnings.
Invoice Tracking Excel Template
The invoice tracking Excel template collects the invoices you issue and receive in a single list, with taxable amount, VAT, grand total, due date and payment details. When you enter the amount paid, the remaining balance and payment status update automatically; overdue, uncollected invoices turn red and show how many days late they are.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 35 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Invoice No. / Account | The document number and the other party to the invoice. |
| Invoice Date / Type | Issue date and the Sale / Purchase / Return distinction. |
| Taxable Amount, VAT %, VAT Amount | Enter the taxable amount and the rate; the VAT amount is calculated automatically. |
| Grand Total | Automatic: Taxable Amount + VAT. |
| Due Date | The date on which payment is expected. |
| Paid / Remaining | Enter the amount collected and the remaining balance drops automatically. |
| Payment Status | Automatic: PAID, PENDING or OVERDUE. |
| Days Overdue | Automatic: counts the days for invoices that are past due and not yet closed. |
How to use it
- Download the file and clear the sample rows.
- Enter every invoice you issue as Sale and every invoice you receive as Purchase.
- Enter the taxable amount and the VAT rate; the totals are calculated automatically.
- Update the "Paid" column as you collect payments.
- Once a week, look at the "overdue amount" row on the "Summary" sheet and draw up your call list.
Who is it for?
- All businesses that sell on credit terms
- Those who use e-Fatura (Turkey's e-invoice system) but track collections separately
- Freelancers and agencies
- Anyone who doesn't want to miss supplier invoice due dates
Frequently asked questions
Can this template be used to issue invoices?
No, this is a tracking list; it does not create invoices. To issue an e-Fatura or e-Arşiv (Turkey's e-archive invoice) document, you need the GİB portal (Turkey's Revenue Administration) or an e-invoice application.
I use e-Fatura — do I still need it?
e-Fatura (Turkey's e-invoice system) creates the document; tracking which invoice has been collected is a separate job. This template fills that gap — or you can use software that also manages collections.
How do I list overdue invoices?
In the filter on the Payment Status column, select "OVERDUE"; sort by remaining amount from largest to smallest and start calling.
How do I enter invoices with VAT withholding?
Track the amount you will actually collect after withholding using the "Paid/Remaining" logic; we recommend entering the taxable amount and the calculated VAT as they are and adding a withholding note in the description column. You can work out the withheld VAT and the amount to expect from the customer with the VAT withholding calculator.
Can I see my invoices by customer?
Select the customer in the filter on the Account column. For a more detailed statement, use it together with the account ledger template.
Related templates
Income and Expense Table Excel
Totals income and expenses by category; calculates VAT, the grand total and net profit/loss automatically.
Order Tracking Excel
Tracks orders by channel, status, amount and shipping tracking number; calculates delivery time in days.
Last updated: September 15, 2026
Searched terms: invoice tracking exceldue date tracking templatepayment collection tracking excelreceivables tracking