FAQ: OXF bank statement giving error - steps to find and fix error

FAQ: OXF bank statement giving error - steps to find and fix error

When importing an OFX or TXT bank statement, an error may appear. This error will usually indicate a specific issue, often caused by a character in the reference.

For example, the error might state that on line 77, position 14, there is a problematic character.






How to find the issue:

1. Open Excel and Notepad. Copy and paste the OFX data from Notepad into Excel.
2. In Excel, navigate to the specified line (e.g., line 77) and count the characters to reach the indicated position (e.g., position 14). You should find the problem character, which in this case is a < in the reference.






3. In the OFX file, locate the same row (use the FIND function to quickly navigate to that row). Delete the problematic character (you may replace it with a space).
4. Save the OFX file and attempt the import again.

    • Related Articles

    • Perform a Bank Reconciliation

      Bank Reconciliation is the process of checking differences between the transactions loaded on the PropWorx and the transaction on the bank statement. You can use the bank reconcile to match the bank transactions imported with those on the statement ...

    • Banking: Import a Bank Statement

      You have two options to import transactions into PropWorx: using the bank statement import or manually entering the transactions (see article: Banking: Load Manual Transactions). 1. Click on Accounting on the Main Menu. 2. Click on Banking 3. On the ...

    • Statements & Invoice Bank Details

      Different bank accounts can be linked to different properties. Make sure the bank details are entered as trust cashbooks under the account settings. Statement bank details can be linked on three different levels: Default Company Bank Details: All ...

    • Correcting Tenant statement entries

      If there are any inaccuracies in the entries on tenant statements, you have the option to rectify them. These corrections made to tenant statements will not influence landlord statements or general ledgers. In cases where the issue pertains to ...

    • Bank Import: Split a Transaction

      1. Click the action icon () on the transaction row and select “Split Transaction” from the menu. 2. Manage Split Transaction screen will open. Under the Split Transaction section, select the file on the split row. 3. Search and select file by ...