Accounts payable report showing payables for next 1-3 months

  • 2
  • Question
  • Updated 4 years ago
  • Answered
I need a report that I can spit out for the boss which will show the accounts payable in the next 30, 30-60, 60+ days.  The A/P Aging Summary report shows all "current" amounts lumped together, but many of these will not be due for >30 days.   It is a pretty important piece of information for keeping tabs on spending and thus cashflow.  Any ideas?

We are running Premier 2015 Manufacturing and Wholesale Edition
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb

Posted 4 years ago

  • 2
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,636 Points 5k badge 2x thumb
Try A/P Ageing Detail
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Hi Charles,  thanks for the reply.  The A/P Ageing Detail still lumps all "Current" invoices together.  We need to be able to split that up into This Month/Next Month etc.  I prefer the Aging Summary Report format.
Hi Carrie, talk to me , if this report is "do and die"issue we can get it done.
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Hi Chandra.  Thanks,  it isn't do or die - I can export the data and fiddle around with it in Excel.  I was just expecting to be able to pull that info out already.  Seems to us that it is a fairly critical piece of information to have when looking at finances and deciding when to spend money and when to not.
Yes, we have done something like this for Accounts receivable you can see the aging in the right column and also all invoice listed under the customer on the aging column, i think i may have in our website still :www.cosmicinnovations.com
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Hi Chandra,  This prob is that I am not, in this instance, interested in the aging info (which Reckon quite nicely displays).  I want to know what is due NOW (which includes all overdue) as well as what is due next month, and the next month etc.  We do feel that this is important information to have at hand when deciding what to spend and when.
Carrie, These reports what you require, many years  ago i used to play round with to
get what you want,there many work around options, as being suggested, lots of customised filtering is not available. Software is not high end product to cater for all these features, it has lots of great features, but cannot satisfy every ones customised requirements. Reckon Accounts is still the best software to meet the requirements for SME and even higher. we can have a look at it, to see if i can do  it for reasonable cost for you. let me know if all other options is not working for you.call me on 02 95411338 or 0407068942
Photo of John Graetz

John Graetz

  • 23,446 Points 20k badge 2x thumb
Hi Carrie.  There is a way in which you can potentially achieve what you want to do.  After you run the report, go to "Modify Report".  There you will find the reason why you are not getting the detail you are after.  By default, the date range is from today to today.  If you extend the "to date" to say 31/12/2015, you should see every bill reported in a specific time category.  I have just tested this and it works to a certain degree, but perhaps not perfectly.  You might need to do a bit of playing around with the "to date".  John G
(Edited)
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Hi John,  I like your thinking, though it does take some getting my head around when interpreting the results.  If you set the "to date" field to be the first day of the month (ie 01/01/2016) as opposed to the end of the month (31/12/2015) then the results are a truer reflection of when bills are due.  (the reason being that many bills are due on the 30th of the month and unless you alter the ageing period, any amounts due on the 30th of the previous month will fall into the incorrect aging bracket - of course different lengths months will change the results).  Not sure if the boss will have the capacity to do the mental gymnastics, but I can work with that data!!!  
Cheers.
Photo of John Graetz

John Graetz

  • 23,446 Points 20k badge 2x thumb
Hi Carrie.  In looking at this a bit closer, you need to be pretty alert in the understanding of what that report is really saying.  The end date or the "to date" becomes the effective date of the report and therefore the results could be quite misleading as far as reporting on future due dates. Therefore, to use an example,  If you have a bill due 15th August and run your report to 31/8 it will show as being due 1-30 days.  But, change the end date to 30/9 and it now becomes 31-60 days, which is not reflective of today's situation at all.  Quite frankly, unless you use a very near "to date" I don't think my suggestion is going to help, but instead it will become pretty useless.  John G 
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Yes,  I tend to agree.  It is only an indication of the spread of bills - not very helpful for when they are due.
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,636 Points 5k badge 2x thumb

At the top of the report window you have the option to change the 'dates', the Interval (days) and Through (days past due) and then Sort By

If you put the Dates as Today, the Interval (days ) as 7 the Through (days past due) to 60 and then Sort By 'Due Date" and then use the A/P Ageing Detail; does that help?

(Edited)
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,636 Points 5k badge 2x thumb
You could even put 1 in the Interval and then you will get a report that will tell you what is due 1 day; 2 days etc etc but it's a bit long
Photo of Carrie

Carrie

  • 1,066 Points 1k badge 2x thumb
Hi Charles,  the problem is that this report shows what is Current or Overdue at the date of the report.  I am interested in is a breakdown of what is due now, what is due next month, and what is due the following month so that we can make decisions on what to spend when.
Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Hi Carrie,

Try an Unpaid Bills Detail Report and then filter the Report for "Due Date" for a period - like next month.  Do one for each month in question.

Hope this helps,

regards,
John.