Excel-Skills.com

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?

Feature comparison

Feature Invoice & Debtors - Service BasedInvoice & Debtors - Trade BasedInvoice 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)

View the Invoice Age Analysis template

Frequently Asked Questions

What is the difference between the service based and trade based invoice templates?
They work the same way. The trade based template adds stock codes, so you can select stock items on quotations and invoices.
How many lines can a quotation or invoice have?
Each quotation and each tax invoice accommodates up to 20 lines.
Can I get an age analysis from invoices created in another system?
Yes. Copy your invoice listing into the Invoice Age Analysis template, enter a statement date and it calculates the ageing for all customers or for one customer.
Do the invoice templates calculate sales tax?
Yes. The service based and trade based invoice templates include user-defined sales tax calculations, so you can set the rates that apply to you.