Convert files with splits
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.
Formats that support splits
- CSV (can be create with multiple columns or multiple lines)
- QIF format (for Quicken)
- IIF format (for QuickBooks)
Formats that do not support splits
- OFX, QFX, QBO
- MT940
How splits are passed to non-supporting formats
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:
- create separate transactions
- collapse splits
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.
Step 1: Create CSV splits as columns
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.
Step 2: Name split columns to support automapping
If possible to adjust column names in a CSV file, rename the columns before converting:
- Name amount columns as Split1, Split2, Split3 and so on
- Name category columns as SplitCategory1, SplitCategory2, SplitCategory3 and so on.
Step 3: Apply a custom mapping for split columns
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.
