Income & Expense Tracker – South African Edition
Track business income, expenses and cash flow in one practical Excel workbook
What’s Included
- Income & Expense Tracker Workbook
- Income & Expense Tracker User Guide
- Income & Expense Tracker Employer Handbook
- Income & Expense Tracker One-Page Overview
Key Features
- ✓ income log with customer category and payment details
- ✓ expense log with supplier category and vat columns
- ✓ monthly budgets and spending by expense category
- ✓ monthly income expense and net profit summary
- ✓ year-to-date cash-flow dashboard and trends
- ✓ vat toggle controls vat fields across the workbook
What This Solves
- ✓ scattered income and expense records
- ✓ poor visibility of monthly cash flow
- ✓ difficulty seeing where business money is going
Who It’s For
- – South African small businesses
- – freelancers and sole proprietors
- – owners tracking business cash flow
How It Helps You
- ✓ keeps day-to-day business money records in one place
- ✓ makes monthly income and spending easier to review
- ✓ supports better cash-flow decisions
Why You Need It
- ✓ regular records make business trends easier to spot
- ✓ budget checks can reveal spending pressure sooner
- ✓ month-end review is simpler when entries stay consistent
Frequently Asked Questions
Do I need VAT registration to use this workbook?
No. If you are not VAT registered, set the Dashboard toggle to No; VAT columns then calculate zero. If you are registered, use Yes and verify the applicable rate and treatment with current SARS guidance or your tax practitioner. The workbook is a recordkeeping aid, not a VAT filing service.
Does the workbook submit a VAT return for me?
No. It calculates and summarises entries you record, but does not connect to SARS eFiling or submit returns. Reconcile its totals to valid source documents and confirm filing obligations and tax treatment with SARS or a qualified tax professional.
Can I change expense categories and budgets?
Yes. Use Categories & Budgets to update expense categories, keyword suggestions and monthly budget amounts. Choose names that fit your business and enter the same category consistently in Expense Log so summary totals and budget progress remain useful.
How many transactions can I record in the workbook?
The prepared Income Log and Expense Log each have 200 transaction rows. Keep regular backups and retain an archive before extending the workbook, because inserted rows may not be included in existing formulas. Reconcile your entries to your source records.
Related Products
View All →
From the Blog
View All →
The Ultimate Guide to Purchase Order Funding in South Africa (2026)
How to Apply for Spaza Shop Funding in South Africa (2026 Guide)
5 Common Import & Export Mistakes South African Businesses Make (and How to Avoid Them)
