Reconciling a Bank Account

Export Items to Excel

Reconcile Bank Accounts can be used to reconcile your bank accounts in Juris with their respective bank statements. It is designed to be easy to navigate and is also customizable to the your preferences.

1. Select Tables > Bank Accounts.
   
   

2. Double-click the icon or description for the account to be reconciled.

   The Bank Accounts\[bank code] window opens.

   

3. Select Tools > Reconcile.

   Several screen customization and navigation options are available:

   • Use the View menu to select or deselect the items visible on the reconciliation screen.  
   • The columns in the Checks and Payments list as well as the Deposits and other credits list may be reordered by dragging and dropping the column headings.  
   • The details in the Checks and Payments list as well as the Deposits and other credits list may be sorted by column by clicking the column heading.  
   • Right-click on the column headings for more options, including sorting and grouping.

   • Right-click on the checkbox shown in the column heading  of the Checks and Payments list as well as the Deposits and other credits list to view item selection options or to restore the column headings to their default arrangement.

     

   • Use the View menu to select or deselect the items visible on the reconciliation screen.  
   • The columns in the Checks and Payments list as well as the Deposits and other credits list may be reordered by dragging and dropping the column headings.  
   • The details in the Checks and Payments list as well as the Deposits and other credits list may be sorted by column by clicking the column heading.  
   • Right-click on the column headings for more options, including sorting and grouping.

   • Right-click on the check box shown in the column heading  of the Checks and Payments list as well as the Deposits and other credits list to view item selection options or to restore the column headings to their default arrangement.

     

     Tip

     See Reconciling Bank Accounts - additional information for Statement Roll forward and Bank Reconciliation detailed descriptions.

4. Enter the appropriate statement date and mark all cleared items as shown on the statement by placing a check mark beside each cleared item.

5. Some entries may appear on the statement that are not listed in Juris in the Checks and Payments or the Deposits and other credits list.  These entries may be added to the system by clicking the New button - or by selecting Form>New.  The new entry form allows A/P Check, Trust Check, Deposit, ATM, Reconciling Entry, Bank Charge, Interest Income, Wire Transfer or Other items to be entered.  A negative amount entered will place the item on the Checks and Payments side and a positive amount entered will place the item on the Deposits and other credits side.

   

   Note

   Entries cannot be removed from the check register, and can only be reversed by entering a second, offsetting entry. Make sure that the following information on new entries is correct before saving.

   • Entry Date
   • Amount (may be positive or negative)
   • Type (A/P Check, Trust Check, Deposit, ATM, Reconciling Entry, Bank Charge, Interest Income, Wire Transfer or Other)
   • Check # (if applicable)
   • Description
   • G/L Account

6. When the Unreconciled Difference is = 0, then the Reconcile option will become enabled.  Click the Reconcile button on the toolbar or select Form>Reconcile.

   

 

Export Items to Excel

1. The  Export Items to Excel option may be accessed by clicking the Export button or by selecting Form> Export. You can also use keystroke Ctrl + E.
2. Enter the export file path or use the Browse button.
3. Select the file name format From. Use the arrow buttons to move the information.
4. Enter the User Defined Text.

5. Click the OK button.

   

 

Related topics