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.

You may like these other stories...

Earlier this week I presented the Chart Edition of AccountingWEB’s High Impact Excel webinar series. One of the many topics I covered was the Sparklines feature, which was first introduced in Excel 2010. Several...
On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I...
By David Ringstrom, CPA In Part 1 of this series I showed how to use a custom number format to conditionally display decimal places. Although the technique is simple, the downside is it may not work in every situation....

Upcoming CPE Webinars

Apr 17
In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!
Apr 22
Is everyone at your organization meeting your client service expectations? Let client service expert, Kristen Rampe, CPA help you establish a reputation of top-tier service in every facet of your firm during this one hour webinar.
Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.