8 Easy Steps to Automate Bank Reconciliation on MyGate Dashboard

Manual bank reconciliation can be tedious and time-consuming. Society Admins can spend hours logging into the bank and manually downloading and importing the bank statement files. Simultaneously, they have to ensure they don’t miss any bank statements required for reconciliation.

However with the remarkable feature of “Automated Bank Reconciliation” on MyGate ERP, the process of reconciling all payments becomes a breeze eliminating the need to sift through piles of paperwork or manually cross-checking digital records.

Step by Step Guide to Automate Bank Reconciliation

A. Uploading the Bank Statement

  1. Choose the desired ledger and select the date range for the entries you wish to reconcile (e.g., 1st to 15th February).
  2. Opt for the specific bank ledger you want to automate reconciliation for (e.g., HDFC Bank).
  3. Select the appropriate format that matches your bank statement:

    a. Dr/Cr & Amount format – If your bank statement displays debit or credit labels in one column and the corresponding amounts in another column, select this option.

    b. Withdrawal & Deposit Amounts format – If your bank statement has separate columns for debit and credit amounts, choose this option.

4. Identify and select the corresponding columns in your bank statement for labels, amounts, and bank dates.

5. Upload your bank statement in either .csv or .xlsx format.

B. Verification of Reconciled Items

  1. After uploading the statement, you’ll find a comprehensive list of the reconciled items on your screen, with the bank dates pre-filled for your review.
  2. The total number of entries that have been auto-reconciled, along with their corresponding value, will be prominently displayed at the top of the list for your convenience.

8. While online receipts made via the MyGate app are known to the software and are perfectly auto-reconciled, it is advised to glance over the cheque receipts given that the cheque numbers can be the same for two banks in some odd cases.

Reject the cheque reconciliation entry if any discrepancy surfaces and go ahead to submit.

Validations for Cheque Payment Entries

To optimize the performance of this tool, we have implemented a couple of validations for cheque numbers during receipt creation:

  1. Cheque numbers must consist of numeric values only.
  2. The maximum length of a cheque number is 6 digits.

We strongly advise our dashboard users to input the cheque number exactly as it appears on their bank statement. If the number entered begins with leading zeros (e.g., 000123), but the statement displays it without them (e.g., 123), the corresponding entry will not be reconciled

Choosing an ERP solution that provides all the bells and whistles needed for a truly automated bank reconciliation process is difficult, and MyGate perfectly fits the bill providing you all the necessary benefits to efficiently manage the finances of your society.


MyGate is building technology to simplify check-ins everywhere. Our flagship solution, launched in 2016, currently facilitates over 2 million check-in requests every day at thousands of gated premises across the 25+ cities in which we operate, and continues to show rapid growth. We’ve strengthened our commitment to information privacy by following GDPR guidelines, the global gold standard for data privacy.

Terms for MyGate Cash

The terms are applicable to all Users. Please read the terms and conditions as contained herein-below carefully and thoroughly, prior to proceeding further with MyGate Cash Services (‘Services’). By...

Cashback Offer on Maintenance Payment

Welcome to MyGate! The MyGate website app is owned and managed by Vivish Technologies Private Limited. All the services are provided by Vivish Technologies Private Limited under its brand...

Personalizing Customer Connections for Brands with Geo-Targeting

“Geo-targeting allows businesses to personalise their messagingand connect with customers on a more intimate level.”Ryan Holmes All brands are online today and reach out to their audience through online...

MyGate, convenience, and better communication

“Convenience is the catalyst that drives innovation in business.”Elon Musk Convenience is a mindful and necessary business virtue. Every brand is based on solutions to some problem. Communicating this...

A Match Made in Marketing Heaven: MyGate’s Engaged User Base

Attention brands and brand managers! It’s time to leave the old-fashioned advertising methods behind and hop on board the MyGate express! We’ve got some exciting news to share with...

Make Your Brand Unmissable On The Mygate App

“Our jobs as marketers are to understand how the customer wants to buy and help them do so.” Bryan Eisenberg, Founder & CMO at IdealSpot Brands are increasingly increasing...