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:
|Cheque||Bank account||Expense item (or any other item you choose)|
|Invoice||Accounts receivable||Income (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:
- Go to Reports (Take me there).
- Find and open Balance Sheet.
- From the Display columns by ▼ dropdown, select Locations.
- Select Run report.
| Transactions under "Not Specified"|