{"product_id":"n8n-workflow-reconcile-daily-till-counts-flag-discrepancies","title":"n8n Workflow: Reconcile Daily Till Counts \u0026 Flag Discrepancies","description":"\u003ch3\u003eReconcile daily till counts automatically—then instantly flag what doesn’t add up\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e reconciles end-of-day till entries by comparing \u003cstrong\u003ecounted cash\u003c\/strong\u003e against \u003cstrong\u003eexpected sales\u003c\/strong\u003e, detects issues like \u003cstrong\u003eduplicates, missing fields\u003c\/strong\u003e, and \u003cstrong\u003egaps in the date sequence\u003c\/strong\u003e, and delivers a single owner-facing digest summarizing clean days and exceptions.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or nightly\u003c\/strong\u003e: start it via \u003cem\u003e“Test workflow”\u003c\/em\u003e or let it run on a \u003cstrong\u003e21:30\u003c\/strong\u003e schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSimulates end-of-day submissions\u003c\/strong\u003e with a batch of sample till entries (date, expected sales, counted cash) to mirror real intake.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e and deduplicates entries by \u003cstrong\u003edate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks reconciliation tolerance\u003c\/strong\u003e by comparing \u003cstrong\u003ecounted cash vs expected sales\u003c\/strong\u003e using configurable tolerance settings (absolute tolerance, percent tolerance, and currency).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates reason-coded owner alerts\u003c\/strong\u003e for exceptions including: over-tolerance, duplicates, missing fields, or missing days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutputs exactly one digest\u003c\/strong\u003e merging clean reconciliations and alerts—so owners get a single, clear summary of how many days matched and what needs attention.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall retail operators reconciling nightly cash totals against expected sales with consistent tolerance rules.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or automation engineers building a reliable till auditing pipeline with exception reporting.\u003c\/li\u003e\n  \u003cli\u003eTeams who want automated detection of \u003cstrong\u003emissing submission days\u003c\/strong\u003e to prevent silent reporting gaps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003emanual trigger\u003c\/code\u003e, \u003ccode\u003eschedule trigger\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: optionally replace the demo intake with your real source (e.g., \u003cstrong\u003en8n Form\/Webhook\u003c\/strong\u003e or scheduled read from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e) while keeping fields: \u003ccode\u003edate\u003c\/code\u003e, \u003ccode\u003eexpected_sales\u003c\/code\u003e, \u003ccode\u003ecounted_cash\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional notifications\u003c\/strong\u003e: add outbound delivery after the owner digest (e.g., \u003cstrong\u003eTelegram\u003c\/strong\u003e or \u003cstrong\u003eTwilio\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146318532787,"sku":"N8N-20249","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5nlyFKr9wd7aJymKRhAKY_m9cTZENh.png?v=1790845981","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-reconcile-daily-till-counts-flag-discrepancies","provider":"N8N Commerce","version":"1.0","type":"link"}