Solved

Is it possible to extract sales per country and also to have a way to precisely separate Home, vs EU, vs rest of world Sales ?

5 replies
20 views

No text available

QuickBooks Online

G

GeorgiaCAnswer

Level 13

Hi Bipouet_fr,

The only way to do this would be using the Location tracking feature in QuickBooks Online Plus.

You could set up different areas and countries as locations and create sub-locations to group these, for example:

Location: Europe - Sub-account: France.

Location: Rest of world - Sub-account: Malaysia.

You would assign the location from the drop-down on the location field when entering transactions.

You can then run location-specific reports such as Profit and Loss by Location, Purchases by Location Detail, and Sales by Location detail.

You can see more about using locations on our guide here.

G

GeorgiaCAnswer

Level 13

Hi Bipouet_fr,

The only way to do this would be using the Location tracking feature in QuickBooks Online Plus.

You could set up different areas and countries as locations and create sub-locations to group these, for example:

Location: Europe - Sub-account: France.

Location: Rest of world - Sub-account: Malaysia.

You would assign the location from the drop-down on the location field when entering transactions.

You can then run location-specific reports such as Profit and Loss by Location, Purchases by Location Detail, and Sales by Location detail.

You can see more about using locations on our guide here.

B

Bipouet_frAuthor

Thanks for the info,

I can see it working if you are doing your invoices manually. I use QBO as part of an integrated system. QBO just get the information fed from the other software. This solution would need to go back in each single invoice and make the necessary amendment.

I find it bizarre that though the location is not simply attached to the custumer directly instead of the invoice as each invoice is attached to the customer. It would be registering silencely all locations once setup within the customers main page. That solution would actually be working for everybody. It would avoid data entry mistake by clicking on the wrong location, especially if several sub location would be created...

Location to the customer directly would be magical in this circumstance. I cannot really see the benefit of adjusting the location at the time of the invoice either.

G

GeorgiaC

Level 13

I agree this will only really be a solution if you were manually entering the invoices, and won't work from an integrated stand-point.

It certainly would be handy if we could programme to pull this data on a report from the already entered customer-details - I'd suggest leaving it as feedback by going to the Gear icon > Feedback within your account. This will go directly to the product engineers and may be implemented into a future update if possible.

The only work-around for this at the moment would be to filter the sales report to specify which customers are included by going to Customise > Filter > Customer > Select specified customers and save the individual report customisation to allow comparison. I appreciate that this would be time-consuming however depending on the volume of customers.

Sign up

Login with SSO

Let's get you signed in

Login with SSO