Skip to main content

Register Closeout Entries Report

Written by Marie London

We're excited to bring you an expanded reporting experience. If you don't see the reporting features described below, don't worry—this updated reporting experience will become available to your account over time.

Resource

Link

Register Closeout Entries Report

Overview

The Register Closeout Entries report helps you review cash drawer reconciliation results by day or by individual closeout activity. It shows one row per drawer count — including expected cash, counted cash, and variance — so you can validate cash handling accuracy at the register level, not just at a daily total.

Use this report to confirm counted cash matches what the system expects at closeout, track cash inflows and outflows through the drawer, and reconcile bank deposits against what was actually paid out. It's useful for staff accountability and staying audit-ready, since you can identify which staff member performed each closeout and surface repeat discrepancies across shifts or locations.

Note: This report covers physical cash only — card, gift card, and other tender types aren't included, so cash sales here won't match totals in your sales reports. It's also one row per drawer count, not per day: a single day can include multiple closeouts (end of day, shift change, mid-day check), so daily totals may combine several entries. Cash Variance is Ending Balance minus Cash Expected — a positive value is an overage, a negative value is a shortage. See the Report Caveats section below for how Starting Balance is derived rather than directly entered.

What this report is best used for

Understand when and why to use this report through common use cases, descriptions, and example questions it can help answer in your day-to-day operations.

Use cases

Description

Example questions this report helps answer

Daily Cash Reconciliation

Confirm that the actual counted cash matches what the system expects at the end of the day or shift.

  • Is my register balanced at closeout?

  • Are there any cash shortages or overages?

  • Who performed the closeout?

Cash Flow Tracking

Track all inflows (sales, pay-ins) and outflows (refunds, deposits, expenses) from the register.

  • How much cash came into or left the drawer today?

  • What portion of pay-outs were for deposits vs. expenses?

  • How much was replenished during the day?

Staff Accountability

Monitor which staff members performed closeouts and ensure consistency across shifts or locations.

  • Who was responsible for each closeout?

  • Were multiple shifts reconciled correctly?

  • Which locations had discrepancies?

Bank Deposit Verification

Reconcile the total cash deposits paid out from registers with bank deposit records.

  • How much cash was marked for bank deposit?

  • Does this align with what was actually deposited?

  • Are any deposits missing or duplicated?

Prerequisites

Before using this report, make sure the following are in place. These directly impact whether you can access the report and how accurate the data will be.

  1. Permissions: You must have the appropriate Data & Reporting permissions enabled to see this report: Financials Reporting > Payment & Disputes

    • If you don’t see the report, check your permissions first - see Reporting Permissions for more information.

  2. Location and Access Scope: What you see in the report depends on your access:

    • You’ll only see data for assigned locations

    • Row-level access may further limit visible data

    • If it looks like data is missing, verify your location assignments and access settings.

  3. Required Setup: For the report to show meaningful data, your register workflows must be setup correctly:

    • Register drawer counts must be recorded daily (opening and closing counts)

    • Pay Ins/Pay Outs must be recorded when cash is manually adjusted from the register drawer

Default report configuration

See how the report is structured when first opened. Learn what each field represents, how the data is organized, and which fields can be used to filter results.

Group By (default)

The default fields the report is grouped by when you first open it.

Field name

Definition

Example

Filter?

Location Name

Name of the business location where the activity occurred.

AZ Tucson

Yes

Closeout Activity Date

The local calendar date when the drawer closeout record was created.

2026-03-22

Yes

Closeout Activity ID (hidden in table, visible in exports)

A unique identifier assigned to each drawer closeout record.

46f26ae1-7043-5e94-bc17-dcc06a191112

No

Columns (default)

The default columns displayed when you first open the report.

Field name

Definition

Example

Filter?

Cash Sales

The total dollar amount of all transactions paid using the Cash payment method within the period covered by the drawer closeout.

$85

No

Cash Refunds

The total dollar amount of refunds issued in Cash during the same period.

$0

No

Cash Paid In

The total dollar amount of manual cash additions entered through the Pay In function during the closeout period. Represents funds manually deposited into the register, typically used to replenish cash removed for refunds or to prepare float for the next shift.

$0

No

Cash Deposits Paid Out

The total dollar amount of cash removed from the register through Pay Out transactions categorized as “Deposit.” Represents cash physically removed to be deposited into the business bank account.

-$550

No

Cash Expenses Paid Out

The total dollar amount of cash removed from the register through Pay Out transactions categorized as “Expense.” Represents petty cash or operational cash used for in-store expenses such as supplies.

$0

No

Ending Balance

The total dollar amount physically counted in the drawer at the time of closeout.

$221.85

No

Cash Expected

The total dollar amount that should be physically present in the register at the time of closeout, based on all recorded system transactions during the drawer’s active period. Calculated as: Starding Balance + Cash Sales − Cash Refunds + Cash Paid In − Cash Deposits Paid Out - Cash Expenses Paid Out.

$856.85

No

Cash Variance

The variance between the Expected Drawer Amount and the Counted Drawer Amount at closeout. Calculated as (Ending Balance - Cash Expected). A positive value indicates an overage (more cash than expected); a negative value indicates a shortage (less cash than expected).

$0

Yes

Customizable fields

Explore the fields you can adjust to tailor the report to your needs. Each field includes a definition, example, and whether it can be used in filtering.

Field name

Definition

Example

Filter?

Location Name

Name of the business location where the activity occurred.

AZ Tucson

Yes

Closeout Activity Date

The local calendar date when the drawer closeout record was created.

2026-03-22

Yes

Closeout Activity ID

A unique identifier assigned to each drawer closeout record.

46f26ae1-7043-5e94-bc17-dcc06a191112

No

Cash Sales

The total dollar amount of all transactions paid using the Cash payment method within the period covered by the drawer closeout.

$85

No

Cash Refunds

The total dollar amount of refunds issued in Cash during the same period.

$0

No

Cash Paid In

The total dollar amount of manual cash additions entered through the Pay In function during the closeout period. Represents funds manually deposited into the register, typically used to replenish cash removed for refunds or to prepare float for the next shift.

$0

No

Cash Deposits Paid Out

The total dollar amount of cash removed from the register through Pay Out transactions categorized as “Deposit.” Represents cash physically removed to be deposited into the business bank account.

-$550

No

Cash Expenses Paid Out

The total dollar amount of cash removed from the register through Pay Out transactions categorized as “Expense.” Represents petty cash or operational cash used for in-store expenses such as supplies.

$0

No

Ending Balance

The total dollar amount physically counted in the drawer at the time of closeout.

$221.85

No

Cash Expected

The total dollar amount that should be physically present in the register at the time of closeout, based on all recorded system transactions during the drawer’s active period. Calculated as: Starding Balance + Cash Sales − Cash Refunds + Cash Paid In − Cash Deposits Paid Out - Cash Expenses Paid Out.

$856.85

No

Cash Variance

The variance between the Expected Drawer Amount and the Counted Drawer Amount at closeout. Calculated as (Ending Balance - Cash Expected). A positive value indicates an overage (more cash than expected); a negative value indicates a shortage (less cash than expected).

$0

Yes

Location Group

The location group the business location is associated with, if applicable.

West Coast

Yes

Operator name

The full name of the staff member who performed and submitted the drawer closeout.

Izzy Weckstein

Yes

Closeout Activity Time

The local time at which the drawer closeout was completed and recorded.

0:00:00

No

Location ID

Unique identifier of the business location.

2c91d997-4184-4e06-a534-ac96a27dceff

No

Location External ID

Identifier for the location from an external system, if provided by the business.

12345X

No

Operator ID

Unique identifier of the staff member who performed and submitted the drawer close out

043d66d0-ea8b-4eae-8558-ed7a5bc4f8d0

No

Description

A text note entered during the drawer count submission summarizing the reason for count (e.g., “End of Day,” “Shift Change,” “Mid-Day Check”).

Dec 15 check

No

Starting Balance

The dollar amount of cash in the drawer at the beginning of the closeout period, before any sales, refunds, pay-ins, or pay-outs occurred.

-$413.15

No

Location Tags

Location tags associated with the business location, if available.

High Volume

Yes

Report Caveats

There are a few important caveats and limitations to be aware of when using this report. Use these details to better understand how the data behaves and how to interpret it correctly.

Caveats

Details and Impact

One row per drawer count, not per day

A single day can have multiple closeout entries: end of day, shift change, or a mid-day check. The Description field shows the reason entered at count time, so daily totals may combine several counts.

Cash only

This report covers physical cash movement in the drawer. Card, gift card, and other tender types are not included, and cash sales here will not match total sales reports.

Positive variance is an overage, negative is a shortage

Cash Variance is the counted amount minus the expected amount. More cash than expected shows positive; less shows negative.

Ending Balance is the physical count, Cash Expected is the system's mathEnding Balance is what was actually counted in the drawer. Cash Expected is what the system calculates should be there from recorded transactions. The gap between them is the variance.

Ending Balance is what was actually counted in the drawer. Cash Expected is what the system calculates should be there from recorded transactions. The gap between them is the variance.

Starting Balance is derived, not entered

Starting Balance is calculated backward from the ending count and the period's recorded flows rather than captured as its own entry, so it inherits any counting or entry errors from those figures.

Use Case Example Configurations

Learn how to set up the report for specific scenarios with practical examples. Follow along to create views that answer common questions and support your workflows.

Use case

Description

How to configure the report

Daily Cash Reconciliation

Confirm that the actual counted cash matches what the system expects at the end of the day or shift.

  • Use default configuration.

  • Filters: Closeout Activity Date = the day; Location Name = the location. Compare Ending Balance against Cash Expected per entry; Cash Variance is the gap, and Operator name shows who counted.

Cash Flow Tracking

Track all inflows (sales, pay-ins) and outflows (refunds, deposits, expenses) from the register.

  • Use default configuration.

  • Filters: set Closeout Activity Date to the period; Location Name = the location. Cash Sales, Cash Refunds, Cash Paid In, Cash Deposits Paid Out, and Cash Expenses Paid Out are all included; pay-outs read as negative amounts.

Staff Accountability

Monitor which staff members performed closeouts and ensure consistency across shifts or locations.

  • Filters: set Closeout Activity Date to the review period.

  • Group by: Location Name, Operator name.

  • Columns: Cash Variance, Cash Expected, Ending Balance.

  • Sort by: Cash Variance to surface repeat discrepancies; drop to the default view to see individual counts per shift.

Bank Deposit Verification

Reconcile the total cash deposits paid out from registers with bank deposit records.

  • Filters: set Closeout Activity Date to the deposit period.

  • Group by: Location Name, Closeout Activity Date.

  • Columns: Cash Deposits Paid Out.

  • Match each day's total against the bank statement; drill to the default view for the individual entries behind a mismatch.

Did this answer your question?