Splitting a Transaction into Two Transactions

There are two transaction split options that allow you to split a single transactions into two separate transactions:

  • the default split option - which splits the original transaction into two transactions with the same debit or credit sign. For example, you could use it to split a transaction for GBP 100 debit into two transactions, one for GBP 60 debit and one for GBP 40 debit.
  • the signed split option - which splits the original transaction into two transactions with opposite signs, that is it allows you to set the debit and credit indicator on the split transaction. For example, you could use this it to split a transaction for GBP 100 debit into two transactions, one for GBP 20 credit and one for GBP 120 debit.

Both of these options automatically selects the new split transaction for matching by setting the allocation marker to To Be Allocated, and leaves the allocation marker on the other transaction unchanged.

To split a transaction into two transactions:

  1. Identify the transaction to be split in the allocation transaction list.
  2. To split into two transactions with different signs (credit and debit), select Action > Signed Split.
  3. The Simple Split form is displayed. The original amount of the transaction is displayed in the Original Amount fields, by currency.
  4. In Outstanding Description, enter a reason for the split or any other useful information.
  5. If you chose a Signed Split, you can set the Debit or Credit indicator for the new split transaction alongside the Amount to Allocate.
Note: In a multi-currency environment, you can enter the amount to be allocated in any of the currencies in use within your business unit. You should use the currency in which you are matching the transactions. The current period currency rate is used to convert this amount into the other currencies available. Any difference between the original currency values and the recalculated currency values is posted as currency exchange gain or loss.
  • The difference between the original transaction amount and the amount to be allocated appears in the Outstanding field. This is the amount of the transaction that remains unallocated and retains the allocation marker from the original transaction.
  • Click OK to split the transaction, or click Cancel to abandon these details.

When you have split the transaction, the new transaction (or transactions) appear immediately above the original transaction in the allocation transaction list.

The transaction containing the Amount to Allocate value has an allocation marker of To Be Allocated. This amount is also added to the debit or credit balance totals at the top of the form which identify the total amounts allocated.

The original transaction contains the outstanding, unallocated amount and retains its original allocation marker.

Note: If the Preserve Original Line Values option is set in Ledger Setup (LES), the original transaction is not altered. An offset transaction is generated to reverse out the full value of the original transaction. Both this offset and the original transaction are given allocation markers of Correction. Two new transactions are generated, one containing the Amount to Allocate value and one containing the Outstanding value from the split dialog.