Getting Started With TBTools Trial Balance

To launch TBTools Trial Balance, select Start > TBTools > TBTools Trial Balance > Trial Balance

The program opens with the following screen:

TBTools Trial Balance supports a number of different database formats, depending on your firm's needs. The following chart shows the 5 database types that are supported.

Database Name

Database Type

SQLite (default)

File

Microsoft Access

File

MySql

Server (Database Engine)

Microsoft SQL Server

Server (Database Engine)

The database type you choose will depend on your preferences and needs. The following provides a short summary of each database type, and when you would want to use each.

SQLite - This is the default and simplest database type supported. Each company will be created as a single file that can be stored in any Windows folder, either on your local hard drive or on your file server. This will work well if you are managing a small number of company databases, and want a simple way to store the company database without the complexity of installing a database engine on your server.

Microsoft Access - this is another choice that allows you to store the database files in individual company files. Similar to the SQLite databases, each company creates a single file that can be stored in any Windows folder, either on your local hard drive or on your file server. Similar to SQLite, this will work if you are managing a small number of company databases, and want a simple file-based storage system. This file type also offers the advantage of being able to directly open the company database files with Microsoft Access. This can be used for specialized reporting, or integration with other third party applications.

My Sql - This is a multi-company server based storage engine that offers a free open-source enterprise level database engine. With this selection, all companies are stored within the same server database, so it is required that you install MySql on your server. Another option with this database format is to setup a remotely hosted MySql database through Amazon Web Services, Google Cloud Platform, or Microsoft Azure. Once you create your online database, you simply supply the database login credentials, and all of your company data will be stored in the hosted or server database.

Microsoft SQL Server - This is another server based storage option that can utilize either Microsoft SQL Express or Microsoft SQL Server. With this selection, all companies are stored within the same server database, so it is required that you install a version of SQL Server on your server, or create a hosted online database through Amazon Web Services, Google Cloud Platform, or Microsoft Azure.

Once you have fully considered the above database storage options, select File > Options to open the Firm Setup dialog. On the General tab, select the database type from the list of choices.

Once you have selected your preferred database type, select the tab that corresponds to the database type selected. Additional information will need to be entered based on the selected database type.

If you select "SQLite" as your preferred database type, select the Browse button to select the default file path folder where your company files will be stored. Note that this is only the default path, but you can still save and access SQLite company files from any Windows folder.

If you select "MS Access" as your preferred database type, select the Browse button to select the default file path folder where your company files will be stored. Not that this is only the default path, but you can still save and access MS Access company files from any Windows folder.

If you select "MySql" as your preferred database type, you will need to enter the database connection information for the MySql database. The required fields are Server, Database, Port, User, and Password. This information will need to be obtained using the values that were provided when the database or database engine were installed.

If you select "SQL Compact" as your preferred database type, select the Browse button to select the default file path folder where your company files will be stored. Not that this is only the default path, but you still save and access SQL Compact company files from any Windows folder

Once you have entered the necessary database information, click Save to close the dialog box.