Percentage Fees are charged monthly on gross sales within an annual tiered system. If annual gross eceeds $2.5m the fee paid drops from 3% to 2.75% and so on to $7m. The fees are paid monthly. We want to track this on a cumulative approach. How do I set the formula up?

Your annual cumulative makes the monthly calculation more difficult. I assume there is also a fixed monthly rent plus cam. You will have to carry the gross sale monthly to avoid charging the higher rate,

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History