Split transactions for Bank Rules

[Patch]

Bank Import - multiple line transactions not listing under uncategorised

@whosat The issue here is that bank rules are soon going to become more powerful by having ability to split transactions. This has been already implemented, just isn’t exposed in the user interface yet. But paypal transactions are already split and I need to find some elegant way to handle this. We know that on imported line items, first line is gross amount and the second line is fee so it could be as simple as creating multiline bank rule to put first line to some income account, the second l…

Looking forward to bank rules by having ability to split transactions.

My main use case is transactions with

• GST 10% on most of the total

• GST free on a small amount eg Stamp duty, Return To Work WHS (Work Health & Safety) fee

I’m not sure how is the best way of implementing this. Stamp duty on some repeating costs are a constant percentage (insurance) but others vary by a small amount (WHS Fee).

• For seemingly randomly variable percentage manual editing would be required. Ideally with Manager prefilling what is constant (multiple line items and tax codes) but flagging the transaction as still needing editing. User interface options for which include not selecting such transactions when the select all checkbox is ticked so leaving them in suspense. Trigged perhaps if more than on line item being entered in a bank rule or “suspense” entered as the amount. For these approaches to work, the edit button on a transaction should first apply the bank rule changes. The user can then refine the bank rule output rather than redo it then incorporate the edits.

• For transactions with a constant distribution (percentage split between line items, or fixed amount to one line item and remainder to another) then some form of data entry user entered formula would be required. I suspect that would best be done when similar functionality is added else where in Manager (eg Automating calculations in Payslips, Cost Price Sale Price Markup Field Idea, Tax Withholding Percentage, Worksheet to batch update prices based on cost formula)