Import a bank statement in OFX, QBO, and QFX formats

Make sure that the PX.Objects.CA.OFXStatementReader import service is specified in the Statement import service field; the location of this field depends on whether the Import bank statements to single cash account check box, located in the Cash management preferences (CA101000) window, is selected:

• Selected:
  The import service is specified in the Cash accounts (CA202000) window for each cash account for which you will import statements in one of these formats.
• Cleared:
  The import service is specified on the Bank statement settings tab of the Cash management preferences (CA101000) window.

Also, make sure that the bank account ID specified in the file is associated with the appropriate cash accounts in the system.
That is, for the cash account for which you want to upload transactions, specify the bank account ID in the External ref. number field in the Cash accounts (CA202000) window.
For instance: You can find the bank account identifier in the OFX file under the <ACCID> tag.

If you forget to specify the bank account ID in the cash account settings and try to upload transactions, the system gives you a warning.
The warning contains the bank account ID from the file, which you can copy and paste to the settings for the cash account.
You can then try to upload the file again.

1. Go to the Import bank transactions (CA306500) window.
2. Click Upload file in the window toolbar. The Statement file upload dialog box is displayed.
3. In the dialog box, make sure that the Upload file option is selected.
4. By using the Choose file field, select the file with the statement. Click Upload to upload the file and close the dialog box.
5. Review statement details in the top part of the window and the list of imported transactions in the table.
6. Click .

The system generates a reference number for the list of uploaded transactions in accordance with the numbering series assigned to bank statements in the Cash management preferences (CA101000) window.

The procedure is similar if you use the Process bank transactions (CA306000) window to import the bank statement.

You can review the list of imported transactions and manually edit transaction details.
You can then process the imported transactions by using the Process bank transactions (CA306000) window.