Case Study

Live Books From WhatsApp Screenshots

A cross-border importer running between Colombia, Venezuela and the United States replaced months of late-night Excel work with a WhatsApp-native AI assistant. Every Zelle screenshot becomes a live, categorized bookkeeping entry in under 8 seconds.

Importer / Cross-border Venezuela ↔ USA AI Bookkeeping

Scattered WhatsApp Screenshots, Excel at 2 a.m.

For a small importer that receives client payments through Zelle, manages tankers in transit, holds revolving supplier credit and tracks active loans, the most expensive operational decision is rarely about pricing. It is about how many hours go into reconciling books at the end of every month.

Before ZENIA, the situation looked like this:

  • Hundreds of Zelle screenshots dispersed across WhatsApp threads, with no central log
  • A Notion page tracking expenses by hand, kept up by the owner herself
  • An Excel sheet that drifted out of sync every week and required late-night reconciliation before the close of the month
  • No traceability of cash position: was it sitting in the bank, locked in tankers in transit, or tied up in client receivables? Nobody could say with confidence
  • Loan and supplier debt tracked informally, monthly interest mentally calculated and easy to miss
  • Multi-leg deliveries (truck departs, driver collects on the road, partial credit sales) impossible to map to clean categories

The owner knew automation existed. The problem was that every traditional accounting tool assumed her business was either a US-only retailer or a perfectly digital LATAM SMB. None of them spoke her actual operational language: WhatsApp-first, Spanish with regional slang, Zelle-driven, with concepts like "la gandola" and "al fiado" baked into daily ops.


A WhatsApp-Native AI Bookkeeping Assistant Built for Her Business

We designed and deployed an AI assistant that lives entirely inside WhatsApp and writes directly into a live Google Sheets repository. The owner forwards a Zelle screenshot the way she would send a photo to a friend. The assistant reads the transfer, classifies it, validates it, deduplicates it against history, and writes it to a structured ledger with an audit trail. No Excel. No data entry. No app to open.

The system she now operates on:

  • Computer vision on every screenshot: the assistant uses Claude Vision to extract sender, amount, date and confirmation code from any Zelle or Bank of America capture, even when multiple transfers are visible in a single image
  • 16 accounting categories tuned to her operation: client receipts, logistics, payroll, customs, transit gratuities, loan interest, capital paydowns, tanker disbursements, tanker returns, credit sales, credit collections, fees and more
  • Three-bucket cash traceability calculated automatically: cash in the bank, capital in transit (tankers) and accounts receivable. The owner sees exactly where every dollar lives at any moment
  • Loan tracker with original capital, monthly interest, paid-to-date totals and live balance for each lender, all derived from natural-language transactions she logs by chat
  • Revolving supplier credit for cylinder/tanker replacement, modeled as a separate sub-section that updates each cycle
  • Tanker intelligence: when she reports a tanker closure ("the truck came back, recovered three thousand cash and one thousand on credit to Carlos"), the assistant automatically distributes the amount across the right buckets and creates the corresponding receivable under Carlos' name
  • Regional Spanish fluency: the assistant understands "chévere", "burda", "vaina", "verdes" (USD), "lukas" (thousands) and the natural way she actually speaks. No command syntax to learn
  • Multi-image batching: she can drop 20 screenshots in a row and the assistant groups them, extracts every transfer and reports back with a clean summary
  • Persistent context: the conversation survives restarts, time gaps and session breaks. Memory is backed by the spreadsheet itself
  • Full audit log: every CREATE, UPDATE and DELETE is timestamped in a control register, ready for tax review or external accounting
  • Executive dashboard: live KPIs, daily cashflow, top fifteen clients, debt exposure and the three cash buckets at the top, formula-driven, visible from any phone or laptop

The owner provides natural-language input. The assistant handles classification, deduplication, ledger writes, dashboard updates and audit. The accounting work that used to consume hours per week now happens in real time, in the messages she was already sending.


From Spreadsheet Friction to Operational Clarity

8s
From WhatsApp capture to ledger entry
16
Operational categories tracked live
0
Excel hours per week (was 6+)

Before ZENIA

  • Zelle screenshots scattered across WhatsApp threads
  • Notion page hand-maintained by the owner
  • Weekly Excel reconciliation, often at 2 a.m.
  • No clear cash position across bank, tankers and credit
  • Loan interest calculated in her head
  • Tanker closures impossible to attribute by client
  • No audit trail for tax review

After ZENIA

  • Every transfer logged automatically from WhatsApp
  • Live Sheet with 16-category ledger and dashboard
  • Zero manual data entry, zero late-night Excel
  • Three cash buckets calculated in real time
  • Loan trackers with capital, interest YTD and live balance
  • Tanker closures auto-distributed across receivables
  • Timestamped audit log on every action

What the Assistant Tracks Live

Categorized transactions Cobros, gastos, gandolas, créditos, deudas
Cash buckets calculated Bank · Tankers in transit · Receivables
Loan tracking Capital, monthly interest, paid YTD, live balance
Audit log Every CREATE, UPDATE, DELETE with timestamp
Owner's manual workload Send a screenshot, talk normally

The shift is not measured in hours saved. It is measured in operational clarity. Before, the owner could not answer "how much do I have in the bank right now?" without first opening three documents. Now she opens her phone and the dashboard answers it. The assistant carries the bookkeeping discipline so the operator can focus on growing the business.


"I used to dread closing the month. Now I send a screenshot and forget about it. The numbers are already where they need to be."

Owner, cross-border importer (Venezuela ↔ USA)

Receive Payments in Zelle, Bank Transfers or Cash?

If your business runs on transfers and your bookkeeping still depends on screenshots and Excel, we can build you the same kind of WhatsApp-native AI assistant, tuned to your operation, your language and your verticals.