Debtors By Account

Summary:

Lists all accounts in debt with their outstanding invoices.

Parameters

Location Status:

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

Location:

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.

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.

From:

This will show all invoices in your date range

Invoice Status:

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

Account Type:

Leave blank for all.. Can narrow the report down by self funding or business clients

Group By Location?

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

Group By Account Type?

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

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

Location:

The location linked to the invoice

Account Name:

The name of the account linked to the invoice

Account Type:

Either group or private

Account Balance Invoiced:

The collective total of balance invoiced. I.e the total amount remaining on invoices for that account.

Invoice Date:

The date the invoice was raised

Invoice Reference:

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

Invoice Status:

The current status of the invoice

Invoice Grand Total:

The overall total of the invoice. This will be the combined total of all charges on the invoice.

Amount Paid:

Amount reconciled against the invoice.

Amount Remaining:

Amount left due to be paid.

Client Name:

The full name of the client. This will be hyperlinked, which when clicked will open the client record in a new tab.

Client Reference:

The reference number of the client

Balance Text:

Will remain blank if the account is in debt.
If the account is balanced it will display.
‘Account Balanced - Check for unreconciled payments’
If the account is in credit it will display
'Account In Credit - Check for unreconciled payments'
​
​

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