Skip to content

Pricing
User Manual
Marketplace
Contact Us

Pricing
User Manual
Marketplace
Contact Us

Release Notes

3

Version 2.28.2 Release Notes
Version 2.28.1 Release Notes
Version 2.28.0 Release Notes

Installation And Updates

8

TAD Client Portal
Installation Prerequisites
First Time Installations
Loading the Excel Add-in
Replacing the Excel Add-in
Remove the Excel Add-in
Install Updates for 2.28.0 and Later
Install Updates for 2.27.5 and Prior

Licenses and Security

6

How does TAD Security work?
Create SQL Account
Assign TAD License
Delete TAD License
Granting Attachment Access
Reset SQL Account Password

Fundamentals

5

How Does TAD Work
Connecting for the First Time
Changing a Tab Name
Copying a Table/Report
When to Refresh Setup

Advanced Tools

7

Load SQL Statement as Table
Load SQL Statement as Report
When to use Global Parameters
Split Parameter Values
Top Rows Parameter
Understanding Select Functions
Understanding SQL Joins

Power User Tools

2

Calling Action from Custom Macro
Running Custom Macros After Download

Tables

8

Table List
Importing Records
Updating Records
Deleting Records
Edit the Table Structure
Format Table Explained
Saving Column Layouts with Scraper
What are Packages?

Reports

13

Report List
Download a Standard Report
Edit the Report Structure
Change Column Layout
Join Additional Tables
Add Advanced Joins
Filter Data and Create Parameters
Add Sort Order to Download
Using the Report Design Layout
Report Layouts
Add a Company Report to Vista
Download Data from Stored Procedure
Update Stored Procedure Parameters

Templates

14

What Templates are available?
Accruals
Add Posted To Batch
Batches
Company Copy
Financials
Fix Batch Errors
Implementation
Implementation Balance
Implementation Setup
Process
Setup Copy
Setup Imports
Setup Updates

Financials

1

Intro to Financials

Automator

1

Intro to Automator

Blaster

1

Intro to Blaster

Implementations

7

How does TAD help with Implementations?
Implementation Lifecycle
Apply Code Format
Loading Your Setups
Import Balances
Create Your Live Company
Time To Go Live

Converter

7

Intro to Converter
Create a Converter Sheet
Configure Converter Sheet
Using Converter Functions
Process the Converter
Refreshing the Converter
Change Source Data into Table

Batches

1

Intro to Batches

Excel Forms

24

TAD Ribbon
TAD Worksheet
About Form
Attachment List Form
Calendar Form
Initialize Cost Projection Form
Initialize Progress Bill Form
Lookup Form
Move Bill Month Form
Parameter Form
Progress Form
Query Form – Overview
Query Form – Tables Button
Query Form – Reports Button
Query Form – Templates Button
Query Form – TAD Button
Query Form – Options Button
Query Editor Form – Query Button
Query Editor Form – Select Button
Query Editor Form – From Button
Query Editor Form – Join Button
Query Editor Form – Where Button
Query Editor Form – Group By Button
Query Form – Update Action

Vista Forms

15

TAD Forms in Vista
TAD Admin – Licenses
TAD Admin – Log
TAD Admin – Report Security
TAD Admin – Table Security
TAD Admin – Template Security
TAD Admin – Version
TAD Sandbox
TAD Setups – Financial Columns
TAD Setups – Financial Rows
TAD Setups – Reports
TAD Setups – Table Columns
TAD Setups – Table Joins
TAD Setups – Tables
TAD Setups – Templates

Vista Topics

2

AR Aging Balance does not match Vista
Find Table/Column Names for a Field

Setup Imports

Getting Started #

The templates below allow you to import new setups into Vista.

Available Templates #

Setup Imports – JC Add Phase to Job Phases
Setup Imports – JC Add CT to Job Phases

Setup Copy Setup Updates

Table of Contents

Getting Started
Available Templates

© 2025 Transfer All Data

X-twitter Youtube Linkedin