quickbooksaccounts receivableAR agingrevenue reconciliationmonthly close

QBO Revenue & AR Reconciliation

Pulls your sales receipts, invoices, and payments for a period straight from QuickBooks Online, then checks what you invoiced against what's actually been paid. You get a clean AR aging report and one reconciled income number for the period, cross-checked against QuickBooks' own reports. Anything it can't match to a customer gets flagged for you to look at, not quietly recorded. It only reads your QuickBooks data — it never changes anything — and you should run it with the connection's write tools turned off.

FinanceMCPBy uristocrat
Install

MCP-powered — requires setup

This skill uses external tools via the Model Context Protocol. You'll need to configure the following MCPs before installing.

Required MCPs

QuickBooks Online MCP

Community MCP server for QuickBooks Online. Provides report tools (Aged Receivables, Customer Balance, Customer Sales) and entity-search tools (Invoices, Payments, Sales Receipts, Credit Memos) this skill reads from. Run it with QUICKBOOKS_DISABLE_WRITE, QUICKBOOKS_DISABLE_UPDATE, and QUICKBOOKS_DISABLE_DELETE set, since this skill writes nothing to QBO.

Setup steps

  1. Set up each required MCP using the configs above
  2. Download the skill file below
  3. Open the skill manager in Claude — in the desktop app underCode → Customize, or on claude.ai underCustomize → Skills
  4. Click Create a new skill (use + on claude.ai) and upload the downloaded file
  5. Start a new session — your MCPs and skill will both be active
  6. Use a trigger phrase to activate
Download skill file

What this skill does

This is an overview of the skill from the site, not the skill's real instructions. The full SKILL.md Claude reads when this skill is active lives on GitHub at the pinned source below.

QBO Revenue & AR Reconciliation

See what you earned and who still owes you. This skill pulls your sales receipts, invoices, and payments for the period from QuickBooks Online, matches what you invoiced against what’s been paid, and gives you an AR aging report plus one reconciled income number for the period.

If it can’t match an invoice or payment to a customer, it flags it for you instead of quietly recording it. It never writes anything back to QuickBooks — run it with the connection’s write tools turned off.

View full SKILL.md on GitHub