Skip to main content
S
sarasota
February 23, 2024
Solved

Find Transactions Missing a Location

  • February 23, 2024
  • 1 reply
  • 0 views

I am trying to re-classify my thousands of records (really 10,000+) with the proper Location.

 

It’s been a grind. Anyway, I’m sure I’ve missed some along the way.

 

Is there a way I can find all transactions missing a value for Location?

Best answer by AdonL

I'm glad you've posted here in the Community, sarasota. Let's work together to find your transactions.

 

Are you trying to use location tracking to track your transactions? QuickBooks Online (QBO) has certain reports you can run to view your entries with or without locations.

 

To achieve this, you can generate a Profit and Loss by Location report and adjust the location filter to Non-specified. Here are the steps:

 

  1. Go to the Reports menu.
  2. Search for Profit and Loss by Location report and open it. 
  3. Click  Customize.
  4. Select Filter and check Location.
  5. On the dropdown arrow, choose Not Specified.
  6. Hit Run report.

 

Once done, click Total Income or Total Expenses to view transactions without assigned locations. I've included some photos below for your reference: 

 


 

 

Also, to monitor sales without assigned locations, run a Sales by Location Detail report and use the Non-specified filter option.

 

 

Finally, I've included these helpful articles so you get the most out of your financial reports and have great information about your business:

 

 

Please know that you're always welcome to swing by if you need further assistance finding missing transactions in QBO. Have a good one!

1 reply

A
AdonLAnswer
February 23, 2024

I'm glad you've posted here in the Community, sarasota. Let's work together to find your transactions.

 

Are you trying to use location tracking to track your transactions? QuickBooks Online (QBO) has certain reports you can run to view your entries with or without locations.

 

To achieve this, you can generate a Profit and Loss by Location report and adjust the location filter to Non-specified. Here are the steps:

 

  1. Go to the Reports menu.
  2. Search for Profit and Loss by Location report and open it. 
  3. Click  Customize.
  4. Select Filter and check Location.
  5. On the dropdown arrow, choose Not Specified.
  6. Hit Run report.

 

Once done, click Total Income or Total Expenses to view transactions without assigned locations. I've included some photos below for your reference: 

 


 

 

Also, to monitor sales without assigned locations, run a Sales by Location Detail report and use the Non-specified filter option.

 

 

Finally, I've included these helpful articles so you get the most out of your financial reports and have great information about your business:

 

 

Please know that you're always welcome to swing by if you need further assistance finding missing transactions in QBO. Have a good one!

    S
    sarasotaAuthor
    February 23, 2024

    Wow @AdonL, hell of a response! Location = Unspecified is genius!

    M
    MelroseV
    February 23, 2024

    Hello, sarasota.

     

    We in the Community are happy that you were able to find my colleague's post helpful and able to resolve your issue. We're more than happy to help you if you need more assistance.

     

    If you need tips and resources to manage your QuickBooks Online account and finances, feel free to visit our Support page to learn more. This provides information to help your navigation experience be more effective.

     

    Keep us posted if you have other questions or concerns. I’m here to help you out. Take care and have a great day!

    Terms & ConditionsAccessibility statement