Excel Warehouse Inventory Tracker - Local Freelancer Needed in NYC

I need a clean, dependable inventory system built entirely in Excel to streamline day-to-day operations in our warehouse located in New York City. The workbook must let warehouse staff quickly record incoming and outgoing stock while giving managers an at-a-glance view of current levels and printable summary reports. Core functions: - Track stock levels in real time as items are received or dispatched. - Allow straightforward updating of any stock entry—quantity, location, SKU details, notes. - Generate clear, filterable reports that managers can use for weekly reviews or audits. Because we already handle re-ordering through a separate tool, the sheet does not have to include low-stock alerts. I'm happy for you to use formulas, tables, PivotTables, slicers, or VBA—whatever delivers a fast, user-friendly experience inside a single workbook. A short “how-to” tab or PDF guide showing staff and managers where to enter data and where to pull reports should be part of the hand-over. Location Requirement: Only freelancers based in New York City or surrounding areas within commuting distance will be considered. An in-person meeting will be required to discuss the project's details and address any questions before proceeding. Deliverables: - Finished Excel file (.xlsx or .xlsm if macros are used), set up with sample data so we can test immediately. - A brief “how-to” guide for use by staff and managers.

Project ID: 40183193