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
Promotions Overview
Promotions Overview The Promotions section in CStoreiQ is where you create and manage your store's own promotional deals — including price groups, combo deals, mix & match offers, and loyalty pricing. Navigate to: Sidebar → Price Book → Promotions ...Altria Pricing Overview
Altria Pricing Overview Navigate to Altria Pricing in the left sidebar (under Price Book) to access the manufacturer deal management interface. This is where all Altria tobacco deals are configured and managed. ? Note: All Altria deals are synced ...Altria's Digital Trade Program (DTP) Overview
Altria's Digital Trade Program (DTP) Overview Altria's Digital Trade Program (DTP) is a multi-tier incentive program designed to reward retailers who participate in tobacco scan data reporting, loyalty programs, and digital engagement through their ...Fuel Module: Dashboard, Inventory (SIR), and Pricing Management
Purpose: Understand your store's fuel operations, track inventory, and manage retail fuel prices centrally from CStoreIQ. Audience: Store Owners, Managers Prerequisites: Your store must be configured to poll fuel data from the POS. Navigation: ...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. ...