! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.

Go to Index or search here


POS and Card Payment Accounting Controls for Retail MSMEs: How to Close the Day Accurately and Prevent Mismatches

⬟ Intro :

A small MSME electronics accessories retailer in Ahmedabad, Gujarat noticed month-end accounts never matched the sales records. POS card sales: Rs. 4.68 lakh. Bank credits from EDC settlement: Rs. 4.51 lakh. Rs. 17,000 unexplained. The CA identified three causes. EDC MDR charges of Rs. 8,400 had not been recorded as expenses. Two last-day transactions had settled in the following month (Rs. 6,200 timing difference). One double-billed transaction of Rs. 2,400 had been refunded to the customer but neither the original nor the refund had been entered in Tally. None were fraud. All were accounting process failures, each preventable with a ten-minute daily closing routine.

For a retail business, the daily POS closing is the single most important accounting control. Every day's sales flow through the POS in three or four payment modes: cash, card (credit and debit), UPI, and credit accounts. If the day is not closed and reconciled before the next day opens, mismatches accumulate. By month-end, the differences can be substantial and the cause of each one is harder to trace. Daily reconciliation also protects against two risks that every retail MSME faces: employee cash handling errors and billing system errors. Both are caught immediately when the day-end closing is done correctly. Both can go undetected for weeks when it is not.

This article covers how POS card settlements work, what causes daily mismatches, how to build a ten-minute daily closing routine, and how to record POS settlements correctly in the accounts.

⬟ How POS Card Settlements Work in Indian Retail :

A POS terminal in an Indian retail MSME is typically an EDC (Electronic Data Capture) machine from the merchant's bank or a third-party provider (Pine Labs, Paytm for Business, Mswipe, PayWorld). When a customer pays by card, the transaction is authorised, and the net amount (after MDR deduction) is settled to the merchant's bank on a T+1 or T+2 cycle. UPI QR payments settle through the payment app's merchant dashboard (Paytm, PhonePe, Google Pay for Business) or the bank's UPI settlement mechanism, typically on T+0 or T+1. Three amounts matter for daily POS reconciliation: Gross sales: total card and UPI transactions recorded in the billing system or EDC machine report. MDR deduction: the bank or gateway fee per transaction, deducted before settlement. Card MDR: 0.4% to 2.5% depending on card type. UPI above Rs. 2,000: 0.25% to 0.40%. UPI under Rs. 2,000: zero MDR. Net settlement: gross sales minus MDR, deposited to the merchant's bank on the settlement date.

A small MSME clothing retailer in Jaipur, Rajasthan closes the POS daily at 9 PM. Tuesday's transactions: Cash sales: Rs. 12,400 Card sales (debit and credit): Rs. 18,600 UPI sales: Rs. 8,200 Credit account sales (to known customers): Rs. 3,800 Total sales per POS: Rs. 43,000 Daily closing check: Cash counted in till: Rs. 12,350 (Rs. 50 short, noted as petty cash difference) EDC machine batch total for Tuesday: Rs. 18,600 (matches POS) UPI merchant app total for Tuesday: Rs. 8,200 (matches POS) Credit account invoices raised: Rs. 3,800 (matches POS) Accounting entries: Debit Cash Rs. 12,350, Short/Over Rs. 50, Credit Sales Rs. 12,400 Debit EDC Receivable Rs. 18,600 (net settlement expected tomorrow minus MDR approximately Rs. 18,320 plus MDR Rs. 280), Credit Sales Rs. 18,600 Debit UPI Receivable Rs. 8,200, Credit Sales Rs. 8,200 Debit Debtors (credit customers) Rs. 3,800, Credit Sales Rs. 3,800 When bank credit arrives from EDC settlement: Debit Bank Rs. 18,320, Debit MDR Charges Rs. 280, Credit EDC Receivable Rs. 18,600.

⬟ Why the Daily POS Close Is the Foundation of Retail Accounting Accuracy :

A daily POS close produces three measurable benefits. The first is immediate discrepancy detection. A cash shortage, a card terminal batch mismatch, or a UPI settlement failure is caught the same day. The day's transaction list is short, the staff can be questioned, and the cause is usually traceable within minutes. The same discrepancy found a week later may be untraceable. The second is accurate daily revenue recognition. Each day's sales entered in Tally the same day produces a P&L reflecting actual daily sales, not cash received (which lags by one or two days for card settlements). Revenue is recognised when the sale is made, not when the EDC credit arrives. This matters for GST: the liability arises at the time of supply. The third is clean month-end accounts. When every day has been reconciled, the month-end close is a consolidation of thirty daily records rather than a month of unresolved differences.

A micro MSME pharmacy in Chennai, Tamil Nadu implemented a daily closing checklist after the CA found cash sales being booked inconsistently. After three months of daily reconciliation, the owner identified that cash was consistently Rs. 400 to Rs. 800 short against the billing software total. Investigation showed the billing software was counting advance deposits from customers placing orders as current-day revenue. The setting was corrected and daily cash reconciliation became clean. A small MSME multi-brand clothing store in Ludhiana, Punjab checked the EDC batch total against the POS billing total each evening. In Month 2, a Rs. 3,200 mismatch appeared: the EDC batch showed one transaction not in the POS. A staff member had processed a card test transaction and voided the sale in POS without voiding the EDC charge. The customer's card was charged but no product was given. The charge was reversed promptly. Without the daily close, this would have been undetected until the customer raised a dispute.

For micro and small retail MSME owners, the daily POS close is the most direct connection between sales operations and the accounts. An owner who verifies the daily close personally (even briefly) has a real-time feel for the business's revenue and immediately notices when something is off. For the CA advising a retail MSME, a business that maintains daily POS reconciliation records is significantly easier to audit and produces cleaner monthly accounts. For lenders reviewing a retail MSME's financial health, consistent daily POS reconciliation records demonstrate operational discipline.

⬟ How Micro and Small Retail MSMEs Currently Handle POS Accounting :

Most micro retail MSMEs in India operate a simplified cash accounting system: cash and UPI receipts are counted at day end, compared to a rough total from memory or a paper tally, and any difference is absorbed as unexplained. Card settlements are booked when the bank credit arrives, not on the day of sale, and MDR deductions are never recorded as separate expenses. A smaller proportion of growth-stage small retail MSMEs use a billing software (Marg, Busy, Gofrugal, or similar) that produces an end-of-day report. These businesses are better positioned to do daily reconciliation but often do not use the report systematically for matching to cash counts, EDC batch totals, and UPI settlements. Formal daily POS reconciliation, with written records of each payment mode's daily total, physical cash count, and accounting entries in Tally, is the practice of well-managed retail MSMEs that have engaged a CA for monthly accounts.

⬟ How POS Technology Is Simplifying Retail Accounting for MSMEs :

Smart POS systems that integrate billing, inventory, and payment settlement are becoming more accessible at the micro and small MSME level. Providers including Pine Labs, Paytm for Business POS, and Mswipe offer POS terminals that generate daily settlement reports in downloadable formats, reducing the manual effort of matching EDC batch totals to billing system totals. Several accounting software providers are developing direct integrations with POS systems. Busy Accounting, Marg ERP, and Gofrugal already offer POS billing modules that connect to Tally or generate Tally-compatible exports. As these integrations mature, the daily POS-to-accounting entry process will become partially automated, reducing the manual effort of daily closing while maintaining the accuracy of individual transaction records.

⬟ The Three-Part Daily POS Reconciliation :

The daily POS close has three components. Cash reconciliation: Count physical cash in the till. Compare to the billing system's cash sales total. Differences above Rs. 200 require investigation. Small differences (under Rs. 100) are recorded as petty cash variance. Card and UPI reconciliation: Print the EDC machine batch settlement report and compare the total to the billing system's card sales. Check the UPI merchant app total against the billing system's UPI sales. All three amounts should match for each payment mode. A difference indicates a transaction processed on the terminal but missing from billing, or in billing but not on the terminal. Credit account reconciliation: List all credit sales to account customers. Verify each has an invoice in the billing system and that the total matches the debtors entered in Tally. This prevents informal credit without a formal invoice.

● Step-by-Step Process

At closing time, run the end-of-day report from the billing software. This shows total sales by mode: cash, card, UPI, credit account. Count physical cash in the till. Deduct the opening float. The remainder should equal the cash sales total from the billing report. Press the Settlement or Batch Close button on the EDC terminal to print the batch report. The batch total should match the card sales total in the billing system. Check the UPI merchant dashboard (Paytm for Business, PhonePe for Business, Google Pay Merchant) for the day's total. This should match the UPI sales in the billing system. Note any differences per payment mode. Investigate cash differences above Rs. 200 and card or UPI differences of any amount before the next day opens. In Tally, pass the daily sales entry: credit Sales, debit Cash (physical count), debit EDC Receivable (card total), debit UPI Receivable (UPI total), debit Debtors (credit sales). Record cash short or over to a petty variance ledger. When the EDC bank credit arrives (T+1 or T+2): debit Bank (net settlement), debit MDR Charges (fee deducted), credit EDC Receivable (gross card amount).

● Tools & Resources

Most EDC terminals (Pine Labs, Paytm POS, Mswipe, bank-issued terminals) print a daily batch settlement report at the end of the day or when the Settlement or End of Day function is used. Retain a printed copy of this report each day and file it with the daily cash count record. Billing software including Marg ERP, Busy, Gofrugal, and Vyapar generate end-of-day sales summary reports by payment mode. Tally Prime supports both a Cash Ledger and configurable receivable accounts (EDC Receivable, UPI Receivable) that can be reconciled against the daily billing reports and bank credits.

● Common Mistakes

Booking the EDC settlement bank credit as revenue is the most common error. It shifts revenue recognition from the date of sale to the date of bank credit, understates the EDC receivable balance, and produces wrong GST liability timing. GST on a card sale is due on the date of supply, not when the bank credit arrives. Not recording MDR as a separate expense is the second mistake. When Rs. 18,320 arrives for Rs. 18,600 of card sales, many owners book Rs. 18,320 as revenue. The Rs. 280 MDR disappears as an unexplained difference. MDR is a legitimate expense and must be recorded separately. Not printing and filing the daily EDC batch report is the third mistake. Without it, there is no independent record of what the terminal processed. A mismatch discovered later cannot be investigated without the batch report. Some EDC terminals purge batch data after 30 days.

● Challenges and Limitations

Multi-terminal retail stores (with two or more EDC machines at different counters) require the daily batch reports from each terminal to be printed and reconciled separately. Combining all terminals into a single total without verifying each terminal individually makes it harder to isolate the source of a mismatch. Some EDC machines, particularly older bank-issued terminals, do not produce itemised batch reports showing individual transactions: they show only a total. For these terminals, the only way to investigate a mismatch is to match the total against the billing system's card transaction list one by one, which is more time-consuming. Replacing older terminals with modern smart POS terminals that provide itemised reports and digital exports is worth the switch for retail MSMEs processing significant card volumes.

● Examples & Scenarios

A small MSME hardware and paint retailer in Nagpur, Maharashtra introduced a physical daily closing register: one page per day with rows for Cash, Card, UPI, and Credit Sales, and columns for Billing System Total, Physical/Terminal Count, and Difference. The owner signed the register each evening. Month 1: differences found on 8 of 30 days, ranging from Rs. 50 to Rs. 1,400. Month 3: differences on only 2 days, both under Rs. 100. The register created accountability and eliminated routine cash rounding by staff. A micro MSME mobile accessories kiosk in Coimbatore, Tamil Nadu used Paytm for Business as the sole payment method. Daily reconciliation: total Paytm merchant dashboard credits should equal total Paytm sales in the billing app. In Month 2, a Rs. 850 difference appeared: two transactions successful in the customer's app but not in the merchant dashboard. Paytm support confirmed these were T+1 settlements. The owner adjusted the daily close to account for Paytm's occasional next-day settlement for certain transactions.

● Best Practices

Assign one person as responsible for the daily close at a fixed time each day. The close should not be left to whoever is available: consistent execution by the same person is the foundation of effective control. Keep the opening float at a fixed, documented amount, counted and confirmed at the start of each day. This makes cash reconciliation simple: physical cash count minus opening float should equal the day's cash sales per the billing system. Maintain a weekly reconciliation of the EDC Receivable ledger in Tally against the pending settlement amount in the bank's EDC portal or payment provider's dashboard. The Tally balance should equal the provider's pending settlement. Any unexplained difference is a discrepancy requiring investigation.

⬟ Disclaimer :

This content is intended for informational and educational purposes only and does not constitute professional accounting or business management advice. POS terminal features, MDR rates, and settlement timelines described are general practices of common Indian payment providers and may vary by provider, terminal type, and merchant agreement. MSME owners should verify current rates and features with their payment provider and work with a qualified chartered accountant for guidance on POS accounting controls appropriate for their specific retail setup.


⬟ How Desi Ustad Can Help You :

Start the daily close tonight. At the end of business today, run the end-of-day report from the billing software. Count the physical cash (minus the opening float). Print the EDC batch report from the terminal. Check the UPI merchant dashboard total. Write down all four numbers: billing system cash total, physical cash count, EDC batch total, and UPI dashboard total. Note any difference in each. If all four match (within a small petty variance for cash), the day is clean. If they do not match, find the specific transaction that caused the difference before opening tomorrow. Do this every day for one month. The daily closing habit will reveal every process gap in the retail cash and card handling, and fixing each one will improve both the accuracy of the accounts and the security of the business.

Register your business with our online directory or join our bidding platform.

Frequently Asked Questions (FAQs)

Q1: What is the difference between an EDC batch report and a bank settlement statement?

A1: A mismatch between the EDC batch report and the bank settlement statement can occur for three reasons. First, the MDR deducted in the bank settlement is higher or lower than expected, indicating either a rate error or a different card category than anticipated (premium cards attract higher MDR than standard cards). Second, a transaction in the EDC batch was declined or reversed after the batch was closed, reducing the settlement amount below the batch total. Third, a technical failure caused the batch transmission to the acquiring bank to be incomplete, and some transactions in the

Q2: What should a retail MSME do if a customer says their card was charged but the transaction did not appear in the billing system?

A2: The root cause of card charged but not in billing is almost always a disconnected POS: the EDC terminal and the billing software are separate systems, and a transaction may complete on the terminal (charge authorised) while the billing software failed to record it due to a network dropout, a software crash, or the staff pressing the wrong button after the card swipe. For retail MSMEs, the most reliable prevention is a POS system where the billing software initiates the card charge (integrated POS) rather than a separate card swipe on an EDC terminal followed

Q3: How should a retail MSME record a card refund in Tally?

A3: GST treatment of card refunds at retail: when a sale is reversed by a refund, the output GST on the original sale must be reversed through a credit note issued to the customer under Section 34 of the CGST Act. For retail businesses issuing B2C invoices (invoices without the customer's GSTIN), the credit note is reported in GSTR-1 as a B2C credit note. The credit note reduces the net taxable supplies and the net output tax in the month it is issued. For retail MSMEs using a POS billing system that generates GST-compliant invoices, the

Q4: What is an opening float and how should it be managed for retail cash reconciliation?

A4: Opening float management becomes important when multiple staff members have access to the till. Without a documented float, it is impossible to know whether a cash shortage reflects missing sales or a lower-than-expected opening float. Best practice for retail MSMEs with more than one cashier: the incoming cashier counts the till at the start of the shift and confirms the float amount on a handover record before accepting responsibility for the till. Any float discrepancy at handover is the responsibility of the outgoing cashier to explain. This handover control, combined with the daily closing reconciliation,

Q5: How should UPI payments be reconciled for a retail MSME?

A5: A practical complication for retail MSMEs is that many customers use different UPI apps (PhonePe, Google Pay, Paytm, BHIM) to pay to the same merchant UPI ID. From the merchant's perspective, all of these payments arrive in the same merchant UPI account and appear in the same merchant dashboard, regardless of which app the customer used. The merchant does not need to reconcile by customer's UPI app, only by the total received in the merchant account. However, if the merchant has multiple QR codes (for example, a Paytm QR and a BharatPe QR at the

Q6: What GST implications arise from POS card sales in a retail MSME?

A6: For retail B2C businesses, GST invoicing requirements are simpler than B2B. A B2C invoice (sold to a consumer without a GSTIN) does not need to show the customer's name or address for invoices below Rs. 2.5 lakh. However, the invoice must still show the GSTIN of the seller, the invoice date, the item or service description, the taxable value, and the GST rate and amount. POS billing systems used by retail MSMEs (Marg, Gofrugal, Busy, Vyapar) typically generate GST-compliant B2C invoices automatically from the sales entry. The GST invoice data from the billing system is

Q7: How should a retail MSME handle a situation where the EDC terminal is offline and card transactions are processed in offline mode?

A7: From an accounting perspective, offline card transactions should not be recorded as confirmed revenue until the terminal has successfully transmitted them and the transactions have been accepted by the bank. A practical approach: offline transactions processed during a connectivity outage are noted separately on the day's cash sheet as pending. When connectivity is restored and the terminal transmits the batch, the accepted offline transactions are confirmed and added to the day's sales. Any rejected offline transactions (card declined post-transmission) are removed from the sales record and, if the customer has already received the goods or

Q8: How can a retail MSME tell if its MDR rates are correct on the EDC settlement?

A8: Retail MSMEs accepting multiple card types (RuPay, Visa, Mastercard debit, Visa/Mastercard credit, Amex) have different MDR rates for each. The blended MDR in any month depends on the mix of card types used. If the month's card mix is predominantly RuPay debit (lower MDR) and the calculated blended rate is higher than expected, it is worth requesting a transaction-level settlement report from the bank to identify which transactions attracted higher rates. Two common sources of unexpected MDR charges are: corporate credit cards (typically attracting higher MDR than personal credit cards) and international cards (higher MDR

Q9: How should credit sales to regular customers be tracked in a retail MSME's POS accounts?

A9: A common pattern in small Indian retail is the khata system: a credit book maintained for regular customers who pay at the end of the month. The khata balance represents informal credit extended without formal invoices. For a retail MSME transitioning to formal accounting, converting the khata system to formal invoice-based credit tracking in Tally is a significant improvement in both accounting accuracy and collection effectiveness. The transition involves: issuing a formal invoice for each new credit sale from the billing system, maintaining the Tally Debtors sub-ledger for each credit customer, generating a monthly statement

Q10: What is the minimum daily closing documentation a micro retail MSME should maintain?

A10: For micro retail MSMEs that do not use formal accounting software, the minimum documentation can be maintained in a simple physical register: one page per day with columns for each payment mode total (billing system and physical/terminal count), the differences, and the owner's signature confirming the close. This register, combined with the filed EDC batch printouts, provides the documentation necessary for a CA to prepare monthly accounts and for compliance with GST audit requirements. Digital documentation (photos of the EDC batch printout, PDFs of the billing system report) is equally acceptable. For MSMEs that have
Please submit any questions via the 'suggestions' window. We are committed to enhancing the user experience by remaining fair, transparent, and user-friendly.



! Advertisements !
! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.