How to bank reconcile transaction in bulk through excel sheet?

How to 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?

      Step 1: Go to 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. Step 4: Select the radio button for "All Transactions". Step 5: Click on "Fetch ...
    • 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 Invoices in Bulk’ Step 2: Fetch the invoices to be reversed. Step 3. Cross check the fetched data and then ...
    • What is bank reconciliation ?

      Income entries are being captured in Income Tracker and cheque / cash gets deposited in Bank Account. Expenses are being captured in Expense Tracker and cheques are written to withdraw money. How do you ensure that all the entries are correct and ...
    • How can I undo a reconciled transaction for Bank Reconciliation Statement?

      Step 1: Login to ADDA >> Admin >> Bank & Cash >> Bank & Cash Accounts Step 2: Select the date range Step 3: Select the respective Bank Account. Step 4: Select the “All Transactions” Step 5:Click on “Fetch Transaction” Step 6: Select the checkbox ...
    • How to make expense payment entry in bulk?

      Batch Upload:  Go to Expense tracker>>By vendor>>Bulk posting>>Click on Bulk upload expense with payment>>Enter all the details for the required vendor i.e Expense head, instrument type, instrument number, from a bank account, Date, Amount, and ...