cancel
Showing results for 
Search instead for 
Did you mean: 
nsehnert
Level 2

Expenditure Report by Country

Another year working on information for the 990 and what would be so helpful would be a report of expenditures sorted by country in which the expense occurred.  Any thoughts about how to create one?

Solved
Best answer August 20, 2020

Best Answers
MirriamM
Moderator

Expenditure Report by Country

Welcome to the Community forum, @nsehnert.

 

To create the report you need, you can run the Purchases by Location Detail. It would show all your purchases grouped by location. 

 

Here's how to pull up the report:

  1. In the left menu, click Reports
  2. Go to the Expenses and vendors section and select Purchases by Location Detail
  3. Set the Report period
  4. Choose Location in the Group by field. 
  5. Hit Run report

location1.JPGlocation1.1.JPG

Take a look at this article to know more about how location tracking works: Set up and use location tracking.

 

You may also find these resources helpful:

If you have other questions about this topic, please keep me updated in the comment section. I'd be more than happy to offer additional assistance. 

View solution in original post

5 Comments 5
MirriamM
Moderator

Expenditure Report by Country

Welcome to the Community forum, @nsehnert.

 

To create the report you need, you can run the Purchases by Location Detail. It would show all your purchases grouped by location. 

 

Here's how to pull up the report:

  1. In the left menu, click Reports
  2. Go to the Expenses and vendors section and select Purchases by Location Detail
  3. Set the Report period
  4. Choose Location in the Group by field. 
  5. Hit Run report

location1.JPGlocation1.1.JPG

Take a look at this article to know more about how location tracking works: Set up and use location tracking.

 

You may also find these resources helpful:

If you have other questions about this topic, please keep me updated in the comment section. I'd be more than happy to offer additional assistance. 

nsehnert
Level 2

Expenditure Report by Country

Thank you.  I asked this same question a year ago to support and they told me it couldn't be done.

Nick_M
QuickBooks Team

Expenditure Report by Country

Hi, nsehnert. 

 

I'm happy to see you were able to find a solution. If you have any other questions, the Community is always here to help. 

 

Thank you and have a nice evening. 

nsehnert
Level 2

Expenditure Report by Country

It would be nice if you add a location to the vendor.  That would be my one request so that I wouldn't have to keep adding it each time I used the same vendor.

RCV
QuickBooks Team
QuickBooks Team

Expenditure Report by Country

Thanks for coming back. We always strive to provide the best experience with the product, nsehnert.

 

I know how beneficial it is to your business to automatically add the location feature to the vendor's profile. At this time, we can only add the Location field on forms so you can assign transactions to different locations.

 

You can visit these blogs for any upcoming QuickBooks updates and enhancements:

 

To learn more about Location feature, refer to these articles:

 

This should take you in the right direction today. The Community will always have your back if you need a hand with customizing your reports or any QBO related. Assistance is just one post away.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us