You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


This tab provides general information on a Bank Reconciliation document: abank account, start and end date of the period covered by8 statement currency.
On this tab, the following fields are required: Entity, Bank Account, Bank Statement, Start and End Date.

The Bank Reconciliation (create) form. The Main tab
<Auto> in the Number field indicates that a number to this document will be assigned automatically when you save the document.
The From field is populated automatically with the current business date. You can select another date, if necessary.
In the Entity field, select an entity of your company for which this document is being prepared. The Entity field is available if the Multi-Company Accounting option is selected on: Administration > Settings> General Settings. You can select your personal default entity to appear in documents; for this, refer to Personal Settings. If you have not selected your default entity, the entity defined first will be used as the system default value.
Use the Bank Account field to select the bank account for statement reconciliation. The currency of the bank account is shown below.
Use the Bank Statement field to select the statement for the specified bank account received from this bank.
Use the Start Date and End Date fields to specify the date range for reconciliation.
Click the link (in blue font) to auto-matching settings. On the screenshot above shown as Auto-Matching according to: Amount, Transaction Date (Tolerance interval +10 days before, +10 days days after). The Auto-Matching Settings dialog box opens.

The Auto-Matching Settings dialog box
You must select at least one of the following options to be used for automatic matching:

  • By Amount. To match a line of the bank statement to an internal document if their amounts are equal.
  • By Transaction Date. To match a line of the bank statement to an internal document if they have the same dates. Also, you can specify two tolerance intervals (in days) before and after the transaction date ot match the documents by dates within the tolerance interval.
  • By Reference No. To match a line of the bank statement to an internal document if they have the same reference numbers.


Once you are done with selection, click OK to save the settings and close the dialog box.
In the Comment text box, you can specify some additional information on this reconciliation.

Other information


At the bottom of the form, you can view who created this document and the current status of the document; it can be one of the following:

  • New (document was created, but not recorded to the database)
  • Not Posted (document was recorded, but not posted)
  • Posted (document was posted)
  • Marked for Deletion (document was marked to be deleted)



The toolbar buttons


After entering some data on the tab, click the Save button to save your work. After filling out all the tabs, click Post to save and post the document without closing it or Post and close to save, post, and close the document.
For descriptions of other buttons, see Document Toolbar.

  • No labels