quickbooks

What This Skill Does

The quickbooks skill enables OpenClaw agents to interface seamlessly with QuickBooks Online via managed OAuth authentication. By leveraging the Maton.ai gateway, this skill allows users to perform CRUD operations on core accounting entities, including customers, vendors, invoices, payments, and bills. It also provides the ability to execute complex financial reports directly through the API. The skill abstracts the complexity of manual OAuth token refreshing by utilizing the platform's connection management service, which handles the secure handshake between your agent and the Intuit infrastructure.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/byungkyu/quickbooks Once installed, ensure your MATON_API_KEY is set in your environment variables to allow for secure authentication with the gateway. Manage your connection statuses and OAuth authorization URLs by visiting the dashboard at https://ctrl.maton.ai.

Use Cases

• Automated Invoicing: Trigger invoice generation based on completed project milestones or inventory depletion.
• Vendor Management: Sync vendor databases from your CRM to QuickBooks automatically, eliminating double entry.
• Financial Reporting: Query real-time profit and loss or balance sheet data to provide immediate status updates to stakeholders.
• Payment Reconciliation: Automate the mapping of incoming payments to specific open invoices using query filters.

Example Prompts

1. "QuickBooks, fetch the last 10 unpaid invoices for customer 'Acme Corp' and summarize the total outstanding balance."
2. "Create a new customer in QuickBooks named 'Jane Doe' with email '[email protected]' and add her to the customer list."
3. "Run a Profit and Loss report for the current fiscal quarter and highlight the top three expense categories."

Tips & Limitations

• Authentication: Always ensure your realmId is correctly mapped via the connection manager, as this is required for all API calls to your specific company instance.
• Performance: For large datasets, use the MAXRESULTS parameter in your queries to optimize performance and prevent timeouts.
• Error Handling: If requests fail, verify that the connection status in ctrl.maton.ai is listed as 'ACTIVE'; expired tokens may require a re-authentication via the provided URL.
• Data Integrity: Always validate inputs before pushing new records, as this skill performs direct write operations to your accounting data.