{"id":1865,"date":"2012-10-08T07:22:19","date_gmt":"2012-10-08T07:22:19","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=1865"},"modified":"2025-06-25T05:06:39","modified_gmt":"2025-06-25T05:06:39","slug":"working-of-auto-bank-reconciliation-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/10\/08\/working-of-auto-bank-reconciliation-in-sage-300-erp\/","title":{"rendered":"Working of Auto Bank Reconciliation in Sage 300 ERP"},"content":{"rendered":"

In our previous blog, we discussed about \u201cAuto Bank Reconciliation in Sage 300 ERP<\/a><\/strong>\u201d and explained how it would be helpful for users to reconcile their Bank Statements in Sage 300 ERP (Formerly known as Sage Accpac ERP). In this blog, we will discuss about the working of Auto Bank reconciliation in Sage (Accpac) 300 ERP.<\/p>\n

Navigate to Bank Reconciliation module>><\/strong>Auto Bank reconciliation.\u00a0In the Auto Bank reconciliation UI, user needs to enter a Bank code and select the bank statement, which is in CSV<\/strong> file using browse button in the screen. Then, click on the \u201cReview mapping\u201d button to map bank statement.<\/p>\n

Step by Step Guide to Auto Bank Reconciliation in Sage 300 ERP – Click here<\/a> \u00a0<\/strong><\/p>\n

\"\"<\/a><\/p>\n

User will have a new Mapping form, where user needs to map the Bank statement column against the column of \u201cBank reconciliation UI\u201d. Click on save button to save this mapping for future use.<\/p>\n

\"\"<\/a><\/p>\n

After clicking on save button, program will read the CSV file and will map it in the reconciliation UI ; if user wants to change the mapping then he\/she can select the mapping name from drop down list and can click on \u201cReview Mapping\u201d button, to change the mapping by selecting an appropriate field in the screen.<\/p>\n

Once proper mapping is selected, all the transactions from bank statement will be populated in \u201cTransaction\u201d tab. \u201cSource\u201d tab will show all the transactions from bank statement in the TXT format.<\/p>\n

\"\"<\/a><\/p>\n

Click on import button, this will import all the data directly in the \u201cReconciliation OFX statement\u201d UI.<\/p>\n

\"\"<\/a><\/p>\n

After successful import of the transaction, navigate to Common service >><\/strong>Bank services >><\/strong>Bank Transaction >><\/strong>Reconcile OFX statement. Select the Bank Code, Reconciliation Date, Reconciliation cute off Date and the Match Deposit by i.e. deposit Slip or transaction to view the Transactions.<\/p>\n

Now user can easily reconcile the bank statement using the Reconciliation OFX statement\u201d UI by clicking on the Reconcile button.<\/p>\n

\n

Demo On Auto Bank Reconciliation in Sage 300 ERP:<\/strong><\/p>\n