Common Errors & Issue Error Importing a Batch Payment

Scenario: You are trying to import a payment batch file like from a lock box bank or a mortgage company and you receive an immediate Red Error with a message about the file. 

99% of batch file errors are the formatting of the excel batch file to import. Remember thousands of batch payments are successfully imported by iGov users so focus on your excel file.

Check the following items:

• Make sure you are using the correct Batch Payment Import because there are 2.  The Batch Payments import is a simple file that applies an amount against whatever is due on the PIDN.  Line Item Batch Payment is a more advanced excel file import that can pay off a specific charge line on a PIDN. 

• Both types of Batch Payments have a sample file on the batch import page that you should download and use.  If you did not, then the issue is almost certainly your columns in your file.

• Check the Column Heading Spelling in your file.  It must match exactly Upper and lower case lettering as well as any spaces.

• Fix your Column Formating (right-click on the column and choose format)

  • PIDN – choose TEXT (not a number). Your PIDN value should be left justified then.

  • Dates – choose short date

  • Numbers – choose number 2 digits after the decimal and no thousand comma. Numbers will right justify.

  • Tax year – choose text.

• Make sure your PIDN column has a value in each cell.

• Watch out for any weird special characters especially an extra comma which could confuse the import because it separates values by commas.

Formatting issues are very normal and easy to correct. If the above instructions do not solve your issue then contact support and the ticket will be elevated.

Version 5.0 of iGovServices 

Last updated on: 12/16/2022

Updated by: CS