If you are uploading the individual amounts to Peachtree and they are uploading
correctly, and Peachtree is telling you that they don't equal zero, then how is
this an Excel problem? There are workarounds to make the total equal exactly
zero in Excel, using the ROUND() function, but that doesn't solve the problem in
Peachtree, does it?

=ROUND(SUM(A1:A20),2)


frecar wrote:
I tried using the round function but it does not solve the problem. Below is
what I am talking about. I am adding amounts that have no more than two
decimals (pennies) but the sum that should be zero is not truly zero. When I
try to upload it to Peachtree, that program recognizes the decimals and does
not permit the posting of the entry because debits minus credits does not
equal zero.

Amount
33,276.55
1,158.33
0.45
66.54
18.79
12,654.58
16,332.28
9,234.81
309.88
2,496.15
-
19.99
(31,452.87)
(1,402.09)
(9,244.74)
-
(514.58)
(44.92)
(31,750.82)
(1,158.33)
0.00000000001637090463191270 (this is the net)

Please e-mail me at if you have any further
information you would like to share.





"David Biddulph" wrote:

Use the ROUND function.
--
David Biddulph

"frecar" wrote in message
...
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 keeps me from uploading an electronic journal entry because
our
software Peachtree says the entry is out of balance.