Process flow for Financial Period Closure Reconciliation

Automating the Financial Period Close process is performed at the end of each financial period to find out the amount differences between general ledger and subledger.

Financial Reconciliation (AP, AR Interim accounts) in LN using RPA process flow. RPA performs these steps:

  • Reads the configured tenant for the user and logs in.
  • Takes the user arguments for the fiscal year and fiscal period.
  • Checks if the specified period is open.
  • Creates a folder in the file manager to store the reports created in LN.
  • Generates Accounts Receivables (AR) Reports and Accounts Payables (AP) Reports using the Print Control Account Checklist (tfacr2415m000).
  • Reads the Excel file from the workbookPath defined on the Arguments tab. This Excel file provides filters and options by reconciliation group and sub-area.
  • Adds the filters specified in the Print Reconciliation Data (tfgld4495m000) session.
  • Generates reports for the reconciliation group and sub-area, optionally by ledger account, and stores them in the created folder.
  • Compares the reports for differences by performing OCR on the reports generated.
  • Writes the results of the OCR to a consolidated Reconciliation Results report.
  • Sends the reports with differences and the consolidated Excel report to IDM.
  • Sends a notification on the number of reports processed to the configured user or user group.