Account Ability prepares form 1098, 1099, 3921, 3922 Account Ability prepares form W-2, W-2C Account Ability prepares form W-2G, 5498, 5498-ESA, 5498-SA
Electronic reporting (efile) IRS TIN matching Print and Mail Services
Like Account Ability on Facebook Follow Account Ability on Twitter Follow Account Ability on Pinterest Account Ability How-To Blog Initiate a desktop support session
Print and mail service Electronic reporting outsourcing service IRS bulk taxpayer identification (tin) matching service
Laser forms and envelopes Continuous forms and envelopes Income tax presentation folders and envelopes
Account Ability prepares 1099 and W-2 forms quickly and easily
About
Home
Features
E-File
TIN Matching
Print and Mail
Screen Shots
Order
Tax Forms
Presentation
Labor Law
Download
Support
FAQs
Tips
Testimonials
Resellers/Links
Resources
Contact

Import Spreadsheets, Text Files, IRS/SSA Transmittals

The Import Mapping Utility Facilitates Importing Spreadsheets and Text Files
The Import Mapping Utility, which is included with Account Ability at no extra charge, converts spreadsheets and delimited text files (comma, tab, pipe) to a format compatible with Account Ability. The main window, shown below, contains two list views — a source view on the left and a destination view on the right. After making a selection from the Tax Form drop down list, the destination view is populated with Account Ability's layout (schema) for the tax form selected. After opening your source file from the Source File group, the source view is populated with the fields comprising the first (header) record of source data. In order to create a mapping, simply drag fields from the source view to their respective fields in the destination view. When done, click the Execute button and your entire source file is mapped to one which can now be imported into Account Ability.

Account Ability's Import Mapping Utility

The Import Mapping Utility supports forms 1094-C, 1095-C, 1095-B, 1098, 1098-C, 1098-E, 1098-F, 1098-T, 1099-A, 1099-B, 1099-C, 1099-CAP, 1099-DIV, 1099-G, 1099-INT, 1099-K, 1099-LTC, 1099-MISC, 1099-NEC, 1099-OID, 1099-PATR, 1099-Q, 1099-R, 1099-S, 1099-SA, 3921, 3922, 5498, 5498-ESA, 5498-SA, W-2G, W-2, W-2C, Clients (Filers, Entities), ACA 1095-B Sponsors, and large ALE Group Members.

Rollup and Append Options — Prior to importing a delimited text file, Account Ability will request that you specify the type of import desired: Rollup or Append. If you specify Rollup, returns for the same recipient are automatically combined into a single return; if you specify Append, returns are appended to the end of file.

Import IRS Pub. 1220 and SSA EFW2 Transmittals — Account Ability can import current year and prior year transmittal files that comply with IRS Pub. 1220 and SSA EFW2 specifications.

Roll Forward Any Part of Your Database Each Year — Since it is not always desirable to roll forward all returns each year, you select which returns to roll forward and whether or not to initialize them for a new calendar year.

Import Another Filer's Returns — One filer can easily import another filer's returns of the same type.

1099 Software W-2 Software  
TIN Matching Software EFile Software EFile Outsourcing Service
  Import Capabilities Tax Forms, Envelopes Presentation Supplies Integrated Data Management Systems, Inc.1099 Tax Forms
  6039 Compliance Jack Henry Forms Income Tax Folders DBA IDMS Account Ability1099 Envelopes
  ACA 1094, 1095 Forms 1098 Forms, Envelopes First Class Envelopes 555 Broadhollow Road Ste 273W-2 Envelopes
  Electronic Reporting 1099 Forms, Envelopes Intuit ProSeries Melville, NY 117473921 Software
  Bulk TIN Matching 3921/3922 Forms, Envelopes Lacerte Software 1-888-IDMSINC (436-7462)3922 Software
  Combined Federal/State 5498 Forms, Envelopes CCH ProSystem fx Copyright ©2020 IDMS Account Ability1099-K Software
  Screen Shots W-2 Forms, Envelopes Drake Software Privacy StatementIncome Tax Folders
  Print and Mail Service 1099/W-2 Laser Kits Labor Law Posters Follow Account Ability on Pinterest  Follow Account Ability on Facebook  Follow Account Ability on Twitter
Account Ability 1099 and W-2 Software