Hire an AI utility restricted cash checker

Everything it can hand back

Your task sets the actual outputs. The specialist picks the methods that cover them.

• A billing and collections reconciliation, with closing receivables kept outside cash
• Restricted cash and total bank cash, rolled forward separately
• Usable cash after collateral and pending debits
• A tie of general cash to the prior fund bridge
• Every MISSING input and any check that could not run

How it does the job well

• Reconcile to source documents, such as bank statements, ledgers and invoices, before reporting.
• Show the calculation, inputs and period for every figure.
• Label actuals, estimates and forecasts clearly.
• Send tax, legal and regulatory questions to a qualified professional.

Mistakes it avoids

• Mixing cash and accrual figures, or different periods, in one comparison.
• Rounding or formula errors that do not tie back to totals.
• Giving personal investment advice.

What a good result looks like

An example, not your task: The program bank balance looks healthy and you need to know how much of it is really free.

• outputs/step-1-water-utility-collections-reconciler.md. Billed, collected and closing receivables, with only collected cash passed on.
• outputs/step-2-grant-restrictions-cash-reconciler.md. Restricted and total bank cash, each rolled forward on its own.
• outputs/step-3-restricted-cash-availability-checker.md. Usable cash after collateral and pending debits, tied to the prior bridge.
• HAND-BACK SUMMARY. Files saved, sources used, MISSING lines and checks missed.

How the work is checked

• Consumer receipts and grant receipts remain separate source streams; restricted releases require evidence and general cash is not double-counted.
• Trace each material input to its source, date, currency, scale, sign and reporting period. Retain unresolved MISSING: lines.
• If a workbook is built, keep hardcoded inputs separate from live formulas and reopen the saved file.
• Distinguish a real zero, unavailable evidence and an inapplicable ratio. Never force a financial statement tie with an unexplained plug.
• States which checks passed, failed or could not run, and names missing inputs.

These checks have not been run against a model yet. Your AI uses them to check its own work.

Capabilities

• Water utility collections reconciler. Reconciles water billings, current and arrears receipts and receivables for the period. Passes only collected cash to the bank map, and keeps billing balances outside cash. Check before moving on, billed less collected equals closing receivables.
• Grant restrictions cash reconciler. Maps the grant-funded program. Classes customer receipts only by the restriction rules you supply. Rolls restricted and total bank cash separately, and never calls customer payments grant revenue. Check before moving on, restricted cash is not above the bank balance.
• Restricted cash availability checker. Uses the reconciled bank and restriction balances. Takes off any extra collateral or pending debits that do not overlap. Ties final general cash to the prior fund bridge before saying what is available. Check before you rely on it, no cash is counted twice.

How the role works

1. Checks your task, context and available tools.
2. Picks the methods needed and prepares a work plan.
3. Carries out supported tasks, with each method's limits and review gates.
4. Checks the real deliverables and corrects supported faults.
5. Hands back files, evidence and unresolved gaps.

Your specialist's working setup

Download the base specialist without a task form or account. README.md and SETUP.md explain how to use the folder. SOUL.md defines its scope. INTAKE.md asks missing questions inside your AI. PLAYBOOK.md, SKILLS.md, BEST_PRACTICES.md, CHECKS.md and HANDOFF.md guide the work and its checked deliverables.

Complete associated skills, supporting files and licences are included. Choose only the methods needed for the actual task. Keep context, working files and accepted feedback in your AI project.

Use this specialist through MCP or the API

Call prepare_specialist with role_id reconcile-restricted-utility-program-cash only. No task is required to load it. Your AI asks what job you need done, what you want back and which relevant context it can use.

For task-led hiring, call find_specialist, explain the suggested specialists and let the user accept or change the team.

Complete ZIP: Download base specialist. API: GET /api/v1/specialists/reconcile-restricted-utility-program-cash/pack. The host AI supplies its own model, tools and execution; a pack does not connect accounts or run a task.

Inputs and helpful context

The specialist starts from the task brief. Only active methods require their inputs.

For the primary method, when used

• Utility billing and collection records for the period, with receivables (from the billing system)
• The program bank cash balance (from the bank statement)
• The grant restrictions and approved eligible program payments (from the grant agreement and approvals)
• Which receipts are restricted and which are not, with the allocation rules (from the grant terms)
• The period dates, currency and scale

Helpful context (optional)

• The grant agreement wording on restricted use.
• The bank statement for the same dates.
• Last period's fund bridge.

Tools and access

• A spreadsheet engine and file-capable AI: Builds a workbook with inputs, formulas and checks you can click into. In plain chat it returns the same tables as text and says no workbook was made.
• A spreadsheet engine and file-capable AI: Create, recalculate, render and reopen the requested native workbook.
• Node.js 20 or later: Run the bundled dependency-free reference calculation against explicit numeric inputs. Without it, the AI does the sums in chat.
• Claude, ChatGPT or Gemini: Any of them can do these sums in a chat and show each step.
• An AI that can make spreadsheet files: It can build the workbook, recalculate it and check that it reopens.
• Node.js 20 or later (optional): Runs the small script that comes with the skill, for a second check of the numbers.

Functions and deliverables

• Utility restricted cash checker: Share utility receipts, grant rules and bank records. Get separate collection and fund schedules, restricted balances and usable cash checks.
  • A billing and collections reconciliation, with closing receivables kept outside cash
  • Restricted cash and total bank cash, rolled forward separately
  • Usable cash after collateral and pending debits
  • A tie of general cash to the prior fund bridge
  • Every MISSING input and any check that could not run
• Water utility billing and cash checker: Share water volumes, bills and receipts. Check unpaid balances and separate current collections from old arrears.
  • New billings: billed cubic meters times your rate
  • Unbilled cubic meters: produced less billed
  • Total receipts, split into current bills and old arrears
  • Closing receivables, with a check that the roll-forward adds up
  • A list of anything missing and what it blocked
• Restricted grant cash tracker: Share grant cash movements and approved uses. Separate restricted money from cash available for general spending, and flag funding gaps.
  • Closing restricted cash
  • Closing total bank cash
  • Free cash: closing bank cash less closing restricted cash
  • A check that restricted cash does not exceed bank cash, and a flag if it does
  • A list of anything missing, and which results it blocked
• Spendable cash balance checker: Share bank balances and cash restrictions. Check what is available and any gap against your minimum balance.
  • Available cash: gross cash less restricted cash, collateral blocks and pending debits
  • Headroom: available cash less your minimum cash
  • Shortfall: how far below the minimum you are, or zero
  • A list of any block that is larger than the balance it comes from
  • A list of missing facts and checks that could not run
  • A small workbook with the same sums, if your AI can make files
• me.md builder: Answer a few questions, or let your AI use what it remembers. Get one private file that tells any AI who you are.
  • One me.md file with up to ten dated sections
  • A list of facts taken from memory, for you to check
  • A short note of what it removed for privacy
  • The two next steps, to save it and set it up

Tasks you can use it for

• The program bank balance looks healthy and you need to know how much of it is really free.
• A grant report asks you to show restricted and unrestricted cash separately.
• Billings are up but collections are slow, and you need the cash view, not the billing view.
• A pending debit or collateral hold may block part of the balance.

Limits to check before starting

• You only need the water billing and collections view. Use the Water utility billing and cash checker on its own.
• You only need to split restricted from free cash. Use the Restricted grant cash tracker on its own.
• You need to prove grant spending followed the agreement. Use the Grant spending and evidence report preparer workflow.
• You need a dated cash ladder of future payments. Use the Treasury liquidity and payment timing checker workflow.

Best way to use this role

Give it one clear outcome, the actual files and a definition of done. Keep the work in one AI project so it can reuse checked context and earlier files.

• Download the workflow pack and give it to an AI that can read files, such as Claude, ChatGPT or Gemini. For a workbook, use one that can build spreadsheets. The pack holds the three step skills.
• Gather the bank statement and the grant restriction rules first. Add the prior fund bridge if you have it. Without it, the usable cash figure comes back marked as not tied.
• Attach the billing records, bank statement and grant terms. Paste the restriction and allocation rules. Say the period, currency and scale once.
• After step 1, check billed, collected and receivable amounts. Only collected cash should move on.
• After step 2, check restricted and total bank cash both close to the bank statement.
• After step 3, check the usable cash figure against any holds. Fill every MISSING line before anyone spends against it.

Read it as data

Read the complete role setup as JSON. Connect your AI to the AI Blocks MCP library and read aiblocks://roles/reconcile-restricted-utility-program-cash for its role instructions and pinned sources.

This is a prepared AI role. No task has run. Your AI carries out authorized work using its available tools and reports the actual deliverables and checks.