Skip to main content

How To Create and Submit A Bulk Upload File For Landlord Certificates

If you have multiple Landlord Certificates to submit to the Department, we have provided a bulk upload spreadsheet that allows you to collect information for numerous tenants, rental units, or both and upload the data to the Department all at once. The minimum record needed to upload is one, and the maximum is 999.

Lot Rent Landlord Certificate Bulk Upload Instructions

Create Your Bulk Upload Spreadsheet

Step 1: Log in to your account

  1. Log into your myVTax account.
  2. Click on the Landlord Certificate Bulk Upload hyperlink under the Payment & Returns section.

myVTax account screen

myVTax landlord certificate payments and returns screen

Non-login Bulk Upload Instructions

  1. Visit myVTax and select the Landlord Certificate Bulk Upload link on the home page.
  2. From here, follow the same instructions for Login Bulk Upload beginning with Step 2.

myVTax non-login screen

Step 2: Download the LRC-140 bulk upload spreadsheet

  1. Click Import to download the LRC-140 spreadsheet template and save it to your computer. Note: You may use your own spreadsheet. The system will accept spreadsheets in the common programs, such as Excel, Pages, Google Docs, etc. Please be sure to use headers on the spreadsheet, or if you do not use headers, leave line 1 of your spreadsheet blank.

myVTax landlord certificate bulk upload screen

Step 3: Match the fields

  1. Input the data into the spreadsheet using the column titles as a guide.
  2. If using your own spreadsheet, make sure the spreadsheet you are using has the same order to the fields as the downloadable version on myVTax. Each item should have its own column. Note: Even if a field is not needed for your tenants, you must still have all the fields in this order on your spreadsheet for Form LRC-140 to generate. Fields may be left blank, but the column must be included in the spreadsheet.
  3. Once the spreadsheet is complete, save it to your computer.

myVTax field key screen

Upload Your Spreadsheet

Step 4: Upload the file

  1. From the Landlord Certificate Bulk Upload page, select the Import button.
  2. Click on the Choose File button and select the file to be uploaded.

myVTax import screen

myVTax file select import

Step 5: Correct any errors

  1. Once the spreadsheet is uploaded, myVTax brings you to a screen with the Imported Data tab selected. This screen will show any record that has an issue or something to correct.
  2. Once an error is identified, go back to your saved spreadsheet and correct the field in error.
  3. Upload the corrected file by clicking on the Import button, choosing the corrected file and uploading it. This will replace the data you previously had imported.
  4. Once all errors are corrected, you may select the Next button. You are then able to click Submit.
  5. If logged in, the system will ask you for your password. Type in your password and click OK.
  6. You will receive a confirmation number on the next page. Keep this number for your records.

Submit Your Bulk Upload File

Step 6: Submit certificate to Department

  1. Click OK to submit the Landlord Certificate to the Department of Taxes. Beginning in 2022, there is no longer a requirement to provide a copy to tenants.

myVTax submit the certificate screen

Download and Print Instructions (pdf)