Skip to content

Cash book

Record money in and out with a running balance, and see the closing balance of the month.

Cash book template, first page

Fill it in and preview

Cash book

A spreadsheet cash book for a shop, club or small business. Record each payment as money in or money out and the balance after every line is worked out, with the totals for the month and the closing balance. Download it as Excel, OpenDocument, PDF or CSV.

Cash book

Cash book

Write each payment in under Money in or Money out. The balance after every line is worked out.

Business Lindqvist Bakery

Month March 2027

Opening balance 500.00

Date Description Money in Money out Balance
2027-03-01 Takings, Monday 412.50 912.50
2027-03-01 Flour and yeast 138.20 774.30
2027-03-02 Takings, Tuesday 389.00 1,163.30
2027-03-03 Delivery van fuel 64.90 1,098.40
2027-03-04 Takings, Wednesday 455.75 1,554.15
2027-03-05 Packaging 52.40 1,501.75
2027-03-06 Cash paid to the bank 800.00 701.75
Total 1,257.25 1,055.50
Opening balance 500.00
Total money in 1,257.25
Total money out 1,055.50
Closing balance 701.75
Number of entries 7

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 cash book spreadsheet to record money in and out with a running balance after every line, monthly totals and the closing balance. Free, opens in Excel.

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: Lindqvist Bakery

  • Month

    For example: March 2027

  • Opening balanceoptional

    The cash you start with. Leave empty for none.

    For example: 500

  • Entries

    One row for each payment. Write the amount under Money in or Money out, not both.

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A spreadsheet cash book for a shop, club or small business. Record each payment as money in or money out and the bala...

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, Month, Entries. 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?

A cash book shows cash you record, so keep receipts and count the cash in hand often. Bookkeeping and tax record rules differ by country, so check what yours require.

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.