Free Income & Expense Tracker for South Africa

About This Template

A straightforward income and expense tracker designed to help South African business owners and freelancers record every rand that comes in and goes out. This template replaces the shoebox of receipts with an organised, categorised record of all business transactions. It includes columns for date, description, category, amount, VAT, and payment method, with automatic monthly and annual summaries. The ready-made categories can be renamed to match the lines on your tax return, making tax season preparation significantly easier.

Who Is This For?

Sole proprietors, freelancers, small business owners, and anyone who needs a simple system to track business income and expenses. Especially useful for people who are not yet using accounting software but need organised financial records for SARS.

Key Features

• Simple transaction entry with date, description, amount, and category
• Ready-made income and expense categories you can rename to match your tax return
• Automatic VAT tracking and separation
• Monthly summary of income, expenses, profit, and VAT
• Annual summary sheet for tax return preparation
• Payment method tracking (EFT, cash, card, cheque)

How to Use This Template

1. 1Download the template and customise the category list to match your business.
2. 2Record every business transaction as it happens: date, description, category, and amount.
3. 3Mark whether each transaction includes VAT and specify the payment method.
4. 4The monthly summary tab automatically calculates your income, expenses, and net profit per month.
5. 5At tax time, use the annual summary to complete your SARS income tax return.
6. 6Keep source documents (invoices, receipts) numbered to match your tracker entries.