Question

In: Accounting

The following information for the month of December 20x6, with respect to cash activities, was gathered...

The following information for the month of December 20x6, with respect to cash activities, was gathered by the company’s bookkeeper.

Cash balance per books, December 1

$3,700

Cash received during December

$77,000

Cash payments made during December

$77,548

Cheques outstanding, December 31

$5,300

Bank service charges for December

$52

Deposits in transit at December 31

$1,700

A $1,200 cheque received from a customer on December 13 in payment of an account receivable was incorrectly recorded as

$1,020

a) What is the adjusted cash balance per books at December 31?

b) What is the cash balance per the bank statement at December 31?

c) The last item in the list above will cause what kind of adjustment to the cash account balance?

Solutions

Expert Solution

(a)

Cash balance as per book on dec 1 $3700
Add:
Cash recieved during december $77000
Error in recording of cheques recieved on dec 13 $180 $77180
Less:
Cash payments made during december $77548
Bank service charges $52 ($77600)
Adjusted cash balance per books at 31 dec $3280
  • Cash recieved was added as it is a reciept from customer
  • Error in recording of cheques is added as an additional $180($1200-$1020) as a result of error is to be made to correct it
  • Cash payments are deduced as these are payments made from the company
  • Bank services charges are deducted as these are expenses to be recorded in cash book

(b)

Adjusted cash balance as per books and adjusted balance as per bank stament will be the same

So adjusted balance as per bank statement at 31 dec=$3280

Cash balance as per bank statement + All additions - All deduction = Adjusted balance as per bank statement at 31 dec

So,

  • Cash balance as per bank statement= Adjusted balance as per bank statement-All additions+all deduction

Additions to the cash balance bank statement as per question are

Deposit in transit $1700

Deposit in transit is added as this will soon be deposited in bank

Deductions to the cash balance of bank statement as per question are

Cheques outstanding $5300

Cheques outstanding is deducted as these will soon be presented at the bank and payment will be made

So,

  • Cash balance as per bank statement at 31 dec = Adjusted balance as per bank statement-All additions+all deduction = $3280-$1700+$5300= $6880

(c)

As the cheque recieved from customer of $1200 was incorrectly recorded as $1020 the difference of $180($1200-$1020) should be added to the cash book.

So, the entry will be

DEBIT Cash book $180

CREDIT      Creditor's account $180

The cash book is debited as the amount of $1200 was wrongly recorded as $1020

The creditor's account will be credited as an additional $180 due to error should be recorded

So the adjustment will result in increasing the cash account of $180   


Related Solutions

The following information was gathered from the records of Cooper Molecular Models Inc. for the month...
The following information was gathered from the records of Cooper Molecular Models Inc. for the month ended December 31, 2019. Balance December 1, 2019 Balance December 31, 2019 Raw Materials Inventory $4,800 $3,960 Work In Process Inventory 1,980 1,860 Finished Goods Inventory 9,600 7,590 Direct Labour $13,925 Accounts Receivable 2,700 Insurance on the factory 460 Depreciation on factory machines 1,600 Sales 53,400 Plant Manager’s salary 5,800 Raw material purchases 9,640 Factory property taxes 960 Cash 3,200 Required: Prepare a schedule...
Gazam  corporations adjusted trial balance at December 31, 20x6 included the following Cash                          &n
Gazam  corporations adjusted trial balance at December 31, 20x6 included the following Cash                                                                                        26,000 Account receivable                                                                 50,000 Allowance for doubtful account                                                                     5,000 Merchandise inventory                                                          41,000 Land                                                                                        50,000 Equipment                                                                              96,000 Accumulated depreciation                                                                             16,000 Account payable 115000 Income taxes payable                                                                                     5,000 Unearned rent                                                                                                15,000 Common stock ($10 par 10,000 shares)                                                       150,000 Retained earnings                                                                                           60,000 Sales                                                                                                                90,000 Interest revenue                                                                                             4,000 Cost of goods sold                                                                  90,000 Selling expense                                                                       30,000 Administrative expense                                                          40,000 Income tax expense                                                                12,000 Loss on sale...
The following information was gathered for Zeba Company for the year ended December 31, 2020: Budgeted...
The following information was gathered for Zeba Company for the year ended December 31, 2020: Budgeted Actual Direct labor-hours 50,000 DL-hr 60,000 DL-hr Factory overhead   $550,000 $600,000 Assume that the cost-allocation base is direct labor-hours. The journal entry to write off over-/under-allocated overhead at year end is: Group of answer choices DR Manufacturing overhead allocated                   $660,000                               CR Cost of Goods Sold $ 60,000                               CR Manufacturing overhead control (actual)                      $600,000 DR Manufacturing overhead allocated                   $550,000 DR Cost of Goods...
Use the following information to prepare a cash budget for December. The cash balance on December...
Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...
The following information has been gathered for Highgate Security for the month ended September 30, 2021:...
The following information has been gathered for Highgate Security for the month ended September 30, 2021: 1) The bank statement indicates a balance of $6,417. 2) The general ledger cash account indicates a balance of $5,422 on September 30, 2021. 3) There was an EFT deposit of $1,700 on the bank statement for the monthly rent from a tenant. 4) The bookkeeper had erroneously recorded a $100 cheque as $1,000. The cheque was to settle the account payable of Janex...
The following information summarizes the activities in the Mixing Department for the month of March. Beginning...
The following information summarizes the activities in the Mixing Department for the month of March. Beginning inventory 2,000 units, 80% complete Started and completed 49,000 units Ending inventory 6,000 units, 25% complete Material is added at the beginning of the process and conversion costs are incurred evenly throughout the process. Q: Calculate the equivalent units completed with respect to conversion costs during the month of March A. 50,000 B. 52,000 C. 52,500 D. 57,000
Overton Company has gathered the following information.
Overton Company has gathered the following information.Units in beginning work in process21,100Units started into production184,900Units in ending work in process24,700Percent complete in ending work in process:    Conversion costs60%    Materials100%Costs incurred:    Direct materials$103,000    Direct labor$263,576    Overhead$187,500Compute equivalent units of production for materials and for conversion costs.MaterialsConversion CostsThe equivalent units of production  Determine the unit costs of production. (Round unit costs to 2 decimal places, e.g. 2.25.)MaterialsConversion CostsUnit costs$$  Show the assignment of costs to units transferred out and in process.Transferred out$Ending work in process$
Given the following information, prepare a statement of cash flows. Cashflow from operating activities: Investment Activities...
Given the following information, prepare a statement of cash flows. Cashflow from operating activities: Investment Activities DATA Increase in accounts receivable 30 Increase in inventories 30 Operating Income 95 Interest Expense 30 Increase in accounts payable 25 Dividends 15 Increase in common stock 20 Increase in net fixed assets 23 Depreciation Expense 12 Income taxes 17 Beginning cash 20 Assume all amounts are in 000's
The following information is available for the OLIVIA Company for the month of December 2019 1....
The following information is available for the OLIVIA Company for the month of December 2019 1. On December 31, 2019 the balance in the company's Cash account has a balance of $16,297 . 2. The company's bank statement shows a balance December 31, 2019 of $19,522 . 3. Outstanding checks at December 31, 2019 total $ 2,877 . 4. A deposit placed in the bank's night depository on December 31, 2019 totaling $ 1,676 did not appear on the bank...
Consider the following information: Cash and cash equivalents at 31 December 2010 = $1.50 million Cash...
Consider the following information: Cash and cash equivalents at 31 December 2010 = $1.50 million Cash and cash equivalents at 31 December 2011 = $1.85 million Interest expense = $0.48 million Net borrowings = $0.25 million Cash dividends = $1.25 million Given a tax rate of 40%, the firm's FCFF at the end of 2011 is closest to: Select one: a. $1,830,000 b. $1,638,000 c. $388,000 Question 13 Question text Assuming a tax rate of 40%, a $100 increase in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT