Organization level Reconciliation Report

If you are on Zenoti Payments, use the Zenoti Reconciliation report to match the Payouts credited to your bank account by Stripe, with the corresponding credit card payments received in Zenoti.

Table of Contents

Important Notes

Ensure the following setting is ‘On’ to see the Zenoti Reconciliation report:

  • At the Organization level, navigate to Admin > Organization > Organizations > Reports tab > Admin > Collections.
  • Under General group, ensure that the Zenoti Payments – Reconciliation checkbox is selected.

Follow these steps to open the report:

  1. At the organization level, navigate to Admin > Reports > Financial > Collections > Zenoti Payments – Reconciliation.
    The filters related to the report appear.
  2. Filters: Select a time period, select your preferred view: Deposit View or Collections View, and select centers.
  3. Click Refresh.
    The report appears.
  4. Click the arrow icon to expand the view.
  5. To export the report, on the top right side of the report, click the Excel () or .CSV () icons. After exporting, the report shows date-wise transactions for collections and deposits.

Filter Criteria

Criteria Options Description
Time Period Today
Last 7 days
Last 14 days
1 Month
2 Months
3 Months
6 Months
Custom
  • Select a suitable time period from the drop-down list.
    Note: The time period options in ‘Months’ refers to the calendar month and not the number of days. For example, if the current date of fetching the report is March 12, 2019 and you have selected 1 month for time period, you get the Reconciliation report for the month of March 2019 (from 1st to the current date). Similarly, 2 months as per our example, refers to March and April, and so on.
  • Use Custom to select a date range between which you want to see the Report. If you choose Custom from the list, then specify custom dates in the From and To fields.
    Note: For custom dates, you can view data for a maximum date range of 6 months at a time. For example, if you wish to see data from January to August, first see the data from January to June and then the data from July to August.
View Deposit View
Collection View
  • Deposit View: The report shows the Stripe payouts deposited to your bank, along with the Net payout amount deposited.
    Note: Deposits scheduled for future date are indicated with a star sign (*).
    Expand the dates to see Corresponding collection date and Invoice details.
  • Collection View: The report shows the collections in Zenoti (after deducting the fee charged by Stripe for processing the transaction). Expand the dates to see Corresponding deposit date and Invoice details.
Centers All centers on Zenoti checkbox

Checkbox for each center

Select ‘All Centers on Zenoti’ checkbox , if you want to see the reconciliation report for the entire organization.

Alternatively, if you want to view report for few centers or one center at a time, select the respective centers.

Note: If you are a franchise owner and say you own three centers, you can see all the three centers in the drop-down list.

Column Descriptions

Column Name Description
Collection Date The date on which the amount was collected by the center.
Deposit Date The date on which the collected amount was deposited in the bank.
Gross This is the gross amount that is collected.
Fee Shows the fee charged by Stripe for processing the card payments.
Net This is the total amount collected or deposited into the bank account after deducting the fee. 
Center Name The name of center will appear here. 

Match the Deposits with your Bank Statement

  1. In the Zenoti Reconciliation Report, select a time period to match with that of your bank statement.
  2. Select Deposits View.
  3. Select the Center for which you would like to reconcile the payments.
  4. Click Refresh.
    The Report appears showing the deposit dates and corresponding bank credits.
    Note: Deposits scheduled for future date are indicated with a star sign (*).
  5. Verify the deposit dates and the amount against your bank statement.
    If you have any questions on your deposits, refer to our FAQ section. You may find answer to your queries.

Match the Deposits and Collections shown in Zenoti Reconciliation Report with that of Register Summary Report

  1. At the center level, navigate to Reports > Daily Reports > General > Register Summary.
    The Register Summary report opens.
  2. Select a transaction or collection date using the custom option in time period.
  3. Click Refresh.
    Register Summary report appears for the selected date.
  4. Scroll down to Zenoti Payments section in the report.
    View the payments collected on that date and corresponding bank deposit dates for the selected center in Reconciliation report.

 

Match the Deposits shown in Zenoti Reconciliation report with that of Zenoti Online Collections Report

  1. At the center level, navigate to Reports > Finance > Collections > Online Collections report.
    The Collections – Online Collections report opens.
  2. Select a View: Collection or Deposit.
  3. Select a time period. If you want for a specific time period, select Custom and set the From and To dates.
  4. Click Refresh.
  5. Select the center and change the view in Zenoti Payments – Reconciliation Report, according to the view you selected in Online Transactions report.
    Match the date and the amount in both the reports.

 

FAQ

  1. For a particular date, the amount in my bank statement is not matching with that in the Reconciliation report. What could be the reason?
    Following are the possible reasons for mismatch of funds:
     If you have processed a refund directly from Stripe dashboard and do not
    have a corresponding record in Zenoti.
     Instead of refunding to the card, if you have refunded the guest by other
    mode such as cash or custom payment.
  2. I am not able to see the report. What should I do?
    Ensure the following setting is ‘On’ to see the Zenoti Reconciliation report:
    At the Organization level, navigate to Admin > Organization > Organizations > Reports tab > Admin > Collections. Under General group, ensure that the Zenoti Payments – Reconciliation checkbox is selected.
  3. The Reconciliation report and the Bank Deposits report don’t seem to match for a day. Why?
    Ensure that you are in the Deposits view in the Reconciliation report and then verify the dates and the amount in Bank Deposits report. They should match.
  4. I feel I received less money in the bank today than expected. Where should I check?
    a.
     To begin with, check the Register Summary report for that day. The Register
    summary report gives you entire summary of your transactions on a give
    day.
    b. Next, open the Reconciliation report and verify the corresponding
    transaction dates of Register summary with those in Reconciliation report.
    c. Open the Online-Collections report and match the dates you are looking for
    in the Reconciliation report (in collection view).
    d. Open the Bank Deposits report and match and match the dates you are
    looking for in the Reconciliation report (in Deposits view).