Accrual-to-Cash Excel Spreadsheet Resource
Our thanks to Mr. Jim Blair, CPA, an AccountingWEB member for responding and making his simple template available to AccountingWEB members.
The attached download  is a very simple spreadsheet to convert accrual basis net income to cash basis. Many financial statement preparers simply zero out the ending balance sheet accounts relative to income and expenses in an attempt to arrive at the adjusted net income amount. The beginning balances for these accounts must also be considered.
This spreadsheet may be revised to include additional accounts on an as needed basis. Remember when adjusting for inventories the IRS allows a deduction for inventories that are paid for in the year of adjustment.
You may download  this spreadsheet for free to convert accrual basis net income to cash basis.