Square Inventory Tracking Setup Guide

Prerequisites

Before you begin, make sure you have:

• An active Square for Restaurants, Square for Retail, or standard Square POS account
• Menu items configured in Square with names that match your inventory products
• A The Neat Profit account (free plan works for single-location bars and restaurants)
• Admin access to both your Square account and The Neat Profit dashboard

Step-by-Step Setup

1. Connect your Square account

   Log in to The Neat Profit, go to POS Connections in the dashboard, and click Connect Square. You'll be redirected to Square's secure OAuth page. Log in with your Square credentials and authorize The Neat Profit to access your sales and menu data. No developer API keys are needed.

2. Review menu item mappings

   The Neat Profit automatically maps your Square menu items to inventory products using name matching. Review the suggested mappings in the dashboard. For any unmapped or incorrectly mapped items, you can manually assign the correct inventory product or create a new one. Items that aren't mapped are flagged for your attention.

3. Set up recipes for composite items

   For cocktails, food dishes, and any item made from multiple ingredients, define a recipe with exact quantities. For example, a Margarita recipe might include 2 oz tequila, 0.5 oz lime juice, and 0.25 oz triple sec. When that cocktail sells through Square, those exact amounts are deducted from inventory. See recipe costing for craft cocktails for detailed guidance.

4. Configure sync frequency

   Choose how often Square sales data syncs with your inventory. Real-time sync is recommended for the most accurate perpetual inventory. Every sale updates stock levels instantly. You can also choose hourly or daily sync if you prefer batch updates.

5. Run your first variance report

   Take a physical count using The Neat Profit's mobile app. Barcode scanning and voice counting make this fast—typically 1-2 hours for a full bar and kitchen. When the count is complete, the system compares it against your Square-derived perpetual inventory and calculates variance instantly. Items with high variance are highlighted. See acceptable liquor variance percentages.

6. Enable AI Smart Ordering

   After 2-3 weeks of Square sales data, enable AI Smart Ordering. The system analyzes your sales patterns, seasonal trends, and current stock levels to generate optimal purchase orders. You'll get one-tap ordering against par levels, with demand forecasting that's 95% accurate. See automating bar ordering.

Common Setup Issues and Solutions

• Unmapped items — If many Square items aren't mapping, check that your Square item names match your inventory product names. You can also use the bulk remap tool in the dashboard.
• Recipe not deducting correctly — Verify that recipe ingredient quantities use the correct units (oz, ml, lb, each). The Neat Profit supports both metric and imperial units.
• Sync delays — If sales aren't appearing in inventory, check your sync frequency setting and ensure your Square account remains connected. Re-authorize if needed.
• Multi-location setup — For multiple Square locations, map each location to a separate business entity in The Neat Profit. Consolidated reporting shows all locations in one view.

Post-Setup Checklist

• All Square menu items mapped to inventory products
• Recipes defined for all composite items (cocktails, food dishes)
• Sync frequency set to real-time or hourly
• First physical count completed and variance report reviewed
• Par levels configured for all high-volume items
• AI Smart Ordering enabled after 2-3 weeks of data
• Staff trained on mobile counting app

Next Steps

Once Square inventory tracking is set up, explore these related features:

• Square inventory tracking for restaurants — Full overview of features
• Square inventory tracking vs manual counting — Why automation wins
• How POS data improves variance tracking — Deeper dive on variance
• Best POS systems for bar inventory — Compare POS options