QuickBooks Automation

Automate Quickbooks operations using Rube MCP and Composio toolkit.

Install

npx promptshop add QuickBooks

Details

Automation Auto-detects your installed agents and installs the skill to each one.

What This Skill Does

This skill automates Quick Books Online operations such as creating invoices, managing customers, and querying accounts. It enables users to streamline financial reporting and customer management tasks. This is useful for businesses looking to automate their accounting processes and integrate Quick Books with other systems.

When to Use

Create new invoices automatically Manage customer records in Quick BooksQuery account details for reporting List invoices for financial analysis Automate customer creation Retrieve customer information

Key Features

Automates Quick Books Online operations.
Creates invoices with line items.
Manages customer records.
Queries accounts for financial data.
Requires Rube MCP server connection.
Uses QUICKBOOKS_CREATE_INVOICE tool.

Manual Installation

Setup

This skill requires the Rube MCP server connected at https://rube.app/mcp.

Before executing any tools, ensure an active connection exists for the quickbooks toolkit. If no connection is active, initiate one via RUBE_MANAGE_CONNECTIONS.

Core Workflows

1. Create an Invoice

Create a new invoice for a customer with line items.

Tool: QUICKBOOKS_CREATE_INVOICE

Key Parameters: customer_id (required) -- ID of the customer (Customer Ref.value) lines (required) -- Array of line item objects. Each must include:

Detail Type -- e.g., "Sales ItemLine Detail"
Amount -- Line item total
Sales ItemLine Detail -- Object with Item Ref containing value (item ID) minorversion -- Optional API version parameter

Example: Tool: QUICKBOOKS_CREATE_INVOICE Arguments: customer_id: "21" lines: [ { "Detail Type": "Sales ItemLine Detail", "Amount": 150.00, "Sales ItemLine Detail": { "Item Ref": {"value": "1", "name": "Services"} } } ]

Prerequisites: Resolve the customer ID using QUICKBOOKS_READ_CUSTOMER or create one with QUICKBOOKS_CREATE_CUSTOMER. Resolve item/account IDs using QUICKBOOKS_QUERY_ACCOUNT.

2. Manage Customers

Create and read customer records.

Tools: QUICKBOOKS_CREATE_CUSTOMER -- Create a new customer QUICKBOOKS_READ_CUSTOMER -- Read a customer by ID

Key Parameters for QUICKBOOKS_CREATE_CUSTOMER: display_name -- Display name (must be unique across customers, vendors, employees; max 500 chars) given_name -- First name (max 100 chars) family_name -- Last name (max 100 chars) middle_name -- Middle name (max 100 chars) title -- Title, e.g., "Mr.", "Dr." (max 16 chars) suffix -- Name suffix, e.g., "Jr." (max 16 chars)

At least one of display_name, title, given_name, middle_name, family_name, or suffix is required.

Key Parameters for QUICKBOOKS_READ_CUSTOMER: customer_id (required) -- ID of the customer to read

Example: Tool: QUICKBOOKS_CREATE_CUSTOMER Arguments: display_name: "Acme Corporation" given_name: "John" family_name: "Doe"

3. Query and Read Accounts

Retrieve account information for use in invoice line items and financial reporting.

Tools: QUICKBOOKS_QUERY_ACCOUNT -- Execute a query against accounts QUICKBOOKS_READ_ACCOUNT -- Read a specific account by ID

Key Parameters for QUICKBOOKS_QUERY_ACCOUNT: query (required) -- SQL-like query string, e.g., "SELECT * FROM Account WHERE Account Type = 'Income'"

Example: Tool: QUICKBOOKS_QUERY_ACCOUNT Arguments: query: "SELECT * FROM Account WHERE Account Type = 'Income' MAXRESULTS 10"

4. List and Filter Invoices

Retrieve invoices with optional pagination and filtering.

Tool: QUICKBOOKS_LIST_INVOICES

Steps: Call QUICKBOOKS_LIST_INVOICES with pagination parameters Use start_position and max_results to page through results Filter by specific criteria as needed

Recommended Execution Plan

Resolve the customer using QUICKBOOKS_READ_CUSTOMER (if you have a customer ID) or create one with QUICKBOOKS_CREATE_CUSTOMER Resolve item/revenue accounts using QUICKBOOKS_QUERY_ACCOUNT and QUICKBOOKS_READ_ACCOUNT to get account or item IDs for invoice line items Create the invoice using QUICKBOOKS_CREATE_INVOICE with the resolved customer_id and well-formed line items Verify creation using QUICKBOOKS_LIST_INVOICES to locate the new invoice by ID or Doc Number

Known Pitfalls

Pitfall	Detail
Invalid references	QUICKBOOKS_CREATE_INVOICE fails if customer_id or Item Ref.value point to non-existent or inactive records. Always resolve IDs first.
Line item validation	Incorrect Detail Type or missing Sales ItemLine Detail fields cause schema/validation errors during invoice creation.
Pagination	QUICKBOOKS_LIST_INVOICES uses start_position and max_results. Incomplete pagination settings can miss invoices in larger books.
Sync tokens	Any later edits require the latest Sync Token from a fresh invoice read. Stale sync tokens cause update rejections.
Rate limits	Quick Books enforces per-minute and daily API caps. High-volume runs should include backoff to avoid throttling errors.
Display Name uniqueness	Customer display_name must be unique across all Customer, Vendor, and Employee objects. Duplicates cause creation failures.

Quick Reference

Tool Slug	Description
QUICKBOOKS_CREATE_INVOICE	Create a new invoice with line items
QUICKBOOKS_READ_CUSTOMER	Read a customer record by ID
QUICKBOOKS_CREATE_CUSTOMER	Create a new customer record
QUICKBOOKS_QUERY_ACCOUNT	Query accounts with SQL-like syntax
QUICKBOOKS_READ_ACCOUNT	Read a specific account by ID
QUICKBOOKS_LIST_INVOICES	List invoices with pagination