Split Transactions

Split Transactions are transactions which cover multiple lines of allocation, including deductions (contras).

Luke Mayo avatar
Written by Luke Mayo
Updated over a week ago

Split Transactions are transactions which cover multiple lines of allocation.

We have recently added the ability to copy lines, add up to 50 lines within a single split, and view the difference on an imported bank entry between the total of the split lines and the total expected. You can see more information on this further down the article.

You will require the Split Transactions features if, for example, you are purchasing more than item on the same invoice or bank payment/bank receipt and need to allocate the single entry to to more than one category/enterprise/description etc.

This may also apply to Sales invoice if you have not ticked the option ‘Do you want Farmplan to create your invoices’ in Company Settings. (If you are creating sales invoice documents you are also able to add as many lines as you wish but the layout is different.)

How to Split Transactions in Farmplan Business Cloud

When processing your data entry you will see an orange 'split' button on the right hand side of each individual transaction:

Selecting this button will open up the split entry screen, and by default will always show two lines. If you had started allocating information or typing in a description before selecting the split icon, this information will populate the first line.

Bank Feed / Bank File Import - only the category, enterprise and description will copy across to the first line of the split, if entered before clicking the split button.

Manual Bank entry / Supplier invoice / Batch customer invoice - all details entered in the single entry before clicking to split will copy across to the first line of the split.

From the split screen you can add up to 50 lines of allocation. Lines are added or removed from the split by selecting the + or - button, the + button will add a line to the bottom of the split, and the - button will remove the selected line.

The purple icon will copy the selected line, creating a new line at the bottom of the split which can then be amended if required. Any line can be copied.

For any deductions (contra) lines on a split entry, remember to enter a minus sign. E.g. levies on a sale.

The total amounts entered on each row should always add up to the total amount of the transaction.

Splitting transactions imported via a Bank Feed / File Import

When splitting transactions that have been imported via the bank feed or an import of a bank statement, these transactions have the total amount that went through the bank. When splitting these entries, the system will give you an 'Amount Left' figure, totaling the value of the splits and showing you how much is still to be allocated before the transaction can be saved.

How to edit or 'unsplit' a transaction

When editing a split transaction or 'unsplitting' it, click the orange split icon next to the transactions (as above).

From here you can either edit the rows and click save or click 'Unsplit'. Clicking 'Unsplit' will remove all entries and will allow you to re-enter the transaction without the split.

Viewing Split Transactions

When viewing transactions that have been split, the description, category, quantity and price are shown as 'Split' or 'Split Transaction' as there are multiple allocations within the split.

What about invoicing?

Split transactions are also available for supplier invoices and batch customer invoices.

Again use the orange split button at the end of the line.

Remember to enter the Supplier or Customer (Account) and invoice reference before entering the split.

Did this answer your question?