Allocating payments against oldest outstanding invoices - shadow ledger?

Suggested

Hi all,


After some help please:

For Credit Insurance purposes, a client of ours needs to be allocating any payments received against the oldest outstanding on the ledger. This determines when they need to stop supply and report non-payments etc and remain compliant.

They don't currently do this as it would cause all sorts of issues with allocating against incorrect PO's etc.

My question is, is there a simple way to do this so that they almost run a 'shadow ledger' where everything gets allocated against the oldest first, which would make it 1000 times easier for them to stay on top of the credit insurance requirements?

I hope this makes sense!

Thanks in advance.

Parents
  • 0
    Suggested

    Hi Dean,

    When posting customer receipts, presuming this relates to customer payments against outstanding invoices, you can sort the outstanding invoices by date so that the oldest appears at the top of the list. This would still be a manual process but it would be a means of ensuring the oldest outstanding customer invoices were paid off first.

    To sort the outstanding invoices, in Bank Accounts > Customer Receipt > Enter the customer account reference and once the list of outstanding items appears, click the Date column heading to re-sort the transactions in date order either ascending or descending as required.

    If this helps, please click Verify Answer.

    Andy,
    Sage UKI


  • 0 in reply to AndyR.
    Suggested

    When doing receipts, if the payment will cover multiple invoices, you can enter the receipt amount and click on automatic. This will pay invoices in full going down the grid. Unallocated Credit notes make a mess, so allocate credit notes as soon as they are issued.

    If you mean that you want to run to parallel sets of allocations, then there is no way short of running two separate companies in Sage and doing the work twice

  • 0 in reply to Ken Fillmore 2
    Suggested

    I suppose you could write a report that listed invoices (allocated or not) newest to oldest stopping when the customer balance is reached. An interesting challenge for the report writing team!

    Then you can continue allocating as you see fit and send the report to the credit insurance company

Reply Children
No Data