Two businesses can have the same month and report very different profits. One counts money when it hits the bank; the other counts revenue when the work is done and expenses when the bill is incurred. That’s the whole difference between cash and accrual accounting, and it decides whether your September looks like a loss or your best month of the year.
This guide explains both methods in plain English, shows the same four months of a real-looking design studio both ways, and walks through the IRS rules on who can use the cash method in 2026 and 2027. You also get a free cash vs. accrual comparison template and an online calculator: enter each sale and expense once, with the date it was earned and the date the cash moved, and see profit under both methods side by side, plus the balances that explain the gap.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Includes 150 transaction rows, a month-by-month comparison for up to 12 months, a profit chart, an automatic reconciliation check and a gross receipts test for the cash method.
Free online cash vs. accrual calculator
Pick the period, then add your sales and expenses, or click Load example. For each line, enter the date it was earned or incurred and the date cash was received or paid (leave it blank if it hasn’t been). For prepaid items such as annual insurance or a 12-month service plan, enter the number of months it covers. The report shows profit both ways by month, A/R, A/P, prepaid expenses and unearned revenue at the end, a check that the difference is fully explained, and an optional gross receipts test. You can print it, save it as a PDF, download Excel, Word or CSV, or send a link to your accountant.
4. Cash vs. accrual report
Profit by month
Cash profit vs. accrual profit
Why the numbers differ (balances at the end)
Can you use the cash method for taxes?
Transaction by transaction
Cash basis: revenue when received, expenses when paid. Accrual basis: revenue when earned, expenses when incurred; multi-month items spread evenly. Difference for the period = change in (A/R − unearned revenue − A/P + prepaid expenses). Gross receipts test thresholds: 2024 $30M, 2025 $31M, 2026 $32M, 2027 $33M (IRS Rev. Proc. 2025-32 and 2026-35). Not tax advice.
Made with the free cash vs. accrual calculator at bookkeepingsheets.com
Cash vs. accrual accounting: the short version
| Cash basis | Accrual basis | |
|---|---|---|
| Revenue is recorded | When the customer’s payment is received | When you earn it (deliver the work or goods) |
| Expenses are recorded | When you pay the bill | When you incur them (receive the service or goods) |
| Accounts receivable and payable | Not on the books | On the balance sheet |
| Prepaid expenses and customer deposits | Hit profit the day the cash moves | Spread over the months they cover |
| Best at showing | How much cash came in and went out | Which month actually made money |
| Who uses it | Most freelancers and small service businesses | Larger businesses, anyone with lenders or investors, GAAP statements |
Neither method changes how much money you make over the life of a sale. A $9,000 website is $9,000 of revenue either way. The methods only disagree about which month it belongs to. Over a long enough period they converge; month to month they can be thousands of dollars apart.
Worked example: same business, two profits
Brightline Web Studio LLC is a small web design business. Here is what happened from July to October 2026:
- A $4,000 website for Harbor Dental was finished in June and paid on July 10.
- Oak & Pine pays a $2,500 monthly retainer at the start of each month for that month’s work.
- A $9,000 website for Summit Gym launched on August 28. The client paid on October 2.
- Lakeside Bakery paid $6,000 upfront on August 25 for a 12-month care plan starting September 1.
- A $7,500 branding project for Cole Law was delivered September 30 and a $3,200 landing page on October 20. Neither is paid yet.
- Rent is $1,200 a month. A freelance developer billed $3,600 for the Summit build (paid September 15) and $2,800 for Riverbend (not paid yet).
- Annual software ($2,400) was paid July 1 and a year of insurance ($1,800) was paid in June, both covering July onward. The ad agency’s $450 October bill was paid November 10.
| Month | Cash profit | Accrual profit | Difference |
|---|---|---|---|
| July 2026 | $2,900 | $950 | −$1,950 |
| August 2026 | $7,300 | $6,350 | −$950 |
| September 2026 | −$2,300 | $8,950 | +$11,250 |
| October 2026 | $10,300 | $1,400 | −$8,900 |
| Total | $18,200 | $17,650 | −$550 |
On a cash basis, September looks like a $2,300 loss and October looks like a record month. In reality September was the busiest month: Brightline finished the Cole Law project and started the bakery plan. October’s cash spike is mostly the Summit Gym payment for work done in August. If the owner judged the business by the bank balance alone, they might have cut back right when things were going well.
Over the four months the totals are only $550 apart, and that gap is fully explained by four balances at October 31:
| Balance | Before July | End of October |
|---|---|---|
| Accounts receivable (earned, not received) | $4,000 | $10,700 |
| − Unearned revenue (received, not earned) | $0 | $5,000 |
| − Accounts payable (incurred, not paid) | $0 | $3,250 |
| + Prepaid expenses (paid, not used up) | $1,800 | $2,800 |
| Net timing difference | $5,800 | $5,250 |
The net timing difference fell by $550 ($5,800 to $5,250), which is exactly accrual profit minus cash profit. This is the key formula, and the template checks it for you:
Accrual profit − cash profit = change in (A/R − unearned revenue − A/P + prepaid expenses)
What’s inside the template
- Setup: business name, first month of the period and the month to report through (up to 12 months).
- Transactions: description, Revenue or Expense, amount, date earned or incurred, date cash received or paid, and months to spread. Gray columns work out what each method recognizes and the status at the end (A/R, A/P, unearned, prepaid or settled).
- Comparison: cash revenue, expenses and profit next to accrual revenue, expenses and profit for every month, totals, the biggest monthly gap, the four balances and a reconciliation check, plus a chart.
- Eligibility: entity type, tax year and three years of gross receipts, compared with the IRS threshold, with a plain-English result.
How to use it
- Pull a list of the period’s invoices and bills, plus anything from before the period that was paid during it (like last month’s invoice that a client paid this month).
- Enter one row per item. The earned or incurred date is when the work was done or the service received, usually the invoice or bill date. The cash date is the deposit or payment date.
- For annual or multi-month items, enter the number of months. The accrual side spreads the amount evenly; the cash side counts it all on the payment date.
- Split partial payments into two rows, one for each payment.
- Read the Comparison sheet. If the check says OK, every dollar of difference is explained by the balances.
Who can use the cash method? (IRS rules for 2026 and 2027)
For your books and reports to managers, you can use whichever method helps you run the business. For your tax return, the IRS limits who may use the cash method. Under Section 448, C corporations, partnerships with a C corporation partner and tax shelters generally can’t use it, unless they pass the gross receipts test: average annual gross receipts for the three prior tax years at or below an inflation-adjusted limit.
| Tax years beginning in | Gross receipts test (3-year average) | Source |
|---|---|---|
| 2025 | $31 million | Rev. Proc. 2024-40 |
| 2026 | $32 million | Rev. Proc. 2025-32 |
| 2027 | $33 million | Rev. Proc. 2026-35 |
A few points that trip people up:
- Sole proprietors, S corporations and most LLCs aren’t covered by the Section 448 limit itself, but the same gross receipts test decides whether you can skip formal inventory accounting. Under the threshold, a small business taxpayer can treat inventory as non-incidental materials and supplies or follow its books (IRS Publication 538).
- Related businesses are combined. If you own several companies under common control, their gross receipts are added together for the test.
- Tax shelters can never use the cash method, whatever their size. Qualified personal service corporations (for example, many medical, law and accounting firms) have their own exception.
- Cash basis isn’t “whenever I deposit it.” Under the constructive receipt rule, a check you receive on December 30 is income for that year even if you deposit it in January.
- Prepaid expenses have limits. Under the 12-month rule, cash-basis taxpayers can deduct a prepayment only if the benefit doesn’t run beyond the earlier of 12 months after it starts or the end of the next tax year.
- Switching methods for taxes usually means filing Form 3115, Application for Change in Accounting Method. Many changes are automatic, but talk to a CPA first; the switch creates a one-time adjustment.
Which one fits your small business?
Cash basis usually fits if you’re a freelancer or small service business, you get paid within a few weeks, you don’t carry inventory, and nobody outside the business reads your financial statements. It’s simpler, and you pay tax only on money you’ve actually collected.
Accrual basis usually fits if you invoice on 30 to 60 day terms, take deposits or sell annual plans, have big prepaid costs, carry inventory, or need a bank loan or investors. It shows which months and which jobs really make money, and it’s required for GAAP financial statements.
Many small businesses do both: they file taxes on the cash method and keep accrual books, or at least a monthly accrual view like this template, for decisions. Accounting software such as QuickBooks and Xero can usually run the same reports either way. If you’re thinking about moving off spreadsheets, see our Excel vs. QuickBooks vs. Xero calculator.
Common mistakes
- Judging the month by the bank balance. A big client payment can hide a slow month and a big annual bill can hide a good one. Look at both views.
- Booking customer deposits as revenue on an accrual basis. Money received for work you haven’t done yet is unearned revenue, a liability, until you deliver.
- Expensing an annual policy in one month. On an accrual basis, spread it over the months it covers.
- Mixing methods inside one report. Recording sales when invoiced but expenses only when paid gives you a profit number that matches neither method.
- Forgetting the credit card. On a cash basis, a business credit card charge is generally deductible when charged, not when you pay the card. Enter the charge date as the cash date if that’s how you file.
FAQ
Is cash or accrual better for a small business?
For taxes, cash is simpler and often defers tax, since unpaid invoices aren’t income yet. For managing the business, accrual gives a truer picture of each month. Many owners use cash for taxes and look at an accrual view each month.
Can I use accrual for my books and cash for taxes?
Yes. Your tax method must be used consistently on your return, but your internal reports can use whatever helps you decide. Your tax preparer will convert as needed.
What is the modified cash (hybrid) method?
A mix, for example cash for most items but accrual for inventory purchases and sales. The IRS allows a combination if it clearly reflects income and is used consistently.
How do accounts receivable and payable fit in?
They only exist on an accrual basis. Track them with our invoice tracker, A/R aging report and A/P tracker, and set up the accounts with our chart of accounts template.
Does the calculator work for a full year?
Yes, for up to 12 months at a time. For a longer view, run one year at a time; items paid or earned before the period are picked up as opening balances automatically.
Related calculators and templates
- Invoice Tracker Template
- Accounts Receivable Aging Report Template
- Accounts Payable Tracker Template
- Chart of Accounts Template
- Excel vs. QuickBooks vs. Xero Calculator
- 13-Week Cash Flow Forecast Template
This guide and template are for general information and record-keeping. They aren’t accounting, tax or legal advice. Tax accounting method rules have exceptions not covered here, and changing methods has consequences. For questions about your own business, talk to a qualified accountant or tax professional.