BillQuery qbXML example

Reads unpaid bills.

qbXML BillQueryRq, version 16.0
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <BillQueryRq iterator="Start">
      <MaxReturned>100</MaxReturned>
      <PaidStatus>NotPaidOnly</PaidStatus>
      <IncludeLineItems>true</IncludeLineItems>
    </BillQueryRq>
  </QBXMLMsgsRq>
</QBXML>
Open in the validator Check it against the qbXML 16.0 schema, edit it, and run it in your own QuickBooks.

Things to know

  • Page large results: iterator="Start" with MaxReturned on the first request, then iterator="Continue" with the iteratorID from the answer.
  • Line items are left out unless IncludeLineItems is true.

The same request with QuBe Sync's API

QuBe Sync takes these parameters, writes the qbXML for you and delivers QuickBooks' answer to your webhook as JSON.

GET /api/v2/connections/{connection_id}/bills
?include_line_items=true
&iterator=true
&max_returned=100
&paid_status=NotPaidOnly

Every field BillQuery takes is in Intuit's reference.

More requests

Vendors and purchases

All qbXML examples