Total Income
₹0.00
Total Expenses
₹0.00
Pending Reimbursements
₹0.00
Total Reimbursed
₹0.00
Net Balance
₹0.00
Available Cash Balance
₹0.00
This Month Income
₹0.00
This Month Expenses
₹0.00
Available Cash by Account
| Account | Balance | |
|---|---|---|
| Total | ₹0.00 |
Income by Bank / Account
| Bank / Account | Amount |
|---|
Income by Course / Service
| Course / Service | Amount |
|---|
Expenses by Category
| Category | Amount |
|---|
Reimbursement Summary
| Person | Needed | Paid | Pending |
|---|
Recent Expenses
| Date | Purpose | Paid By | Amount | |
|---|---|---|---|---|
| Loading data... | ||||
Recent Income
| Date | Source | Bank | Amount | |
|---|---|---|---|---|
| Loading data... | ||||
Add New Expense
Expenses Records
| Date | Project | Category | Paid By / To | Purpose | Reimbursable? | Status | Amount | Actions | |
|---|---|---|---|---|---|---|---|---|---|
| Loading expenses... | |||||||||
Add New Income
Income Records
| Date | Project | Bank / Account | Course / Service | Received From | Purpose | Amount | Actions | |
|---|---|---|---|---|---|---|---|---|
| Loading income logs... | ||||||||
Reimbursement Balances
Calculated automatically from all expenses paid by staff with Reimbursement Needed = Yes minus all reimbursements paid to them. Fully-settled staff are hidden by default — their payment history below is always preserved.
| Person | Total Reimbursement Needed | Total Reimbursement Paid | Balance Pending | Status | Details | |
|---|---|---|---|---|---|---|
| No reimbursable transactions logged yet. | ||||||
Mohamed Abdus Salam
Comprehensive Statement and Payment History
Total Reimbursable Needed
₹0.00
0 expenses total
Total Reimbursed Paid
₹0.00
0 payments total
Balance Pending
₹0.00
PendingQuick Actions
Category Breakdown
Included Reimbursable Expenses
| Date | Entry No. | Category | Purpose / Description | Vendor / Paid To | Account / UPI Used | Original Amount | Allocated / Paid | Payment Status | Expense Status | Bill / Proof | Notes |
|---|
Reimbursement Payments History
| Payment Date | Amount Paid | Paid From Account | Notes | Actions |
|---|
Record Reimbursement Payment
Reimbursement Payments History
| Payment Date | Project | Paid To (Staff) | Paid From Bank | Notes | Amount | Actions | |
|---|---|---|---|---|---|---|---|
| Loading payment history... | |||||||
Import Financial Records
Upload Excel (.xlsx, .xls) or CSV files to quickly batch-import your records.
1. Select or Drag Financial File
Click to upload or drag & drop
Supported files: Excel (.xlsx, .xls) and CSV (.csv)
4. Map Spreadsheet Columns
Required fields unmapped| Database Target Field | Requirement | Mapped Excel Column |
|---|
5. Duplicate Protection Policy
6. Parse Review & Preview
First 10 rows previewTotal Rows
0
Valid Rows
0
Invalid Rows
0
Duplicate Rows
0
Parsing Errors found (Invalid rows will be skipped):
Import Job Completed!
Your ledger has been updated successfully with the imported records.
Successfully Imported
0
Skipped Duplicates
0
Failed / Invalid Rows
0
User Management (Owner Only)
Invite new users, assign roles, and toggle user account statuses securely.
Create User
Registered System Users
0 Users| User | Role | Status | Added | Actions |
|---|
Account & Payment Channel Management
Configure physical banks, UPI IDs, Publications, or cash drawers used in transactions.
Add New Account
Configured Payment Accounts
| Account Name | Type | Order | Status | Actions |
|---|
Expense Category Management
Manage physical/operational categories used to organize and track company outlays.
Add New Category
Configured Ledger Categories
| Category Name | Order | Status | Actions |
|---|
Course, Publication & Service Management
Manage active income types, student diplomas, consultation services, or publications.
Add New Item
Active Stream Categories
| Item Name | Type | Order | Status | Actions |
|---|
Configurable Custom Fields Configurator
Add meta-fields (e.g. Student Registration ID, Transaction Slips, Billing ID) dynamically without editing DB structures.
Create Custom Field
Active Metadata Fields
| Field Label | Key | Form | Type | Req? | Status | Actions |
|---|
Global Ledger App Settings
Configure workspace localization, registration defaults, and analytics configurations.
Database Audit Trail Logs
Real-time immutable log tracking deletions, mutations, and role changes across the ledger.
| Timestamp | User Email | Action | Module | Record ID | Details |
|---|
Data Backups, Portability & Bulk Exporters
Export full datasets in XLS format or recover rows that failed Excel validations.
Ledger Backup Summary
Download Structured Data
Export full or partial spreadsheet rows cleanly compiled with all transaction parameters.
Failed Import Rows Recovery
If any spreadsheet rows failed data-type validation or mapping errors, download them here for fast correction.
Audit Log Value Mutation Diff
Previous State
New State
Project Management
Add, rename, activate, deactivate, or reorder projects to track finances separately.
Add New Project
Configured Projects
| Project Name | Order | Status | Actions |
|---|
Confirm Deletion
Are you absolutely sure you want to delete this record? This transaction will be permanently removed from the database. This action cannot be undone.
Database Setup Guide
Office Ledger now runs on a self-hosted PHP + MySQL backend instead of Supabase. To set up a new environment:
- Create a MySQL database on your host, then run
sql/schema.sqlfollowed bysql/seed.sqlagainst it. - Copy
config_private/db.sample.phptoconfig_private/db.phpand fill in your database credentials. Keep this file outside the public web root. - Deploy the
api/,lib/, and frontend files to your Hostingerpublic_html. - Create the first owner account by running
php bin/create_user.php you@example.com "Your Name" ownerover SSH. - Sign in with that account, then use Admin → Users to create accounts for everyone else — there is no public self-registration.
Record Reimbursement Payment
Staff Member
Mohamed Abdus Salam
Balance Pending
₹0.00