Debtors On A Date

Summary:

Lists all the debtors on a specified date
Note, this report does not unreconciled payments into consideration. An alternate report for this can be supplied upon request.
​
​

Parameters

Display:

Defaults to ‘All’. This will show all appointments regardless of what business they may be linked to.
‘Business Clients’ Will only show appointments for appointments that are linked to a business.
‘Self Funding’ Will only show appointments for appointments that are not linked to a business.

Business:

Leaving this blank will pull through all businesses and self funders depending on what the parameter above is linked to. Otherwise, you can select one or businesses from the list.

Location Status:

As default it will only display data for Active & View Only locations. To see 'All' this will need to be selected

Location(s):

Leave blank to show data for all locations from the setting above. For example, if no locations are selected it will look for all 'Active & View Only’ locations as shown above.

Invoice Status:

Leave blank for all. Can narrow the report down by unpaid and paid invoice status.

Debtors On A Date:

Defaults to today. If you want to find invoices in debt on a specific date, change this date field.

Group By Location?

Separates the data into location groupings, with totals per location at the bottom of each group

Group By Account?

Separates the data by account, with totals per account at the bottom of each group.

Account Name:

Left blank as default, should you want to only show data for certain clients or businesses you can type their name in here.
Press the + button enter their name and then submit.

Note: If more than one grouping is selected they will stack one under another in the order they appear in the parameter section.

Once you submit your parameters you can save this as a preset by pressing save at the top right-hand side of the report.

Columns

Invoice Ref:

The invoice reference number. This is hyperlinked and once clicked on will open the invoice on a new tab.

Location:

The location linked to the invoice

Clients On Invoice:

When more than one client is on the invoice this will remain blank. When one client is on the invoice it will print their name.

Client Reference:

When more than one client is on the invoice this will remain blank. When one client is on the invoice it will print their reference.

Invoice Date:

The date the invoice was raised.

Account Type:

This will print either the business name or ‘Self Funding’

Account Name:

The name of the account the invoice is linked to

Charges On Invoice:

This will remain blank if multiple charges appear. If there is just one it will print the charge description.

Days In Debt:

Number of days between the invoice date and the date on the report.

Status On Date:

It uses the payment date to determine when an invoice was paid. If the report date was before the payment date, the status will say ‘unpaid’. If the payment date was before the report date but was only part paid it will say ‘part paid’

Invoice Total On Date:

The total of all billing items before or on your report date, linked to this invoice.

Outstanding On date:

The amount outstanding on the invoice before or on your report date.

Invoice Current Total:

The current total amount on the invoice today.

Outstanding Current:

The outstanding amount on the invoice today

If exporting the data into a CSV or Excel file, the grouping parameters should be ignored.