1 Topic by t2webby (edited by t2webby 08/06/2008 07:36:28 pm)

  • From: Canada
  • Registered: 06/04/2008
  • Posts: 72

Topic: Aged Supplier / Aged Customers Analysis

This could be just me not understanding the logic, i'm not sure but an improvement in the ways it shows the current and 0-30, 31-60, 61+ could be better shown as follows:

Let's say we had 300$ - 60 days overdue, $200 of an invoiced as been payed that was originally within the 0-30 days overdue stage, and there is a 100 in current 'non' overdue invoices. The total balance would for a particular customer/supplier would be 400

Instead of:

Current    0-30    31-60     over 60    balance

600           -200     300         0               400

A better way to show it would be:

Current    0-30    31-60     over 60    balance

100           0         300         0               400

* Current to me shows what receivables/payables that are not yet due, while the 0-30, 31-60, over 60 shows what is actually due to pay or received starting with 0-30 days overdue.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Aged Supplier / Aged Customers Analysis

The algorithms for the aged analysis is:
for invoices the duedate is taken as a parameter and for all other items (payments and credit notes) the docdate/paydate is taken as a parameter when calculating the aging. This is the most common way of doing it.

/Joe

  • uma
  • Member
  • Offline
  • From: Russia, Moscow
  • Registered: 04/25/2011
  • Posts: 25

Re: Aged Supplier / Aged Customers Analysis

t2webby wrote:

This could be just me not understanding the logic, i'm not sure but an improvement in the ways it shows the current and 0-30, 31-60, 61+ could be better shown as follows:


I agree with t2webby, i also didn't understand the sense of result view
Example
Terms: Due 15th Of the Following Month
Currency     RUB
invoice = 1800
paid = 2000 and has been done reconcile of 2000 to 1800, left 200
----> result view
Current            1-30 Days     31-60 Days     Over 60 Days     Total Balance
1 800,00     -2 000,00     0,00                     0,00                -200,00
Why the reconcile doesn't work? The really this invoice was paid and no liabilities during this periods. The customer is creditor. Such report distorts the data. Is anyone who solved this problem?
Uma

skype: uma702

uma's Website