Accrual-to-Cash Excel Spreadsheet Resource
A question in the AccountingWEB Q&A Forum asked if anyone knew of an existing template such as an Excel worksheet or simplified software program that can be used in workpapers and to teach new team members how to properly and completely convert an accrual trial balance to a cash trial balance.
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.
Voice of the Editor
What makes a company a great place to work? Experience, a ConnectEDU company, uses criteria that include benefits, career advancement opportunities, culture, and work/life balance to form its annual list of the Best Places to Work for Recent Grads. BDO USA and Ernst & Young both made the Top 25 list. Read what makes these firms stand out and find out what can be done at your firm to entice college grads.