Bank reconciliation system. Upload a bank statement (PDF, Excel, CSV, or image) → AI extracts every transaction → reconcile against G/L.
npm install
cp .env.local.example .env.local
# Add your Anthropic API key to .env.local
npm run dev- Push this repo to GitHub
- Go to railway.app → New Project → Deploy from GitHub repo
- Select this repo
- Go to Variables → add:
ANTHROPIC_API_KEY=your_key_here - Railway auto-detects Next.js and deploys. Done.
| Format | How it works |
|---|---|
| Sent directly to Claude as a document | |
| Excel (XLS/XLSX) | Parsed server-side with SheetJS, converted to text |
| CSV | Read as text |
| Image (JPG/PNG) | Sent to Claude as an image — works for photos of paper statements |
- AI parses every transaction and categorizes it
- Full two-sided bank reconciliation (bank side vs. G/L)
- Outstanding check tracker — carries forward month to month, auto-clears when statement is uploaded
- Deposits in transit tracker
- Bank-side and book-side adjustments with GL codes
- Full transaction detail by category
- Print-ready report with signature lines
- CSV export
- Data persists in browser localStorage between sessions