How To Create an Accounting Trial Balance Sheet

By Jack L.

The instruction set down below are for beginners people who are new to accounting to help keep their information clean and organized. In this guide, I will be showing you how to creating a Trial Balance Sheet that will stay organized and holds your Trial Balance, Income Statement, and Balance Sheet.

Step 1:

Fist sign into google docs and create a new google spreadsheets.

Step 2:

The numbers are rows and the letters are the columns, go to the first row and select column A through J, then click the format button at the top, go to the merge cell, and click merge horizontally, type “Name”

Step 3:

Go to row 2 and in row 2 repeat step 2 but instead of typing name, type “What it is”

Step 4:

Go to row 3 and in row 3 repeat step 2 but instead of typing name, type “Date”

Step 5:

Go back to the first three rows you just merged together and select them, then on the toolbar mouse over to the button that has four lines, click the button and center the words in the rows.

Step 6:

Now go to row 4, select row 4 and 5 in column A. click the format button, go to merge cell and click merge vertically. Repeat this same exact step in columns B, C, and D.

Step 7:

Then still in the merge that we just made, type in column A “Date”, in column B type “Account number”, in column C type “Account Name”, and in column D type “Account type”

Step 8:

Then in row 4, select column E and F then merge them together and type “Trial Balance”, select column G and H then merge them together and type “Income statement”, select column I and J then merge them together and type “Balance Sheet”

Step 9:

Go to row 5, in column E type “Debit”, in column F type “Credit” in column G type “Debit”, in column H type “Credit”, in column I type “Debit”, in column J type “Credit”.

Step 10:

After that go down as many rows as you would like, you do not need to click anything just move down.

Step 11:

At the second to last row, In column C type “Total”.

Step 12:

Go to column E and create a sum formula,(example of my sum formula “=SUM(E6:E30)”) you would put the cell numbers into the parentheses. Only use the cells from that column.

Step 13:

Then click format button and go to “Numbers”, then click on accounting. That will set the value to dollars in that cell

Step 14:

Repeat step 11 and 12 for Columns F,G,H,I, and J

Step 15:

Then go to the last row and in column C type “Net Total”

Step 16:

In the last row, go to column G and create a subtraction formula, (example of my subtraction formula “=H31-G31”) you would want to put the second to last row H column minus the second to last row G column, then click format button and go to “Numbers”, then click on accounting.

Step 17:

In the last row, go to column J and create a subtraction formula, (example of my subtraction formula “=I31-J31”) you would want to put the second to last row I column minus the second to last row J column, then click format button and go to “Numbers”, then click on accounting.

Step 18:

Select all the columns and rows you used in your chart, mouse over to the toolbar and click the button that looks like a window called “Borders”, then in the drop down menu click the button that looks like a window again.

Step 19:

Now to test, in each column E through J put any number in between the 6th row and the row that has your “Total”. Try to put at least two different numbers in each column.