The standard age analyses are fine, but are missing a vital piece of information, which is the payment terms. Using the 2 options,"n days form invoice date" or "n days after month end" I can map in Excel the suggested payment or receipt date of every transaction still outstanding on either debtors or creditors or both.
Most cash forecasts need this data anyway, so at a detail level, the addition of the payment terms makes the calculation possible.
Excellent idea... This would keeps a tighter grip on credit control.
Attachments Open full size