How do you complete a trial balance?

Steps in Preparation of Trial Balance

1. Calculate the Balances of Each of the Ledger Accounts.
2. Record Debit or Credit Balances in Trial Balance.
3. Calculate Total of The Debit Column.
4. Calculate Total of The Credit Column.
5. Check if Debit is Equal To Credit.

What is the correct order on a trial balance worksheet?

On the trial balance the accounts should appear in this order: assets, liabilities, equity, dividends, revenues, and expenses. Within the assets category, the most liquid (closest to becoming cash) asset appears first and the least liquid appears last.

How do you prepare a trial balance sheet?

If you’ve been entering transactions manually, you create a trial balance by listing all the accounts with their ending debit or credit balances. Then, you total the debit and credit columns. If the totals at the bottom of the two columns are the same, the trial is a success, and your books are in balance.

How do you complete worksheets?

How to create a worksheet template

1. Select the worksheet that you want to use as a template.
2. Click the File tab.
3. Under Info, click Save As.
4. In the File name box, type the name of the worksheet template. To create a custom worksheet template, type the file name that you want to use.
5. Do one of the following:
6. Click Save.

What is the purpose of a trial balance worksheet?

A trial balance is a worksheet with two columns, one for debits and one for credits, that ensures a company’s bookkeeping is mathematically correct.

How do you adjust a trial balance example?

Example of an adjusted trial balance

1. Step 1: Run an unadjusted trial balance. Account. Debit. Credit. Cash. 10,000. Accounts Receivable. 7,000.
2. Step 2: Enter adjusting journal entries. Account. Debit. Credit. Rent Expense. 700. Prepaid Rent. 700.
3. Step 3: Run an adjusted trial balance. Account. Debit. Credit. Cash. 10,000. Accounts Receivable.