Case Study

Production

UPSCash

Cash-reconciliation automation for a US department-store chain — matches each store's end-of-day register cash against QuickBooks and flags the discrepancies that matter. Built in about two weeks.

UPSCash

Stack

Technologies

NestJSReactSQLiteTypeORMQuickBooks (Intuit OAuth)ResendDocker

Context

Tags

automationfinancefull-stack

Overview

The owner needed the cash left in each store's register at end of day reconciled against QuickBooks. UPSCash lets staff submit the day's cash, connects to QuickBooks Online over Intuit OAuth, pulls the journal entries, and reconciles per store against configurable thresholds (minor $100 / major $500), emailing the owner on major discrepancies. The same check runs on weekly manager deposits.

Because it touches money and a third-party financial account, the care went into the boring-but-important parts.

Features

Safety & correctness

  • QuickBooks tokens encrypted at rest (AES-256-GCM) and auto-refreshed.
  • HMAC-verified, de-duplicated webhooks.
  • Role-based access, full audit logging, and encrypted backups with integrity checks.

Impact

Metric Before After Impact
Built in — — ~2 weeks