Import Multiple Import Session Strategy

Introduction  Previous Topic  Next Topic

Although some applications, such as Intuit's QuickBooks®, are deficient in that they cannot export a recipient's entire 1099 or W-2 to a single file, they can export the information to distinct text files and spreadsheets which, when rolled up over multiple import sessions, result in a single return for each recipient. The following strategy is suggested when rolling up multiple import sessions.

 

1.Create a text file or spreadsheet that contains the name, address, and taxpayer identification number for each recipient to be imported.
2.Using the text file created in step (1) 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.
3.Import the destination file created in step (2) using the Append option. This will result in a file of null returns containing recipient names, addresses, and taxpayer identification numbers.
4.Create a text file that contains annual totals (or detailed transaction information) for each recipient imported in step (3) above. Ensure that each record of this file contains a primary key field (such as the taxpayer identification number) for the recipient.
5.Using the text file created in step (4) 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.
6.Import the destination file created in step (5) using the Rollup (or Append) option. Each existing recipient's record will be updated accordingly.

 

Repeat steps (4), (5) and (6) as often as needed until all recipient returns are complete.