Implementation Balance – AP 1099 Totals

Getting Started #

If you are performing a mid-year conversion, you must load the year-to-date (YTD) AP 1099 totals to account for payments made to your vendors so far.

Template Info #

• Required Source Data
  • Vendor #
  • 1099 Type
  • Various Box Amounts (ideally in separate columns)
• Additional Tips
  • N/A
• Basic Steps
  • Copy source data to Template
  • Import the Records

Start Import Process #

Open your source data file in Excel. The example below is the sample data file.

Click the Templates button on the left side of the ribbon.

If you’ve signed into TAD before, then you should receive the message below. Click Yes.

If you have not signed into TAD before, follow the Get Connected instructions.

Select the Implementation Balance – AP 1099 Totals template.

Click the Download Selected button.

Enter your Company number and click the Download button.

The table should be empty and look like the image below.

Copy and Paste the source data to the 1099 Totals sheet.

For the YEMO column, enter 12/XX where XX represents the year you are loading.

Click the Format Table button.

The *Result column should show Formatted for every record. You should see the default Company number applied.

Click the Validate Import button.

The *Result column should show Validated for every record. If this says Failure, then the *ErrorMsg column will provide the error.

Click the Execute Import button.

The *Result column should show Imported for every record. You can now validate the data in Vista.

Validate Import Data #

You can validate the 1099 Totals by running the AP 1099 Report report in Vista.

Enter your Company and the Year Ending Month that you just imported.

All other parameters should look like the image below.

You can validate the grand totals for each 1099 Box and the Total Form Count in the bottom right.