Data verification always works better in table view when checking through a batch of data at once. There is no need to export data to excel file with Floodgate as there is a 'Table View' available in Donor Manager.
Firstly, filter for the batch of data that you want to verify (e.g. data from yesterday, data from last week). Then, click 'Table View' button located near the filter button around the top of the screen (see below).
Data of the filtered donors will be shown in table format. Click the up/down triangles to sort data by the field. Missing and irregular data can be found easily with this view.
Please modify the data to be shown in one page by using the menus shown at the top of the table. For example, 46 data are shown in 2 pages with the below example. You can change the '25' to '50' from the drop down menu at the left end to show all 46 data in one page.
Shortcut Key such as Ctrl+F works on all the data and column headers. There is no need to scroll up/down and left/right constantly to find the data that you are looking for. Search box and filters work from the table view too, so that you can narrow down your results further.
Changes can be made for multiple pledges in one go from this table view as long as the changes are made on one page. Moving from one data to another and fix everything. Click 'Save' at the top of the page just once and all the changes that you made for multiple pledges are saved at once.