How to Do Bookkeeping for a Retail Store

Retail bookkeeping looks simple from the outside. You buy products, you sell products, you keep the difference. Then you try to figure out why your POS says you made $42,000 last month but your bank account doesn’t agree, and suddenly it’s not simple anymore.  Retail has a few moving parts that most bookkeeping guides skip: inventory, cost of goods sold, sales tax, card processor fees, returns, and the occasional missing item off a shelf. Get those right and your books tell you exactly how the store is doing. Get them wrong and your profit number is basically a guess.  This guide covers what’s different about bookkeeping for a retail store, and how to handle each piece.

How do you do bookkeeping for a retail store? 

To do bookkeeping for a retail store, record every sale from your POS system, track inventory purchases and stock levels, and calculate cost of goods sold so you know your true profit margin. Reconcile your POS reports against bank deposits and card processor payouts, collect and file sales tax on schedule, and record returns, discounts, and shrinkage. Most stores need a daily sales check, a weekly reconciliation, and a monthly inventory count and close

What makes retail bookkeeping different?

If you’ve read our guide on how to do bookkeeping for a small business, you know the basics: separate accounts, good software, and monthly reconciliation. Retail adds five things on top: 

• Inventory. You’re holding money on shelves, and it has to be tracked. 

• Cost of goods sold (COGS). Your real profit depends on what your products cost you, not just what you sold. 

• High transaction volume. Lots of small sales instead of a few big invoices. 

• Sales tax. You collect it from customers and owe it to the state. 

• Payment timing. Card sales don’t land in your bank the same day, and fees come out first. 

Each one is manageable once you have a system. 

Step 1: Connect your POS system to your accounting software 

Your point-of-sale (POS) system is where retail bookkeeping starts. Every sale, return, discount, and payment type gets recorded there.  Connect your POS to your accounting software, such as QuickBooks Online or Xero, so daily sales summaries flow in automatically. Most popular retail POS systems offer an integration or a connector app.  A tip: import daily summaries, not every individual sale. Hundreds of tiny transactions clutter your books. One daily entry, broken down by sales, sales tax, discounts, and payment type, is much easier to reconcile. 

Step 2: Choose how you’ll track inventory 

Inventory is usually a retail store’s biggest asset, so it needs careful tracking. You’ll make two choices.  Perpetual or periodic? 

• Perpetual inventory updates stock levels in real time as you buy and sell. Most modern POS systems do this automatically. It’s more accurate and shows you what’s running low. 

• Periodic inventory means counting stock at set intervals, like monthly or yearly, and calculating what was sold. It’s simpler but gives you less visibility between counts. 

Which costing method? 

• FIFO (first in, first out) assumes the oldest stock sells first. It’s the most common method and matches how most shops actually sell. 

• Weighted average uses the average cost of all units in stock. It’s useful when costs change often. 

• LIFO (last in, first out) assumes the newest stock sells first. It’s less common and has special tax rules. 

Whatever method you choose, stick with it. Changing methods affects your tax reporting, so talk to your CPA first. 

Step 3: Calculate cost of goods sold 

This is the number that tells you whether your store is actually profitable.  COGS = Beginning inventory + Purchases − Ending inventory  For example, suppose you started the month with $20,000 in inventory, bought $8,000 more, and ended with $18,000 on hand. Your COGS for the month is $10,000.  If you sold $25,000 that month, your gross profit is $15,000, a 60% gross margin.  Without COGS, your profit and loss statement just shows sales minus expenses, which can make a struggling store look healthy. With it, you can see which months, products, and categories actually make money. 

Step 4: Reconcile POS sales with your bank 

This is where retail books usually go wrong. Your POS says one thing, your bank says another, and the gap is hard to explain.  The gap usually comes from: 

• Card processor fees, which are deducted before the money reaches you. 

• Payout timing. Friday’s card sales might not arrive until Monday or Tuesday. 

• Cash. Cash sales only show up when you deposit them. 

• Refunds and chargebacks, which come out of later payouts. 

How to reconcile: 

1. Compare your POS daily sales report with your card processor’s payout report. 

1. Record processor fees as an expense, not as reduced sales, so you can see what payments really cost you. 

1. Match each payout to the bank deposit it belongs to. 

1. Count the cash drawer daily, record any overage or shortage, and match cash deposits to the bank. 

Do this weekly at minimum. Monthly is too long. By then, small gaps have stacked up into a mystery. 

Step 5: Handle sales tax correctly 

Sales tax isn’t your money. You collect it from customers and pass it to the state, so it should never be counted as revenue. 

• Record sales tax as a liability when you collect it, separate from sales. 

• Set your POS to charge the right rate for your location, and update it when rates change. 

• File and pay on your state’s schedule, which may be monthly, quarterly, or annually depending on how much you collect. 

• Set the money aside. A separate savings account for sales tax stops you from accidentally spending it. 

• Check your online sales. If you also sell online, you may owe sales tax in other states once you pass their thresholds. Ask your CPA whether that applies to you. 

Step 6: Record returns, discounts, gift cards, and shrinkage 

These smaller items add up quickly in retail.  Returns and refunds should reduce your sales, and returned items that can be resold should go back into inventory.  Discounts and promotions should be tracked separately from full-price sales, so you can see what your promotions actually cost you.  Gift cards are not sales when you sell them. They’re a liability until the customer redeems them, because you owe that customer products.  Shrinkage is inventory you’ve lost to theft, damage, or errors. You’ll find it when your physical count is lower than your records. Record it as an expense, and if it keeps growing, look into why. 

Step 7: Track vendor bills and purchases 

Retailers deal with a lot of suppliers. Record every purchase order and vendor bill as it arrives, match it against what you actually received, and pay on time. Late payments can cost you early-payment discounts and good relationships with suppliers.  If you’re juggling a lot of vendors, accounts payable support can take this off your plate. 

Your retail bookkeeping checklist 

Daily 

• Close out the POS and review the daily sales report 

• Count the cash drawer and record any over or short 

• Deposit cash regularly 

Weekly 

• Reconcile card processor payouts against POS sales and bank deposits 

• Enter vendor bills and schedule payments 

• Review low-stock items and reorder 

Monthly 

• Count inventory, or at least spot-check high-value items 

• Calculate COGS and review gross margin 

• Reconcile every bank and credit card account 

• Review your profit and loss statement and balance sheet 

• File sales tax, if you’re on a monthly schedule 

Yearly 

• Do a full physical inventory count 

• Write off obsolete or damaged stock 

• Prepare your books for your CPA 

Common retail bookkeeping mistakes 

• Counting sales tax as income. It inflates your revenue and leaves you short when the tax bill is due. 

• Recording card deposits as sales. Deposits are net of fees, so your sales and your fees both end up wrong. 

• Skipping inventory counts. Without them, your COGS and profit are estimates. 

• Treating gift card sales as revenue. That money isn’t earned until the card is used. 

• Ignoring shrinkage. Small losses grow quietly when nobody’s tracking them. 

• Reconciling only once a month. Retail moves fast, so small gaps become big ones. 

When to get help with retail bookkeeping 

Retail books get complicated quickly, especially once you have hundreds of products, multiple payment methods, or more than one location. If you’re spending hours every week reconciling POS reports, or you’re not sure your margins are right, it’s worth bringing in help.  At BookkeeperLive, we handle bookkeeping for retail businesses, including POS reconciliation, inventory tracking, and monthly financial reports. Plans start at $75 a month. Not sure what’s included? Our guide to bookkeeping services for small business breaks it down.  Contact Us 

Frequently asked questions 

What is the best accounting method for a retail store? 
Many retailers use accrual accounting because it matches inventory costs to the sales they relate to, which gives a clearer picture of profit. Smaller stores may be able to use cash basis for taxes. Your CPA can tell you which method fits your situation.   How often should a retail store count inventory? At least once a year for a full count. Many stores also count monthly, or spot-check high-value and fast-moving items weekly, to catch shrinkage early. How do I calculate cost of goods sold for a retail store? Add your beginning inventory to your purchases for the period, then subtract your ending inventory. The result is your cost of goods sold.  Should card processor fees be recorded as an expense?  Yes. Record the full sale amount as revenue and the processor fees as a separate expense. That way, both your sales and your payment costs are accurate. Is sales tax considered revenue?  No. Sales tax is money you collect on behalf of the state, so it’s recorded as a liability until you pay it.  How do I record gift card sales? 
Record them as a liability when sold, and move the amount to revenue when the customer redeems the card.