inventory report

JO-ANNEJO-ANNE Member Posts: 196
edited September 2019 in Accounts Hosted
Is there a report I can produce in Accounts Hosted that shows inventory bought and sold over a period of time? We are trying to compile a list of, say filters, that we have bought and sold so we can go to a supplier and bargain on our buy price.


  • Acctd4Acctd4 Accredited Partner Posts: 896 ✭✭
    edited September 2019

    Hi Jo-Anne

    There's an Item Profitability report which would suffice but I think it's only in specific editions (Under “Project Costing” default reports). 

    You can tweak the Sales by Item Summary instead though & then memorise it for future re-use:

    • Click on Reports (along the top toolbar) then under the Sales heading, click on “Sales by Item Summary
    • Click on the “Modify Report” button (top left of report)
    • On the Display tab, change/edit the Report Date Range, Report Basis & Columns to display

    You can also click on the “Advanced” button to select All/Active/Non-Zero options for row & column display

    • On the Filters tab, select “Item” in the Filters list, then choose “All Inventory Items” from the dropdown Item options
    • On the Header/Footer tab, you can give this report a more personalised name in the Report Title box
    • Click on OK

    Depending on how your Items are set up, you can tweak this further to only show specific groups/types of Items.

    Once happy with it, click on the “Memorise” button (next to “Modify …”) & save it for next time.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    [email protected]

Sign In or Register to comment.