Bulk import additional spend for 1099s
Overview
Import a CSV to update additional spend for multiple existing vendors for one entity and tax year. Enter reportable payments made outside Ramp, not each vendor's full annual total. Ramp adds additional spend to reportable bill-line amounts when calculating filing totals.
Do not import amounts already included in reportable bill lines, including bills marked paid outside Ramp. If you mark a bill line Not reportable to replace it with an adjusted additional-spend amount, you can import that replacement amount. See the vendor-credit workaround.
These steps apply when Import additional spend appears in your 1099 dashboard. If you don't see it, you can still add additional spend in an eligible, unfiled vendor's worksheet.
How imported values update additional spend
Importing replaces saved additional spend; it does not add the uploaded amounts to previously saved additional spend.
- Populated cell: Replaces that saved value.
- Blank cell: Keeps that saved value.
- Zero amount: Enter
0to reset an amount to zero. - Remove a saved occupation code: Remove it in the vendor's worksheet, then download a new template before continuing the import.
- Vendor omitted from the file: Leaves that vendor's additional spend unchanged.
Additional spend cannot be changed after filing has started.
Enter 2026 tipped occupation codes
Use the three-digit Treasury Tipped Occupation Codes in the IRS occupation list, such as 101 for bartenders, not occupation names or SOC codes. Preserve leading zeros. Use 000 if any tips are from a nonqualifying occupation.
- 1099-NEC: Use
nec_tipped_occupation_code_1andnec_tipped_occupation_code_2. - 1099-MISC: Use
misc_tipped_occupation_code_1andmisc_tipped_occupation_code_2.
Enter code 1 before code 2. Codes must be distinct within each form, with no more than two per form. For 1099-NEC, this limit includes codes saved on reported bill line items. Cash tips greater than zero require an occupation code in the CSV or one already saved in the worksheet.
Import additional spend
- Open Review 1099s, choose the tax year and entity, then select Import additional spend.
- Select Download template. Keep all original column headers and the prefilled vendor, entity, and tax-year identifiers unchanged.
- Enter additional spend in the applicable 1099 amount columns. Use nonnegative USD amounts with no currency symbols or commas and no more than two decimal places.
- For tax year 2025, leave tips, overtime, and tipped-occupation-code columns blank.
- For tax year 2026, follow the tips and overtime preparation guidance for the amounts and the CSV occupation-code instructions for the codes.
- Select Upload completed template. Upload up to 500 vendor rows at a time. Review the spreadsheet and resolve any validation errors before continuing.
- Select Replace additional spend, confirm the entity and tax year, then select Replace additional spend again.
After the import succeeds, Ramp returns you to the 1099 overview. To review filing totals and submit forms, follow 1099 Filing on Ramp.