Bank Reconciliation Process

When you have received the bank file, use the Automatic Bank Reconciliation form to process the bank reconciliation:

1. Enter a unique reference number for the Update Log. This is your reference number for the process.
2. In the Interface field, select the interface format to use. This field displays a list for selection based on what you have set up, as outlined in the setup steps.
3. The Input File should point to the directory location of the bank file that is going to be processed (a default location is specified on the Interface Selection form).
4. Select Pre-Process to commence the reconciliation prerequisite steps. During these steps, Greentree Desktop searches the bank file, and identifies which bank accounts are included in the file. There is more than one if the file contains multiple headers. The pre-process matches the Account field in each new header line with the bank account numbers set up in Greentree Desktop.
5. If there are multiple bank accounts in the file, these display in the table above, and you can select which accounts to process. You do not need to run them at the same time.
6. Click the Process button to start the automatic bank reconciliation process. Greentree Desktop reads the bank input file, interpret the information in the file according to the interface specifications, and add this data to Greentree Desktop using the creation of new bank statements for selected accounts.

The matching process that occurs behind the scenes is different depending on the nature of the transaction being matched. Greentree Desktop determines whether or not the transaction is a debit or a credit using the transaction code in the transaction line.

Greentree applies this logic:

Once the process is complete, the Cash Management Automatic Bank Reconciliation form updates with this information about the import:

• Statement number.
• Statement date.
• First/last page number.
• Number reconciled.
• Number unmatched (transactions in the bank file that could not be matched to Greentree Desktop transactions using the criteria outlined above).
• Number miscellaneous (transactions that had a miscellaneous transaction code assigned to them).
• Opening balance.
• Closing balance

This process has automated:

• Reconciled transactions that were successfully matched, based on the criteria outlined above has selected them on the Transaction Selection tab on the new bank statement). The closing bank balance updates based on these selections.
• Added miscellaneous payment and receipt transactions to the Transaction Entry tab on the new bank statement. These transactions are reconciled. The closing bank balance updates based on these transactions.
• Added unmatched lines type R and P transactions) to the Transaction Entry tab on the new bank statement. These transactions are reconciled. The closing bank balance updates based on these transactions.

Post-Process Steps

You can run an Unmatched Items Listing report. This field displays any unmatched items of the selected bank account and statement/page numbers. If you know that there are transactions in Greentree Desktop which do match these transactions for some reason, the automatic process did not match them using the matching criteria), then you must reconcile those transactions.

To do this, go into the bank statement (Cash Management Bank Statement Entry) which was created by the process, delete the unmatched line.

You can also run a Bank Reconciliation report to print details of the reconciliation.

• Automatic Bank Reconciliation
• Setup Steps
• Transaction Selection Tab
• Transaction Entry Tab
• How to Set Up a Bank Interface Format
• Review Sample File Specification from National Bank of New Zealand
• Review Sample File Formats