Bank Account Mapping
Bank Account Mapping is available with Insight and Accelerate Packages.
Under the Standard Package we convert the chart of account based on the account type in the source file - for example:
- Bank Account, Credit Card, Paypal - Will be set up as such in Xero (pending your bank feed connection)
- Current Asset/Liability - Will be setup as Current Asset/Liabilities in Xero
Therefore please ensure that the Account Type is correct prior to uploading.
VERY IMPORTANT: Even if the Account Type is correct in the source, individual banks have different requirements to enable bank feeds. For example, some banks require ‘credit cards' to be set up as ‘bank accounts' in order to connect bank feeds. Review Xero’s website for your banks requirements
Whilst clearing accounts may have been used in the source file, it is unlikely that these will be required unless to clear the remaining balance. Their account type is normally Bank Account in the source file, therefore you may wish to change these to Current Asset/Liability accounts prior to upload.
Bank Account Mapping
If you map your bank accounts as current asset/liability accounts we cannot complete our quality assurance on bank reconciliation reports prior to delivery. In Xero, you will be unable to complete a reconciliation moving forward. The link will also be lost between payments and contacts for this account in Xero.
The benefit of changing the account types to an asset or liability is that you are still able to make payments and manual journals to these accounts.
Please be advised -If bank mapping is not completed within a 48 hour timeframe we will complete on your behalf.
Can I Change Account Types Myself in Xero?
Should you choose a conversion service that does not include the option to modify bank account types you can do so in Xero afterwards.
It is not a simple process so we have written a blog post with more details about this.
NOTE: As this information updates periodically we recommend confirming this is still accurate with Xero or for additional information on direct bank feeds please see the Xero Help centre.
Related Articles
Bank Feeds
Bank Account Mapping - Bank Account / Credit Card / Paypal / Asset / Liability Any account you want to reconcile in Xero, or receive bank feeds for need to be selected as a bank, credit card or PayPal. Each bank requires the accounts to be set up in ...Bank Versus Asset/Liability Accounts
In Xero if you would like to be able to reconcile an account it needs to be a bank account, you don’t have to have linked bank feeds if not required. As such it is an operational decision whether it is a bank account or an asset/liability account. It ...Transaction types that may lead to issues
We always try to deliver the conversion with full transactional history. On occasions, if the following transaction types occur extensively we may only be able to provide a service with no or reduced history. In some instances it may prevent us ...Custom Chart of Account Service
Customising my Chart of Accounts in Xero With this service, you select how you want the Chart of Accounts to appear in Xero, prior to conversion. The full desktop file history will then present in Xero as though it had been run through this new Chart ...PDF Bank Statements to CSV and OFX
I need bank statement PDFs in a file format If you need to get historical data into an electronic format and all you have are old bank statement PDFs our PDF conversion service can assist. Using a semi-automated process we tidy up the data, put ...