The workbook has four tabs. A Start Here guide walks you through it in three steps. A Settings tab holds your business name, starting balance and your own list of categories — which feed the dropdowns so you never mistype 'transport' three different ways. The Transactions tab is where you record every sale and expense, with a running balance that turns red if you ever go below zero. The Dashboard shows total sales, expenses, net profit and cash on hand, a month-by-month table and a chart — all live.
Everything is a formula, so nothing has to be added up by hand. The cells you type into are yellow; the rest are locked so you can't accidentally delete the maths. It opens in Excel or in Google Sheets — upload it to Google Drive and you can keep your books free from your phone.
When typing it in every day gets tiring, the same records can be kept for you automatically: Biashara Yangu records sales by voice, photo or text and reads any M-Pesa statement, then keeps this exact dashboard for you.