Learn about importing bank files into PocketSmith. If you can't use bank feeds, bank files allow you to import your transactions and accounts!
In this overview
Bank files overview
Importing a bank file is an alternative method for bringing your transactions into PocketSmith. When you first start using PocketSmith, you can import a bank file from your checklist. You can also import a bank file from the Account Summary page if you have already completed the checklist.
You can import the following files into PocketSmith: OFX, QFX, QIF, CSV. Most online banking services will offer a download of these file types. Then you can import them straight into PocketSmith! We recommend importing OFX, QFX, QIF files as these can be used in our express migration tool - it's a quick and easy way to import your transaction history!
Importing a CSV file into PocketSmith has a slightly different process, but you can find out everything you need to know about this and importing all bank files in PocketSmith in the articles below!
- Importing bank files into PocketSmith
- Different file types that can be imported into PocketSmith
- Managing whether categories are imported with my bank file
- Moving to PocketSmith from another personal finance app
- Expense transactions are showing as income (or vice versa) after importing my bank file
- Transaction dates are incorrect after importing a bank file
- An error is shown during a bank file import
Frequently asked questions
What is the best file format to use when importing my bank files?
We recommend OFX files - this file type imports smoothly into PocketSmith without any issue and most online banking provides this export option. We also support QFX, QIF & CSV. Where possible it's best to use OFX, QFX or QIF over a CSV file. For more information check out Supported file types
How can I avoid duplicate transactions when importing bank files?
If you've imported two different files with dates that cross over each other, or if you add the same file twice into the same account in PocketSmith, this will cause duplicate transactions. When you're importing bank files that might include duplicates it's really important to select the option Replace existing transactions with overlaps or Leave overlapping transactions out. Find more about this option, see this article: Bank file import options
My bank feed only goes back a few months, can I go back further by importing bank files?
When you first add a bank feed, our bank feed provider gathers up to last 90 days of your transaction history. If you'd like to import more that this into PocketSmith, you can backfill an account by importing bank files. Learn more here: Importing bank files into PocketSmith
Why are the dates on transactions incorrect after importing a bank file?
When importing CSV and QIF bank files, PocketSmith tries to work out the date format that has been imported without asking you for additional input. Sometimes, PocketSmith will import transactions with the incorrect date format. To learn how to fix this, check out our article: Transaction dates are incorrect after importing a bank file
Overlapping options when importing a file
When importing 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. It's best to avoid duplicate transactions, so we recommend selecting either Replace existing transactions with overlaps or Leave overlapping transactions out. For more details about this option, check out this article: Bank file import options
Joining the payee and memo fields
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! You can find more about this option in the following article: Bank file import options