Skip to main content

How to troubleshoot Debtor or Creditor Workpapers incorrectly calculating GST

To assist users in fixing GST when calculated inccorrectly on the Debtor or Creditor Workpapers.

Updated over 3 weeks ago

Issue

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.

An example of a Xero bill:​
​

An example of the corresponding 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.


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.

Did this answer your question?