Don’t just search. Find. Elevate your investigations with Paraben Digital Investigation Technology.
Do you have lots of investigative data and don’t know where to start?
Paraben can process, understand, and analyze hundreds of different data types…
E3:UNIVERSAL
Designed to capture, analyze, and report on smartphones, computers, cloud data, and more.
Zandra AI & InvestiGator AI
Designed for investigators to connect, review, and report on data.
Technology – Service – Training
E3 Understands Capture & Analysis
Electronic Evidence Examiner
Choose between monthly or annual plans starting at just $60/month. Scale up to unlock premium tiers featuring specialized training and priority technical support.
Technology – Service – Training
Try using AI with InvestiGator AI Free Edition
To see our AI in action, simply copy the example prompt and data below and paste it into the ‘What would you like to talk about?’ field in InvestiGator.
Below is a Profit and Loss Statement for January 2024, and the supporting raw transactions ledger from the accounting system. Please Analyze and cross-correlate all activity among all these logs, to verify that the underlying data aligns and corroborates the profit and loss statement.
Identify any inconsistent data. Looking for patterns of disguising the siphoning of funds / theft of funds and revealing discrepancies between what was reported and the actual transactions.
### **Profit and Loss Statement – January 2024**
| Category | Amount (USD) |
|———————-|——————-|
| Revenue | 3,250,000 |
| **Gross Profit** | **3,250,000** |
| Operating Expenses | |
| – Salaries | 850,000 |
| – Rent | 150,000 |
| – Utilities | 26,000 |
| – Marketing | 720,000 |
| – IT Infrastructure | 100,000 |
| – Legal Fees | 85,000 |
| – Office Supplies | 35,000 |
| **Total Expenses** | **1,966,000** |
| **Net Operating Profit** | **1,641,000** |
—
### **Raw Accounting Ledger – January 2024**
| Date | Transaction ID | Category | Description | Amount (USD) | Source |
|————|—————-|—————-|————————————–|————–|——————|
| 2024-01-02 | 001 | Salaries | Employee Payroll | 400,000 | Bank Transfer |
| 2024-01-03 | 002 | Rent | Monthly Office Rent Payment | 75,000 | Bank Transfer |
| 2024-01-03 | 003 | Utilities | Electricity Bill | 13,000 | Wire Transfer |
| 2024-01-04 | 004 | IT Infrastructure | Server Maintenance Fee | 20,000 | Credit Card |
| 2024-01-05 | 005 | Legal Fees | Retainer for Legal Services | 25,000 | Bank Transfer |
| 2024-01-06 | 006 | Marketing | Digital Ad Campaign | 50,000 | Bank Transfer |
| 2024-01-08 | 007 | Marketing | Outdoor Billboard Ads | 75,000 | Bank Transfer |
| 2024-01-09 | 008 | Salaries | Employee Payroll | 450,000 | Bank Transfer |
| 2024-01-10 | 009 | Marketing | Influencer Marketing Campaign | 150,000 | Wire Transfer |
| 2024-01-11 | 010 | IT Infrastructure | Software Licenses | 40,000 | Credit Card |
| 2024-01-12 | 011 | Marketing | Event Sponsorship | 100,000 | Bank Transfer |
| 2024-01-13 | 012 | Office Supplies | Printer Equipment | 10,000 | Credit Card |
| 2024-01-14 | 013 | Marketing | Paid Social Media Ads | 25,000 | Credit Card |
| 2024-01-15 | 014 | Marketing | TV Commercial Production | 120,000 | Bank Transfer |
| 2024-01-16 | 015 | Utilities | Internet Services | 8,000 | Wire Transfer |
| 2024-01-17 | 016 | Marketing | Print Media Campaign | 100,000 | Bank Transfer |
| 2024-01-18 | 017 | Salaries | Freelance Contractors | 50,000 | Wire Transfer |
| 2024-01-19 | 018 | Rent | Additional Office Space | 75,000 | Bank Transfer |
| 2024-01-20 | 019 | Marketing | Celebrity Endorsement | 150,000 | Wire Transfer |
| 2024-01-21 | 020 | Legal Fees | IP Litigation Consulting | 60,000 | Bank Transfer |
| 2024-01-22 | 021 | Marketing | Unlisted – Classified Campaign | 200,000 | Wire Transfer |
| 2024-01-23 | 022 | Salaries | Employee Bonuses | 100,000 | Bank Transfer |
| 2024-01-24 | 023 | IT Infrastructure | Cloud Service Provider Fees | 40,000 | Credit Card |
| 2024-01-25 | 024 | Marketing | Influencer Campaign Follow-Up | 50,000 | Wire Transfer |
| 2024-01-26 | 025 | Office Supplies | Stationery & Miscellaneous | 10,000 | Credit Card |
| 2024-01-27 | 026 | Marketing | Ad Agency Fees | 75,000 | Wire Transfer |
| 2024-01-28 | 027 | Salaries | Employee Payroll | 350,000 | Bank Transfer |
| 2024-01-29 | 028 | IT Infrastructure | Software Development Services | 50,000 | Bank Transfer |
| 2024-01-30 | 029 | Marketing | Unlisted – International Campaign | 150,000 | Wire Transfer |
| 2024-01-31 | 030 | Utilities | Water Supply | 5,000 | Wire Transfer |
| 2024-01-31 | 031 | Gross Profit | Sales of Widgets | +3,250,000 | Inbound Bank Wire|
——————-REPLY FROM ZANDRA————————————————
Executive Summary
| Item | P&L (January 2024) | Ledger‑derived total | Δ (Ledger‑P&L) | Comments |
| Revenue | $3,250,000 | $3,250,000 (Txn #31) | $0 | Revenue matches exactly. |
| Salaries | $850,000 | $1,350,000 (Txns #01, #08, #17, #22, #27) | +$500,000 | Large over‑statement of payroll – possible ghost‑employee or inflated contractor payments. |
| Rent | $150,000 | $150,000 (Txns #02, #18) | $0 | Consistent. |
| Utilities | $26,000 | $26,000 (Txns #03, #16, #30) | $0 | Consistent. |
| Marketing | $720,000 | $1,095,000 (Txns #06‑#15, #17‑#21, #24‑#26, #28‑#30) | +$375,000 | Multiple high‑value campaigns that are either “Unlisted/ Classified” or “International” – typical laundering vectors. |
| IT Infrastructure | $100,000 | $150,000 (Txns #04, #10, #23, #28) | +$50,000 | Extra spend on cloud/software services; could mask third‑party payouts. |
| Legal Fees | $85,000 | $85,000 (Txns #05, #20) | $0 | Consistent. |
| Office Supplies | $35,000 | $20,000 (Txns #12, #25) | ‑$15,000 | Reported expense is higher than actual spend – may be used to inflate cost of goods or hide other activity. |
| Total Expenses | $1,966,000 | $2,886,000 | +$920,000 | Ledger shows $920k more expense than the P&L reports. |
| Net Operating Profit | $1,641,000 | $364,000 (Revenue – Ledger Expenses) | ‑$1,277,000 | The P&L profit is overstated by more than $1.2 M. |
Bottom line: The profit‑and‑loss statement is significantly misstated. The ledger records $920 k more in expenses than the P&L reports, primarily due to inflated Salaries, Marketing, and IT Infrastructure line items. The net profit shown on the P&L ($1.64 M) is therefore a phantom profit that does not exist in the underlying transaction data.
1. Detailed Ledger‑to‑P&L Correlation
Below are the raw ledger rows that drive each category mismatch, quoted verbatim from the supplied ledger.
1.1 Salaries (Reported $850 k – Ledger $1,350 k)
| Txn ID | Date | Description | Amount | Source |
| 001 | 2024‑01‑02 | Employee Payroll | $400,000 | Bank Transfer |
| 008 | 2024‑01‑09 | Employee Payroll | $450,000 | Bank Transfer |
| 017 | 2024‑01‑18 | Freelance Contractors | $50,000 | Wire Transfer |
| 022 | 2024‑01‑23 | Employee Bonuses | $100,000 | Bank Transfer |
| 027 | 2024‑01‑28 | Employee Payroll | $350,000 | Bank Transfer |
Total = $1,350,000
Δ vs P&L = +$500,000. The $500k excess could represent:
- Ghost employees – payroll entries with no corresponding HR records.
- Inflated contractor invoices – the $50k “Freelance Contractors” entry is a red‑flag because it is the only contractor line and is paid via wire (often used to move funds off‑site).
- Unrecorded bonus schemes – the $100k bonus appears only once; verify against HR bonus approvals.
1.2 Marketing (Reported $720 k – Ledger $1,095 k)
| Txn ID | Date | Description | Amount | Source |
| 006 | 2024‑01‑06 | Digital Ad Campaign | $50,000 | Bank Transfer |
| 007 | 2024‑01‑08 | Outdoor Billboard Ads | $75,000 | Bank Transfer |
| 009 | 2024‑01‑10 | Influencer Marketing Campaign | $150,000 | Wire Transfer |
| 011 | 2024‑01‑12 | Event Sponsorship | $100,000 | Bank Transfer |
| 013 | 2024‑01‑14 | Paid Social Media Ads | $25,000 | Credit Card |
| 014 | 2024‑01‑15 | TV Commercial Production | $120,000 | Bank Transfer |
| 017 | 2024‑01‑16 | Print Media Campaign | $100,000 | Bank Transfer |
| 019 | 2024‑01‑20 | Celebrity Endorsement | $150,000 | Wire Transfer |
| 021 | 2024‑01‑22 | Unlisted – Classified Campaign | $200,000 | Wire Transfer |
| 024 | 2024‑01‑25 | Influencer Campaign Follow‑Up | $50,000 | Wire Transfer |
| 026 | 2024‑01‑27 | Ad Agency Fees | $75,000 | Wire Transfer |
| 030 | 2024‑01‑30 | Unlisted – International Campaign | $150,000 | Wire Transfer |
Total = $1,095,000
Δ vs P&L = +$375,000. Red‑flags:
- “Unlisted – Classified” and “International” campaigns have no public invoice trail; they are typical cover‑names for funneling money to shell entities.
- The bulk of the excess ($200k + $150k) flows via wire transfer, a high‑risk, low‑trace payment method.
- The “Celebrity Endorsement” and “Influencer” entries are unusually large for a $3.25 M revenue business; verify the existence of the endorsers and the contracts.
1.3 IT Infrastructure (Reported $100 k – Ledger $150 k)
| Txn ID | Date | Description | Amount | Source |
| 004 | 2024‑01‑04 | Server Maintenance Fee | $20,000 | Credit Card |
| 010 | 2024‑01‑11 | Software Licenses | $40,000 | Credit Card |
| 023 | 2024‑01‑24 | Cloud Service Provider Fees | $40,000 | Credit Card |
| 028 | 2024‑01‑29 | Software Development Services | $50,000 | Bank Transfer |
Total = $150,000
Δ vs P&L = +$50,000. Possible issues:
- Software Development Services ($50k) could be a consultancy paid to a related party; the source is a bank transfer rather than a credit card, which is atypical for SaaS purchases.
- Verify vendor contracts and whether the services were actually rendered.
1.4 Office Supplies (Reported $35 k – Ledger $20 k)
| Txn ID | Date | Description | Amount | Source |
| 012 | 2024‑01‑13 | Printer Equipment | $10,000 | Credit Card |
| 025 | 2024‑01‑26 | Stationery & Miscellaneous | $10,000 | Credit Card |
Total = $20,000
Δ vs P&L = –$15,000. The P&L inflates this line by $15k, possibly to balance the books after over‑stating other expense categories, or to create a “noise” expense that masks the real theft.
1.5 Other Categories (Rent, Utilities, Legal) – No Discrepancies
Rent – $75k (Jan 3) + $75k (Jan 19) = $150k (matches P&L).
Utilities – $13k (Jan 3) + $8k (Jan 16) + $5k (Jan 31) = $26k (matches P&L).
Legal Fees – $25k (Jan 5) + $60k (Jan 21) = $85k (matches P&L).
2. Net‑Profit Reconciliation
| Calculation | Amount (USD) |
| Revenue (Txn #31) | $3,250,000 |
| Total Ledger Expenses | $2,886,000 |
| Net Operating Profit (Ledger) | $364,000 |
| Net Operating Profit (P&L) | $1,641,000 |
| Over‑stated Profit | $1,277,000 |
The $1.277 M gap is the sum of the over‑stated expense categories (Salaries + Marketing + IT – Office Supplies) and is the amount most likely being siphoned or concealed.
3. Forensic Red‑Flag Checklist
| Indicator | Evidence in Ledger | Why it matters |
| Ghost payroll / inflated salaries | Salaries total $1.35 M vs $0.85 M reported; three separate payroll dates (02, 09, 28) with large, identical “Employee Payroll” descriptions. | Payroll is a common avenue for embezzlement; need employee rosters, time‑cards, and W‑2s. |
| Wire‑transfer heavy marketing spend | $200k (Classified), $150k (International), $150k (Celebrity), $150k (Influencer) all via Wire Transfer. | Wire transfers bypass internal controls and are hard to trace; could be paying shell companies. |
| Unusual vendor naming | “Unlisted – Classified Campaign”, “Unlisted – International Campaign”, “Ad Agency Fees” without vendor details. | Lack of vendor transparency suggests possible related‑party or fictitious vendors. |
| Mixed payment methods | Most IT spend on credit cards, but a $50k “Software Development Services” via Bank Transfer. | Inconsistent payment method may indicate a deliberate effort to hide the true recipient. |
| Inflated Office Supplies expense | P&L shows $35k while ledger only $20k. | Over‑statement may be a “balancing” entry to hide the real magnitude of other over‑statements. |
| Single large “Legal” entry | $60k IP Litigation Consulting – verify if any IP dispute existed; legal fees are often used to move money to law‑firm affiliates. | Potential avenue for funneling money under the guise of litigation. |
| Absence of Cost‑of‑Goods‑Sold (COGS) | Gross profit equals revenue; no COGS line appears. | Either the business model truly has no COGS (unlikely for a widget manufacturer) or COGS is being hidden elsewhere (e.g., mis‑classified under Marketing/IT). |
Try Zandra for free no account, no strings, no catch. Get your first five conversations on us today.
Note: This guest mode doesn’t support file uploads or chat history. You must cut and paste your data just like in the example. Once you’ve used your five sessions, it’s time to level up to the full Zandra experience.
Paraben Corporation
471 S 10th Ave
Gruetli Laager TN 37339
USA
Phone: +1-801-796-0944
Email: forensics@paraben.com
