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.
Fist sign into google docs and create a new google spreadsheets.
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”
Go to row 2 and in row 2 repeat step 2 but instead of typing name, type “What it is”
Go to row 3 and in row 3 repeat step 2 but instead of typing name, type “Date”
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.
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.
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”
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”
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”.
After that go down as many rows as you would like, you do not need to click anything just move down.
At the second to last row, In column C type “Total”.
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.
Then click format button and go to “Numbers”, then click on accounting. That will set the value to dollars in that cell
Repeat step 11 and 12 for Columns F,G,H,I, and J
Then go to the last row and in column C type “Net Total”
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.
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.
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.
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.
If numbers showed up in the rows with your “Total” and “Net Income” then your Trial Balance Sheet worked.
Congrats you now have a fully working Trial Balance sheet to help organize your work.