Question Submit

Wednesday, June 22, 2005

Balance Sheet Problems.


I have having problems creating an accurate balance sheet. I have used QB for several years but, I have not needed to create balance sheets with it. Unfortunately, now I do.

Under current assets, all of the amounts showing up with the exception of National City Bank should be zero. How do I eliminate these amounts?

The accounts payable should be zero. How do I eliminate this balance?

Total current Liabilities should also be zero. How do I eliminate this entry?

Opening balance equity is $16,000. How do I make the report show $16,000

Retained earnings should also be zero. How do I eliminate the retained earnings amount?

This company is an LLC which I purposely keep to a minimum of assets for liability reasons

Thanks for your help.



Your question is difficult, without knowing your situation. I would urge you to talk to your accountant.

Assuming that all current assets should in fact be zero, you will need to find out what is in those accounts.

To do this open a "Balance Sheet Standard" report, and click modify report. In the window that appears, change the dates to beginning of your company’s existence or some date way in the past such as 01/01/1975 to today's date.

Now look at the current asset accounts that are on the balance sheet. Double click on the ones that should be zero. You will be given a list of transactions that make up your balance. You can either reclassify them at the transaction level by double clicking them again or make a journal entry to reclassify them.

Again, I can't recommend any of this...especially if the transactions in the current asset account are from prior years. (This could create a current year tax problem if they were assets on your prior years returns). But this is how you would do it from a QuickBooks operations standpoint.

As for opening balance equity, this is an account created by QuickBooks when you open an account that has an existing balance. Generally this account should be zero. Many times it is capital or retained earnings.

Retained earnings should in fact have a balance if you have been in operation for more than a year and have either a collective profit or loss.

As you can see there are many issue involved, however it shouldn't take a CPA long to correct it to your specifications and within the constraints of the law. This would be money well spent.

No comments: