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

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter4: Internal Control And Cash
Section: Chapter Questions
Problem 27BE
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
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
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
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning