PDA

View Full Version : aging receivables


dhart999
02-08-2002, 06:26 AM
We have found that invoices that are over 30 days due do not appear in "over 30" column on the Aging A/P Report -- they appear in the "current" column. I entered an invoice with a due date of 2/8/02. I ran the A/P Aging Report on 2/11/02 and this invoice appeared in the "current" column.
Does anyone know why this would happen?
Thanks.

Deborah Bean
02-08-2002, 09:19 AM
I think you mean you ran the report on 3/11 or the invoice was dated 1/8.

Account Aging is based on either the Invoice Date or the Due Date. This is handled in the Customer Defaults. From my book that will be out in June:

Account Aging
The second tab of the Customer Defaults is the Account Aging tab and it controls how the age of your invoices is displayed in the Aged Receivables and other reports.
1. In the top section, Age Invoices by, you have two options—Invoice date and Due date. If you have an invoice that is dated April 5th and the invoice is unpaid on May 15th, you can count the age of the invoice in one of the two ways. Aging by invoice date will make the invoice 40 days old because you start counting from the first date of the invoice, April 5th. If you choose the other option, by due date, the invoice is only considered to be 10 days old because you didn’t start counting the age until May 5th. Most companies choose to age their invoices by invoice date.
2. The lower section, Aging Categories, controls how your Aged Receivables report looks. The Column Heading field for each column shows the heading for each column across the top, described as 0-30, 31-60, 61-90, and Over 90 days. The # of Days column shows the maximum age that can appear in each column. Obviously there is not a # of Days field for the 4th Column line because it contains all invoices that are not in the other columns.
Each column lists the appropriate invoices and totals in its column based upon the age of the invoices that we have set.
Be aware that if you select Due Date to age your invoices, and you accept the default aging on your A/R, then when your Aged Receivables report prints, it will show the invoices in the column for their age based on the date the invoices are due. This means that some invoices in the 0-30 column will have a negative age. A customized Aged Receivables is shown here to illustrate how the invoice and due date affect the age.

dhart999
02-12-2002, 08:10 AM
Thanks for the info.
I believe the problem we are having is because the A/P person is leaving the default date in the date field when entering invoices.