- Home
- Skills
- Business & Operations
- Business Financial Leakage Investigator
Works with the AI Agents you already use
Business Financial Leakage Investigator
Analyze business records to identify revenue leakage, expense spikes, and margin erosion with forensic precision.
$49
Business Financial Leakage Investigator
Example session with this skill installed
I have attached my Shopify sales report and Stripe settlement export for Q3. We are seeing a 4% discrepancy between reported sales and bank deposits. Please investigate the leakage.
- Read your context and instructions
- Compiled the business financial leakage
I have analyzed the Shopify and Stripe records for the Q3 period (July 1 – September 30). The initial data quality check indicates consistent currency (USD) across both sources, though 14 transactions in the Shopify export lack corresponding Stripe IDs.
Financial Investigation Report: Q3 Revenue Discrepancy
1. Reconciliation Summary
| Category | Shopify Ledger (Gross) | Stripe Settlements (Net) | Variance |
|---|---|---|---|
| Gross Sales | $452,400.00 | $448,200.00 | ($4,200.00) |
| Refunds/Returns | ($12,100.00) | ($12,450.00) | $350.00 |
| Processing Fees | N/A | ($13,108.00) | N/A |
| Total Expected Deposit | $440,300.00 | $422,642.00 | ($17,658.00) |
2. Key Findings
| ID | Finding | Category | Status | Amount | Confidence |
|---|---|---|---|---|---|
| REV-01 | Unmatched Shopify Orders | Revenue | Confirmed | $4,200.00 | High |
| EXP-02 | Duplicate Transaction Fees | Expense | Hypothesis | $840.00 | Medium |
| REC-03 | Q3 End Timing Difference | Recon | Timing | $12,618.00 | High |
3. Revenue Integrity Analysis
Unmatched Orders: 14 orders (IDs #8840-#8854) appear in Shopify but have no corresponding Stripe transaction. This suggests either a payment gateway failure or orders processed through a secondary, unsupplied channel.
Refund Mismatch: Stripe shows $350 more in refunds than Shopify. Likely manual refunds issued directly in the Stripe dashboard that were not synced to the commerce platform.
4. Prioritized Action Plan
- P0 (Immediate): Verify order IDs #8840-#8854 against bank deposits to confirm if cash was actually received.
- P1 (High): Review Stripe logs for manual refund triggers to ensure Shopify inventory levels remain accurate.
- P2 (Operational): Audit the "Shopify-to-Stripe" API connector to prevent future sync failures.
Next steps
- Provide the bank statement for the first week of October to resolve the $12,618 timing variance.
- Upload the export from any secondary payment methods (e.g., PayPal) used during Q3.
- Confirm if manual refunds were authorized in the Stripe dashboard during August.
Connects securely to your tools. The creator never sees your data.
About this skill
Stop letting unexplained variances and margin erosion eat your bottom line. This skill performs a cold-blooded financial forensic investigation on your business records to find exactly where money is leaking. It transforms messy transaction exports and revenue reports into an evidence-led action plan for profit recovery.
What it does
- Revenue integrity audit by cross-referencing sales ledgers against processor settlements and bank deposits to find unmatched funds or timing gaps.
- Expense leakage detection identifying duplicate vendor payments, zombie subscriptions, and avoidable transaction or platform fees.
- Profitability diagnosis decomposing margin changes into price, volume, and cost effects at the individual product or service level.
- Discrepancy classification flagging variances as timing differences, missing records, or unexplained losses requiring immediate investigation.
- Action prioritization ranking findings by financial impact and confidence levels so you fix high-materiality leaks first.
How it works
- Data Ingestion where you provide transaction exports, P&L summaries, or processor statements for a specific reporting period.
- Quality Assessment to identify missing columns, inconsistent currencies, and non-operating items like loans or owner withdrawals.
- Forensic Analysis through nine phases covering revenue, expenses, reconciliation, and product-level contribution margins.
- Investigation Reporting delivering a structured breakdown of findings, prioritized actions, and a list of specific missing records needed to close gaps.
Frameworks & tools
This skill utilizes standard management accounting principles, including contribution margin analysis, variance decomposition, and 3-way reconciliation logic. It is compatible with data exported from QuickBooks, Xero, Stripe, Shopify, and standard bank CSVs.
Why this beats prompting it yourself
Generic prompts often miss the nuances of accrual versus cash accounting or fail to distinguish between gross and net revenue. This skill enforces strict scenario discipline, ensuring that every identified "saving" is backed by specific transaction evidence rather than vague assumptions.
Use cases
- Auditing payment processor fees and settlements against gross sales to find hidden costs.
- Investigating a sudden dip in net profit despite stable or growing top-line revenue.
- Identifying overlapping SaaS subscriptions or duplicate billing across multiple departments.
- Ranking product lines by true contribution margin after accounting for variable delivery and return costs.
Known limitations
Does not provide formal audit opinions, tax advice, or legal fraud determinations. Requires transaction-level data for high-confidence leakage detection; summary totals will limit output to high-level diagnostics.
Requires transaction-level data for high-confidence leakage. Does not provide formal audit opinions or tax advice. Limited to diagnostic analysis based on provided records.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 16 days ago
Permissions
No special permissions declared or detected