Overview
This function only applies if you record incoming payments within Music Monitor. If you manage all incoming payments in another system, it doesn't apply.
The Debtor Report is a flexible report on amounts billed, amounts paid and account balances for any time period, and summarised by almost any field. It starts by calculating a debtor balance as at a specified date. From there you can use the inbuilt options to display different data relating to the Debtors and Line Items concerned.
Run The Debtor Report
Go to Common Tasks > Financial Reports > Debtor Report
The Date field will pre-fill with today's date. If needed, select a different date from the date picker.
Optionally, enter a Last Name to generate the report for one individual Debtor
Music Monitor will calculate the Debtor balance as it was at the date you selected.
The report will open initially showing only three totals - Invoice Total, Amount Paid, and Outstanding.
Expand and Refine the Information
Show Breakdown
To display detailed information, select the blue Display and summarise by... button. Options are:
Debtor: Lists each Debtor represented in the report and shows the three totals for that Debtor
Days Overdue: Shows an entry for each Days Overdue value represented in the report and shows the three totals for those records
Debtor AND Days Overdue: Groups first by Debtor and then further breaks down that Debtor's balance into different entries for different Days Overdue
More Detail
When you select the blue Show Detail button in any summary, the report lists every invoice found in your initial search.
Remove Those Not Oustanding
Select the blue Hide Zero or Credit Balances to hide summary groups with zero or credit balances.
Note: This option is available only for reports generated for today's date, not for past dates.
Use the Data
There are several buttons to perform other functions you may need when analysing outstanding amounts.
The Invoice Date and Invoice Ref entries are links to the related invoice. Select the entry to open the invoice and view it.
The debtor’s Name is a link to the related Debtor record. Select the entry to open the Debtor record and view it.
There are three icons in the black top bar:
Save as Excel: Exports your current view as a spreadsheet.
Print: Downloads and opens a PDF of your current view.
List: Opens the related Line Items as a list in a new window, leaving the report still open.