How to do bank reconcile transaction in bulk through excel sheet?

How to do bank reconcile transaction in bulk through excel sheet?

If want to do bulk bank reconciliation in excel (Offline Reconciliation) and then upload to ADDA system again, please use this feature. It will allow you to export the statement to your local system to reconcile it offline in excel.

Step 1: Downloading base data to reconcile.

  1. Login to ADDA -->> Admin -->> Bank & Cash -->> Bank & Cash Accounts
  2. Select the Date Range
  3. Select the Bank A/c
  4. Click on "Non reconciled Transactions.
  5. Click on "Fetch Transaction"
  6. Click on “Export to Excel:”. A new window will appear and will say to save the same file.
  7. Give the path in your local system, where to save this file.

Step 2: Marking changes in Excel file for Reconcilation.

  1. Once file saved, open the same file with Microsoft excel
  2. Set the respective flag in “SetReconcileFlag(Y/N)*” Column where the reconciliation to do.
  3. Enter ReconcileAsOf Date in “SetReconcileAsOf(dd/mm/yyyy)*” Column in the format shown.
  4. Save the file in .csv format using File -> Save as in Microsoft Excel.

Step 3: Uploading the reconciled file in excel to ApartmentAdda System.

  1. Click on “Import Excel with Reconciled Data” to upload the file.
  2. Browse the reconciled file from local computer.
  3. Click on “Upload Document”.
  4. Once upload is successful, system will through number of “Total Transactions Un-Reconciled”, “Total Transactions Reconciled” and “Total Transactions Ignored”.
  5. Close the window showing number of the transaction.

    • Related Articles

    • How to reconcile a transaction i.e. Bank Reconciliation?

      Please follow the below steps on how to do Bank Reconciliation: Step 1: Login to ADDA -->> Admin -->> Bank and Cash -->> Bank & Cash Accounts Step 2: Select the Date Range. Step 3: Select Bank A/c shown next to "Reconciled Transaction" to reconcile. ...

    • How to reconcile a transaction on ADDA?

      Please follow the below steps to reconcile a transaction on ADDA: Login to ADDA -->> Admin -->> Bank and Cash -->> Bank & Cash Accounts -->> Select the Bank -->> Enter the date i.e posted From & Till -->>Select the radio button for" All Transactions" ...

    • How to upload Vendor Opening Balance in bulk?

      Please follow the steps below to upload vendor opening balance in bulk using excel upload. Step 1: Got to Expense Tracker > By Vendors > Bulk Posting. Step 2 : Click on 'Batch Upload Opening Balance From Excel'. Step 3: Download the Excel Template ...

    • I see a transaction on my bank statement that seems related to my House. Did ADDA charge it?

      On ADDA you pay only those Dues that are posted by your Association. The Amount collected goes to the Association Bank Account. There is no other Transaction that ADDA posts and that shows up on your Bank Statement. Please write to our Support email ...

    • How to reverse receipts in bulk?

      Please follow the below steps to reverse receipts in Bulk: Step 1: Go to Income Tracker >> Member Income >> Bulk Corrections >> Click ‘Reverse Receipts in Bulk’. Step 2: Fetch the receipts to be reversed based Invoice Date/Invoice Date/Posted Date. ...