Daily Close shows a per-store, per-day summary of the day's money - what was collected by each payment type, the cash counted in the drawer, the day's sales, and whether the drawer balanced. Each store shows one row per day, followed by a per-store total, with a grand total at the bottom.

Report view from testing environment

Note: Online and curbside web orders appear on their own location line, separate from the physical stores. Those web locations have no cash drawer, so their Expected Cash, Register Count, and Over/Short are blank.

Controls

Start Date / End Date

The date range to report on. Both dates are included in full. For example, Start 6/3 and End 6/6 covers all of June 3 through June 6. The time of day doesn't matter; the report always covers whole days.

Store

A single store, or All Stores for the whole chain. All Stores adds a total row per store and a grand total at the bottom.

Exclude Acquired Historic Sales?

• Checked (the default) - hides historical sales that were imported only to feed forecasting.
• Unchecked - includes those imported sales, which inflates the cash and sales figures.

Run Button

Runs the report and displays the results in the grid.

Report Columns

• Store Number - The store the row is for
• Store Name - The store's name
• Date - The business day
• Cash - Cash taken in for the day, net of any cash given back on returns
• Check - Payments made by check
• Credit Cards - All card payments (Visa, Mastercard, Amex, Discover, and so on). Debit cards run as credit are included 
• Debit Cards - PIN-debit card payments. Usually zero unless a store runs cards as debit
• Returns - Merchandise returned during the day, already reflected in Net Sales and shown separately for reference
• Store Credit - Store-account credit that customers redeemed as payment
• Gift Card - Gift card balances that customers redeemed as payment
• Coupon - The value of coupons and loyalty rewards applied at checkout. Non-cash; no money changes hands
• Payouts - Cash paid out of the drawer during the day (for example, petty-cash expenses)
• Net Sales - Merchandise sold for the day, net of returns and before sales tax
• Tax - Sales tax collected
• Expected Cash - The amount of cash the drawer should hold at close, calculated by the system
• Register Count - The actual cash counted in the drawer at close
• Over/Short - Register Count minus Expected Cash. A positive number means the drawer was over; a negative number means it was short

Enterprise Client-Specific Versions

The layout above is the standard report. Enterprise clients can have a tailored version of Daily Close with columns adjusted to their needs. Common options include:

• Card groupings - American Express broken out on its own, with Visa, Mastercard, and Discover grouped together (they settle separately from Amex)
• A Bank Deposit column - Cash and Credit Cards combined into a single deposit total
• A sales-to-drawer comparison - a Difference column showing Total Sales against the counted drawer
• A trimmed column set - hiding columns a client doesn't use

Contact FieldStack Support to set up a client-specific version