1099 Bulk Import: Upload Your Data via CSV

Supported File Formats

The bulk import tool accepts standard CSV (comma-separated values) files, which can be exported from virtually any accounting, payroll, or spreadsheet application.

• CSV (.csv) — The primary supported format. Use comma delimiters with optional text qualifiers (double quotes).
• UTF-8 encoding — Ensure your file uses UTF-8 encoding to preserve special characters in names and addresses.
• Header row required — The first row of your file should contain column headers (e.g., "Recipient Name," "TIN," "Amount").
• No row limit — Upload files containing any number of recipients. The platform handles large files efficiently.

If you use Excel or Google Sheets, export your data as CSV before uploading. Most accounting software (QuickBooks, Xero, FreshBooks, and others) can export payment data to CSV directly.

How Field Mapping Works

Your CSV column names may not match our form field names exactly, and that is fine. The field mapping interface lets you connect your columns to the correct 1099 fields visually.

1. Upload your file — Select and upload your CSV. The platform reads the header row and displays your column names.
2. Review auto-mapping — Common column names (like "Name," "TIN," "Address") are automatically matched to their corresponding 1099 fields. Review these suggestions and adjust as needed.
3. Map remaining fields — For columns that were not auto-mapped, use dropdown menus to assign each one to the correct form field.
4. Save your mapping — Save your field mapping configuration so you can reuse it the next time you import a file with the same format. This is especially useful for clients whose data exports are consistent year over year.

Supported 1099 form fields include recipient name, TIN (SSN or EIN), address (street, city, state, ZIP), account number, and all relevant payment amount boxes for 1099-NEC and 1099-MISC.

Pre-Import Validation

Before any data is committed to a client workspace, the platform validates every row in your file. This catches errors at the point of import rather than at the point of filing.

• Missing required fields — Rows missing a recipient name, TIN, or payment amount are flagged immediately.
• TIN format checks — The platform verifies that TINs are in a valid format (9 digits for SSN or EIN).
• Address validation — State codes are checked against the list of valid U.S. state abbreviations. ZIP codes are validated for format.
• Duplicate detection — If two rows contain the same recipient TIN, the platform alerts you so you can confirm whether both entries are intentional.
• Amount formatting — Payment amounts are checked for valid numeric formatting. Non-numeric characters in amount fields are flagged.

Error Handling and Corrections

When validation finds issues, you have clear options for resolving them without starting over.

• Row-level error display — Each row with an issue is listed with a plain-language description of the problem and the specific field that needs attention.
• Inline editing — Fix individual field values directly in the import preview without going back to your spreadsheet.
• Partial import — Import the valid rows and set aside the rows with errors. Fix the problem rows separately and import them in a second pass.
• Re-upload option — If there are widespread issues, correct your CSV file externally and upload a revised version. Your saved field mapping will still apply.

CSV Template

To make your first import as smooth as possible, we provide a downloadable CSV template pre-formatted with the correct column headers for 1099-NEC and 1099-MISC forms.

• 1099-NEC template — Includes columns for recipient name, TIN, address fields, account number, and nonemployee compensation (Box 1).
• 1099-MISC template — Includes columns for all relevant MISC boxes (rents, royalties, other income, medical payments, and more).

Templates are available for download within your account after you sign up. They can also be used as a reference for structuring your own export files.

Best Practices for Bulk Import

Follow these guidelines to ensure a smooth import experience.

1. Clean your data first — Remove blank rows, fix obvious typos, and ensure TINs are formatted consistently before uploading.
2. Use the template — If possible, format your data using our CSV template to minimize mapping effort.
3. Import per client — Upload a separate CSV for each client to keep recipient data properly organized within their respective workspaces.
4. Review the validation report — Take a few minutes to review flagged items before committing the import. It is faster to fix issues now than after filing.
5. Save your field mapping — If you will import data in the same format again next year, saving the mapping eliminates a step in future imports.

Frequently Asked Questions