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
Prices/Order
Tax Forms
Presentation
Labor Law
Download
Support
FAQs
Tips
Testimonials
Resellers/Links
Resources
Contact

Tips Knowledge Base

Search the Tips Knowledge Base for:
All Tips Within Rolling Up Returns
 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 in 'Rolling Up Returns' 
Rolling Up A File of Existing Returns
Multiple Import Rollup Strategy
Tips
Rolling Up A File of Existing Returns
If you have an existing file of returns that contains multiple returns for various recipients, the following procedure explains how to rollup the duplicates, resulting in a single return for each recipient.

a) Open the file of existing returns.
b) From the 'File' menu, select 'Export' to display the Export Options dialog.
c) Move all Available Fields to the Selected Fields area.
d) Click 'Begin' to create an export (EXPORT) file.
e) Close the file of existing returns.
f) Select 'Copy' from the side bar of 'Client (Filer) Management'.
g) Create a new client by assigning a new client id (NEWID) and clicking OK.
h) Using the EXPORT file created in step (d) as the source file in The Import Mapping Utility, create and execute a mapping of all applicable fields back to the same tax form.
i) Double-click the NEWID created in step (g) and open the same tax form as the original returns.
j) Import the destination file created in step (h) using the 'Rollup (or Append)' option. If successful, the resulting file will contain a single return for each recipient.
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