Monday, September 17, 2018

Reconcile Transactions Under Deposits & Credits Tab of the Bank Reconciliation when Users Rely on Customer/CompanyName to Reconcile

To easily reconcile transactions under Deposits & Credits tab of the Bank Reconciliation page when users rely on Customer/Company Name to reconcile, perform the following:

1.  Navigate to Lists > Accounting > Accounts.

2.  Drilldown on the account to be reconciled.

3.  Check off 1-Line box for Payee to display on its own column.

4.  Mark the Uncleared checkbox.

5.  Set Date range as needed.

6.  With Payee displayed on one line, users should be able to find the transactions to be cleared.

7.  Clear off transactions using Clr checkbox.

8.  Proceed to reconciliation process through Transactions > Bank > Reconcile Bank Statement.

9.  Once Statement Date is set, all transactions that fall within the range will be displayed. (In fact, all transactions whether cleared or not are displayed on the list.

11. Click the Mark All Cleared to Reconcile button. (This will mark all the ones that were checked off as cleared in Point 7 to reconciled.)

12. Proceed to finish reconciliation as usual.

Note: Users may attach their case to Enhancement 81449: Reconcile Bank Statement > Please add a column for Customer or Company Name under Deposits and Credits tab.

No comments:

Post a Comment