Skip to content

Simple bookkeeping sheet for a small business

One ledger for sales and costs, with the balance, monthly profit and category totals worked out.

Simple bookkeeping sheet for a small business template, first page

Fill it in and preview

Simple bookkeeping sheet

A spreadsheet for the books of a small business or a sole trader. Record each sale and each cost as one row with its date, type and category. The Ledger sheet keeps a running balance. The Summary sheet shows total money in and out, profit or loss, the closing balance, a month by month table for the year and the totals for each category. Download it as Excel, OpenDocument, PDF or CSV.

Ledger

Simple bookkeeping sheet

Record every sale and every cost as one row. Choose Income or Expense and a category. The balance and the Summary sheet follow.

Business Nomad Coffee Roasters

Year 2027

Opening balance 4,200.00

Date Description Type Category Amount Balance
2027-01-04 Wholesale order, cafe Aurora Income Sales 640.00 4,840.00
2027-01-05 Green coffee, 60 kg Expense Supplies 412.50 4,427.50
2027-01-10 Shop rent for January Expense Rent 550.00 3,877.50
2027-01-14 Market stall takings Income Sales 318.40 4,195.90
2027-01-18 Roasting workshop fees Income Services 240.00 4,435.90
2027-01-22 Electricity Expense Utilities 96.80 4,339.10
2027-01-27 Delivery van fuel Expense Transport 74.20 4,264.90
2027-02-02 Wholesale order, hotel Marina Income Sales 905.00 5,169.90
2027-02-09 Social media advertising Expense Marketing 120.00 5,049.90

Summary

Summary

Total money in 2,103.40

Total money out 1,253.50

Profit or loss 849.90

Opening balance 4,200.00

Closing balance 5,049.90

Entries without a type 0

Month Money in Money out Profit or loss
2027-01-01 1,198.40 1,133.50 64.90
2027-02-01 905.00 120.00 785.00
2027-03-01 0.00 0.00 0.00
2027-04-01 0.00 0.00 0.00
2027-05-01 0.00 0.00 0.00
2027-06-01 0.00 0.00 0.00
2027-07-01 0.00 0.00 0.00
2027-08-01 0.00 0.00 0.00
2027-09-01 0.00 0.00 0.00
2027-10-01 0.00 0.00 0.00
2027-11-01 0.00 0.00 0.00
2027-12-01 0.00 0.00 0.00
Year 2,103.40 1,253.50 849.90
Category Money in Money out
Sales 1,863.40 0.00
Services 240.00 0.00
Other income 0.00 0.00
Rent 0.00 550.00
Wages 0.00 0.00
Supplies 0.00 412.50

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

A simple bookkeeping spreadsheet for a small business: record income and expenses in one ledger and see the balance, monthly profit and totals by category.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 4 details. The document fills itself in as you type.

  • Business

    For example: Nomad Coffee Roasters

  • Year

    The year the monthly table covers.

    For example: 2027

  • Opening balanceoptional

    The money in the bank and the till at the start of the year.

    For example: 4200

  • Money in and out

    One row for each sale or cost. Type: Income or Expense. Category: Sales, Services, Other income, Rent, Wages, Supplies, Utilities, Transport, Marketing, Tax and fees or Other. Enter the amount without a minus sign.

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A spreadsheet for the books of a small business or a sole trader. Record each sale and each cost as one row with its...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 4 details, starting with Business, Year, Money in and out. 1 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

This sheet records money in and out. It is not a full accounting system and does not handle tax, stock or credit sales. Check with an accountant what your local rules require you to keep.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.