Solo Business Bookkeeping (Excel + offline app)

A ledger, a monthly P&L and your real payout per sales channel, for a one-person business. No subscription.

You make sales on more than one platform, pay for a few tools, and at tax time you rebuild the year from bank statements. Accounting software wants a monthly fee and a chart of accounts you never asked for.

Before: a shoebox of statements and a guess. After: every entry in one ledger, a P&L that builds itself month by month, and a "Show the working" button on every total.


Where this method comes from

  • Single-entry, cash-basis books. The IRS calls single-entry bookkeeping "the simplest to maintain" and "a simple and practical system" for a small business. It records the flow of income and expenses (IRS Publication 583, Starting a Business and Keeping Records). Many small businesses can use the cash method, where money counts when it moves.
  • The P&L order. Income minus cost of sales gives gross margin, and gross margin minus operating expenses gives net profit (SCORE, the SBA's mentoring partner).
  • Fees from the source. The Etsy and Stripe rates in the fee table each list the official page they came from and the date they were checked.


Type each entry once; the P&L, the chart and the after-fee payout per channel update by themselves

There are no formulas to write and no month-end sums. Click any total to see the rows and the arithmetic behind it.


Worked example (check it by hand)

The sample holds 25 entries from October to December, including an Etsy sale, a Stripe invoice and a refund.

  • October income after channel fees: 674.50.
  • December net: −341.43. The month's expenses beat its income, and the P&L shows it.
  • Year profit: 636.00. Click it to see every income row, fee and expense that adds up to it.


Setup

Unzip, open the .html file, look around the sample, clear it with one button, then add your first entry.


FAQ

  • Cash or accrual? Cash basis, single entry. Money counts when it moves, not when it's invoiced.
  • What's not included? Invoices, payroll, VAT/GST returns, depreciation and a double-entry balance sheet.
  • Refunds? Enter a refund as an income row with a negative amount. Its fee is zero.
  • Where is my data? In your own browser. The app blocks every network request. "Back up now" downloads a dated file you can restore anywhere.
  • Fees change? Every rate sits in one table. Edit one cell and every sale follows.


Disclaimer: This isn't tax or financial advice. Check your own obligations with a qualified accountant.

How this was made: built with the help of AI tools, to my design. Every formula is tested against independently calculated figures before it ships.

14-day money-back: if it isn't right for you, email support@dokimos.my within 14 days of purchase for a full refund.

Dokimos

Hi, I'm Benjamin, based in Malaysia. I build pricing, profit and bookkeeping spreadsheets for one-person businesses: makers, service providers, landlords and online sellers.

You pay once and own the files. Most products come with an Excel workbook, a Google Sheets copy and an offline app that runs in your browser. Every formula is visible, so you can check any number yourself.

This store is new, so there are no reviews yet. If something doesn't work as described, email me and I'll fix it. I reply within 1 business day (Malaysia time, GMT+8).

$19.95

What You'll Get:

  • Solo-Bookkeeping.html: the whole app in one file. Opens in Chrome, Edge, Firefox or Safari. No install, no account, no internet needed.
  • Solo-Bookkeeping.xlsx: the companion workbook (Excel; also opens in Google Sheets). It has START HERE, Ledger, P&L, Categories and Fee Table tabs, with formulas visible and input validation.
  • HOW-TO-USE.txt: plain-text instructions, including how to move your data between computers.
  • quick-start.pdf: a one-page setup guide with the link to your own copy of the Google Sheet.

All four come in one zip file (solo-bookkeeping.zip, 91 KB).

  • 1 Files
  • solo-bookkeeping.zip
    92.9 kB