Xero and Finsit

Connecting a Business to Xero

1.    Click onto to the relevant business 
 
2.    Click on Connect 
 
3.    Select Bookkeeping Product below Source of Data
4.    Select Xero from the list of Bookkeeping Products

 
5.    Select the relevant Business Type from the list
6.    Select the description from the list of SIC codes
7.    Click Connect. This will launch the external Xero account.
8.    Select the relevant organisation from the list 

 
9.    Click on continue with 1 organisation Did not ask me to enter my user credentials
10.  Enter your user credentials such as Email and Password

 
11.    Click on Login
12.    Select the relevant Organisation
13.    Click on Allow Access

Overview 

The Overview screen displays information such as:

• Bookkeeping integration status – when the data was last synchronised
• An option to launch Xero directly from CCH Open Integration
• An option to synchronise the data on demand
• An option to discount the data from Xero
• Financial category mappings – in this example indicating that all nominal codes have been mapped 
• An option to launch finsit the advisors financial reporting tool

Mappings 

The mapping screen is only applicable to quarterly reporting (MTD) for income Tax and finsit the advisors financial reporting tool.  The mappings for the production of the accounts are stored within CCH Accounts Production.  

• Standard mapping files are provided for Xero
• These mappings display the financial reporting category that each nominal code from Xero Bookkeeping Data will be mapped into for HMRC quarterly reporting and finsit 

Data Tab

• Change the date range to view transactions for a given period
• Once connected to Xero, the data will be synchronised automatically.  The data is then updated each evening displaying all daily transactions within the specified date range.

Checking the Status 

View the status of imported data, successes and failures.  View data which has been synced on demand and by whom

• If Accounts with no Code is displayed under Error message, this is due to Bank Accounts in Xero not having a nominal code.  These will need to be added in order to be able to synchronise the data. 

Sync on Demand

Disconnecting a Business from Xero

Click on the Disconnect button to discount a business from Xero, or this can also be done via the Overview tab

Within the Accounting period click on Sync. With Open Integration 

• You have a choice to either synchronise transactions or trial balance

• The first time the data in synchronised into CCH Accounts Production the mapping will default to none, this is because if you have created your own bespoke chart within Xero which uses the same codes as CCH Accounts Production, then no mapping is required.
• If you want to select for example Xero Limited to FRS 102 or a bespoke client mapping, then this can be done by clicking on the down arrow next to the mapping name.
• If the new unincorporated Master Pack is in use, then the mapping will be shown as in the screen below.

Synchronising Transactions

 
1.    Select transactions as shown in the above screen shot

• Sync. With Open Integration displays the 'Total' number of transactions that are available to be synchronised from both CCH Accounts Production to Open Integration and Open Integration to CCH Accounts Production
  
• The Errors and Exception panel also displays the 'Total' number of transactions that are available to be synchronised from both CCH Accounts Production to Open Integration and Open Integration to CCH Accounts Production.
  

2.    Click on Synchronise

3.    Click on OK

4.    Click on Yes
5.    Click on Synchronise

 
6.    If prompted, select the relevant nominal code/codes to be mapped
7.    Once all codes are mapped click on OK

• Before checking the Trial Balance or Transactions, make sure the synchronisation is complete, otherwise the following message is displayed.

8.    Check the trial balance 

Synchronising the Trial Balance 

1.    Within the Accounting period click on Sync. With Open Integration 
2.    Select trial balance 

• Sync. With Open Integration displays the trial balance available to be synchronised from Open Integration to CCH Accounts Production.

• The first time the data in synchronised into CCH Accounts Production the mapping will default to none, this is because if you have created your own bespoke chart within Xero which uses the same codes as CCH Accounts Production, then no mapping is required.
• If you want to select for example Xero Limited to FRS 102 or a bespoke client mapping, then this can be done by clicking on the down arrow next to the mapping name.
• If the new unincorporated Master Pack is in use, then the mapping will be shown as in the screen below.

3.    Click on Synchronise

 
4.    Click on OK

5.    Click on Yes 

6.    Click on synchronise 

7.    If prompted, select the relevant nominal code/codes to be mapped
8.    Once all codes are mapped click on OK

• Before checking the Trial Balance or Transactions, make sure the synchronisation is complete, otherwise the following message is displayed.

 
9.    Check the trial balance 

Edit Client Mapping 

1.    If you need to edit the client mapping, then this can be done by selecting Edit client mapping from the menu bar

2.    Select the Account code you wish to edit and type in the code or part of the description. If you want to create a new code in CCH Accounts Production press F10.

3.    Click on Save. The client mapping will include the client code, so it is easily identified as a client mapping.
4.    The data will need to be re-synchronised to see the changes