A desktop and web financial tracking application built with Laravel, React, and Inertia. This app helps small companies manage orders, expenses, invoices, and reports, with offline and online support.
- Order Management: Track client orders with amount, description, and creation metadata.
- Invoices: Auto-generate invoices linked to orders.
- Expense Tracking: Log expenses with labels and amounts.
- Reporting: Monthly reports with daily income/expense snapshots.
- Offline & Online Account Management:
- Registration codes for online account creation.
- Secret key in
.envfor offline account creation and password resets.
- PDF Data Handling: Functions for reading PDFs and importing data into the SQLite database.
- Search & Filtering: Filter orders, expenses, and invoices easily.
- Backend: Laravel 12 + Inertia
- Frontend: React (with Inertia)
- Database: SQLite (local), PostgreSQL (cloud)
- Desktop App Wrapper: Native PHP
- ORM: Eloquent
Tables include:
users: id, username, password, remember_token, timestampsorders: id, patient_name, order_date, amount, description, created_by → users, modified_by → users, timestampsinvoices: id, order_id → orders, transaction_id, total_amount, description, timestampsexpenses: id, description, label, amount, expense_date, created_by → users, modified_by → users, timestampsreports: id, month, total_orders, total_income, total_expenses, net_profit, generated_at, daily_data JSON, timestampsregistration_codes: id, code_hash, expires_at, timestamps
- Clone the repository:
git clone https://github.com/<your-username>/financial-tracker.git
cd financial-tracker- Install backend dependencies:
composer install- Install frontend dependencies:
npm install
npm run build- Configure environment:
cp .env.example .env
php artisan key:generate- Run migrations:
php artisan migrate- Run locally:
php artisan serve
npm run dev- Access the app locally via
http://localhost:8000. - Admin user receives registration codes via email for online setup.
- Use secret key in
.envfor offline setup and password resets. - Reports auto-generate monthly, and you can view daily snapshots in JSON format.
- Online: Registration code sent to the company owner’s email for account creation.
- Offline: Secret backup key in
.envallows trusted users to create accounts and reset passwords locally.
⚠️ Only recommended for single-company, single-computer deployment with trusted users.
This project is licensed under the MIT License.