Q: How can I import my bank statements into EEBA?
EEBA supports importing bank activity for checking, savings and credit card accounts. You can import QFX (Quicken) and OFX (MS Money) files, as well as CSV files as an alternative for advanced users.
Step 1. Get Ready to Import
Head to your bank’s website and download your “recent activity.” Note that this is often not the same as downloading your statement. When asked, choose one of the following file formats:
- QFX, a.k.a. Quicken, Web Connect, or;
- OFX, a.k.a. MS Money, Open Financial Exchange.
Step 2. Import Your Bank Activity
When you’re ready, head to the Accounts page and click on
“Import Bank Activity” to begin.
Once there, click on “Choose File” and select the QFX or OFX file you want to upload. If your bank uses comma decimal separators, be sure to choose that option. Then, click on “Upload Transactions.”
On the next page, choose:
- The account you want to import from
- The EEBA Account to import to
- Then click “Begin Import”
Step 3. Review & Save Your Import
On the review page, all your bank’s transactions will be on the left, and all of EEBA’s existing transactions on the right. EEBA will match similar transactions in green (exact matches), or yellow (best-guess matches). Unmatched transactions will be in grey.
Review the matches in EEBA to make sure they’re correct. You can cancel a match by clicking on the “X” in the middle column.
- To manually match two transactions, drag and drop the imported transaction over the EEBA transaction you want to match it with.
- To create a new transaction, drag the imported transaction over one of the Envelopes shown at the bottom of the page.
“Manually Created” transactions will be in blue.
Once you’re done, click on “Save Changes” at the bottom of the screen.
Congratulations, you just imported your bank statement!
Last Updated: 2/14/2012