There are payments method preferred such as UPI, debit cards,credit cards by people over carrying cash. Considering card payments restaurants etc partner with a company that provides an EDC machine. This way customers can just tap the card enter pin and make payment. For a restaurant, however, checking each transaction processed might be difficult as a large number of transactions take place every day. In case a transaction fails or a wrong amount is collected and it goes undetected it might lead to a loss over time.
To resolve this problem, you can use our automated reconciliation software to check each card payment processed. You can load data automatically to the software via integrations in various file formats. The software then cleans the data off its duplicates and inconsistencies and then configures logic to produce a result. From which a summarised monthly view of all transactions is displayed along with a Store wise view of total transactions. You easily track the store-wise payments and get overview verification of the total payments.
Client Sales Report
This report contains the details of all orders placed and sales made in a particular store
Partner Card Report
The credit card payments processed by the card partner are mentioned in this report
This report is used to verify if the payments actually reach the bank account.
The software reconciles the card report with the MIS report so as to show a summary view of the transactions. You can see all the card payments processed store-wise for a particular month in one place which facilitates easy analysis for your finance team.
This is the unique store identifier number which helps you differentiate between stores and get a store-wise result.
This shows you the month in which these transactions were processed in the store.
Transaction Date (txn_date)
Shown here are the dates of transactions that place through card payments.
Credit Card Sales
This shows you the total payments received through the credit card in a particular store.
CC Sales (HDFC)
These are the payments made through the HDFC card as per the HDFC report
CC Sales (AMEX)
Shown here are the payments made through the AMEX card as per the AMEX report
Credit Card Sales- CC Sales (HDFC) – CC Sales (AMEX) is the sales variance
These are the deductions as recorded in the HDFC report. This includes all the fees charged and other expenses.
Calculated Net Received
Credit Card Sales – Deductions is the total amount that is supposed to paid to you.
All the settlements made by HDFC to your bank account.
Total Card Sales
This is the total credit card sales made in a month by your store as per
Total Credit Card Sales As Per Card Report
Shown here are the total credit card sales in a month recorded in the card report.
Net Sale Difference
Total card sales – Total Credit Card Sales as Per Card Report is the net sales difference calculation
Amount Received as per Bank Statement
This is the total amount in credit payments received in your bank account.
By automating the MIS reconciliation process, the software makes your job easier. The software automates the loading of data files in a variety of formats (CSV, XML, PDF, XLXS, etc.), so you may select the one that’s most convenient for you. After applying logic, it subsequently cleans and transforms the data. Completing all of these procedures, the software generates the reconciliation result as displayed above. It presents the results in a form that makes it simple for finance teams to analyze. You get an overview of the monthly summary of Credit Card payments with MIS reconciliation at one place without much effort.