Sales & Expense Tracker — Excel Income, Expenses & Monthly Profit Report

Simple daily records. A clear monthly profit picture.

The Sales & Expense Tracker is a downloadable Microsoft Excel workbook for keeping tidy records of the money your business receives and spends — and seeing at a glance whether each month made a profit.

What it does

• Sales log: record sales per transaction or as a daily total, with payment method and any card/online fees deducted.
• Expense log: record every payment by category, and mark whether you kept the receipt.
• Monthly profit & loss: income, fees, expenses and net profit for each month of your financial year, with a year total.
• Owner drawings kept separate: money you take for yourself is tracked but not counted as a business expense.
• Receipt reminders: expenses without a receipt are flagged and totalled.
• Dashboard: year-to-date income, expenses, profit, margin, best month and where the money goes, with charts.
• Error checks: invalid dates, dates outside your financial year, missing categories and wrong amounts are flagged in red.

Who it's for

Sole traders, self-employed professionals, small shops and online sellers who want organised records for decision-making and for their accountant. Works in any currency, with any financial-year start month.

Works well with the Business Cash Flow Manager: this tracker records what has happened; the Cash Flow Manager forecasts what will happen.

What you receive

• Format: one ZIP download containing two Microsoft Excel workbooks (.xlsx): a BLANK file ready for your data and a SAMPLE file with example data.
• Delivery: instant download. After payment, your download link appears on the order confirmation page and is sent to your email.
• Requirements: Microsoft Excel 2010 or newer. No macros needed.
• Price: US$17 one-time purchase; no subscription.
• Shipping: None — this is a digital product.

Note: a record-keeping and management tool on a cash basis. Not accounting or tax advice.