Do you make sales throughout the month but still struggle to see how much money actually came in, how much went out, and what is still waiting to be paid or collected?
A small business income and expense spreadsheet can help you organize those numbers without building a complicated accounting system.
With this free Excel template, you can quickly see:
- how much money came into your business
- how much money went out
- your net balance for the month
- what customers still owe you
- what bills or expenses are still waiting to be paid
The goal is simple: give you a clearer picture of your business money so you can make better day-to-day decisions.
Table of Contents
- What You Can Learn From This Spreadsheet
- What Is an Income and Expense Spreadsheet?
- What Is Included in the Free Excel Template?
- How to Use the Spreadsheet
- How to Fill Out the Transactions Sheet
- Paid vs. Pending
- How to Read the Monthly Summary
- 10-Minute Month-End Review
- Yearly Review
- Frequently Asked Questions
What You Can Learn From This Spreadsheet in 10 Minutes
In simple terms: tracking income and expenses means recording the money coming into your business and the money going out.
If you record those transactions consistently, the spreadsheet helps you see what came in, what went out, what was left, and what is still pending.
Example: your business collects $12,000 during the month and pays $8,500 in expenses. Your net balance is $3,500.
But if another $2,000 in vendor bills is still pending, you need to know that before deciding how much cash is really available.
Important: this spreadsheet is a management tool. It is not a replacement for bookkeeping, accounting records, tax reporting, or professional financial advice.
What Is an Income and Expense Spreadsheet?
An income and expense spreadsheet is a simple record of the financial transactions that affect your business.
You can use it to record sales, service income, vendor payments, rent, payroll, software, transportation, marketing, taxes, and other business expenses.
Keeping those transactions in one place can help you:
- organize the money coming in and going out
- identify where you are spending the most
- see whether your monthly balance is positive or negative
- track bills you still need to pay
- track money customers still owe you
- compare results from one month to another
What Is Included in the Free Excel Template?
The workbook includes six sheets:
- Instructions: a step-by-step guide to using the spreadsheet.
- Glossary: plain-English explanations of the financial terms used in the workbook.
- Categories: lists for transaction type, status, payment methods, and income and expense categories.
- Transactions: the main sheet where you record each income or expense item.
- Summary: a monthly view of paid income, paid expenses, net balance, pending amounts, and largest expense categories.
- Yearly Review: a month-by-month view of the selected year, including a chart to help you identify trends.
The file also includes three months of sample restaurant transactions so you can see how the system works before entering your own information.
When you are ready to start, delete the sample transaction rows while keeping the headers and formulas intact.
How to Use the Income and Expense Spreadsheet
You do not need accounting experience to use the template. Consistency matters more than perfection.
Daily: Record Income and Expenses
Spend a few minutes recording the main transactions that occurred during the day.
- record sales or other income
- record purchases and vendor payments
- record payroll, transportation, software, marketing, fees, and other expenses
- mark each transaction as Paid or Pending
Weekly: Review Where Your Money Is Going
Open the Summary sheet and review your income, expenses, net balance, pending amounts, and Top 3 expense categories.
Then choose one action: review a vendor, reduce an unnecessary expense, investigate an unusually high category, or organize an upcoming payment.
Monthly: Review the Bigger Picture
At the end of the month, review what you collected, what you paid, what is still outstanding, and how the month compares with previous periods.
You can also open Yearly Review to look for changes in income, expenses, and net balance over time.
How to Fill Out the Transactions Sheet
In the Transactions sheet, each row represents one transaction.
- Date: when the transaction occurred, or its expected date if it is still pending
- Type: Income or Expense
- Category: the category that best describes the transaction
- Description: a short explanation such as “Daily sales,” “Food supplies,” or “Rent”
- Payment method: Cash, Bank transfer, Card, QR, or another option you add
- Customer / Vendor: optional, but useful for tracking outstanding amounts
- Status: Paid or Pending
- Amount: the value of the transaction
- Notes: optional details such as an invoice number or reference
If you want to keep the process very simple, start with at least Date + Type + Category + Status + Amount.
Paid vs. Pending: Why the Difference Matters
A sale, purchase, invoice, or bill does not always mean that money has already moved.
Paid means the cash movement has already happened:
- Paid income: the customer has paid you.
- Paid expense: you have already paid the bill or expense.
Pending means the amount exists, but the money has not moved yet:
- Pending income: a customer still owes you money.
- Pending expense: you still need to pay the bill.
For example, suppose a vendor sends you a $500 invoice that is due next week. Record it as an Expense with a Pending status. When you pay it, change the status to Paid and update the date if necessary.
How to Read the Monthly Summary
In the Summary sheet, select the month you want to review. The spreadsheet automatically calculates:
- Total income (Paid): money that actually came into the business.
- Total expenses (Paid): money that actually went out.
- Net balance: paid income minus paid expenses.
- Pending expenses: bills you still need to pay.
- Pending income: money customers still owe you.
Use the Top Expenses Section to Decide What to Review First
The spreadsheet identifies your three largest paid expense categories for the selected month and shows which category accounts for the largest share of your expenses.
Instead of trying to reduce every expense at once:
- identify your largest expense category
- understand what is driving that cost
- choose one action — control it, renegotiate it, reduce it, or compare alternatives
- review the result during your next check
How the Pending-Expense Alert Works
The template includes an alert to help you notice when pending expenses are becoming significant compared with the expenses you have already paid.
The relationship is:
Pending expenses Ă· Paid expenses
The default threshold is 20%.
- Below the threshold, the spreadsheet shows OK.
- At or above the threshold, it displays a warning.
- If there are no paid expenses for the month, the alert remains blank.
For example, if you have paid $5,000 in expenses and another $1,200 is still pending, the pending-expense ratio is 24%. With a 20% threshold, the spreadsheet will flag it for review.
This does not automatically mean there is a problem. It means you should review what is pending, when those payments are due, and whether they could put pressure on your available cash.
10-Minute Month-End Review
At the end of each month, use this quick checklist:
- select the correct month in Summary
- review paid income and paid expenses
- check your net balance
- review pending income and pending expenses
- identify your largest expense categories
- review the most important outstanding payments
- choose one financial action for the next month
Use Yearly Review to Compare Your Results Over Time
The Yearly Review sheet brings together the results for the selected year and shows:
- paid income by month
- paid expenses by month
- monthly net balance
- pending expenses
- a chart showing the monthly trend
If a month shows zero, it simply means there are no qualifying transactions recorded for that period.
Recommended Income and Expense Categories for a Small Business
Do not start with 30 or 40 categories. For most small businesses, 8–12 categories are enough to get started.
Common income categories:
- Sales
- Services
- Other income
Common expense categories:
- Vendors / Supplies
- Payroll
- Rent
- Utilities
- Transportation
- Marketing
- Taxes
- Other expenses
You can adjust the available lists in the Categories sheet to better match your business.
Common Mistakes When Tracking Business Income and Expenses
- Recording only large expenses: small purchases add up, so record them too.
- Mixing personal and business expenses: keep them separate whenever possible.
- Ignoring Pending transactions: use Pending whenever money has not actually moved yet.
- Waiting until month-end: update the spreadsheet regularly instead of reconstructing the month from memory.
When Should You Use a Cash Flow Forecast Instead?
This spreadsheet helps you organize transactions and understand what has happened or is currently pending.
A cash flow forecast has a different purpose: it helps you estimate when money is expected to come in and go out in future weeks or months.
If your main question is “What happened to my money this month?”, start with the income and expense spreadsheet.
If your main question is “Will I have enough cash to cover upcoming payments?”, a cash flow forecast is the more appropriate next step.
Frequently Asked Questions
What is an income and expense spreadsheet?
It is a simple tool for recording money coming into and going out of a business. It helps you organize transactions, review monthly results, and understand where your money is going.
Can I use this spreadsheet for a small business?
Yes. The template is designed for small businesses that need a practical way to track income, expenses, pending payments, and monthly results without creating a complex financial system.
Is this the same as bookkeeping?
No. The spreadsheet is primarily an internal management and tracking tool. It does not replace a complete bookkeeping or accounting system.
How often should I update the spreadsheet?
Daily is ideal, especially if your business has many transactions. If that is not practical, update it several times per week so transactions do not accumulate.
Should I include unpaid invoices and bills?
Yes. Record amounts that are still expected to be collected or paid as Pending, then update them to Paid when the money actually moves.
Can I use this spreadsheet for taxes?
The template can help you organize business transactions, but it is not designed to replace tax records, tax software, bookkeeping requirements, or advice from a qualified tax professional.
Download the Free Small Business Income and Expense Spreadsheet
Use the template in Microsoft Excel to record business income and expenses, track outstanding amounts, review monthly results, identify your largest expense categories, and compare results throughout the year.
Discover more from
Subscribe to get the latest posts sent to your email.
