# Retail Store Bookkeeping: Card Batches and Inventory

- Author: AutoBankConvert (https://www.autobankconvert.com)
- Published: 2025-03-11
- Updated: 2025-03-11
- Category: Industry bookkeeping
- Canonical: https://www.autobankconvert.com/blog/retail-store-bookkeeping

> Retail store bookkeeping: match card batch deposits to daily sales, record inventory purchases and cash deposits, and close each store month on time.
Retail store bookkeeping from bank statements is a daily matching job done monthly. Each card batch deposit is tied to the register day it settles, cash deposits are checked against drawer counts, and supplier payments are coded to inventory rather than expense. Close every store month on a fixed day with the same short step list.

## What does a retail store bank statement look like each month?

A retail store bank statement repeats the same few line types all month: one card batch deposit per trading day, a cash deposit every day or two, supplier payments, rent, payroll drafts and processor fees. The volume is high but the patterns are narrow, which makes a retail client one of the best fits for rules that code lines automatically.

### The repeating lines

For a single store open six days a week, a month's statement often holds:

- **Around 26 card batch deposits**, one for each trading day, sometimes with a weekend batch that combines Saturday and Sunday.
- **Ten to twenty cash deposits**, depending on how often the owner goes to the bank.
- **Supplier payments** by ACH, check or card, for stock and for store supplies.
- **Fixed costs** such as rent, utilities, insurance and the point-of-sale subscription.
- **Payroll drafts** from the payroll provider.
- **Processor fees**, either deducted from each batch or charged as one debit at month end.

### Why the pattern helps

Once the batch description, the cash deposit and each regular supplier have a rule, most lines on a retail statement code themselves every month. The bookkeeper's time then goes to the exceptions: a batch that does not match, a missing cash deposit, a new supplier. That is where the books actually go wrong.

## Matching card batch deposits to daily register sales

A card batch deposit is matched to the register's daily sales report by settlement date and amount. The point-of-sale system closes a batch at the end of each trading day, and the processor deposits it one or two business days later, usually net of fees. The match proves that every day's card sales reached the bank.

### Reading the gap between batch and register

The batch rarely equals the register's card total exactly. The gap usually has one of four causes:

1. **Processing fees** taken out of the batch.
2. **Refunds** to cards processed that day.
3. **Tips** on card payments, in stores that take them.
4. **A missing or combined batch**, when a weekend or holiday rolls two days into one deposit.

Processors and card companies report a store's card receipts to the IRS each year on Form 1099-K. The [IRS guide to understanding Form 1099-K](https://www.irs.gov/businesses/understanding-your-form-1099-k) says a business gets one from its payment card processor no matter how many payments it received. Matching batches monthly is what lets the bookkeeper explain any difference between that form and the store's recorded sales at year end.

### A worked match for four trading days

The table below is an example for illustration; the amounts are made up.

| Register day | Register card sales | Batch deposit | Deposit date | Gap | Explanation |
| --- | --- | --- | --- | --- | --- |
| Mon 3 Mar | 2,140.00 | 2,083.21 | Wed 5 Mar | 56.79 | Fees, per processor report |
| Tue 4 Mar | 1,875.50 | 1,800.33 | Thu 6 Mar | 75.17 | Fees 49.73, refund 25.44 |
| Wed 5 Mar | 2,310.25 | none | none | 2,310.25 | Batch not closed, look for it in Friday's deposit |
| Thu 6 Mar | 1,990.00 | 4,186.29 | Mon 10 Mar | -2,196.29 | Includes Wednesday's batch net of fees |

Wednesday's missing batch and Thursday's oversized one cancel out once the processor report is read. Without the match, Wednesday would look like a lost day and Thursday like a record one.

## Cash deposits and the register drawer count

A cash deposit is checked against the drawer count for the days it covers: opening float, plus cash sales, minus cash paid out, should equal the cash counted at close, and the counted cash minus the float is what should reach the bank. A store that skips this check cannot tell a short drawer from a deposit that never happened.

### Recording cash sales

Book cash sales from the register report for each day, not from the bank deposit. The deposit is the movement of that cash to the bank. If a store records sales only when cash is deposited, a week of unbanked cash disappears from the sales figures, and any shortage hides in the timing.

A clearing account such as "Cash on hand - undeposited" holds each day's cash sales until the deposit lands. At month end its balance should equal the cash still in the safe. If it is higher, cash is missing or a deposit was coded somewhere else.

### Shortages and paid-outs

Small daily shortages and overages are normal and go to a "cash over and short" account. A pattern of shortages on the same shift is a management question, not a bookkeeping one, but the bookkeeper is often the first to see it. Cash paid out from the drawer for small purchases needs a receipt in the drawer, or it becomes an unexplained shortage. The guide to [bookkeeping for cash businesses](/blog/bookkeeping-for-cash-businesses) goes further into deposit discipline for stores that take mostly cash.

## Inventory purchases from vendors on the retail statement

Inventory purchases are payments to suppliers for goods the store will sell. They are coded to an inventory asset account, not to expense, and become cost of goods sold as the stock is sold. Store supplies, such as bags, receipt paper and cleaning products, are expenses. Mixing the two makes the gross margin meaningless.

### Coding supplier payments

Most retail suppliers can be set up with one rule each, because a store tends to buy stock from the same handful of vendors. A few cases need care:

- **One supplier, two purposes.** A wholesale club purchase can include stock and store supplies on one receipt. Split it from the receipt.
- **Deposits on large orders.** A prepayment for seasonal stock that has not arrived is a prepaid asset until the goods are received.
- **Credits and returns to suppliers.** Code these against inventory, not to income.

### Getting to cost of goods sold

How cost of goods sold is calculated depends on the store's inventory method. A store with a point-of-sale system that tracks stock can report cost of goods sold directly. A smaller store may count stock at month end or quarter end and work backwards: opening inventory, plus purchases, minus closing inventory. Either way, the bank statement supplies the purchases, and the count or the system supplies the rest.

## How should a retail store book returns, chargebacks and gift cards?

Returns, chargebacks and gift cards are the retail transactions that move money in the opposite direction or at a different time from the sale. Each one needs its own account so that sales stay a clean figure. Netting them into sales hides how much money the store gives back.

### The three cases

- **Returns and refunds.** Refunds to cards come out of the day's batch. Cash refunds come out of the drawer. Book both to a "sales returns" account and, if the item goes back on the shelf, adjust inventory too.
- **Chargebacks.** A customer disputes a card charge and the processor withdraws the amount, often with a fee. Code the amount to a chargeback account and the fee to processing fees. If the store wins the dispute, the reversal goes back through the same account.
- **Gift cards.** Selling a gift card is not a sale. It creates a liability for goods the store owes. The sale happens when the card is redeemed. Stores that book gift card sales as revenue overstate income in December and understate it in January.

Seasonal timing affects other industries in the same way. [Short-term rental bookkeeping](/blog/short-term-rental-bookkeeping) deals with payments received before the stay, which follow a similar logic to a gift card that has not been spent yet.

## Closing each retail store month on a fixed day

A retail store month closes on a fixed day after month end, often the fifth or seventh business day, so the owner gets the same report at the same time every month. The close is a short, repeatable list, and most of its steps are checks rather than entries.

### Close-week step list

1. Convert the store's bank and card statements for the month and confirm each one passes its balance check.
2. Match every card batch deposit to a register day, including the first days of next month that settle this month's sales.
3. Reconcile the undeposited cash account to the cash in the safe at month end.
4. Review supplier payments and split any mixed receipts between inventory and supplies.
5. Record the inventory count or the point-of-sale inventory report.
6. Book chargebacks, returns and gift card activity from the processor and register reports.
7. Reconcile the bank account and send the owner sales, gross margin and cash position.

[AutoBankConvert](/) can convert a store's statements as soon as they arrive and apply its supplier and batch rules, which leaves the matching and the inventory step for the bookkeeper.

### Taking on more retail clients

Stores in the same town often share an accountant, a supplier or a landlord, which makes retail a natural niche for a practice that wants to grow by referral. The ideas in [marketing for bookkeepers](/blog/marketing-for-bookkeepers) apply well here, because a close that delivers the same report every month is something owners talk about with each other.