Find the QuickBooks transactions still sitting in Uncategorized every week

Every Monday: how many QuickBooks transactions sit in Uncategorized Income and Expense, what they add up to, and the payees behind most of them.

Runs
Mondays at 9:00
Posts
Stat tile

From your apps to your board

How the skill works: your agent reads holding accounts from QuickBooks, mondays at 9:00, and gives you uncategorized transactions and the report in the chat.

Reads

  • QuickBooksHolding accounts
reads
Your agentClaude Code, Codex, Cursor or GeminiMondays at 9:00
posts

You get

  • Uncategorized transactionsA stat tile on your board, with its trend
  • The report in the chatEvery run, with or without Briefkin

What you get

  • Uncategorized transactions today, with new and cleared since last week.
  • The total per holding account.
  • Top payees: the five names behind most of the amount.
  • The oldest lines, with date and memo.
  • One line on what to clear first, for example "6 lines with no payee hold $2,410".

The card on the right is a sample. Yours shows your own numbers and updates in place every run.

What lands on your board

AcmeUncategorized transactions37-10% vs previous period, bettervs last report
Total$8,940
New this week12
Cleared16
An example with made-up numbers. Your agent posts your real ones.

What it does

Uncategorized Expense is where bank feed lines land when someone adds them in a hurry, and it quietly makes the P&L wrong. Bookkeepers and founders find out at month end, when forty lines need a decision and nobody remembers what the $1,500 transfer was.

Every Monday the agent reads the ledger for the Uncategorized accounts, counts and totals what is there, and groups it by payee, so a few rules or one conversation clears most of it. The count on the card should fall week by week; when it climbs, you see it the same Monday.

How it works

  1. 1Find the holding accounts

    Run select Id, Name, AccountType from Account where Name in ('Uncategorized Income', 'Uncategorized Expense', 'Uncategorized Asset') through GET /v3/company/{realmId}/query. Add any other holding account the books use, such as Ask My Accountant.

  2. 2Read their transactions

    Call the GeneralLedger report (GET /v3/company/{realmId}/reports/GeneralLedger) with account set to those IDs, start_date the first day of the fiscal year and end_date today. The TransactionList report has no account filter, which is why this reads the ledger.

  3. 3

    3Count, total and group

    Keep one row per transaction: date, type, payee, memo and amount. Count them, total the amounts per account, group by payee to find the five that explain most of the total, and flag anything older than 30 days.

  4. 4

    4Compare with last week

    Save the IDs to a JSON file so next Monday can tell what is new and what was cleared. Post the count as the headline with 8 weeks of history, the total and the oldest line in the glance, and the payee table when the card opens.

  5. Post it to the board

    With BRIEFKIN_TOKEN set, the agent sends the result as one card that updates in place every run. Without it, you get the report in the chat.

Install and run it

Pick your agent, where the data comes from and how to schedule it; the commands below follow.

Agent
Data
Schedule
  1. Install the skill

    One command. It puts the SKILL.md in ~/.claude/skills and in ~/.agents/skills, which Codex, Cursor, Gemini CLI, Copilot CLI and OpenCode read too.

    shellcurl -fsSL https://briefkin.dev/skills/quickbooks-uncategorized-transactions/install | sh
  2. Run it

    Ask Claude Code:

    promptRun the quickbooks-uncategorized-transactions skill

    Or paste the prompt instead of installing:

    promptUsing the QuickBooks Online Accounting API, find the IDs of the Uncategorized Income, Uncategorized Expense and Uncategorized Asset accounts, then run the GeneralLedger report filtered to those accounts from the start of the fiscal year to today. Count the transactions, total them per account, group them by payee and list the five payees with the largest totals, and flag anything older than 30 days. If you have last week's list, say how many are new and how many were cleared. End with the one group I should clear first. Change nothing in QuickBooks.
  3. Put it on a schedule

    Mondays at 9:00, from cron on any machine where Claude Code is signed in:

    crontab0 9 * * 1 claude -p "Run the quickbooks-uncategorized-transactions skill"

    Add it with crontab -e. A laptop asleep at that time runs it when it wakes if you use launchd or Task Scheduler instead; GitHub Actions works for the API route.

  4. Send it to your board

    Connect Briefkin once with curl -fsSL https://briefkin.dev/install | sh and every run lands on your board as a stat tile. How setup works

View the SKILL.mdRaw file
SKILL.md---
name: quickbooks-uncategorized-transactions
description: "Every Monday: how many QuickBooks transactions sit in Uncategorized Income and Expense, what they add up to, and the payees behind most of them. Use when the user asks for this, or when it runs on a schedule."
---

# QuickBooks uncategorized transactions

Every Monday: how many QuickBooks transactions sit in Uncategorized Income and Expense, what they add up to, and the payees behind most of them.

Uncategorized Expense is where bank feed lines land when someone adds them in a hurry, and it quietly makes the P&L wrong. Bookkeepers and founders find out at month end, when forty lines need a decision and nobody remembers what the $1,500 transfer was.

Every Monday the agent reads the ledger for the Uncategorized accounts, counts and totals what is there, and groups it by payee, so a few rules or one conversation clears most of it. The count on the card should fall week by week; when it climbs, you see it the same Monday.

## Two ways to get the data

Use the API or MCP route when you have an MCP server, a CLI or an API token for the app. Otherwise, if you can drive a browser the user is signed in to (Claude in Chrome, a Playwright or Chrome DevTools MCP server), use the browser route. Say which one you used.

## Route A: API or MCP server

### What you need

- Read access to QuickBooks Online through an app with the `com.intuit.quickbooks.accounting` scope, or a QuickBooks connector or MCP server your agent already uses, and the company's realm ID.
- The names of any other holding accounts your books use.

If something is missing, say what and stop; do not invent numbers.

### Steps

1. **Find the holding accounts** (QuickBooks): Run `select Id, Name, AccountType from Account where Name in ('Uncategorized Income', 'Uncategorized Expense', 'Uncategorized Asset')` through `GET /v3/company/{realmId}/query`. Add any other holding account the books use, such as Ask My Accountant.
2. **Read their transactions** (QuickBooks): Call the `GeneralLedger` report (`GET /v3/company/{realmId}/reports/GeneralLedger`) with `account` set to those IDs, `start_date` the first day of the fiscal year and `end_date` today. The TransactionList report has no account filter, which is why this reads the ledger.
3. **Count, total and group**: Keep one row per transaction: date, type, payee, memo and amount. Count them, total the amounts per account, group by payee to find the five that explain most of the total, and flag anything older than 30 days.
4. **Compare with last week**: Save the IDs to a JSON file so next Monday can tell what is new and what was cleared. Post the count as the headline with 8 weeks of history, the total and the oldest line in the glance, and the payee table when the card opens.

## Route B: the browser

### What you need

- Signed in to QuickBooks Online (or accountant access through QuickBooks Online Accountant) with a role that can run reports, such as Standard all access, Reports only, Admin, or an Accountant user.

If something is missing, say what and stop; do not invent numbers.

### Steps

Start at https://app.qbo.intuit.com/app/chartofaccounts. The user is signed in already; never type passwords or codes, and ask if a sign-in page appears.

1. **Find the holding accounts**: In QuickBooks Online open **Transactions > Chart of accounts** (under **Accounting** in some layouts) and type `Uncategorized` in the filter box. You should see Uncategorized Expense, Uncategorized Income and Uncategorized Asset; add any other holding account the books use, such as Ask My Accountant. If you keep several companies, pick the right one from the company menu first.
2. **Run the report for each account**: On each account row choose **Run report** (the QuickReport). Set **Report period** to `This fiscal year-to-date` and click **Run report**. Each line is one transaction with date, type, name (payee), memo and amount.
3. **Count, total and group**: Count the lines and read the total at the bottom of each report. Group the lines by name to find the five payees behind most of the amount, and flag any line older than 30 days. When a report runs past a few hundred lines, use **Export > Export to Excel** instead of scrolling.
4. **Compare with last Monday**: Keep the list of transaction dates and amounts from each run, so next week you can say how many lines are new and how many were cleared. Check **Transactions > Bank transactions > For review** separately: those lines are not in the books yet and never show in the account reports.

Note: The account QuickReport is the quickest UI view, but it pages long lists, so books with hundreds of uncategorized lines reads faster from the Excel export. Lines waiting in For review are not counted on either route.

## The report

- **Uncategorized transactions** today, with new and cleared since last week.
- **The total** per holding account.
- **Top payees**: the five names behind most of the amount.
- **The oldest lines**, with date and memo.
- One line on what to clear first, for example "6 lines with no payee hold $2,410".

## Post it to Briefkin

When `BRIEFKIN_TOKEN` is set, or `~/.config/briefkin/env` exists (the installer from https://briefkin.dev/docs writes it), also send the result to the user's Briefkin board as one card. Keep the `item_key` the same on every run so the card updates in place, use a new `event_id` per run, and put today's real numbers in place of the example ones. If the request fails, say so once and carry on.

```bash
[ -n "${BRIEFKIN_TOKEN:-}" ] || . ~/.config/briefkin/env
curl -sS -X POST "${BRIEFKIN_URL:-https://briefkin.dev}/v1/events" \
  -H "authorization: Bearer $BRIEFKIN_TOKEN" \
  -H "content-type: application/json" \
  -d @- <<'JSON'
{
  "v": 1,
  "event_id": "quickbooks-uncategorized-transactions/<date of this run, e.g. 2026-10-16>",
  "item_key": "quickbooks-uncategorized-transactions",
  "project": "Acme",
  "source": "QuickBooks uncategorized transactions skill",
  "kind": "metric",
  "title": "Uncategorized down to 37 transactions",
  "metric": {
    "label": "Uncategorized transactions",
    "value": 37,
    "better": "lower",
    "period_start": "<start of the period, ISO 8601>",
    "period_end": "<end of the period, ISO 8601>"
  },
  "glance": [
    {
      "type": "Grid",
      "props": {
        "columns": 3
      },
      "children": [
        {
          "type": "Stat",
          "props": {
            "label": "Total",
            "value": 8940,
            "prefix": "$"
          }
        },
        {
          "type": "Stat",
          "props": {
            "label": "New this week",
            "value": 12
          }
        },
        {
          "type": "Stat",
          "props": {
            "label": "Cleared",
            "value": 16,
            "tone": "ok"
          }
        }
      ]
    }
  ],
  "widget": [
    {
      "type": "Table",
      "props": {
        "columns": [
          "Account",
          "Transactions",
          "Amount"
        ],
        "align": [
          "left",
          "right",
          "right"
        ],
        "rows": [
          [
            "Uncategorized Expense",
            29,
            "$7,215"
          ],
          [
            "Uncategorized Income",
            8,
            "$1,725"
          ]
        ]
      }
    },
    {
      "type": "Table",
      "props": {
        "columns": [
          "Payee",
          "Lines",
          "Amount"
        ],
        "align": [
          "left",
          "right",
          "right"
        ],
        "rows": [
          [
            "No payee",
            6,
            "$2,410"
          ],
          [
            "Amazon",
            9,
            "$1,862"
          ],
          [
            "Square deposits",
            5,
            "$1,140"
          ],
          [
            "Uber",
            7,
            "$486"
          ],
          [
            "Shell",
            4,
            "$312"
          ]
        ]
      }
    },
    {
      "type": "Callout",
      "props": {
        "text": "The 6 lines with no payee hold $2,410, including a $1,500 transfer from 52 days ago that may be an owner deposit.",
        "tone": "warn"
      }
    }
  ],
  "size": "md"
}
JSON
```

Widgets come from the Briefkin catalog (https://briefkin.dev/v1/catalog). Without a token, just give the user the report.

Set `period_start` and `period_end` to the window the number covers: the tile names it from them ("Last 7 days", "Today", "This month"). For a count right now (open items, a balance), send `"period_label": ""` so no period shows; for another name, send it as `period_label` (at most 24 characters).

## Run it on a schedule

Suggested: Mondays at 9:00 (`0 9 * * 1`). From cron, with the agent signed in on that machine:

```bash
0 9 * * 1 claude -p "Run the quickbooks-uncategorized-transactions skill"
# Codex: codex exec, Gemini CLI: gemini -p, Copilot CLI: copilot -p, OpenCode: opencode run
```

Or use the agent's own scheduler (Claude Code routines, Codex automations, Claude or ChatGPT scheduled tasks): https://briefkin.dev/skills/quickbooks-uncategorized-transactions#schedule

Source: https://briefkin.dev/skills/quickbooks-uncategorized-transactions

What your agent needs

  • Read access to QuickBooks Online through an app with the com.intuit.quickbooks.accounting scope, or a QuickBooks connector or MCP server your agent already uses, and the company's realm ID.

  • The names of any other holding accounts your books use.

Connecting QuickBooks

  1. QuickBooks connector in Claude. Intuit and Anthropic partnered in 2026 to bring QuickBooks into Claude; where your plan offers the connector, connect it with your Intuit sign-in.
  2. QuickBooks Online MCP server, Intuit's open-source local server (source). It runs over stdio and reads QUICKBOOKS_CLIENT_ID, QUICKBOOKS_CLIENT_SECRET, QUICKBOOKS_REFRESH_TOKEN, QUICKBOOKS_REALM_ID and QUICKBOOKS_ENVIRONMENT.
  3. Accounting API with OAuth 2.0. Register an app in the Intuit Developer Portal, authorize the company once with the com.intuit.quickbooks.accounting scope, and store the same five values. Access tokens last an hour and the refresh token can change on each refresh, so the skill must save the newest one.

The accounting scope has no read-only version; with Intuit's MCP server, set QUICKBOOKS_DISABLE_WRITE, QUICKBOOKS_DISABLE_UPDATE and QUICKBOOKS_DISABLE_DELETE to true so the agent gets only read, search and report tools.

Questions

Why doesn't it count what is waiting in the bank feed?

Lines still in the For review tab are not in the books yet, and the Accounting API does not return them. This skill counts what was already added to the Uncategorized accounts; check For review in Banking separately.

Can it categorize the transactions?

It only reads. It can suggest an account for each payee from how you categorized that payee before, and you make the change in QuickBooks, or turn the suggestion into a bank rule so the next lines land in the right place.

Do I need Briefkin to use the QuickBooks uncategorized transactions skill?

No. The skill runs with your own agent and gives you the report in the chat. With a Briefkin token set, each run also posts it to your board as a stat tile, so you can glance at it instead of asking again.

Which agents can run it?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot CLI, OpenCode, Windsurf and Amp all read SKILL.md files. The install command puts it in ~/.claude/skills and ~/.agents/skills, where they look. ChatGPT, the Claude app and Grok take the prompt instead. Pick your agent under "Install and run it" and the commands change to match.

Can it work without an API or MCP server, from my browser?

Yes. Switch the data source to "Your browser" and the steps change to the QuickBooks pages themselves: the agent opens app.qbo.intuit.com/app/chartofaccounts in a browser you are signed in to and reads the numbers off the page. Claude Code, Codex, Cursor, Claude app and ChatGPT can drive a browser out of the box; Gemini CLI, Copilot CLI and OpenCode need a Playwright or Chrome DevTools MCP server first. It is slower than the API and needs you signed in, so it suits a report you run by hand or from a scheduler on your own computer.

Watch uncategorized transactions on your board, run after run

Skills are free to use with any agent. Briefkin is where their results land: one board for every report, number and question your agents send, with a ping when something needs you.

Free during the open beta. No card.