Power BI Connector for QuickBooks Online

Build 25.0.9454

TaxPayment

Shows sales tax payment records, summarizing payments made to tax agencies for easier tracking and reconciliation.

Columns

Name Type References Description
Id [KEY] String The unique identifier (Id) that is assigned by QuickBooks Online to this tax payment transaction. It is used to retrieve or reference the tax payment programmatically and is required for updates or deletions.
SyncToken String The version control token for this tax-payment transaction that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the transaction is modified, and only the latest sync token is accepted for edits.
MetaData_CreateTime Datetime The date and time stamp (Coordinated Universal Time) for when QuickBooks Online created this tax-payment record in the source domain. This timestamp provides an immutable audit trail for the transaction's creation.
MetaData_LastUpdatedTime Datetime The date and time stamp (Coordinated Universal Time) for when this tax-payment record was last modified in the source domain.
PaymentDate Date The date on which the tax payment was made or recorded in QuickBooks Online. This date determines the accounting period for the payment.
PaymentAccountRef String The unique Id of the account from which the tax payment was made or to which the refund was moved. This field links the tax payment to the specific bank or liability account used.
PaymentAccountRef_Name String The display name of the account from which the tax payment was made or to which the refund was moved. This name helps users identify the account in reports and on forms.
PaymentAmount Decimal The total monetary amount of the tax payment or refund that is recorded in this transaction. This value reflects the amount actually paid to or refunded from the tax agency.
Refund Boolean Indicates whether this transaction is a refund (true) or a tax payment (false). When this flag is set to false, the record represents an outgoing tax payment. When this flag is set to true, the record represents a tax refund received from the tax agency.
TxnDate Date The transaction date on which this tax-payment record is posted to the books. This date can match or differ from the payment date, depending on when the transaction was entered.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454