← Financial Management for SMEs: Financial Literacy for SMEs

Building a Simple Excel Accounting System

Module 04 / 6 · 70 min

Build the nine-sheet bookkeeping workbook step by step: worksheets and layout, a chart of accounts with data validation, the income tracker and the expense tracker, and SUMIFS summaries.

In this module you will learn to

Plan a bookkeeping workbook of linked worksheets and set up headings, formats and protection
Apply data entry rules and data validation lists so entries stay clean
Build an income tracker that splits VAT from VAT-inclusive sales
Build an expense tracker with totals, withholding and automatic checks, and summarize both with SUMIFS

Built on

Erudite Africa training curriculum: Financial Management for SMEs, Level 1 Beginner, Financial Literacy for SMEs (October 2026)
Commercial Code Proclamation No. 1243/2021; Commercial Registration and Business Licensing Proclamation No. 980/2016 as amended by No. 1150/2019, and Regulation No. 392/2016 as amended by No. 461/2020
Income Tax Proclamation No. 979/2016 as amended by No. 1395/2025; Federal Tax Administration Proclamation No. 983/2016 as amended by No. 1434/2026
VAT Proclamation No. 1341/2024; VAT Registration Directive No. 1104/2025; Electronic Invoicing System Administration Directive No. 1142/2026; Council of Ministers Regulation No. 139/2007 on sales register machines
Financial Reporting Proclamation No. 847/2014; Private Organization Employees' Pension Proclamation No. 1268/2022
Investopia's verified Ethiopian tax and business law fact sheet (October 2026), based on the laws above and summaries by PwC, KPMG, EY, Grant Thornton, the IFRS Foundation and Ethiopian law firms

Examples and companies are fictional. Tax rates and rules are shown as they stood when the course was written; always check the current proclamations, directives and guidance from the Ministry of Revenues before filing, and take professional advice for your own case.