Sage 100

Customer is upgrading to 100c v2018 (coming from 4.30!). They are a Clearing House and hold funds for customers. Customers are asking for interest on their money while being held, so customer is asking if there is any Add On that would calculate Compound Interest? Anybody have any ideas or know of a program even if not and Add On that would do this? They don't feel comfortable doing Excel Spreadsheets for this from an audit standpoint.

Not an answer but an idea - can you use the Finance Charge option in AR as a starting point?

Unfortunately, that would generate a fee to the customer, not a credit. The entry program won't allow you to enter it as a negative value, and it would apply across all customers, which you may not want. Perhaps a cash receipt import as a G/L cash receipt and calculate the amount using Crystal to create the export as a csv value with the calculated interest and use that as the source for the import. Otherwise, you will need to bite the bullet and have a compound interest program built that does that process so you can correctly post to both the A/R and to G/L.

Are you interested in a solution that will provide the amount but not transfer to Sage. If yes, look at TValue, timevalue.com.