Xenett Port validates the data once you upload the excel file and show the flags where data is inappropriate. This will save you to do back and forth.

Let's see how you can resolve those error flags:

You can resolve the errors on-screen by double-clicking on the transactions.

There are filters on the header that displays a different group of errors. When you click on it, it will filter the data and will display all the transactions falling under the same error.

For example, if you are importing 1000 bills out of which 10 bills have Vendor named 'Verizon Wireless' in the excel template but in the accounting system, the vendor is named as 'Verizon' then Xenett Port will display 10 flags under the Name filter. In this case, you can double-click on the vendor field and select the Verizon vendor from the dropdown. Once you change in one transaction it will update the changes in all the 10 bills (If the transactions have the same error). This way you can resolve the errors on-screen easily.