Once your data import is complete, you can validate invoice and customer data against your ERP data by spot checking 5-10 items per workspace to ensure they match in both systems. By doing this, you help improve the efficiency of your collections process and ensure accurate cash flow insights.
To validate your data in Tesorio, click on the down arrow on the left navigation panel and select the relevant collections workspace for the data you are validating.
To keep track of your data validations, download Tesorio Data Validation Worksheet.docx
Invoices Workspace
When you arrive at the Invoices workspace, you will be able to check the following against your ERP invoice data without any additional filters or columns:
Invoice Balance
Invoice Date
Due Date
Add Invoice Columns
To validate additional data points, you will need to add the following columns:
Invoice Amount - the original invoice amount
Subsidiary - the subsidiary the invoice is associated with
To do this, select Manage Workspace on the top right and navigate to the Columns tab. Find the fields, select them, and click Apply. The new columns will appear on the right side of your table.
Invoice Drawer - Contacts
The Invoice Drawer is where you access additional details about your invoice. To access the invoice drawer, hover over an invoice in your workspace and click on the ellipses to the right.
Next navigate to the Contacts tab of the Invoice Drawer and review the contacts that synced into Tesorio.
Customer Workspace
Next, navigate to the Customers Workspace by selecting the Customers tab. On the Customers workspace, you will be able to check the customer's total balance against your ERP data.
Credit Memos Workspace
Navigate to the Credit Memos Workspace and check them to ensure your memos are linking to the correct invoice. You should validate:
Original Amount
Unapplied Amount
Applied Amount
Customer Payments Workspace
On the Customer Payments Workspace, validate applied and unapplied payments.
