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 categories align with SARS income tax return requirements, 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
• SARS-aligned expense categories for easy tax return preparation
• Automatic VAT tracking and separation
• Monthly summary pivot with income, expenses, and profit
• 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.