quickbooks
Query QuickBooks Online — invoices, customers, payments, accounts, and reports via the REST API.
Source facts
- Repository
- ThinkfleetAI/thinkfleet-engine
- Last source activity
- February 1, 2026 at 16:21
- Detected SKILL.md language
- English
- Stars
- 0
- Forks
- 0
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- quickbooks
- description
- Query QuickBooks Online — invoices, customers, payments, accounts, and reports via the REST API.
- metadata
- {"thinkfleetbot":{"emoji":"📒","requires":{"bins":"[Truncated]","env":"[Truncated]"}}}
# QuickBooks Online
Query invoices, customers, payments, and reports via the QuickBooks API.
## Environment Variables
- `QUICKBOOKS_ACCESS_TOKEN` - OAuth 2.0 access token
- `QUICKBOOKS_REALM_ID` - Company ID (realm ID)
## Query customers
```bash
curl -s -H "Authorization: Bearer $QUICKBOOKS_ACCESS_TOKEN" \
-H "Accept: application/json" \
"https://quickbooks.api.intuit.com/v3/company/$QUICKBOOKS_REALM_ID/query?query=SELECT%20*%20FROM%20Customer%20MAXRESULTS%2010" | jq '.QueryResponse.Customer[] | {Id, DisplayName, PrimaryEmailAddr, Balance}'
```
## List invoices
```bash
curl -s -H "Authorization: Bearer $QUICKBOOKS_ACCESS_TOKEN" \
-H "Accept: application/json" \
"https://quickbooks.api.intuit.com/v3/company/$QUICKBOOKS_REALM_ID/query?query=SELECT%20*%20FROM%20Invoice%20MAXRESULTS%2010" | jq '.QueryResponse.Invoice[] | {Id, DocNumber, CustomerRef, TotalAmt, Balance, DueDate}'
```
## Create invoice
```bash
curl -s -X POST -H "Authorization: Bearer $QUICKBOOKS_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
"https://quickbooks.api.intuit.com/v3/company/$QUICKBOOKS_REALM_ID/invoice" \
-d '{"CustomerRef":{"value":"1"},"Line":[{"Amount":100,"DetailType":"SalesItemLineDetail","SalesItemLineDetail":{"ItemRef":{"value":"1"}}}]}' | jq '.Invoice | {Id, DocNumber, TotalAmt}'
```
## Get profit/loss report
```bash
curl -s -H "Authorization: Bearer $QUICKBOOKS_ACCESS_TOKEN" \
-H "Accept: application/json" \
"https://quickbooks.api.intuit.com/v3/company/$QUICKBOOKS_REALM_ID/reports/ProfitAndLoss?start_date=2024-01-01&end_date=2024-12-31" | jq '.Header, .Rows.Row[:5]'
```
## Notes
- Use sandbox URL `https://sandbox-quickbooks.api.intuit.com` for testing.
- Always confirm before creating invoices or payments.
View on GitHub