QuickBooks HelpQuickBooksHelpIntuit

Run a balance sheet by class or location in QuickBooks Online

by Intuit5 Updated 3 months ago

Find out how to filter a balance sheet by class or location in QuickBooks Online.

Before you run your balance sheet report by class or location, it's good to know which part of the transaction QuickBooks gets the data from. This will help you determine the accuracy of your report. We'll explain to you how.

If you want to see more filters or format the layout, here's how you can customise your reports.

Header and detail

Every transaction is separated into 2: the header and the detail. For example:

 Transaction Type HeaderDetail
 Cheque Bank accountExpense item (or any other item you choose)
 Invoice Accounts receivableIncome (or any account) linked to the product/service

Depending on the type of report you run, QuickBooks uses info from the headers or details. For example, the balance sheet uses data from headers, while profit and loss uses data from the details.

If you assign classes and locations to your transactions, you can customise your balance sheet and profit and loss to show data for a specific division. But remember:

  • Classes are only linked to details.
  • Locations are linked to both headers and details.

Filter by class

You can’t filter your balance sheet by class since headers aren’t linked to classes. However, you can filter your profit and loss by class since details are linked to classes.

But I can display columns by classes for my balance sheet.

You can, but it wouldn’t be accurate. The headers (example: Accounts Receivable, Accounts Payable) aren’t sorted by the class you assigned them to—they’re under “Not Specified”.

Filter by location

Unlike filtering by class, you can filter both your balance sheet and profit and loss by location because when you save a location on a transaction, it's linked to both the header and detail.

To filter a balance sheet by location:

  1. Go to Reports (Take me there).
  2. Find and open Balance Sheet.
  3. From the Display columns by ▼ dropdown, select Locations.
  4. Select Run report.
 Transactions under "Not Specified"
  • Your Accounts Receivable, Accounts Payable, or Payroll transactions might have amounts under “Not Specified” because their related transactions (Receive Payment, Pay Bills) can’t be split into different locations. If the related transactions need to be split into different locations, you can divide the transaction based on location or use a journal entry to record them.
    Note: We recommend contacting your accountant to help you out with splitting transactions.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.