Edit

Reconciliation overview

Example overview

Problem statement

Reconciliation is an accounting practice used to ensure that two sets of records are in agreement. It confirms that money leaving an account matches the money that's actually being spent. This is generally something done by the finance department during a month-end closing and can be a very time-consuming process which requires lots of manual effort, depending on the volume of transactions that don't match. See also >>

Existing manual process

Today, the existing manual process takes a lot of time: People have to copy transaction information from some file into an Excel document and manually check all the transactions for errors. This process transfers all the information to an Excel file and checks for errors, and then people need only to correct these errors.

Automation solution

The bot uses Adobe Reader to convert .pdf files to .txt, because for machine processing we have to use a format that we can read and extract information from for further work. The next big step is data processing and its transfer to an Excel file. In this step, we copy all the necessary information into the appropriate columns in the template and set the status for the current transaction.

Reusable components

In this example, there are 5 reusable components:

• Create a temp folder

• Create a folder with the predefined name or use the current data

• Convert .pdf to a .txt file

• Custom Action - download the file by direct link to the folder

• Generate a report

Preconditions

1. Install to your PC:
   • WorkFusion Studio (Intelligent Automation Cloud Business)
   • Adobe Reader (English version)
2. Download the example.
   • ManualReconciliationInput - the input folder inside the ManualReconciliation v1.2.zip folder, the standard path for the input folder: C:\ (do not forget to extract before work)

Installation and getting started

1. Install Intelligent Automation Cloud Business.

2. Download ManualReconciliation v1.2.zip.

3. Extract the folder and drop it into your Studio workspace (C:\Users\%USERNAME%\workfusion-workspace\rpae_project).

   caution

   If the template does not load at runtime, you can download ManualTask.xlsx from the example folder to any file exchange and change the default value in the str_link_to_file variable to your direct link.

4. Select the .pdf files to process and save them in one folder.

5. Open the example in Studio.

6. Set default values for the following variables:

   1. str_input_folder_path - the path to the folder with the .pdf files, for example: C:\ManualReconciliationInput
   2. str_result_path - the path to the folder or drive where you want to create a folder with the results, for example: C:\ManualReconciliationResult or C:\
   3. str_result_folder_name - the result folder name, for example: ManualReconciliationResult

7. Click on the Play recording button.