How To Upload Your Bank Statement

What you need to know: 

Importing bank statements allows you to quickly bring transactions from your financial institution into AgExpert Accounting, reducing the amount of manual data entry and helping keep your records up to date. 

AgExpert Accounting can import the following file formats: 

• QuickBooks (.QBO) 

• Quicken (.QFX) 

• Comma-separated values (.CSV) 

Most financial institutions offer at least one of these file formats when exporting transactions. 

What you need to do: 

• Download a transaction file from your online banking portal. 

• Save the file to a location you can easily access, such as your Downloads folder or Desktop folder. 

• Confirm the file is in .QFX, .QBO, or .CSV format. 

• If using a .CSV file, you will need to identify some information from the file including: 

• Does the file have a header row? 

• Are the transaction amounts in one column or two? 

• What rows from the file you wish to import? 

• What date format is the file using? 

• What column shows transaction descriptions? 

• What column has the transaction amount? 

How to (Step by Step): 

For .QBO and .QFX files: 

1. Click Banking. 

2. Select Bank accounts. 

3. Click Upload statement beside the desired bank account. 

4. Browse to the location of the file on your computer, select the file downloaded from your financial institution, and click Open.   

5. The transactions from the file will then be imported into the Pending area to complete. 

For .CSV files: 

1. Click Banking. 

2. Select Bank accounts. 

3. Click Upload statement beside the desired bank account. 

4. Browse to the location of the file on your computer, select the file downloaded from your financial institution, and click Open. 

5. If you have previously gone through the import mapping process, use the drop-down menu to select your Saved import and move to step 7.  If this is the first time mapping the import, see below. 

   To map the import:  

   a) Use the Has header row button to indicate if the .CSV file has a header row. 

   b) Indicate which row in the .CSV file is the header row, if applicable. 

   c) Use the drop-down menu to choose if the Transaction amounts are in One column or Two columns. 

   d) Indicate which rows from the .CSV file you wish to import from. 

   e) Use the drop-down menu to choose the Bank account for which the transaction will be imported. 

   f) Use the drop-down menus to indicate which column in the .CSV file has the Transaction date and what date format is being used. 

   g) Indicate which column of the file contains the Description by using the drop-down menu. 

   h) Use the drop-down menu to select the column of the Transaction amount. 

   i) Click Review and review the Transactions section to confirm your previous choices are mapped correctly.  If you need to make changes, click Change import options. 

   j) You can Name import options for future use by entering a name and selecting Import.   

   Note: If you save a template for this account, you will be able to skip this mapping process for future imports. 

6. Click Import. 

7. The transactions from the file will appear in your Pending area to complete. 

References and Additional Resources 

• How To Add a Bank Account or Credit Card 

Still have questions? Contact support  

Contact us at 1-800-667-7893 or email support@fccagexpert.ca if you require additional support. You can find other help options under the Question Mark Icon in the top right of AgExpert Accounting at any time.