Link perfectly reconciles each night to what is in your XPM so any variances exist between XPM and Xero (blue). The five most common causes for these in order are:
- 'Misc invoices': Xero invoices that fail to sync to a job.
Here's how to find them: Xero to XPM Invoice Reconciliation Report
These misc invoices can be deleted from XPM and immediately re-synced using these steps: Re-syncing Xero invoices to XPM Jobs - Credit Notes: Credit notes never sync from Xero to XPM so are always excluded from any XPM invoice subtotals. I believe its to do with XPM not accepting negative values on an invoiced disbursement.
Here is how to handle credit notes in XPM: Credit notes in XPM - Xero (blue) invoice dates being edited after XPM invoice approved
This won't affect an invoice subtotal but will when comparing two periods. These invoices need to be deleted in XPM and re-created with the correct date. - Xero (blue) invoice amount different to invoiced value as approved in XPM:
These invoices also need to be deleted in XPM and re-created. The invoice sync is two-way but not for 'updates' or changes to existing invoiced values or dates (invoice descriptions can be added to in Xero blue after approval in XPM). - XPM invoice date edited
For some reason it's possible to edit an XPM invoice date after approval. While this might move the invoice in XPM, and you can simultaneously update the correct date in Xero (blue), it will not update the date of the invoice records as posted to the WIP Ledger. This is a problem because the WIP ledger is the basis for all reliable reporting.
Comments
0 comments
Please sign in to leave a comment.