Creating Trial Balance report using formulas

Creating Trial Balance' Report Using Formulas

The Trial Balance is constructed when we build the structure in sheet TB. When you build the structure in sheet TB, you are effectively building the Trial Balance.

Usually, the Trial Balance is built to enable us to check whether our accounts balance or not, i.e. whether total debits amounts agree with total credits amounts, and whether we have taken all accounts in our book.

As long as your absolute total of RM-DEBIT and RM-CREDIT (both in sheet DATA) agree, your Trial Balance should balance. However, since a complete unique list of accounts is in sheet TB, the Trial Balance in sheet TB should be separately considered because you may not list all your unique accounts in this sheet.

You can refer to 'Step 5 - Set The Structure In Sheet TB' in Topic 2 to see the formulas. Here is a sample of the Trial Balance in TB sheet:

	A	        B	        C	D	E	F
	ACCOUNTS	BALANCE SHEET-

                        MAIN CATEGORY	BALANCE SHEET SUB CATEGORY	PL CATEGORY	PL-DETAIL	RM-NET
1 TOTAL/SUBTOTAL	78,259.733.40	(78.259.733.40)	0.00
2 Checking row		OK
3	CUSTOMER D	CURRENT ASSET TRADE DEBTC NR	NA	1,264,076.37
41 	CUSTOMER E	CURRENT ASSET TRADE DEBTC NA	NA	2.198.702.74
42 	CUSTOMER F	CURRENT ASSET TRADE DEBTC NR	NA	1,423,215.51
43 	CUSTOMER G	CURRENT ASSET TRADE DEBTC NR	NA	2.838.528.18
44 	DEPOSIT-ELECTF CURRENT ASSET OTHER DEBTC NA NR	200.764.37
45 	DEPOSIT TELEPH CURRENT ASSET OTHER DEBTC NA	NA	0.00		
46	DEPOSIT VATER CURRENT ASSET OTHER DEBTC NA	NA	4,000.00
47 	DEPRECIATION-F UNAPPROPRIATE UNAPPROPRI DIRECT EXPEN DEPRECIAT	72.976.72
	DEPRECIATION-A UNAPPROPRIATE UNAPPROPRI ADMIN EXPENI DEPRECIA 	265.052.05
	DIRECTOR A 	CURRENT ASSET: OTHER DEBTC NA NA					42.004.96
	DONATION UNAPPROPRIATE UNAPPROPRE ADMIN EXPENE DONATION			200:00
	ELECTRICITY FAC UNAPPROPRIATE UNAPPROPRI DIRECT EXPEN ELECTRICIT	1.363.20
	ELECTRICITY VOI UNAPPROPRIATE UNAPPROPRY ADMIN EXPEN ELECTRICIT		544.22
	ENTERTAINMENT UNAPPROPRIATE UNAPPROPRI ADMIN EXPEN ENTERTAIN		4.822.38
	UNAPPROPRIATE UNAPPROPRI ADMIN EXPENI EX-GRATIA 54 EX GRAΤΙΑ		(5.706.09)
	NA FINANCE CO A CURRENT LIABIL OTHER CREDI MA
	GAIN LOSS FROI UNAPPROPRIATE UNAPPROPP OTHER INCOME GAINELOSS
	GAINIELOSS) FROI UNAPPROPRIATE UNAPPROPRI OTHER INCOMI GAINILOSS
	GUARANTEE CAF UNAPPROPRIATE UNAPPROPRI DIRECT EXPEN GUARANTE

	HOLDING COMPA INTER.COMPANY HOLDING COM NA NR	10.336.501.21	( 3.9122443330
	INCOME TAX-EXF UNAPPROPRIATE UNAPPROPRI ADMIN EXPENE INCOME TA	8.34050	634050
	INK SOLVENT UINAPPROPRIATE UNAPPROP DIRECT EXPEN INIK SOLVEN	320.00	300M

	INSURANCE CLAIR UNAPPROPRIATE UNAPPROPRI OTHER INCOME INSURANCE	(2.300.60)
60 	INTEREST IN SUSE CURRENT LIABILI OTHER CREDI MIR	NR	0.00	(1.022001)
	INTEREST IN SUSI CURRENT LIABIL OTHER CREDY NA	
    

0.00 (1630.36) (16328) INTEREST RECEN UNAPPROPRIATE UNAPPROPRI OTHER INCOME INTEREST F 0.00 The figures in column H (RM-NET) are affectively the Trial Balance figures. 51