Debtor Days Calculation

The Debtor Days is to calculate the total amount that is paid per transaction per day. The total turnover is paid over a certain period of time.

  • Log in to the GoodX Desktop App with your username and password.
  • Double click on the Financial Reports module.

  • From the Navigation bar, click on Debtors.

  • From the drop-down, click Age Analysis.

  • An episode screen will appear, click on the correct Age analysis, click on the Edit button.


  • The Report parameters screen will appear.


  • Click once on the Next button.

Number of periods for debtor days calculations:
  • Select 1, it will calculate the current debtor turnover plus 1 previous month, click next.

  • From the print screen, the summary will appear at the bottom with the debtor days on.

How to calculate the Debtor Days(30): Use current turnover + 1 previous months turnover (Jul + Jun)

Figures as on report date (e.g. end of period 202105)
Report
Period		 Calendar
month		 Fin Period Days per period Turnover Outstanding
Oct 202008 31 1,463.76 1,079.76
Nov 202009 30 37,936.77 36,645.57
Dec 202010 31 3,464.40 3,109.70
Jan 202011 31 25,364.65 20,553.12
Feb 202012 29 29,033.44 21,558.48
Mrt 202101 31 1,836.00 1,501.24
Apr 202102 30 30,471.56 27,309.52
May 202103 31 19,846.36 19,006.84
Jun 202104 30 5,794.01 4,536.50
X Jul 202105 31 6,443.40 6,443.40
161,654.35 141,744.13
Method 1 Use AVG turnover, calculated over PREVIOUS N periods Calc period cfg Avg turnover Debtor Days
calculated over 1 period (30 days) 1 12237.41 359.0684655
calculated over 2 periods (60 days) 2 16041.885 273.9122011
calculated over 3 periods (90 days) 3 20851.77667 210.7287115
Method 2 Use AVG turnover, calculated over N periods Calc period cfg Avg turnover Debtor Days
calculated over 1 period (30 days) 1 6443.4 681.9486653
calculated over 2 periods (60 days) 2 6118.705 718.1369309
calculated over 3 periods (90 days) 3 10694.59 410.8683016



  • Calculate the Average Turnover. (Current balance) R6 443,40 + (Previous months turnover) R5 794,01 = R 12 237.41
  • Debtor Days = Total amount outstanding x Days per period ÷ Average Turnover
    • Debtor Days = 141.744.13 x 31 ÷12 237.41 = 359.0684655
How to calculate the Debtor Days(60): Use current turnover + 2 previous months turnover (Jul + Jun + May)÷ 2
  • Calculate the Average Turnover. (Current balance) R6 443.40 + (2 previous months turnover) R5 794.01+ R19 846.36 ÷ 2 = R16 041.885
    • Debtor Days = 141.744.13 x 30 ÷ 16 041.885 = 273.9122011
How to calculate the Debtor Days(90): Use current turnover + 3 previous months turnover (Jul + Jun + May+ April)÷ 3
  • Calculate the Average Turnover. (Current balance) R6 443.40 + (3 previous months turnover) R5 794.01 + R19 846.36 + R30 471.56 ÷ 3 = R20 851.77667
    • Debtor Days = 141.744.13 x 31 ÷ 20 851.77667 = 210.7287115
Last modified: Wednesday, 24 February 2021, 11:09 AM