Small Business Expense Tracker Spreadsheet, Income and Profit Dashboard, Excel Bookkeeping Template

Bring your business income, expenses and cash flow into one clear monthly review. RockPaperPop's Small Business Profit & Expense Tracker is an editable Excel-format workbook for freelancers, service businesses and small business owners who want an approachable way to record cash and compare results with their budget.

WHAT IT DOES
- Record income, expenses, fees and three refund types in one cash transaction log.
- See net revenue, operating costs, cash-basis profit before tax and net cash change.
- Review a monthly category budget versus actuals, including overspending and remaining cost budget.
- Set recurring monthly budgets and replace a category's plan with a monthly override when needed.
- Track bill due dates and paid / unpaid status with payment-reference matching.
- Review a calendar-year overview and two automatic charts.
- Edit category names while stable category IDs preserve previous entries.
- Use clearly marked amber input cells, dropdowns and source-entry warnings.

NINE TABS
Dashboard, Setup, Monthly, Annual, Transactions, Budget, Recurring Plan, Bills and Start Here.

EXACT CONTENTS
One customer ZIP containing:
1. RPP-FIN-340_Business-Tracker_CLEAN.xlsx - editable workbook without example transactions.
2. RPP-FIN-340_Business-Tracker_EXAMPLE.xlsx - the same workbook with clearly labelled fictional demonstration data.
3. RPP-FIN-340_Quick-Start.pdf - four-page guide.
4. RPP-FIN-340_Printable-Summaries_A4.pdf - two blank printable summary worksheets.
5. RPP-FIN-340_Printable-Summaries_US-Letter.pdf - the same two worksheets in US Letter size.
6. RPP-FIN-340_Usage-Licence.pdf - own-business use terms.
7. RPP-FIN-340_READ-FIRST.txt - delivery and setup notes.
8. RPP-FIN-340_File-Manifest.txt - file list.

The printables are monthly and annual worksheets for handwriting or copying figures from the workbook. PDFs do not calculate or connect to Excel. Listing images and the preview video are seller presentation assets, not extra customer products.

START IN THREE STEPS
1. Download and extract the ZIP. Save a working copy of the CLEAN workbook.
2. Enter your business name, reporting year, month, review date and currency in Setup. Rename category names if needed.
3. Enter cash transactions, set budgets and review Monthly, Annual and Dashboard. Use the EXAMPLE file as a learning reference.

CURRENCY DISPLAY
Choose USD, GBP, CAD, EUR, CHF, AED, SAR, QAR, KWD, BHD, OMR, PKR, INR, BDT, JPY, CNY, SGD, MYR, IDR, AUD or NZD, or enter a custom code with 0-3 decimal places.
JPY displays 0 decimal places; KWD, BHD and OMR display 3; other presets display 2. One reporting currency per workbook. This changes display only: it does not convert values or consolidate mixed currencies. Enter amounts already expressed in your reporting currency. Calculations retain the precision you enter.

CALCULATION BASIS
Cash-basis profit before tax = income received minus customer refunds, operating expenses paid and fees, plus expense and fee refunds. Refunds affect the month in which they are paid or received. Unpaid invoices and unpaid bills are not actual income or expenses.
Owner contributions / withdrawals, loan principal, tax cash and capital-asset cash remain separate from trading profit. Transfers between accounts within the same tracked business have zero combined cash effect. Net cash change is not an ending bank balance.
Record gross income and each fee once on a separate Fee row. Do not enter a net payout and deduct the same fee again. A paid bill checklist entry does not create a second expense.

CAPACITY
1,200 transaction rows, 600 monthly budget override rows, 60 recurring plan rows and 240 bill rows per workbook. Use the prepared rows. One business per workbook. You can save another copy for your own future reporting year; update the year, plan dates and bill dates.

SOFTWARE AND TESTED COMPATIBILITY
Delivered as editable .xlsx files intended for Microsoft Excel on a desktop or laptop. Formula and input behaviour were tested in the authoring engine, and the exported workbooks were independently recalculated in LibreOffice. Native Microsoft Excel was not available for testing. No Google Sheets version or tested Google Sheets, Apple Numbers, phone or tablet compatibility is claimed. Spreadsheet software is not included.

FAQ
Which app do I need?
Microsoft Excel on a desktop or laptop. Google Sheets, Apple Numbers, phones and tablets are not tested, so we can't promise they work.

Will it file my taxes?
No. It helps you track income, costs and cash-basis profit before tax. It does not file taxes or give tax advice.

Who is it for?
Freelancers, service businesses and small business owners who want income, expenses and profit in one place.

Does it connect to my bank?
No. You record your own transactions in the log.

Is anything shipped?
No. This is an instant digital download. No physical item is shipped.

DIGITAL DELIVERY
This is an instant digital download. No physical item will be shipped. After payment is confirmed, download the ZIP through Etsy.com in a web browser: Your account > Purchases > Download Files. Guest buyers can use the download link in their Etsy receipt email. Etsy app downloads are not supported; use a computer or mobile browser, then extract and open the files on your computer.

LICENCE
For the buyer's own business and internal use. You may edit, print and back up your working files and reuse them for your own reporting years. No resale, redistribution, public sharing, PLR, template giveaways or competing-template use. Separate purchases are required for separate client businesses. See the included licence for details.

LIMITATIONS AND SUPPORT
No bank sync, automatic exchange rates, tax-filing calculations, inventory valuation, depreciation, unpaid-invoice accounting or guaranteed-profit claims. This is a management tracker, not a statutory accounting or tax-return system. Because the product is digital, routine returns or exchanges are not offered after delivery. Please contact RockPaperPop through Etsy Messages if you have a download problem, a faulty file or an item-not-as-described concern. This does not limit applicable consumer rights or Etsy protections.

CREATION DISCLOSURE
Created for RockPaperPop with AI assistance in workbook development, copy and original device mockup artwork. Product screens and charts in the listing come from the actual example workbook. Demonstration figures are fictional. Microsoft Excel is a trademark of Microsoft Corporation; this independent product is not affiliated with or endorsed by Microsoft.