View transaction discrepancies
Transactions are typically locked in Sage Construction Management after being exported to QuickBooks Online (QBO). However, these transactions can still be modified in QBO, 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 QBO total is correct.
- Bills
- Sub invoices
- Miscellaneous expenses
- Prime invoices
- Go to Accounting Link and select Sync > Discrepancies.
The discrepancies page displays the Sage CM Amount and the respective QuickBooks Amount for bills, sub invoices, miscellaneous expenses, and prime invoices.
For bills, sub invoices, and prime invoices, you can also access the Discrepancies function using the appropriate link under the Accounts Payable (AP) or Accounts Receivable (AR) tab. - Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Go to Accounting Link and select Sync > Discrepancies.
- Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Select the transaction to remove permanently from the appropriate list and select Remove From List Permanently.
- Go to Accounting Link and select Sync > Discrepancies.
- Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Select Export To Excel in the appropriate section.