Revel to Xero and Quickbooks daily sales invoice
DSYNC can organize a daily sales sync with both Quickbooks and Xero. We have however come across a challenge where the Revel system is unable to split the taxed/un taxed at a product class level.
The challenge we see is with taxed/untaxed only – when we are extracting the data the information is not split and does not identify which product class the tax is/is not on.
So, for example the invoice has 2 classes of products which need to go to different QB or Xero accounts (different tax) then it's a problem we are unable to correctly assign.
If you know one product class to assign the untaxed to then you can apply a default using DSYNC
This workaround we have implemented for some clients where we can default one product class to be assigned the total tax amount and it is deducted on the invoice.
Example: we get the 'untaxed' total from Revel (which is combined for all payment types and classes) and subtract that total from one of the totals split by product class.
On the invoice, you will then have one line per product class, plus one line for 'untaxed' sales. And the untaxed sales total will be deducted from one of the other lines on the invoice
Here is an Example
2 product classes: hot drinks, cold drinks
hot drinks sales: $5000
cold drinks sales: $300
untaxed sales: $150
... invoice then would have three lines as follows:
hot drinks $4850
cold drinks: $300
The correct product class to apply can be narrowed down ... For example in Australia, only water is exempt so if you have split by product class and know that water is in cold drinks you would take it out of the cold drinks. If you have untaxed items in multiple classes then unfortunately it does not identify by product class how much comes out of each class