Hi folks - I am importing trial balances into NS, and i have run into an issue - this upload file format - has worked to import the beginning balance. Now I am doing this for the following month (and have to import the activity rather than the month ending balance). The format is the same, the Credits and Debit match up. I am getting an import error “The amounts in a journal entry must balance.” I am attaching the results file here. What am i missing?

How are you "grouping" that lines? Normally we use a External ID column to indicate what lines are grouped to form a single Journal Entry. The first line is not balanced if alone.

90521.38

debit vs

94773.05

credit

This is 1 JE with multiple lines. So all the credits total = all the debits. The individual lines don’t balance out, but the JE no as a whole does

Then be sure that: 1. No external ID column is mapped in the import, or a single External ID es set to the whole batch. 2. There are no empty columns, only zeros if needed. 3. There are no rounding errors.

I did all this. That’s why I’m scratching my head