Finance & Management Accounting Web / Admin Panel
PLBoard — P&L and Cost Management Dashboard

From Excel-based P&L management to a multi-axis, auto-aggregating management dashboard.

Bridgeworks Co., Ltd. — Imports project results from the external ERP “ZAC” and per-SV payroll data, then automatically calculates revenue, cost, gross profit, and operating profit by customer, SV, and department. A management platform built to visualize monthly P&L in real time.

Instant
Real-time visualization of monthly P&L
Break free from manual Excel
3 axes+
Multi-angle analysis by customer, SV, and department
Supports business-segment breakdown too
-80%
Less effort for P&L aggregation
Automate costing
Challenge
Before

Project results and per-SV payroll were aggregated by hand in Excel, and costing depended on individuals. The monthly P&L close took several days, and viewing profitability by customer and department from multiple angles was hard.

  • We want to grasp monthly P&L quickly
    Manual Excel aggregation delayed the close by days
  • We want to import project and payroll data accurately
    ZAC and payroll data transcribed by hand
  • We want to view profitability by customer and department from multiple angles
    Hard to aggregate per axis, so overall optimization was impossible
  • We want to calculate cost of sales and gross profit automatically
    Costing depended on individuals and was a black box
Solution
After

From import to visualization on a single platform. Real-time company-wide P&L for management, the profitability of their own customers for department heads, and automated costing for accounting—a multi-axis P&L dashboard built to support decisions on all three fronts.

Automated pipeline: data import 〜 costing 〜 P&L aggregation 〜 visualization Data Import ZAC projects Payroll by SV Costing Engine Auto-calc P&L aggregation Customer × SV Dept × Seg Dashboard Mgmt visualization Multi-axis Feed analysis results back into management decisions A shared platform supporting analysis, costing, and control Multi-axis pivot analysis Customer/SV/Dept/Seg Costing engine Gross & operating profit, automated Role permission management Per-department view control Automates from import to P&L visualization, accelerating management decisions
app.plboard.example.jp/dashboard
Revenue (K JPY) 128,400 COGS 86,200 Gross profit 42,200 Op. profit 18,600 Gross profit by customer A Co. B Co. C Co. D Co. E Co. F Co.
P&L Dashboard — revenue, cost, gross profit, and operating profit visualized by customer
Tech Stack React Ant Design Laravel MySQL OAuth2
10months
54person-months
Considering adopting it at your company too? → info@amela.vn