Use DataSnipper's Snips to extract loan agreement terms, re-perform amortization calculations, and verify repayments against bank statements.
Video tutorial
What the video covers: importing loan agreements and bank statements, extracting key terms and repayment conditions from each document using Snips, verifying signatures with Validation and Exception Snips, and extracting repayment figures from bank statements into the Amortization Table sheet.
Prerequisites
Loan agreement and addendum
Repayment schedule
Bank Statements
Start procedure
Open your Excel workbook and ensure the testing data is documented.
Import your relevant documents: Loan agreement and addendum, and Bank Statements.
In the Document Viewer, select the Loan agreement and extract the relevant data into the "Agreement Summary" sheet.
Select the addendum and extract the repayment terms.
Use the Validation or Exception Snip to verify signatures in both agreements.
Select the 'Bank Statement' in the Document Viewer.
In the "Amortization Table" sheet, use Text Snip to extract repayments from the bank statements into the relevant cells.
