The Physical inventory worksheet (Operations > Reports > Inventory > Physical inventory worksheet) displays the system count for inventory items so that you can compare it to what you actually have in stock.
While the basics for running any report in SOS Inventory are covered in Reporting introduction and Running a report, the filters, options, and columns specific to the Physical inventory worksheet are explained below.
As of date.
Location. Select All locations or a single location. All, the default, displays only the total quantities for all items across all locations.
Categories. Select All or individual categories. All is the default. Multiple individual categories can be selected. To use this filter, categories must be defined in SOS Inventory.
Vendor. Choose a preferred vendor from the dropdown.
Item name contains. Type all or part of an item name to display matching items.
Non-zero only. This option excludes from the report items with a system count of zero.
Highlight reorders. Highlights in light red an item's quantity at a particular location that needs reordering. If available, the item's reorder point from Location settings is used. If Location settings are unavailable, the item definition reorder point will be used. The Total quantity will be highlighted if it is at or below the reorder point in the item's definition. It is possible to have an item quantity highlighted for a location but the Total quantity is not.
Show serials. This option adds columns for System Serials and Actual Serials to the report. The System Serials column includes the serial numbers for each serial-tracked item. Actual Serials allows you to specify the serial-numbered items that are actually in inventory.
Show lots. This option adds columns for System Lots and Actual Lots to the report. The System Lots column includes the lot numbers and quantities for each lot-tracked item. Actual Lots allows you to specify the lot numbers and quantities that are actually in inventory.
Show bins. This option adds columns for System Bins and Actual Bins to the report. The System Bins column includes the bin numbers and quantities for each bin-tracked item. The Actual Bins column allows you to specify the bin numbers and quantities that are actually in inventory for those items. The columns System Bins and Actual Bins are displayed only if you selected a single bin-tracked location.
Show "as of" date. If checked, shows the at the top of the report, based on your As of date filter. The date appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the As of date will appear only if you print your spreadsheet. If a header is also entered for the report, the date will be displayed below the header.
Group by. A set of options that allows you to group data on the report. The options include None, Category, or Vendor. The default is None, which displays items in alphabetical order. If your Group by option is set to Category, any item that has not been assigned to a category will be included in the first grouping displayed on the report, under the heading <no category>. The same principle applies when the Group by option is set to Vendor. Items with no preferred vendor defined will be listed first on the report, under the heading <no vendor>.
Header. Enter header text for the report, if desired. The header appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet.
Footer. Enter footer text for the report, if desired. The footer appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the footer will appear only if you print your spreadsheet and will show above the system-generated text, Report Generated [date] [timestamp].
The default columns for the Physical inventory worksheet are Name and Description. Fifteen additional SOS columns are available, as well as any custom fields you have created for items.
The Physical inventory worksheet below has the As of date of 8/21/2026, for Location Dallas, TX, and preferred Vendor Anderson Supply Co. The option Highlight reorders has been checked. The default columns (Name and Description), Reorder Point, and Max Stock were selected. The columns System Count and Actual Count are built into the report.
The System Count value for Aiwa Receiver is highlighted, as it has fallen below its reorder point.
Selecting an item name links to its data record on the Items list.

If you have an Apple iPhone, iPad, iPod Touch, Mac, or Vision, you can use SOS Inventory's iOS app for your physical counts instead of the Physical inventory worksheet. For specific installation requirements, refer to iOS app - Installation, logging in and out. You can download the SOS Inventory app from the Apple Store. For instructions on using the iOS app for physical counts, see iOS app - Conducting physical counts.