The bank import feature allows you to import transactions from your bank or credit card vendors directly into Accounting Seed without any file transformation. Accounting Seed supports the following files formats which are used by most banks: OFX and QFX. The extension of the file needs to be one of these suffixes for the import to work. When selecting a file output format from your bank labels like "Microsoft Money" and "Quickbooks" are often used to label these file types. Accounting Seed recommends the latest version of OFX or Microsoft Money if given a choice of file formats from your bank. The following are features of the Bank Import:
- Bank imports are executed from the "Import Financial File" tab. Simply navigate to this tab to start the process.
- There is an option to prevent duplicate entries. This feature will not book any duplicate entries from your bank and is recommended to always be enabled.
- When finding vendor matches the application will attempt to match on the first 3 letters of the first word. You are able to store an Import Nickname on the account to provide an exact match.
- Both Cash Receipts and Cash disbursements will be created from the results file.
Importing a Bank File
Step By Step:
Importing a file
- Download transactions form your bank website into one of the supported file formats: OFX and QFX. When selecting a file output format from your bank labels like "Microsoft Money" and "Quickbooks" are often used to label these file types. Accounting Seed recommends the latest version of OFX or Microsoft Money if given a choice of file formats from your bank.
- Navigate to the "Import Financial File" Tab
- Click the "File Input" button to choose the file from the folder on your computer to which you downloaded it to.
- Click the "Import" button. This will import the transactions to a grid view. You are able to display 10, 25, 50 or 100 transactions at a time. Use the upper right hand search to find a specific transaction or ID. It will search on all of the fields.
Coding Account and GL Account
- Use the Find Customer/Vendor Matches button to search for existing Account matches. Accounting Seed will attempt to match on the first word of the vendor.
- If the vendor does not exist then you can add a new vendor by right clicking on the Account Tab and opening it in a new Tab in your browser. Here you can add a new vendor. You will need to populate the following fields:
- Accounting Active set to Checked
- Accounting Type = Vendor or Customer and Vendor
- Default Gl Account
- Import Match Name - Optional, but allows for an exact match on this Account. Simply cut and paste the name used in the bank import file into this field.
- If the vendor already exists you can update the Import Match Name on the Account so that the Customer/Vendor and GL Account will be updated automatically next time you import the file.
- You are able to mass populate The Vendor and GL Account fields by Selecting a Value in the Default Vendor and Default Vendor GL Account fields in the upper right hand part of the screen. Once you populate these fields click the Populate Default Vendor button at the top of the screen to mass populate and blank values for Vendor and GL Account in your grid.
- Both the Customer/Vendor and GL Account fields need to be populated for the record to be created.
- If you do not care about the Vendor simply create a bucket account such as "Uncategorized Account" to code these transactions to and use the Mass Populate button described in step 4 of the previous section.
- Upon import, a unique ID is created. This prevents importing duplicate records. If a transaction is imported again, it will match to the already created record and not allow for duplicate entry.