Expenditure Report by Country

nsehnert · ‎August 20, 2020

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?

MirriamM · ‎August 20, 2020

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:

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

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

MirriamM · ‎August 20, 2020

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:

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

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 · ‎August 24, 2020

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

Nick_M · ‎August 24, 2020

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 · ‎August 24, 2020

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 · ‎August 24, 2020

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.

Topics

Training

Community

Resources

Expenditure Report by Country