1. Generating the OFX split
Navigate to Lettings properties > Property balances > View BACS Schedule.
Once the BACS has been completed and imported, return to the View BACS Schedule page, click the dropdown next to Generate BACS Schedule and select Create split BACS Schedule:
This file will automatically be stored within SME Professional with the date it was created and the amount it contained (Eg 2024-01-16 for £3000).
A pop-up will appear advising users that they can view the stored file and any others created. Accessing this is optional, and the page can also be accessed anytime from Bank > Add OFX split > Manage the saved split schedules.
Mark the items on the BACS schedule as complete as normal.
2. Uploading the bank lines after the debits are cleared
When transactions are imported into the relevant account for the day this clears, there will be a large bulk debit on the Unassigned lines page.
When this occurs, note the amount and date this cleared on, and then go to Bank > Add OFX Split.
Click Choose a file to select and pick the relevant file, typically the item with the same value as the debited amount. The date here shows when the file was generated, for reference.
Set the date the transaction cleared on. This is the date that the debit cleared in your bank.
Click Upload file.
Once uploaded, navigate to Bank > Auto assign bank lines.
Return to Financials > Unassigned lines. The bulk debit can now be ignored by clicking the red X.
Note: If Create split BACS Schedule is clicked multiple times, it will produce multiple files. This will not affect the process but may make it difficult to determine the correct file when uploading. If this occurs, the files can be deleted from the system by going to Bank > Add OFX split > Manage the saved split schedules. Please be aware that deleting items from this page is a permanent action.
Note: From Bank > Add OFX split > Manage the saved split schedules, users can also download the file for reference if preferred, though this is not a necessary step in the process.