Shopify income and expenses tracker

What is inside

• Settings: your plan price, card rate and fixed fee, entered once.
• Sales: orders, product sales, discounts, refunds and shipping, straight from Shopify Analytics.
• Expenses: a dated log with a category dropdown, so nothing is forgotten at tax time.
• Profit and loss: twelve months of gross profit, margin, fees, ads and net profit. All formulas.
• Year: the totals, the margin, the profit per order and the month that actually paid you.

How to use it

1. Open it in Excel, or upload it to Google Drive and open it with Google Sheets. Everything survives the trip: formulas, dropdowns and formats.
2. Fill in the sand-coloured cells. They are the only ones meant for typing; every white cell is a formula that keeps itself correct.
3. Start with the Settings sheet. The rates there drive every fee calculation in the workbook, and they come from your own account, not from us.
4. Keep it open at the end of each week. A spreadsheet you update on the day you remember is worth more than a perfect one you fill in once a year.

Why we give it away

We build real business apps with AI tools and publish what they cost down to the cent, and these sheets came out of doing that: they are the ones we keep open ourselves. Giving them away costs us nothing and puts us in front of the people we write for. How we test explains where the numbers in them come from.