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

    • View Statement Distribution log (Landlord & Tenant Statements)

      Statement Distribution Log will provide a list of any sent Owner and Tenant statements. The log will show which statements were Success, Failed or Note Sent. 1. Click Admin on the Main Menu. 2.Click on Communication 3. On the main ribbon bar, select ...

    • Microsoft 365 Integration Verification Error ("need admin approval")

      When a user tries to integrate their Microsoft 365 account with PropWorx but receives a prompt indicating they don't have the necessary permissions to verify the app, the administrator of the Microsoft account will need to complete the verification. ...

    • FAQ: AUTOCHARGES NOT RUNNING - What to Check

      If auto charges are not running, here are some things to check: End Date: Did you set an end date on the autocharge? For example, if the end date is 31 July 2024, it will not charge rent for August. Start Date and Advance Days: When did you add the ...

    • FNB Payments - Payments Results/ Rejected Report

      1. Sign into the FNB Online Banking. Click on Menu. 2. Click on Inbox 3. Click on Download on the payment batch 4. On the Download prompt, click Download. Download will be saved to your computer. 5. Open report to view Message column to see itemised ...

    • Manage Rental Landlords Profile

      Watch Video - PropWorx © 1. Click Admin on the Main Menu. 2. Click on Customer Files. 3. Select Rental on the menu heading. 4. Click on the File Name to open the file. 5. Customer File will open. Click on Landlords on the file tab ribbon bar. 6. ...