Small Business Bookkeeping Spreadsheet: A Simple Guide for Online Sellers

If you sell online, run a small service business, or do freelance work on the side, bookkeeping can feel like something to worry about later. The trouble is that later usually arrives at tax time, with a shoebox of receipts and a lot of guessing. A simple routine in a spreadsheet avoids most of that stress, and it does not take long once it becomes a habit.

Please note: this article is general information about keeping organized records. It is not tax, accounting or legal advice. Rules on what you must record, how long to keep it, and what you can claim differ by country and region, so please check your local rules with a qualified accountant or your tax office.

What bookkeeping actually means for a small business

At its simplest, bookkeeping is a dated record of the money that comes in and the money that goes out, with enough detail that you, or an accountant, can understand each line later. For many small businesses and online sellers, a well kept small business bookkeeping spreadsheet in Excel or Google Sheets is a practical place to do it.

The goal is not complex accounting. It is a clear, complete record you can trust.

What to record

Sales and income

Record every sale or payment you receive. Useful columns are:

• Date
• Order or invoice number
• Customer or platform
• What was sold
• Gross amount (what the customer paid)
• Any sales tax collected, if that applies where you are
• Payment method

If you sell on a marketplace or through a payment provider, they usually offer a monthly report you can download. Use it to check your own records rather than replacing them.

Platform and payment fees

Online sellers often receive less than the sale price because fees are taken out first: listing fees, transaction fees, payment processing, advertising and shipping labels. Record these separately rather than only recording the smaller amount that reaches your bank. That way you can see what each sale really earned, and your records match the reports from the platform.

Business expenses

Log every purchase made for the business, with a category. Common categories include:

• Materials and stock
• Packaging and postage
• Software and subscriptions
• Equipment
• Advertising
• Phone and internet (the business share)
• Travel and mileage
• Professional fees

Keep the category list short and consistent. A drop-down list in the category column helps a lot, because "Postage", "postage" and "Shipping" otherwise end up as three different totals.

Receipts

For each expense, keep the receipt or invoice. A simple system works well: save a photo or PDF into one folder per month, and name each file with the date and supplier. Add a column in your spreadsheet with that file name or a reference number, so any line can be matched to its receipt in seconds.

A monthly routine that takes about an hour

Many small business owners find a weekly ten-minute check plus a monthly session is easier than one long day at the end of the year. Here is a routine you can adapt:

1. Add the month's sales. Enter them from your order list or download the platform report and copy the totals in.
2. Add the month's fees. Take them from the same report so they line up.
3. Add expenses and file receipts. Go through your business bank and card statements line by line. Each purchase gets a row and a receipt.
4. Check against the bank. Compare your totals with what actually moved through your business account. If something does not match, find out why now, while you still remember.
5. Look at the result. Income, minus fees, minus expenses, gives you a rough monthly profit. Watching it month by month shows which products or services are worth your time.

A tip that saves real headaches: if you can, use a separate bank account or card for the business. Mixing personal and business spending is one of the most common reasons records become hard to untangle.

Keeping records ready for tax time

When the year ends, your accountant or tax software will usually want totals by category, plus the ability to check individual items. Good records make that simple:

• One row per transaction, with a date, amount, category and receipt reference.
• Yearly totals by category, which a SUMIF formula or a pivot table can produce in seconds.
• Mileage logs, if you use a vehicle for work, recorded as you go rather than rebuilt from memory.
• A backup. Keep a copy of the file and the receipt folders somewhere other than your main computer.

How long you need to keep records, which expenses count, and whether you need to register for sales tax all depend on where you live and how your business is set up. An accountant can tell you what applies to you, and organized records usually make that conversation shorter.

When a spreadsheet is enough, and when it is not

A spreadsheet suits many sole traders, side businesses and small online shops: a manageable number of transactions, one person doing the books, and no payroll. If you employ staff, hold a lot of stock, or have complicated tax obligations, it is worth asking an accountant whether dedicated software or professional help makes more sense.

A ready-made option

If you would rather not build the formulas and categories yourself, the OPXVIA small business templates include bookkeeping and tracking workbooks for Excel and Google Sheets. Each one comes with a filled worked example, a blank copy, and an instruction guide. They are record keeping tools only and do not replace advice from an accountant.