Bill · Query
simulated in sandboxBillQuery
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
<?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-01curl "https://ledgerwire.vibiz.app/v1/bills?limit=10&updatedAfter=2026-10-01" \
-H "Authorization: Bearer $LEDGERWIRE_KEY"qbXML response (from the sandbox seed data)
<?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.
Skip the XML: call GET /v1/bills with JSON.
Get a free sandbox key