Journal reconciliation (GL30201S)
By using this window, you can reconcile your account transactions.
Search line in list window
If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.
There are two types of search fields:
White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or % and get different results:
- space: the result contains the words in any order,
- %: the result contains the words in the specific order, and the % functions as a wildcard as well.
Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.
The window toolbar
- Reconcile
- This will set the reconciliation on selected transactions.
- Void
- This will void the already reconciled transactions.
The top part
Input section
- Reference no.
- The reference number of the reconciliation.
- Reconciliation setting
- The setting of the reconciliation.
- Reconciliation date
- The date when the reconciliation was created.
- Reconciliation balance
- Here you enter the reconciliation balance.
- Hold
- A check box that indicates (if selected) that the batch has the On hold status and cannot be released or posted. You can clear the check box only if the batch has total debits equal to total credits.
- Description
- A description of the reconciliation.
The Filter documents on section
- Load documents up to
- Load documents up to your selected date.
- Include unposted
- Includes unposted documents to be reconciled.
- Include reclassified
- Includes reclassified documents to be reconciled.
- Include hidden lines
- Includes hidden lines.
The Calculation section
- Beginning balance
- Beginning balance from previous reconciliation.
- Reconciled debit
- The sum of the debit transactions that are check-marked.
- Reconciled credit
- The sum of the credit transactions that are check-marked.
- Difference
- The difference between debit and credit transactions.
The table
- Select all
- Sets a check box in selected for all records displayed in the table.
- Deselect all
- Removes the check box in selected for all records displayed in the table.
- Selected
- A check box that you select to indicate that the transaction is included in the reconciliation document as a reconciled one.
- Account
- The account of the reconciliation.
- Account description
- A description of the account
- Ref. no.
The reference number of the external or internal document associated with the journal transaction. Journal entries related to the same document should have the same reference number specified.
The documents reference numbers must be specified for VAT-related journal transactions.
It is required because VAT and taxable amounts are reflected in the VAT reports only if they are linked to the corresponding documents.
If the reference number of the external document has been manually specified for a journal transaction, the document cannot be opened because it was not added to the system.
- Transaction description
- A description of the transaction or any comments relevant to the transaction.
- Transaction date
- The transaction date of the document associated with the journal transaction.
- Debit
The debit amount of the journal entry.
You can specify only a debit or a credit amount for a single journal entry.
- Credit
The credit amount of the journal entry.
Again, you can specify only a debit or a credit amount for a single journal entry.
- Subaccount
- The subaccount of the reconciliation.
- Released
- This check box is selected when the document is released.
- Reclassified
- This check box is selected if this is a journal entry of the type Reclassification.
- Batch no.
- The unique ID of the batch, which is generated by the number series assigned to batches in the General ledger preferences (GL102000) window.
- Workspace
The workspace where the batch originates.
New batches can be created only for General ledger.
- Orig. batch no.
- The number to the original general ledger batch based on which the selected Reclassification batch has been generated.
- Orig. workspace
- The original workspace based on which the selected Reclassification batch has been generated.
- Post period
- The period that the transaction is posted in.
- Posted
- Status for the transaction if it is posted or not.
- Hide line
- A check box for hiding this line for future reconciliations.
- Branch
- The branch associated with this journal entry.
- Project
The project with which this transaction line is associated, or the code indicating that this batch is not associated with any project.
The Non-project code is specified on the General information tab in the Project accounting preferences (PM101000) window.
This column appears only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window.
- Project task
The particular task of the project with which this transaction line is associated.
This column appears only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window.