Monthly Income and Expense Tracker for Small Business | Excel and Google Sheets

If you do not track your income and expenses month by month, you do not actually know your numbers.

You know your bank balance. That is not the same thing.

Every deduction you miss is money you owe the IRS that you did not have to. Every month you do not record is a month you have to reconstruct later, manually, under pressure.

This tracker exists to stop that cycle.

Who This Is For

This tracker was built for:

• Independent contractors and 1099 workers who file Schedule C and need their numbers organized
• Freelancers who get paid by multiple clients and can never tell if they actually made money
• Etsy sellers and online shop owners juggling material costs, fees, and shipping every month
• Small business owners who are not accountants and do not want complicated software
• Anyone who has handed a shoebox of receipts to their tax preparer and knows it cannot happen again

If you have income, you have expenses. If you have expenses, you have deductions. And if you are not tracking them, you are overpaying.

What You Will Be Able to Do

After using this tracker, you will:

• Know your exact monthly income, cost of goods sold, and net profit or loss without digging through bank statements
• Have every deductible expense categorized and totaled before tax season starts
• Hand your tax preparer a clean, organized record instead of a pile of transactions
• Stop guessing which months were profitable and which ones were not
• Track your vehicle mileage deduction with the 2025 IRS rate built in at $0.70 per mile
• File with confidence because your numbers are documented and accounted for

What's Inside

Income Section Track Gross Receipts, Other Income, and Returns or Allowances month by month. Monthly and annual totals calculate automatically.

Cost of Goods Sold (COGS) Separate rows for Materials and Supplies, Labor, and Other COGS. Gross Profit or Loss is calculated automatically per month and for the full year.

Expenses and Deductions (Schedule C-Aligned Categories)

Every category mirrors what the IRS asks for on Schedule C. You are not translating your records at tax time. They are already in the right format.

Categories covered:

• Advertising: Etsy Ads, Flyers, Promotions, Social Media Marketing
• Business Vehicle: Mileage at 2025 IRS rate ($0.70/mile, auto-calculated), Gas, Car Repairs, Parking and Tolls, Registration
• Commissions and Fees: Bank Fees, Listing Fees, Marketplace Commissions, Transaction Fees
• Contract Labor: Virtual Assistant, Social Media Manager
• Insurance, Legal and Professional Fees, Office Expenses
• Rent, Repairs and Maintenance, Supplies, Equipment and Tools
• Taxes and Licenses: Payroll, State Income, State Sales Tax
• Travel and Meals, Utilities, Wages
• Other Expenses: Bad Debts, Business Gifts, Charitable Donations, Continuing Education, Dues and Subscriptions, Website Expenses, plus 18 open custom lines for expenses that do not fit a preset category

Summary Row Total Expenses and Net Income or Loss are calculated automatically. No formulas to build. No manual math.

Design and Setup Color-coded input cells show you exactly where to type. Business name and year fields at the top. One sheet. Twelve months. January through December with a full-year totals column.

Why This Tracker Exists

Free templates exist.

Most of them are generic. Categories that do not match what the IRS actually asks for. No mileage rate. No COGS section. No structure that carries through to your tax return.

This tracker was built around Schedule C. That is the form self-employed individuals and small business owners file. The categories in this tracker map directly to what your preparer needs and what the IRS reviews. You are not reorganizing your records. You are done the moment you enter the numbers.

Works with Microsoft Excel and Google Sheets. Download once. Reuse every year.

Guessing costs money. Organized records do not.

What This Tracker Directly Answers

This tracker was built around the exact questions self-employed individuals and small business owners search for:

• monthly income and expense tracker for small business download
• how to track business expenses as a freelancer or independent contractor
• simple expense spreadsheet for Etsy sellers
• Schedule C expense categories for self-employed
• how to organize finances for tax prep without accounting software
• small business bookkeeping template Excel and Google Sheets
• how to track mileage deduction for self-employed 2025
• income and expense spreadsheet for sole proprietor

Frequently Asked Questions

1. Is this compatible with Microsoft Excel and Google Sheets? Yes. The file works on both platforms. Download and open it in whichever program you already use.

2. Does this cover Schedule C expense categories? Yes. The expense categories in this tracker are structured to match Schedule C, the form self-employed individuals and small business owners file with the IRS. Your records are already organized the way your tax preparer needs them.

3. Can I use this for multiple years? Yes. Save a new copy at the start of each year and enter your business name and year at the top. The structure and formulas carry over every time.

4. I am not an accountant. Will I be able to use this? Yes. Color-coded cells show you where to enter numbers. Totals calculate automatically. You do not need to know formulas or bookkeeping to use it correctly.

5. What if I have expenses that do not fit any listed category? There are 18 open custom lines in the Other Expenses section. Add any expense your business incurs that does not fall under a preset category.

6. Is this for a product-based business, a service business, or both? Both. The COGS section covers product-based businesses with material and labor costs. Service-based businesses can leave that section blank and focus on the income and expense categories.

7. Will this work for my Etsy shop? Yes. Etsy Ads is a built-in line item. Listing fees, marketplace commissions, transaction fees, materials, and shipping costs all have dedicated categories.

About Rapid Tax Software Solutions

Built specifically for small business owners, freelancers, and self-employed individuals navigating taxes and monthly recordkeeping.

Every category in this tracker is intentional. The structure reflects what tax professionals use and what the IRS expects. Not guesswork. Not filler.

Doing it right matters.

Bottom line: Know your numbers every month. Walk into tax season with documentation that is already done. Stop leaving deductions on the table.

Download it once. Track every month with confidence.

Digital Product Policy: By completing your purchase, you understand and agree that this is a digital product. All sales are final. Due to the immediate access provided upon purchase, no refunds, returns, exchanges, or chargebacks are permitted once the product has been purchased or downloaded.