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
TIN Matching
Print and Mail
Screen Shots
Tax Forms
Labor Law

Tips Knowledge Base

Search the Tips Knowledge Base for:
 Client Manipulation (1)  Compliance (1)
 Correction Processing (2)  Data Entry (2)
 Database Manipulation (2)  Importing and Rolling Forward (1)
 Network Installations (1)  Printing (1)
 Rolling Up Returns (2)
  Open the 'FAQ' Knowledge Base
Topics for the search 'Multiple Import Rollup Strategy' 
Multiple Import Rollup Strategy
Multiple Import Rollup Strategy
The key to a successful rollup session is to start with recipient demographics!

a) Create a text file, or spreadsheet, containing only recipient demographics (name, address, taxpayer identification number, account number).
b) Using the text file created in step (a) as the source file in The Import Mapping Utility, create and execute a mapping of demographics information only.
c) Import the destination file created in step (b) using the 'Append' option. If successful, this will result in a file of null returns, one for each recipient.
d) Create a text file, or spreadsheet, containing either annual totals or detailed transaction information for each of the recipients imported in step (c) above. Each record of this file must contain a primary key field (such as the taxpayer identification number) for the recipient.
e) Using the text file created in step (d) as the source file in The Import Mapping Utility, create and execute a mapping in order to produce a destination file that Account Ability can import.
f) Import the destination file created in step (e) using the 'Rollup (or Append)' option. If successful, each existing recipient's record will be updated accordingly.

Repeat steps (d)-(f) as often as needed until all recipient returns are complete.

NOTE: When you are all finished, order the resulting file by recipient name and run a 'Control Report' from the 'File' menu in order to verify the results.
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 ©2023 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