Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Next.js 15 TypeScript strict Neon Postgres Built with Claude Code License: AGPL v3 CI

English | Bahasa Indonesia


Rekapin

Upload your bank statement. Get real financial reports.

Rekapin turns raw bank statement exports (CSV/Excel) — or a simple Excel template — into cash-basis financial statements: Profit & Loss, Cash Flow, and Cash Book, plus a dashboard that answers the questions every small-business owner actually asks: how much did I earn? what's my gross margin? my net margin? where did the money go?

Built for Indonesian UMKM. No accounting knowledge required — no journals, no debits and credits. Just upload.

MVP complete — live in production. All 6 /ship steps have shipped, including a real Vercel deployment, verified end-to-end (signup → email verification → onboarding → statement upload → categorization → reports → Excel export → staff invite). Features ship through the /ship agent pipeline — follow the commits to watch it being built.

Build progress (MVP, /ship steps):

# Step Status
Skeleton, auth, onboarding ✅ Shipped
Statement upload, parsing, dedup ✅ Shipped
Categories, rules engine, transactions ✅ Shipped
Reports (P&L, Cash Flow, Cash Book) ✅ Shipped
Dashboard, margin KPIs, Excel export ✅ Shipped
Polish, deploy to Vercel ✅ Shipped

Post-MVP hardening done alongside step ⑥: dependency security upgrades (better-auth, drizzle, xlsx — 0 known vulnerabilities), real transactional email via Resend, and the full staff-invite/member-management flow (FR-1.4). See DEPLOY.md for the deploy runbook.

How It Works

  1. Upload — bank statement CSV/Excel (BCA preset; other banks via the column-mapping wizard, saved per account) or the standard Excel template
  2. Map once — column mapping wizard, saved per bank account
  3. Review — auto-categorization via rules engine (AI-powered in Phase 2), guaranteed deduplication
  4. Done — reports and margin dashboard update instantly, export to Excel

Features (MVP)

  • Multi-business support with strict data isolation
  • Bank statement import: BCA preset + universal mapping wizard (more bank presets planned)
  • Duplicate-proof: re-uploading the same file never doubles a transaction
  • Rules-based auto-categorization that learns from your corrections
  • Reports: Profit & Loss, Cash Flow, Cash Book — period comparison, Excel export
  • Dashboard: revenue, expenses, net profit, gross margin, net margin, trends, top expenses, cash position

Phase 2: AI auto-categorization (Claude), PDF statement parsing, budget alerts, and an AI chat that answers questions about your finances from real database queries — bring your own key: Claude (default), Gemini, Grok, OpenAI, or OpenRouter via Vercel AI SDK.

Stack

  • Next.js 15 (App Router) · TypeScript strict · Tailwind CSS + shadcn/ui · Recharts
  • Neon Postgres + Drizzle ORM · Better Auth · Vercel Blob
  • Claude API — transaction categorization · Vercel AI SDK — multi-provider AI chat (Phase 2)
  • Deployed on Vercel

Run

npm install
npm run dev    # http://localhost:3000
npm run build  # type check + production build

You'll need a Neon Postgres database and env vars set per .env.example (DATABASE_URL, BETTER_AUTH_SECRET, Google OAuth keys, optional Vercel Blob token). No hosted demo yet — this is a local-dev-only project until step ⑥.

The Pipeline That Builds This

Every feature ships through a 5-agent pipeline (/ship [feature]), artifacts in .pipeline/:

Agent Role
planner Turns the feature request into a technical spec
designer Design spec — guided by a bundled premium-design skill
coder Writes the code from spec + design
tester Runs and checks the result
reviewer Final verdict — SHIP / NEEDS WORK / BLOCK

See CLAUDE.md for conventions and the full flow.

Credit

Product & direction

Built by

  • Claude Code (Anthropic) running the /ship 5-agent pipeline

Every commit carries a Co-Authored-By trailer — built with AI, owned by the human.

License

GNU AGPL-3.0 — free and open source. Use it for anything, including your business. If you modify and distribute it, or run a modified version as a service, your changes must stay open source too. Keep NOTICE.md intact for attribution.

About

Upload your bank statement. Get real financial reports. Cash-basis P&L, cash flow & margin dashboard for Indonesian Small Medium Enterprise.

Resources

Contributing

Security policy

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages