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
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
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.
Results
Built in
Impact: ~2 weeks
Tech stack
NestJS · React · SQLite · TypeORM · QuickBooks (Intuit OAuth) · Resend · Docker