A/P Aging Summary

  • 1
  • Question
  • Updated 4 weeks ago
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
Photo of Megan

Megan

  • 110 Points 100 badge 2x thumb
  • frustrated

Posted 4 weeks ago

  • 1
Photo of Kris Williams

Kris Williams

  • 11,978 Points 10k badge 2x thumb
What version of Reckon are you running?
Photo of Megan

Megan

  • 110 Points 100 badge 2x thumb
2020
Photo of Kris Williams

Kris Williams

  • 11,978 Points 10k badge 2x thumb
Reckon One, Reckon Hosted, Reckon desktop? 
Photo of Megan

Megan

  • 110 Points 100 badge 2x thumb
Oh right sorry, I haven't used Reckon before.....Reckon Accounts Premier Manufacturing & Wholesale Edition 2020...?
Photo of Kris Williams

Kris Williams

  • 11,978 Points 10k badge 2x thumb
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
Photo of Megan

Megan

  • 110 Points 100 badge 2x thumb
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..
Photo of Kris Williams

Kris Williams

  • 11,978 Points 10k badge 2x thumb
If you go to pay bills and show bills due on before 20th, but it’s not a report
Photo of Megan

Megan

  • 110 Points 100 badge 2x thumb
If  I change the date to next month then I get an accurate summary and it will split this month and the next month up. I then have to export it to excel and change the due dates at the top.
Photo of Kris Williams

Kris Williams

  • 11,978 Points 10k badge 2x thumb
Glad you found a workaround