I have been building solutions on Nimble AMS for over ten years and share my recommendations about approaching this AMS that's built on Salesforce.
Unbeknownst to many Nimble AMS clients is that Nimble has a very handy tool for calculating Accounts Receivable (AR) as of a past date.