Details of Supplier Payments Due

[linus]

Hi

I'm new to this forum.

I've looked for previous post regarding this but couldn't find anything.

Looking for a report/schedule showing supplier invoices that are due for payment on a particular date. The report should have the following data points
- supplier name
- invoice number
- amount

This will help us to ensure that we know in advance when exactly suppliers are due to be paid so that we can manage our cashflow

Does Sage have a standard report for this

Thanks
Linus

[brucedenney]

The Batch Supplier Payments option shows you this information, you can then use the Excel integration to send the list to excel and work with.

I don't know of a report off the top of my head, although you could write one, If you did write it you would have a bit more flexibility as regards what the due date is, you can use the due date on the transaction or use the date of the transaction or use the date of the transaction and the current credit terms to determine when things are "due"

[Lad]

Bit late to the party here, but I use a report for similar but not precise purposes.

It is the "aged creditors analysis (drillabe)"

From that report, I get to see all suppliers and the amount outstanding currently, the amount in period 1 (30-60 days), period 2 (60-90 days) Period 3 & Older.

The balance in each outstanding section is hyperlinked or "drillable", allowing my to click into each and see exactly what the reference number, invoice date and balance is.

Hope this helps.