The ProperConvert converter supports splits in transactions.
What is a transaction with multiple splits? When each transaction can have more than one category assigned.
Some formats support splits, and the converter can convert transactions with splits. Splits are passed during a conversion when supported and adapted when the output format does not support them.
The OFX, QFX, QBO, MT940 formats do not support splits. For example, with a PayPal file and there are Gross, Fee, and Net columns, resulting in two splits and the amount. Since creating a transaction with multiple splits is not possible, the converter offers two ways to pass splits into the output file:
Creating separate transactions will result in multiple transactions that you can still work with in your accounting software.
Collapsing splits will loose the category details, but keep a transaction as a whole, that could be edited later in the accounting software.
For example, for a CSV file with splits below, the file has the Amount column, 'Split1', 'Split2', 'SplitCategory1', 'SplitCategory2'.
If there are no split category columns - the name of this split column will be used as a category name for all transactions.
If possible to adjust column names in a CSV file, rename the columns before converting:
Click 'Review Mapping' to use a custom mapping feature (provided for for CSV/Excel files only).
Set the number of splits here.
Set columns, which have split amounts.
Similarly, set columns for split categories.
Once the mapping is saved, make sure to verify the splits column at the end of the transaction grid that all splits are parsed correctly.