Setting the structure in Sheet TB

Sheet TB (short for Trial Balance) will function as our List of Accounts (or Chart of Accounts) and Trial Balance.

You may think it a bit strange that a Chart of Accounts can simultaneously function as the Trial Balance. But with Excel, it can be done.

Set The Structure In Sheet TB

The next step is to set the structure in sheet TB (for Trial Balance). This sheet is used to contain our List of accounts (Chart of Accounts). It will also serve as the Trial Balance.

Sample structure

Here is a sample of the data structure in sheet TB:

ACCOUNTS	BALANCE SHEET MAIN CATEGORY	BALANCE SHEET CATEGORY	PL CATEGORY	PL DETAIL	RM DEBIT/ (CREDIT)	CHECK DUPLICATE
TOTAL/SUBTOTAL					0.00
Checking row					OK

Below is the explanation, row by row.

14