If you receive the following error message: "The sum of split amounts must be equal to 0" you are receiving this error message the sum of the journal entry does not net to zero. Below are some things that you can check to resolve this error message:
- Make sure that each line of the journal entry has the same value mapped to the QuickBooks field, RefNumber, and that the lines of the same journal entry follow sequentially in the import file.
- Open up the file in Excel and make sure that the total of the journal entry nets to zero. Debits should be expressed as a positive number and credits as a negative number.
- Expand the number of decimal places in the number column and then sum up the column it could be a rounding issue out several decimal places.