Accrual to Cash Conversion — Staff Procedure Guide

Scope & Method Selection

Before touching the numbers, decide which version of "cash basis" you are producing. The three flavors below produce materially different results, and getting this wrong wastes a full conversion cycle.

Method	Recognition	Use Case
Pure Cash	Income when received, expense when paid. No AR, AP, prepaids, accruals, deferred revenue, or inventory on the books.	Small-business tax filings, simple sole props, owner internal reporting.
Modified Cash	Cash basis for revenue and most expenses, but capitalizes & depreciates fixed assets and may carry inventory and prepaids.	Most professional service firms, internal management reporting, many SMB tax returns.
Hybrid	Accrual for inventory/COGS (where required), cash for everything else. Permitted when §471(c) does not apply or when GAAP-accrual inventory is required.	Inventory-bearing businesses above the §448(c) gross-receipts threshold ($30M for 2024, indexed).

Tax Method Note

If the conversion is for a tax method change, the IRS requires Form 3115 with a §481(a) adjustment. Do not just "switch" on a return — this is an automatic-consent change (DCN 233 for accrual-to-cash for eligible small taxpayers). See Section 8.

Source Data Required

The conversion is only as clean as the source data. Pull both period-end and prior-period-end balances — the deltas drive every adjustment. Do this before opening Excel.

From the accounting system

Report	What to Pull	Periods
Trial Balance	Accrual basis, all accounts, with prior-period comparison column.	2
P&L	Accrual basis, by month if possible; export to Excel — never PDF.	1
Balance Sheet	Comparative — current period end and prior period end side-by-side.	2
A/R Aging Detail	Confirms AR balance and identifies stale invoices.	2
A/P Aging Detail	Confirms AP balance; check for vendor bills entered for prior periods.	2
Inventory Valuation	Beginning and ending inventory by SKU/category if applicable.	2
GL Detail — Accrued Liabilities	Identify what was accrued and when each piece will be paid.	2
GL Detail — Prepaids	What was prepaid, the amortization schedule, and what hit P&L.	2
GL Detail — Deferred Revenue	Customer deposits, retainers, gift cards, subscription advances.	2

Software-specific export tips

QuickBooks Online

Reports → toggle Accounting method to Accrual at the top of every report before exporting. QBO defaults to the company file setting; do not assume.
For the comparative BS: Balance Sheet → date range → Compare another period: Previous period. Export to Excel (not "Export to PDF").
QBO's built-in cash-basis report only adjusts AR and AP at the transaction level. It does not back out prepaids, accrued liabilities, deferred revenue, or inventory. Never deliver QBO's cash-basis report as the final cash-basis financials without reconciliation.
Pull the Audit Log if the period is closed — late accrual entries can change the conversion math after the fact.

Xero

Reports → Cash basis toggle is per-report; export both versions to compare.
Xero's "tracked inventory" creates inventory valuations automatically — confirm whether the client uses tracked or untracked items.

Sage / NetSuite / Other

Always request a trial balance with subsidiary detail rather than summary financials. Many ERP systems consolidate accruals into unhelpful rollups on the standard P&L.
Confirm the period close was completed. Sub-ledger postings after the GL close create reconciliation differences.

Stop & Verify

If the client's books are on a hybrid method already (e.g., cash for revenue but accrual for payroll), do not apply the full conversion. Identify which accounts are already on cash basis and exclude them from the delta calculations. Get this in writing from the client or prior preparer.

Workpaper Architecture

Use a single Excel workbook with the following tab structure. Color-code the tabs and lock the source tab once data is pasted. The structure is the same whether the source is QBO, Xero, Sage, or a CSV the client emailed.

Tab 01

SOURCE

Raw paste from accounting system. Trial balance, P&L, BS — both periods. Never edit.

Tab 02

ΔWP

Delta worksheet. Compute Δ for every accrual-only account between the two period ends.

Tab 03

ADJ

Conversion journal entries with narrative for each. The audit trail.

Tab 04

CASH P&L

Output: cash-basis income statement, with reference column tying every line back to the ADJ tab.

Tab 05

CASH BS

Output: cash-basis balance sheet, with the equity true-up explicitly shown.

Tab 06

§481(a)

If applicable: §481(a) adjustment calculation, sign check, and 4-year spread schedule.

Tab 07

TIE-OUT

Validation checks (see Section 6). Every check must show "OK" before the file is considered final.

Convention

Use a consistent sign convention. Recommended: positive numbers = increases, negative numbers = decreases, with debits/credits shown via a separate column on the ADJ tab. Mixing conventions across tabs is the most common source of conversion errors.

Conversion Mechanics

Every conversion reduces to four moves: adjust revenue, adjust expenses, strip the accrual-only balance sheet accounts, and roll the net effect through equity. The math is identical to the indirect method of the cash flow statement.

Revenue side

F-1 · Revenue Cash Revenue = Accrual Revenue − ΔAccounts Receivable + ΔDeferred Revenue (Unearned) − ΔUnbilled Revenue / Contract Assets where Δ = Ending − Beginning

Increase in AR means revenue was booked but cash has not arrived → subtract. Increase in deferred revenue means cash arrived but revenue is not yet booked → add. Unbilled revenue / contract assets behave like AR.

Expense side

F-2 · Operating Expenses Cash Expenses = Accrual Expenses + ΔPrepaid Expenses − ΔAccounts Payable − ΔAccrued Liabilities (wages, taxes, interest, etc.) − Depreciation & Amortization − Other non-cash charges (bad debt, impairments, stock comp)

Increase in prepaids means cash went out before the expense hit P&L → add. Increase in AP / accruals means expense hit P&L before cash went out → subtract. Strip out non-cash charges entirely.

Inventory & COGS

F-3 · Inventory (Pure Cash) Cash Inventory Outflow = Accrual COGS + ΔInventory − ΔAP (inventory portion only)

Under pure cash, inventory is removed entirely — purchases are deducted when paid. Under modified cash, inventory may remain on the balance sheet and COGS is computed conventionally.

Master reconciliation: Net Income

F-4 · NI Reconciliation (Master) Cash Net Income = Accrual Net Income − ΔAR − ΔInventory (if removing) − ΔPrepaid Expenses + ΔAccounts Payable + ΔAccrued Liabilities + ΔDeferred Revenue + Depreciation & Amortization + Other non-cash items

Balance sheet — what stays, what goes

Account	Pure Cash	Modified Cash	Treatment
Cash & Cash Equivalents	Keep	Keep	No adjustment.
Accounts Receivable	Remove	Remove	Offset to Equity.
Inventory	Remove	Often kept	If removed, offset to Equity. If kept, no adjustment.
Prepaid Expenses	Remove	Often kept	If removed, offset to Equity.
Fixed Assets / Accum. Depr.	Keep	Keep	No adjustment. Depreciation continues.
Accounts Payable	Remove	Remove	Offset to Equity.
Accrued Liabilities	Remove	Remove	Offset to Equity.
Deferred Revenue	Remove	Remove	Offset to Equity.
Notes Payable / LT Debt	Keep	Keep	Principal is a balance sheet item; interest accrued goes through Accrued Liabilities.
Equity / Retained Earnings	Plug	Plug	Absorbs the net of all adjustments — see equity true-up.

The equity true-up

F-5 · Cash-Basis Equity Cash Equity = Accrual Equity − AR − Inventory (if removed) − Prepaid Expenses (if removed) + Accounts Payable + Accrued Liabilities + Deferred Revenue

The equity adjustment at any given balance sheet date is the §481(a) adjustment if you are converting for tax purposes — same number, different label.

Step-by-Step Procedure

Confirm scope in writing
Get the client's intended cash-basis flavor (pure / modified / hybrid) confirmed in email or the engagement letter. Confirm the period(s) being converted and whether this is a one-off report or a tax method change.
Pull source files into Tab 01 (SOURCE)
Export trial balance, P&L, BS for both period ends, plus AR aging, AP aging, inventory valuation, prepaid schedule, and accrued-liability detail. Paste into the SOURCE tab. Lock it (Review → Protect Sheet).
Map accounts to the Δ worksheet
On Tab 02 (ΔWP), build a two-column comparison of every accrual-only account:
- Column A: account name
- Column B: prior period balance
- Column C: current period balance
- Column D: Δ (=C−B)
- Column E: tickmark / source reference
Draft adjusting entries on Tab 03 (ADJ)
For each Δ, write a journal entry with a narrative. One entry per account category. Standard pattern:
- DR Revenue / CR AR (to remove uncollected revenue)
- DR AP / CR Expense (to remove unpaid expenses)
- DR Accrued Liabilities / CR Expense
- DR Deferred Revenue / CR Revenue (to recognize cash collected)
- DR Expense / CR Prepaid Expense (to remove prepaid asset, if pure cash)
- DR Depreciation Adjustment / CR Depreciation Expense (only if pure cash with no fixed assets)
Build cash-basis P&L on Tab 04
Start from accrual P&L (linked from SOURCE), apply each adjustment from ADJ as a column, and compute the cash-basis result. Each adjustment line should reference its ADJ entry number (e.g., "ADJ-3").
Build cash-basis BS on Tab 05
Same approach. Strip out the accrual-only accounts (set to zero or hide), and compute the equity plug. Equity must equal Accrual Equity ± the cumulative adjustment per Formula F-5.
Run validation checks on Tab 07 (TIE-OUT)
See Section 6 for the required checks. Every check must return "OK" before close.
Compute §481(a) if applicable on Tab 06
Cumulative net adjustment to convert the opening balance sheet to cash. Sign-check, determine 4-year spread (positive) or single-year (negative), document for Form 3115.
Document & review
Write a one-page memo summarizing: scope, method chosen, total adjustment, any judgment calls (especially around hybrid treatment), and tie-out results. Route for partner review before issuing to client or filing.
Archive
Upload the final workpaper, source exports, and memo to TaxDome under the client's tax-year folder. Keep the SOURCE exports — if the conversion is ever reviewed, you need the original accrual data to reproduce the work.

Validation & Tie-Outs

Five checks must all pass. Build them as formulas on Tab 07 with conditional formatting (green = OK, red = fail).

#	Check	Formula / Test
T-1	Cash BS balances	Total Assets = Total Liabilities + Equity (cash-basis side)
T-2	NI reconciliation matches	Cash NI (P&L) = Accrual NI ± Σ adjustments per F-4
T-3	Equity plug = §481(a) cumulative	Cash Equity − Accrual Equity = Σ all BS-side conversion adjustments
T-4	Roll-forward check	Beginning Cash Equity + Cash NI ± Distributions = Ending Cash Equity
T-5	Cash account is unchanged	Cash & equivalents on cash-basis BS = Cash on accrual BS (always)

If T-5 Fails

The cash account itself never changes between accrual and cash basis — it is already on cash. If your cash-basis BS shows a different cash balance than the accrual BS, you have an error in the adjustments, not a legitimate difference. Stop and reconcile before continuing.

Common Pitfalls

The conversion math is straightforward. The errors come from these eleven items, almost without exception.

Credit card payables

Charging an expense on a credit card is constructively paid for cash-basis purposes. Do not back out the credit card balance the way you do A/P. Only the merchant fees and interest on the card itself accrue.

Customer deposits vs. deferred revenue

Both increase cash basis revenue (cash received without revenue recognition). Confirm the GL classification — customer deposits are sometimes parked in liability accounts that are not labeled "deferred revenue."

Sales tax payable

Sales tax is a pass-through, never the client's revenue or expense. Confirm whether the client books revenue gross-of-tax (then accrues sales tax payable) or net. Your conversion should not move sales tax payable.

Payroll accruals

Accrued wages, accrued bonuses, accrued payroll taxes, and accrued PTO all reverse under cash basis. Confirm with the client which payrolls were unpaid at year-end. Bonuses paid within 2.5 months of year-end have separate accrual rules under §461 — not relevant for cash basis but flag if you are bouncing back.

Loan principal vs. interest

Principal payments never hit either P&L. Only interest does. Make sure accrued interest payable is captured in the accrued-liabilities adjustment, separately from the principal balance on the BS.

Inventory under §471(c)

Eligible small-business taxpayers under the §448(c) gross receipts test ($30M for 2024, indexed) can treat inventory as non-incidental materials & supplies — effectively cash basis on inventory. Confirm eligibility and election before stripping inventory entirely.

Bad debt expense

The allowance method is GAAP / accrual only. Cash basis taxpayers cannot deduct bad debt — uncollected receivables simply never become revenue. Reverse any bad debt expense and the allowance for doubtful accounts.

Unbilled revenue / contract assets

Common for service businesses on percentage-of-completion. Treat the same as A/R for conversion purposes — Δ unbilled revenue reduces cash-basis revenue.

Owner draws / distributions

Distributions are equity transactions, not expenses. Confirm they are coded correctly before you start — if a draw was miscoded as an expense, you will mis-state the conversion.

Related-party accruals

For accrual-method clients, §267 already disallows current deduction of accruals to related cash-basis parties. Once you flip to cash, this rule becomes moot for the converting entity but may affect comparative analysis with prior accrual returns.

Mid-year conversions & partial periods

If converting partway through a year, the opening balance sheet for the cash-basis period must be stated on cash basis — meaning the §481(a) is computed at the conversion date, not year-end. Do not just convert the YTD P&L without restating the opening BS.

Tax Treatment & §481(a)

If the conversion is for a tax method change rather than internal/management reporting only, this section governs.

Form 3115 — Application for Change in Accounting Method

DCN 233 — automatic consent for change from overall accrual to overall cash for eligible small-business taxpayers under §448(c).
Filed in duplicate: original attached to the timely-filed (incl. extensions) federal return for the year of change; copy to IRS Ogden (DCN-specific address — verify each filing season).
Year of change can only be the current tax year — no retroactive method changes via Form 3115.

The §481(a) adjustment

F-6 · §481(a) §481(a) = Cumulative effect on taxable income of being on the new method = (Cash-basis income inception-to-date) − (Accrual-basis income inception-to-date) ≡ Equity adjustment from F-5 at the conversion date

Positive §481(a) (increases income — typical when accrual revenue exceeds collected revenue, i.e. AR > AP): spread over 4 tax years beginning with the year of change.
Negative §481(a) (decreases income): taken entirely in the year of change.
De minimis rule: positive §481(a) under $50,000 may be elected to be taken entirely in the year of change.

Audit Protection

A properly filed Form 3115 provides audit protection — the IRS cannot challenge the prior method (i.e., cannot retroactively force adjustments for years before the year of change). Filing without Form 3115 is a change without consent, which leaves all prior years exposed and can result in the IRS imposing its own method.

State conformity

Most states conform automatically to federal method changes via Form 3115. California (FTB) requires no separate state form for federal-conforming method changes but will respect the §481(a) spread. Verify state-specific treatment for any state where the client files — particularly NY, which has historically taken positions inconsistent with federal on certain method items.

Quick Reference Card

Print this section. Tape it to the workpaper monitor.

Conversion Cheat Sheet

All deltas are Ending − Beginning. All adjustments are signed from the perspective of the converting away from accrual (i.e., to cash).

Revenue

Cash Rev = Accrual Rev − ΔAR + ΔDeferred Rev − ΔUnbilled

Expenses

Cash Exp = Accrual Exp + ΔPrepaid − ΔAP − ΔAccrued − Depr. − Non-cash

Net Income (Master)

Cash NI = Accrual NI − ΔAR − ΔInv − ΔPrepaid + ΔAP + ΔAccrued + ΔDef.Rev + Depr. + Non-cash

Equity / §481(a)

Cash Equity = Accrual Equity − AR − Inv − Prepaid + AP + Accrued + Def.Rev

Sign-Check Mnemonic

"Asset deltas SUBTRACT, liability deltas ADD." (AR, Inventory, Prepaid → subtract Δ from NI) (AP, Accrued, Deferred → add Δ to NI)

Workpaper Template Layout

The exact column structure for each tab. Use this as the starting template; do not deviate without partner approval.

Tab 02 — ΔWP (Delta Worksheet)

Account	Prior PE	Current PE	Δ	Adj. Sign for NI	Tick
Accounts Receivable	120,400	158,200	37,800	(−)	A/R aging tied
Inventory	42,000	38,500	(3,500)	(−)	Per phys. count
Prepaid Insurance	6,000	9,200	3,200	(−)	Schedule
Accounts Payable	28,300	41,100	12,800	(+)	A/P aging tied
Accrued Wages	0	14,500	14,500	(+)	Per payroll
Deferred Revenue	22,000	35,400	13,400	(+)	Customer list

Tab 03 — ADJ (Adjusting Entries)

JE#	Account	DR	CR	Narrative
ADJ-1	Revenue	37,800	—	Reverse uncollected revenue (ΔAR)
	Accounts Receivable	—	37,800	Reverse uncollected revenue (ΔAR)
ADJ-2	Accounts Payable	12,800	—	Reverse unpaid expenses (ΔAP)
	Operating Expenses	—	12,800	Reverse unpaid expenses (ΔAP)
ADJ-3	Deferred Revenue	13,400	—	Recognize cash collected for future services
	Revenue	—	13,400	Recognize cash collected for future services

Continue this pattern for every Δ on Tab 02. Each ADJ entry must reference its source delta on the ΔWP tab so the reviewer can trace from any number on the cash-basis statements back to the source data in two clicks.

Automation Note

This procedure is a candidate for an internal HTML tool — input the trial balance plus the prior-period BS, output the cash-basis P&L, BS, §481(a) calc, and Form 3115 attachment narrative. Logged for the development queue alongside the existing investment-structure and salary-planning tools.