Accounts payable report showing payables for next 1-3 months
![Carrie_7009426](https://us.v-cdn.net/6032430/uploads/defaultavatar/n0GFDAFXW1RQJ.jpg)
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
We are running Premier 2015 Manufacturing and Wholesale Edition
1
Comments
-
Try A/P Ageing Detail0
-
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.0
-
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
0 -
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.
0 -
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
0 -
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 G0
-
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.0 -
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 G0
-
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?
0 -
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 long0
-
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.0
-
Yes, I tend to agree. It is only an indication of the spread of bills - not very helpful for when they are due.0
-
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.0
-
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
0 -
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.1
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community