Author Topic: Shipping fees and bookkeeping software  (Read 187 times)

cback

  • Beginner
  • *
  • Posts: 6
  • A beginner
Shipping fees and bookkeeping software
« on: June 18, 2018, 09:39:45 am »
Hi all, sorry I have no idea if this is the right place to post or even if anyone here can help but am desperate so will give it a go :)

My bookkeeping software is Acumulus and the consumer invoices are automatically sent there which is great.  Problem is, that the shipping fees are being booked as not having to be taxed with our 21% VAT.   I have looked at the settings for the batch processing of the invoices (sending to Acumulus) but there is nothing related to it there.   Setting tax rules for the shipping costs themselves is not relevant as this just adjusts the costs on the invoice itself.  So my issue is purely about how the shipping costs are being booked in Acumulus.

Does anyone have any ideas on how to do this?  VAT needs to be paid on the entire invoice amount, including the shipping costs so that's the problem right now.  Since the beginning of 2017 the bookings have ended up elsewhere, where they shouldn't be.

If this is not something that needs to be done in Virtuemart then I will turn to the bookkeeping software helpdesk. 

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7780
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Shipping fees and bookkeeping software
« Reply #1 on: June 18, 2018, 10:17:05 am »
Without seeing the bridging software it is impossible to say but if you set your shipping costs to be taxed then the order_shipment and order_shipment_tax are both recorded within the VM orders table.
It then is possible to get the figures you require so it will be your bridging software that isn't doing it properly
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

cback

  • Beginner
  • *
  • Posts: 6
  • A beginner
Re: Shipping fees and bookkeeping software
« Reply #2 on: June 18, 2018, 10:54:51 am »
Thank you kindly for your reply.  Where do I find out what the bridging software is?  And where do I find the VM orders table?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7780
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Shipping fees and bookkeeping software
« Reply #3 on: June 19, 2018, 01:06:57 am »
Quote
Where do I find out what the bridging software is?

only you can know this .. is is what ever script/software joins VM to your billing/accounting software

the table is #__virtuemart_orders
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation