On Jan 22, 6:13*am, Glenn wrote:
My point was stated in the part you
snipped from my post
[....]
If just the individual amounts are uploaded,
and the balance is being calculated in Peachtree,
then that's where the problem needs to be fixed.

Oh, good point! You might be right. Conceptually, it makes sense
that the OP would upload the data (debits and credits), and Peachtree
would balance them in its own way.

I had ass-u-me-d that the OP was uploading the balance (perhaps in
addition to the debits and credits) because in two postings, that
seemed to be the only value that the OP identified as problematic.

In the OP's initial, the OP writes (annotations added): "I netted
debits and credits and the answer is zero - it appears - as it should
be. However, there are decimal values beginning about decimal place
twelve. This [the non-zero decimal fraction in the netted amount]
keeps me from uploading __an__ [single] electronic journal entry
because our software Peachtree says __the__ [single] entry is out of
balance".

And later the OP writes: "As you can see, the only place where values
appear beyond the second decimal is in the net figure at the bottom".

Arguably, the list of debits and credits would not be a single journal
entry. But playing devil's advocate, the OP might mean a "journal
transaction", which for Peachtree might be a compound operation.
Again, I am not familiar with Peachtree at all.

Notwithstanding my interpretation of what the OP is trying to do, you
could still make a strong case for seeing this as flaw in Peachtree.
If Peachtree is designed only for financial uses, I think it should
round financial numbers ("dollars and cents") to a reasonable number
of decimal places -- 4 or 6 if not 2.

Be that as it may, finger-pointing, no matter how correct, is not
going to solve the OP's problem. As you and I pointed out, rounding
the netted amount should. I wish the OP would post back to let us
know.

I suspect the initial vague suggestion to use ROUND led the OP to
round the individual amounts(!), but not the SUM; alternatively, the
OP misused ROUND in some way (I can think of several). That is the
only way I can imagine that ROUND did not solve the OP's upload
problem.