Skip to main content

Bank lines - Splitting transactions into positive and negative figures

Updated over 6 months ago

When splitting a bank transaction, there will be occasions where both negative and positive figures will need to be entered.

For example: There is a credit card payment comprising of several transactions which equals £3000 and this figure includes a refund of a deposit. The breakdown of this is shown below:

  • £2000 rent in for property A

  • £2000 deposit in for property A

  • -£1000 holding fee (returned to the tenant for property B)

Splitting the bank line

  1. Navigate to Bank > View bank lines

  2. Locate the bank transaction that needs to be split

  3. Within the ID column, click on the ID number

  4. Within the Amount column, enter each payment amount in full in a different line
    If the original transaction is positive, only enter the positive amounts in each row
    If the original transaction is negative, only enter the negative amounts in each row

  5. Leave the Category and Subcategory fields blank.

  6. The remaining negative or positive balance will show in the Amount Remaining section

  7. Tick the Claw back difference checkbox

  8. Click Add lines above, and a pop-up will appear to advise that one or more lines have no category assigned. Select OK to add the lines to the unassigned lines page

Once submitted, the transaction will be split into each positive and negative amount. Users can now navigate to Financials > Unassigned lines and assign each as needed.

Did this answer your question?