I'm new here and also relatively new to accounting - I took over the day-to-day accounting of the business I work for last August.
I use Sage Instant Accounts and my question relates to being able to print a list of supplier invoices due for payment on or before a specific date. I know that in the supplier record you can set due dates and payment dates, but this seems too generalised for my use - the point is that many of the suppliers which we use do not have set payment dates (ie. 30 days as a standard). Some are 30 days, some are end-of-month following invoice and some have special credit terms which can vary depending on supplier and time of year.
Whilst I use the diary feature to keep on top of all of this on a day-to-day basis, my boss keeps asking for a printout detailing the invoices due in the upcoming weeks and the related due dates and amounts. Is there a way of Sage dealing with these varying payment due dates and allowing for a report to be printed to fulfill my bosses needs??
Only way i can think is if you run a detailed aged creditor list. This will list the invoices outstanding at the date you run the report for and will list by supplier the invoices outstanding and the amounts.
I suppose when you process the invoice you could enter the due date in one of the reference boxes so you can see the date due when you run the detailed aged creditors report.
Not sure if you can run a report of invoices by date due but someone with more SAGE knowledge than myself may be able to point you in the right direction.
There is actually both a payment due report and an overdue report that can be run (certainly on line 50 not sure about instant) but it is dependant on if you have the correct payment due days in the credit part of the supplier account setup.
Thanks, but I think that this still does not solve the problem of having different due dates for different invoices from the same supplier - for example, if a certain invoice is on extended credit terms.
I think the idea of entering the due date in the 'Extra Reference' field might be a good idea tho
