Accounting Training

Chapter 9
Journalizing

Copyright ©Jerry Belch 2015
Projects this week
Chapter 9 worksheet
Cash Receipts Journal
Bromley's Formal Wear Checkbook
Cash Payments Journal
Sales Journal
Purchases Journal
General Journal
Journalize your company's transactions
Chapter Test

Journalizing Tutorial


In the last two chapters we analyzed business tranasctions into their debit and credit parts. After you decide which account to debit and which one to credit, it is time to record these transactions into a journal. This process is called journalizing.
  • All business transactions should first be recorded in a journal.
  • The journal provides a chronological record of these transactions.
  • The recording of the debit and credit parts of each transaction is called double-entry accounting.
  • The source documents, such as invoices, checks, receipts are used to decide the debit and credit parts that are recorded in a journal.
  • Instead of recording all business transactions in one journal, specialized journals are used.
  • They save time because more than one person can journalize at the same time.
  • The number of journals depends on the type and nature of the business.
  • Each journal is used for a separate kind of transaction. For example,
  • Purchases journal is used to record purchase of merchandise on account.
  • The cash receipts journal is for recording all receipts of cash from cash sales and received on account.
  • Cash payments journal is used to record all checks and withdrawls.
  • The sales journal is for charge sales only.
  • The general journal is used for all other types of entries that do not fit into the other four.

At first this might seem a little confusing, but as we go thru the transactions, it will be easier to understand.
  • There are five journals.
  • Each represent transactions that are recorded in a particular journal.
  • Examine the transactions in the columns to the right, then click on the links above for that journal to see how these transactions were journalized using Excel spreadsheets.
  • The transactions are for Bromley's Formal Wear.
  • The business transactions and journals represent transactions for the month of November.
  • When deciding on which account is debited and which one is credited, we must use our chart of accounts.
  • Do not just make up account titles.
  • Look at the chart of accounts for Bromley's Formal Wear prior to completing these exercises.



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
412Other 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
621Utilties Expense
622Alterations Expense
623Interest Expense
624Delivery Expense

Journalizing your company transactions


Now it is time to journalize your own company's business transactions.
  1. Decide on which month, November or December.
  2. Journalize all of your business transactions using the appropriate journal.
  3. You can clear the data from the worksheet, by selecting the cells that contain the data that your want of delete, then press Delete Key.
  4. All of the headings and formulas should remain intact.
  5. You may modify the spreadsheet jounals before entering in your own company's information or your may choose to prepare manual journals.

Cash Receipts Journal Template
Cash Payment Journal Template
Sales Journal Template
Purchases Journal Template
General Journal Template

Cash Receipts Transactions

  • The cash receipts journal is a record of all cash received by a business.
  • This includes cash received from sales and sales tax collected.
  • Any deposit is listed here: business contract,cash sales
  • The journal also records money received from charge sale customers.
  • The general debit column is used to record for example, the sale of old office equipment, or other cash collected that is not directly related to the product or services sold by the company.
  • The source of information for the cash receipts journal is the check register or the on-line bank account.
  • Listed in the table below is a summary of the cash received.

DateTransactionAmount of Transaction
11-1Business Contract$180,025.09
11-1Open House/Sales$136,244.92
11-1Open House/Sales Tax$10,899.59

Now let us decide what accounts should be debited and which acounts should be credited.
  • The business contract:
    1. Debit Cash $180,025.09
    2. Credit Sales $180,025.09
    3. Debits equal credits.
    4. Click on the link in the projects box to see how this transaction was journalized.
  • Open House:
    1. Debit Cash $147,144.51
    2. Credit Sales $136,244.92
    3. Credit Sales Tax Payable $10,899.59
    4. Debits Equal credits.
    5. Click on the link in the projects box to see how this transaction was journalized.
  1. After all entries are made, the journal needs to be proved.
  2. That means that all debit totals should equal all credit totals.
  3. Total Sales, Total Sales Tax Payable and Accounts Receivable Credit and Notes Payable Credit totals should equal Cash Debit total.
  4. If all debits do not equal credits, you should go back through your work to find your error.
  5. The journal has a couple of formulas that verify that the journal is in balance.
  6. See boxes C77 and C78


Cash Payments Transactions

  1. The cash payment journal is to record cash disbursements.
  2. Click on the link for the cash payments journal in the Projects Box.
  3. It has 4 money columns: General Debit, Accounts Payable Debit Purchases Discount Credit and Cash Credit.
  4. The other columns are used to record the date, document number, account title and posting reference.
  5. Some of the transactions in the check-book are checks written.
  6. Other withdrawals are paid electronically and are deducted from our account.
  7. The chart of accounts is necessary when using the format of this cash payments journal.
  8. In accounting, we work with the same number many times.
  9. If we enter the same number, again and again, there is a great probability that we will enter it incorrectly.
  10. The journal you will be looking at has you enter the cash credit amount, then key the the account number you want to debit.
  11. That debited amount is then extended into the proper column and totaled for you, thus reducing the chance of error.
  12. The last two entries involving the payroll are different. An account number is not entered.
  13. Each amount is entered manually.
  14. As in all journals, it must be in balance.
  15. That means that all debits must equal all credits.
  16. Two formulas have been entered at the bottom of the journal, that show if the journal is in balance.
  17. If you are not in balance, you cannot continue with posting these amounts to the general ledger.

Here are the transactions (checks and electronic payments) that are recorded in the check register. This is the source for entries in cash payments journal. Deposits are not included since they are recorded in the cash receipts journal.

Date

Payee

Subject

Amount

11/01

Store Equipment Co.

CK 1101

$47,000

11/01

Staples

610119230

$3,800

11/01

David's Bridal

610119230

$100,000

11/01

Virtu Water

610119060

$87.50

11/01

Virtu Rent

610119117

$3,750

11/01

Virtu Gas

610119079

$87.50

11/01

Virtu Electric

610119087

$875.00

11/01

Cable

610119168

$100.00

11/01

Internet Service

610119192

$350.00

11/01

Virtu Insurance

610119133

$812.50

11/01

Virtual Loan

610119222

$2,163.54

11/01

Office Mart

610119230

$135

11/01

Eddies Tailoring

610119230

$131.75

11/01

Virtu Phone

610119109

$687.50

11/01

Federal Express

610119230

$25.00

11/01

Joe's Plumbing

610119230

$350.00

11/01

News Press

610119230

$500.00

11/01

Kerri Hall

610119230

$200.00

11/01

Eddie's Tailoring

610119230

$327.50

11/01

Channel 3

610119230

$500.00

11/01

Virtual Bank

610119230

$60,858.42

11/01

Franchise Tax

610119176

$21,933.76

11/01

Internal Revenue

610119184

$39,683.53

11/01

CEO pay-check

$5,102.56

11/01

CFO pay-check

$4,805.27

11/01

VP Sales pay-check

$3,699.34

11/01

VP Marketing pay-check

$3,699.34

11/01

VP Advertising pay-check

$3,699.34

11/01

VP HR pay-check

$3,699.34

11/01

VP Technology pay-check

$3,699.34

11/01

Adm Assist

$3,699.34

11/01

Sales Assist 1 pay-check

$2,736.84

11/01

Sales Assist 2 pay-check

$2,736.84

11/01

Sales Assist 3 pay-check

$2,736.84

11/01

Sales Assist 4 pay-check

$2,736.84

11/01

Sales Assist 5 pay-check

$2,736.84

11/01

Marketing Assist 1 pay-check

$2,736.84

11/01

Marketing Assist 2 pay-check

$2,736.84

11/01

Marketing Assist 3 pay-check

$2,736.84

11/01

Event Planner pay-check

$2,736.84

11/01

Payroll Clerk pay-check

$3,699.34

11/01

A/R Clerk 1 pay-check

$3,699.34

11/01

A/R Clerk 2 pay-check

$3,699.34

11/01

Human Resources Assist pay-check

$2,736.84

11/01

Banker pay-check

$3,699.34

11/01

Web Design pay-check

$2,736.84

11/01

IT assoc 1 pay-check

$2,736.84

11/01

IT assoc 2 pay-check

$2,736.84

On November 2 there are two amounts that need to be explained. This transaction involves paying on the Note, the money you borrowed from VE. The first amount, $655.54 is payment on the principal. The other amount, $1,508.00 is interest expense. Together the two add up $2,163.54 the amount listed in the check-book