Integrations
Your data already has
a starting point.
Choose the import path that fits your records. Bring spreadsheets, Publication 1220 files, accounting data, and supported vendor payments into E-File Magic, then review everything before you file.
Start with a file
An import path for the files you already have.
Upload a Publication 1220 export, choose a ready-made workbook, or use your own spreadsheet columns.
Publication 1220 Import
Bring FIRE-format files from any software source, including multiple filers in one file.
Excel Templates
Use annual form worksheets and supplied headings for automatic template mapping.
Spreadsheet & CSV
Map your own XLSX, XLS, or CSV columns, then review a sample before launch.
Multi-Filer Import
Include filer details alongside recipient and form information on each row.
Accounting and payables
Connect the tools behind your books.
Each source has its own setup and supported data. Find the path that fits your accounting workflow.
QuickBooks Online
Connect through Intuit and map expense accounts for eligible paid vendor activity.
Expense-account mappingXero
Map accounts, calculate paid activity, and select the vendors to import.
Mapped payments and vendor selectionBILL
Use an AP/AR sync token and map supported paid bill activity to form boxes.
Paid AP recordsZoho Books
Connect in your Zoho data center and map a USD organization’s chart accounts.
Chart-account mappingFreshBooks
Map categories for supported paid bills linked to identifiable Bill Vendors.
Supported paid billsBusiness Central
Use the E-File Magic Payables extension and map the relevant G/L accounts.
Payables and G/L recordsWorking in QuickBooks Desktop?
Use E-File Magic for Windows to collect local company records and schedule your import.
A clear path forward
Import first. File when you’re ready.
Bring your records together, review the outcomes, and move into filing with a clear next step.
- 01
Choose your source
Pick the spreadsheet, 1220 file, or connected-accounting path that fits your records.
- 02
Review the setup
Confirm the source, tax year, destination, and any mappings or report settings.
- 03
Launch the import
Start processing explicitly and follow progress and reported issues.
- 04
Review your records
Check recipients and forms before releasing an order for filing and delivery.
You choose when to release your filing order.
Guides & answers
A little guidance goes a long way.
Find the right starting point for your records and prepare for a smoother import.
Recommended reading

Article
Spreadsheet or 1099 Software? Decide Where Each Belongs
Choose where spreadsheets fit and when a filing workspace can help.
Read the guide- Knowledge baseImport a spreadsheet with your own column names
- Knowledge baseConnect your accounting software
Import options FAQs
Which import option is right for me?
Use Excel Templates for a ready-made workbook, Spreadsheet & CSV for your own columns, or a supported accounting connection for eligible vendor payments. If your software produces a Publication 1220 file, you can bring that export instead.
Compare import optionsCan I keep using my current accounting software?
Yes. Use a supported connection or bring a compatible spreadsheet or Publication 1220 export. Review the setup and supported data for your chosen source before importing. You review the resulting forms in E-File Magic before filing.
Connect your accounting softwareCan I import for more than one business?
Yes. Multi-Filer Import and compatible Publication 1220 files can bring several filers together. Accounting connections select one company and destination filer per import, so each business stays separate.
Import forms for several businesses from one workbookDoes importing submit my forms?
No. Importing prepares records in your workspace. Review the recipients and amounts, resolve any issues, then submit a separate order for filing and recipient delivery.
Submit your forms for filing and deliveryCan your team help prepare my spreadsheet?
Yes. Import Services lets you send your spreadsheet to our team for preparation and import. When the records are ready, you review them and complete the filing order.
Ask E-File Magic to help import your spreadsheetExplore Import ServicesStill have a question? Talk to Support
Prepare with confidence
Your next filing starts here.
Explore your import options, or talk with our team.