Bank Account Mapping
Bank Account Mapping is available with the Accelerate Package.
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 from ...Bank Reconciliation Post Conversion
How to deal with the reconciliation post-conversion can vary depending on how up-to-date the accounting data file was when it was uploaded for conversion. In addition, whether you ordered a history versus balances service will influence when you need ...Turning on Chart of Account Numbers - Quickbooks & Reckon
Adding numbers can help you identify the type of accounts, thereby speeding up your account selection on various forms. You might want to develop and follow a consistent account naming and numbering convention. For example: 1000-1999 - Assets ...