Pawna (পাওনা) — সহজে রাখুন ধার-দেনার হিসাব

Pawna is a complete, production-ready Personal Money Lending & Borrowing Tracker Android mobile application built with modern fintech UI, robust calculation logic, multi-format exports (Excel, PDF, CSV), .pawna database backup/restore, PIN app lock, and bilingual support (Bangla & English) with Bangladeshi Taka (৳).

---

🌟 Key Features

1. Core Financial Logic & Balances

• Money I Gave (ধার দিয়েছি): Increases Receivable (আমি পাবো) balance.
• Money I Took (ধার নিয়েছি): Increases Payable (আমাকে দিতে হবে) balance.
• Repayments (পরিশোধ):
  • আমি টাকা পেয়েছি (Received Repayment): Decreases Receivable balance.
  • আমি টাকা পরিশোধ করেছি (Given Repayment): Decreases Payable balance.
• Net Position Formula: Net Position = Total Receivable - Total Payable.
• Overpayment Prevention: Warns and requests explicit confirmation before recording repayments exceeding the outstanding balance.
• Auto Statuses: Active, Partially Paid, Fully Paid, Overdue, Settled (with celebration animation on full settlement).

2. People / Beneficiaries Management

• Add, edit, archive, and delete beneficiaries with avatars, phone numbers, and notes.
• Searchable beneficiary picker when recording transactions (no typing name manually).
• Real-time outstanding calculation per person with clear status badges (🟢 আপনি পাবেন, 🔴 আপনাকে দিতে হবে, ⚪ হিসাব পরিশোধিত).
• Sorting by highest outstanding, lowest outstanding, name (A-Z / Z-A).

3. Chronological Ledgers & Statement

• Dedicated History tab with multi-filters (Lent, Borrowed, Repayments, Person, Date, Amount).
• Individual person statements with running balances, loan breakdown, and 1-click SMS / WhatsApp payment reminders.

4. Export & Reports

• Excel (.xlsx): 4 detailed sheets (Summary, People & Balances, Loans & Borrowings, Repayments).
• PDF Financial Statement: Formatted report with summary cards and tabular ledgers.
• CSV Export: Raw ledger data formatted with UTF-8 BOM.

5. Backup & Restore

• Create Backup: Generates encrypted .pawna JSON database file with checksum verification.
• Restore Backup: Validates schema and restores all people, transactions, and settings safely.
• Auto Backup Schedule: Off, Daily, Weekly, Monthly.

6. Security & App Lock

• 4-Digit PIN Code Lock with secure numeric keypad and animated verification.

---

📱 Android APK Installation & Build

Method 1: Instant PWA Install on Android

1. Open the application URL in Google Chrome or Edge on any Android device.
2. Tap the browser menu (⋮) and select "Install App" or "Add to Home Screen".
3. Pawna will install as a standalone mobile application that works 100% offline.

Method 2: Build Native Android APK with Capacitor

# 1. Install Capacitor CLI & Android Bridge
npm install @capacitor/core @capacitor/cli @capacitor/android

# 2. Initialize Capacitor Project
npx cap init Pawna com.pawna.tracker --web-dir dist

# 3. Build & Sync
npm run build
npx cap add android
npx cap sync android

# 4. Generate Debug APK
cd android && ./gradlew assembleDebug

The compiled APK will be located at: android/app/build/outputs/apk/debug/app-debug.apk

---

🛠️ Tech Stack

• Framework: React 19 + TypeScript + Vite
• Styling: Tailwind CSS with fintech dark & light theme modes
• Typography: Hind Siliguri (Bangla) + Outfit / Inter (Fintech Numerals)
• Exports: xlsx, jspdf, jspdf-autotable
• Icons & Animation: lucide-react, motion, canvas-confetti