Record Clearing Account Reconciliation

This activity allows you to record the clearing details of the Account Balances.

Select the “Record Clearing Account Reconciliation” activity under the “Clearing” business component.

The “Record Clearing Account Reconciliation” page appears.

Enter the following:

Clearing No.	The clearing number that you want to retrieve (Alphanumeric, 16).
	Help facility available.
Finance Book	Use the drop down list box to select the finance book to which the clearing account codes have been assigned. If the Reconciliation of Clearing Accounts At Company level is set to Yes, then the finance book combo will be loaded with all the finance books of the Login OU’s company to which the login user has been mapped else the finance book mapped for the Login OU and login User alone will be available for selection.

The system displays the following:

Status

The status of the clearing number. It could be Fresh, Active, Deleted or Reversed.

Enter the following:

Clearing Type	Use the drop down list box to select the clearing type. The combo is loaded with “Within Account Codes” and “Across Account Codes”. The system displays “Within Account Codes” by default on launch of the page.
Clearing Date	The date of creation of clearing number.
Numbering Type	Use the drop-down list box to select the numbering type for the Clearing organization unit and the “Record Clearing Account Reconciliation” transaction type. The numbering types must have already been defined in the “Create Numbering Class” activity of the “Document Numbering Class” business component and must be in “Active” status. The system displays the numbering type set as default for the transaction in the “Document Numbering Class” business component.
Account Code	Use the drop down list box to select the account code for recording the clearing. The combo is loaded with all the assigned account codes of the defaulted finance book. The system displays “Blank” by default on launch of the page.

The system displays the following:

Description	The textual description of the account code selected.
Currency	The code identifying the currency in which the postings will be made in the account.

Enter the following:

Reconciliation Account Code

Use the drop down list box to select the account code for recording the clearing. The combo is loaded with all the assigned account codes of the defaulted finance book. The system displays “Blank” by default on launch of the page.

The system displays the following:

Account Description	The textual description of the account code selected.
Currency	The code identifying the currency in which the postings will be made in the account.

Note: Reconciliation Account Code, Account Description and Currency controls will be visible only when the clearing type is selected as Across Account Codes.

Enter the following:

Transaction Date From	The starting date in the range of transaction dates from which you want to retrieve the details.
To	The ending date in the range of transaction dates until which you want to retrieve the details.
Transaction OU	The organization Unit for which you want to retrieve the transactions. The combo is loaded with the OUs mapped for the defaulted / selected Finance Book.

Click the “Get Details” pushbutton to retrieve the transactions.

Note: If the clearing type is “Within account codes”, for the selected account code, Finance Book, transaction date range, Transaction OU combination, all the postings to debit leg would be displayed in the “Clearing Account Transactions” multiline and all the postings to credit leg would be displayed in the “Clearing Account Credit Transactions / Reconciliation Account Transactions” multiline.

Note: If the clearing type is “Across account codes”, for the selected account code, Finance Book, transaction date range, Transaction OU combination, all the postings of Account codes for debit leg and credit leg would be displayed in the “Clearing Account Transactions” multiline and all the postings of Reconciliation Account codes for debit leg and credit leg would be displayed in the “Clearing Account Credit Transactions / Reconciliation Account Transactions” multiline.

Tolerance Group

Use the drop down list box to select the tolerance group. Tolerance assigned to account code / reconciliation account codes is loaded in the combo.

The system displays the following in the Clearing Account Transactions Multiline

Transaction Type	The type of transaction.
Transaction OU	The code identifying the organization unit in which the transaction has been originated.
Transaction Number	The number identifying the document that has been created for the transaction.
Transaction Date	The date on which the transaction took place.
Transaction Currency	The currency in which the transaction has taken place.
Transaction Amount	The transaction amount in the transaction currency.
Dr. / Cr. Indicator	Indicates whether the transaction amount has been debited (“Dr”) or credited (“Cr”) in the account.
Uncleared Amount	The transaction amount yet to cleared in Transaction Currency
Uncleared Amount in Base Currency	The transaction amount yet to be cleared in Base Currency of the company.

Enter the following field in the “Clearing Account Transaction” multiline:

Clearing Amount

The transaction amount to be cleared in the clearing Transaction.

The system displays the following in the Clearing Account Transactions Multiline

Clearing Amount in Base Currency

The transaction amount to be cleared in the clearing Transaction in Base Currency of the Company.

Enter the following field in the “Clearing Account Transaction” multiline:

Tag Group

The code identifying the tag group (Alphanumeric, 6).

The system displays the following in the Clearing Account Transactions Multiline

Cost Center	The cost center to which the account code is mapped.
Analysis Code	The Analysis Code to which the account code is mapped.
Sub Analysis Code	The Sub Analysis Code to which the account code is mapped.
Remarks	The Line Level remarks of the Transactions would be retrieved and displayed.
Project OU	The Organization Unit in which the Project Code has been created
Project / Sub-Project Code	The code identifying the Project /Sub-project to which the transaction is associated.
Project / Sub-Project Description	The description of the project / sub-project.

The system displays the following in the Clearing Account Credit Transactions / Reconciliation Account Transactions Multiline on get details.

Transaction Type	The type of transaction.
Transaction OU	The code identifying the organization unit in which the transaction has been originated.
Transaction Number	The number identifying the document that has been created for the transaction.
Transaction Date	The date on which the transaction took place.
Transaction Currency	The currency in which the transaction has taken place.
Transaction Amount	The transaction amount in the transaction currency.
Dr. / Cr. Indicator	Indicates whether the transaction amount has been debited (“Dr”) or credited (“Cr”) in the account.
Uncleared Amount	The transaction amount yet to be cleared in Transaction Currency
Uncleared Amount in Base Currency	The transaction amount yet to be cleared in Base Currency of the company.

Enter the following field in the “Clearing Account Credit Transactions / Reconciliation Account Transactions” multiline:

Clearing Amount

The transaction amount to be cleared in the clearing transaction.

The system displays the following in the Clearing Account Credit Transactions / Reconciliation Account Transactions multiline:

Clearing Amount in Base Currency

The transaction amount to be cleared in the clearing transaction in Base Currency of the Company.

Enter the following field in the “Clearing Account Credit Transactions / Reconciliation Account Transactions” multiline:

Tag Group

The code identifying the tag group (Alphanumeric, 6).

The system displays the following in the Clearing Account Credit Transactions / Reconciliation Account Transactions multiline:

Cost Center	The cost center to which the account code is mapped.
Analysis Code	The Analysis Code to which the account code is mapped.
Sub Analysis Code	The Sub Analysis Code to which the account code is mapped.
Remarks	The Line Level remarks of the Transactions would be retrieved and displayed.
Project OU	The Organization Unit in which the Project Code has been created
Project / Sub-Project Code	The code identifying the Project / Sub-project to which the transaction is associated.
Project / Sub-Project Description	The description of the project / sub-project.

Enter the following fields:

Cost Center	Cost Center mapped to clearing difference account code. Value in the control is mandatory only when clearing difference occurs during authorization and the clearing difference account is mapped to cost center effective on clearing date.
	Help facility available.
Analysis code	Analysis Code mapped to clearing difference account code. Value in the control is mandatory only when clearing difference occurs during authorization and the clearing difference account is mapped to Analysis Code.
	Help facility available.
Sub Analysis code	Sub Analysis Code mapped to clearing difference account code.
Comments	Comments if any for the Journal voucher generated on authorization of clearing with clearing difference.
Journal Voucher	Journal voucher generated on authorization of clearing with clearing difference.
	Data hyperlink available

The system displays the following:

Clearing Difference

The difference between the Debit and credit leg postings.

Click the “Record” pushbutton to record the clearing details.

The system updates the status of clearing number as “Fresh”.

Click the “Authorize” pushbutton to authorize the clearing details.

The system updates the status of clearing number as “Authorized”.

Click the “Delete” pushbutton to delete the clearing number.
Click the “Reverse” pushbutton to reverse the clearing number.

The system displays the following fields:

Created By	The login ID of the user who created the Clearing number.
Created Date	The date on which the Clearing number is raised.
Modified By	The login ID of the user who modified the Clearing number.
Last Modified Date	The date on which the Clearing number is last modified.

To proceed, carry out the following

Select the “View Clearing Account Reconciliation” link to view the clearing account reconciliation details.

Prerequisites

Finance book must be defined in the “Create Finance Book” activity of the “Organization Set Up” business component.
Account Codes to be assigned for clearing.