Accounting Trial Balance Sheet

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.

Supplies:

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.

Step 20:

If numbers showed up in the rows with your “Total” and “Net Income” then your Trial Balance Sheet worked.

Step 21:

Congrats you now have a fully working Trial Balance sheet to help organize your work.

Share

    Recommendations

    • Arduino Contest 2019

      Arduino Contest 2019
    • IoT Challenge

      IoT Challenge
    • Colors of the Rainbow Contest

      Colors of the Rainbow Contest

    2 Discussions

    0
    None
    tytower

    26 days ago

    Well thats a lot of good information on setting up a spreadsheet which is what is used mostly by the experienced.

    If you are a learner then try this
    On a large sheet of paper draw about 10 big "T's"
    Call one "Bank" over the top
    Down the right side of that is the money out
    Down the left side is the money in

    Buy a car .. Money out $1000 put that in your Bank "T" account right side.
    Now here is the interesting part .. On another "T" account name it "Car". On the opposite side ..the asset side , put $1000. left side called "Debits"
    If you do a trial balance now add up all the left sides ,they should equal all the right sides..simple

    Pay your rent ..Pay $400 out so Bank $400 out right side ..Open a "T" account called " rent" and left side "expenses" put $400.

    Buy a cow ..Open a "T " account called "Cattle" and debit it ..Money out Bank right side $4000
    Sell a Cow ..Money into bank left side ..debit..$6000 and credit Cattle right side with $6000.

    Now do a Trial Balance...
    Assets &Liabilities ,Income & Expenses

    Now your profit is Cattle 2000 - Rent 400=1600..
    After that money in bank is $600 car is $1000 and that's what you are worth
    If you want more just Google T accounts or Double entry accounting.
    T Accounts.jpg
    0
    None
    Penolopy Bulnick

    26 days ago

    Looks like a lot of good information! Thanks for sharing :)