Accrual To Cash Adjustment

Why Your Numbers Don't Match

You run your P&L and your bank statement and they just don't line up. This happens constantly when you're converting accrual-based financial statements into cash-basis numbers for lenders, tax purposes, or internal analysis. The difference isn't an error. It's an Accrual To Cash Adjustment, and it's one of those things that sounds simple until you actually do it. I've done this adjustment for so many businesses that I can spot the problem areas within ten minutes. The most common issue I see? People forget about prepaid expenses and accrued liabilities. They adjust revenue and accounts receivable but leave these two sitting in the numbers untouched. That's how you end up with a five-figure gap between what your adjustment says and what actually made sense.

Running the Accrual To Cash Adjustment

Start with your accrual-based net income figure. From there, you need to subtract the increases in current assets and add back the decreases, then reverse the logic for current liabilities. Specifically: Subtract the increase in accounts receivable from your net income. If your AR went from $50,000 to $75,000 during the period, that $25,000 increase represents revenue you recorded but haven't received cash for yet. It needs to come out. Subtract any increase in prepaid expenses. Same logic. You booked the expense when you paid, not when you used it. Cash moved but the P&L already captured it under accrual.

Add the increase in accounts payable. If you went from $30,000 to $45,000 in AP, that means you recorded expenses but haven't paid cash yet. The expense is in your net income but the cash hasn't left your bank account. Add it back. Subtract the decrease in prepaid expenses or add the decrease in accounts payable, depending on which direction they moved. The logic is the same either way. I worked with a manufacturing client last year who had a particularly messy situation with their work-in-progress inventory. Their WIP account increased by $120,000 during the quarter, which meant a lot of cash was tied up in partially finished goods that hadn't been recognized as cost of goods sold yet. Under accrual, that inventory sits on the balance sheet. Under cash basis, it doesn't affect the P&L until the goods actually sell. We adjusted for the entire change in WIP, not just the finished goods portion, and it added nearly $40,000 back to their cash flow figure. Without that adjustment, their lender would have seen a company that looked significantly less profitable than it actually was on a cash basis.

The Methodology Behind It

The mechanics are straightforward but easy to mess up if you're not careful about the direction of each adjustment. Here's a slightly more detailed walkthrough. Take your accrual net income. Look at your balance sheet changes for the period. For each current asset account, determine whether it increased or decreased. Increases in current assets are subtracted. Decreases are added. For each current liability account, it's the opposite. Increases are added. Decreases are subtracted. The intuition here is that a current asset increase means cash is trapped in something non-cash. A receivable increase means sales revenue exists on paper but the money isn't here yet. An inventory increase means you spent cash buying stuff that hasn't been expensed yet. All of these reduce your true cash position relative to your accrual net income.

For liabilities, an accounts payable increase means you recorded an expense but didn't pay for it yet. The expense reduced your net income, but the cash never left. So you add it back to get to the real cash number.

Common Pitfalls I See All the Time

One thing that catches people off guard is how depreciation affects this calculation. Depreciation is a non-cash expense that reduces your accrual net income. Since no actual cash left your account for depreciation, you need to add it back when doing the Accrual To Cash Adjustment. This is usually the simplest adjustment in the whole process, but I've seen junior accountants skip it repeatedly. They remember to adjust working capital accounts and then move on, forgetting that depreciation alone could account for tens of thousands of dollars in adjustment. Another issue is multi-year prepaids. If a business pays a year's worth of insurance upfront, that's a current asset under accrual accounting. The entire payment hits cash immediately but only the monthly portion hits the P&L. When adjusting, you need to make sure you're adjusting the right portion of the prepaid account. Some people just adjust the total change without considering whether part of it relates to non-current assets. That throws off your final number. Stock-based compensation is another one that trips people up. It's a non-cash expense on the P&L, so it needs to be added back just like depreciation. But because it shows up as an equity transaction rather than a cash transaction, it doesn't naturally appear in the working capital adjustments. You have to catch it separately.

What This Method Can't Handle

The accrual-to-cash conversion works well for operating items. It breaks down when you start dealing with capital expenditures, debt principal repayments, or equity transactions. Those aren't reflected in your net income at all under accrual accounting, so a simple adjustment from net income won't capture them. If you need cash flow from investing or financing activities, you have to pull those from the balance sheet directly or from your general ledger detail. Also, this approach assumes your accrual financials are accurate to begin with. If there are misstatements in revenue recognition, expense cutoff, or inventory valuation, the cash adjustment will inherit those errors. I had a client once whose accrual revenue was inflated by about $80,000 due to premature recognition on a long-term contract. The cash adjustment made the numbers look reasonable until we dug into the contract terms and found the discrepancy. Always verify the starting point before you trust the output. The adjustment is most useful for small to medium businesses that maintain proper accrual books but need to show cash profitability for loan applications or investor meetings. For larger companies with complex treasury operations, the manual calculation becomes unwieldy and prone to errors. Those organizations typically use dedicated cash flow statement software that pulls directly from the ERP system.

A Practical Example

Let me walk through a concrete scenario. A company reports accrual net income of $200,000 for the quarter. During that quarter, accounts receivable increased by $30,000, inventory decreased by $15,000, accounts payable increased by $20,000, and prepaid expenses increased by $5,000. Depreciation for the period was $12,000. Starting with $200,000 in net income, subtract the $30,000 increase in AR. Add back the $15,000 decrease in inventory. Add back the $20,000 increase in AP. Subtract the $5,000 increase in prepaids. Add back the $12,000 in depreciation. That gives you a cash basis net income of $212,000. The math is clean enough that you can do it in a spreadsheet in under five minutes. The hard part is getting all the account balances correctly categorized and making sure nothing was missed. I usually build a running checklist of every current asset and liability account, then mark each one as I adjust it. That way I can see at a glance if anything is still unaccounted for.

There's also a shortcut method that some people use when they have access to a full cash flow statement. Instead of building the adjustment from net income, they simply take the operating cash flow line from the indirect method cash flow statement. That's technically the same number, just already calculated by whatever accounting system produced the statements. If you have a properly prepared cash flow statement, you don't need to do the manual adjustment at all. But that luxury isn't available to everyone, especially smaller businesses that prepare their financials manually or through simpler software packages. If you're doing this regularly, I'd recommend building a standardized template with every balance sheet account laid out in columns. You fill in the beginning balance, ending balance, and the adjustment in one pass. Takes maybe 15 minutes per period once the template is set up, compared to an hour or two of figuring it out from scratch each time.

When to Use This

SBA lenders routinely ask for cash basis financial statements alongside accrual ones. That's the most common reason businesses run this adjustment. It's also useful when you're preparing documents for a small business loan application, when doing internal performance analysis and want to strip out non-cash items, or when comparing your business to competitors who report on a cash basis. It's less useful if your business has significant long-term contracts, deferred revenue that spans multiple periods, or inventory accounting issues. In those cases, the adjustment becomes complicated enough that a full cash flow statement preparation is more reliable. Don't force this method into situations where it doesn't fit just because it's easier to explain.

Tools and Resources

I keep a Google Sheet template that handles most standard cases. It has dropdowns for each account type, automatic calculations for the adjustments, and a summary section at the bottom. You can find a basic version of it online if you search for accrual to cash adjustment spreadsheet templates. Just be careful with free templates because a lot of them don't account for unusual items like stock-based compensation or non-current prepaids. I've seen people use those templates and end up with cash flow numbers that were off by several percentage points because of missing line items. For businesses that do this monthly or quarterly, investing in a proper accounting package like QuickBooks Online with cash basis reporting turned on saves a massive amount of time. You can run side-by-side reports and verify your manual calculations against what the software produces. That verification step alone has caught errors for me at least twice in the last year, usually stemming from misclassified accounts or incorrect date ranges. The bottom line is that the Accrual To Cash Adjustment is a practical tool, not a theoretical exercise. It works well when your data is clean and your situations are standard. It falls apart quickly if you're dealing with edge cases or messy bookkeeping. Know your starting numbers, verify your categories, and don't skip the reconciliation step at the end. That last part is where most people go wrong, assuming the math checks out when they've actually missed an account or two somewhere in the middle of the spreadsheet.