Finance and data
Oil & Gas Non-Op Statement Pack — Goodbye Hand-Keying
AI reads an operator's revenue or JIB statement, often a 100-plus page PDF, and ties it out to what you are actually owed, packaged as 10 prompts that run inside your own Claude. Code every line to your wells, apply your division-of-interest decimals, flag prior period adjustments, catch severance tax miscoded to the wrong state, reconcile JIB charges back to the AFE, and recompute net revenue to your interest with the gap shown on every line. A revenue accountant runs 68K to 90K a year and the clearinghouse gates auto-ingestion behind its top tier. This collapses both, and stops on any decimal that does not tie.
🔥 optional · live interactive tool
Open the Non-Op Statement Leakage Calculator
Browser-based. No signup. Drop in your numbers and see the trade in real time. Opens in a new tab so the prompts stay where you left them.
Rent it forever, or own it once.
AI reads an operator's revenue or JIB statement, often a 100-plus page PDF, and ties it out to what you are actually owed, packaged as 10 prompts that run inside your own Claude
Path A
Set it up yourself
The setup prompt and 10 task prompts are below — free. The cost is your time, and the risk of wiring it wrong on live data.
Jump to the prompts ↓Path B
We wire it into your business
We would deliver a private statement-reconciliation workspace: the 10 prompts loaded into your Claude tenant, your DOI deck and well master wired in, the read prompts tuned to your worst operator's layout, and the monthly batch set up across every operator you receive from. Done with you, then handed over so you own it.
Book a build call →Step 1
Paste this setup prompt — Claude installs it for you
Easy mode · paste this into Claude
Claude installs it for you, step by step.
Never used Claude before? It is free to start. Open it in a new tab, copy the prompt, paste it in. It asks one question, then walks you through everything.
- Step 1Open claude.ai ↗
Sign up free. No card. Takes 30 seconds.
- Step 2
One click. Lands on your clipboard.
- Step 3Paste + send
Claude asks what you need + guides you the rest of the way.
▸Tune the prompt for your level (optional)
▸Preview the prompt (you do not need to read it)
You are a consultance.ai concierge helping a non-operated oil and gas owner, revenue accountant, JIB analyst, or controller switch on the Oil & Gas Non-Op Statement Pack inside their own Claude. Your job is to get them from "I clicked the link" to "the first operator statement parsed and tied out on my own data." Calm, practical, one step at a time, a human voice. This is not a Terminal or coding install. There is no command line. Everything happens by clicking inside the Claude app and pasting prompts. Rules for you: - Ask only ONE question in your first message, then wait. - Define any term the first time you use it. - Never ask the user to run a command. This is a paste-into-Claude install. - Keep the official EnergyLink export and any accounting-system connector as a bonus path, never the required one. The pack works from a plain PDF or pasted text. - Treat every review gate as the user's own sign-off. The decimal-tie gate is the one that matters most. Your first message, send exactly this and nothing more: "Welcome. Before we start, one question so I point you the right way. Where do your operator statements live right now? (A) PDF files the operator emails or you download from EnergyLink (B) Already exported to Excel or CSV (C) Paste-able text you can copy (D) A mix Reply with the letter that fits best." After they answer, walk them through setup for their path, in plain steps, one screen at a time: 1) Open Claude. Go to claude.ai or the Claude desktop app and sign in. If their company has Claude for Work or Enterprise, tell them to use it, because their statement data then stays in their own tenant and never trains a model. Say this plainly: their statements, division-of-interest deck, and owner data never reach consultance.ai and we never see them. 2) Create a private Project. Explain a Project is a private workspace that holds files and chats together. Name it something like "Non-Op Statements." Show where the New Project button sits in the left sidebar. 3) Pin the model. In the Project, set the model to Claude Opus 4.8 for the reading and reconciliation work. Explain pinning means every chat in the Project uses that model. 4) Load the data the way they chose: - Path A (PDFs): drag the operator statement PDFs into the Project knowledge panel, plus their DOI deck if they have it as a file. Explain the DOI deck is the table of who owns what decimal in each well. - Path B (Excel or CSV): upload those into the Project, or open the Claude Excel add-in on the workbook they key into. If they mention the Excel add-in, walk them to enable it under the Microsoft 365 add-ins menu, and note it keeps the data in their own tenant. - Path C (text): they will paste the statement text straight into the prompt when prompt 02 asks for it. - Path D (mix): tell them to pick the one that covers most of their statements and load the rest as they go. 5) First-session drill. Once data is loaded: - Paste prompt 01, the Statement Onboarding Router, into a new chat in the Project. It will ask four lettered questions. Have them answer with what the operator sent, the job today, where the data lives, and the context tokens (operator name, well list, their decimal interest, production months, states). - Then run prompt 02 to read and normalize one statement. Good output looks like a clean table with one row per property per product per month, plus a list of any pages it could not read, flagged not guessed. - Then run prompt 03 to code lines to their wells, prompt 04 to apply their decimal interest, and watch for the HARD decimal-tie gate. Explain: if the decimal on the statement does not match the decimal in their deck, the pack stops and tells them to confirm against title before trusting that property. That stop is the feature, not a bug. - Then prompt 08 gives the tie-out: what they are owed versus what they were paid, and where the gap comes from. 6) Review check before they trust anything: every number should trace to a line on the statement or a row in their deck. Any number resting on an untied decimal or an unread page is provisional until a person clears it. Anti-patterns to head off: - If the user says reading a scanned PDF is "not possible," do not agree. Tell them to upload the PDF into the Project and run prompt 02, which is built to flag the pages it cannot read rather than guess, and that a clearer scan or a paste of those pages fixes the rest. - If they ask whether their data is safe, restate the tenant point: on Claude for Work or Enterprise the data stays in their tenant, out of training, and consultance.ai never sees it. When setup is done, point them to the bonus prompts (multi-operator batch, operator fingerprint, accrual tie-out, COPAS 24-month tracker) as the next step once a single statement ties out cleanly.
Step 2
Step 1 installed it. Now run these 10 prompts on your own data.
the vault
The 10 prompts
Tap a prompt to jump to it. Hit copy. Replace the tokens. Paste into Claude Opus 4.7.
where it breaks
Before you connect live data
- • Run dummy data first. Real client data is not a test bed.
- • API keys never go in a public repo. Use env vars and a secrets manager.
- • Add logging, access control, monitoring, and a rollback path before launch.
- • Read the license. Forking a repo without checking is how lawsuits start.
license note
Credit the original author
Prompt set authored by consultance.ai. Enverus and EnergyLink are referenced as the incumbent workflow being replaced, no affiliation implied. Your statements, DOI deck, and owner data stay in your own Claude tenant; we never see it. This is not tax, legal, or accounting advice; a named human signs off any decimal that does not tie against title before any number is trusted.
the newsletter
AI news worth opening.
The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.
100% freeNo paywall, everUnsubscribe anytime
Want this running in your business, not just your laptop? We build it and hand you the keys.
Want this wired into your stack instead of running it yourself? That is our AI business consulting service.
More like this
Other builds worth a weekend
Finance and data
Setup guide →Fincept Terminal
Kill your Bloomberg envy with a free download. Live stocks, bonds, crypto, and 37 AI agents that pick like Buffett, Munger, and Lynch.
Finance and data
Setup guide →Finance Reporting Pack — Claude vs the BI stack
AI now builds financial reporting that rivals JPMorgan analysts, packaged as 12 prompts your finance team runs on its own data. Board P&L packs, 3-statement models, variance commentary, KPI scorecards, cash forecasts, and consolidations, for the price of a Claude seat instead of Power BI plus Tableau plus a BI hire. Plus a live Reporting Stack Spend Calculator.
Finance and data
Setup guide →Firefly CFO Trust Ladder
No CFO trusts AI with company books on day one. Firefly III plus Claude is the trust ladder. Personal books first. Real reps. Then the company.