Q4 Financial Activities during Jan 2020 (Only these transactions during the month) AR Payments deposited in 01/2020 and cleared in the bank in 01/2020 AP Payments made in 01/2020 and cashed in the bank in 01/2020 Outstanding / Uncashed AP Checks as of 01/31/2020 AP Invoices received on 02/15/2020 for Jan 2020 services AR Invoices issued on 02/01/2020 for Jan 2020 services Depreciation Amount 15,000.00 25,000.00 3,000.00 9,000.00 25,000.00 300.00 Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work 1/31/2020 12/31/2019

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter6: Cash And Receivables
Section: Chapter Questions
Problem 6P
icon
Related questions
Question
Q4
Financial Activities during Jan 2020 (Only these transactions during the month)
AR Payments deposited in 01/2020 and cleared in the bank in 01/2020
AP Payments made in 01/2020 and cashed in the bank in 01/2020
Outstanding / Uncashed AP Checks as of 01/31/2020
AP Invoices received on 02/15/2020 for Jan 2020 services
AR Invoices issued on 02/01/2020 for Jan 2020 services
Depreciation
Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work
12/31/2019 1/31/2020
220,000.00
30,000.00 15,000.00
12,000.00
3,000.00
5,000.00
(2,000.00)
268,000.00 23,000.00
Cash
Accounts Receivable
Unbilled AR
Prepaid Expense
Fixed Assets - Gross
Accum. Depreciation
Total Assets
Accounts Payable
Credit Card Payable
Accrued Liabilities
Deferred Revenue
Total Liabilities
Equity
Retained Earnings
Total Equity
Amount
15,000.00
25,000.00
3,000.00
9,000.00
25,000.00
300.00
Difference
3,000.00
5,000.00
45,000.00 17,000.00
22,000.00
22,000.00
10,000.00
150,000.00 150,000.00
227,000.00 189,000.00
50,000.00 50,000.00
(9,000.00)
6,700.00
41,000.00 56,700.00
(222,700.00)
Transcribed Image Text:Q4 Financial Activities during Jan 2020 (Only these transactions during the month) AR Payments deposited in 01/2020 and cleared in the bank in 01/2020 AP Payments made in 01/2020 and cashed in the bank in 01/2020 Outstanding / Uncashed AP Checks as of 01/31/2020 AP Invoices received on 02/15/2020 for Jan 2020 services AR Invoices issued on 02/01/2020 for Jan 2020 services Depreciation Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work 12/31/2019 1/31/2020 220,000.00 30,000.00 15,000.00 12,000.00 3,000.00 5,000.00 (2,000.00) 268,000.00 23,000.00 Cash Accounts Receivable Unbilled AR Prepaid Expense Fixed Assets - Gross Accum. Depreciation Total Assets Accounts Payable Credit Card Payable Accrued Liabilities Deferred Revenue Total Liabilities Equity Retained Earnings Total Equity Amount 15,000.00 25,000.00 3,000.00 9,000.00 25,000.00 300.00 Difference 3,000.00 5,000.00 45,000.00 17,000.00 22,000.00 22,000.00 10,000.00 150,000.00 150,000.00 227,000.00 189,000.00 50,000.00 50,000.00 (9,000.00) 6,700.00 41,000.00 56,700.00 (222,700.00)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Will you please provide the formulas (explanation) to understand the results or numbers that were added in the solution?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Bank reconciliation statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning