Register summary report
The Register Summary report provides a register-level summary of all transactions processed through the register, including opening balances, cash flow, payment method breakdowns, and expected versus actual closing balances. It gives the same data that is visible during the register close process but in a report format that you can review without initiating a closure.
This report opens as a legacy popup window from the appointment book's Reports icon. It is essential for end-of-day reconciliation and for pre-checking the register status before closing.
Audience: Front desk staff and center managers who reconcile registers at end of day.
Before you begin
Permission: View Register or Close Register (under Cash Registers) — required to access this report.
- Ensure you have access to the register(s) at the center for which you want to view data.
- This report shows data for the current register session or business day.
- If the register has not yet been opened for the day, the report will show no data.
How to access the report
- Open the Appointment Book from the main navigation.
- In the right navigation panel, click the Reports icon.
- Select Register Summary from the reports menu.
- The report opens in a popup dialog showing the register reconciliation data.
Column descriptions
The main section of the report shows the overall register activity:
| Column | Description |
|---|---|
| Register Name | The name of the register (for centers with multiple registers, each appears as a separate row or section). |
| Opening Balance | The cash amount that was in the register at the start of the business day. This is the float amount entered when the register was opened. |
| Total Cash In | The total cash received through transactions during the day. This includes cash payments for services, products, tips, and any manual cash-in entries. |
| Total Cash Out | The total cash removed from the register during the day. This includes cash refunds, paid-outs, and any manual cash-out entries. |
| Expected Closing Balance | The calculated closing balance based on the opening balance, cash in, and cash out. Formula: Opening Balance + Total Cash In - Total Cash Out. |
| Actual Closing Balance | The actual cash counted in the register at the time of closure. This field is populated after the register is closed. If the register is still open, this field may be blank. |
| Variance | The difference between the expected closing balance and the actual closing balance. A positive variance means more cash than expected; a negative variance means less cash than expected. |
Payment method breakdown
Below the main register summary, the report provides a detailed breakdown by payment method:
| Payment Method | Description |
|---|---|
| Cash | Total cash payments received, including cash portions of split payments. |
| Credit Card | Total credit card transactions processed through the register. |
| Debit Card | Total debit card transactions processed through the register. |
| Check | Total check payments received, if applicable. |
| Gift Card | Total gift card redemptions processed through the register. |
| Loyalty Points | Total loyalty point redemptions applied at checkout. |
| Membership Credit | Total membership credits applied at checkout. |
| Package Credit | Total package credits applied at checkout. |
| Other | Any other payment methods configured in your system. |
Each payment method row shows the total amount processed and the number of transactions. This breakdown helps you verify that the totals match your payment processor records and internal accounting.
Understanding variances
The variance between the expected and actual closing balance is a critical indicator of register accuracy:
Zero variance
A zero variance means the physical cash in the register exactly matches the expected amount. This is the ideal outcome and indicates that all transactions were processed correctly.
Positive variance (overage)
A positive variance means there is more cash in the register than expected. Possible causes include:
- A cash payment was received but not recorded in the system.
- A manual cash-in was added without a corresponding transaction.
- An error in counting the cash.
Negative variance (shortage)
A negative variance means there is less cash in the register than expected. Possible causes include:
- A cash refund or paid-out was issued but not recorded in the system.
- Cash was removed from the register without authorization.
- An error in counting the cash.
- A discount was applied at the register but the cash was not returned to the guest.
Note: Consistent variances in either direction should be investigated promptly. Occasional small variances may result from rounding or counting errors, but persistent patterns warrant a review of register procedures.
Filters
| Filter | Description |
|---|---|
| Register | Select the specific register to view. If the center has only one register, it is selected by default. |
| Date | The business date for which to view the register summary. Defaults to today. |
| Center | The center for which to view register data. Defaults to the center currently selected in the appointment book. |
Tips for using this report
- Pre-closure check -- Run this report before initiating the register close process to preview the expected closing balance and identify any issues early.
- Reconcile payment methods -- Compare the payment method breakdown in this report to your credit card terminal batch totals and other payment processor reports.
- Track variances -- Monitor variances over time. If a specific register or shift consistently shows variances, investigate the root cause.
- Multi-register centers -- For centers with multiple registers, review each register separately to isolate any issues to a specific register.
- Compare with collections -- Cross-reference the cash amount in the Register Summary with the cash amount in the Today's Collections report to ensure consistency.