GOHIGHLEVEL ANSWERS & PROMPTS: PLAYBOOK T54 · DUPLICATE INVOICE & ORDER PAIR-KEY GUARD
AUTHOR: DANIEL HALLMAN
KEYWORD: INVOICE DEDUPE
PLAYBOOK T54 · Duplicate Invoice & Order Pair-Key Guard KEYWORD: INVOICE DEDUPE

How Do You Flag Duplicate Supplier Invoices and Orders Across Google Sheets, n8n, and GoHighLevel?

Answer: Naively stripping commas and parentheses from invoice amounts turns European decimals like 500,00 into 50000, turns (500.00) credit notes into positive 500, and treats USD 500 and EUR 500 as identical bills. Normalize every invoice into integer minor units (cents) with an explicit currency code and sign in Settings > Custom Fields and Automation > Workflow Builder (or your n8n Code step), build a sorted pair_key across vendor + currency + cents within a 3-day window, and hold flagged cards in a Pending Review stage in Opportunities > Pipelines before payout.

STEP-BY-STEP INSTRUCTIONS + ANNOTATED GHL SCREENSHOTS

Steps in GoHighLevel

  1. STEP 1
    In Settings > Custom Fields, create Opportunity fields for Currency Code (USD, EUR, GBP), Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status (Pending Review, Confirmed Duplicate, Approved Separate Bill).
    REAL GHL SCREEN · SETTINGS > CUSTOM FIELDS ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Custom Fields screenshot showing Settings > Custom Fields menu, Contact/Opportunity/Company object filters, and + Create field button
    1Open Settings > Custom Fields 2Filter by Contact or Opportunity Object 3Click + Create Field
  2. STEP 2
    In Automation > Workflow Builder (and your n8n invoice normalization node), convert bracketed amounts (500.00) to negative integers (-50000), parse the last decimal separator explicitly by vendor locale, and build a sorted pair_key combining vendor_id + currency + amount_cents across invoices dated within 3 days of each other.
    REAL GHL SCREEN · AUTOMATION > WORKFLOW BUILDER CANVAS ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Workflow Builder canvas screenshot showing If/Else condition branch, priority routing steps, and Builder/Settings/Execution logs tabs
    1Add If/Else Condition & Tag Guard 2Chain Priority & Wait Steps 3Switch to Settings or Execution Logs
  3. STEP 3
    In Opportunities > Pipelines, route any bill whose pair_key matches an active record into a Duplicate Hold stage and send one daily digest to Slack or Conversations > Team Inbox, pausing payment until a bookkeeper sets Dedupe Review Status to Approved Separate Bill.
    REAL GHL SCREEN · OPPORTUNITIES > BOARD & PIPELINES ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Opportunities screenshot showing Opportunities sidebar item, Opportunities/Forecast/Pipelines tabs, and + Add opportunity button
    1Click Opportunities in Left Menu 2Switch Between Board, Forecast & Pipelines 3Click + Add Opportunity or Filter Stages
MODE: AGENT PROMPT
PASTE INTO CLAUDE CODE, CURSOR, CHATGPT, OR GOHIGHLEVEL ASK AI AGENT PROMPT
Configure duplicate invoice and order detection across n8n and GoHighLevel in sub-account <YOUR_LOCATION_ID>:
1. In Settings > Custom Fields, create Opportunity fields for Currency Code, Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status.
2. In Automation > Workflow Builder and n8n, parse decimal formats and bracketed credits into signed integer cents and generate a sorted pair_key across vendor_id, currency, and amount within a 3-day window.
3. In Opportunities > Pipelines, hold matching pair_key records in Duplicate Hold until Dedupe Review Status is updated to Approved Separate Bill.
Cause
  • Supplier and order sheets frequently mix dot and comma decimal formats (1,234.56 vs 1.234,56), accounting bracket credits ((500.00)), multiple currencies (USD vs EUR), or re-sent bills where the vendor appends a letter (INV-204 vs INV-204A) two days later.
  • Regex stripping that removes commas before converting to a number corrupts amounts and triggers false duplicate alerts or misses real double-billings.
GoHighLevel Configuration
  • Store Currency Code, Amount in Cents
  • and Invoice Pair Key in Settings > Custom Fields, parse locale decimal separators and negative credit brackets explicitly in Automation > Workflow Builder (and n8n)
  • and hold flagged pairs in Opportunities > Pipelines with an explicit Approved Separate Bill status so bookkeepers do not have to delete rows to clear false positives.
MENU PATH REFERENCE

GoHighLevel Menu Paths

Step Menu Path in GHL Action
Step 1 Settings > Custom Fields Create Opportunity fields for Currency Code (USD, EUR, GBP), Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status (Pending Review, Confirmed Duplicate, Approved Separate Bill).
Step 2 Automation > Workflow Builder Convert bracketed amounts (500.00) to negative integers (-50000), parse the last decimal separator explicitly by vendor locale, and build a sorted pair_key combining vendor_id + currency + amount_cents across invoices dated within 3 days of each other.
Step 3 Opportunities > Pipelines Route any bill whose pair_key matches an active record into a Duplicate Hold stage and send one daily digest to Slack or Conversations > Team Inbox, pausing payment until a bookkeeper sets Dedupe Review Status to Approved Separate Bill.
3-step diagram showing Normalize minor units converting currency amounts into integer cents, Sorted pair key matching vendor, cents, and 3-day window, and Hold pending bills pausing payout until bookkeeper marks approved.
VISUAL PLAYBOOK · PLAYBOOK T54 (DUPLICATE INVOICE & ORDER PAIR-KEY GUARD) Back to Annotated GHL Screenshots ↑
DEFAULT SETUP VS. AUTOMATED WORKFLOW

Operational Comparison

Speed to Lead & Callback Safety
Default 0s Checkbox: Collides with Rep
45s Guard Workflow: Zero Collision
Caller Reply & Booking Rate
Generic 'We Missed You' SMS: 12%
Question-First Workflow SMS: 64%

Related Questions

BUILD FASTER IN GOHIGHLEVEL · FREE TRIAL BONUSES + MCP SERVER

Build this directly inside your GoHighLevel sub-account

Connect Claude Code, Cursor, or OpenAI Codex to our ghl-tools MCP Server & Rust CLI to build workflows, forms, and funnels from your editor, or start your GoHighLevel plan through our partner link to unlock $612+ in ready-to-import kits (including GHL & n8n Invoice Deduplication Workflow Pack) and weekly live clinics.