Back to QuickBooks Bills
Connect Knoon AI with QuickBooks Bills (QuickBooks) to automate AI workflows.
Run a QuickBooks Online SQL-like query for bills (defaults to SELECT * FROM Bill).
quickBooksBillQuery
BETA
Internal
Permissions
Optional permissions
There are no items to display.
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| query | mustache | Optional. Full QBO query to run. If omitted, the backend uses the default query for this entity. | No |
| minorVersion | mustache | Optional QuickBooks minor version (defaults to 75). | No |
Returns
| Name | Type | Description |
|---|---|---|
| id | string | Bill ID. |
| docNumber | string | Bill document number. |
| vendorId | string | Vendor ID. |
| txnDate | string | Transaction date. |
| dueDate | string | Due date. |
| totalAmount | number | Total amount. |
| balance | number | Open balance. |
| currencyCode | string | Currency code. |
| syncToken | string | Sync token for updates. |
| privateNote | string | Private note. |
QuickBooks Bookkeeping (With VAT/GST) & OneDrive Upload
Automate QuickBooks bookkeeping with bill processing, duplicate checks, unpaid bill payments, and OneDrive receipt filing.
6 min
Record QuickBooks Bills & Attachment (Without GST/VAT)
Records bills without tax and attaches the original file to the QuickBooks bill.
4 min