===== Bulk Import Form ===== {{:tax_coll:2022-10-18_15-10-13.jpg?800|}} ====Select New File==== Click [Browse...] to choose the file you received from the mortgage company. If you have a .csv file, you can change the file type via the drop-down in file explorer.\\ {{:tax_coll:2022-10-18_15-39-35.jpg?250|}} ====File Has Header Row==== {{:tax_coll:2022-10-18_15-44-28.jpg?200|}}\\ Checking this box will skip importing data from the first row in the file during the import process. This is to handle electronic files that have a "header" row.\\ \\ For example: * CtlNumber,PaidBy,Bill,PaymentAmount Would be examples of column names if a file had a "header row." If in doubt, you can see how checking/unchecking the box will affect the options in the identifier combo boxes. If you don't see any header row, you can leave this box unchecked. ====Identifier Type==== {{:tax_coll:2022-10-18_15-55-50.jpg?250|}}\\ Based on what you see in the data file, choose one of the three identifier "types" to match on: - Bill Number - Control Number - Tax Map/Parcel ID ====Check Number==== {{:tax_coll:2022-10-18_15-59-08.jpg?250|}}\\ Enter the check number for the payments you are importing (separate with commas if multiple checks for one file) ====Selecting Identifying Information==== The identifying information is necessary to import the payments. This helps link the electronic file information to the data in //TaxColl2k//. ===Identifier=== {{:tax_coll:2022-10-18_15-2-08.jpg?250|}}\\ This should be either a: * Bill Number * Control Number * Tax Map/Parcel ID **Make sure** to identify the data correctly using the "Identifier Type" dropdown above the "Check Number" field. ===Pmt Amt=== {{:tax_coll:2022-10-18_16-15-50.jpg?250|}}\\ Identify the column using the sample data that most likely is the Payment Amount of the bills. ===Owner Name=== {{:tax_coll:2022-10-18_16-16-55.jpg?250|}}\\ While not mandatory to select, try to identify using the sample data what is most likely the owner name column ====Import Payments==== {{:tax_coll:2022-10-18_16-27-28.jpg?250|}}\\ \\ Clicking the [Import Payments] button will begin the import process. If the identifier and payment amount have been selected, you will be prompted to provide the Tax Type and Payment Period this electronic file was made for:\\ \\ {{:tax_coll:2022-10-18_16-29-14.jpg?300|}}\\ \\ Once the payments have been imported, the "Pending Payments" report will open and display any payments categorized as one of the following: * **Overpayment** (partial refund; bill will be PAID) * **Underpayment** (full refund; bill will remain UNPAID) * **Already paid** (full refund) * **Parcel not found** (full refund)