USA Cash to Accrual Conversion?

Jan 13, 2017
Reaction score
United States
I've exhausted google and haven't found very many helpful resources, but I have to create a cash to accrual conversion worksheet for a company. I completely understand the concept (accounts receivable, payables, accrued expenses, unearned revenue, etc) but I'm having a hard time actually executing.

I have 4 years worth of information in Quickbooks. Where do I start? What type of template should I use (I assume I will be using excel).

Does anyone have a mock-template that they have used or know of that I can use to complete this?

Thanks in advance!



VIP Member
May 12, 2011
Reaction score
United States
Start with your cash basis trial balance. Then add adjustment columns (Dr & Cr) for your accrual basis adjustments and then your columns (Dr & Cr) for your Adjusted (Accrual Basis) Trial Balance. (sum of cash plus adjustments)

So in your adjustment columns - add in the accounts and amounts you need on accrual basis (which you named above: A/R , A/P, Accrued exp, etc) plus their income stmt offsets. For example if you are adding A/R then you have the related accrual based sales revenue. Then document your adjustments, get your work reviewed and that's it.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

USA Stuck doing Accrual to cash basis conversion! 1
Cash to Accrual 3
USA Question on Cash to Accrual 1
Cash to Accrual clarification 2
Cash & Accrual Accounting 1
Cash vs accrual 0
Change cash to accrual 2
cash basis or accrual 4