Xero – Enable Payment/Credit Sync

Users need to set up the sync settings before they can sync for the first time. Click on Accounts>Integrations>Xero – Non-Certified>Sync Setup to get started.

 

Enable Payment/Credit Sync

  • Click on Enable Payment/Credit Sync checkbox

 

  • Configure the following accounts:

a) Payments Account. Select a ‘Current Asset’ or ‘Bank Account’ type Xero account to record received payments in. You can create a new Xero account or type ‘Current Asset’ by clicking on the plus (+) icon. NOTE: Make sure that the selected ‘Current Asset’ type account has ‘Enable Payments to Account’ enabled in Xero.

b) Credit Notes Account. Select a ‘Sales’ or ‘Revenue’ type Xero account which has ‘Enable Payments to Account’ checked, to record Write-Offs and Credit Memos in.

 

 

  • Click Save.

 

Map Accounts

  • Click on Map TimeSolv Bank Accounts to Xero Bank Accounts link.

 

  • Link up the appropriate TimeSolv Operating – Trust Default account with the Xero Operating – Trust Default Operating account, and the  TimeSolv Operating Trust account with the Xero Operating Trust account, and likewise for TimeSolv Trust account and Xero Trust account.

 

  • Click Save and then Back.

 

Review Mapping of Payments

  • Click on Review the mapping of TimeSolv Payments to existing Xero Prepayments link.

 

  • Download Excel file to review Payment mappings. Review the Excel file and look for any TimeSolv Payments being added to Xero that should match to an existing Xero Bank Transaction. Correct any mismatches in either TimeSolv or Xero and download/review the Excel file again.

 

  • Use the Confirm Mappings button to connect your TimeSolv Payments to Xero Bank Transactions.

 

  • Click Back.

 

 

Review Mapping of Credits

  • Click on Review the mapping of TimeSolv Credits to existing Xero Credit Notes link.

 

  • Download Excel file of Credit mappings.

 

  • Review the Excel file and look for any TimeSolv Credits being added to Xero that should match to an existing Xero Credit Note. Correct any mismatches in either TimeSolv or Xero and download/review the Excel file again.
  • Use the Confirm Mappings button to connect your TimeSolv Credits to Xero Credit Notes:

 

  • Click Back.

 

Map Allocations

  • Click on Review the mapping of TimeSolv Payment/Credit Allocations to existing Xero Allocations link.

 

  • Download Excel file for Allocations mapping.

 

  • Review the Excel file and look for any TimeSolv Allocations being added to Xero that should match to an existing Xero Payment. Correct any mismatches in either TimeSolv or Xero and download/review the Excel file again.

 

  • Use the button Confirm Mappings to connect your TimeSolv Allocations to Xero Payments.

 

Sync Payments & Credits

  • Click on the Sync tab.

 

  • Click on Sync to Xero button.

 

  • A live sync log will start and it will show you a full list of all payments/credits synced to Xero.

  • The live sync log only shows the most recent 50 log entries. Once the sync is finished, the user shall be able to download an excel file containing all the log entries.

Related Post