Objective
Posting a register closure returns an error 'The Retail POS tax rate on one of the products in this sale has a tax type (expense or income) assigned in Xero that doesn't match the account code 'X’s tax type'. Find the product causing the error.
Setup
- Retail POS for Mac or PC
- Xero integration
Steps
Using register closures
- In Xero, check the tax rate of the account that is cited in the error message
- Click Reporting
- Click Register Closures
- Click the register closure that will not post over
- Click View Full Details
- Click each sale to see the tax rates applied on the sale
- Find the product with a tax rate that does match the tax rate of the account cited in the error message
Using a CSV
- In Xero, check the tax rate of the account that is cited in the error message
- Click Products
- Click Export List
- Filter the account_code column for products that use the account code cited in the error message
- Filter the tax column for products that also use a different tax rate than the account they are mapped to
Additional Information
Can I view a breakdown of my register closures?
How to apply a filter in Open Office