[hmaevilla]

I think I need to brush up on this ability. Can anyone give me pointers of how to go about doing this in a table format? On the left there would be cash balances and the right the accrual balances. In the middle are to be debits and credits to either increase or decrease accounts. This format for conversion is foreign to me with all the GL accounts shown as an example but think this is an area that I need to brush up on. I have always seen questions that provide the Income Statement and Balance Sheet in Cash format and worked from those numbers to achieve the accrual income and balances.

I think I am just gonna have to try to create my own general ledger cash system in Excel and then add in the extra boxes to convert. Doing it this way seems so weird to me but more like something one would get in real life I suppose.

Help if you have any examples or suggestions.