Cover: Simple Business Cashbook

Simple Business Cashbook: Cash, Bank & Mobile Money Tracker for Excel & Google Sheets (Any Currency)

Know where your business money is, and whether you're making a profit.

US$6.00

  • Instant digital download (ZIP)
  • Secure checkout by Paddle.com, our Merchant of Record
  • Tax, if any, is added at checkout for your country
  • 14-day refund policy

Most bookkeeping templates are built for US or UK hobby sellers: one currency, one bank account, and sometimes locked tabs you can't change. This cashbook is built for real small businesses that take cash, bank payments and mobile money. Use any currency, start your financial year in any month, and change anything. Nothing is locked.

How it works

  1. Setup: type your business name and currency, choose your financial year, list your money accounts (cash, bank, mobile money, PayPal...) with opening balances, and edit the categories.
  2. Each day or week, add one row per payment: date, amount, In / Out / Transfer, account and category.
  3. Your running balances, monthly profit, category totals, balance check and dashboard update by themselves.

What's inside the spreadsheet (XLSX)

  • Start Here tab with plain-English instructions
  • Setup: business name, any currency code and symbol, financial-year start month, up to 8 money accounts with opening balances (defaults: Cash, Bank, Mobile Money; rename them to MTN MoMo, Airtel Money, M-Pesa, PayPal or anything else), and editable income, expense and "not profit" categories
  • Transactions: 1,000 rows with drop-downs. Date, description, In / Out / Transfer, amount, account, to-account, category, fee, payment reference and notes. Each row shows the account's running balance and a Check (OK, or what's missing).
  • Transfers between your own accounts (e.g. mobile money to bank, cash deposits) are not counted as income or expenses. Transfer and withdrawal fees go in the Fee column and are counted as expenses.
  • Owner's drawings, owner's money added and loans are kept out of profit, so your profit figure is honest.
  • Monthly Summary: income, expenses, profit, owner's money and loans, drawings, net change and money at month end for each month of your financial year
  • Category Breakdown: every category by month, with totals and a check that it agrees with the Monthly Summary
  • Balances & Check: book balance for each account on any date, next to the real balance you type in, with the difference and a status
  • Dashboard: income, expenses, profit, drawings and money now, plus 4 charts
  • Undated: works for any year. Change the first year on Setup and carry your closing balances forward.

Also included

  • A sample file filled with fictional data, so you can see every tab working
  • 9 printable pages (PDF, undated): setup, cashbook, transfers and fees, month-end check, monthly summary, category totals and year-end summary, in A4 and US Letter
  • A 2-page quick-start guide

Works with: Microsoft Excel (desktop or web), Google Sheets (free, via upload, as shown in the guide) and LibreOffice Calc. There are no macros, add-ons or subscriptions, and nothing is locked. Formula cells are shaded so you know which ones to leave alone.

Good for: shops, market stalls, kiosks, salons, tailors, caterers, freelancers, online sellers and any small business that wants a clear money record. In English; works with any currency.

Please note

  • This is a digital download. Nothing will be shipped.
  • It is a record-keeping tool. It is not accounting, tax or legal advice, and it does not prepare or file tax returns or VAT. Ask a qualified accountant or your tax authority what you must record and pay.
  • It does not connect to your bank or mobile money account; you type or copy in your transactions.
  • One business per purchase. Please don't share or resell the files.
  • Screenshots show fictional sample data.

Files you get

FileFormatNotes
Folioplain-Simple-Business-Cashbook.xlsxXLSXBlank cashbook, 7 tabs, 1,000 transaction rows. Works in Excel, Google Sheets and LibreOffice. No macros. Nothing is locked.
Folioplain-Simple-Business-Cashbook-SAMPLE.xlsxXLSXSame cashbook filled with fictional sample data (an imaginary juice bar, UGX, July-June year)
printable/…-A4.pdfPDF9 landscape pages, undated
printable/…-US-Letter.pdfPDF9 landscape pages, undated
Folioplain-Business-Cashbook-Quick-Start-Guide.pdfPDF2 pages, including how to open the file in Google Sheets
Folioplain-License.pdfPDF1 page (one business)

Previews

Screenshots show fictional sample data, not real people or businesses.

Questions

Do I need Microsoft Excel?
No. It works in free Google Sheets and LibreOffice Calc too. The guide shows how to open it in Google Sheets.
Does it work with my currency?
Yes, any currency. Type its code (for example UGX, KES, NGN, GHS, ZAR, INR, USD, GBP, EUR) on the Setup tab. Amounts show with two decimals; you can type whole numbers.
Can I use several currencies at once?
It's designed for one main currency per file. If you hold money in a second currency, record it in your main currency at the rate you used, or keep a second copy of the file.
My financial year doesn't start in January.
Choose any start month on the Setup tab (for example July for a July-June year). The months and summaries follow it.
Can I track mobile money and PayPal?
Yes. Accounts are just names; rename the defaults or add up to 8. Transfers between them (and their fees) are handled separately from income and expenses.
Is it dated?
No. The spreadsheet and printables work for any year.
Does it do VAT or taxes?
No. It's a simple record of money in and out, and it isn't tax advice. Your records can help your accountant or tax return, but ask them what you need.
Does it connect to my bank or mobile money?
No. You type in each transaction (or paste from a statement). The Balances & Check tab helps you confirm your records match the real balances.
Is anything locked?
No. Formula cells are shaded light teal so you know to leave them alone. If you overwrite one, use Undo.
How many transactions does it hold?
1,000 rows. Most small businesses fit a year in that; if you need more, start a second copy for the second half-year or ask us how to extend it.
Can I use it for clients?
The standard license covers one business. Bookkeepers and accountants should contact us about a separate license.