quickbooksinventoryvarianceshrinkagemonthly close

QBO Inventory Reconciliation

Takes a physical inventory count you paste or upload and checks it against QuickBooks Online's own inventory asset records for the same period. You get a variance report by item, not just one aggregate number, so shrinkage and damage show up before close instead of turning into an unexplained variance later. If your business doesn't track inventory in QuickBooks at all, it says so plainly and skips the check instead of reporting a false variance. 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 the inventory asset/valuation report this skill reads from, per item, as of a stated date. 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 Inventory Reconciliation

Check what you counted against what QuickBooks thinks is on the shelf. This skill takes a physical inventory count you paste or upload, pulls QuickBooks Online’s own inventory asset records for the same period, and shows you exactly which items are off — item by item, not just one number.

If your business doesn’t track inventory in QuickBooks at all, it says so plainly and skips the check instead of reporting a false variance. It never writes anything back to QuickBooks — run it with the connection’s write tools turned off.

View full SKILL.md on GitHub