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.

Status

Released

Core Stack

NestJS · React · SQLite · TypeORM

UPSCash

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.

Key Features

01

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.

Tech Stack

Core Stack

  • NestJS
  • React

Application Layer

  • SQLite
  • TypeORM

Data & AI

  • QuickBooks (Intuit OAuth)
  • Resend

Delivery

  • Docker

Results

Built in

Before

After

Impact

~2 weeks