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 |
