FrontAccounting forum — Aged Supplier / Aged Customers Analysis

Re: Aged Supplier / Aged Customers Analysis

2011-04-26T16:00:10Z

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

Re: Aged Supplier / Aged Customers Analysis

2008-08-07T09:19:04Z

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

Aged Supplier / Aged Customers Analysis

2008-08-06T19:15:40Z

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.