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 |
