No experience with Amazon accounting at all, so this is in the way of a
guess. But I have had to deal with Excel being used to perform calculations
and having to deal with similar minor differences in calculation between its
results and those from an accounting program. We found that using Precision
as Displayed cured the problem. That is set using Tools | Options | and a
check on the [Calculation] tab.

"Richard Wrigley" wrote:

Gretings from Norfolk (UK)

I have just found this group, so may be asking a question previously
answered.

I am trying to set up n excel spread sheet for a friend for her sale of
books on Amazon.

Does anybody know the way Amazon calculate their fees and VAT - I know the
percentages and deducted amounts, but every time I try I get errors between
their figures and my calculated values of + or - 1 penny.
I have tried various rounding techniques, but to no avail

Any help would be appreciated.
--
Richard.

"I have yet to see any problem, however complicated, which when looked at in
the right way, did not become still more complicated"
Poul Anderson