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 , 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).
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
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
