Issue: When exporting a journal from Active Ledger or an Active Workpapers binder back to the source file (e.g., Xero, MYOB, QBO, etc.), users may find that their balances are incorrect by the amount of the exported journals.
Cause: When journals are exported back to the source, their impact on the trial balance amounts is removed in both Active Workpapers and Active Ledger.
Resolution:
For Active Ledger, we automatically trigger the “Load Data” button. If this fails to trigger, ask the user to manually click "Load Data" for their relevant dataset.
For Active Workpapers, the user needs to manually re-import the trial balance after exporting the balancing journal.
For Active workpapers, use this canned response:
Title:
Active WP - TB out by exported journal back to source
Message:
"Thank you for your ticket. When journals are exported back to the source, their impact on your trial balance amounts is removed. This is done with the expectation that when you re-import your trial balance, the exported journals will be retrieved from the source, preventing any duplication of amounts.
Additionally, if you have columns enabled for 'adjustment journals', you can see the movements of the balance shift from the 'Adjustment' column to the 'Imported' column. However, this requires you to click the 'Reimport Trial Balance' button.
Once you reimport your trial balance, your balances should be accurate, as the exported journal values will now be pulled from the source."