cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
andy-mcwilliam
Level 3

Possible Bug? Handling of Classes on Cash Accounts

Hi,

 

Either I am not doing something right, or I think there is a bug in the way QBO handles Classes, specifically in the reporting of Cash Accounts on the Balance Sheet. 

 

Once I have Classes switched on then I have to specify a Class in every transaction, which I do. Say I make a £100 expenditure from my current account and charge that to an expense account called Food, and I tag that transaction with Class General. My P&L report will correctly show an expense against category Food and will tag that transaction with Class General. But when I run the Balance Sheet, with a column for each Class, the reduction in the current account balance will not be shown in the General column, but in an Unspecified column.  (The equivalent thing happens with income accounts too.)

 

To sort this out I have to do multiple journal entries at the end of each month in order to clear out the Unspecified column and get the correct values into the correct Class columns. A real hassle, a waste of time, and easy to get wrong.

 

If you think of an income or expense transaction as a balancing double-entry journal, then it appears that the income/expense account is being tagged with a Class, whereas the cash account is not. Or, if both sides are being tagged, then QBO is losing/ignoring the Cash account Class tags when building the Balance Sheet.  Interestingly accruals (eg income in advance) are reported correctly in the Balance Sheet. The problem seems to relate just to Cash Accounts.

 

Please tell me where I am going wrong, if I am. Or fix the bug.

 

Thanks,

 

Andy

 

1 REPLY 1
JonpriL
Moderator

Possible Bug? Handling of Classes on Cash Accounts

Hello @andy-mcwilliam,

 

You've done nothing wrong. Let me share information on how an assigning of classes in a transaction affects the data in each of your financial reports.

 

To start with, creating an expense transaction lets you assign classes in each row along with the affected category or item of the purchase. Now, your Profit and Loss report displays its data based on the created transaction detail (each row of your transaction). Whereas, your Balance Sheet report displays its data based on your transaction summary (entire transaction).

 

With this, even if your cash expenditure is posted in the class category of your Profit and Loss report, it will show up as an unspecified class in your Balance Sheet report. To learn more about how your reports display your transaction, here's an article you can read for reference: Targets vs. Sources overview.

 

Lastly, I've also included this helpful article for the steps in changing the columns and adding or removing names or accounts to display in your reports: Customise reports in QuickBooks Online.

 

If there's anything else that I can help you with, please let me know in the comments. I'll be here to lend a hand.

Need to get in touch?

Contact us