Which Excel invoice and debtors template do you need?
Our invoice templates create quotations, tax invoices and customer statements with ageing, and track what each customer owes. If you already invoice from another system and only need to know who owes what, the age analysis template works from your existing invoice list.
Quick answer: which template should you choose?
- Invoice & Debtors - Service Based Template: choose it if you sell services and want quotations, tax invoices, customer statements and debtor ageing.
- Invoice & Debtors - Trade Based Template: choose it if you sell stock items and want stock codes on your quotations and invoices.
- Invoice Age Analysis Template: choose it if you already invoice elsewhere and only need an age analysis from your invoice list.
Feature comparison
| Feature | Invoice & Debtors - Service Based | Invoice & Debtors - Trade Based | Invoice Age Analysis |
|---|---|---|---|
| Quotations | Up to 20 lines | Up to 20 lines | –No |
| Tax invoices | Up to 20 lines | Up to 20 lines | –No |
| Stock codes on quotations and invoices | –No | ✓Yes | –No |
| Customer statements with ageing | ✓Yes | ✓Yes | –No |
| Age analysis for one or all customers | ✓Yes | ✓Yes | ✓Yes |
| Works from an existing invoice list | –No | –No | ✓Yes |
| Monthly sales, receipts and debtor balance charts | ✓Yes | ✓Yes | –No |
The templates in detail
Invoice & Debtors - Service Based Template
Automated service based invoices and customer statements.
- Best for:
- Service businesses that need quotes, tax invoices, customer statements and debtor ageing without full accounting
- Not suitable for:
- Invoices or quotes with more than 20 lines, selling stock items (use Invoice & Debtors - Trade Based) or full bookkeeping (use Accounting - Service Based)
View the Invoice & Debtors - Service Based template
Invoice & Debtors - Trade Based Template
Automated trade based invoices and customer statements.
- Best for:
- Trade businesses that invoice stock items and need quotes, statements and debtor ageing
- Not suitable for:
- Invoices or quotes with more than 20 lines, or full bookkeeping with stock (use Accounting - Trade Based)
View the Invoice & Debtors - Trade Based template
Invoice Age Analysis Template
Automated age analysis calculations for any invoice list.
- Best for:
- Businesses that already produce invoices elsewhere and need a quick debtors age analysis
- Not suitable for:
- Creating invoices or customer statements (use Invoice & Debtors - Service Based or Trade Based)