Billing, Collections, and Deposits report
The Billing, Collections, and Deposits report is a comprehensive financial report that provides a unified view of your center's sales activity, payment collections, and bank deposit amounts within a selected date range. Finance teams, center managers, and business owners use this report to reconcile invoices, track collections by payment method, monitor deduction activity such as chargebacks and refunds, and verify deposit amounts at the bank level.
Use this report to:
Reconcile end-of-day, end-of-week, or end-of-month financial activity.
Verify the payment mix and review amounts collected in cash, card, and direct debit.
Identify outstanding invoice balances that remain uncollected.
Monitor deductions such as chargebacks, refunds, and reversals that affect bank deposit totals.
Reconcile Zenoti deposit data against bank statements.
Key Terms
The following terms are used throughout this article. Refer to this section for definitions when reviewing report data.
Invoice: A billing document generated in Zenoti when goods or services are sold to a guest. Invoices record what was sold, the amounts owed, and any associated tax.
Collection: A payment received against an invoice. A collection can be made in cash, by card, through direct debit, or via other accepted payment methods.
Deposits: The amount transferred from collected payments into the bank account after processing fees are deducted and refunds or chargebacks are applied.
Chargeback: A payment reversal initiated by a guest's bank or card issuer following a dispute. The disputed amount is deducted from the center's bank deposit.
Processing fee: A fee charged by the payment processor for handling a transaction. Processing fees are deducted from the gross deposit before funds are transferred to the bank.
Pending dues: The total outstanding unpaid amount on invoices at the time the report is generated. Pending dues are calculated in real time and change when a payment is received or when the report is refreshed.
Refund: An amount returned to a guest from a previous collection. Refunds are applied against collections and reduce the deposit amount for the period in which they are processed, provided the original collection had been deposited.
Reversal: A transaction that was voided or reversed before bank settlement was completed. The reversal removes the amount from the expected bank deposit.
Direct debit: An automated payment method where Zenoti collects funds directly from a guest's bank account using a pre-authorized mandate.
SSG fee: Service and Support Grant fee. A supplementary charge that may be applied to invoices alongside standard service charges and donations.
Access the report
At the organization or center level, click Reports.
Search for and select Billing, Collections, and Deposits Report.
Apply the required filters and click Refresh to load results.
Scroll horizontally within any section to view all columns.
Available Filters
Apply the following filters to narrow the data displayed across all sections of the report.
Filter | Options and values | Description |
|---|---|---|
Center Name | Single or multiple center selection. | Filters all report sections to display data for the selected center or centers. The options available depend on the centers your account has access to. Zenoti recommends selecting centers in the same region or business unit for meaningful financial comparison. |
Group By | Item Type or Business Unit. | Determines how data is grouped and controls the display names of three sections in the report. Select Item Type to group data by service, product, membership, or other item categories. The three affected sections display as Sales Overview by Item Type, Collections Overview by Item Type, and Deposits Overview by Item Type. Select Business Unit to group data by your center's internal business divisions. The three affected sections display as Sales Overview by Business Unit, Collections Overview by Business Unit, and Deposits Overview by Business Unit. This filter does not affect the Collections Overview by Payment Method for Sales in the Date Range or the Deductions sections. |
Date Range | Start date and end date entered using the calendar picker. | Defines the date period for which data is fetched across all five sections. Each section applies this date range differently. Refer to the individual section descriptions for details on whether the date range applies to invoice creation date, collection date, or deposit date. |
Report Structure
The Billing, Collections, and Deposits report is organized into five sections. Each section captures a distinct aspect of financial activity for the selected date range. The following table provides a quick reference for the contents of each section.
Section | Functionality |
|---|---|
Sales Overview by Item Type or Business Unit | Shows all invoices created within the selected date range, organized by item category. This is the revenue reporting view of the report. It covers the items or services sold and billed in this period. The data is anchored to the invoice creation date, meaning an invoice appears here based on when it was raised, not when payment was received. Use this section to review gross sales, tax collected, tips, and fees. Additionally, identify any invoices that still carry outstanding balances through the Pending Dues column. |
Collections Overview by Payment Method for Sales in the Date Range | Shows collections against invoices created in the selected date range, broken down by payment method. Use this section to reconcile cash and card totals and verify net deposit amounts per payment type. |
Collections Overview by Item Type or Business Unit | Shows all payments received within the selected date range, anchored to the payment date rather than the invoice date. Use this section for cash flow analysis and to understand how much of the period's cash receipts relate to prior-period sales. |
Deductions | Shows all amounts deducted from bank deposits within the selected date range, including chargebacks, refunds, and reversals. Use this section to understand the gap between gross collections and net bank deposits. |
Deposits Overview by Item Type or Business Unit | Shows amounts deposited into the bank within the selected date range, organized by item category, separated by in-period and out-of-period sales. Use this section as the final step in reconciling Zenoti data against the bank statement. |
Note
The Group By filter applies only to the Sales Overview by Item Type or Business Unit, Collections Overview by Item Type or Business Unit, and Deposits Overview by Item Type or Business Unit sections. Click the expand icon next to any Category row in those sections to view subcategory-level detail.
Collections Overview by Item Type or Business Unit
The Collections Overview by Item Type or Business Unit section is the cash flow view of the Billing, Collections, and Deposits Report. Unlike the Sales Overview by Item Type or Business Unit section, which is anchored to invoice creation date, this section is anchored to the date payment was actually received. It captures all payments received within the selected date range, organized by item category, regardless of when the underlying invoice was created. This distinction matters because guests may pay invoices from prior periods within the current reporting window, meaning the totals here will often differ from those in the Sales Overview by Item Type or Business Unit section.
Column name | Short description | Description |
|---|---|---|
Category | Displays the item category and its subcategories. | Shows the item category and its subcategories based on the Group By filter selection. Click the expand icon next to a category row to view subcategory-level detail. |
Collections Exclusive of Tax | Shows the net revenue from collections received in this period, excluding tax. | Shows total collections in the selected date range for this category, excluding tax. May include payments for prior-period invoices. |
Tax | Shows the tax collected on invoices for which payment was received in this period. | Shows the total tax amount on invoices for which payment was received during the selected date range. |
Collections Inclusive of Tax | Shows the gross collections received in this period, including tax. | Shows the total collections, including tax received during the period, calculated as Sales Exclusive of Tax plus Tax. |
Other Fees | Shows additional charges such as donations and service fees collected in this period. | Shows the total of supplementary charges, including donations, service charges, and SSG fees collected during the period. |
Tips | Shows the total tips collected in the selected date range. | Shows the total tip amounts collected during the selected date range, regardless of when the invoice was created. |
Shows the total collections received for invoices created in the same period. | Shows collections received for invoices created in the same date range. Parent total for the Manual and Automatic sub-columns. | |
Manual Collections from Sales in Date Range | Shows collections received in the selected date range for invoices created in the same range, collected manually by staff. | Shows the portion of in-period collections that were processed manually by staff, for example, a card payment entered by a receptionist at the center for a same-period invoice. This is a subset of the Collections from Sales in the Date Range total. |
Automatic Collections from Sales in Date Range | Shows collections received in the selected date range for invoices created in the same range, collected automatically by the system. | Shows the portion of in-period collections that were processed automatically by the Zenoti system, for example, a recurring membership billing run. If an automatic collection fails and a staff member retries it manually, that retry is recorded as a manual collection, not in this column. This is a subset of the |
Collections for Sales prior to Date Range | Shows collections received in this period for invoices created in a previous period. | Shows collections received for invoices created before the selected date range. Parent total for the Manual and Automatic sub-columns. |
Manual Collections for Sales prior to Date Range | Shows collections received in the selected date range for invoices created before the selected range, collected manually by staff. | Shows the portion of out-of-period collections that were processed manually by staff. This is a subset of the Collections for Sales prior to Date Range total. |
Automatic Collections for Sales prior to Date Range | Shows collections received in the selected date range for invoices created before the selected range, collected automatically. | Shows the portion of out-of-period collections that were processed automatically by the Zenoti system. This is a subset of the Collections for Sales prior to Date Range total. |
Cash Collections | Shows the total amount received in cash during the selected date range. | Shows the total amount received in cash during the selected date range, regardless of the invoice creation date. Use this column for end-of-day cash reconciliation. |
Other Collections | Shows collections received through payment methods other than cash, card, or direct debit. | Shows the total amount collected through payment methods such as wallet credits, gift card redemptions, and custom payment types during the selected date range, regardless of invoice creation date. |
Direct Bank Collections | Shows the total collections received through card and direct debit payment methods. | Shows the total amount received through card and direct debit payment methods during the selected date range, regardless of when the invoice was created. |
Refunds | Shows the total refunds processed in the selected date range. | Shows the total amount refunded to guests during the selected date range. |
Processing Fee | Shows the total processor fees charged for collections in the selected date range. | Shows the total fees charged by the payment processor for all collections within the defined date range. |
Deposits | Shows the total amount deposited into the bank for collections in the selected date range. | Shows the total amount deposited into the bank for all collections received within the defined date range. |
Disputes | Shows the total deposit amount under dispute in the selected date range. | Shows the total amount under dispute from deposits received during the defined date range. Disputes are recorded on their resolution date in Zenoti. |
Total Collections | Shows the total amount collected in the selected date range for this category. | Aggregates all collections received in the selected date range for this item type or business unit, across all payment methods and regardless of invoice creation date. |
Considerations
The Sales Overview by Item Type or Business Unit section is anchored to the invoice creation date and is the correct view for sales reporting. This section is anchored to the payment received date and is the correct view for cash flow analysis. Out-of-period collections appear here but not in the Sales Overview by Item Type or Business Unit section for the same date range, which is expected behavior.
Do not add Collections from Sales in Date Range, Collections for Sales prior to Date Range, and their respective Manual and Automatic sub-columns together. The sub-columns are subsets of the parent totals, and summing all six produces double-counting.
Cash collections, Other collections, and Direct bank collections are not split by invoice period. These columns capture all activity in the date range, regardless of when the invoice was created. There is no in-period or out-of-period breakdown for these payment types.
Refunds reduce Deposits, not the collections total. Refunds are deducted at the deposit stage. Deposits will therefore be lower than total collections in any period where refunds were processed.
Note
The Collections from Sales in Date Range and Collections for Sales prior to Date Range columns are parent totals. Their Manual Collections and Automatic Collections sub-columns are subsets of those totals. Do not add parent and sub-columns together when calculating totals, as this results in double-counting.
Collections Overview by Payment Method for Sales in the Date Range
The Collections Overview by Payment Method for Sales in the Date Range section shows how payments were received against invoices created within the selected date range, broken down by individual payment method.
Key characteristics of this section:
Each row represents one payment method, such as cash, credit card, direct debit, or wallet.
For each payment method, the section shows the transaction count, total collected, processing fees, gross deposits, and the net deposit after refunds and disputes are accounted for.
This section covers only invoices created within the selected date range. Collections received in the current period for invoices created previously appear in the Collections Overview by Item Type or Business Unit section.
Center managers and finance teams use this section for end-of-day cash and card reconciliation, reviewing processing fee costs per payment type, and verifying that net deposit amounts align with payment processor reports.
Column descriptions
The following table describes the columns available in Collections Overview by Payment Method for Sales in the Date Range section.
Column name | Short description | Description |
|---|---|---|
Payment Type | Displays the payment method used to complete the collection. | Shows the payment method used. Common values include Cash, Credit card, Direct debit, Gift card, and Wallet. |
Transactions | Shows the number of payment transactions recorded in the date range for this payment type. | Shows the number of individual payment transactions for this payment method in the selected date range. |
Sales Exclusive of Tax | Shows the net sales revenue collected through this payment method, excluding tax. | Shows the total payments applied to item sales through this payment method, excluding tax, for invoices created in the selected date range. |
Tax | Shows the tax amount collected through this payment method. | Shows the total tax collected through this payment method for invoices created in the defined date range. |
Other Fees | Shows additional charges such as donations and service fees collected through this payment method. | Shows the total of supplementary charges, including donations, service charges, and SSG fees collected through this payment method. |
Collections | Shows the total amount collected through this payment method, including tax. | Shows the gross amount received through this payment method, including tax, before processing fees, refunds, or disputes are deducted. |
Processing Fee | Shows the fees charged by the payment processor for transactions through this payment method. | Shows the payment processor fees for this payment method in the selected date range. Cash transactions carry no processing fee. |
Deposits | Shows the gross amount deposited into the bank through this payment method. | Shows the gross amount deposited through this payment method for invoices created in the selected date range, before deductions. |
Refunds | Shows the total amount refunded to guests through this payment method. | Shows the total amount refunded to guests through this payment method for invoices created in the defined date range. |
Disputes | Shows the total deposit amount under dispute for this payment method. | Shows the total amount under dispute, also referred to as a chargeback, from deposits received through this payment method. Disputes are recorded on their resolution date in Zenoti, which may differ from the original transaction date. |
Net Deposits (Plus Adjustments) | Shows the net amount deposited into the bank after disputes, reversals, and refunds are deducted. | Shows total deposits minus disputes, reversals, and refunds for this payment method. May not match the bank statement exactly because disputes are recorded on their resolution date. |
Total Sales | Shows the total sales value for invoices in the selected date range for this payment method. | Shows the combined total of Sales Exclusive of Tax, Tax, and Other Fees for invoices in the selected date range collected through this payment method. |
Considerations
Collections received in the current period for invoices created previously do not appear here. Those amounts are captured in the Collections Overview by Item Type or Business Unit section.
The Transactions column counts payment events, not invoices. A single invoice that received two partial payments is counted as two transactions.
Disputes are recorded on their resolution date, not the original transaction date. The net deposit figure for a period can be reduced by chargebacks that originated in a different period. Cross-reference with the payment processor dispute dashboard when investigating discrepancies.
Deposits Overview by Item Type or Business Unit
The Deposits Overview by Item Type or Business Unit section is the bank reconciliation view of the report. It shows the actual amounts deposited into the bank within the selected date range, organized by item category.
Key characteristics of this section:
Unlike the Collections Overview by Item Type or Business Unit section, which shows all payments received, this section shows only amounts that have cleared as bank deposits.
Deposits are separated into in-period sales, which are invoices created and paid within the same date range, and out-of-period sales, which are invoices from a prior period collected and deposited in the current period.
Each deposit type is further broken down by collection method: automatic, which are deposits collected by the Zenoti system, and manual, which are deposits collected by staff.
Finance teams use this section as the final step in reconciling Zenoti data against the bank statement, verifying that deposit totals by category align with what the bank or payment processor has settled.
Column descriptions
The following table describes the columns available in Deposits Overview by Item Type or Business Unit section.
Column name | Short description | Description |
|---|---|---|
Category | Displays the item category and its subcategories. | Shows the item category and its subcategories based on the Group By filter selection. Click the expand icon next to a category row to view subcategory-level detail. |
Transactions | Shows the number of transactions that resulted in bank deposits in the selected date range. | Shows the total number of individual transactions that resulted in bank deposits within the defined date range for this category. |
Sales Exclusive of Tax | Shows the net revenue from deposited transactions, excluding tax. | Shows the total payments applied to item sales in this category that resulted in bank deposits during the selected period, excluding tax. |
Tax | Shows the tax collected on deposited transactions in the selected date range. | Shows the total tax collected for transactions in this category that resulted in deposits within the defined date range. |
Collections | Shows the gross collections including tax for deposited transactions. | Shows the total collections including tax for deposits in this category, calculated as Sales Exclusive of Tax plus Tax. |
Processing Fee | Shows the processor fees deducted from deposits in this category. | Shows processing fees charged for deposits in this category in the selected date range. |
Refunds | Shows the total refunds applied against deposits in this category. | Shows the total amount refunded to guests from deposits in this category for the defined date range. Refunds reduce the Deposits value. |
Disputes | Shows the total deposit amount under dispute in this category. | Shows the total amount under dispute, also referred to as a chargeback, from deposits in this category. Disputes are recorded on their resolution date in Zenoti. |
Deposits for Sales in Date Range | Shows the deposits for invoices created and collected within the selected date range. | Shows deposits for invoices created and collected within the selected date range. Parent total for the Auto and Manual Collected sub-columns. |
Automatic Deposits for Sales in Date Range | Shows deposits in the selected date range for invoices created and collected in the same range, processed automatically. | Shows deposits for same-period invoices that were collected automatically by the Zenoti system, for example, a recurring membership charge processed without staff intervention. This is a subset of the Deposits for Sales in Date Range total. |
Manual Deposits for Sales in Date Range | Shows deposits in the selected date range for invoices created and collected in the same range, processed manually by staff. | Shows deposits for the same-period invoices that were collected manually by staff at the center. This is a subset of the Deposits for Sales in Date Range total. |
Deposits for Sales prior to Date Range | Shows deposits for invoices created in a prior period but collected in the current period. | Shows deposits for invoices created before the selected date range. Parent total for the Auto and Manual Collected sub-columns. |
Automatic Deposits for Sales prior to Date Range | Shows deposits in the selected date range for invoices created before the selected range, processed automatically. | Shows deposits for prior-period invoices that were collected automatically by the Zenoti system. This is a subset of the Deposits for Sales prior to Date Range total. |
Manual Deposits for Sales prior to Date Range | Shows deposits in the selected date range for invoices created before the selected range, processed manually by staff. | Shows deposits for prior-period invoices that were collected manually by staff. This is a subset of the Deposits for Sales prior to Date Range total. |
Deposits | Shows the total amount deposited into the bank for this category in the selected date range. | Shows total bank deposits for this category in the selected date range. Use this as the primary figure for bank statement reconciliation. |
Deductions | Shows the total deductions from deposits in the selected date range for this category. | Shows the total amount deducted from bank deposits in the selected date range for this item type or business unit. Includes chargebacks, refunds, and reversals processed during the period. |
Considerations
Deposits will be lower than total collections for the same period. The Deposits column reflects amounts after processing fees, refunds, and disputes are deducted. This difference is expected and is not a discrepancy. Do not subtract processing fees again from Deposits when reconciling, as they are already included.
Disputes reduce Deposits in the period they are resolved, not when the original transaction occurred. A chargeback resolved in the current period reduces this period's Deposits figure even if the original deposit was in a prior period. This can cause Deposits to appear lower than expected when compared to a bank statement that records the deduction differently.
Do not add parent deposit totals and their sub-columns together. Deposits for Sales in Date Range and Deposits for Sales prior to Date Range are parent totals. Their Auto Collected and Manual Collected sub-columns are subsets. Summing parent and sub-columns together results in double-counting.
The Transactions column counts deposit events, not invoices. A single invoice with multiple partial payments collected on different dates may contribute more than one deposit transaction to this count.
Deductions
The Deductions section shows all amounts subtracted from bank deposits within the selected date range. It explains the gap between the gross deposit amounts shown in other sections and the net amount that actually clears in the bank.
Key characteristics of this section:
Deductions arise from chargebacks, chargeback fees, refunds, payments returned by the guest's bank, and transaction reversals.
Deductions are recorded in Zenoti on the date they are resolved, not the date of the original transaction. Entries in this section may therefore relate to transactions from prior periods.
Use this section to track the total financial impact of deductions, investigate chargeback patterns, verify whether disputed amounts have been reversed in your favor, and reconcile deposit shortfalls against the bank statement.
Column descriptions
The following table describes the columns available in the Deductions section.
Column name | Short description | Description |
|---|---|---|
Description | Displays the category of deduction applied. | Shows the type of deduction processed. Possible values are Chargeback, Chargeback Fee, Chargeback Reversed, Refund, Returned, and Reversal. Refer to the deduction type definitions in the table below for a full description of each value. |
Amount | Shows the monetary value of the deduction. | Shows the monetary amount of the deduction for the corresponding deduction type. Chargeback Reversed entries appear as positive values, indicating that funds were returned to your account following a successful dispute resolution. |
The following table defines each deduction type.
Deduction type | Description |
|---|---|
Chargeback | A payment reversal initiated by the guest's bank after a dispute. The full transaction amount is deducted from your deposit. |
Chargeback Fee | An administrative fee charged by the payment processor for handling a chargeback, separate from the disputed transaction amount. This fee is incurred regardless of whether the chargeback dispute is won or lost. |
Chargeback Reversed | A chargeback that was successfully contested and reversed in your favor, returning the original transaction amount to your account. A Chargeback Reversed entry offsets the corresponding Chargeback entry. When both appear in the same period, the net financial impact of that transaction may be zero. |
Refund | An amount returned to the guest by the center, deducted from collected deposits. Refunds are recorded in the period they are processed and reduce the net deposit amount for that period. |
Returned Payment | A payment returned by the guest's bank due to insufficient funds, an invalid account number, or another rejection. The returned amount is deducted from your deposit. |
Payment Reversal | A transaction that was voided or reversed, typically before settlement is completed. Reversals may result from entry errors, duplicate transactions, or system corrections and produce a deduction from the expected deposit amount. |
Considerations
Chargeback Reversed does not remove the original Chargeback entry. Both entries appear as separate rows. To calculate the net financial impact, subtract the Chargeback Reversed amount from the Chargeback amount. When both appear in the same period, the net impact of that transaction on deposits may be zero.
A single transaction can generate multiple deduction rows. A disputed transaction produces both a Chargeback entry and a Chargeback Fee entry. Review all rows for a period to understand the full deduction impact rather than relying on any single row.
Deductions affect deposits, not collections. Deduction amounts are subtracted from what is transferred to the bank. They do not reverse the payment recorded in the Collections section.
Deductions are recorded on the date they are processed or resolved, not the original transaction date. A Chargeback and its corresponding Chargeback Reversed entry may appear in different reporting periods if dispute resolution spans multiple periods.
Sales Overview by Item Type or Business Unit
The Sales Overview by Item Type or Business Unit section is the sales and billing view of the report. It shows all invoices created within the selected date range, organized by item category. For businesses following accrual accounting, this section also serves as the revenue reporting view.
Key characteristics of this section:
The data is anchored to the invoice creation date. An invoice appears in this section based on when it was raised, regardless of whether payment has been collected.
The section covers gross sales, tax collected, tips, fees, and the collection and deposit status of each invoice.
Invoices with outstanding balances appear with a non-zero value in the Pending Dues column, making this section the primary reference for identifying unpaid invoices.
Finance teams and center managers use this section for end-of-period sales summaries, tax reconciliation, commission calculations, and follow-up on outstanding dues.
Important
Select the Show only collections within the selected date range checkbox in the section header to restrict the Collections and Deposits columns to activity that occurred within the selected date range only. When cleared, those columns show all collections and deposits against those invoices up to the report run date. The checkbox is cleared by default.
Column descriptions
The following table describes the columns available in this section. Click any Category row to expand and view subcategory-level detail. The grouping of subcategories depends on the Group By filter selection.
Column name | Short description | Description |
|---|---|---|
Category | Displays the item category and its subcategories. | Shows the item category and its subcategories based on the Group By filter selection. Select Item Type to group data by services, products, memberships, and so on. Select Business Unit to group data by your center's internal divisions. Click the expand icon next to a category row to view subcategory-level values. Each category row aggregates all values from its subcategories. |
Sales Exclusive of Tax | Shows the net revenue earned from sales, excluding tax. | Shows the total value of items sold during the selected date range, before tax is applied. |
Tax | Shows the total tax collected on invoices in the selected date range. | Shows the total tax collected on invoices created during the selected date range. |
Sales Inclusive of Tax | Shows the gross revenue from sales, including tax. | Shows the total invoice value, including tax, calculated as Sales Exclusive of Tax plus Tax. |
Other Fees | Shows additional charges applied to invoices beyond item pricing. | Shows donations, service charges, and SSG fees applied to invoices. These amounts are not included in Sales Exclusive of Tax. |
Tips | Shows the total tips collected on invoices in the selected date range. | Shows the total tips collected on invoices created in the selected date range. Tips are not included in Sales Exclusive of Tax. |
Cash Collections | Shows the total amount collected in cash for invoices in the selected date range. | Shows the total cash received against invoices created in the selected date range. |
Other Collections | Shows collections received through payment methods other than cash, card, or direct debit. | Shows collections received through wallet credits, gift card redemptions, and custom payment types. |
Direct Bank Collections | Shows the total collections received through card and direct debit payment methods. | Shows the total amount collected through card-based and direct debit payment methods, deposited directly into the bank. This column is the parent total for the Manual and Automatic sub-columns. Do not add all three columns together, as the manual and automatic columns are subsets of this total. |
Direct Bank - Manual Collections | Shows card and direct debit payments processed manually by staff. | Shows the portion of Direct Bank Collections that was processed manually by staff, for example, a receptionist entering a card payment at the counter. This is a subset of the Direct Bank Collections total. |
Direct Bank - Automatic Collections | Shows card and direct debit payments collected automatically by the system. | Shows the portion of Direct Bank Collections that was processed automatically by the Zenoti system using a saved card or direct debit mandate, for example, a recurring membership billing run. If an automatic collection fails and a staff member retries it manually, that retry is recorded as a manual collection, not in this column. This is a subset of the Direct Bank Collections total. |
Pending Dues | Shows the total outstanding unpaid amount on invoices in the selected date range. | Shows the total amount yet to be collected on invoices created in the selected date range. This includes invoices with no payment received and invoices that have been partially collected. The value reflects the remaining unpaid balance on each invoice, not the full invoice amount. This value is calculated in real time at the time the report is generated and changes when the report is refreshed. When the Show only collections within the selected date range checkbox is selected, this column displays zero because only fully collected invoices are included. |
Processing Fee | Shows the fees charged by the payment processor for collections in the selected date range. | Shows the total payment processor fees for collections in the selected date range. Processing fees are deducted before funds are transferred to the bank. |
Deposits | Shows the total gross amount deposited into the bank for invoices in the selected date range. | Shows the gross amount deposited into the bank for invoices created in the selected date range, calculated as bank collections minus processing fees. Refunds and disputes that reduce this figure are recorded on the date they are processed, which may fall outside the selected date range. |
Disputes Raised in the Date Range | Shows the total deposit amount currently under dispute for invoices in the selected date range. | Shows the total deposit amount under dispute for invoices created in the selected date range. Disputes are recorded on their resolution date and may include prior-period activity. |
Refunds | Shows the total amount refunded to guests from deposits in the selected date range. | Shows the total refund amount processed during the selected date range. Refunds are recorded on the date they are processed and apply to any sale invoice, regardless of when it was created. This value reduces the deposit amount for the period in which the refund is issued. |
Total Sales | Shows the total value of all items billed in the selected date range. | Shows the combined total of Sales Exclusive of Tax, Tax, Other Fees, and Tips for all invoices created in the selected date range. Use this column for a single headline figure of everything billed in the period. |
Collections | Shows total payments received against invoices created in the selected date range. | Shows all collections received across all payment methods against invoices created in the selected date range, regardless of when the payment was received. Use this column alongside Pending Dues to understand how much of the period's sales have been collected to date. |
Considerations
Group By replaces category rows entirely. Switching between Item Type and Business Unit changes the row structure completely. Totals from one grouping cannot be compared to totals from the other. Refresh the report after changing the filter.
Tips are excluded from Sales Exclusive of Tax. To report the full guest-facing billed amount, add the Tips column to Sales Inclusive of Tax. Other Fees, which include donations, service charges, and SSG fees, are also excluded from Sales Exclusive of Tax.
When a refund is processed, the Refunds column increases and the Deposits column decreases by the same amount. The Sales Exclusive of Tax and Tax columns are not affected because sales figures are recorded at the point of sale and are not reversed by post-sale adjustments. For businesses on accrual accounting, this means a refund appears as a reduction in deposits rather than a reversal of recognized revenue.
Do not add Direct Bank Collections together with its Manual and Automatic sub-columns. The sub-columns are subsets of the parent total, and summing all three produces double-counting.
Tax values depend on item-level configuration in Zenoti. The rate applied to each invoice is determined by the tax settings per item category. Verify configuration if totals appear inconsistent with expected rates.