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.
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.
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.
Installation and Getting Started
Install Intelligent Automation Cloud – Express Edition or Business Edition.
Extract the folder and drop it into your WorkFusion Studio Workspace (C:\Users\%USERNAME%\workfusion-workspace\rpae_project).
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.
Select the .pdf files to process and save them in one folder.
Open the example in WorkFusion Studio.
Set default values for the following variables:
str_input_folder_path – the path to the folder with the .pdf files, for example: C:\ManualReconciliationInput
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:\
str_result_folder_name – the result folder name, for example: ManualReconciliationResult