View transaction discrepancies
Transactions are typically locked in Sage Construction Management after being exported to Xero. However, these transactions can still be modified in Xero, which can potentially cause a discrepancy. To maintain consistency between the systems, Sage Construction Management provides the Discrepancies function in the Sync tab.
This function analyzes exported transactions and provides a list of transactions where totals do not match. You can rectify the discrepancies as needed, as the AccountingLink does not identify if the Sage Construction Management total or Xero total is correct.
Transactions reviewed for discrepancies
- Bills
- Sub invoices
- Miscellaneous expenses
- Prime invoices
The Accounts Payable (AP) and Accounts Receivable (AR) tabs offer a Discrepancy function that allows discrepancies to be reviewed by transaction type.
View discrepancies
- Go to Accounting Link and select Discrepancies under the Sync tab.
The discrepancies page displays the Sage CM Amount and the respective Xero Amount for bills, sub invoices, miscellaneous expenses, and prime invoices.
- Optionally, update the From Date and To Date to filter the results by date as needed.
Remove discrepancies permanently from the list
- Go to Accounting Link and select Discrepancies under the Sync tab.
- Optionally, update the From Date and To Date to filter the results by date as needed.
- Select the transaction to remove permanently from the appropriate list and select Remove From List Permanently.
Export discrepancies to Excel
- Go to Accounting Link and select Discrepancies under the Sync tab.
- Optionally, update the From Date and To Date to filter the results by date as needed.
- Select Export To Excel in the appropriate section.