Accounting Training

Chapter 10
Posting General Ledger
Posting Accounts Receivable Ledger
Posting Accounts Payable Ledger
Taking a Trial Balance

Copyright ©Jerry Belch 2015

Projects this week
Chapter 10 worksheet
General Ledger
Cash Receipts Journal
Cash Payments Journal
Sales Journal
Purchases Journal
General Journal
Journal Summary
Accounts Receivable Ledger
Accounts Payable Ledger
Chapter Video
Set up your company's general ledger, accounts receivable ledger, accounts payable
Post totals from specialized journals to your general ledger
Chapter Test



Navigation Tool

Accounting Terms in This Chapter
Click on terms.

Posting
Balance Sheet Accounts
Income Statement Accounts
Recording the Loan
Posting Initial Investment
Posting from Cash Receipts Journal
Posting from Cash Payments Journal
Posting From Sales Journal to General Ledger
Posting AR From Sales Journal
Posting to AR Ledger from Cash Receipts Journal
Posting Purchases to General Ledger
Posting Purchase To AP Ledger
Trial Balance and Schedule of Account

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.
  1. The journal does not sort the entries into accounts.
  2. The journal does not show in one place, for example, utilities expense.
  3. A journal does not supply account balances for preparing up-date financial records.
  4. In order to see how transactions have changed account balances, posting from the different journals to the accounts is necessary.
  5. Posting is a simple sorting process that transfers amounts from the journals to the appropriate accounts in the ledger.
  6. 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.
  7. The assets, liabilities and stockholders' equity accounts are on the balance sheet.
  8. The revenue and expense accounts are on the income statement.
  9. The ledger is arranged in the same manner.
  10. We need to look first at Bromley's Formal Wear General Ledger.
  11. Click on the link above to view the general ledger.
  12. Account names and numbers are filled in
  13. As you can see they match the chart of accounts.
  14. 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 NumberAccount Name

ASSETS (1)

111Cash
112Accounts Receivable
113Furniture and Fixtures
114Accumulated Depreciation Furniture
115Office Supplies
116Other Assets
117Office Equipment
118Accumulated Depreciation Office Equipment
119Prepaid Insurance
120Inventory

LIABILITIES (2)

211Notes Payable
212Accounts Payable
213Workers' Comp Payable
214Federal Income Tax Payable
215FICA Tax Payable
216Medicare Payable
217FUTA Payable
218SUTA Payable
219Sales Tax Payable
220SDI Payable
221State Income Tax Payable
222State Training Tax Payable

STOCKHOLDERS' EQUITY (3)

311Common Stock
312Retained Earnings

REVENUE (4)

411Sales
412Sales Returns
413Other Income

COST OF MERCHANDISE SOLD (5)

511Purchases
512Purchase Returns

EXPENSES (6)

611Salary Expense
612Rent Expense
613Repairs Expense
614Advertising Expense
615Supplies Expense
616Depreciation Expense
617Insurance Expense
618Miscellaneous Expense
619Payroll Taxes Expense
620Legal and Accounting expense
621Utilities Expense
622Alterations Expense
623Interest Expense
624Delivery 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.
  1. The first one is to record the loan.
  2. The amount of the loan was for $15,800.00.
  3. The amount was determined by the items that we needed to start up our business: Furniture & Fixtures, Office Equipment, Supplies, and Merchandise Inventory.
  4. As you can see two accounts, Cash and Notes Payable are involved in this transaction.
  5. 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.

  6. Post the second entry from the General Journal, the one relating to common stock and cash.
  7. Follow the same procedure as listed above.
  8. Cash Posting
    • Cell A9 for the Date, 11-1
    • Cell C9 for posting reference, GJ1
    • Cell D9 For the debit amount of, 85,000
  9. 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
  10. Post the next two entries for salary expense and payroll taxes in the same manner as instructed above.
  11. How do you know if you posted correctly?
  12. 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.
  13. 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.
DatePost RefAmount
Sales

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

Cash

Cell A11 - 11/30

Cell C11 - CR1

Cell E11 - $327,169.60

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.
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.
  1. Click on the link for the Cash Payments Journal
  2. Scroll down to row 30. These are the numbers to be posted to the general ledger
  3. 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.
  4. 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)
  5. 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.

Account DebitedAccount creditedAmountPost to Cell

Cash

284,406.45

E12

Furniture & Fixtures

47,000.00

D27

Office Equipment

3,800.00

D65

Mdse. Inventory

100,000.00

J84

Notes Payable

655.54

D104

Fed Inc Tax Payable

20,497.70

J123

FICA

14,776.66

D143

Medicare

3,455.84

J143

FUTA

953.33

D161

State Income Tax

6,267.50

D199

SUTA

4,051.67

J161

Sales Tax

10,899.59

D180

SDI

595.83

J180

State Training

119.17

J199

Purchases

60,858.42

J255

Advertising Expense

1,000.00

D132

Delivery Expense

25.00

D407

Insurance Expense

812.50

J331

Interest Expense

1,508.00

J388

Miscellaneous Expense

200.00

D350

Repairs Expense

350.00

J293

Supplies Expense

135.00

J312

Alterations Expense

459.25

D388

Rent Expense

3,750.00

D293

Utilities Expense

2,187.50

J369

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.