How do I run an accurate A/P aging summary to show totals of May invoices and June invoices seperately? At the moment they are all coming under the current column and if I change the date to 31/05/20 then it doesn't take into account any payments made in June
If you go to reports, Accounts Payable, you can get a supplier balance summary as at any date you wish, but yes a balance as at 31/5 will not include payments in June. There is also an Unpaid bills report which regardless of the date you choose it will always include any payments up to now, check these out and see if they suit your purpose
The unpaid bills report gives an accurate total for each supplier up to the end of May. It doesn't show aging though. Ideally I want an aging summary so I can look and see what is going to be due on the 20th of this month for each supplier as well as what is over due. I thought this would be a common thing for accounting programmes? It's like it needs another column before current that is labelled future for all the current month invoices to go into..