Month-End Close Automation & Financial Reconciliation3 min readUpdated September 2026

Three Numbers That Should Match and Usually Don't

At a multi-channel retail brand, the store deposit, the point-of-sale journal and the bank statement rarely agree, and the gap usually parks in a cash-over-short account nobody owns. Location count, more than revenue, decides whether a spreadsheet close can keep up, and per-store review is what exposes a recurring variance.

Vendors Covered in this Article

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Three Numbers That Should Match and Usually Don't: Deposit, POS Journal, Bank Statement

The point-of-sale journal records what was rung up, the deposit slip records what a store manager actually took to the bank, and the bank statement records what the bank actually received and processed. A gap between any two of these is either a timing issue, a deposit made after the cutoff, a counting error, or occasionally something worse, and the close needs to identify which before writing it off as immaterial.

A gap that recurs at the same store month after month, even a small one, deserves more attention than a one-time variance at a different location entirely. Treating every gap as equally routine, rather than tracking which locations produce recurring variances, is how a real problem hides in plain sight behind a chain-wide average that looks fine.

Who Should Own the Cash-Over-Short Account?

Small daily variances get parked in a cash-over-short account as a matter of convenience, and that's reasonable for genuinely small, random amounts. The problem is when nobody actually reviews that account's running balance by location, so a store with a persistent, one-directional variance, always short, never over, gets buried in a bucket that reads as noise instead of the signal it actually is.

Say one store's cash-over-short account has run short by roughly the same small amount for six straight months. Reviewed only as part of a chain-wide total that nets close to zero, that pattern is invisible. Reviewed by location, it's an obvious candidate for a closer look, whether that means a till-counting process issue or a more direct conversation with the store's management.

When Does Each Sales Channel Book Its Revenue?

In-store sales recognize at the point of sale, online orders often recognize at shipment or delivery depending on your policy, and a buy-online-pickup-in-store order sits somewhere in between depending on how your system is configured. Treating all three as though they post on the same day overstates or understates revenue depending on which channel is growing fastest that month.

A Return Processed In-Store for an Online Order Complicates the Deposit Tie-Out

A customer who buys online and returns the item at a physical store creates a transaction that touches two different systems, the online order record and the in-store POS return, and the two need to agree on both the amount and which channel absorbs the reversed revenue. A store's daily deposit total won't include cash for that return since no cash changed hands at the register, but the POS journal often still logs a return transaction, so a deposit-to-POS tie-out that doesn't account for this specific transaction type will show a variance that has nothing to do with a counting error at the store.

A Worked Example Across Ten Stores

Say each of ten stores runs a small, genuinely random cash variance of ten or twenty dollars a day, that nets out to close to zero across the chain most months, easily written off as noise. Now say one store is consistently forty dollars short every day while the others net out fine. Reviewing the cash-over-short account only in total across all ten stores hides that one store entirely; reviewing it by location surfaces it within the first week.

Review cash variances this way each month:

  1. Tie each store's deposit slip to its point-of-sale journal and to what the bank actually received.
  2. Decide whether each gap is a timing issue, a counting error or something worse before writing it off as immaterial.
  3. Review the cash-over-short balance by location, not only in total across the chain.
  4. Assign a finance reviewer, not the store manager, to follow up on any store with a persistent one-directional variance.

FloQast for a Brand With a Handful of Locations

A brand running a manageable number of physical locations, where a reviewer can check each store's deposit-to-POS-to-bank tie-out by hand within the close window, does well on FloQast's checklist model to enforce that review consistently every cycle.

BlackLine Once Store Count Makes Per-Location Review Impossible by Hand

A brand running enough locations that manually tying out deposits, POS data, and bank activity for every store each month becomes the actual bottleneck benefits from BlackLine's stronger matching. Retailers in this general category run accounts payable of roughly 43.4 days on average1, a useful cross-check when a store's vendor payment pattern looks unusual alongside its cash variance.

Bringing a New Store Manager Up to Speed on Deposit Discipline

A newly opened location's manager needs an explicit walkthrough of the deposit and cash-handling process in the first week, not a general employee handbook reference. Pair that conversation with the actual deposit slip and POS report from a real recent day at another store, so the new manager sees exactly what a correctly reconciled day looks like before they're responsible for producing one themselves.

Executive Capability Standard

What Good Looks Like

A well-run omnichannel retail close ties out every store's deposit against its POS journal and bank statement, reviews the cash-over-short account by location rather than only in total, and recognizes each channel's revenue on its own timetable.

Building The Capability (5-Stage Skill Ladder)

1. Learn:List every store location and its cash-over-short running balance for the past three months.
2. Do Manually:Reconcile deposit, POS, and bank data by hand per location for two cycles before automating.
3. Delegate:Assign one reviewer ownership of the per-location cash reconciliation, separate from store operations management.
4. Automate:Move per-location and per-channel reconciliation into FloQast or BlackLine based on store and channel count.
5. Buy:Add dedicated retail point-of-sale reconciliation software once store count outgrows what a general ledger checklist can track.

How to Get Started

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Frequently Asked Questions

Who should own resolving the cash-over-short variance?

A designated finance reviewer, not the store manager whose till the variance came from. Reviewing it by location rather than only in aggregate is what actually surfaces a persistent, one-directional pattern at a single store before it becomes a larger problem.

Should each channel's revenue post on its own day or all at month-end?

On its own day, following each channel's actual recognition point, point of sale for in-store, shipment or delivery for online. Batching everything to post at month-end regardless of channel makes the monthly trend harder to read accurately.

How many stores before BlackLine makes sense over FloQast?

Once per-location tie-outs of deposits, POS data, and bank activity consistently take longer than a reviewer can complete inside the close window, that operational strain is the more honest signal than any specific store count.

Sources

Where we quote a benchmark, we show its source. Other figures in this guide are estimates or general guidance, so check them against your own numbers.

  1. Payables days (AP/Sales x 365) by industry (US). NYU Stern (Aswath Damodaran), Working Capital Ratios by Industry, US, 2026.

Related Guides