Importing bank files into PocketSmith

In this article

Preparing bank files to import into PocketSmith

If you are importing bank files into PocketSmith, it is best to have your bank files prepared. Most online banking services provide export options for bank files in OFX, QFX, QIF or CSV format. You will need to have your files exported from your online banking website before they can be imported into PocketSmith.

Learn how to export your bank files from your online banking website here:  Preparing your bank files & accepted file types

Once you have exported the bank files from your online banking, you are ready to import them into PocketSmith! 


Importing bank files from the checklist

If you have just signed up to PocketSmith, you'll see your checklist. From here you can import bank files to set up new bank accounts.

1
Select the option Upload your bank files 

2
As long as you have  prepared your bank files, you can click I'm ready to upload my files! 

3
Our Quick Importer tool will open where you can drag and drop or choose the files you would like to import.
4
After adding a bank file, you'll need to create a new account for this file to be imported into. To do this, add an  ACCOUNT NAMEBANK NAME and  TODAY'S BALANCE

If you are importing a CSV file, you'll also need to choose or create a CSV format

5
You may notice some different options to apply to the import. We have outlined what these different options are  below.
6
To add any additional files, you can create new bank accounts for these, or just add it to a previously created account. Once you've added all of your bank files that you'd like to import, click Start import

Importing bank files on the Account Summary page

If you want to import a QFX, OFX, QIF or CSV bank file after you have completed your checklist and once you're set up in PocketSmith, it's easy to do from the Account Summary page ( Accounts > Account Summary) page. 

Importing bank files into a new offline account 

1
Head to the Account Summary page ( Accounts  Account Summary)
2
Select New offline account > From a file import  and select the bank where the account belongs that you'll import the file to

Note

If you want to import a bank file into a new account that belongs to a new bank which doesn't exist in your PocketSmith account, you'll just need to add the bank before following these steps.

On the Account Summary page, select +New Bank from the left sidebar, enter the name of the bank, select the option Accounts from a file import, and click Save. This bank will now show as an option when choosing New offline account > From a file import 

3
Add the account name, opening balance, account type
4
Click Save and continue
5
Drag and drop or choose the file you'd like to import
6
If you're importing a CSV file, choose a CSV format or create new format and assign the columns appropriately
7
You may notice some different options to apply to the import. We have outlined these different options below
8
Select Import my transactions

Importing bank files into an existing bank account 

1

Head to the Account Summary page ( Accounts > Account Summary

2
Navigate to the bank account that you'd like to import a bank file
3
Click MANAGE ACCOUNT > Upload bank file 
4
Continue from step 5 in the previous section

Bank file import options

Transaction overlap options

When uploading a bank file into an existing bank account, PocketSmith can pick up overlapping transactions - these are transactions that have the same dates as transactions already in the account. 

You are able to select what PocketSmith does about these:

  • Leave overlapping transactions out
    This keeps the original transaction and prevents the new transaction from being imported
  • Replace existing transactions with overlaps
    This is useful if the overlapping transaction has other new information you would like to import and replace and older transaction
  • Keep both existing and overlapping transactions. This may result in duplicates
    We do not recommend this option 

Amounts in the statement file are reverse

This checkbox should only be selected when the transaction amounts are incorrectly imported as expense or income. This option is available because some credit card providers show debit amounts as a credit or credit amounts as debit. For more information about this check out our article: Expense transactions are showing as income (or vice versa) after importing my bank file

Payee and memo field

If you have imported a bank file and you notice some information is missing from the Merchant column, this may be because some banks separate merchant details into a memo field and a merchant field. To fix this, you can import the file again and select the checkbox Join the payee and memo fields together. Just remember to change the overlap options to  Replace existing transactions with overlaps!

Still need help? Contact Us Contact Us