Setting up locations in QuickBooks Online.

Keywords: Location, Reporting, Quickbooks

Credit: Intuit- Quickbooks Online  Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Before locations can be used in QuickBooks Plus or Advanced, they must first be enabled in Account and settings. For each location, you can add up to four levels (tiers) of sub-location, allowing for a total of up to five hierarchical levels, including the top-level (parent) location. However, there’s no limit to the number of locations and sub-locations you can create at each level. As mentioned previously, the usage limits for classes and locations are combined. In QuickBooks Online Plus, up to 40 classes, sub-classes, locations, and sub-locations can be created. In QuickBooks Online Advanced, unlimited locations (and classes) can be created.

Enabling locations

Getting started with locations is pretty straightforward. As with classes, to enable location tracking, head to the Advanced section of Account and settings, and toggle the switch. There is one other setting relating to locations in Account and settings: Location label. This dropdown allows you to change the label of the Location field throughout QuickBooks. Depending on you, and how you are using the Location field, you may wish to change this. For example, for a retail customer you could change Location to Store.

Note: changing the label doesn’t make any functional changes within QuickBooks, but it does change the label wherever it is used, including on reports.

Using locations in QuickBooks Online.

The locations list

Now let’s look at how locations can be used once they have been enabled. Locations can be created and managed in the Locations list from the All lists menu, accessed from the General settings gear. As with all categorization work for you, you’ll need to think carefully about the structure of their business and the levels they need to get the information they want. There’s a fine art to getting the right amount of detail in a report, but taking the time to get this right at the outset makes things much easier later. How you set up locations directly impacts reports, so think carefully about the hierarchy you set up for yourself.

To add, edit, or view locations, go to the Location list, accessed from All lists in the General settings gear. Here you’ll see a list showing all active locations. This list is presented alphabetically. If you would prefer it ordered a different way, you can control how locations are ordered by prefixing the location name with numbers.

To create a new location, select New, then give the location a unique name. If it’s a sub-location, check the Is sub-location box, then select the parent location from the dropdown. If your business operates with a different name, or requires different contact details depending on the location, these options can be selected and new details entered. This will change the details on sales forms, such as invoices, for this location.

Selecting Run report in the Action column opens a Quick Report which shows all transactions the location has been applied to. Selecting Run Report at the top of the screen (next to the New button), opens the Location report, detailing the structure of the locations that are active. The dropdown menu in the Action column of a location allows you to edit it, or make it inactive. Inactive locations don’t count towards usage limits.

As in the classes list, the Printer icon lets you print a list of all locations, and the List settings gear allows you to view inactive locations.

Using locations for different entities

Location tracking is designed for tracking the performance of different locations within the same business. You may find that you have someone that also uses it to track different entities too-although this was a more common scenario before QuickBooks Ledger was released.

If any of the entities use, or plan to use, additional QuickBooks products that use the company’s tax ID ( such as QuickBooks Payroll or 1099 e-filing), then using locations to track entities is to be strongly discouraged, as only one tax ID is associated with each QuickBooks account.

It’s best to avoid the complications of using locations to separate different entities, and with the low cost of QuickBooks Ledger, this could be a more efficient solution.

Assigning locations to transactions

Now let’s take a look at how to assign locations to transactions.

Adding locations to individual transactions

Adding a location to an individual transaction is simple. Select the relevant location from the dropdown list, or add a new one.

Adding Locations to multiple transactions

It’s also possible to use the Reclassify transactions tool to add or change the location of multiple transactions at once.

It’s worth remembering however, that the Reclassify transactions tool makes changes at the target line level, and locations affect the transaction source.

In practice, this means that if you make changes to the location of a single target line using the Reclassify transactions tool, any other target lines on the same transaction will also be updated, so use it carefully.

Assigning locations to bank transactions

As with classes, locations can be added to bank transactions using bank rules, or individually as you review transactions in the For review tab of the bank feed.

To see any locations added by bank rules, make sure that Locations is selected in the List settings gear.

Assigning locations using journal entries

Journal entries are the only transactions that allow you to add multiple locations. They don’t have a source, but every line on a journal entry is a target. Because of this, it’s important to remember that all lines on a journal entry that adjust a specific location should balance in order for the balance sheet to remain in balance. So you must debit and credit the same total amount to a particular location on a journal entry.

You could also use journal entries when you need to add more than one location to a transaction.

Handling bills covering more than one location

All transactions can only have one location associated with them in QuickBooks. Your businesses might not be that simple however, and sometimes bills will be received that are related to multiple locations. Accounts payable activity is usually recorded through bills and bill payments. Because bills have a location field, the bill payment transaction (which has no location field) picks up the location of the bill being paid. If a bill payment is applied to multiple bills that have different locations, or if the location is assigned to the bill after the payment has been made, then the location data in QuickBooks is likely to become incorrect. To avoid this, filter the Pay Bills screen for one location at a time, allowing you to show only bills due for each location. Then pay bills for each location individually. If the actual payment needs to be for the total amount due to the vendor, record multiple payments in QuickBooks Online and match those payments to the actual payment when it comes through in bank feeds.

Locations and billable expenses

If billable expenses are added to an invoice, the payment won’t show a location if:

  • The expenses don’t have a location on the original expense, or
  • They have a different location than the location on the invoice

All billable charges show in the customer’s invoice drawer. But you can’t see the location in the drawer, so you need to open each billable charge to see what location it was for. Then you can decide whether to pull the billable charge into the invoice you’re creating for this location.

Alternatively, you can run an Unbilled Charges report with Location as a default column.

Consistency is the key

If a location isn’t specified in a transaction, you’ll see these amounts in the Not specified column when you run a report. However, you won’t know whether the location wasn’t assigned by mistake or intentionally. That’s why you should use location tracking ( or any method of advanced categorization) consistently once you start using the feature. And remember, with location, there is no setting to warn you if they leave the field blank. If you’re using any connected apps that sync data to QuickBooks, explore whether they sync data to/from the location category. Any third-party apps that use QuickBooks online platform would call this category the Department Ref field. If you’re unsure, you can always contact the app provider and ask whether that field is part of their app integration.

Reporting with locations in QuickBooks Online.

There are several reports in the Reports center set up to make it easy to get insights based on location data:

  • Location List
  • Profit and Loss by Location
  • Sales by Location Summary
  • Sales by Location Detail
  • Purchases by Location Detail

Like the class reports, these reports contain predefined groups and filters to show commonly used information about classes. Most reports, however, can also be grouped or filtered by location to add an extra dimension of detail to your reports.

Locations and financial reports

Now let’s consider what insights running the financial statements by location can bring.

Profit and Loss by location

The Profit and Loss by Location report shows you all the transactions assigned to a particular location—and tells you how each location performed compared to others.

Transactions with no location are listed in the Not specified column. If there are no

transactions for a particular location in the reporting period, that location won’t appear on the report.

You can use filters to show only specific locations, allowing you to create a profit and loss for each location, if required. Just remember to save the custom reports with separate names to make them easy to find.

Customized balance sheet report

There is no default “Balance Sheet by Location” report. However, because locations affect the source of the transaction, you can customize a Balance Sheet Report to show locations by choosing Locations from the Display columns by dropdown.

This can be a quick way of showing assets and liabilities by location. For example, you could use this to provide yourself with useful information about inventory levels at different locations.

Example use of locations

Let’s look at an example of how locations could be used to provide details about a business run from different locations. Landscaping by Joshua, has opened some new branches, and Josh wants to know how each of them compare.

Set up

Locations are enabled in Account and settings. “Location” is an accurate description, so the Location label doesn’t need to be changed.

Creating locations

Each location is added to the Locations list, accessed from All lists in the General settings gear.

Two parent-level locations are created:

  • Smalltown
  • Large town has two branches, so these are set up as sublocations:

Largetown has two branches, so these are set up as sublocations:

  • North
  • South

Assigning locations to transactions

All existing transactions have locations added using the Reclassify transactions tool.

Joshua’s team makes sure to add the locations to any transactions added to QuickBooks.

Running a Profit and Loss by Location report.

Josh can use the Profit and Loss by Location report to show how each of the branches are performing. He likes to see this regularly, so it’s saved with a unique name in the Custom reports tab of the Reports center, and is scheduled to be sent to him every two weeks.

Customizing the balance sheet

Two custom balance sheets are created and saved. One shows the balance sheet for just the Smalltown branch. The other shows the balance sheet for the North and South branches in Large town.

Schedules are created to share these monthly with regional managers.

Check out our Free Additional Articles