Prepare bank reconciliation statement for hannah handbags

Assignment Help Accounting Basics
Reference no: EM132064676

Accounting In Organisations Assignment Question -

QUESTION - Hannah's Handbags Pty Ltd has received its bank statement for the month of January 2016 from Commonwealth Bank of Australia. The accountant named Darren, has gathered the necessary information to prepare the bank reconciliation statement for the month of January 2016. The following information is gathered by Darren:

1) Bank reconciliation statement on 31 December 2015:

Balance as per bank statement

 

$839.20

Dr.

Add: Cheques not debited by bank:

 

 

 

No. 193

$60.00

 

 

253

248.20

 

 

257

417.40

 

 

261

719.20

 

 

Bank error - deposit to incorrect account

300.00

1,744.80

 

 

 

2,584.00

 

Less: Outstanding deposit

 

2,100.00

 

Balance as per Cash at Bank account

 

$484.00

Cr

2) The progressive totals of the Cash Receipts Journal and the Cash Payments Journal for the month of January 2016 are, respectively, $21,546 and $24,108 before taking into account any of the items appearing on the bank statement.

3) The following items appear on the January bank statement but not in the cash journals for the same month:

a) Cheques written during December 2015 that had not been presented for payment were: cheque no.193, for $60; cheque no.253, for $248.20; and cheque no.257, for $417.40.

b) The bank statement included a deposit of cash sales on 1 January 2016 of $2,100 and a debit of $300 to correct the error from December 2015.

c) The bank had collected a rent of $420 from a tenant who leases space in Hannah's Handbags Pty Ltd's warehouse.

d) On 30 January a $294 cheque that was received from a customer and deposited by Hannah's Handbags Pty Ltd, was returned and marked "Insufficient Funds". This was shown in the January bank statement.

e) On 14 January 2016, NRMA had charged the company's bank account for insurance premiums, for the amount of $350.

f) The bank statement included a debit of $30 for a Cheque book and $48 for interest on overdraft.

g) A deposit of $400 by Hannah to her personal bank account held at Commonwealth Bank of Australia, appeared incorrectly in the Hannah's Handbags Pty Ltd's bank statement.

4) The following items appear in the cash journals but not on the bank statement:

a) Cheques written during January that had not been presented for payment were: cheque no.288, for $632; cheque no.289, for $1,000; and cheque no.293, for $342.

b) Cash Sales of $1,720 on 31 January were deposited in the bank which was not included in the bank statement.

5) Additional information:

a) On 31 January 2016 the bank statement showed a debit balance of $2,342.80.

b) The accountant discovered that cheque no.290 for $315 in payment for electricity and gas bill, had been incorrectly recorded in the cash payments journal as $375.

c) Cheque no. 285 for $228 appears twice on the bank statement.

d) Cheque no. 296 was entered correctly as $360 in the cash payment journal but appeared in the bank statement as $560.

Required:

a) Prepare bank reconciliation statement for Hannah's Handbags Pty Ltd as of 31 January 2016.

b) Prepare the necessary adjusting entries as at 31 January 2016.

Reference no: EM132064676

Questions Cloud

Determine whether the company should sell sailboats hulls : Determine whether the company should sell sailboats hulls or process them further into complete sailboats. Assume sales volumes will not be affected
Refinery hydrocarbon stream : Hydrogen sulphide has to be removed from a light refinery hydrocarbon stream before the gas is subjected to further processing.
What is the total payout to investors : What is the total payout to investors (debtholders plus shareholders) of each company?
When the greenshoe option would be exercised : Why the greenshoe option exists When the greenshoe option would be exercised
Prepare bank reconciliation statement for hannah handbags : ACCY112: Accounting In Organisations Assignment Question. University of Wollongong Australia. Prepare bank reconciliation statement for Hannah Handbags
Calculate a t-test for the given scenario : Calculate a t-test for the following scenario. An engineer is designing a stationary parts bin at a work table and considers using an established functional.
Undertake the process of analysing one organisation : This assignment requires your group to undertake the process of analysing one organisation and its operating environments from a marketing perspective.
Do you think america could continue policing the world : Do you think the United States has the right to tell countries, like North Korea and Syria, that they cannot develop nuclear weapons? Why or why not?
What is the percent cost to the firm of the loan : What is the percent cost to the firm of the loan in Mexican pesos expressed as a per annum percentage?

Reviews

Write a Review

Accounting Basics Questions & Answers

  According to gasb statement no 44 all of the following is a

according to gasb statement no. 44 all of the following is a recommendation category for the cafrs statistical section

  Benson and orton are partners who share income in the ratio

benson and orton are partners who share income in the ratio of 13 and have capital balances of 70000 and 30000

  Impro company operates in a state where corporate taxes and

impro company operates in a state where corporate taxes and workers compensation insurance raes have recently doubled.

  Dearman company which has only one product has provided

dearman company which has only one product has provided the following data concerning its most recent month of

  Breakeven point in sales dollars for redex

The following monthly data are available for RedEx, which produces only one product that it sells for $84 each. Its unit variable costs are $28 and its total fixed expenses are $64,960. Sales during April totaled 1,600 units. (a) How much is the b..

  Ronald metzgar placed his fifteen-month-old son matthew

ronald metzgar placed his fifteen-month-old son matthew awake and healthy in his playpen. ronald left the room for five

  How many units will be produced in march

Meadows Company produces hand tools. March 1 inventory is projected to be 1590 units. How many units will be produced in March?

  Calculate the estimated inventory at the end of november

Royal Gorge Company uses the gross profit method to estimate ending inventory and Calculate the estimated inventory at the end of November

  What are the equivalent unit conversion costs

Barnes and Miller manufacturing is trying to determine the equivalent units for conversion costs with 3000 units of ending work in process at 80% completion

  Reid shaw company produces one product a putter called

reid shaw company produces one product a putter called go-putter. shaw uses a standard cost system and determines that

  Prepare appropriate journal entries to remove the equipment

On March 31, 2017, the equipment was sold for $40,000. Prepare the appropriate journal entries to remove the equipment from the books

  Prepare the closing entries at december

Service revenue $50,000; salaries and wages expense $27,000 and supplies expense $7,000. Prepare the closing entries at December 31

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd