The Import and Export functions are listed below the “Action Line” and the RED highlighted letters correspond to each function.
B=Export Lien Holders, this will create a list of existing lien holders to be sent to Real Auction, We need to send this because we can’t have two lien holders with the same Tax ID and an existing lien holder may be bidding at Real Auction. After selecting “B” from the action line you will see the following message:
D=Export Tax Sale Info, this will create a list of properties with what is owed for each B&L as if you were publishing it in the news paper. After selecting “D” from the action line you will see the following message:
A copy of the file “tax_sale.csv” is also placed in your home folder on the tax server and can be opened in a spread sheet.
I=Import Lien Holders, this will import from Real Auction the list of all bidders (vendors), it will check the file to make sure it can be read in properly. After selecting “I” from the action line you will see the following messages:
W=Import Tax Sale Info, this will import the the same file that was exported to Real Action, with the inclusion of the lien holder id, interest rate and premium if any. Select “W” from the action line you will see the following messages:
When finished you will see upload compete. Press <enter> and you will be returned to the tax sale day applications main menu and you should see the vendor information now.
Now you can print a vendor report this will print a detailed listing of each vendors bidding’s with a total sheet that should match what Real Auction has transferred in to the town’s account, for this example I will just show one vendor and the totals page:
If your numbers prove we are ready to upload the data in to the tax system.
Select U=upload next.
Enter the lien holder Lien search Fee enter this as a whole number “40.00” press <enter> (if you don’t want to assign a fee enter “0.0”).
Enter the lien holder recording Fee enter this as a whole number “12.00” press <enter> (if you don’t want to assign a fee enter “0.0”).
Enter the Town’s Lien search Fee enter this as a whole number “12.00” press <enter> (if you don’t want to assign a fee enter “0.0”).
Enter the Town’s recording Fee enter this as a whole number “8.00” press <enter> (if you don’t want to assign a fee enter “0.0”).
Answer (Y) to create the certificates in the tax system, (N) will exit with out uploading and ask about posting utility (if you have one).
NOTE: MAKE SURE EVERY ONE IS OUT OF THE TAX SYSTEM OTHERWISE YOU WILL GET AN ERROR MESSAGE AS THE SYSTEM WILL TRY TO LOCK EVERYONE ELSE OUT.
When finished you will see:
Answer (N) to posting Utility and run a deposit slip under id “1” in the tax system, when you prove your deposit you can return to the tax sale day application and post the utility here if you are using the four equal installment utility (using the tax system for your utility system). If that is the case repeat the upload procedure entering “0.0” for all the fees and answering “N” to the tax part and “Y” to utility.