How to Import a Custom Bank Statement into Metro ERP?
To import a custom bank statement into Metro ERP Accounting App follow the below steps.
1) Go to the Accounting Module. By clicking on the 'Accounting' application.
2) Navigate to the Accounting Dashboard. and Click on the "Import" bank statement to import your bank statement.
3) This action will open a popup to import your bank statement. Select the 'Custom Bank' template and download the Excel file format to enter your data before uploading it back for import.
4) After entering the data into the Excel file, Click the 'Select Files' button to choose the file from your system, and then click the 'Upload' button to import it into the system.
5) This action will open the Bank Statement Import screen, where you can match the columns from your file with the corresponding system fields. Once the mappings are correctly aligned and the data looks accurate, click the 'Test' button to validate the import. If everything is correct, proceed by clicking the 'Import' button to upload the data into the system.
6) If the Auto Reconcile Account Code column is present in the file, the system will match it with the existing account code. Once a match is found, the statement line will be automatically reconciled.
7) Click the Edit button, adjust the Ending Balance to match the Computed Balance, then click Save and Post to confirm the form.
8) Next, click the Validate button to confirm and validate the statement form.
9) Now you can verify the journal entries that were automatically created using your account code by clicking the Journal Entries smart button on the Statement form. You can also verify which account is selected on each journal entry line for reconciliation.
10) If the Auto Reconcile Account Code is not provided in the Excel sheet, you can proceed with manual reconciliation after importing the statement. Please refer to the user guide linked below for step-by-step instructions on how to perform manual reconciliation.
View the manual reconciliation steps: Click Here
To get more details on importing custom bank statement and perform Auto Reconcilation in the metro accounting App, please do contact us at support@metrogroup.solutions