Spreadsheet guide · Small business reporting
How to track small business sales and expenses in a spreadsheet
A report is only as clear as the information behind it. A consistent Excel workbook makes it easier to review sales, direct costs, operating expenses, and what remains after overhead.
The short version
Keep sales and operating expenses in separate tables, use one transaction per row, keep column names and data types consistent, and review the same measures each month. Separate direct costs tied to sales from general operating overhead so the totals do not count the same cost twice.
Know which numbers you want to review
Revenue is the amount recorded from sales. Direct costs are costs associated with delivering those sales. Operating expenses are the business overhead you record separately, such as software, supplies, or rent. A simple operating-profit view subtracts direct costs and operating expenses from revenue.
Keep your accounting and tax records as the authoritative source for your business. A management dashboard can help you review activity, but it does not replace accounting advice or tax reporting.
Make the Excel source easy to refresh
- Put sales rows in the Sales table and overhead rows in the Expenses table. Use one row for each sale or expense entry.
- Keep the sample workbook’s table names and column headers if you are using a template that expects them. Avoid merged cells, blank header rows, and subtotal rows inside the data.
- Store dates as dates and amounts as numbers. Use a consistent spelling for categories, services, and sales channels so the same item does not split into multiple labels.
- Add new rows to the tables instead of creating a new layout for every month. Then refresh the report from the same workbook.
Review the business in a repeatable monthly routine
Compare revenue by month and service, review direct costs and gross profit, then look at operating expenses by category. Check operating profit and margin after overhead. When a number changes sharply, investigate the underlying rows before drawing a conclusion.
Keep definitions stable from month to month. For example, do not move the same type of cost between direct costs and operating expenses just to make one month look better.
What a Power BI template can and cannot do
A Power BI template can turn organized source tables into charts and filters for reviewing business activity. It still depends on consistent data and a refresh routine. A desktop template is not automatically a bank feed, accounting integration, or continuously updated online dashboard.
The Bedsun Tech dashboard starts with fictional demo data. Its sample Excel workbook shows the expected Sales and Expenses table structure; you replace the sample rows and refresh in Power BI Desktop on Windows.