How to manage bank accounts/credit cards with no bank feeds (Manual Imports)

These are the steps to create a bank account/credit card in Xero, and import statements manually:

1. Create the bank/credit card account in Xero. Go to Accounts > Bank Accounts > Add Bank Account > Input name of bank into the search (include credit card  > Click 'Add it anyway’ if there is no option > Fill in bank details > Save.
2. Create a Excel File (.csv formatted) of the transactions to import. Please see the link below to an attachment of a template to import transactions. Using a downloaded transaction history for the bank account or paper statement, transfer the information across into the relevant fields in the template, and save the file as a CSV (Comma delimited) Excel .
3. Import the Transactions. From the Dashboard, find the new bank/credit card account and click 'Manage' > go to 'Import a Statement' > Click Browse and select the newly created CSV file > then click 'Import'. You will then see a screen with settings for the categories of the transactions. Please ensure you assign each field to the relevant category in the settings. Once everything is assigned, click Save.

All transactions should now be imported into Xero and allow to be reconciled. To ensure all transactions are imported correctly, check a balance on a paper statement against the statement balance in Xero at the relevant date. This will need to be done on a regular basis.

Please see this link to a video which demonstrates this process, and provides further help on editing the CSV file.