Overview: This article helps users troubleshoot scenarios where their Debtor or creditor balances in Active workpapers does not match with debtor or creditor balances in Xero.
Step-by-Step Resolution Process
Open your binder and navigate to Settings cog > Binder Details. Verify that the dates on the binder align with the desired dates for creditor/debtor reports in your source file.
Next, in Settings > Edit Columns, ensure that the primary column dates also align with the creditor/debtor reports in your source file.
Refresh your trial balance in Active by clicking "Reimport All Columns" on the trial balance screen.
Then, open the debtor/creditor workpaper, press the three dots next to the debtor/creditor workpaper in the side panel, scroll down, and click "Execute" under the command section.
If the issue persists, please let us know, and we can give you a call to troubleshoot further.
Possible Reasons for Out of Balance or Missing Debtor/Creditor Data
Use of prepaid transactions (e.g., payment on an invoice is in the current FY, but the invoice date is in the next FY).
Overpayment transaction issues: If there is an overpayment transaction but there is no invoice attached to the overpayment transaction for that same customer. This scenario may occur if the customer name on an overpayment transaction is changed after it has been created under the original customer. Similar to point 1, if the overpayment transaction is not in the same period as the invoice, it can also cause a discrepancy. As in our system debtors are queried based on invoices first.
Note: If any of the above scenarios apply, this is the software working as intended to flag these debtor/creditor discrepancies, allowing the end user to address them in their source file.