---
title: "Payment History"
canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31101155/Payment%20History"
format: markdown
---
Goal: There are four enquiry options available:   Number of Days The easiest way to explain the number of days in the payment history enquiry might be by way of an example: Account Balance = 100,000 Current= 20,000 30 Days= 60,000 60 Days= 20,000 90 Days= 0 120 Days = 0  Sales History Current= 20,000 30 Days= 60,000 60 Days= 40,000 90 Days= 10,000 120 Days = 15,000    BALANCE FORWARD ACCOUNTS The program firstly works out the total sales which are overdue by subtracting the 'Current' due from the 'Balance Due' i.e. 100,000 - 20,000 = 80,000.  It then searches through the customer's 'Sales History' (starting with last months sales and working back) until it has accumulated sales for the total amount overdue, i.e. 60,000 from 30 Days + 20,000 from 60 Days.  It then takes the amount that is overdue for each period (above) and multiplies it by the period days overdue i.e. 60,000 x 30 and 20,000 x 60.  The results for each period are added together and divided by the total amount overdue, i.e. 1,800,000 + 1,200,000 = 37.5 80,000 The result of this calculation is displayed in the 'Days' field on completion of the Month End close.  OPEN ITEM ACCOUNTS The number of 'Days' in the payment history for open item accounts is calculated as follows:  which invoices were paid over the month, then which ones were paid on time and which ones were overdue, i.e. not paid within 30 days of statement date, · 'Days' paid overdue will then be calculated for each invoice and averaged (number of days overdue/number of invoices paid for the month).  The number of payment days overdue is calculated as follows:  If the invoice is paid within 30 days of the statement date then the overdue payment days = 0.  If the invoice is not paid within 30 days of the statement date then the overdue payment days = the number of days over 30 days that the invoice was paid by.  For example, Inv 123 Dated 23-05-10 was paid on 15.07.10. Therefore the payment days overdue for this invoice would be 15.  If there were 2 other invoices for the month that were paid on time (i.e. days overdue = 0), then the payment days overdue for the month would be 5, i.e. (15 + 0 + 0)/3 = 5.  N.B Unpaid invoices are not taken into account.