Excel-Skills.com

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 AccountingAccounting - Service BasedAccounting - 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

View the Accounting - Trade Based template

Frequently Asked Questions

What is the difference between the Basic, Service Based and Trade Based accounting templates?
All three produce the same core reports: a trial balance, income statement, cash flow statement and balance sheet. The Service Based template adds tax invoices, customer statements and debtor ageing. The Trade Based template adds invoicing plus stock on hand at average cost and gross profit per product.
Which accounting template should I use if I sell both services and products?
Use the Trade Based template. It records stock and non-stock income and expenses on the same sheets: you select a stock code for stock items and leave it blank for everything else.
Do the accounting templates handle VAT or GST?
Yes. All three calculate sales tax on income and expenses using sales tax codes and percentages that you set up, so they can be used for VAT or GST in most countries.
Can I use the accounting templates for more than one financial year?
Yes. You set the first financial year once, and then change the reporting year in a single cell to move the 12-month period forward or back. All the reports update automatically.
Can I prepare annual financial statements from these templates?
Yes. Each template produces a trial balance, which you can copy into our Financial Statements templates to produce IFRS for SMEs annual financial statements with notes.