Wrong Interest Rates on Accounts Receivable

SUGGESTED

Since upgrading to Sage 50 Quantam 2015, Sage has stopped accurately calculating interest rates on A/R balances. Previously, any outstanding balance was charged interest at 12% per year... this works out to a daily compounding rate of 0.0328%. The customer statements are properly showing these rates; however, the interest that is actually being applied is way off base.

For example, I have a customer with a month end balance of $10,190.67, which I would expect interest to be $100.51 for the month ($10,190.67 * 12% * 30/365); however, Sage 50 is inexplicably calculating the interest at 869.52 despite the fact the statement is displaying the appropriate rate.

The settings have not changed and are still set at "annual interest rate" at "12.0% on invoices overdue by 30 days".

Any input to solve this problem is greatly appreciated!

Parents
  • 0

    I am very new to bookkeeping/Sage and we upgraded to the 2015 version so I would be very interested to know how everyone is going to use this new feature!  I have a few customers who have over-due accounts and we add 2% interest per month - so I have having a difficult time with this.... Thank you!

Reply
  • 0

    I am very new to bookkeeping/Sage and we upgraded to the 2015 version so I would be very interested to know how everyone is going to use this new feature!  I have a few customers who have over-due accounts and we add 2% interest per month - so I have having a difficult time with this.... Thank you!

Children
  • 0 in reply to Kendra9
    SUGGESTED

    I have received the answer from 2nd-level tech support.

    Bottom-Line : According to a believable source in tech support : The interest calculation feature does not work (ie. gives the wrong results) at this time in version 2015.  

    The only solution they are offering (until the programmers figure out the problem) :

    a) TURN OFF the interest calculation feature

    b) Calculate the interest manually and insert the amount into an additional invoice

    BTW, you can't go back to the old interest calculation method once your data has been converted to version 2015.

    NB : I am a Sage business partner

  • 0 in reply to Lise Robichaud

    yes, there is a problem, 12% annual compounded daily in sage is .0311%

    but .0311 * 365 is only 11.35%

    what is the best way to track monthly interest charges to correctly apply payments ?

      run the statement this month (sales invoice is say 31 days overdue)

      create an invoice for the interest, crediting the interest income account for one day of interest

      run the statement next month

         the problem is the statement will show 61 days of interest on the original invoice

         and an interest invoice will appear on the statement, billing the first day of interest

         so the statement will show 62 days of interest due

    and I don't see how to calculate interest charges for one customer, and not another - I presume Sage assumes that charging interest on an overdue account balance applies to all customers - as corporate policy

  • 0 in reply to Roger L

    12% annual interest compound daily is

    =((1+0.12/365)^1)-1 = .0329% (not .0311%)