Bank Reconciliation

Overview of FW78 - Bank Reconciliation

This program is designed to assist the user in reconciling their checking account general ledger and/or any other general ledger account that is in DDI-Connect.

Getting Started

1. Maximize your screen for the best view of this program.

2. Select your Checking Account or General Ledger Account you want to reconcile.

3. Enter your start and end date.

Note: Since general ledger transactions go back to the day you started using the system, to start using this program you may want to clear everything to a particular start date. Then use that same start date for the rest of that fiscal year (that way it will show you everything outstanding from that date).

4. Choose Outstanding Items then click "View Items". This will load the outstanding general ledger items into the grids below.

5. Enter in the ending balance from your bank checking accounts statement in the top right hand corner.

6. Start clearing items in the Debits/Credits grids. You can use your Shift or CTRL keys to select multiple items to clear.

Screen Fields

Field	Description
Check Acct	This is a selection drop-down list of your checking accounts that are setup in the system.
Date Range	Enter the date range you are reconciling. The outstanding debits & credits will be totaled by the outstanding items in this date range. Also, the ending balance will be the ending general ledger balance as of the "thru" date.
View	This is a selection drop-down list of viewing options. When reconciling you will want to be viewing the "Outstanding Items". To unclear an item you can switch the view to "Cleared Items" and then find the transaction to unclear. The "All" drop down will show both cleared and outstanding items for that date range.
View Item	When the View Item button is pressed, it will pull in the general ledger activity in the grid from the date ranges selected.
Clear Date	Enter the date you want the items to be cleared on.
Clear/Unclear Item(s)	This button will clear or unclear selected items in the grid.
GL Balance	The GL balance is the balance in the general ledger account as of the thru date selected.
Outstanding Debits	This is the total of debits in the Debits grid.
Outstanding Credits	This is the total of credits in the Debits grid.
Outstanding Items from Bank	This is a place where you can put the total dollar amount (-/+) in that field of the items outstanding on your actual checking account side. Meaning, the transaction is on DDI but not yet happened on your checking account.
Tran dt	Date of the general ledger transaction.
Src	Source of the transaction in DDI-Connect.
Debit	The amount of the debit general ledger transaction.
Credit	The amount of the credit general ledger transaction.
Clear dt	The date the transaction was cleared.
Notes	The customizable note in this program. To add/edit a note, select one or multiple transactions, click "Edit Note", enter your note into the grid and the press the "Enter" key.
County	The County will automatically populate when you enter the ZIP code. However, you can change the county by clicking on the drop down arrow and selecting from the available list
Displayed Debit Total	This is the total amount of debits in the grid.
Highlighted Debit Total	Using your Shift and/or Ctrl key you can select multiple debit items in the grid. The system will then add up the highlighted amounts up and display them in this field.
Displayed Credit Total	This is the total amount of credits in the grid.
Highlighted Credit Total	Using your Shift and/or Ctrl key you can select multiple debit items in the grid. The system will then add up the highlighted amounts up and display them in this field.

How to Enter a Note

1. Highlight one or multiple transactions from the grid.

2. Click "Edit Note" at the top of your screen.

3. Enter the note into the grid.

4. Press Enter.