Skip to main content

Filters supported for QuickBooks Desktop

See Filters for how to use them.

AP Invoice​

  • issue_date: <=, >=, =
  • number: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =
  • vendor_id: =

AP Payment​

  • ledger_account_id: =
  • number: <=, >=, =
  • payment_date: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN
  • vendor_id: =

AR Invoice​

  • customer_id: =
  • number: <=, >=, =
  • issue_date: <=, >=, =
  • status: =
  • source_update_time: : <=, >=, =, BETWEEN

AR Payment​

  • customer_id: =
  • ledger_account_id: =
  • number: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN
  • transaction_date: <=, >=, =

Bank Account​

  • currency_code: =
  • name: =, ILIKE, BETWEEN
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =
  • type: =

Customer​

  • balance: =, <, <=, >, >=
  • name: =, ILIKE, BETWEEN
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =

Estimate​

  • customer_id: =
  • issue_date: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN

Expense​

  • bank_account_id: =
  • number: <=, >=, =
  • payment_date: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN
  • vendor_id: =

Item​

  • name: =, ILIKE, BETWEEN
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =

Ledger Account​

  • currency_code: =
  • name: =, ILIKE, BETWEEN
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =
  • type: =

Purchase Order​

  • number: <=, >=, =
  • order_date: <=, >=, =
  • source_update_time: : <=, >=, =, BETWEEN
  • vendor_id: =

Vendor​

  • name: =, ILIKE, BETWEEN
  • source_update_time: : <=, >=, =, BETWEEN
  • status: =