PayCom Monthly Summary Report β Paycom VAT Column
The PayCom Monthly Summary report includes a dedicated Paycom VAT column that isolates the VAT component of each Paycom processing fee, enabling finance teams to reconcile Zenoti's report directly against the "of which VAT" line in the Paycom invoice.
Before you begin
- Your organization must use Paycom as a payment processor through Zenoti Payments.
- You need access to the PayCom Monthly Summary report. Contact your administrator if the report does not appear in your Reports Dashboard.
Permission: Access to this report is controlled by the Financial permission group under the Financial_Reports_V2 security object. Your administrator can grant access through Configuration > Security > Security Roles > [your role] > Financial Reports.
On this page
- How it works
- The Paycom VAT column
- The Paycom Fee column
- How the two columns relate
- Reconciling to the Paycom invoice
How it works
The PayCom Monthly Summary report provides a line-by-line breakdown of Paycom processing activity for a given period. Each row represents a transaction or fee event, and the report includes several financial columns that together account for the full cost of Paycom processing.
The report separates processing fees into two components:
- Paycom Fee β the VAT-inclusive total processing fee for each transaction.
- Paycom VAT β the VAT portion extracted from within that fee.
This separation exists because Paycom's own invoice presents fees in a similar split: a gross fee amount alongside a "of which VAT" sub-line. Without the Paycom VAT column in Zenoti, finance teams had to calculate the VAT component manually or accept a rounding mismatch when comparing the two documents.
What the column contains
The Paycom VAT column (paycom_vat) stores a money value representing the VAT element embedded in the Paycom processing fee for each transaction row. The value is extracted from the fee calculation, not added on top of it β Paycom VAT is always a subset of the Paycom Fee, never an additional charge.
The Paycom VAT column
The Paycom VAT column appears in the PayCom Monthly Summary report alongside the existing fee columns. It contains the VAT component of the Paycom processing fee for each transaction.
Key characteristics:
- Data type: Money (currency-formatted, two decimal places).
- Scope: Per-transaction β each row shows the VAT attributable to that specific transaction's processing fee.
- Sign: Positive for standard transactions. For refunded or reversed transactions, the value reflects the corresponding fee reversal.
- Relationship to Paycom Fee: Paycom VAT is always less than or equal to Paycom Fee for a given row. The two columns are not additive β Paycom VAT is already included within Paycom Fee.
The Paycom Fee column
The Paycom Fee column remains unchanged. It continues to display the VAT-inclusive total processing fee for each transaction β the gross amount Paycom charges for processing that transaction.
Finance teams who previously used Paycom Fee alone for reconciliation can continue to do so for total-fee comparisons. The Paycom VAT column is additive to the report, not a replacement.
How the two columns relate
The relationship between the two columns mirrors the structure of a Paycom invoice:
| Column | What it represents |
|---|---|
| Paycom Fee | Total processing fee including VAT (gross) |
| Paycom VAT | The VAT portion contained within Paycom Fee |
For any given transaction row: Paycom Fee = Net fee + Paycom VAT.
The Paycom VAT column provides the breakdown that allows you to verify the "of which VAT" sub-line on the Paycom invoice matches what Zenoti has recorded.
Reconciling to the Paycom invoice
To reconcile the PayCom Monthly Summary report against the Paycom invoice:
- Open the PayCom Monthly Summary report for the relevant billing period.
- Sum the Paycom Fee column to obtain total gross processing fees for the period.
- Sum the Paycom VAT column to obtain total VAT within those fees.
- Compare the Paycom VAT total against the "of which VAT" line on the corresponding Paycom invoice.
- Compare the Paycom Fee total against the total fee line on the Paycom invoice.
If the sums match, the period is reconciled. If they do not match, filter the report by transaction date to narrow the discrepancy to specific rows.
Note: Small differences may arise from rounding at the per-transaction level. Review individual rows where the Paycom VAT value appears inconsistent with the fee percentage to identify the source of any variance.