USA Cash to Accrual Conversion?


Joined
Jan 13, 2017
Messages
1
Reaction score
0
Country
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!
 
Ad

Advertisements

kirby

VIP Member
Joined
May 12, 2011
Messages
1,801
Reaction score
240
Country
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

Top