The weekly payments review: which reports to check

A weekly payments review takes about twenty minutes and catches most problems before they grow. The payment processing reports worth checking are your batch reports, deposit records, refunds and voids, declined transactions, and any chargeback notices. Looking at them together, once a week, shows you missing deposits, unusual refunds, and rising fees while they're still easy to fix.

Most owners look at payments only when something goes wrong. A short weekly habit flips that.

Which reports should you pull?

Here's a simple list. Your POS and processor portal should have most of these.

1. Batch reports for each day. How much was processed and when each batch closed.
2. Deposit report. What arrived in your bank and which batches it covered.
3. Refunds and voids by employee. Who issued them, when, and for how much.
4. Declines. How many sales were declined and why, if the report shows reasons.
5. Chargebacks and retrievals. Any disputes or requests for information from the card networks.
6. Card mix. How much came from debit, credit, EBT, and eWIC.

If your POS and payments are connected, many of these come from one place. NRS Pay integrates with the NRS POS, which helps line up sales and card data.

What are you looking for in each one?

Batches. Every day should have a closed batch. An open batch means sales haven't settled, and a late batch can cost more.

Deposits. Every closed batch should have a matching deposit, usually within a business day or two. A missing deposit needs a call.

Refunds and voids. Look for unusual patterns. One employee with far more refunds than others. Refunds right after sales. Cash refunds on card purchases.

Declines. A spike in declines might mean a reader problem, a network issue, or card testing if you take any online payments.

Chargebacks. Note every dispute and its deadline. A missed deadline usually means an automatic loss. Investopedia's overview of the chargeback process is a good refresher.

Card mix. A shift toward rewards credit can raise your costs even if sales are flat.

What does a good weekly routine look like?

Pick the same time every week. Monday morning, before the store gets busy, works for many owners.

Open a simple sheet with the week's dates down the side. Add columns for batch total, deposit, difference, refunds, voids, declines, and notes.

Fill it in from your reports. Most weeks, the difference column is small and explained by fees or refunds. Write down anything that isn't.

Here's a hypothetical week. Monday through Sunday batches total $9,400. Deposits total $9,120. Fees account for $240, and one $40 refund explains the rest. Refunds by employee look normal. Declines are low. No chargebacks. Done in fifteen minutes.

Now say the next week shows a $600 gap with no refunds to explain it. You check and find Saturday's batch never closed. You close it, and the deposit arrives Tuesday. Caught in a week instead of a month.

What should you look at monthly?

Once a month, add a few extras.

Calculate your effective rate: total fees divided by total card sales. Track it month to month.

Read your processing statement line by line. Look for new fees or changes.

Review permissions. Make sure former employees no longer have POS or portal access.

Check your PCI compliance status. If a non-compliance fee is showing, finish your annual questionnaire.

If any report is confusing, the NRS Pay team can walk you through it. NRS Pay offers live support seven days a week.