Lime Personal Accounting

A lightweight, self-hosted personal accounting plugin for WordPress. Track income, expenses, wallets, and generate an automatic cashbook ledger.

Features · Quick Start · Database · API · Development · License

Features

• Dashboard — Real-time income, expense, and balance overview with transaction counts
• Wallet Management — Create wallets categorized as income or expense
• Income Tracking — Log income with wallet, amount, description, and currency
• Expense Tracking — Log expenses with wallet, amount, description, and currency
• Automatic Cashbook — Every income/expense auto-generates a ledger entry
• Activity Logging — Audit trail for all financial actions with IP tracking
• Soft Deletes — No data is ever physically deleted; recoverable via database
• Zero Dependencies — No third-party PHP libraries; uses jQuery (bundled with WP)
• Self-Hosted — All data stays on your server; no cloud services required
• Docker Ready — One-command deployment with docker-compose up -d

Quick Start

Prerequisites

• Docker & Docker Compose installed

Deploy

git clone https://github.com/obydullah/lime-lpa-docker.git
cd lime-lpa-docker
docker-compose up -d

Access

First Use

1. Open http://localhost:8090/wp-admin
2. Log in with your WordPress admin credentials
3. Navigate to Accounting in the sidebar menu
4. Create your first wallet (e.g., "Salary" with category "Income")
5. Add income/expense entries linked to your wallets

Database Schema

All tables use the lpa_ prefix and include soft-delete support (deleted_at column).

┌──────────────┐     ┌──────────────┐
│   wallets    │────<│   incomes    │
│  (categories)│     │  (amount,    │
│              │────<│   wallet_id) │
│              │     └──────┬───────┘
│              │            │
│              │     ┌──────┴────────┐
│              │     │  cashbook     │
│              │     │  (auto ledger)│
│              │     └──────┬────────┘
│              │            │
│              │     ┌──────┴────────┐
└──────────────┘     │   expenses    │
                     │  (amount,     │
                     │   wallet_id)  │
                     └───────────────┘

  ┌──────────────┐    ┌───────────────────┐
  │  activities  │    │  configurations   │
  │  (audit log) │    │  (key-value store)│
  └──────────────┘    └───────────────────┘

Table Summary

Screenshots

Note: Screenshots can be added after running the plugin. Recommended captures:

• Dashboard with stats cards
• Wallets list with add/edit modal
• Income list with form modal
• Expense list with form modal
• Cashbook ledger view
• Activities log

API Actions

All operations go through a single AJAX endpoint: wp_ajax_lpa_action

Wallets

Incomes

Expenses

Other

Architecture

┌─────────────────────────────────────────────────────┐
│                   WordPress Admin                   │
│                                                     │
│  ┌───────────┐  ┌──────────┐  ┌──────────┐          │
│  │ Dashboard │  │ Wallets  │  │ Incomes  │  ...     │
│  │  (view)   │  │  (view)  │  │  (view)  │          │
│  └────┬──────┘  └────┬─────┘  └────┬─────┘          │
│       │              │             │                │
│       └──────────────┼─────────────┘                │
│                      │                              │
│              ┌───────┴────────┐                     │
│              │   script.js    │  jQuery AJAX layer  │
│              │   (SPA-like)   │                     │
│              └───────┬────────┘                     │
│                      │                              │
│              ┌───────┴────────┐                     │
│              │ ajax-handlers  │  Single router      │
│              │    .php        │  12 actions         │
│              └───────┬────────┘                     │
│                      │                              │
│              ┌───────┴────────┐                     │
│              │  database.php   │  Schema + helpers  │
│              └───────┬────────┘                     │
│                      │                              │
└──────────────────────┼──────────────────────────────┘
                       │
               ┌───────┴────────┐
               │  MySQL 8.0     │
               │  (6 tables)    │
               └────────────────┘

Development

Project Structure

wp-content/plugins/lime-personal-accounting/
├── lime-personal-accounting.php   # Entry point, hooks, assets
├── includes/
│   ├── database.php               # Schema creation, DB helpers
│   ├── admin-menu.php             # WordPress menu registration
│   ├── ajax-handlers.php          # All 12 AJAX CRUD handlers
│   ├── pages.php                  # Page controllers
│   └── views/                     # PHP templates (7 views)
│       ├── dashboard.php
│       ├── wallets.php
│       ├── incomes.php
│       ├── expenses.php
│       ├── cashbook.php
│       ├── activities.php
│       └── settings.php
└── assets/
    ├── css/style.css              # 426 lines of custom CSS
    └── js/script.js               # 351 lines of jQuery SPA

Making Changes

1. Edit any file under wp-content/plugins/lime-personal-accounting/
2. Refresh the WordPress admin page
3. No rebuild required — volume-mounted for live reload

Code Conventions

• PHP functions: All prefixed with lpa_
• CSS classes: All prefixed with lpa-
• JS functions: Exposed on window for inline handlers
• Security: Every AJAX call requires nonce + manage_options capability
• DB access: Always via $wpdb API (never raw PDO)
• Soft deletes: Every table has deleted_at column; never DELETE FROM

Adding a New Feature

1. Add DB columns in database.php (use dbDelta())
2. Add AJAX handler in ajax-handlers.php
3. Add router case in lpa_ajax_router()
4. Create/update view in includes/views/
5. Add JS functions in script.js
6. Register menu in admin-menu.php (if new page)

Tech Stack

License

This project is licensed under the GNU General Public License v2.0 — see the LICENSE file for details.

Built with ❤️ by Obydullah