Description
6 attachmentsSlide 1 of 6attachment_1attachment_1attachment_2attachment_2attachment_3attachment_3attachment_4attachment_4attachment_5attachment_5attachment_6attachment_6
Unformatted Attachment Preview
Template for the Adjusting Journal Entries
Transaction
#
a.
b.
c.
d.
f.
g.
h.
j.
Dr
Dr
Dr
Dr
Dr
Dr
Dr
Dr
Dr
Account
Number
Dollar
Amount
Account
Cr Number
Cr
Cr
Cr
Cr
Cr
Cr
Cr
Cr
Dollar
Amount
*Do not enter the information highlighted in yellow into BB. Some
transactions will have more then one debit or credit
so enter the smallest account first. Do not enter the transaction #
in BB. Use with or without gridlines.
Template for the Adjusting Journal Entries
Transaction
#
a.
BCDFGH
Dr
Dr
Dr
Dr
Dr
Dr
Dr
Dr
Account
Number
201
3241
Account
Dollar
Amount Cr Number
60900 $380.00 Cr
61000 $900.00 Cr
61300 $1,300 Cr
61100 $92.50 Cr
60600 $333.30 Cr
61200 $1,500.00 Cr
60700 $100.00 Cr
900
PP
20
Dollar
Amount
$380.00
$900.00
$1,300
$92.50
$333.33
$1,500.00
13000
13050
23200
17100
14050
14000
23250 $100.00
*Do not enter the infor
transactions will have r
so enter the smallest a
in BB. Use with or withCash
Debit
Credit
70,000.00 9,000.00
10,000.00 4,000.00
12,124.00 1,100.00
12,557.00 14,000.00
8,277.00
750.00
450.00
940.00
250.00
200.00
800.00
6,000.00
12,900.00
74,450.00
14000
Prepaid Rent
Debit
$7,500.00
$7,500.00
17100
Accumulated Depr.-
Debit
Credit
Debit
Debit
910.00
650.00
3,828.00
27000
Note Payable-
Credit
250
40000
$380.00
60500
Credit
10,000.00
92.50
92.50
445
Delivery Expense
250
10,000
Credit
Debit
11,200.00 5,600.00
11,600.00
7,600.00
16,000.00
46,400
60900
Office Supplies Exp.
Debit
Credit
$380.00
61400
Utility Expense
445
5,800
3,800
8,000
23,200
Accounts Receivable
Debit
Credit
$333.33
50000
$333.33
Prepaid Insurance
Debit
Credit
0
$3,666.67
$3,666.67
14050
60600
Accounts Payable
Debit
Credit
8,000.00
6,000.00
4,900.00
800.00
800.00
6,000.00
12,900.00
20000
Debit
27050
Note Payable-
Credit
866.67
Insurance Expense
0
11,500.00
11,500.00
$900.00
Credit
5,200.00
4,333.33
61500
61000
Shipping Supplies Exp.
Debit
Credit
$900.00
60100
Debit
Gasoline Expense
800
800
Credit
Inventory-26″ Bikes
Debit Credit
8,000
4,900
7,500
$143.33
4,400
14,000
14,000.00
15000
Bike Racks
60700
Debit
23200
Wages Payable
Debit
Debit
Interest Expense
$143.33
39003
Common Stock
이
60200
4,000
5,000
1,000
6,000
Credite
1,300
1,300
236.25
236.25
Credit
70,000.00
70,000.00
61100
Credit
60800
Legal Expense
$940
Depreciation Expense
Debit
Credit
$940
Inventory 20″ Bikes
Debit
Credit
6,000
4,000
2,800
Ulitliyy
15100
Computer Equipment
Debit
5,200.00
Credit
750.00
5,950.00
Debit
23400
23250
Payable
39005
1,600
800
Debit
2,800
2,000
Interest Payable
Debit
Credit
60300
0
Credit
Retained Earnings
Debit
Credit
$1,500.00
445
445
100.00
100.00
Credit
0
61200
Rent Expense
Debit Credit
$1,500.00
Office Supplies
Debit
70
70
13050
Shipping Supplies
Debit
Credit
$200.00
$200.00
Debit
17000
Accumulated Depr.-
Debit
Credit
143.75
23300
Sales
3,828
Debit
650
650
39007
Dividends
Debit
Credit
200
200
143.75
60400
$1,300.00
Credit
$1,300.00
924
957
627
1,320
0
Credit
61300
Wage Expense
Debit
Credit
CreditAccount # Dollar Amount Cr Account # Dollar Amount
NO JE
Transaction # Dr
1-Jan
2-Jan Dr
3-Jan Dr
4-Jan Dr
5-Jan Dr
6-Jan Dr
7-Jan Dr
8-Jan Dr
9-Jan Dr
10-Jan Dr
11-Jan Dr
12-Jan Dr
13-Jan Dr
14-Jan Dr No JE
15-Jan Dr
Dr
Dr
Dr
16-Jan Dr
17-Jan Dr
18-Jan Dr
Dr
Dr
Dr
19-Jan Dr
20-Jan Dr No JE
21-Jan Dr
22-Jan Dr
23-Jan Dr
24-Jan Dr
Dr
Dr
Dr
25-Jan Dr
26-Jan Dr
27-Jan Dr
Dr
28-Jan Dr
Dr
29-Jan Dr
Dr
Dr
Dr
30-Jan Dr
31-Jan Dr
Dr
Dr
10000
14000
14050
15100
10000
13050
15000
15100
13000
12000
12050
60800
10000
50000
60500
12000
10000
50000
60400
60100
20000
20000
10000
50000
20000
61400
60700
27050
12000
12050
10000
50000
39007
23300
$70,000.00 Cr
$9,000.00 Cr
$4,000.00 Cr
$5,200.00 Cr
$10,000.00 Cr
1,100.00 Cr
$14,000.00 Cr
$750 Cr
$450 Cr
$8,000.00 Cr
$6,000.00 Cr
$940 Cr
Cr
$12,124.00 Cr
Cr
$5,600.00 Cr
Cr
$250.00 Cr
$4,900.00 Cr
$12,557.00 Cr
Cr
$5,800.00 Cr
Cr
$200.00 Cr
Cr
$800.00 Cr
$800.00 Cr
$6,000.00 Cr
$8,227.00 Cr
Cr
$3,800.00 Cr
Cr
$12,900.00 Cr
$445.00 Cr
$43.33 Cr
$866.67 Cr
$7,500.00 Cr
$4,000.00 Cr
$17,320.00 Cr
Cr
$8,000.00 Cr
Cr
$650.00 Cr
$3,828.00 Cr
Cr
Cr
39003
10000
10000
27050
27000
10000
10000
10000
10000
20000
20000
10000
23300
40000
12000
12050
10000
20000
23300
40000
12000
12050
10000
20000
10000
10000
23300
40000
12000
12050
10000
23400
10000
20000
23300
40000
12000
12500
10000
10000
$70,000.00
9,000.00
$4,000.00
$5,200.00
$10,000.00
$1,100.00
$14,000.00
$750
$450
$8,000.00
$6,000.00
$940
$924.00
$11,200.00
$4,000.00
$1,600.00
$250.00
$4,900.00
$957.00
$11,600.00
$5,000.00
$800.00
$200.00
$800.00
$800.00
$6,000.00
$627.00
$7,600.00
$1,000.00
$2,800.00
$12,900.00
$445.00
$910.00
$11,500
$1,320.00
$16,000.00
$6,000.00
$2,000.00
$650.00
$3,828.00
*Do not enter the information highli
Some transactions will have more th
so enter the smallest account first. C
transaction # in BB. Use with or withBETA
PS
Part Five Instructions
CCOUNTING
a. Adjusted Trial Balance
b. Income Statement
c. Statement of Retained Earnings
d. Balance Sheet
OCIETY
Before preparing the Financial Statements make sure all the assignments have been
corrected in your spreadsheets. Prepare the Financial Statements listed below using
Excel.
Once you finish the Financial Statements follow the instructions below:
Step 1: Take the corrected balances in each account and prepare the Financial Statements listed
above. Once completed print out the Financial Statements.
Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder
for the corresponding week.
Step 3: Once you complete entering all the information into Blackboard, upload the Financial
Statements into Blackboard.Wells Fargo Bank
Ending Cash Balance on Bank Statement
Deposits in Transit
Outstanding Checks
Adjustments or Errors +/-
Reconciled Balance
Balance
Add or subtract rows as needed
76,363
112,908.00
$35,040.00
0
$154,231.00
If any journal entries need to be written add them here.
Bank Service Fee
$70.00
Cash
Gas Expenses
Cash
$235
$70.00
$235
“Evy’s Electric Bike Shop
Ending Cash Balance in T-Account
Adjustments or Errors +/-
Reconciled Balance
Balance
74,450.00
$305.00
$74,145.00
Purchase answer to see full
attachment
Tags:
financial statement
computer equipment
Electric Bike Shop
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.
Reviews, comments, and love from our customers and community: