Ramp Bill Pay users now have the ability to manage their vendor tax information within Ramp, making year-end 1099 processing even easier.
AP Clerks and Admins will have everything they need, including Vendors’ Spend and Tax information, in one easy export from Ramp’s Bill Vendor page. Additionally, users looking to import tax information for multiple vendors at once can bulk upload vendor W9 information.
How does it work?
Entering / Editing Individual Vendor Tax Information
Viewing Vendor Tax Information
Exporting Vendor Tax Information
Bulk Upload Vendor Tax Information
Entering / Editing Individual Vendor Tax Information
As an AP Clerk or Admin, navigate to the Bill Vendors section within the Vendors tab. Within the Vendor Details section for the desired vendor, there will be a new Tax Information section where you can click the Add Tax Information button to begin entering the necessary vendor tax details.
When entering the vendor’s tax information, you will need to select the vendor’s Federal Tax Classification and enter their Taxpayer Identification Number (TIN) and their Business Address.
Vendors can be classified as the following:
- Individual / Sole-Proprietor or Single Member LLC
- C-Corporation
- S-Corporation
- Partnership
- Trust / Estate
- Or International*
*For international vendors all other fields will be removed as 1099s are not required for them.
Based on the vendor’s Federal Tax Classification, their TIN will either be their
- Social Security Number (SSN)- only if the classification is Individual / Sole-Proprietor or Single Member LLC
- Or Employer Identification Number (EIN) - if the classification is not Individual / Sole-Proprietor or Single Member LLC
Viewing Vendor Tax Information
After saving vendors’ tax information, you will be able to tell, at a glance, which vendors have collected tax information and which do not by viewing the new Tax Information column in the Bill Vendor table.
Exporting Vendor Tax Information
Ramp allows you to export your Vendor Tax information from the Bill Vendors page along with the total Bill payment spend for a given period. If no period is selected, the total spend exported will be the total Bill payment spend since the vendor’s first Bill payment. Since tax information includes sensitive information such as the vendor’s TIN, Ramp will require Multi-Factor Authentication (MFA) for the export.
To begin, click the download icon and select Export CSV with Sensitive Information
If you have not recently authenticated via MFA, a pop-up will appear and will ask you to authenticate via your configured authentication method (e.g. via phone or via email). After MFA, please click the download icon and select Export CSV with Sensitive Information once again.
Bulk Upload Vendor Tax Information
If you would like to import tax information for multiple vendors at once you can bulk upload your vendors W9 information. Please note, tax information can only be uploaded for existing vendors. New vendors cannot be added from the bulk tax information upload.
Begin by clicking the three dots next to the New Vendor button and selecting the Bulk Upload Tax Information option.
From the Bulk Upload Tax Information section, you will need to download the template file and input the tax information for each vendor you would like to import information for. The following fields are required for successful upload:
- Vendor Name
- Federal Tax Classification (choose from “Individual, “C-Corporation”, “S-Corporation”, “Partnership”, “Trust”, or "International"*)
*If "International" is chosen, all other fields in the file will be ignored as 1099s are not required for them. - Taxpayer Identification Number (TIN)
- Tax Address Line 1 (Ex. “71 5th Ave”)
- City (Ex. “New York”)
- State/Province/Region (Ex. “NY”)
- Zip / Postal Code (Ex. 10003)
Note: The Vendor Name for all your existing Bill Vendors will be pre-filled within the downloaded template.
After uploading the completed template file, you will see a preview of the list of vendors you are importing and their associated tax classification. Verify that the information is correct and click the Add Tax Information button to complete the import and upload the tax information to the appropriate vendors.
Note: If any changes are required, you can correct the info in the template and re-upload.
Legal: Ramp does not provide accounting or tax advice. Please work with your accountant to determine the tax requirements applicable to your business.