Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me figure out where I went wrong. TYIA. General Ledger Bank Reconcilation C5-1 (Algo) Recording Transactions and Adjustments, Reconciling Items, and Preparing Financial

Please help me figure out where I went wrong. TYIA.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

General Ledger image text in transcribed

image text in transcribedimage text in transcribed

Bank Reconcilation image text in transcribed

C5-1 (Algo) Recording Transactions and Adjustments, Reconciling Items, and Preparing Financial Statements LO 2-2, 2-4, 2-5, 3-3, 3-5, 4-2, 4-3, 4-4, 5-4, 5-5 (General Ledger) On January 1, Pulse Recording Studio (PRS) had the following account balances. The following transactions occurred during January. a. Received $2,420 cash on 1/1 from customers on account for recording services completed in December. b. Wrote checks on 1/2 totaling $4,370 for amounts owed on account at the end December. c. Purchased and received supplies on account on 1/3, at a total cost of $200. d. Completed $3,900 of recording sessions on 1/4 that customers had paid for in advance in December. e. Received $4,750 cash on 1/5 from customers for recording sessions started and completed in January. f. Wrote a check on 1/6 for $4,000 for an amount owed on account. g. Converted $1,010 of cash equivalents into cash on 1/7 h. On 1/15, completed EFTs for $1,400 for employees' salaries and wages for the first half of January. i. Received $2,940 cash on 1/31 from customers for recording sessions to start in February. 1. Prepare journal entries for the January transactions. Review the 'General Ledger' and the unadjusted 'Trial Balance' Tabs to see the effect of the transactions on the account balances. 2. Prepare journal entries for items (j)-( (n) from the bank reconciliation. j. The bank deducted $470 for an NSF check from a customer deposited on January 5. k. The check written January 6 has not cleared the bank, but the January 2 payment has cleared. I. The cash received and deposited on January 31 was not processed by the bank until February 1 . m. The bank added $4 cash to the account for interest earned in January. n. The bank deducted $4 for service charges. 3. Prepare adjusting journal entries on 1/31 in 'General Journal' Tab. (these are shown as items 15 to 21). o. Depreciation for the month is $240. p. Salaries and wages totaling $1,500 have not yet been recorded for January 16 to 31 . q. Prepaid Rent will be fully used up by March 31. r. Supplies on hand at January 31 were $200. s. Received $200 invoice for January electricity charged on account to be paid in February but is not yet recorded. t. Interest on the promissory note of $28 for January has not yet been recorded or paid. u. Income tax of $1,700 on January income has not yet been recorded or paid. 4. Review the adjusted 'Trial Balance' as of January 31. 5. Prepare an income statement for the period ended January 31 in the 'Income Statement' Tab. 6. Prepare a bank reconciliation in the 'Bank Reconciliation' Tab. 7. Prepare a classified balance sheet as of January 31 in the 'Balance Sheet' Tab. 8. Using the information from the requirements above, complete the 'Analysis' tab. Answer is not complete. Prepare the journal entries to record transactions (a) through (n). Then prepare the necessary adjusting entries (o) through (u) to correctly report net income for the period. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Fonaral I arger Account \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Interest Payable } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 20 & January 31 & & 28 & 28 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Salaries and Wages Payable } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 16 & January 31 & & 1,500 & 1,500 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Income Tax Payable } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 21 & January 31 & & 1,700 & 1,700 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Deferred Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 3,900 \\ \hline 4 & January 04 & 3,900 & & 0 \\ \hline 9 & January 31 & & 2,940 & 2,940 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Notes Payable (long-term) } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 12,400 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Common Stock } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 10,400 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Retained Earnings } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 4,810 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|r|r|} \hline \multicolumn{5}{|c|}{ Service Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 4 & January 04 & & 3,900 & 3,900 \\ \hline 5 & January 05 & & 4,750 & 8,650 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Depreciation Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 15 & January 31 & 240 & & 240 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Interest Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 20 & January 31 & 28 & & 28 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Rent Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline 17 & January 31 & 1,140 & & 1,140 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Salaries and Wages Expense } \\ \hline \multicolumn{1}{|c|}{ No. } & Date & Debit & Credit & Balance \\ \hline & January 01 & & & 0 \\ \hline $ & January 15 & 1,400 & & 1,400 \\ \hline 16 & January 31 & 1,500 & & 2,900 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Utilities Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 0 \\ \hline 19 & January 31 & 200 & & 200 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Income Tax Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 0 \\ \hline 21 & January 31 & 1,700 & & 1,700 \\ \hline \end{tabular} Answer is not complete. Use the January 31 balance in Cash from General Ledger tab and the information (j) - (n) to prepare a bank reconciliation. PRS's bank reported a balance of $5,580

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jefferson Jones, Maryanne Mowen, Don Hansen, Donald Jones, Ralph Tassone

2nd Canadian Edition

0176707123, 978-0176707125

More Books

Students also viewed these Accounting questions