Jump to content

Adding interest to overdue accounts


This topic is 7870 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am having a prolbem with adding interstto my overdue accounts. I have an aging field and an orde total, but is there an easy way to automatically add interest to an invoie that is out 30 days and then keep updating the interst with each statement?

Link to comment
Share on other sites

It's easy to add interest. The trick is figuring out when not to add interest. It depends how your database is set up. Here are a couple of ideas...

If you are tracking the payment of individual invoices by applying payments to the oldest invoice and marking it paid (by setting a paid field), then use the paid field and the invoice date as a test to determine whether to accrue interest.

If you are only keeping a customer balance owing, you will need a new charges field, and an existing balance field. Every month, add interest to the existing balance, then add the current charges to existing balance. Clear the current charges and calculate the new current charges.

Link to comment
Share on other sites

This topic is 7870 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.