Daily Settlement Worksheets: Automate End-of-Day Reconciliation for Retail & Hospitality
Eliminate manual cash counting errors and close your business day in minutes with automated settlement reports
Every retail manager, restaurant owner, and pharmacy supervisor knows the pain of end-of-day reconciliation. Cashiers count physical cash, credit card receipts pile up, mobile payment confirmations need verification, and discrepancies between system sales and actual collections create hours of detective work. In busy supermarkets like those in Dehiwala or Gampola, where hundreds of transactions occur daily across multiple payment methods, a single miscounted denomination or unrecorded expense can throw off your entire settlement. Manual settlement worksheets on paper or Excel spreadsheets are prone to calculation errors, offer no audit trail, and leave finance teams scrambling to explain variances days later when bank deposits don't match reported sales.
ApexCloud's automated daily settlement worksheet functionality transforms this tedious process into a streamlined, accurate workflow. The system automatically pulls sales data from all POS terminals, categorizes transactions by payment method (cash, card, mobile wallets, credit sales), calculates expected cash in drawer after accounting for opening float and petty cash expenses, and generates comprehensive settlement reports with variance analysis. Finance managers at operations like MKB in Dehiwala-Mount Lavinia and Mahajana in Gampola use these automated worksheets to reconcile multi-location operations in minutes rather than hours. The platform flags discrepancies in real-time, maintains complete audit trails with timestamps and user accountability, and integrates settlement data directly into your accounting ledger—eliminating double-entry and ensuring your financial records are always current and accurate.
Capabilities that move the needle
Everything below is built into ApexCloud and ready on day one.
Multi-Payment Method Reconciliation
Automatically categorize and reconcile cash, credit cards, debit cards, mobile wallets, vouchers, and credit sales in a single consolidated worksheet. ApexCloud tracks each payment gateway separately, matching card settlement reports with POS transactions and identifying any processing fees or chargebacks. For businesses like Kashmeer Super in Hatton handling diverse payment types, this eliminates the manual sorting and calculation that typically consumes 30-45 minutes per location daily.
Automated Variance Detection
The system calculates expected cash by taking opening float, adding cash sales, subtracting cash expenses and withdrawals, then compares this to actual counted cash entered by cashiers. Any variance beyond your configured threshold (typically Rs 50-100) triggers alerts and requires manager approval with documented explanations. This built-in accountability has helped retailers reduce unexplained shortages by up to 75% by making discrepancies visible immediately rather than discovering them during monthly audits.
Denomination-Level Cash Counting
Cashiers enter physical cash counts by denomination (Rs 5000, 1000, 500, 100, 50, 20, 10, 5, 2, 1 notes and coins), and ApexCloud automatically calculates totals while displaying expected amounts based on sales data. This denomination breakdown speeds up counting, reduces arithmetic errors, and provides forensic detail when investigating discrepancies. Pharmacies and supermarkets report 40% faster cash counting compared to manual calculator-based methods, with significantly fewer recount requests.
Bank Deposit Preparation
Generate ready-to-use bank deposit slips directly from settlement worksheets, with cash and cheque amounts pre-calculated and formatted for your banking partner. ApexCloud tracks which settlements have been deposited, on what date, and to which bank account, creating a complete chain of custody from POS sale to bank reconciliation. Multi-location operations like Fourams City Centre in Batticaloa use this to manage deposits across branches, ensuring every rupee is accounted for and reducing bank reconciliation time by 60%.
Cashier-Level Accountability
Track settlement performance by individual cashier, shift, and POS terminal with complete audit trails showing who counted what, when, and what variances occurred. Managers can identify patterns—whether certain cashiers consistently have shortages, specific terminals have technical issues causing discrepancies, or particular shifts experience more problems. This data-driven approach to cash management helps retailers coach staff effectively and identify training needs or potential security concerns before they become significant losses.
Historical Settlement Analysis
Access any past settlement worksheet instantly, with full transaction drill-down capability to investigate historical discrepancies or answer audit questions. ApexCloud maintains unlimited settlement history with advanced filtering by date range, location, cashier, variance amount, or approval status. Finance teams conducting monthly closes or annual audits can pull comprehensive settlement reports covering any period, with exportable data in Excel or PDF format that satisfies auditor requirements and regulatory compliance needs.
Petty Cash & Expense Integration
Record petty cash disbursements, supplier COD payments, utility bills, and other cash expenses directly in the settlement worksheet, automatically reducing expected cash in drawer. Each expense entry requires categorization, approval workflow, and optional receipt attachment, creating a complete record of all cash movements. This integration eliminates the common problem of forgetting to account for legitimate expenses during reconciliation, which often leads to apparent shortages that waste management time investigating phantom discrepancies.
Role-Based Settlement Workflows
Configure multi-level approval workflows where cashiers enter counts, supervisors verify and approve, and finance managers review variances before final posting to accounts. ApexCloud enforces these workflows systematically, preventing premature settlement closure and ensuring proper oversight. Larger operations like MKB with Rs 150,000+ monthly operations use this to maintain internal controls, with automatic notifications alerting the next approver when action is required, reducing settlement cycle time while maintaining audit compliance.
Built for your industry
Supermarkets & Retail
Multi-checkout supermarkets handle hundreds of daily transactions across 5-8 payment methods, making manual settlement extremely time-consuming. ApexCloud's automated worksheets reconcile all registers simultaneously, account for returns and exchanges, track promotional vouchers and loyalty point redemptions, and generate consolidated reports for multi-branch operations. Retailers like Mahajana in Gampola and Kashmeer Super in Hatton rely on these tools to close their day accurately despite high transaction volumes and complex payment mixes.
Pharmacies
Pharmacies deal with prescription insurance claims, credit sales to corporate accounts, and strict regulatory requirements for financial record-keeping. ApexCloud settlement worksheets separate insurance receivables from cash sales, track outstanding credit balances by customer, and maintain the detailed audit trails required for healthcare compliance. The system ensures that controlled substance sales are properly reconciled and that all financial discrepancies are documented with timestamps and responsible party identification for regulatory inspections.
Restaurants & Hospitality
Restaurants like Zaytoon in Pilimathalawa and Ram Balaji Dosai in Kandy handle cash, cards, delivery platform settlements (Uber Eats, PickMe), and staff meal deductions that complicate end-of-day reconciliation. ApexCloud automatically accounts for delivery commission deductions, tip distributions, complimentary meals, and staff advances, calculating the exact expected cash after all adjustments. This prevents the common restaurant problem of apparent shortages caused by forgotten adjustments, while providing the detailed reporting needed to analyze actual vs. theoretical food cost.
“Before ApexCloud, our five cashiers at our Gampola location would spend 45 minutes each closing their registers, and I would spend another hour reconciling everything and investigating discrepancies. We were finding variances of Rs 2,000-5,000 several times per week, and it was impossible to determine whether these were counting errors, system issues, or actual problems. Since implementing ApexCloud's automated settlement worksheets three months ago, our closing time has dropped to under 15 minutes per cashier, and our unexplained variances have decreased by about 80%. The denomination-level counting interface catches arithmetic errors immediately, and the system's automatic calculation of expected cash after accounting for expenses has eliminated most of the false alarms we used to chase. Our accountant loves that bank reconciliation now takes minutes instead of hours because every deposit is already documented and matched to sales. The audit trail has also proven invaluable—when we do have a discrepancy, we can drill down to the exact transaction level and identify the issue quickly. This system has paid for itself many times over just in reduced management time and eliminated losses.”
Frequently asked questions
How does ApexCloud handle multiple shifts or cashier changes during the day?
ApexCloud supports unlimited shift settlements, allowing you to reconcile each cashier individually when they end their shift rather than waiting until day-end. Each cashier logs in, enters their cash count, and the system calculates their specific expected amount based only on transactions they processed. Supervisors can then prepare a consolidated daily settlement combining all shifts, or analyze performance by individual shift to identify patterns.
What happens if our actual cash count doesn't match the system's expected amount?
ApexCloud flags any variance beyond your configured tolerance threshold and requires the cashier or supervisor to document the reason (miscounted, pricing error, unrecorded expense, etc.). The system won't allow settlement closure until variances are acknowledged and approved by an authorized manager. All variance explanations are permanently recorded with timestamps and user IDs for audit purposes, and you can generate variance reports to identify trends or recurring issues.
Can we reconcile card payments when the bank settlement amount differs from POS totals?
Yes, ApexCloud allows you to enter actual bank settlement amounts for each card type and payment gateway, automatically calculating and recording the difference (typically processing fees, chargebacks, or disputed transactions). These reconciliation differences are posted to designated expense or adjustment accounts in your chart of accounts, ensuring your books accurately reflect actual bank deposits while maintaining full visibility into payment processing costs.
How does the system handle foreign currency transactions for businesses near tourist areas?
ApexCloud supports multi-currency cash counting with configurable exchange rates. Cashiers enter foreign currency amounts separately (USD, EUR, GBP, etc.), the system converts to LKR at your specified rate, and the settlement worksheet shows both original currency amounts and LKR equivalents. This is particularly useful for retailers in Colombo tourist areas or businesses near airports who regularly accept multiple currencies but need to reconcile everything in rupees.
Can we access settlement worksheets from our mobile phones for remote locations?
Yes, ApexCloud is fully cloud-based with responsive mobile interfaces that work on any smartphone or tablet. Branch managers can review, approve, and submit settlement worksheets from their mobile devices, and head office finance teams can monitor settlement status across all locations in real-time from anywhere. The mobile interface supports all core functions including cash counting entry, variance documentation, and approval workflows.
What reports are available for analyzing settlement patterns over time?
ApexCloud provides comprehensive settlement analytics including variance trend analysis by location, cashier, day of week, and time period; average settlement processing time metrics; cash vs. card sales mix evolution; and exception reports highlighting unusual patterns. You can generate comparative reports showing month-over-month improvement in accuracy, identify which locations or cashiers have the best settlement performance, and export all data to Excel for custom analysis or presentation to management.
Close Your Business Day with Confidence
Join hundreds of retailers across Sri Lanka who have eliminated settlement headaches with ApexCloud's automated reconciliation.
Start Free Trial