Use DataSnipper's Document Matching to perform periodic reconciliations between a trial balance and financial statements, with advanced matching options to improve accuracy.
Video tutorial
What the video covers
How to import financial statements, run Document Matching on the Class and Balance columns, and use the Mandatory field and Amount threshold options to improve match accuracy.
Prerequisites
Financial Statements
Trial Balance
DataSnipper Professional or Elevate package
Steps
Open your Trial Balance in Excel and import the Financial Statements into DataSnipper.
Click Document Matching in the DataSnipper ribbon and select Start new document matching.
Select your sample data from the Trial Balance: the Class column and the Balance column.
Select the imported Financial Statements and click Match all rows.
To improve accuracy with advanced options: reopen Document Matching, click the three dots next to (All Documents) and select Row of Table. On the Class column input, select Mandatory field. On the Balance column input, select Threshold: Amount and enter a value (e.g. 1). Then click Match all rows again.
Saving a template
For recurring reconciliations, save the configuration as a template. Reopen Document Matching, click Continue document matching, and select Save as template. Future runs only require importing new financial statements and selecting the template.
