General Ledger Posting Tutorial
View the chapter video before beginning this lesson.
As we learned in the last lesson, each business transaction is recorded in a specialized journal.
- The journal does not sort the entries into accounts.
- The journal does not show in one place, for example, utilities expense.
- A journal does not supply account balances for preparing up-date financial records.
- In order to see how transactions have changed account balances, posting from the different journals to the accounts is necessary.
- Posting is a simple sorting process that transfers amounts from the journals to the appropriate accounts in the ledger.
- If you look at the Chart of Accounts below, you will see that the ledger is arranged in the same order as they appear in financial reports.
- The assets, liabilities and stockholders' equity accounts are on the balance sheet.
- The revenue and expense accounts are on the income statement.
- The ledger is arranged in the same manner.
- We need to look first at Bromley's Formal Wear General Ledger.
- Click on the link above to view the general ledger.
- Account names and numbers are filled in
- As you can see they match the chart of accounts.
- They are arranged by type of account: assets, liabilities, stockholders equity, sales, cost of merchandise sold and expenses.
An Excel spreadsheet called Journal Summary has been prepared for you. You may wish to print it out and use it while you are posting. The information is the same that is contained in the all of the journals.
Bromley's Formal Wear
Chart of Accounts
|Account Number||Account Name|
|113||Furniture and Fixtures|
|114||Accumulated Depreciation Furniture |
|116||Other Assets |
|118||Accumulated Depreciation Office Equipment |
|213||Workers' Comp Payable|
|214||Federal Income Tax Payable|
|215||FICA Tax Payable|
|219||Sales Tax Payable|
|221||State Income Tax Payable|
|222||State Training Tax Payable|
STOCKHOLDERS' EQUITY (3)
COST OF MERCHANDISE SOLD (5)
|611||Salary Expense |
|612||Rent Expense |
|613||Repairs Expense |
|614||Advertising Expense |
|615||Supplies Expense |
|616||Depreciation Expense |
|617||Insurance Expense |
|618||Miscellaneous Expense |
|619||Payroll Taxes Expense |
|620||Legal and Accounting expense |
|621||Utilities Expense |
|622||Alterations Expense |
|623||Interest Expense |
|624||Delivery Expense |
POSTING FROM THE GENERAL JOURNAL
We are going to post the entries from the general journal to the general ledger. Open the General ledger. The link is in the Projects box.
- The first one is to record the loan.
- The amount of the loan was for $15,800.00.
- The amount was determined by the items that we needed to start up our business: Furniture & Fixtures, Office Equipment, Supplies, and Merchandise Inventory.
- As you can see two accounts, Cash and Notes Payable are involved in this transaction.
- Let's post the Cash account first.
- In cell A8, type in the date of the posting , 11-1
- In cell C8, type GJ1. This is the posting reference and states that this number came from the General Journal, Page 1
- In Cell D8, type in 150,800. This where the first debit posting to this account goes.
- The debit total column shows 150,800
- The balance in the account shows 150,800 debit balance.
- Find the Notes Payable account. It is a liability account so, scroll down until you see it.
- In cell A103 enter the date, 11-1
- In cell C103, type GJ1 as the posting reference
- In cell E103, type in the amount of the posting, 150,800
- The total of the credits posting to the account shows at the bottom
- The account balance is a credit balance of 150,800.
- Post the second entry from the General Journal, the one relating to common stock and cash.
- Follow the same procedure as listed above.
- Cash Posting
- Cell A9 for the Date, 11-1
- Cell C9 for posting reference, GJ1
- Cell D9 For the debit amount of, 85,000
- Common Stock Posting
- Cell A217 for the Date, 11-1
- Cell C217 for the posting reference, GJ1
- Cell E217 for the credit amount of 85,000
- Post the next two entries for salary expense and payroll taxes in the same manner as instructed above.
- How do you know if you posted correctly?
- Read the short tutorial on trial balance, then scroll down to the bottom of the worksheet to see if you are in balance after posting these four entries.
- Save your file and turn in a printout toyour instructor.
POSTING FROM THE CASH RECEIPTS JOURNAL
Look at the bottom row of the cash receipts journal to find the amounts that need to be posted. These are the numbers we want to post. They are summarized for your convenience.
The cell locations on the ledger spreadsheet, posting references, date and amounts are summarized in the table below.
Scroll down to the trial balance and see that you are still in balance after posting the cash receipts journal. Save your file and turn in a printout to your instructor.
Cell A236 - 11/30
Cell C236 - CR1
Cell E236 - $316,270.01
|Sales Tax Payable|
Cell A179 - 11/30
Cell C179 - CR1
Cell E179 - $10,899.59 - $316,270.01
Cell A11 - 11/30
Cell C11 - CR1
Cell E11 - $327,169.60
POSTING FROM THE CASH PAYMENTS JOURNAL
If you will remember in the cash payments journal, we used account numbers as codes to record the debit part of the transaction. These code numbers are the account numbers where we want to post these amounts. For example, if we want to post the total amount of salaries we would post it to account 611.
To begin the posting process, follow these steps.
- Click on the link for the Cash Payments Journal
- Scroll down to row 30. These are the numbers to be posted to the general ledger
- The table below shows which accounts are debited and credited, the amount to be posted and the cell number in the general ledger where the amount should be entered.
- You will also need to supply the date of the transaction and the post ref showing that the posting came from the cash payments journal (cp1)
- You notice that all accounts in the cash payments journal are debited with the exception of Cash which is credited the total amount of all the debited accounts.
Scroll down to the trial balance section and verify that you are still in balance before continuing. When you are in balance, save your file. Turn in a printout to your instructor.
|Account Debited||Account credited||Amount||Post to Cell|
Furniture & Fixtures
Fed Inc Tax Payable
State Income Tax