Skip to main content
L
lschurchf
August 10, 2022
Solved

Is there a work around the problem where the balance sheet doesn't allocate the bank balance by classes? Is there an alternative to classes to avoid this issue?

  • August 10, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by Angelyn_T

I appreciate you for getting back, @lschurchf. I can share with you some additional information about categorizing bank transactions into different locations.

 

You can split your deposits into different locations by selecting the desired location under the Show payments for this location dropdown menu. I'm adding this screenshot for your visual reference.

 

For deposits with a different location, create a new transaction from the +New icon, then follow the same steps to set the location. You can learn more about bank deposits from this article: Record and make bank deposits in QuickBooks Online.

 

When running your report, your deposits will be classified into different locations.

 

If you have follow-up questions about your deposits or reports, leave a comment below. I'll get back to you as soon as I can help you again. Keep safe!

1 reply

Angelyn_T
Angelyn_T
August 10, 2022

Hi, @lschurchf. Yes, you can use location tracking as an alternative to classes when classifying your entries. I'm here to guide you on how.

 

When running a report, QuickBooks Online (QBO) uses the information from the report's headers or details to show data for a specific division. The Balance Sheet uses data from headers and classes are only linked to the transactions' details. In your case, you may categorize your entries by location since it's linked to both.

 

You can learn more about this feature from this article: Set up and use location tracking.

 

When you run your report, follow these steps:
 

 

  1. Click on Reports on the left pane, then open the Balance Sheet Detail report.
  2. Make the necessary customization.
  3. Tap on the Gear or Settings icon beside Export.
  4. Tick the box beside Location.

 

For additional resources while running your report in QBO, check out this link: Run a balance sheet by class or location in QuickBooks Online. 

 

The system also allows you to export your reports to Excel if you want to use them outside of QuickBooks or alter more customizations. Here's your guide: Export your reports to Excel from QuickBooks Online.

 

You can always leave a comment below if you have any other questions about your Balance Sheet report or bank balances. I'm just a few clicks away to help. Have a good one!

L
lschurchfAuthor
August 11, 2022

Thank you, I will give it a try

Terms & ConditionsAccessibility statement