Case Study · Rovic Chicken Dealer

Three decades of records, one manager carrying the ledgers on trips, and a business that could not stop.

Rovic Chicken Dealer (RCD) is a medium-sized poultry distribution business in the Philippines that has been operating for more than three decades, and it is still growing. Its transaction volume is high, its operating day is complex, and until this engagement, its entire memory lived on paper. Studio JNSQ moved that memory to the cloud in two weeks, and the business found hundreds of thousands of pesos it had lost along the way.

2 weeks
Delivery Window
41%
Aged AR Collected
5–10 hrs
Weekly Time Recovered
RVF™
Framework Applied
Back to portfolio
Who they are

Thirty years of operation, still growing, still keeping the records by hand.

Rovic Chicken Dealer (RCD) is a medium-sized family-owned poultry distribution business in the Philippines that has been in operation for more than three decades. It is not slowing down. On any given day, multiple trucks run multiple trips, and the operational floor layers loading exchanges, culling, supplier settlements, and customer collections into the same working window. It is a capital-intensive business, and it moves quickly.

What made RCD unusual was not the volume; it was the medium. Everything above — every transaction, every customer account, every receivable balance, every reconciliation — lived on paper. Thirty years of physical ledgers, still hand-written, still the source of truth. The records were the business, and the records were the risk.

Client
Rovic Chicken Dealer
Sector
Agriculture, poultry distribution, Philippines
Tenure
30+ years in operation, medium-sized, still growing
Operational Reality
High transaction volume, multi-truck days, supplier and customer exchanges layered into the same window
Engagement
RVF™ Advisory + Execution: Cloud-Native Operating System
Delivery Window
2 weeks (ahead of the owner's international trip)
The bind they were in

The records were fragile, the manager was the bottleneck, and the expenses were invisible.

The owner needed to travel, and travel is where the three failure modes of the paper system stacked on top of each other in the worst possible way. Normally, the manager would take the physical customer ledgers with him on trips, so that he could keep the collection notes moving by hand while he was away. That is not portability; that is the records holding the business hostage. And it made every one of the paper-era problems worse at exactly the moment they needed to be smaller.

First was the fragility. A damaged or misplaced book could take decades of accounts receivable, sales history, and customer context down with it, permanently. Second was the manager himself becoming a bottleneck — not because of anything he was doing wrong, but because reconciliation, allocation, and customer follow-up all lived in his handwriting and his memory. When he was travelling or attending to other work, the business waited on him. Third was expense drift. The business carried a growing tail of non-operating expenses, and they piled up quickly. The owner wanted to be able to look at a period, at a glance, and know: why is this month bigger, and were there unusual items I should have seen coming. None of that was answerable from the paper trail.

How we approached it

We did not migrate thirty years of records. We gave the business a clean starting line.

The instinctive move on a digital transformation this old would be to migrate the historical data first, spend months tracing missing entries, and stand up the system on the back of a full reconstruction. That approach would have failed here for two reasons. First, the delivery window was two weeks; there was no time to relitigate three decades of paper. Second, the historical records were themselves incomplete, and forcing them into a modern schema would have produced a system whose ledger nobody trusted from day one.

So we did something quieter, and more useful. Rather than migrating the past, we designed the system to accept opening balances: a clean, deliberate starting point that the business could set as-of a specific date, with the older paper records kept in their original form as reference. The one exception was accounts receivable, because AR is the one place where the past is still an active balance sheet item. So we spent a focused stretch of the engagement combing through the 2026 records from the start of the year, surfacing aged receivables that had been buried inside the manual ledgers, and adding them to the opening balances as the system went live. That single exercise turned into the largest cash-flow moment of the entire engagement.

The data engineering was built for trust. Every sale line auto-posts its unpaid balance to Accounts Receivable as a debit; every payment auto-posts as a credit. The audit module ties batches and non-operating expenses to a specific audit period, preventing double-counting. Liquidation reports compare expected ending balances (computed from prior audit + batch profits minus expenses) against actual holdings (cash, bank, inventory, A/R, floating), surfacing the variance as a single number the owner can interrogate. On the analytics side, Chart.js renders three live charts on the dashboard: per-batch net income as a signed bar chart, sales classification as a doughnut, and expense breakdown as a pie. The inventory reconciliation table runs continuously, comparing acquired versus disposed versus unaccounted chickens across all batches.

Explore the full system

Eight modules, every screen, with design annotations explaining the decisions behind each feature.

Open interactive system →
Feature: the dashboard

Organized around the batch, because that is how the business already thinks.

The dashboard was designed around a single organizing principle: the batch. A poultry distribution business doesn't think in months or quarters; it thinks in truckloads. So the six KPI cards at the top summarize the batch universe: Gross Revenue, Cost of Goods Sold, Transaction Expenses, Net Income, Chickens Disposed, and Outstanding A/R. Below the cards, three Chart.js visualizations turn the numbers into shapes the owner can read without parsing a table: a per-batch profit bar chart (blue for profit, red for loss), a sales classification doughnut (Good / Semi / Reject), and an expense breakdown pie.

The inventory reconciliation table at the bottom is the feature the owner didn't ask for but uses the most. It cross-references acquired chickens against disposed chickens across every batch and surfaces the unaccounted delta in red. Before this table existed, the business discovered inventory gaps only at month-end. Now they surface the same day the batch closes.

01 — Dashboard
The batch business at a glance
Six KPI cards, three Chart.js charts, and an inventory reconciliation table — organized around the batch, because that is how the business already thinks.
  • Six KPI cards. Gross Revenue, CGS, Transaction Expenses, Net Income, Chickens Disposed, Outstanding A/R — the numbers the owner checks first.
  • Batch profit chart. A per-batch bar chart with positive (blue) and negative (red) bars so unprofitable runs are immediately visible.
  • Sales classification. Good / Semi / Reject doughnut breaks down what the business is actually selling.
  • Inventory reconciliation. Acquired vs disposed vs unaccounted, with variance in red when the numbers don't match.
View this screen in the interactive system →
Feature: the operational unit

The batch stayed the same; only the medium changed.

In RCD's mental model, everything happens inside a batch — a shipment run, with its own suppliers, customers, sales lines, expense lines, and reconciliation. That vocabulary was built over thirty years, and it is exactly right for how poultry distribution actually works. So the system was designed around the batch as the primary object, rather than forcing the business into a generic invoicing model that would have felt foreign from day one.

02 — Batches
Every truckload, one row
The batch list is the operational backbone. Each row tracks a procurement-to-disposal cycle with balance badges that surface data problems before they compound.
  • Balance badges. "Balanced", "50 undisposed", "12 unlisted" — color-coded status at a glance so reconciliation gaps don't hide.
  • Sortable columns. Farm, date, acquired, disposed, gross revenue, net income, A/R — each sortable for different questions.
  • Bulk select. Checkbox column for batch-level operations like audit grouping and export.
  • Net income inline. Profit or loss per batch shows in the list so the owner doesn't have to open each one to assess it.
View this screen in the interactive system →
Feature: the safety net

Every destructive action creates a snapshot, automatically.

When we asked the manager what he was most anxious about with digital tools, his answer was not about learning curves; it was about accidental deletion. Thirty years of paper had taught him that mistakes are permanent, and he had never fully believed that a computer could be more forgiving than a spreadsheet with a stray keystroke.

03 — Batch Editor
One screen, entire lifecycle
The batch editor captures the full procurement-to-collection cycle: header with glance strip, procurement details, sale lines with classification, transaction expenses, and an auto-computed revenue report.
  • Live glance strip. Total Acquired, Disposed, Supposed Undisposed, and Status sit at the top — updated as you type.
  • Sale line classification. Good / Semi / Reject per line, with customer, quantity, price, paid, and balance — all editable inline.
  • Auto-computed revenue report. Gross Revenue minus CGS minus Transaction Expenses equals Net Income, recalculated on every keystroke.
  • Version history. Snapshots auto-created before any destructive action; restore or download as JSON.
View this screen in the interactive system →

The reset button lives in a section literally labelled Danger Zone, and even that is guarded by the automatic snapshot behaviour. It is a small kind of grace to build into a tool, and it is the reason the manager stopped hesitating on the third day.

Feature: the on-ramp

A fifteen-line modal that made a thirty-year migration unnecessary.

The Opening AR modal is a small piece of UI that carries the entire delivery strategy behind it. Because we designed the system to accept balances forwarded from an older ledger, we did not have to prove the historical data was complete; we only had to prove that today's balance was correct. That single move turned a six-month migration project into a two-week implementation.

04 — Audit Records
Proving the cash is really there
Periodically the dealer counts everything they hold and checks it against what the books predict. This is the reconciliation engine — the feature that makes the whole system trustworthy.
  • Roll-forward math. Prior ending balance + selected batch profits − non-op expenses = expected ending.
  • One audit per entry. Batches and non-op expenses lock to an audit so they can't be double-counted.
  • Liquidation breakdown. Cash, bank, inventory, A/R, floating & others sum to actual holdings.
  • Variance, color-coded. Expected vs actual surfaces shrinkage or an encoding slip immediately.
View this screen in the interactive system →
Feature: answering the owner's real question

Non-operating expenses live in their own tab, so nothing hides inside a total.

Non-operating expenses had a way of piling up inside a paper system, because they did not tie cleanly to any batch and nobody wanted to spend the mental effort of categorizing them mid-shift. Over time, that tail became the specific place where the owner was losing visibility. So we gave non-op expenses their own tab, kept them fully separated from operating cost, and surfaced the whole expense mix on the dashboard as two views at once.

05 — Non-Operating Expenses
The money that leaves outside a batch
Owner draws, household bills, loan interest — real outflows that aren't tied to any truckload. A fast journal that feeds the audit.
  • Type-to-add row. The dashed bottom row promotes to a real entry the moment you type; a fresh blank appears. Tab keeps flowing.
  • Groups. Entries cluster into named groups so a whole set can be pulled into an audit at once.
  • Audit lock chips. Once an entry is claimed by an audit it's read-only and tagged with that audit's date.
  • Bulk actions. Select to export, group, ungroup or delete.
View this screen in the interactive system →

The owner can now ask the same question she always asks — what changed this month — and get the answer before she finishes the sentence.

Feature: aged receivables that stop hiding

Every customer with an outstanding balance now has a card, and the aged ones surface first.

Before the engagement, the owner had accepted that some receivables would eventually be written off as bad debt, not because the customers were unreachable, but because tracking each account's balance and history across a stack of hand-written ledgers was too expensive to do well. The work of collection was possible; the seeing was what was broken.

06 — Accounts Receivable
A running ledger per customer
Sales across every batch become debits; payments become credits. Each customer carries one running balance — proper double-entry, made legible.
  • Debit / credit tags. Sales (Dr) and payments (Cr) interleave chronologically with a running balance column.
  • Expand on click. The header row is the balance; expand for the full ledger and drill back to the batch.
  • Opening balances. Receivables that pre-date the system can be seeded so history stays whole.
  • Overpaid detection. Negative balances flag as "Overpaid" in amber, not hidden.
View this screen in the interactive system →

The record-combing exercise put hundreds of thousands of pesos back into visible AR that had been buried in the paper records, and 41% of those aged balances have been collected since implementation. Average collection time improved by two to three days, quietly, without any change to the collection process. Only the visibility changed.

In the manager's words

What JML said, unedited.

This system not only allowed me to travel and enjoy my off times, but also really streamline the sales and collections process to make sure the business is not losing money anywhere.

JML · Sales and Finance Manager, Rovic Chicken Dealer
What changed on the ground

Time back on the calendar, cash back in the ledger, and a bottleneck that stopped bottlenecking.

The manager travels now without the ledgers. The books stay behind, and the business does not stop when he is out of the office, because the system holds the operational picture and multiple people can move against it at once. That single change — the elimination of the single point of failure — had knock-on effects that reached every corner of the operating day.

Approximately five to ten hours per week came back to the manager's calendar, and in complex-transaction periods (multi-truck days, layered supplier and customer exchanges), the savings on audit alone ran two to five hours per period. The double-entry and lost-cash-flow risks that came with manual re-writes across ledgers are automated away. Cash holdings, the single most sensitive metric for a capital-intensive distribution business, are now visible at any moment, in any location.

Time Recovered
5 to 10 hours per week saved on reconciliation and data cascades. 2 to 5 hours saved per audit period on complex-transaction days.
Aged AR Collected
41% of flagged aged receivables collected since implementation. The 2026 record-combing exercise recovered hundreds of thousands of pesos in previously buried balances.
Collection Cycle
Average collection time improved by 2 to 3 days. Aged balances now surface in-system, instead of appearing during an owner review.
Data Integrity
Double-entry and lost-cash-flow risks are automated away. Cash holdings are visible at any moment, from any device.
Where the business is going next

The recovered attention is now studying two new markets.

RCD handles high transaction volume, and the system has been running long enough to surface real patterns rather than one-month noise. That is where the compounding effect of the Resource Value Formula™ starts to show up in the shape of the business itself. When you recover a manager's calendar, an owner's visibility, and a receivables position all at once, the question stops being how do we survive the next week and starts being where do we grow to next.

RCD is now studying market expansion into Visayas and Mindanao. Both regions carry logistics complexity that the paper era would have made unreadable in time to act on; both regions look answerable now, because the operating picture is finally visible day-by-day rather than reconstructed at month-end. That is the whole thesis of the RVF™. Recover the resource, and the business grows into a shape it could not previously see.

About this case study. Prepared by Studio JNSQ based on a client engagement, published with the client's consent under full attribution. The client is Rovic Chicken Dealer (RCD), a poultry distribution business in the Philippines. Design notes throughout summarize the deployed system's features; an interactive system page shows every screen with annotations. Results are measured against the scope that was agreed. No outcomes outside the brief are claimed.
Back to portfolio
Want to know where your resources are leaking?

Take the Resource Value Formula™.

The same framework that anchored this engagement is available as a free diagnostic. Twenty questions across four aspects, five to seven minutes.