LedgerWire

Bill · Query

simulated in sandbox

BillQuery

Bills record what you owe a vendor. They post to Accounts Payable and can carry expense lines (an account) and item lines (inventory you bought).

qbXML request

BillQueryRq
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <BillQueryRq requestID="1">
      <MaxReturned>10</MaxReturned>
      <ModifiedDateRangeFilter>
        <FromModifiedDate>2026-10-01T00:00:00</FromModifiedDate>
      </ModifiedDateRangeFilter>
      <IncludeLineItems>true</IncludeLineItems>
    </BillQueryRq>
  </QBXMLMsgsRq>
</QBXML>

JSON equivalent

GET /v1/bills?limit=10&updatedAfter=2026-10-01
GET /v1/bills?limit=10&updatedAfter=2026-10-01
curl
curl "https://ledgerwire.vibiz.app/v1/bills?limit=10&updatedAfter=2026-10-01" \
  -H "Authorization: Bearer $LEDGERWIRE_KEY"
Sends this exact qbXML to the shared demo sandbox (simulated sample data).

qbXML response (from the sandbox seed data)

BillQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <BillQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
      <BillRet>
        <TxnID>34A-1793835062</TxnID>
        <TimeCreated>2026-11-04T23:31:02+00:00</TimeCreated>
        <TimeModified>2026-11-04T23:31:02+00:00</TimeModified>
        <EditSequence>1793835062</EditSequence>
        <TxnNumber>7000</TxnNumber>
        <VendorRef>
          <ListID>80000088-1794871862</ListID>
          <FullName>Northside Properties LLC</FullName>
        </VendorRef>
        <APAccountRef>
          <ListID>80000007-1760311862</ListID>
          <FullName>Accounts Payable</FullName>
        </APAccountRef>
        <TxnDate>2026-11-04</TxnDate>
        <DueDate>2026-12-04</DueDate>
        <RefNumber>B-7001</RefNumber>
        <TermsRef>
          <FullName>Net 30</FullName>
        </TermsRef>
        <AmountDue>1433.52</AmountDue>
        <OpenAmount>1433.52</OpenAmount>
        <IsPaid>false</IsPaid>
        <ItemLineRet>
          <TxnLineID>34B-1793835062</TxnLineID>
          <ItemRef>
            <ListID>8000003D-1794871862</ListID>
            <FullName>Faucet Kitchen</FullName>
          </ItemRef>
          <Desc>Pull-down kitchen faucet</Desc>
          <Quantity>18</Quantity>
          <Cost>79.64</Cost>
          <Amount>1433.52</Amount>
        </ItemLineRet>
      </BillRet>
    </BillQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through BillQuery results?

In qbXML, add iterator="Start" to BillQueryRq with MaxReturned, then send iterator="Continue" with the iteratorID until iteratorRemainingCount is 0. With LedgerWire, GET /v1/bills?limit=100 and follow nextCursor.

How do I fetch only bills changed since my last sync?

Use ModifiedDateRangeFilter/FromModifiedDate inside BillQueryRq, or updatedAfter on the REST endpoint.

Why does BillQuery return statusCode 1?

Status 1 is informational: "A query request did not find a matching object in QuickBooks". The request was valid and nothing matched the filters. LedgerWire returns an empty data array for it.

Sandbox fidelity

The LedgerWire sandbox simulates BillQuery with QuickBooks rules: required fields, element names, refs that must exist (3140), unique names (3100), field lengths (3070) and EditSequence locking (3200). Tax calculation, custom fields and preferences are not simulated.

More Bill messages

Other Query messages

Skip the XML: call GET /v1/bills with JSON.

Get a free sandbox key