Query the Payment entity filtered by a date range to retrieve all customer payments within the reconciliation period
For each Payment, inspect the DepositToAccountRef to determine whether it was deposited to a clearing (undeposited funds) account or directly to a bank account
Query the Deposit entity to find deposit transactions that aggregate payments from the undeposited funds account
Match each Payment Id found in the Deposit lines back to the original Payment records to confirm the full reconciliation chain
Compare the total of matched payments against the bank statement line amount and flag any discrepancies
Use the JournalEntry or Deposit entities to post any rounding adjustments needed to bring the reconciliation into balance
Known gotchas
Payments deposited directly to a bank account bypass the undeposited funds account and will not appear in any Deposit record; the reconciliation logic must handle both paths
A single Deposit can contain lines from multiple Payment types including sales receipts and payment records; do not assume all deposit lines are from the Payment entity
QBO does not expose a native reconciliation status field on Payments via the API; reconciled status is only visible in reports, not in the Payment entity payload
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp