Overview of Day Reconciliation in CStoreiQ
Day reconciliation comprehensively summarizes all store activities, including sales breakdowns, department performance, payment methods, and other critical statistics.
Follow the steps below to view and manage daily reconciliation data effectively:
1. Access the Day Reconciliation Page
Log in to your account using your credentials.
Click on the "Day Reconciliation" option in the left-hand menu.
2. Select the Store
Select the Store for which you want to view data.
3. Choose the Date for reconciliation.
If the date shows green, it means data is available for that day.
If the date shows red, it indicates missing data or an incomplete day-close on the Point of Sale (POS) system.
4. Review Store Summary
View key store details, including:
Store Name and Address
Store Opening and Closing Times
Total Sales for the day, categorized into Inside Sales and Fuel Sales
Total Sales Taxes applied during the day
5. Analyze Payment Methods
Breakdown of transactions by various payment methods configured in your store:
Cash Transactions ( e.g - Cash, credit , debit etc.)
Credit Transactions
Debit Transactions
6. Examine Fuel Sales
Detailed fuel sales breakdown includes:
Sales for each Fuel Type (e.g., Diesel, Gasoline)
Average Price Per Gallon
Volume Sold and corresponding sale amounts
7. Review Refunds and Critical Statistics
Access information about:
Refund Transactions (total count and value)
Any significant events or discrepancies like void lines and error corrects.
8. Network Report
Detailed report of payment networks, including:
Number of Transactions processed through each network
Sale Amounts associated with networks
9. Review Cash Flow
Monitor cash inflow and outflow:
Pay In: Added to the register
Pay Out: Withdrawals (e.g., vendor payments).
Check for Over/Short Totals to identify discrepancies or theft.
10. Department Sales
Breakdown of sales by department, including:
UPC and Non-UPC Sales
Total transaction counts and sales values
Option to view detailed item-level transaction data by clicking on the (i) button under details column.
11. Purchases and Expenses
Add and track:
Purchases or expenses incurred during the day
You can Generate reports of all the purchases and expenses you enter here for future reference
12. Bank Deposits
Track Bank Deposits by configuring banks in the store setup.
Record how much was deposited into each bank.
13. Promotions and Discounts
View breakdowns of:
Promotions applied to items
Sales Amounts associated with promotions
Discounts offered during the day
14. Upload Invoices or End-of-Day Reports
Upload any supporting documents, such as:
Invoices or expense receipts
End-of-Day Close Reports from the POS system, and fuel ATG reports.
Use the Browse Files option to upload and save files for the selected date. You can always return to this date to refer to the uploaded files.
By following these steps, you can efficiently manage day reconciliation and keep track of all store activities, ensuring smooth operations and accurate reporting.
Related Articles
How to Add Products to Your Price Book on CStoreiQ
This guide explains how to add products to your price book using CStoreiQ’s back-office system. Follow these steps to manage your inventory effectively and set pricing across your stores. Step 1: Access the Price Book Log in to your CStoreiQ account. ...Advanced Search Filters in CStoreIQ Price Book Explained
The Advanced Search feature boosts efficiency by allowing for detailed item searches. It offers filters for department, store location, vendor, and various product attributes, along with the ability to search by selling prices. Additionally, the "POS ...How to Add Products to Your Price Book in CStoreIQ BackOffice: A Step-by-Step Guide
Adding new products to your price book is crucial for maintaining an up-to-date inventory and ensuring accurate pricing. This guide outlines the steps to seamlessly integrate new items into your price book, streamlining inventory management and ...Using Live Data for Operational Decisions
Live data provides a real-time view of all transactions occurring at the store. It enables operational decisions by offering insights into store activities with a maximum delay of seven minutes between the transaction and its appearance in the live ...Managing Parent-Child Relationships in Inventory Management
Parent-child relationships in inventory management are essential for maintaining an accurate overview of stock. These relationships link items (like cartons and packs) to ensure proper tracking and depletion of inventory. Without such relationships, ...