reporting of purchases
We have purchases which go to a supplier paid on invoices received. We also have purchases that go to the same supplier thru Bank Feed automated transactions - the rule is set up properly and goes t...
Forum Discussion
Hi Feebie
Thank you for your post.
In this matter, the supplier payments report will only show transactions that have been recorded as payments. You can try to record one of your bank feed transactions as a supplier payment to see if this will reflect in the report.
However, as we value your feedback, we'll surely pass it on to the relevant team.
Cheers,
Princess
Hi Princess, thanks for replying. All of our bank feed rules are linked to a supplier card, they are all purchases so really should show up on the Supplier Purchases report. We have a couple of suppliers who have standard monthly payments for rental of equipment - these are entered as bank rules for the bank feed to automatically allocate and process to the supplier. The bank feeds are there to make automated transactions easily tasked, and if they are already linked to a supplier card, then the information is there. We are also billed invoices for work performed during the month which we enter to MYOB thru purchases and the payments thru pay bills. The work paid by bills are allocated to different expense codes. If we want to find out how much we are spending in total with this supplier we should be able to run a Supplier Purchases report and get ALL the information and broken down into expense codes. I think it's a fairly important report to be corrected.
Thank you for understanding and sending this on to the relevant team for fixing.
kind regards
Hi Feebie,
Thank you for your response. We appreciate you explaining how it would help you out, and we understand how important the Supplier Purchases report is to your business. However, this is how AccountRight currently works, and it has limitations on generating all the transactions for suppliers. We thank you for your understanding on this matter, and we truly appreciate your feedback and suggestions for our system. We also recommend posting your concern in AccountRight Exchange Ideas for consideration by our developers.
Cheers,
Princess
Thanks Princess - I will definitely put in the request.
Just to clarify though, when we run a report on the supplier thru the Supplier Payments Report - this gives just one actual total for the period (we ran for the July - June 2023 yr) - and that total figure "seems" accurate.
This means that MYOB already has the capacity to source all of the information for that supplier (including the automated amounts from the bank feeds) into that report.
If the report can already do that, and provide a total, it stands to reason that the Supplier Payment History Report - which is a history of the payments made to the supplier, would be able to mirror that process and provide a full history in detail of all transactions from that Supplier.
It really isn't good enough to say that "this is how MYOB currently works" - a Supplier Payment History Report should show the history of the supplier - its not called a Supplier Payment Part-History Report.
Thank you for your response, but really I feel it's a little condescending and the correct reponse should be - "thanks for letting us know about that, it does seem odd that one report does not match the other, and also odd that one report includes the bank feed transactions but the other report doesn't. I will forward this to the fix-it team and hopefully it will come out in the next update ..."
...but it's fine.... don't worry..... I'll do it.... thanks for understanding I truly appreciate your feedback and suggestions for how I should expect this report to not be correct.....
Hi Feebie,
Thank you for your response. I apologize for any inconvenience caused, and I'm sorry for not being able to provide you with an accurate response. I misunderstood the report you're looking for.
If you are referring to the Supplier Payments report, this report totals all cash disbursements made to suppliers within the period range, while the Supplier Payment History report shows all the purchases that were included in each payment you've made to your suppliers during a specific period. You can try to run the two reports to see the difference and determine if there's an issue with the report.
Thank you once again for your feedback. Your patience and understanding are really appreciated.
Cheers,
Princess
I'm beginning to believe that I'm caught up in some nightmare revolving door.
I don't know how else, or how many different ways I can say what the problem is, so I will now break it down into dot points:
1. The Supplier Payment report - provides us with a one line total sum of purchases (Payments) we have made to a certain supplier. BUT what we need is a list of those purchases that will give us a breakdown of the expenses (ie) where the payments have gone ... rental, maintenance etc. So for this we turn to the Supplier Payment History Report - which by its name alone should provide this history.
2. The Supplier Payment History Report does provide a breakdown to a degree BUT THE TOTALS DO NOT MATCH THE SUPPLIER PAYMENT REPORT. This report fails to take into account the purchases made to the supplier card from the bank rules.3. The Supplier Payment Report does not provide the full expense details of the Supplier - it only shows the expenses that have come thru the business as invoiced PURCHASES, paid thru Pay Bills. All expenses that go to a Supplier Card are Purchases - whether or not they go thru spend money, bank feed, or pay bills. If they go to a Supplier Card, they are purchases - we are not just giving them money for something to do- they are purchases. If you ask for a Supplier Payment History, you want the history of the payments made to that supplier - all of them, not just some of them
4. The only other way is to access the various General Ledger expense transactions that this supplier has been allocated to, separate them out from the other suppliers allocated to those expense accounts, and manually add up all of their transactions. This is ridiculous when you have a report sitting there labelled Supplier Payment History.
IF you're now telling me that the Supplier Payment Report is only the cash disbursements made thru Spend Money or bank rules -HOW DO WE KNOW THIS? If that's the case, then the report needs re-naming as it is extremely misleading But we still need a breakdown so we can see what it is.
Also if the Supplier Payment History report is only the expenses thru paid bills, ALSO MISLEADING. it is not a Supplier Payment History report if it doesn't show ALL THE HISTORY OF THE SUPPLIER.
i'm guessing now that we need to add the two reports together to get the TOTAL of what has been paid to this Supplier. Is that right????? BUT WE STILL DONT HAVE A BREAKDOWN. *sigh*
