06 — Cash Management, Daily Close & Accounting Integration Specification

1. The Strict Cash Drawer Lifecycle

Liquor stores handle a significant proportion of cash transactions (often 25% to 40% of total revenue). Solid cash controls eliminate internal shrinkage and clerical balancing errors.

The 4 Stages of Drawer Management

   [ 1. Morning Shift Open ]
   Cashier verifies and accepts opening float (e.g. $200.00 standard bank)
              │
              ▼
   [ 2. Mid-Day Transactions & Cash Drops ]
   • Ring sales, dispense change
   • Cash drops when drawer exceeds threshold ($1,000 max in till)
   • Paid-outs logged for petty cash / store supplies
              │
              ▼
   [ 3. Evening Blind Close ]
   Cashier counts physical currency by denomination without seeing system totals
              │
              ▼
   [ 4. Manager Reconciliation & Daily Z-Report ]
   • System compares physical count against expected cash
   • Flags variances over threshold (e.g. > $5.00)
   • Generates Daily Z-Report & syncs to QuickBooks

2. Blind Drawer Close: Eliminating Shrinkage Temptation

Why "Blind Close" is Mandatory

In systems that display the expected drawer cash total (e.g. "You should have $1,428.50"), dishonest or careless employees are tempted to pocket any cash overage or fail to recount discrepancies.

LQPOS Blind Close Workflow

1. The cashier enters their PIN and initiates Close Shift.
2. The UI presents a Denomination Counter:
   • Hundreds ($100), Fifties ($50), Twenties ($20), Tens ($10), Fives ($5), Twos ($2), Singles ($1)
   • Dollar Coins ($1.00), Halves ($0.50), Quarters ($0.25), Dimes ($0.10), Nickels ($0.05), Pennies ($0.01)
   • Rolled coin inputs (e.g. 5 rolls of Quarters = $50.00)
3. The cashier types in the physical counts and clicks Submit Final Count.
4. The system calculates the grand total behind the scenes.
5. If the variance between counted cash and expected cash is greater than the configured threshold (e.g. $\pm $5.00$):
   • The cashier is asked to recount once.
   • If the variance persists, the drawer locks and alerts the shift manager for override sign-off with a mandatory note ("Drawer short -$12.40: Cashier made error on change").

3. Mid-Shift Cash Drops & Paid-Outs

1. Automated Safe Drops (Skims)

• When cash in the drawer exceeds a safety limit (e.g. $800.00), the POS displays a non-intrusive reminder: "Till Cash Exceeds $800 — Recommended Cash Drop: $500.00".
• The cashier selects Cash Drop, inputs the drop envelope number and amount ($500.00), and places the envelope in the store's drop safe.
• A dual-copy receipt prints: one goes into the safe envelope, the second stays in the till.

2. Petty Cash Paid-Outs

• For routine store expenses (e.g. buying lemons/limes from the grocery next door, paying a window washer, local ice delivery).
• Cashier clicks Paid-Out, selects category (Store Supplies, Repairs, Delivery Tip), enters vendor name, amount, and takes a photo of the receipt using the register webcam or mobile tablet.

4. The Daily Z-Report & Batch Settlement

At end of business day, after all lanes are closed, the store manager runs the Consolidated Store Z-Report.

Z-Report Structure

══════════════════════════════════════════════════════════
POUDRE LIQUORS — DAILY FINANCIAL Z-REPORT
Date: Thursday, November 05, 2026 | Register Lanes 1 & 2
Report #Z-20261105 | Closed at: 11:15 PM MST
══════════════════════════════════════════════════════════

GROSS SALES BREAKDOWN:
  Liquor / Spirits (750ml, 1.75L, etc.)      $4,218.40
  Beer & Malt Beverages                      $3,140.25
  Wine & Champagne                           $1,895.10
  Non-Alcoholic (Mixers, Ice, Soda)            $342.50
  Tobacco & Accessories                        $118.00
----------------------------------------------------------
TOTAL GROSS MERCHANDISE SALES:               $9,714.25

DISCOUNTS & ADJUSTMENTS:
  Wine Case Discounts (10% / 15%)             -$214.50
  Mix-and-Match Pick-6 Bundles                 -$48.20
  Store Specials / Red-Tags                   -$112.00
  Customer Loyalty Rewards Redeemed            -$65.00
----------------------------------------------------------
TOTAL DISCOUNTS APPLIED:                      -$439.70

NET SALES:                                   $9,274.55

TAX & REGULATORY DEPOSITS:
  State & Local Liquor Tax (7.5%)              $695.59
  Keg Shell & Container Deposits               $120.00
  Deposits Refunded to Customers              -$60.00
----------------------------------------------------------
GRAND TOTAL REVENUE COLLECTED:              $10,030.14

TENDER SUMMARY:
  Cash Collected:                            $2,842.14
  Credit Cards (PAX EMV Batch #481):         $5,892.00
  Debit Cards:                               $1,146.00
  Store Gift Cards Redeemed:                   $150.00
----------------------------------------------------------
TOTAL TENDERED:                             $10,030.14

CASH RECONCILIATION:
  Starting Morning Float:                      $400.00
  Cash Sales Collected:                      $2,842.14
  Safe Drops to Drop Safe:                  -$2,000.00
  Paid-Outs (Store Supplies):                  -$34.50
  Deposit Refunds Paid:                        -$60.00
----------------------------------------------------------
EXPECTED TILL CASH:                          $1,147.64
ACTUAL COUNTED CASH:                         $1,145.50
OVER / SHORT VARIANCE:                          -$2.14 (Within Tolerances)

STATISTICAL METRICS:
  Total Completed Transactions:                    342
  Average Basket Size:                          $29.33
  Total Items Sold:                                894
  Total Voided Lines (Audit):                        6 ($54.20)
  21+ IDs Verified via Scanner:                    218 (63.7%)
══════════════════════════════════════════════════════════

5. QuickBooks Online / Desktop Synchronization

LQPOS eliminates manual bookkeeping by posting an automated Daily Summary Journal Entry directly to QuickBooks Online via REST API (or generating standard QBO / IIF files for QuickBooks Desktop).

Standard Chart of Accounts Mapping

Example Automated QuickBooks API Payload

{
  "TxnDate": "2026-11-05",
  "DocNumber": "Z-20261105",
  "PrivateNote": "LQPOS Daily Z-Report Sync - Lanes 1 & 2",
  "Line": [
    {
      "Description": "Daily Card Settlements",
      "Amount": 7038.00,
      "DetailType": "JournalEntryLineDetail",
      "JournalEntryLineDetail": { "PostingType": "Debit", "AccountRef": { "name": "Merchant Clearing" } }
    },
    {
      "Description": "Daily Cash Collected",
      "Amount": 2842.14,
      "DetailType": "JournalEntryLineDetail",
      "JournalEntryLineDetail": { "PostingType": "Debit", "AccountRef": { "name": "Undeposited Funds" } }
    },
    {
      "Description": "Sales Tax Collected",
      "Amount": 695.59,
      "DetailType": "JournalEntryLineDetail",
      "JournalEntryLineDetail": { "PostingType": "Credit", "AccountRef": { "name": "Sales Tax Payable" } }
    },
    {
      "Description": "Gross Merchandise Sales",
      "Amount": 9274.55,
      "DetailType": "JournalEntryLineDetail",
      "JournalEntryLineDetail": { "PostingType": "Credit", "AccountRef": { "name": "Liquor Store Revenue" } }
    }
  ]
}