UPSCash

Featured Project

UPSCash

Released

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.

Released Portfolio Build NestJS · React · SQLite

Project Snapshot

Status Released
Project Type Portfolio Build
Core Stack 7 technologies
Access Private build

Overview

Project Snapshot

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

Overview

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

Core Stack

  • NestJS
  • React

Application Layer

  • SQLite
  • TypeORM

Data & AI

  • QuickBooks (Intuit OAuth)
  • Resend

Delivery

  • Docker

Results

Impact

Built in

Before

After

Impact

~2 weeks