POS Reconciliation & How It’s Done in 7 Steps
This article is part of a larger series on POS Systems.
POS reconciliation is the process of manually checking your POS sales records against your cash on hand and credit card processing statements to ensure there are no discrepancies. Not difficult but often tedious, it is a key part of the cash-handling process and helps prevent chargeback disputes.
Most service and retail businesses will only reconcile their POS at the end of a business day—before credit card transactions are batched and sent to their card processor. High-volume businesses like restaurants, operating with separate teams during different day-parts, typically reconcile at least twice per day. Continue on for our step-by-step guide to POS reconciliation
Using a modern POS to manage your business definitely makes POS reconciliation less of a chore. You can check out our ranking of the best POS systems for small businesses to find your best fit. Though for POS reconciliation, we like Square’s easy-to-read reports, which can really speed up your process.
Step 1: Close All Checks
Before you can begin your reconciliation, you want to be sure that there are no open checks in your register or POS. If you have multiple ticket types that come from phone orders, online sales channels, or different types of on-premise sales, check under all categories. An open check can be one of the first things that will throw off your reconciliation. Restaurants that accept online orders may also want to toggle off incoming orders until the reconciliation is complete.
Step 2: Gather the Materials You’ll Need
To start, you’ll need the day’s (or shift’s) POS sales transactions. The name of this report will vary by POS brand; most will call it an end-of-day register, cash report, transaction report, or Z report. You’ll also need credit card processing batch statements, your cash drawer at the ready for counting, and receipts or logs from any cash paid into or out of the till throughout the day. Most modern POS systems prompt your staff to enter pay-ins and pay-outs as they process them in and log them all on an easy-to-read report.
Square’s cash drawer report makes it clear how much cash to expect at the end of the day. (Source: Square)
What are pay-ins and pay-outs?
Pay-ins and pay-outs are non-sales-related cash amounts that are added or removed from the till during a shift. Pay-ins usually happen on busy days when the tills are running low on small bills and coins, so you add more cash to make change. Pay-outs commonly happen when a manager removes large bills to place in the safe, a cash tip is paid to a staff member, or petty cash is disbursed.
If your business is a bar or restaurant where several cash-handling employees hold on to cash transactions outside of a till, you’ll reconcile their cash and credit card payments using their individual shift reports. But, other than the report you use, the reconciliation process will be the same.
Step 3: Compare Card Transactions to Statements & Note Discrepancies
Look through your POS’s detailed transaction lists for each sale or refund for the period you’re reconciling. Cross-reference with your credit card batch statements and mark them if they match. If they don’t line up, make a note of it.
Step 4: Compare Cash Transactions to Cash on Hand & Note Discrepancies
Add up all the cash sales for the day or shift and compare the total to the actual cash you have in the register. As we note in the best practices below, it’s good to start each day with the same amount of cash because it will be easier to reconcile cash transactions. Note any discrepancies you see. These could be simple errors in change counting, or they could reveal a pattern of theft.
Always count cash behind a locked door. You might take tills to the back office (if you have one) to audit or lock your customer entrance until your count is complete. You never want to leave an open till on the sales counter while you tend to a customer or a staff issue. If you are alone in your building or close late in the evening—like a convenience store or nightclub—you should put two locked doors between your cash and the street.
Step 5: Correct Any Obvious & Reparable Errors
This is where a bit of detective work comes in. Not every discrepancy will have a clear reason or fix. Each business is different, but by reconciling your POS every day, you’ll notice patterns in overages and know how to reconcile them.
In spas, restaurants, or other tip-handling businesses, a $20–$40 card charge not associated with a specific transaction (and therefore showing as a cash overage) might be a tip that needs to be distributed to an employee. If you permit customers to add valet charges to their checks, overages might be cash that is owed to the valet service. Businesses that accept personal checks from customers might see a shortage of cash if a check got lodged at the back of the register drawer.
Depending on your POS system, you may have the ability to adjust credit and debit card transactions until the end of the business day. Many POS systems don’t send your credit card transactions to the bank the moment they are tapped, dipped, or swiped. Instead, those transactions are pre-approved and “batched.” So, POS users typically have time to correct credit and debit charges until the batch is finalized and sent to your processor.
Your credit card batch typically finalizes automatically when you run the end-of-day process in your POS. The sooner you spot errors like overcharges, double charges, or misentered tip amounts, the easier it is to reconcile them. This is your chance to correct these erroneous charges before a customer calls you to complain of an overcharge (or worse still, initiates a chargeback dispute).
Speaking of chargebacks: If you are using a POS, be sure that your credit cards are clearly processed under your business name, otherwise you’ll get a lot of confused customers initiating disputes when they see the phrase “POS” on their bank statement. POS is a common phrase in the retail and restaurant world, but can be confusing to customers.
Step 6: Create a Log for Each POS Reconciliation Session
This log can be a simple sheet of paper that you use every day to note the day’s POS reconciliation. Be sure to note the date, any discrepancies, and the totals for credit card statements and cash sales. You should organize the reports you used to perform your reconciliation neatly with this log so there is a clear record if questions arise. Your bookkeeper or accountant will be eternally grateful. And, if there are any unresolved errors, they will have all the relevant information to help you solve them.
Step 7: Provide POS Reconciliations to an Accountant or Tax Professional
Keep your POS reconciliation documents neatly filed and close at hand for at least a year. Your accounting professional may request your logs regularly or when it’s time to handle taxes. Provide them when needed.
Tip: You can keep your end-of-day reports and reconciliation logs neatly stored in a binder with a sheet protector for each day’s documents. If you want, you can even store deposit slips or any receipts from petty cash purchases as well. Bars and restaurants that have lots of daily POS reconciliations may prefer bank boxes. Keep these records in a locked safe or filing cabinet.
Benefits of Performing POS Reconciliation
One of the best features of a POS system is that it automatically produces analytics and reports to give you clear insight into your business’ health. So, why do the manual process of POS reconciliation? When you cross-reference each transaction with your POS logs, you’ll have a better understanding of your business needs and prevent long-term accounting errors.
Here are six of the biggest benefits of POS reconciliation:
Alerts you to accounting errors
Keeping your books accurate is vital. Each time you compare your transactions and cash-on-hand with your POS reports, you’ll be able to identify discrepancies—and possibly find patterns, so you can stop the errors.
Secures cash deposits
You need to know how much cash you deposit every day. Balancing each POS daily ensures that your daily deposit amounts are accurate. If you discover a mistake after you deposit your cash, it’s a much bigger headache to correct it.
Saves money in the long term
A large percentage of chargebacks (15%–35%) are due to merchant error. If you made the error, you cannot dispute the chargeback. At $25–$100 per chargeback, plus the lost revenue and processing fees, this can add up. You can save yourself time and money by performing daily audits.
Keeps you informed of overall business health
Aside from simply catching errors and unauthorized transactions, regular reconciliation can give you a clearer picture of your business and how it’s performing. You’ll become familiar with hot-selling items and each day’s sales volume, so you can make better-informed decisions for your business.
Highlights employee performance
POS reconciliation will help you see which of your employees are your top sellers. On the flip side, you’ll also be able to tell who’s making mistakes with cash or possibly identify thieves among your workforce.
POS Reconciliation Best Practices
If you haven’t been performing regular POS reconciliation, it’s OK. You’re committing to doing it now, and it’s important that you follow a few best practices for POS reconciliation. These tips will help ensure your books are accurate and you’re not losing money.
- Use integrated credit card processing: When you use the best POS hardware, you should see few errors because they typically include integrated payment processing terminals. The fewer tasks employees have to do manually, the fewer errors you’ll see.
- Limit one employee per till: If you designate one employee per register, it’ll be easier to identify issues when you do POS reconciliation. If you have more employees than registers, look for a POS system that supports dual cash drawer tills. This allows you to assign individual cash drawers to staff who use the same register. Or, in the case of a bar or restaurant, ensure that all employees have their own login code to use when processing transactions.
- Have a manager conduct audits: As the owner, you could perform POS reconciliation, or you could assign the task to a manager, department head, or even your accountant.
- Open with the same amount of cash every day: Start each day with the same amount of cash on hand and the same amount of cash in each till. This makes it much easier to spot overages and other errors at the end of the day or shift.
- Tailor procedures to your business: Small retailers and service businesses may review all the day’s transactions on a single transaction report. Restaurants and retailers with multiple tills and cashiers, however, will typically audit their cash and credit card transactions by staff member. This breaks up the reconciliation tasks into smaller chunks throughout the day, as you’ll reconcile each POS and till as your payment-processing staff members complete their shifts and clock out.
- Be consistent: If you want to do daily POS reconciliation, don’t skip a day. Smaller businesses that process fewer payments may opt to reconcile weekly, bimonthly, or monthly.
Bottom Line
When you regularly compare your expected sales (those in your POS software) to the actual numbers from your credit card processing statements and cash drawers, you’re warding off potentially big accounting errors. You could spot patterns of theft or small discrepancies that, over time, add up to significant losses.
Performing POS reconciliation may be one of the more mundane tasks of a business owner’s life, but it’s also rewarding. You’ll have better insight into your business’ health and see who’s excelling or struggling with sales, what’s selling and what isn’t, and, possibly, what’s slowly picking at your profits. By regularly absorbing all the transaction data, you’ll be able to make better-informed decisions for your business.
You May Also Like …
- Is your POS easy to use, or are you ready to throw it out the window? Consider switching to one of the best POS systems on the market.
- Want to make more sales? Of course you do. Learn how your retail analytics reports can help you drive sales.
- Worried about data breaches? With top-notch POS security, you’re mostly protected, but there are a few things you should be doing to ensure customer data stays safe.