inserting percentage calculations in timeslips

Sage Timeslips

Sage Timeslips
Welcome to the Sage Timeslips product community. Drop in to the Sage Timeslips forum and post questions, discuss ideas, and share information about your Timeslips experiences. There's always something new to learn about Sage Timeslips!

inserting percentage calculations in timeslips

  • Could someone help me to insert a % to calculate it every month?

  •  


    katemcleod wrote:

    Could someone help me to insert a % to calculate it every month?


     

    I'm afraid I need a little more information to be able to help you.

     

    Can you tell us which version you are using and what exactly you are trying to accomplish with this percentage?

     

    Hope this helps.  

    Folks for us, it's all about the Kudos.  If you think this suggestion was especially helpful, please consider clicking the KUDOS! (yellow) icon in this message.  Thanks.

    Nancy Duhon, Esq.
    Certified Consultant for Timeslips, Amicus Attorney and Credenza
    Duhon Technology Solutions, LLC
    duhon@duhon.biz
    404-325-9779
    Providing personalized local and remote online support for Timeslips users for over 17 years.

  • I gave up, but...I found an old bill and the interest rate was calculated in.  So I had actually put it in at 8%.  Now it simply won't come up, or calculate at all.    I was going to try doing an amortization on Excel which will be hard to do since there are NEW charges to ADD IN. (sigh).  Last bill that calculated was on 5-18-10, so I would have a year to try and figure it out on Excel.  There is a glitch somehow.

  • where do I find the version. Is it TS 10.5 Remote? It is an update from about May 2010.


  • katemcleod wrote:

    I gave up, but...I found an old bill and the interest rate was calculated in.  So I had actually put it in at 8%.  Now it simply won't come up, or calculate at all.    I was going to try doing an amortization on Excel which will be hard to do since there are NEW charges to ADD IN. (sigh).  Last bill that calculated was on 5-18-10, so I would have a year to try and figure it out on Excel.  There is a glitch somehow.


    Are you trying to charge interest on the overdue balance?  Open the Client Information (name and address area) and then click on the Arrangement 2 tab.  Mid-way down it will have an Interest section.  Plug in the ANNUAL interest rate.  You may need to tweak these settings a bit to get exactly what you need, but that should get you started.

     

    BTW, 10.5 has a copyright of 2001, making it over 10 years old.

     

    Hope this helps. 

    Folks for us, it's all about the Kudos.  If you think this suggestion was especially helpful, please consider clicking the KUDOS! (yellow) icon in this message.  Thanks.

    Nancy Duhon, Esq.
    Certified Consultant for Timeslips, Amicus Attorney and Credenza
    Duhon Technology Solutions, LLC
    duhon@duhon.biz
    404-325-9779
    Providing personalized local and remote online support for Timeslips users for over 17 years. 

  • I will try again.  But I already had put in the 8% calculation and it shows that.  but won't calculate.  The bill is continuing, so the % should still calculate in the end.  I just didn't have enough sense to finalize the bill as It is being paid on every month.  And yes, this timeslips may be 10 years old, but we purchased an update, and it has 2010 on the Cd and says to use this CD to install Timeslips 2010.  I hope there is nothing wrong with this, or that TS  gave us the proper CD.

  • I have checked to do as you said, but, I had already done that.  I simply cannot get it to calculate.  Can you figure out why it won't calculate?


  • katemcleod wrote:

    I have checked to do as you said, but, I had already done that.  I simply cannot get it to calculate.  Can you figure out why it won't calculate?


    Do they actually owe a balance?  It will only calculate on OVERDUE balances. 

     

    You can try and run a Prebill Worksheet to see how it is calculating.

     

    Hope this helps. 

    Folks for us, it's all about the Kudos.  If you think this suggestion was especially helpful, please consider clicking the KUDOS! (yellow) icon in this message.  Thanks.

    Nancy Duhon, Esq.
    Certified Consultant for Timeslips, Amicus Attorney and Credenza
    Duhon Technology Solutions, LLC
    duhon@duhon.biz
    404-325-9779
    Providing personalized local and remote online support for Timeslips users for over 17 years. 

  • You might also want to check your Grace Period and other variables on the Arrangement 2 tab, then check out the Timeslips Help on the topic "interest"  which does (at least in TS2009) go into GREAT DETAIL about how the interest is calculated, including some examples!

     

    Let us know if you continue to be stumped or solve the problem.

     

    Good luck!

     

    -laurie

  • I have checked all the variables.  I think I am done with TS and will get an easier program.  This is so difficult.  and it most certainly did calculate before, and won't now.  I can't even figure out what AR means.


  • katemcleod wrote:

    I have checked all the variables.  I think I am done with TS and will get an easier program.  This is so difficult.  and it most certainly did calculate before, and won't now.  I can't even figure out what AR means.


    Are you trying to calculate the percent of interest due on a bill you already sent and they have not paid?

     

    Or are you trying to add in a surcharge as a percentage of the total bill?  If the total new charges are $100.00, then charge an additional $6.00 as an administrative surcharge for a total bill amount of $106.00.

     

    Those would be two different things and we would achieve it via different means.

     

    Hope this helps. 

    Folks for us, it's all about the Kudos.  If you think this suggestion was especially helpful, please consider clicking the KUDOS! (yellow) icon in this message.  Thanks.

    Nancy Duhon, Esq.
    Certified Consultant for Timeslips, Amicus Attorney and Credenza
    Duhon Technology Solutions, LLC
    duhon@duhon.biz
    404-325-9779
    Providing personalized local and remote online support for Timeslips users for over 17 years. 

  • You made a comment that implied you have not approved the bill. Timeslips will not calculate interest unless the bill is approved. If you run an Aged AR report, does the client have a balance?

    Timeslips is not really difficult if you know how to use it. Switching programs can be alot of work and expense. You might find it worthwhile to spend a little time with a certified consutlant who can help you make TImeslips work for you more easily.