Collins329's avatar
Collins329
Partner
11 years ago
Status:
Open

Report: Purchase by item

You have the 'Sales by Item' report so why not 'Expenses by Item'?

 

You are able to enter a new Item for each side of the transaction so why not be able to report on both???

 

Thanks

 

"Reports - Expense by Item"

13 Comments

  • Hi Dev Team,

     

    Could we please have a report in Essentials that lists all my purchases by Items.

     

    Like the Sales by Items, but so I can see what I have purchased without having to dump the Bills by Supplier report to Excel, and then fishing out all the transactions that are relevant.

     

    I can't believe that this is missing.

     

    Thanks,

     

    Alan

     

    "Purchases by Item report is needed"

    • KattC's avatar
      KattC
      Former Staff
      Status changed:
      New
      to
      Open

      Hello AlanT 

       

      Thanks for the great suggestion, you can print a report similar to this request by going to Reports>>Bills Reports>>Bills by Supplier >>Tick Item Detail>>Select Dates>>Generate Report. But as we have discovered in an earlier post you cannot export this report to excel all will need to be done manually.

       

      I encourage all users that would like this report to be made available in Essentials "Purchases by Items"  and bring able to be exported to excel to vote and comment on this idea. 

    • HDuggan's avatar
      HDuggan
      Cover User

      I would find this useful too. Also the ability to export all reports to excel. Thanks

    • SamanthaMoore's avatar
      SamanthaMoore
      Partner

      This is an important report given that Essentials does not have job costing capabilities. 

  • CafeThePreVue's avatar
    CafeThePreVue
    Contributing Cover User

    We have painstakingly entered items and corresponding prices to every single item we purchase for stock when we enter our bills, however have just discovered there is no report so that you can track these items per month/week/year.

    For example, we want to see how many litres of milk we purchase over a month, and despite having "Milk 1L" as an item, there is no way to view this report, and instead we have to go through each invoice and manually compile this information.

    Very strange as I know there is an items sold report! 

    • sid72's avatar
      sid72
      User

      YEs!, this would be extremely helpful - why have the sales side and not the purchase side? additionally I would like to have an item that I purchase but don't sell. Such as fuel, I am eligable to claim fuel tax credits, but MYOB Essentials has no way to record this, I have to go through and manually do this or create an outside spreadsheet. if there was a report for purchase side it would be so much easier

  • Liam_M's avatar
    Liam_M
    Former Staff
    Status changed:
    New
    to
    Open
    That's a great suggestion. Anyone else who would find this report useful, please cast your vote for this idea.
  • Hi I would dearly like a report for purchase by item. We are farmers and need this report for animal reconciliation at end of financial year.