Debtor records in Music Monitor show the current balance for each debtor. To calculate what a debtor's balance was at a date in the past, you must check every line item for when it was created so you can include those prior to your target date but not those created since.

The Debtor Report can be used to find a debtor’s balance for a particular date.

Initiate the script from one of two places:

The first window that comes up invites you to enter the date at which you want to find the balance.

You can optionally enter a debtor name to find the balance for that one debtor, or leave it blank to find all balances at that date.