Skip to main content
Glama
QuickBooks Desktop MCP

QuickBooks Desktop MCP

by Compolaga

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
QBBRIDGE_LOG_DIRNoDirectory for logging all qbXML requests and responses. Defaults to <data>\log.<data>\log
QBBRIDGE_APP_NAMENoName shown in the QuickBooks access permission dialog.QBBridge
QBBRIDGE_DATA_DIRNoDirectory where the server stores its files (runs, logs, confirm.key, used_codes).%LOCALAPPDATA%\QBBridge
QBBRIDGE_RUNS_DIRNoDirectory for the undo-logs (runs). Defaults to <data>\runs.<data>\runs
QBBRIDGE_QBXML_MAXNoMaximum qbXML version to use; the server picks the highest version supported by QuickBooks that is ≤ this value.13.0

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
qb_company_infoA

Returns the company file path QuickBooks Desktop currently has open. Call this first, and before any write, to confirm you're pointed at the right client's file.

qb_list_accountsA

Lists the chart of accounts: name, type, number, active, currency, balance, total_balance. account_type optionally filters (e.g. "Bank", "Income", "Expense", "OtherCurrentAsset"). Use this to confirm an account name exists exactly before posting to it.

balance vs total_balance: for a parent account with subaccounts, "balance" is that account's OWN activity only; "total_balance" includes every subaccount. Balances are in the account's own currency.

qb_account_balanceB

Balance of one account (e.g. a bank account or the suspense account), in that account's currency.

qb_list_vendorsA

Lists vendors (name, ListID). Use this to confirm a payee exists exactly before posting a transaction against it.

qb_vendor_historyA

Returns which account(s) this vendor's past transactions were booked to, with counts -- e.g. {"Food Purchases": 175}. Use this before guessing an account for a new transaction from a known vendor: prefer whatever this vendor has actually been booked to before, not a plausible-sounding guess.

qb_query_transactionsB

Queries transactions of one type (Check, Deposit, CreditCardCharge, CreditCardCredit, Transfer, JournalEntry). date_from/date_to as YYYY-MM-DD. Returns normalized records: date, amount, payee, account (first line), memo, txn_id, edit_sequence.

qb_check_duplicateA

Checks whether a transaction with this date+amount already exists somewhere in the company file, within a tolerance window (banks don't always post the two sides of a transfer/payment on the exact same date). Use this before posting anything, to avoid double-entry -- especially for payments/transfers, where the same real-world event can get recorded from either side of a linked account. By default it looks at Check, Deposit, CreditCardCharge, CreditCardCredit, Transfer, Invoice, ReceivePayment and JournalEntry.

qb_add_transactionA

Adds a transaction (Check, Deposit, CreditCardCharge, or CreditCardCredit) in the home currency. lines: [{"account": str, "amount": number or string, "memo": str|None}, ...]. For foreign-currency accounts or exchange rates use qb_write_check / qb_deposit instead. A Deposit has no header payee or refnum in qbXML: payee is put on every line (as EntityRef) and a refnum is refused.

Two steps: without confirm_code this only returns a preview and a confirm code; with the code it books and logs an undo entry (qb_revert_run).

qb_add_vendorA

Creates a vendor. Two steps (preview + confirm_code). Refuses if a vendor with this exact name exists; check qb_list_vendors first for near-duplicates in spelling/casing.

qb_statusA

Call this first. Reports whether QuickBooks answers, which company file is open, product/edition/country, the qbXML versions QuickBooks supports and the one this server uses (highest <= QBBRIDGE_QBXML_MAX, default 13.0 for QuickBooks 2016), and whether multicurrency is on plus the home currency.

qb_list_currenciesB

QuickBooks' currency list (name, ISO code, active, stored exchange rate in home currency per unit). Only meaningful with multicurrency on.

qb_search_customersA

Finds customers whose name, company name, contact or e-mail contains query (case-insensitive; empty = all). Returns currency and balance.

qb_search_itemsA

Searches the item list: matches query (case-insensitive) against item name, full name, manufacturer part number (art. code) and description. Returns type, price, income account, tax code.

qb_list_open_invoicesA

Unpaid invoices (balance > 0), for one customer (exact full name) or all. Returns ref number, date, customer, currency, total and balance.

qb_find_invoiceA

Finds invoices by ref number (exact), and/or amount (matches total = subtotal + tax, or balance remaining), date range (YYYY-MM-DD) and customer. Give at least one criterion.

qb_find_transactionsA

All transactions in a date range (YYYY-MM-DD), optionally for one account or entity and of given types (e.g. ["Invoice", "ReceivePayment", "Deposit", "Check", "JournalEntry"]). One row per transaction: type, date, ref, entity, account, amount, currency. Use before booking a bank line to avoid booking it twice.

qb_create_customerB

Creates a customer. bill_address: {"lines": [..max 5], "city", "state", "postal_code", "country"}, or the form qb_search_customers returns ({"Addr1".."Addr5", "City", "State", "PostalCode", "Country"}); unknown keys are refused. currency: ISO code or QuickBooks name (multicurrency only; cannot be changed later once used). Refuses if a customer with this exact name exists. Two steps (preview + confirm_code).

qb_create_itemA

Creates a non-inventory item (max 31 characters, no ':'). Use only after the user explicitly asked for a NEW item; search first with qb_search_items. manufacturer_part_number can hold an article code so qb_search_items finds it. Two steps (preview + confirm_code).

qb_create_invoiceA

Creates an invoice.

lines, in invoice order: item line {"item": exact item full name, "description", "quantity", "rate"} (or "amount" instead of quantity x rate), optional "sales_tax_code" per line; text-only line (e.g. a product-group heading) {"description": "..."} without item. sales_tax_code: default SalesTaxCodeRef for item lines (e.g. "Non"). currency: optional check -- refused if the customer's currency differs (the invoice currency is always the customer's currency). exchange_rate: home-currency units per 1 unit of invoice currency. expected_total: the invoice SUBTOTAL, i.e. the sum of the lines excluding sales tax. Refused before booking if the lines add up to something else; checked again after booking against QuickBooks' own Subtotal, and an invoice that differs is removed again immediately. Without expected_total the same check is made against the subtotal of the preview. Sales tax is computed by QuickBooks on top and returned as sales_tax_total / total. Refuses a ref_number that already exists, unknown customer or items. Two steps (preview + confirm_code).

qb_receive_paymentA

Records a customer payment and applies it to open invoices (Customers > Receive Payments). amount is in the customer's currency. apply_to: [{"invoice_ref": "INV-001", "amount": ...} or {"txn_id": ..., "amount"}]; the same invoice listed twice is applied once with the summed amount. deposit_to_account: bank account or Undeposited Funds (QuickBooks requires an account in the customer's currency or the home currency). exchange_rate: home-currency units per 1 unit of the customer's currency. Refuses invoices of another customer, already paid, or over-applied. Two steps (preview + confirm_code).

qb_depositA

Money into a bank account (Make Deposits). lines: [{"account": source account (e.g. a suspense account), "amount", "memo", "entity"}] or [{"payment_txn_id": a received payment sitting in Undeposited Funds}] (no "amount": it is the payment's own amount, looked up in QuickBooks and counted in the total and expected_total). Amounts are in the bank account's currency; exchange_rate = home-currency units per 1 unit of that currency. Two steps (preview + confirm_code).

qb_write_checkA

Money out of a bank account (Write Checks), e.g. bank charges, fixed monthly payments or an unknown debit to a suspense account. lines: [{"account": expense/other account, "amount", "memo", "customer"}]. Amounts in the bank account's currency; exchange_rate = home-currency units per 1 unit of that currency. Two steps (preview + confirm_code).

qb_journal_entryA

General journal entry. lines: [{"kind": "debit"|"credit", "account", "amount", "memo", "entity"}]; debits must equal credits. With multicurrency, an entry may use one foreign currency (currency + exchange_rate = home-currency units per 1 unit) next to home-currency accounts; amounts are then in that foreign currency. ref_number max 11 characters. Two steps (preview + confirm_code).

qb_revert_runA

Undoes every booking of one of THIS server's own runs (run_id from a write tool's result or qb_list_runs), newest first. Only own bookings can be undone: the run log is looked up by id in this server's own run directory, records only what the run created, and revert deletes exactly those objects. Refused if QuickBooks has another company file open than the one the run was booked in, or if the run log is damaged. Two steps: without confirm_code it shows what would be undone. After a partial failure, calling it again skips the steps already undone; a booking that no longer exists in QuickBooks (removed by hand) counts as undone. A (partly) reverted run takes no new bookings.

qb_list_runsA

Lists this server's recent runs (newest first) with what each booked and in which company file, so you can find a run to inspect or revert. Fully reverted runs are not listed; partly reverted ones are marked, and a damaged run log is reported instead of its bookings.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

B3.4/5.0

Scored across 25 tools

Disambiguation3/5

Several tools overlap in purpose: qb_status and qb_company_info both report the open company file; qb_query_transactions, qb_find_transactions, qb_find_invoice and qb_list_open_invoices are four different ways to retrieve transactions; and qb_add_transaction partially duplicates qb_write_check/qb_deposit/qb_journal_entry. Descriptions do clarify the boundaries (home-currency-only add_transaction, single-type query vs. cross-type date-range find, check_duplicate vs. find_transactions), but an agent still has real choices to make between similarly purposed tools.

Naming Consistency4/5

The qb_ prefix and snake_case are used uniformly across all 25 tools, giving a predictable surface. The only inconsistency is verb choice: creation uses both 'add' (qb_add_transaction, qb_add_vendor) and 'create' (qb_create_customer, qb_create_invoice, qb_create_item), and retrieval mixes 'list', 'search', 'find', and 'query'.

Tool Count3/5

25 tools is at the heavy end, though QuickBooks Desktop is a genuinely broad domain (accounts, customers, vendors, items, currencies, multiple transaction types, invoices, payments, run revert). A handful do not clearly earn their place given redundancy: qb_company_info vs qb_status, and qb_add_transaction vs the four specialized write tools.

Completeness3/5

The write side covers invoices, payments, deposits, checks, journal entries and a strong revert/run-log safety net, and the read side covers accounts, vendors, customers, items, currencies and transactions. However, there is no update or delete for customers, vendors, items or booked transactions, and the entire Accounts Payable side (bills, bill payments, vendor credits) is absent despite vendor tools existing.

Maintenance

ActivityMaintained
ResponsivenessOutdated data