reporting of purchases

Hey Mike - Thank you,  I appreciate the time you have given in replying, but I beg to differ.

When you generate a report that gives you a total value of expenditure against a suppliers card, and then you generate the report right next to it that supposedly gives you a history of the same supplier, then really it should show ALL transactions made under that supplier - whether they be recorded as spend money or not - they are all against the same supplier card - they are all purchases and should be reported as such. If one report can generate a total, the other report could surely show a history to match it.
The whole point of bank rules for recurring transactions is to save time - what good are bank rules for recurring transactions if you can't set them up for this - it asks in the rules for the suppliers card.
The reporting isn't accurate if you can't match a total given in one report, to the history of transactions in the other. I think this is wrong of MYOB to set it up this way if that's the case  - it would would make more sense for both reports should show the total of expense with that supplier.  If it's only showing half the answer, then the report is useless really. 

Hi Feebie , the transactions created via the bank feed rules are Spend Money type, where no bill is created. Purchase reports only include purchase bills, therefore all the Spend Money transactions will be excluded. You would need to create bills for those (S/M) transactions, and perhaps match the payments to those bills via Bank Feed (no rule required). 

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*

Hi Feebie,

Thank you for sharing your feedback and for letting me know about your concern with the reports. This is not the experience and support we want to provide our customers. I completely understand your frustration with the reports, and I apologize that these software reports can't provide you with all the information you need for your business.

Regarding the reports, I'm sorry to inform you that there's no report I can run that will gather all the information for the supplier. I've tried replicating on my backend and checking each supplier report, but unfortunately, it's not giving me all the information.

However, I've passed this along to the relevant team. I truly value you as a customer and apologize for any inconvenience caused. I encouraged you to post this feedback to our AccountRight Exchange ideas for consideration by our developers. Once again, thank you for your patience and understanding.

Cheers,

Princess