Overview: Users may encounter an issue where GST is automatically calculated when importing GST-free invoices or bills from their source system (e.g., Xero) into a Debtor or Creditor Workpaper in Active. This can also occur when the GST values in Xero differ from those imported into the Creditor or Debtor Workpapers in Active.
Xero Bill:
Active Creditors Workpaper:
Cause
This behaviour is due to current limitations in both the Xero API and our system, which do not fully support the accurate import and computation of GST values.
For the debtor/creditor workpapers, GST amounts are automatically calculated based on the formulas in the "GST Calculated" column within the workpapers. This column will allow manual adjustments where needed.
Workaround/Resolution
To reconcile GST values accurately, users should refer to debtor/creditor reports available in Xero and manually adjust the GST amounts directly within the workpapers if discrepancies are identified.