Ecommerce invoicing and tax caluclations for multinational stores where all prices are stored as rrp with tax included

forums_noreply@adobe.com — Thu, 06 Nov 2014 17:42:22 GMT

We have a client that has a large ecommerce store with around 900 products.

The below scenario is stumping us and have found only one real work around but it requires using 3rd party apps to do the invoicing.

Any suggestions from Partners or devs that have a similar issue would be greatly approciated.

Taxation – Current prices include tax, need pricing schedule for countries

Currency 1 is $AUD and GST tax rate. Prices to be entered as inc tax. Tax deduction to calculate back from RRP
Currency 2 is £GBP and VAT rate. Prices to be entered as inc tax. Tax deduction to calculate back from RRP
Sub domains needed for each currency
Deduct the tax for none tax countries
Calculating or reporting on tax amounts for BAS

Comments

Potential is TWO currencies. Each to have RRP entered manually.
Which currency displays will depend on where customer access to website is from. AU will show for all world initially, later to be broken down as AU (for AU, NZ, Oceania, Asia,) £GBP, for rest of the world Deductions automatic for all consumer retail purchases when customer is outside

Testing
- using discount code hidden in shopping cart to detect country from drop down and then removing tax from rrp (or using JS to detect url and adding code automatically, this has been tested and is working)
- invoicing for different countries to be different
- using the api to remove the tax for non tax countries
- using api to retrieve tax summary

So far the solution we are suggesting but there might be issues with syncing with a server hosted Myob Accounting package

Specifications for SET up

Accounting package - MYOB is Account right plus. Just downloading V2014.16.7861
BC shop has about 900 products
Options for syncing data
- http://myob.com.au/addons/listing/41/transpost/
- http://www.onesaas.com/integrate/myobaccountright-with-businesscatalyst (looklike this might not work with server hosted)

Systems restrictions that we can’t get around

Invoicing - for some reason there is only one system invoice, if this was not the case we could easily set up different invoice formatting and content for each region and apply appropriate tax calculation.

Proposed set up based on findings

based on extensive consultation with Business Catalyst, reference material and testing the following configuration and management is the best solution and in some cases the only available solution to satisfy the criteria set out above.

Sub domains for regions

3 regions should be set up UK, AUS and Rest of the world. UK and Rest of the world should use subdomains while Australia would use the default domain. UK.dccconcepts.com, world.dccconcepts.com and dccconcepts.com

Displaying different currencies

Subdomains and using country drop down in the shop to direct people to the correct currency symbol and pricing.

Deducting tax from rest of the world.

As the discount system is not in use we are able to create a script that will deduct the required amount when shoppers are in this region by checking the url they are on and applying the discount. Their order total would then reflect price with the deducted amount.

Invoicing

As every order is checked manually we are proposing that the system invoice is modified to show the order total and explain that a sales invoice will be sent out once the order is finalised with tax, shipping and order modifications if required.

The order informatiuon would be sent to the accounting package via onesaas.com sync up

http://www.onesaas.com/integrate/myobaccountright-with-businesscatalyst, this needs to be further investigated to make sure it works as advertised. Or http://myob.com.au/addons/listing/41/transpost/ ( this would be a more manual process but looks like the better option for syncing with a server based myob)

You can then apply your tax, shipping and amendments and add tax exempt labels just like you do now with server hosted package to the level of detail you wish.

Reporting BAS would then be as per your normal account process.

What I find very frustration is that eCommerce is supposed to be multi currency , muti national but simple things like have a different invoice for each region created like they have with a separate shopping cart for each region and VAT, BAS and tax reporting a fundimental activity for business in all countries is lacking

Again any incites or solutions would be greatly appreciated.

Adobe Community: Message List - Ecommerce invoicing and tax caluclations for multinational stores where all prices are stored as rrp with tax included