...
Then you will need to specify the date starting which the reconciliations become required and the internal bank documents will be available for reconciliations from this date; the earlier documents will not be involved in reconciliations. For this, use the Bank Reconciliation Start Date field. By default, the field is populated with the current date, however, you can change it for another date.
...
For details, refer to Settings: Money.
To manually indicate for a specific bank account that reconciliations in this account are required, select the Reconcile Bank Statements option in its master record on: Money > Master Data > Bank Accounts. For details, refer to Bank Accounts.
Initially, all transactions associated with the bank account for which reconciliation becomes required have will get the Unmatched reconciliation status.
Note. If you select earlier reconciliation start date than the current date, you might need to re-post all the Bank Payments, Bank Receipts, and Money Transfers that were created in the period (time interval) between the selected date and the current date, so that correct reconciliation statuses could be assigned to these documents.
Import of Bank Statements
...
On the Main tab, specify the bank account and the period for reconciliation.
Then, on the Operations tab, click the Import (
) button if you are going to import the bank transactions from the statement. The Import from Excel form appears.
The Import from Excel form
...
Create a new Bank Reconciliation document using the form: Money > Service Tools > Bank Reconciliations. For details, refer to Creating a Bank Reconciliation.
The Bank Reconciliation form. The Main tab
- On the Main tab, select the bank account.
- Select a bank statement. Click the Fill in (
) to the right of the Bank Statement field to populate the document with transactions from the selected statement. - The start and end dates of the period under reconciliation appear automatically.
- Click the Auto-Matching settings according to: link in blue font below the dates. The Auto-Matching Settings dialog box opens.
The Auto-Matching dialog box
...
8. If the right pane is empty, click Fill to populate with internal documents having dates from the start date of reconciliation specified for the bank account or from the start of the period set by using the Set Period (
) button on the left pane toolbar.
The Select period dialog box
...
The system matches any statement line to a bank document which has the same amount, reference number, or date within the tolerance interval depending on which criteria were selected.
The Bank Reconciliation form. The Matching tab
...
Then, select either a statement line or a document and click one of the For Bank Statement Line or For Document buttons, respectively. 
The Bank Reconciliation form. The Matching tab - viewing the matching results
...
If the document was fully or partly matched to a line in any bank statement, a special comment (in blue font) will appear in the lower left corner of the form.
The Bank Reconciliation form. The Main tab with reconciliation status indicated
...
The Unmatched Bank Documents report contains the list of bank documents that were not matched to any Bank Statement lines although they have dates within the specified period.
Using the Bank Reconciliation Analysis report with its various filters, you can analyze the issues in reconciliation process if any.
