Accounts payable report showing payables for next 1-3 months

Carrie_7009426
Carrie_7009426 Member Posts: 67
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

Comments

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020
    Try A/P Ageing Detail
  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited July 2019
    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.
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited September 2018
    Hi Carrie, talk to me , if this report is "do and die"issue we can get it done.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited July 2019
    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.

  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited July 2019
    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

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • John Graetz
    John Graetz Member Posts: 1,651 ✭✭✭
    edited July 2020
    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
  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited July 2019
    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.
  • John Graetz
    John Graetz Member Posts: 1,651 ✭✭✭
    edited July 2020
    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 
  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020

    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?

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020
    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
  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited July 2019
    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.
  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited October 2016
    Yes,  I tend to agree.  It is only an indication of the spread of bills - not very helpful for when they are due.
  • Carrie_7009426
    Carrie_7009426 Member Posts: 67
    edited October 2016
    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.
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited December 2016
    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

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited February 2017
    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.