{"id":5149,"date":"2013-11-18T12:47:24","date_gmt":"2013-11-18T12:47:24","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=5149"},"modified":"2013-11-18T12:47:24","modified_gmt":"2013-11-18T12:47:24","slug":"transaction-filtering-and-sorting-feature-under-reconcile-statements-form","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/11\/18\/transaction-filtering-and-sorting-feature-under-reconcile-statements-form\/","title":{"rendered":"Transaction filtering and sorting feature under Reconcile Statements Form"},"content":{"rendered":"

Bank Reconciliation is one of the key processes of any business. Sage 300 ERP offers an excellent Bank Reconciliation module which automates and simplifies the reconciliation process.<\/p>\n

Reconcile Statements Form (available in Bank Transactions folder) facilitates the reconciliation of bank account from the accounting records and a statement from the bank. The Reconciliation tab on the Reconcile Statements forms to list all outstanding deposits and withdrawals. It has a function to reconcile the balances and record any adjustments.<\/p>\n

Normally, you reconcile your bank accounts at the end of each fiscal period, when you receive the statement from the bank. There can be hundreds of transactions that need to be reconciled. Browsing individual transaction looking for transaction number, an amount can be very tedious.<\/p>\n

In this blog, we will discuss the standard transaction filtering\/sorting options that Reconcile Statements Form provides to quickly locate the transactions.<\/p>\n

Basically, you can use the Display, Transaction Type, <\/strong>and Sort By fields<\/strong> to filter outstanding deposits or withdrawals and sort them by date or transaction number.<\/p>\n

Now let\u2019s looks at individual filter\/sort options.<\/p>\n