Which Excel accounting template is right for your business?
All three accounting templates turn the income and expenses you record into a monthly trial balance, income statement, cash flow statement and balance sheet. All three handle sales tax (VAT or GST), multiple bank accounts and general ledger journals, and roll forward to the next financial year.
The difference is what else your business needs: invoices and customer statements, and stock. Use the quick answer and the table below to pick the right one.
Quick answer: which template should you choose?
- Basic Accounting Template: choose it if you record income and expenses but don't invoice customers from the workbook, and you don't hold stock.
- Accounting - Service Based Template: choose it if you sell services and want tax invoices, customer statements and debtor ageing in the same workbook as your accounts.
- Accounting - Trade Based Template: choose it if you buy and sell stock and need stock on hand at average cost and gross profit per product, plus invoicing.
Feature comparison
| Feature | Basic Accounting | Accounting - Service Based | Accounting - Trade Based |
|---|---|---|---|
| Monthly trial balance, income statement, cash flow statement and balance sheet | ✓Yes | ✓Yes | ✓Yes |
| Sales tax (VAT or GST) calculations | ✓Yes | ✓Yes | ✓Yes |
| Multiple bank accounts | ✓Yes | ✓Yes | ✓Yes |
| General ledger journal entries | ✓Yes | ✓Yes | ✓Yes |
| Any 12-month financial year, rolled forward from one cell | ✓Yes | ✓Yes | ✓Yes |
| Tax invoices | –No | Up to 20 lines | Up to 20 lines |
| Customer statements and debtor ageing | –No | ✓Yes | ✓Yes |
| Stock on hand at average cost | –No | –No | ✓Yes |
| Gross profit per product | –No | –No | ✓Yes |
The templates in detail
Basic Accounting Template
Basic accounting in Excel for service based businesses.
- Best for:
- Small service businesses that need simple bookkeeping with VAT and full financial statements
- Not suitable for:
- Businesses that invoice customers from the template (use Accounting - Service Based) or hold stock (use Accounting - Trade Based)
View the Basic Accounting template
Accounting - Service Based Template
Service accounting plus invoices and customer statements.
- Best for:
- Service businesses that need full bookkeeping plus invoicing, customer statements and VAT in one workbook
- Not suitable for:
- Businesses that hold stock (use Accounting - Trade Based) or invoices with more than 20 lines
View the Accounting - Service Based template
Accounting - Trade Based Template
Trade based Excel accounting for businesses with inventory.
- Best for:
- Small trade businesses that buy and sell stock and want accounting, invoicing and stock on hand in one workbook
- Not suitable for:
- Complex trading operations (designed for relatively simple trade businesses) or invoices with more than 20 lines