PumpMate ERP User Manual & Reference
Complete Account ID naming standards, Double-Entry Journal mappings, Report definitions, and Customer Support FAQ.
1. Recommended Account & Product ID Naming Convention
| Entity Category | Recommended Prefix / Code | Real Station Examples | Where Used in ERP |
|---|---|---|---|
| Fuel Products (Nozzle) | P + Fuel Letter (Fixed) | PD (Diesel HSD), PS (Super), PH (HOBC) |
Products, Nozzles (Sec A), Wet Stock, Stock Receipts |
| Lubricants (Packed) | Brand Short Code | BLZ1, DEO4, DEO10, T2, BULK |
Products, Stock Movement (Sec C), Party Grid (Sec B) |
| Credit Customers | Company / Person Initials | CMGM, SURGLAB, FAUJI, TRANS |
Accounts (Customer), Section B Grid, SKP Billing |
| Expense Heads | EX + Category | EXOV (Owner Veh), EXGEN (Generator), EXMISC |
Accounts (Expense Head), Section B Grid, Individual Ledger |
| Employees | EMP# or Staff Initials | EMP1, EMP2, ERA (Raza Ahmed) |
Accounts (Employee), Employees Payroll, Section B Grid |
| Income Heads | MP / Short Code | MP (Month Profit), MISC-INC |
Accounts (Income Head), Reports (Post Month Profit), Expenses |
| Suppliers | OMC Name | PSO, HASCOL, ATTOCK, SHELL |
Suppliers, Tanker Stock Receipts, Accounts Payable |
2. Complete Double-Entry Journal Posting Reference
| Station Transaction | Debit Account (Dr) | Credit Account (Cr) | Triggered By |
|---|---|---|---|
| Cash Fuel Sale (Nozzles) | Cash | Diesel / Super / HOBC Sales | Daily Entry Save (Nozzle Sales > 0) |
| FIFO Cost of Goods Sold (COGS) | Cost of Goods Sold | Diesel / Super / HOBC Stock | Daily Entry Save (Auto FIFO Layer Consume) |
| Customer Credit Sale (Udhaar) | Accounts Receivable | Sales Revenue | Section B Row (Customer Debit > 0) |
| Customer Payment Received | Cash | Accounts Receivable | Section B Row (Customer Credit > 0) |
| Tanker Stock Received from Supplier | <Product Name> Stock | Accounts Payable (PSO) | Suppliers → Post Stock Receipt |
| Employee Salary / Advance Paid | Salary Expense | Cash | Employees Tab OR Section B Employee Debit |
| Recurring Expense Head (e.g. EXOV) | <Head Name> Expense | Cash | Section B Row (Expense Head Debit > 0) |
| One-Off Expense (Expenses Module) | Misc Expense | Cash / Bank | Expenses Tab → Type: Expense |
| Other Income / Manual MP Credit | Cash / Bank | MP (Month Profit) | Expenses Tab (Income) OR Section B MP Credit |
| Month-End Operating Profit Close | Sales Revenue | MP (Month Profit) | Reports → 🗓 Post Month Profit Button |
3. Complete Reports Reference (11 Built-In Reports)
Grouped by Control, Customer, Revenue, Expense, and Employee accounts with total Debit/Credit equality check and Net Profit/Loss footer.
Product-by-product Stock, Rate, Stock Value, Dr Balance, OIL Gross Profit, 2-column Expenses Detail, and Net Profit with signature blocks.
Clean summary of Sale Revenue accounts vs Expense & COGS accounts, plus CNG Gross Income/Expense lines and Total Net Income.
Side-by-side Assets (Cash, Bank, Accounts Receivable, Stock) vs Liabilities (Accounts Payable) and Owner Equity snapshot.
Chronological per-product ledger showing Opening Stock, daily Purchase Qty, Sale Qty, Running Balance, Debit/Credit Rs, and Average Daily Sale.
Complete audit log of every PSO/station rate revision showing Date, Product, Old Purchase, New Purchase, Old Sale, and New Sale.
Single-day register printout, full-month daily sales table, per-fuel Nozzle Ledger, FIFO Wet Stock layer table, and 1-click Post Month Profit.
4. Operational FAQ & Troubleshooting Guide
| Question / Situation | Why It Happens | Recommended Action |
|---|