How Do I See My Cost of Goods Sold?

    Select Reports from the navigation menu and choose Inventory Reports. Select Cost of Goods Overview.*

    Cost of Goods Sold (COGS) is automatically calculated in Backbar in the Cost of Goods Sold Overview report based on sales data and inventory session details. This report, within the Inventory reports, shows COGS values at the category level only. 

     

    In order to track COGS in Backbar, you need to enter sales data for wine, beer, and spirits by selecting Sales > Dashboard from the navigation menu and entering in weekly sales data from your POS system. Click on the Enter sales data manually button in the bottom left of the Dashboard. The dates for the POS sales report should align to the time period between two inventory sessions on your Backbar account.

     

    Enter Sales Data Page

     

    Once sales data is entered, the COGS report will use that data as part of the formula for calculating your cost of goods sold percentage.

     

    The inventory data will account for the value of inventory used during the time period requested.  This information comes from your Inventory > Usage details report. You must have both Inventory counts and all orders entered in the corresponding time period for the usage to calculate correctly, and in turn your COGS data.

     

    Once you have input valid sales and inventory/order data into Backbar, the report will then calculate the COGS percentage at the category level.  The inventory-based COGS report will always require manual sales data entry, and will not pull sales data from your POS system.

     

    cost of goods sold-01

     

    To view item level COGS information, you must have a POS integration. The item level report is on the Reports > Sales Reports tab > Cost of Goods Sold Details report. There is not manual sales entry/import for item level COGS reporting.

     

     

    image-png-Apr-09-2026-03-13-17-3601-PM

     

     

    The Sales column totals come from mapped item sales data from your POS system integration.  The COGS column totals is the item value directly from your usage details inventory report.  The Cost of Goods Sold percentage is calculated by:

     

    COGS value / Sales = COGS %

     

     

    This report is grouped by category type and subtype and columns can be expanded to view the individual item details. 

     

    *The Cost of Goods Sold Report is only available through paid subscriptions.

    Still need help?

    Submit Support Ticket