Know whether you made money this month. Record every sale and every expense in two simple sheets, and the summary shows profit by month, by sales channel and by expense category.

What you get:

• Sales sheet for 500 orders: date, channel, item total, shipping charged and fees. Net received is calculated for you.

• Expenses sheet for 500 payments: date, category, how you paid and whether the receipt is kept.

• Summary sheet: monthly sales, expenses, profit and margin; sales by channel; expenses by category; receipts still missing.

• Editable drop-down lists for your own channels and categories.

• Input checks that point out dates, amounts or categories that do not fit.

• Four-page quick start guide (PDF) that explains how each number is worked out.

Format: XLSX workbook, 4 worksheets, formulas only, no macros.

Works with: Excel 2016 or later, LibreOffice Calc and Google Sheets (upload the file to Google Drive).

Preview images show real sheets with fictional example data.

This is a record-keeping tool, not tax advice. Licence: use and adapt for one business. Please do not resell or share the blank template.

More free calculators and guides for craft sellers: khairzada-craft-tools.pages.dev