Import data
Import spreadsheets and 1220 files
Use an E-File Magic template, a Multi-Filer workbook, your own spreadsheet, or a Publication 1220 export. Review the detected records and results before filing.

In this guide
Completed does not mean ready to file
Review imported and skipped counts. Resolve filer and recipient Validation Issues before submitting the records for filing.
Before you start
A supported source file
XLSX or XLS up to 10 MiB; CSV or 1220 up to 25 MiB. Click or 1220 file on the upload screen for supported extensions.
The intended filer and year
Choose an existing destination or create a filer during setup.
Import permission
An active Account User can import; wait for other filer work to finish.
View all setup requirements
- If importing into an existing filer, select the correct Current Active Filer in the top navigation. Standard and advanced import wizards also let you create a new filer after uploading.
- Prepare the recipient spreadsheet source you plan to import.
- Ensure your account role includes import permission.
- Know your intended default form for imported rows when using Advanced Import.
- Wait for any filer mass-archive/delete run or order snapshot run on the same filer to finish before starting import processing.
- Imported recipients with correctable validation errors are saved and marked invalid. Open the recipient and review Validation Issues, correct the information, and save before submitting it for filing. Manual creation and edits must pass validation. Rows that cannot be safely assigned or saved are still skipped; review their diagnostics before importing again.
- Tax IDs in the preview show only the last four characters. Recognized EIN and SSN/ITIN hyphens stay in their proper positions; an identifier with no known type is masked without adding guessed hyphens.
Choose your import path
Start with your file type, or return to a saved import.
Start an import
Continue or review
Standard template
Use this for E-File Magic template files where form mapping is automatic.
Open Spreadsheets and confirm the filer
Open Recipients -> Imports -> Spreadsheets & 1220.
Confirm Current Active Filer is set in the top bar.
Upload the template
Click New Import, then drag your template XLSX/XLS file into the highlighted upload area or click Choose file.
The file uploads automatically and opens the preview modal after detection.
Choose the destination and check the year
Under Import setup in Review template import, choose the active filer or create a new filer.
The workbook tax year must match the destination filer. A Tax year mismatch message disables Launch Import before any rows are queued. Select a matching filer or create a new filer with the workbook year; do not edit hidden workbook metadata to bypass the check.
Review forms and sample rows
Review the detected forms and sample rows.
If the plan shows Deferred form counts, continue when the sample rows look correct; exact totals will finalize during processing.
Complete new-filer details when needed
If creating a new filer, enter its display name and telephone number, then review Filing details. Choose Business or Individual and enter the legal business name or person name fields, tax ID, U.S. street address, city, state, ZIP code and contact information. Correct the highlighted fields here before launch. The display name can include commas and periods; the legal filing name cannot. The template’s Filing Year is fixed by the workbook.
Launch and monitor the import
Click Launch Import to start asynchronous processing.
Monitor status in the left import directory and Selected Import detail. When View imported records? appears, choose Yes, view records to open Recipients or No, stay here to continue reviewing the import.
Template rows are auto-mapped, queued, and processed without manual field mapping.
Multi-Filer workbook
Use this when each row includes filer information as well as recipient information.
Prepare current-year names and filer details
Use current-year template headers. Keep individual first and last names in their separate name columns; use the business-name columns only for businesses.
Multi-Filer Import creates domestic business filers. For an individual, use a standard workbook and choose Individual when creating its destination. Foreign filers require setup in Filers first.
Review repeated filer details: the same Tax ID with different legal names or addresses can create separate filers.
Open New Import and upload
Open Recipients -> Imports -> Spreadsheets & 1220.
Click New Import to clear any previously selected file or preview state and briefly highlight the upload area in green.
Drag the multi-filer XLSX/XLS file into the upload area (or click to choose).
Confirm the detected destinations
Wait for detection to open the preview modal.
Under Import setup, confirm Destination shows Detected filers from the spreadsheet; no single active filer is selected for this import.
Review samples or save for later
Review sample rows and detected form rows.
Use Save for later, Back, or the close button to leave the review without starting. Resume Import Preview reopens the saved upload later; these controls are disabled while launch is running.
Launch and monitor processing
Click Launch Import to queue processing.
Monitor the import directory while the system stages unique filers and imports the recipient rows under the detected filer for each row.
Review filer and recipient issues
After completion, compare imported and skipped counts. In Filers, open any Needs attention filer and use Validation Issues to correct and Save its details. Then check names, amounts, and Validation Issues in Manage Recipients. Completed means processing ended; it does not mean the records are ready to file.
Rows are grouped under their detected filers and processed through the normal background import workflow.
Publication 1220 file
Import original returns from another filing system.
Choose the original file
Choose or drop the original file. Click or 1220 file to read the accepted extensions and file requirements; close the help with Close or Escape.
Check the preview and select import details
Wait for security checks and review the detected year, filers, forms, and original-return counts. Corrections marked G or C are excluded.
Choose Import Filers and Recipients for general information only, or Import Filers and Recipients with Details to include amounts and form details.
Launch or save for later
Click Next: Import, then Launch Import. Save for later keeps a draft in Import history.
Review imported records
After completion, open Filers or Recipients and review highlighted issues. If Business is provisional, confirm the correct type and Tax ID. A filer needing review can be saved with unchanged details; successful Save runs validation.
Original returns become editable records. Incomplete or uncertain records stay marked for review until validation succeeds.
Your own spreadsheet
Use this when importing an arbitrary recipient spreadsheet.
Open Spreadsheets and upload the file
Open Recipients -> Imports -> Spreadsheets & 1220.
You can start without an active filer. If you want to add recipients to an existing filer, select it in the top bar.
Drag your spreadsheet into the upload area or click Choose file. Upload and inspection begin automatically.
Confirm the email and preview
Confirm Completion Email (defaults to your login email).
Wait for detection to open the Advanced Import wizard.
If the preview row total shows a plus sign, treat it as a lower-bound estimate for a large file rather than a final row count.
Filer: choose the destination
On the Filer screen, choose Current active filer or Create a new filer. If no filer is active, Create a new filer is selected automatically. Filer setup occupies the main panel before mapping begins.
Form: confirm the year and target form
Existing filers keep their saved year. For a new filer, choose Filing Year, enter its display name and telephone number, choose Business or Individual, and complete the corresponding legal name and filing details. Correct highlighted fields, then select Next: Form and choose Target form. Changing the year reloads its filing requirements and resets form-specific mappings; common recipient mappings and filer details are retained.
Map columns: review suggestions
Select Next: Map columns. Check any AI updated or Needs review labels. Use Auto-map suggestions to rerun matching if needed, or Undo AI changes to restore the suggestions before the review. Review sample rows before launch; an AI review does not certify your data or filing.
Map the correct identity fields
Map Business Name for organization rows and map First Name plus Last Name for person rows.
When a row has both Business Name and person names, the row is imported as a business recipient.
Display Name is derived by the system from mapped identity fields and is not a mapping target.
Do not map Recipient ID, form ID, internal filing-version, or tax-year columns; E-File Magic sets them from the selected destination and target form.
Review: inspect samples and unused columns
Click Next: Review to check Sample rows and the Mapping plan in one screen with the review checks. Next: Import opens the final confirmation. Existing-filer mappings are saved before review. New-filer details and mappings stay local until launch; reloading or leaving the page discards those unsaved choices. If an unmapped-column reminder appears, review the listed spreadsheet columns and choose Back to mapping or Continue. Optional target fields without a mapping do not trigger this reminder.
For mapped currency fields, review USD-formatted preview values; standard spreadsheet dollar entries such as 1,001.05 are accepted and normalized automatically.
Import: confirm and launch
Click Next: Import, review the destination and year, then click Launch Import. A new filer is created and selected before the import starts. If launch fails after the filer was created, retry uses that same filer.
Monitor and review imported records
Watch the status in the left import directory and wait for processing to finish.
Open Recipients -> Manage to review imported rows and validation issues.
Your spreadsheet import is queued and processed with the configured column mapping.
Resume a pending import
Use this when a previously uploaded import is still in upload pending status.
Find the pending upload
Open Recipients -> Imports -> Spreadsheets & 1220.
Use Search, Sort By, and Directory Filter if needed to narrow by file name, status, ID, import type, or error text.
Select the pending row in the left import directory.
Open its preview or wizard
Click Resume Import Preview for a standard template or Multi-Filer Import submission, or Resume Advanced Import Wizard for an advanced submission.
Review before launching
Review the reopened preview modal or advanced wizard, then launch when ready.
The pending import is reopened so you can continue mapping and launch processing.
Monitor progress and skipped rows
Use this after starting an import job.
Find the submission
Locate the submission in the left import directory using Search, Sort By, Directory Filter, Rows, and Previous/Next as needed.
Read progress and Finalizing Metrics
Watch live progress bars and row counters (processed, imported, skipped, issues) while status is Queued or Processing.
Finalizing Metrics means recipient rows have been saved and their totals are still being updated. Leave the import running; it completes after those required updates finish.
Understand retry behavior
For a Failed import, choose Retry Import to return to file selection with the original destination filer selected when one was saved. Choose the corrected file from your computer and review its new preview before launching. The failed attempt stays in history. Records already imported remain saved; include only remaining records in the corrected file to avoid duplicates.
Check exact counts and refreshed status
For XLSX/XLS imports, the total row count in the left import directory becomes exact shortly after processing begins, even though the earlier preview may have shown an estimate.
Automatic status refresh runs about every 5 seconds while queued/processing; use the compact refresh icon beside the directory paging controls or Refresh Status in the selected import detail only when you need an immediate manual check.
Review skipped-row diagnostics
If status is Completed or Failed and skipped rows exist, click Open Hard Skip Diagnostics to launch the diagnostics modal and review the reason summary plus row-level skip details, including retry-exhausted rows that were skipped automatically.
Use Refresh Diagnostics to reload retained skip details and Close to return to the import. This is a read-only review; it does not retry rows or alter recipients.
Review imported recipients
If a run ends Failed after importing some recipients, those imported rows can still finish appearing in Search shortly after failure while background sync catches up.
When status is Completed, continue in Recipients -> Manage for post-import review.
You can confirm whether import processing has completed and identify next review steps.
Delete a pending upload
Use this to remove an upload-pending submission before it is queued.
Select the pending submission
Select the upload-pending submission in the left import directory.
Open Selected Import detail.
Choose Delete Pending Import
Click Delete Pending Import.
Confirm deletion
Confirm deletion in the on-screen confirmation modal.
The pending submission and its saved draft import rows are removed and no longer appear in the recent list.
Review saved import history
Use the history tab to review seasonal work without starting another import.
Open Import history
Open Import history. Spreadsheet history contains spreadsheet uploads only.
Review results or resume available setup
Select the saved spreadsheet to review its results. Resume setup needs unexpired source data. Retry Import starts a new upload for a Failed attempt and remains available after the old source expires.
Review retained results after details expire
After 48 hours, review the saved counts and imported recipients. Start a new import if the source details have expired.
Saved results remain useful for seasonal work while temporary details and resume actions expire.
Page details and controls
Source Detection
Choose an XLSX, XLS, CSV, or IRS Publication 1220 file. E-File Magic detects the source and opens the matching preview or mapping flow. Click or 1220 file beside the upload prompt for accepted extensions and file requirements.
Template Preview And Launch
After you choose a standard template or Multi-Filer workbook, the review workspace places destination setup beside a wide, readable sample table on desktop and stacks them on smaller screens. The review body scrolls as one area, with the action buttons always available. Sample rows are previews, not completed validation results. Large-file estimates and parser notices appear in one compact review note until staging finalizes exact totals.
Upload And Inspect
Drop a file or click Choose file. Native 1220 files can use .irs, .txt, .1220, .dat, or .fire. A different extension or no extension also works when the contents are recognizable. Upload and inspection begin automatically. 1220 and CSV files have a 25 MiB limit; XLSX and XLS have a 10 MiB limit. Large previews may show a lower-bound count with a plus sign.
Advanced Import Wizard
After uploading and inspecting an advanced spreadsheet, the wizard opens at Filer. Choose the current filer or complete a new filer in the main panel, then select its Form. Map columns groups common recipient fields and IRS box/line fields. Review combines sample rows, the field mapping plan, and checks before the final Import confirmation. Catalog and suggestion loading stays inside the wizard.
Import history
Use the New import and Import history tabs at the top, with the same outlined tabs and icon boxes as Reports. The selected tab is highlighted in blue. On narrow screens the tabs stack. Use Left/Right arrows, Home or End while a tab has keyboard focus to switch views. New import opens the upload workflow. Import history opens the spreadsheet directory and selected details. Search, Sort By, Directory Filter, Rows, Previous, Next, and Refresh import directory control this history. Select a row to review its status and counts or resume unexpired setup. New Import in the directory clears the current draft; switching tabs alone preserves an unfinished draft. History includes standard, Multi-Filer, and Advanced spreadsheet imports only.
Import Detail Card
Click New Import or Switch to New Import to start a fresh file. The Choose file / Drop spreadsheet here area glows green for about ten seconds to guide you to the upload step. Choosing a file clears the glow and begins upload and inspection. Selecting an existing import lets you resume an unfinished upload or monitor queued, processing, completed, and failed work.
Hard Skip Diagnostics
Completed or failed spreadsheet imports with skipped rows can open a read-only diagnostics modal. Review status, skipped rows, available details, and last update time; the reason summary groups skips. Each row shows every recorded issue separately, with readable field names and its rule code. Refresh Diagnostics checks for additional retained details; either Close button returns to the import. Missing details can reflect limited loading or expired diagnostics. Detailed diagnostics are available only while the temporary source details remain available.
Workbook security checks
File contents are checked automatically. Renaming an executable or another document to XLSX, XLS, or CSV will not make it acceptable. Wait for the file type and integrity checks. The malware scan runs in the background and does not delay import. Select the small shield icon in the review header to open Workbook security details. Findings appear inside this dialog. Close it or press Escape to return to your import without losing your place. A green shield means no malware was detected; an unfinished, failed, or unavailable scan is never shown as clean and still allows import. Macro or external-link findings are informational; a confirmed malware hit quarantines the file and blocks downloading or importing. Use a different source file and contact support if a file is quarantined. A scan cannot guarantee safety, and the uploaded bytes are not changed.
View Imported Records
After a running import completes, choose Yes, view records or No, stay here. New-filer imports also stay on this page until you choose Yes. For a Multi-Filer Import, Yes opens the first imported filer; use Select filer to view the others. The prompt does not repeat when you refresh a finished import or open older completed history.
New Filer Details From Your Workbook
For a standard template, enter the company or filer name and telephone number on the Filer Information sheet. When you select Create a new filer, New Filer Name and Legal business name start with the company name, City comes from its separate city field, and Telephone Number comes from the telephone field. Review or edit these values before launch. A Multi-Filer workbook uses the filer information on each form row instead. When you create a new filer from either spreadsheet import wizard, it automatically becomes Current Active Filer with its filing year as soon as the filer is saved. If creating the filer fails, your previous active filer stays selected.
Review and revise an import
Use Upload And Inspect Columns to inspect the selected file, then Open Advanced Import Wizard for a custom spreadsheet. Change filer and Change form return to those choices. Edit mappings or Fix mappings returns to the column assignments before launch. Recipients Manage opens the imported records.
Completion emails
Optional completion emails list the destination filer names, including filers created by the import. If more than 20 filers are involved, the email shows the first 20 and explains that additional filers are included.
IRS 1220 review
Review the source year, original-return counts, filers, sample and forms summary. Affirmatively choose general information only or with details. G/C correction records are excluded in both modes. Use Next: Import, then Launch Import; Back changes the choice before launch. Save for later preserves the draft, and the security shield shows scan results. General-only recipients need form completion. Invalid imported business data remains available for repair. If a tax ID type cannot be determined, Business is selected provisionally. Review the type and Tax ID before filing; choosing Business does not clear validation issues. After import, open Filers to see the newly created records.
Actions and controls
- Use New import to upload and prepare a spreadsheet. Use Import history to find saved spreadsheet runs; accounting runs are listed in Accounting integrations instead.
- Open Recipients -> Imports -> Spreadsheets & 1220 from the left navigation.
- Run spreadsheet imports with an ordinary active Account User role; Account Admin access is not required.
- Open this import page directly; you do not need to visit Recipients -> Manage first.
- Upload one XLSX, XLS, CSV, or IRS 1220 file. The contents determine the import format, even when a 1220 file has a different filename extension.
- Keep CSV and text/binary 1220 uploads at or below 25 MiB, and XLS/XLSX uploads at or below 10 MiB.
- Use Search in the left import directory to find submissions by file name, status, ID, import type, or error text without moving the right-side import detail workflow.
- Use Sort By to order imports by Created Date or, when Search has text, by Search Relevance.
- Use Directory Filter to narrow the directory by status: Upload Pending, Queued, Processing, Finalizing Metrics, Completed, or Failed.
- Use Rows plus Previous and Next to move through longer import histories without loading only the first screen of records.
- When recent imports load, the newest row is selected automatically so its detail actions are ready immediately.
- Use New Import in the directory header to clear the current draft file and preview state. The Choose file / Drop spreadsheet here area glows green briefly to show your next step. Select any directory row to return to that import's detail.
- For Advanced Import, step 1 asks you to choose Current active filer or Create a new filer in the main panel. No active filer is needed to upload or create a filer. Existing destinations keep their filing year; new filers can choose a supported Filing Year and Business or Individual before continuing.
- Upload and inspect spreadsheet headers using the system default preview size.
- For very large files, preview row totals can show as an estimate with a plus sign until background processing finishes the exact count.
- Use the Advanced Import wizard when detection classifies the file as a custom spreadsheet.
- Map all targets in grouped Form Mappings sections, with common recipient fields first and form-data fields organized by IRS box or line number when those references are available.
- In Form Mappings, review friendly target labels, grouped box/line sections, and plain-language hints while still seeing the technical field ID.
- Use Search columns to find a spreadsheet column, then drag it to a target or select it from that target's source-column dropdown. Expand or collapse a field group to keep the mapping list manageable.
- Use Auto-map suggestions to rerun column matching and a brief AI review of column meanings. Fresh advanced mappings also receive this review automatically. Your manual choices, including individually cleared fields, are preserved. Clear removes all choices so Auto-map can start fresh. Changing the form or Filing Year resets form-specific mappings while keeping common recipient mappings. Auto-map becomes available after the selected form fields finish loading.
- Review AI updated and Needs review labels beside mapping fields. Undo AI changes restores the suggestions from before that review and is available until your next edit. You can keep editing while the review runs; your changes take priority.
- AI reviews column headings and mapping choices only; spreadsheet rows and sample values are not sent for this review. It shares your existing Help allowance. If review cannot finish, the message explains whether the allowance, spreadsheet size, service availability, or an unusable reply prevented it. You can continue with standard suggestions; clicking Auto-map suggestions requests a fresh review.
- Use the five screens in order: Filer, Form, Map columns, Review, and Import. Review combines Sample rows and Mapping plan tabs with the review checks. Next advances, Back returns, and completed steps can be revisited. Close leaves the wizard without launching. Controls pause while saving or launching. If any spreadsheet columns are unused when you leave Map columns, a confirmation lists them. Choose Back to mapping to include them or Continue to leave those values out.
- Use the Business Name mapping target for organization rows, and use First Name plus Last Name for individual rows.
- If a row has both Business Name and person name values, import treats that row as a business recipient.
- For standard E-File Magic and Multi-Filer templates, fill the business primary-name column for a business, or leave it blank and fill first and last name for an individual. No entity-type column is needed. A filled primary business name wins if both sets are entered; a second business-name line alone does not select Business. Missing or partial names are imported with validation issues for correction.
- Those templates share one address layout: street, city, state/province, ZIP/postal, and country code. Leave country blank or enter US for a domestic address; enter the IRS country code for a foreign address. Canada requires a recognized province code. Other countries do not universally require province or postal values; for Form 1042-S, leave province blank outside Canada. Mailing country and country of residence are separate fields.
- Older foreign-address Y/N flags and dedicated foreign columns still work. Resolve a missing country on a foreign row, a flag that contradicts its country, or conflicting shared and dedicated province/postal values before filing. The importer does not invent missing address information.
- Download Excel template in Imports and Import Services provides one combined workbook for 2022–2026. Keep Filer Information and enter the filing year in B13; that value drives standard-template imports. You may delete unused form worksheets or columns. Blank, unrecognized and year-inapplicable columns are ignored. Keep recognized field names and the hidden template-information sheet. Duplicate applicable fields and invalid repeat slots still need correction. Required taxpayer data is still validated on imported rows. The combined workbook contains 41 form tabs, a Field Guide and Country Codes. Annual Multi-Filer workbooks retain row-level filer information. Start data on row 2. Empty tabs for unavailable years are ignored; populated unavailable forms require correction.
- Use the numbered columns provided for repeating entries. Match the same number across every field for one participant. The 8955-SSA sheet includes 100 participant slots; expand its grouped columns to use slots 2 through 100. Do not duplicate headings, add unsupported numbers or combine multiple entries in one cell.
- Standard imports use one selected filer. Import 1042-S separately from 1099-class forms using the appropriate configured filer. The new Multi-Filer workbook can create domestic business filers for either program, but its 1042-S sheet requires the withholding-agent details shown in the Field Guide. For an individual filer, use a standard workbook and choose Individual when creating the filer in review, or select an existing filer. Foreign filers require setup in Filers first.
- Only in E-File By Excel and INLINEF Excel templates, you may add any descriptive text before an underscore in a column heading: Business_Name1, Business_Name2, or Recipient_EmailAddress. Keep the supplied field name after your prefix unchanged, including any numbered repeat slot. Prefix text may contain spaces or more underscores. In older templates, keep the complete original heading, such as Payroll_Box1_NEC. Use each field only once; different prefixes cannot distinguish duplicate columns. This option does not apply to CSV, Advanced Mapping, or accounting imports.
- Unknown columns are ignored rather than mapped. Check the imported values when a heading was misspelled. For a year mismatch, use a destination filer matching Filing Year in Filer Information. Missing columns do not block template recognition; required row values can still produce validation issues.
- Template sample rows show the business name or the combined personal-name components for review. Tax IDs stay masked; missing names show a dash rather than the filer name or customer identifier.
- Common recipient mappings (for example Tax ID, Address Line 1, City, State, and ZIP) are mirrored into required form common fields during import processing when those form fields are not explicitly mapped.
- When importing U.S. state values, full state names are normalized to two-letter postal codes (for example Oregon -> OR).
- Run preflight preview to see imported data and target fields before launch, including currency fields shown in USD display format.
- Spreadsheet imports use dollars: INLINEF, standard templates, and advanced CSV/XLS/XLSX interpret 1234 as $1,234.00 and 1234.56 as $1,234.56. Numeric and text Excel cells both work; do not multiply file amounts by 100. E-File Magic converts money fields to internal cents, leaving account numbers, rates, and counts unchanged. More than two decimals round to the nearest cent, half away from zero. Invalid or overflowing money skips the row with field-specific diagnostics. If an older upload is rejected because it predates consistent dollar handling, start a new import from the original file and review any already imported recipients to avoid duplicates; saved amounts are not automatically changed.
- For Multi-Filer Import workbooks, filer tax ID, ZIP, and phone columns can be typed as ordinary spreadsheet numbers or text. Use text formatting when a tax ID starts with zero so Excel does not drop the leading zero.
- When you move from Mapping to Preflight Preview, the current mapping is auto-saved so closing and resuming keeps your latest selections.
- This workflow always creates new recipients for imported rows; Recipient ID is not a mappable target.
- Launch asynchronous import processing from the final wizard step.
- Large spreadsheet and CSV imports continue in the background and can resume from saved progress if processing is interrupted.
- Resume upload-pending submissions from Selected Import and reopen the correct preview or mapping workflow for the detected import type.
- Delete upload-pending submissions when you need to discard a draft import.
- Monitor queued/processing imports with live progress bars in the left import directory and the Import Detail card; a new run starts at 0% until rows begin processing or the total row count becomes known, and automatic status refresh runs about every 5 seconds without a full-page loading mask.
- For completed or failed spreadsheet submissions with skipped rows, open Hard Skip Diagnostics in Selected Import to review a reason summary and row-level skip details in a large modal.
- When an import finishes with imported records, View imported records? appears. Choose Yes, view records to open Recipients for the destination filer, or No, stay here to keep reviewing the import. Closing the dialog also keeps you here. The prompt waits until processing and Finalizing Metrics finish and does not appear for failed imports or imports with no records.
- Imported rows run the same form, filing-year, and IRS filing checks used by manual entry, even when a row is kept for follow-up review.
- For 1099-MISC, 1099-NEC, and 1099-R rows with Form State PA and a positive State Income Tax Withheld amount, use exact EIN or SSN/ITIN punctuation for both filer and recipient Tax IDs. An import with an indeterminate type is retained but marked invalid for correction; other unpunctuated Tax IDs and a Pennsylvania address by itself remain acceptable.
- For standard E-File Magic templates, drag or select one XLSX/XLS file and it uploads automatically, then opens the preview modal.
- When the template import review opens, use Import setup to choose the active filer or create a new filer. Review the detected-form chips and masked sample rows before launch.
- For Multi-Filer Import workbooks, Import setup confirms that each row routes to the filer detected from that row's filer columns; then review detected forms and masked sample rows before launch.
- For very large template workbooks, the form-plan count can show as Deferred during preview and then finalize during processing.
- Use Y for Yes and N for No in every binary yes/no form field, including standard Excel, INLINEF and mapped custom templates. Yes/No, true/false and 1/0 are accepted aliases for binary fields and saved as Y/N. Fields with coded choices such as 1,2,3 keep their listed codes; consult the dropdown or Field Guide.
- In Advanced Import, complete filer setup, then choose Target form on the Form screen. Next: Review requires at least one form box or line mapping. Check the sample values and mapping plan in the same review, then select Next: Import for final confirmation. Launch Import starts processing; Back and Close never start it.
- Create a domestic business or individual filer in either import wizard using editable Filing details. Choose Business or Individual under Entity Type. Business shows legal business names; Individual shows First Name, Middle Name, Last Name and Suffix. Template information is prefilled when available; Advanced Import requires you to enter missing details. For a 1042-S filer, also complete issuer country, EIN type, and Chapter 3 and Chapter 4 status codes. Foreign filers should be created in Filers first and selected as the active destination. Choose State from the searchable state list; you can search by name or abbreviation. The list includes the states and territories supported for the selected filer and year.
- New import history stays available until its filer is deleted. A Multi-Filer import stays available until its last associated filer is deleted. Unattached upload drafts and temporary source details expire after 48 hours. Imported recipients and the saved result counts do not expire with those temporary details. Older history that has already expired cannot be recovered here.
- INLINEF keeps filers with missing or invalid business details and imports their recipient rows. After the import, open each filer marked Needs attention, select Validation Issues, correct the fields and Save. Check recipient Validation Issues too before filing. The filing year and workbook structure must still be supported. Standard imports can create a filer during setup; that reviewed new-filer form must be valid before launch.
- For IRS 1220, Review shows the source tax year, detected filers, recipient count, sample records and form counts. A plus sign means the preview count is partial. The supported information-return files contain 750-byte T, A, B, C, optional K and F records.
- Use Next: Import to review the launch step, Back or the completed Review step to return, and Launch Import to start background processing. Save for later, Close, or Escape keeps the uploaded draft in Import history. Resume Import Preview reopens it. Controls pause while launch is in progress.
- 1220 imports create filers from the file and assign each recipient to its preceding filer. They do not ask for spreadsheet column mappings or an existing destination filer. Multiple form groups for the same filer share that imported filer when its identifying and contact details agree.
- 1220 amounts use the file’s fixed decimal positions and are preserved exactly. No spreadsheet dollar conversion or automatic rounding is applied. Amounts that the selected annual form cannot accept remain available for repair.
- Invalid filers and recipients are still imported and marked invalid. Review their validation issues before filing. Composite names, foreign addresses, correction indicators and source values without an exact counterpart may require manual review.
- Open the shield beside the filename for scan details. Escape or Close returns to review. A rejected file structure blocks import and reports the record and byte position when available; confirmed malware also blocks launch. Fix structural problems in the source-producing application and upload a new file.
- Choose Import Filers and Recipients to bring in general information only. Amounts and form details remain blank, and recipients are marked invalid until completed and validated.
- Choose Import Filers and Recipients with Details to include amounts and form-specific information. Neither option is preselected; you must choose before continuing.
- 1220 imports process original returns only. Payee records marked G or C are skipped, and correction-only groups do not create filers. Review and import history show excluded correction counts.
- Download Excel template in Imports and Import Services provides one combined workbook for 2022–2026. Keep Filer Information and enter the filing year in B13; that value drives standard-template imports. You may delete unused form worksheets or columns. Blank, unrecognized and year-inapplicable columns are ignored. Keep recognized field names and the hidden template-information sheet. Duplicate applicable fields and invalid repeat slots still need correction. Required taxpayer data is still validated on imported rows.
If you get stuck
I cannot start import processing.
Upload or resume the draft so its review wizard opens. Choose the active filer or complete Create a new filer, review the details, then click Launch Import. Multi-Filer Import uses the filers in the workbook. If start is still rejected, wait for any active filer mass-archive/delete run or order snapshot run on that filer to finish before retrying.
Completed import shows skipped rows but I cannot see why.
In Import history, select the spreadsheet and click Open Hard Skip Diagnostics while temporary details remain available. Review the grouped reasons and row details. Accounting runs and their grouped diagnostics are in Accounting integrations, Import history. Expired details cannot be recovered by refreshing.
An import completed but some recipients are marked invalid.
These recipients were saved with validation errors. Open each affected recipient, review Validation Issues, correct the information, and save. They must pass validation before filing. Hard Skip Diagnostics covers rows that were not imported; it does not retry or repair them.
A saved import says its temporary details expired.
Review its saved status and counts and open the imported recipients. Start a new import to collect fresh source data. Expired source details and diagnostics cannot be resumed or restored by refreshing.
More troubleshooting (19)
Upload fails with unsupported file type.
Choose an XLSX, XLS, CSV, or Publication 1220 file. Native 1220 files accept .irs, .txt, .1220, .dat, and .fire; another extension or no extension is accepted when its contents can be identified. Click or 1220 file for help. Renaming an unrelated file does not make it importable. If the contents cannot be identified, export a fresh 1220 file from the source system.
The upload was interrupted before the preview opened.
Retry the same upload from the current import. The system reuses the pending import and provides a fresh upload link instead of creating another draft. If your access or the import status changed, refresh Selected Import before continuing.
I do not see forms in the selector.
On Filer, choose Create a new filer if no filer is active, select its Filing Year and complete the required details. Choose Target form on the next screen. For an existing destination, check Current Active Filer. Wait for form choices and filing requirements to load; use Reload filing requirements if needed.
I opened Imports directly and the form selector is empty.
Wait for form choices to load on the Form screen. If no filer is active, return to Filer and choose Create a new filer. Select its supported year there, then continue to Form. You do not need to visit Manage Recipients first.
The import directory shows no rows.
Click Refresh in the import directory. The list shows spreadsheet imports across the organization, including Multi-Filer Import submissions that are not tied to one active filer.
Resume or Delete buttons are disabled.
Resume and Delete only work when status is Upload Pending. A Failed import offers Retry Import to choose a corrected file and review a new import. It does not replay the stored spreadsheet or remove already imported records. Import permission is required.
Delete Pending Import fails.
Refresh the Selected Import once and try again. If the draft is unusually large, start a fresh upload instead of retrying partial deletion; the platform blocks incomplete cleanup.
Import is queued/processing for a while.
Progress bars and counters update automatically while the status is Queued or Processing. Large files may advance in visible increments, and temporary processing failures are retried automatically. Use Refresh only when you need an immediate status check, and keep monitoring until the status changes.
Inline-filer import says FilerTaxID is invalid even though the cell looks correct.
Open the imported filer and select Validation Issues. Correct the Tax ID and Save; the recipient rows remain imported. An EIN needs exactly nine digits. In future workbooks, format the column as text to preserve a leading zero. Do not reimport a completed workbook just to repair this filer.
Some rows imported as individuals when they should be businesses.
Confirm the spreadsheet business-name column is mapped to Business Name in the wizard. Rows with Business Name populated are imported as business recipients, even if person name columns are also mapped.
The security notice says Local test.
This is a harmless development test workbook. Its malware result is simulated, and no malware engine ran. The normal pending and quarantine restrictions still apply so the workflow can be tested. Ordinary files in local development show malware scanning as unavailable.
Creating a new filer reports a business-name error, or Launch Import stays unavailable after changing New Filer Name.
New Filer Name is the display label. Under Filing details, correct Legal business name and any other highlighted fields. Legal names allow letters, numbers, single spaces and the listed punctuation; remove commas and periods from the legal name. You can keep them in the display label. If requirements could not load, click Reload filing requirements. The original workbook is not edited. Select a field name in the error summary to jump directly to its input.
The completion dialog could not open my recipients.
Try Yes, view records again. You can also choose No, stay here, then open Recipients from the menu and select the destination filer. The import remains saved.
AI review cannot finish or returns no usable suggestions.
Read the reason beside Auto-map suggestions. If the reply was unusable or the request could not finish, click Auto-map suggestions to request a fresh review. If your allowance is reached or the spreadsheet has too much column information, review the standard matches and assign the remaining columns yourself. You can continue importing. Always review sample rows before launch; suggestions do not validate your records.
An AI suggestion looks wrong, or a field says Needs review.
Select the correct source column for that field. You can also use Undo AI changes before making another edit. A heading such as Amount may have several meanings; inspect your spreadsheet and choose the intended field.
Auto-map keeps a column choice I made earlier.
Manual choices and individual clears are preserved. Use Clear to reset all choices, then Auto-map suggestions to start fresh.
An upload could not be confirmed, or a saved import is no longer available.
Open Import history and refresh the directory. Resume the pending import if its uploaded file is available. If it cannot resume, choose the spreadsheet again to start a fresh import. A new file selection creates a separate draft even when you choose the same file. A deleted or expired draft cannot be resumed. Review completed imports before launching another import of the same data to avoid duplicate recipients.
My INLINEF import completed but the filer needs attention.
This means the filer and its recipient rows were kept, but the filer has details to correct. Open Filers → Validation Issues, review the saved problems and Save corrected details. The original import can finish; later recipient changes, separate imports and orders stay blocked until repair. Review any recipient validation issues afterward.
A 1220 import says the tax ID type is unknown, but Business is already correct.
Business is a provisional selection when the file cannot determine the type. Review the type, Tax ID, and highlighted details. On Filers, click Save even when the details are unchanged; you do not need to toggle the type or edit the Tax ID. Only a successful validated save clears the issues. Choose Individual if that is the correct classification.