Enterprise Applications

Meat Commissary ERP System

An integrated ERP for a meat processing and distribution business: double-entry accounting, FEFO batch inventory, carcass-to-product production costing, purchasing, multi-branch sales and HACCP traceability in one CodeIgniter application.

Meat Commissary ERP dashboard with sample data: stock value, sales, receivables, a 30-day sales chart, top items, low stock, expiring batches and outstanding receivables

Dashboard shown above with sample data.

Project overview

An integrated ERP platform that centralises the operations of a meat processing and distribution business in the Philippines, connecting purchasing, production, inventory, branch sales and accounting in one system.

Meat commissary operations involve raw meat procurement, carcass breakdown, production processing, inventory movement, product costing, distribution, branch operations and financial management. Spreadsheets and disconnected applications make it hard to keep accurate inventory, monitor production yields, reconcile transactions and produce consolidated reports.

The objective: one platform that ties every operational activity to accounting and financial reporting, giving management visibility, accuracy and control across the organisation.

Business challenges

  • Disconnected accounting, purchasing, inventory and production processes
  • Tracking raw materials through processing to finished goods
  • Inaccurate inventory costing and production yield calculations
  • Limited visibility of expiry dates and batch movements
  • Complex branch-to-branch transfers and reconciliation
  • Manual financial consolidation and reporting
  • Maintaining traceability and audit records
  • Limited visibility of operating expenses and profitability

Solution architecture and core modules

Accounting and financial management

Built on double-entry principles, so operational transactions post directly to the financial records.

  • General ledger and chart of accounts
  • Accounts payable and accounts receivable
  • Cash and check disbursement vouchers
  • Sales and purchase accounting
  • VAT computation and Philippine tax reporting support
  • Trial balance, income statement, balance sheet and cash flow statement
  • Cost of goods sold (COGS) computation
  • Accounting period locking and a financial audit trail

Inventory and warehouse management

Perpetual inventory for raw materials, work in progress and finished products.

  • Batch and lot-level tracking
  • First Expired, First Out (FEFO)
  • Weighted-average costing
  • Goods receiving and supplier tracking
  • Warehouse stock movements, adjustments and reconciliation
  • Inter-branch stock transfers
  • Expiry and spoilage monitoring
  • Barcode and QR-based traceability

Production and meat processing

Tracks the transformation of raw meat into finished products, from meat cuts to burger patties, siomai, pork tocino and other ready-to-cook and ready-to-eat lines.

  • Carcass receiving, breakdown and portion conversion
  • Raw material to work-in-progress conversion and finished goods production
  • Recipe and bill of materials (BOM) management
  • Ingredient consumption tracking
  • Production yield and wastage monitoring
  • Production cost allocation
  • Batch traceability through the whole process

Purchasing and supplier management

  • Supplier records
  • Purchase requisitions and purchase orders
  • Goods receiving and supplier invoice recording
  • Purchase cost tracking
  • Supplier batch and source traceability
  • Accounts payable integration

Sales and multi-branch operations

  • Centralised sales management with branch-level monitoring
  • Inventory allocation, transfers and branch stock reconciliation
  • Sales transactions posted to accounting
  • Consolidated operational reporting

Food safety and compliance

  • HACCP monitoring records
  • Cold-storage temperature logs
  • Batch, lot and supplier-to-production traceability
  • Expiry and disposal monitoring
  • Operational audit trails

Reporting and business intelligence

  • Consolidated sales summary and branch performance comparison
  • Monthly operating expenses and purchases summary
  • Outstanding payables and cash/check disbursements
  • Weekly inventory summary and month-end inventory
  • Production yield and costing
  • Sales reconciliation and financial statements

Technical architecture

A structured MVC application on a normalised MySQL database, designed for maintainability, data consistency and a clean separation of business logic.

LayerTechnology
Back endPHP, CodeIgniter 3 / 4
DatabaseMySQL
Front endBootstrap 5
JavaScriptjQuery, AJAX
ArchitectureMVC
SecurityRole-based access control
Data integrityTransactional processing and audit trails

Key engineering considerations

The hard part is keeping physical inventory, production consumption and the accounts consistent with each other.

  • Accounting entries generated automatically from operational transactions
  • Consistent inventory valuation across warehouses and branches
  • Accurate production yield and wastage calculations
  • Protection against unauthorised changes to financial records
  • Full historical transaction traceability
  • Role-based access and approval workflows
  • Reliable reconciliation between inventory and accounting

Business value

The system is designed to deliver:

  • Centralised management of commissary and branch operations
  • Better inventory visibility and accountability
  • More accurate production costing
  • Tighter control of raw materials and finished goods
  • Less manual accounting and reconciliation work
  • Stronger batch traceability and food safety monitoring
  • Consolidated reporting for better management decisions

My role

As lead developer and full-stack software architect, I am responsible for:

  • Enterprise system architecture and technical planning
  • Database design and normalisation
  • Back-end development and business logic
  • Accounting and inventory workflow architecture
  • Production and costing logic
  • API and AJAX-based interactions
  • Security and role-based permission design
  • Reporting and financial computation
  • Quality assurance and optimisation

Have a similar challenge?

Business systems, WordPress platforms, performance or infrastructure: tell me what you are working on.

Start a conversation