You may receive the error: Validation error: transaction distributions in fund 10 must balance. Distribution ID field value -23 (for example) on validation report when importing invoices.
The number referenced in the validation report refers to the section grouping in your import parameter.
1. Select the fields tab of the import parameter in use 2. Locate the grouping based on the number referenced 3. Check through and confirm whether that section is mapped correctly - specifically confirm that "amount" fields are mapped accurately
For example, confirm that an amount field that should be mapped to "Debit transaction distribution amount" is not instead mapped to "Account distribution amount."
If the error is still occurring after re-mapping recreate the import parameter If the error is still occurring, recreate the Excel spreadsheet