Bank Reconciliation - Miscellaneous
The Miscellaneous tab is used to mark Journal Entries to the General Ledger accounts. This tab shows all non-check entries that were posted to the bank account through IntelliDealer. On this screen, you can reconcile every entry that appears on your statement. If there are missing entries, use General Invoicing or Vouchers to post those entries to the bank account.
To open the Miscellaneoustab, click an Account Number on the Bank Reconciliation screen, then select the Miscellaneous tab.
The informational fields on the Miscellaneous tab are:
| Field | Description |
|---|---|
| Set Bank Statement Date | Enter or select the date of the current Bank Statement. |
| Statement Ending Balance | Enter the closing balance on the current Bank Statement as of the date on that statement. |
| Outstanding Checks | The total value of the checks in the system that are still marked outstanding. |
| Outstanding Miscellaneous Entries | The total value of the miscellaneous entries in the system that are still marked outstanding. |
| Current G/L Balance | The current balance of the general ledger as of today. |
| Unrecorded Entries |
The value entered in this field is subtracted from the Unreconciled Difference value, allowing you to perform the bank reconciliation update. If the Unreconciled Difference is over 0, the update cannot be performed. Use this field to enter an amount from a prior system that is being managed externally, or for items that have posted to the bank but not the business system or vice-versa. Note: This value is not recorded in the system and should only used to temporarily adjust the Unreconciled Difference to perform the update. For example, if there is an Unreconciled Difference of 200 dollars but you need to perform the update and are certain that the 200 dollar difference is the result of a deposit that has yet to be processed, enter 200 in this field to complete the update. |
| Unreconciled Difference |
The goal of working with the Bank Reconciliation system is to make this value zero for each account. The unreconciled difference is calculated as: |
The sorting options on the Miscellaneous tab are:
|
Sort by |
|
|---|---|
| Field | Description |
| Date | Sorts the search results by date. |
| Invoice Number | Sorts the search results by invoice number. |
| Amount | Sorts the search results by amount. |
| Absolute Amount | Sorts the search results by numerical value, regardless of whether the value is positive or negative. |
The fields on the Miscellaneous tab are:
| Field | Description |
|---|---|
| Auto Reconcile Check Numbers | The range of checks entered in the From and To fields will automatically be reconciled by the system after clicking Go >>. |
| Amount | The amount of the journal entry. |
| Date | The date of the journal entry. |
| Invoice Number | The invoice number associated with journal entry. |
| Name | The customer name. |
| Source | The source of the journal entry. |
| Description | A description of the journal entry. |
Click on an Invoice Number to open the Vouchers Information screen.
Use these buttons to complete your work on the Miscellaneous tab:
| Button | Function |
|---|---|
| Select All | Selects all the invoices listed. |
| Save | Saves the changes made on the Miscellaneous tab. |
| Close | Closes the Miscellaneous tab and returns you to the Bank Reconciliation screen. |
| Preliminary | Set the printing parameters for printing reconciliation preliminary. |