Debtors - Graph (Reports menu)
The "Graph - Debtors per week" displays the debit and credit transaction totals of all debtor (customer / client) accounts per week in a bar chart.
To print a Graph - Debtors per week:
1.On the Reports ribbon, select Reports → Debtors → Graph.
2.Select the Period - Select a period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates to include in the graph.
3.Click on the OK button.
Printed example : Graph - Debtor per week
An example of the "Graph - Debtor per week", is as follows:
The Outstanding amount should balance with the Debtor's control account on all reports, if the same periods are selected.
The details is as follows:
1.Vertical axis -
a)Positive amounts - Invoices and debit batch transactions (e.g. take on opening balances, adjustments, refunds (payments to debtors), generate multiple transactions (i.e. Interest on overdue debtor accounts, fixed amounts to all debtors and charge amounts), etc. per week.
b)Negative amounts - Credit notes, receipts (payments received from debtors) and other credit transactions (e.g. adjustments, bad debts written off, generate multiple transactions (i.e. Balance debtors with amount less than a specified amount), etc. per week.
2.Horizontal axis - This is the number of the week in the calendar year (1 to 52). Weeks 1 to week 8 is for January and February. Since the financial year starts on 1 March, the first week would normally be week 9 in this Set of Books.
a)Invoices/Debit transactions - The total amount value of debit transactions for the entire period.
b)Receipts/Credit notes/Credit transactions - The total amount value of credit transactions for the entire period.
c)Outstanding - This is the difference (movement) of the debit and credit transactions. A positive figure indicates that there are more Invoices and debit transactions than credit notes, receipts and credit transactions for the period.