2) prepare the T-accounts. To complete the journal entries, do not forget that you need to make the adjusting entries per the descriptions of transactions in the project document.
3) The last tab in the Excel template is for you to prepare the unadjusted trial balance, as well as the adjusted trial balance. Note that you need to enter all the adjustments in the worksheet.
4) The last step of the project is to make the closing entries. You shall close the Revenue account(s) as well as the Expenses accounts to the income summary and the then close to the Retailed Earnings. Note that in the Excel template "trial balance" tab, the income summary account is not needed.
Date: | Transactions | Adjustments | EOM Closing Entries | ||||||||||||||
Account | Account Name | Beginning Balance | Ending Balance | Adjusted Balance | Ending Balance | ||||||||||||
DB | CR | DB | CR | DB | CR | DB | CR | DB | CR | DB | CR | DR | CR | ||||
101 | Cash | 0 | 0 | 122,863 | 27,464 | 95,399 | 0 | 95,399 | 0 | 95,399 | 0 | ||||||
111 | Accounts Receivable | 0 | 0 | 3,729 | 0 | 3,729 | 0 | 3,729 | 0 | 3,729 | 0 | ||||||
112 | Allowance for doubtful accounts | 0 | 0 | 0 | 0 | 0 | 0 | 186 | 0 | 186 | 0 | 186 | |||||
121 | Boat Inventory | 0 | 0 | 32,775 | 12,050 | 20,725 | 0 | 20,725 | 0 | 20,725 | 0 | ||||||
122 | Boat Accessory Inventory | 0 | 0 | 3,080 | 1,897 | 1,183 | 0 | 43 | 1,140 | 0 | 1,140 | 0 | |||||
131 | Supplies | 0 | 0 | 760 | 0 | 760 | 0 | 498 | 262 | 0 | 262 | 0 | |||||
132 | Prepaid Insurance | 0 | 0 | 2,196 | 0 | 2,196 | 0 | 183 | 2,013 | 0 | 2,013 | 0 | |||||
133 | Prepaid Rent | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
141 | Store, Office, & Boat Equipment | 0 | 0 | 26,880 | 0 | 26,880 | 0 | 26,880 | 0 | 26,880 | 0 | ||||||
142 | Accumulated depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 280 | 0 | 280 | 0 | 280 | |||||
201 | Accounts Payable | 0 | 0 | 12,360 | 34,417 | 0 | 22,057 | 0 | 22,057 | 0 | 22,057 | ||||||
202 | Accrued Salaries Payable | 0 | 0 | 0 | 0 | 0 | 0 | 4,600 | 0 | 4,600 | 0 | 4,600 | |||||
203 | Accrued Interest Payable | 0 | 0 | 0 | 0 | 0 | 0 | 133 | 0 | 133 | 0 | 133 | |||||
204 | Unearned Revenue | 0 | 0 | 0 | 580 | 0 | 580 | 0 | 580 | 0 | 580 | ||||||
205 | Dividends Payable | 0 | 0 | 0 | 1,500 | 0 | 1,500 | 0 | 1,500 | 0 | 1,500 | ||||||
206 | Current Maturities of long-term debt | 0 | 0 | 0 | 0 | 0 | 0 | 5,000 | 0 | 5,000 | 0 | 5,000 | |||||
207 | Other Accrued expenses payable | 0 | 0 | 0 | 0 | 0 | 0 | 357 | 0 | 357 | 0 | 357 | |||||
210 | Notes Payables | 0 | 0 | 0 | 20,000 | 0 | 20,000 | 5,000 | 0 | 15,000 | 0 | 15,000 | |||||
301 | Common Stock - (no par) | 0 | 0 | 900 | 100,000 | 0 | 99,100 | 0 | 99,100 | 0 | 99,100 | ||||||
311 | Retained Earnings | 0 | 0 | 1,500 | 0 | 1,500 | 0 | 1,500 | 0 | 0 | 2,855 | 0 | 1,355 | ||||
401 | Boat Sales | 0 | 0 | 0 | 18,999 | 0 | 18,999 | 0 | 18,999 | 18,999 | 0 | 0 | 0 | ||||
402 | Accessory Sales | 0 | 0 | 0 | 2,709 | 0 | 2,709 | 0 | 2,709 | 2,709 | 0 | 0 | 0 | ||||
403 | Boat Repair Revenue | 0 | 0 | 0 | 4,304 | 0 | 4,304 | 0 | 4,304 | 4,304 | 0 | 0 | 0 | ||||
501 | Cost of Goods Sold - Boat Sales | 0 | 0 | 12,050 | 0 | 12,050 | 0 | 12,050 | 0 | 0 | 12,050 | 0 | 0 | ||||
502 | Cost of Goods Sold - Accessory Sales | 0 | 0 | 1,767 | 0 | 1,767 | 0 | 43 | 1,810 | 0 | 0 | 1,810 | 0 | 0 | |||
601 | Salaries Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 4,600 | 4,600 | 0 | 0 | 4,600 | 0 | 0 | |||
602 | Supplies Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 498 | 498 | 0 | 0 | 498 | 0 | 0 | |||
603 | Insurance Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 183 | 0 | 0 | |||
604 | Rent Expense | 0 | 0 | 2,400 | 0 | 2,400 | 0 | 2,400 | 0 | 0 | 2,400 | 0 | 0 | ||||
605 | Depreciation expense | 0 | 0 | 0 | 0 | 0 | 0 | 280 | 280 | 0 | 0 | 280 | 0 | 0 | |||
606 | Utilities expense | 0 | 0 | 0 | 0 | 0 | 0 | 357 | 357 | 0 | 0 | 357 | 0 | 0 | |||
607 | Advertising expense | 0 | 0 | 660 | 0 | 660 | 0 | 660 | 0 | 0 | 660 | 0 | 0 | ||||
608 | Interest expense | 0 | 0 | 0 | 0 | 0 | 0 | 133 | 133 | 0 | 0 | 133 | 0 | 0 | |||
609 | Doubtful Accounts expense | 0 | 0 | 0 | 0 | 0 | 0 | 186 | 186 | 0 | 0 | 186 | 0 | 0 | |||
0 | 0 | 223,920 | 223,920 | 169,249 | 169,249 | 11,280 | 11,280 | 174,805 | 174,805 | 26,012 | 26,012 | 150,148 | 150,148 |
2) prepare the T-accounts. To complete the journal entries, do not forget that you need to...
Tucker Boats began business on September 1, 2013, ...Tucker Boats has adopted a September 30 as fiscal year end, just in time to stock new merchandise. On September 1, Joe ...hired a recent graduate, Henry Webster. In the next few days of September, he rented a sales office, boat garage, and lot space. The store is open Monday through Saturday and Joe is there all six days. Henry works 8 hours per day, Monday through Friday. Both Henry and Joe...
Adjustment information as of September 30, 2013 not already given in original transactions: Joe was very conscientious in checking his customers' credit history. However, while at the Nevada State Boat Show, he learned that it is customary within the pleasure boating industry for retail boat sales to suffer bad debt losses equal to 5% of credit sales. Joe decides that it is prudent to use the 5% industry-wide standard until he has more experience with his own business and customers....
Post journal entries to T-accounts for this problem. Oliver Rowe owned a bus and was tired of his current job. He decided to open a business, Oliver, Inc., that provides day tours to tourists through Hollywood and Los Angeles. Below is a Chart of Accounts for Oliver, Inc.: Chart of Accounts Cash Bus Office Equipment Tour Supplies Prepaid Insurance Accounts Receivable Accounts Payable Common Stock Dividends Tour Revenue Parking Expense Salary Expense *Please use only the above account names for your...
Prepare journal entries to record the following merchandising transactions of Horus company, which uses the perpetual inventory system. All the transportation charges are paid in cash. July 1 Purchased merchandise from Osiris Company for $6,500 under credit terms of 2/15, n/30, FOB shipping point, invoice dated July 1. 2 Sold merchandise to Anubis Co. for $950 under credit terms of 2/10, n/60, FOB shipping point, invoice dated July 2. The merchandise had cost $542. Transportation charges is $50. 3 Paid...
record journal entries using the accounts for these transactions Week-1 Basic Journal Entries Mason Yachts, a boat manufacturing company, begins business on 1/1/2017. Mason specializes in selling and repairing yachts. A listing of all of Mason trial balance accounts can be found in "trial balance tab below. For the transactions below, please record the necessary journal entries in the Journal Entries tab and update the balances in the trial balance. I have provided a "T-Account tab for each individual trial...
Prepare April Journal Entries as T accounts and Regular Journal entries. Don’t forget descriptions and date. JTT is a licensed CPA. During the first month of operations of her business, the following events and transactions occurred. a) April 2, Invested $73,600 cash and equipment valued at $32,200 in the business. b) April 2, Hired a secretary-receptionist at a salary of $667 per week, payable monthly. c) April 3, Purchased supplies on account $1,610. (Debit an asset account.) d) April 7,...
2:06 PM 32% ex13.docx Prepare journal entries to record the following transactions involving the shont-term securities of Duke Co, all of which occurred during year 2013. a. On March 22, purchased 1,000 shares of RIP Company stock at $10 per share plus a $0 brokerage fee. These shares are categorized as trading securities b. On September 1, received a $1.00 per share cash dividend on the RIP Company stock parchased in c. On October 8, sold 500 shares of RIP...
12. Prepare the necessary journal entries on the books of Ahmed Car wash Company to record the following transactions, assuming a perpetual inventory system is used. Ahmed purchased the goods from ABC Company. (3 marks) a) Ahmed purchased S55,000 of merchandise from ABC Company on account, terms 3/10, n/30. The goods cost ABC Company $32,500. Ahmed returned $6,000 of damaged merchandise for credit. Ahmed paid for the merchandise purchased within 10 days (b) (c) i) Prepare the necessary journal entries...
Inv 3 ES Re se P Prepare journal entries for the following merchandising transactions of Dollar Store assuming it uses a perpetual inventory system and the gross method. Nov. 1 Dollar Store purchases merchandise for $1,500 on terms of 2/5, n/30, FOB shipping point, in- voice dated November 1. 5 Dollar Store pays cash for the November 1 purchase. 7 Dollar Store discovers and returns $200 of defective merchandise purchased on November 1, and paid for on November 5, for...
2. (18 points) Petersen Book Store entered into the transactions listed below. In the journal provided, prepare Petersen's necessary entries, assuming use of the perpetual inventory system. Sept 2 Purchased $2,800 of merchandise on credit, terms 130. 5 Returned $400 of the items purchased on Sept 6. 6 Paid freight charges of $90 on the items purchased Sept 2. 19 Sold merchandise on credit for $4,500, terms 2/10, 1/30. The merchandise had an inventory cost of $1,900. (Two entries needed)....