Skip to main content

Bank lines - Using the OFX split

Some banks display BACS payments on imported bank statements as a single bulk debit rather than individual transactions

The OFX split process will allow for the bulk debit to be split as required into its relevant individual transactions.

1. Generating the OFX split

Navigate to Lettings properties > Property balances > View BACS Schedule.

  1. 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:

  2. SME Professional will automatically save the file and display the creation date and total value (for example, 2024-01-16 - £3,000).

  3. A pop-up will appear advising users that they can view the stored file and any others created. You can view saved split schedules immediately or access them later by navigating to: Bank > Add OFX Split > Manage Saved Split Schedules

  4. Mark the items on the BACS schedule as complete as normal.

2. Uploading the bank lines after the debits are cleared

Once the bulk debit has cleared in your bank account and the bank transactions have been imported:

  1. Navigate to Financials > Unassigned Lines.

  2. Locate the bulk debit transaction and note the amount and cleared date.

  3. When this occurs, note the amount and the date it cleared, then go to Bank > Add OFX Split.

  4. Click Choose File and select the relevant split schedule. In most cases, this will be the file with the same total value as the bulk debit.

    The displayed date indicates when the split schedule was created and can be used as a reference.

  5. Set the date the transaction cleared on. This is the date that the debit cleared in your bank.

  6. Click Upload file.

  7. Once uploaded, navigate to Bank > Auto assign bank lines.

  8. Return to Financials > Unassigned lines. The bulk debit can now be ignored by clicking the red X.

Note: Multiple Split Files

If Create Split BACS Schedule is selected more than once, multiple split files will be generated.

While this will not prevent the process from working, it may make it more difficult to identify the correct file when uploading.

Unwanted split files can be permanently deleted by navigating to:

Bank > Add OFX Split > Manage Saved Split Schedules

Warning: Deleting a saved split schedule cannot be undone.

Note: Downloading Saved Split Files

From Bank > Add OFX Split > Manage Saved Split Schedules, you can also download saved split files for reference if required.

This is optional and is not necessary to complete the OFX split process.

Related Articles
Did this answer your question?