XERO Integration - Mapping Rent Book charges of type OTHER to custom chart of accounts

XERO Integration - Mapping Rent Book charges of type OTHER to custom chart of accounts

Currently this is not supported through the platform. The only work around is for the client to manually do this with £0 balance invoices to move money from one chart of account to another. See the guide below.

Preparation

  • Create a suspense/clearing account just for this purpose
  • Pull the latest chart of accounts into the XERO synchronisation
  • Map them under Chart of Accounts mapping for rent book item OTHER

For each invoice

STEP 1 - Find the invoice in XERO (the one COHO created to your generic OTHER chart of account), you want to allocate and copy it.



STEP 2 - You will need to duplicate the line item on the invoice and make the initial one a negative number (so you are taking money out of the suspense account).



STEP 3 - Approve this invoice confirming a £0 balance (aka, no payment is expected on a bank account for this invoice)



STEP 4 - Review your profit & loss to see the money moved to the correct chart of account.