Bakery Income & Expense Tracker
Simple bookkeeping for a home bakery: log money in and money out, and see your profit by month without a complicated accounting app.
The Bakery Income & Expense Tracker is made for home and cottage bakers who want a clear, tidy record of their business. Two easy logs (income and expenses) feed a 12-month summary and a dashboard with charts, so you always know your income, spending, card fees, profit and margin.
WHAT'S INCLUDED
- Bakery Income & Expense Tracker, SAMPLE version (filled with example data so you can see how it works)
- Bakery Income & Expense Tracker, BLANK version (ready for your business)
- Easy instructions PDF (Excel + Google Sheets)
Tabs:
- DASHBOARD: income, expenses, fees, profit, margin and best month, an income vs. expenses chart, profit by month, top expense categories and income by category
- INCOME: date, customer / source, category, channel, description, amount, fees and net (automatic). Room for 1,000 entries.
- EXPENSES: date, vendor, category, description, amount, paid with and receipt saved? (missing receipts are flagged). Room for 1,000 entries.
- MONTHLY SUMMARY: 12 months of income, fees, expenses, profit and margin, plus income and expenses by category for every month
- SETTINGS: your bakery name, the first month of your 12-month view, and your own income / expense categories and payment methods
- START HERE: step-by-step instructions
Please note: this is a simple record-keeping tool for your own tracking. It is not accounting or tax advice.
Works in Google Sheets and Excel (Google Sheets is free; Excel 2016+ or Microsoft 365).
HOW DELIVERY WORKS
- Instant download: right after checkout you get a download link on screen and by email.
- You receive one ZIP file. Double-click it (Mac or Windows) to unzip the files.
- Excel: open the .xlsx file. Google Sheets: go to sheets.google.com > File > Import > Upload and choose the .xlsx (step-by-step in the instructions PDF).
- Open the SAMPLE file to see how it works, then fill in the BLANK file with your own details.
- This is a digital product. Nothing will be shipped.
GOOD TO KNOW
- A computer is recommended for setup. The Google Sheets mobile app works for quick updates.
- Sample names, numbers and prices are fictional examples.
- Not affiliated with Google or Microsoft.
- For personal or single-business use. Please don't resell or share the files.
- Because this is a digital download, we can't offer returns. If a file won't open or a formula isn't working, contact us and we'll fix it or send a replacement.
- Designed with the help of AI tools; formulas tested by OvenReadySheets.
Pairs with our Bakery Order & Deposit Tracker.