Income and Expense Ledger Spreadsheet, Simple Small Business Bookkeeping Template with Monthly Summary, Excel and Google Sheets
Price:$7.21
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
A simple money-in, money-out ledger that totals itself by month, by category and by reference.
WHAT IT IS
A clean cash ledger for small handmade businesses. Log each receipt and payment once. The Summary tab shows totals for each month of the year you choose, for each category, and for each reference (an order, invoice, market or supplier). It also shows the overall cash surplus (money in minus money out).
WHO IT'S FOR
• Handmade and small online sellers who want a tidy record of cash in and out
• Market stall and craft fair sellers tracking takings and fees
• Anyone who has outgrown a notebook but doesn't need accounting software
WHAT'S INCLUDED (4 tabs)
• Instructions: short step-by-step guide
• Transactions: date, reference, category, money in, money out (up to 500 rows)
• Categories: your own list of up to 30 categories, which feeds the Category dropdown
• Summary: 12 monthly totals for the year you choose, category totals, totals for up to 500 references and an all-dates total
A full year of sample data (January to December 2026) is filled in: 144 transactions across 8 categories, including refunds, market fees and two months that spent more than they took in. Look around, then replace it with your own.
HOW IT WORKS
1. Type only in the blue cells. Gray cells calculate for you.
2. Set up your categories (e.g. product sales, materials, packaging, shipping, fees, refunds).
3. Enter each transaction with a positive amount in either Money in or Money out.
4. Reuse the same reference on related rows (e.g. a sale, its shipping and any refund) to see the net per reference.
5. Type a year on the Summary tab to see that year month by month.
Use one currency throughout.
IMPORTANT
This is a cash record, not tax or accounting advice. It records money in and money out. It doesn't calculate tax and isn't a replacement for an accountant.
COMPATIBILITY
• Microsoft Excel (.xlsx file)
• Google Sheets: upload the file to Google Drive, choose Open with > Google Sheets, then File > Save as Google Sheets
• Standard formulas only: no macros, no add-ins, no sign-up
INSTANT DIGITAL DOWNLOAD
This is a digital file. No physical item will be shipped. You can download it as soon as your purchase is complete.
Please note: this template was created with the help of AI tools and reviewed before release.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Maker Spreadsheet Bundle, 7 Workbooks: Inventory, Candle, Jewelry and Bakery Trackers, Bookkeeping and Repricing, Excel and Google Sheets
$15.40
-
Digital download
Catalogue Repricing Spreadsheet, Bulk Product Pricing and Profit Margin Calculator for Handmade Sellers, Excel and Google Sheets Template
$4.86
-
Digital download
Home Bakery Inventory and Batch Cost Tracker, Ingredient Cost Per Bake and Recipe Costing Spreadsheet, Excel and Google Sheets Template
$7.21
-
Digital download
Jewellery Inventory and Materials Cost Tracker, Jewelry Spreadsheet for Bead, Wire and Findings Cost Per Piece, Excel and Google Sheets
$7.21