Question: Hello, from the following, what am i doing wrong please. 13. From the following information for A. Liu prepare for May 31: Cash Receipts and

Hello, from the following, what am i doing wrong please.

13.From the following information for A. Liuprepare for May 31:

  1. Cash Receipts and Cash Payments Books for May
  2. Bank Ledger Account for May
  3. Bank reconciliation statement as at 31 May

The April Bank reconciliation statement contained the following items:

An outstanding deposit $733.10, and

Unpresented cheque #324856 for $934.02

For May:

Extract Cash Receipts Book of A.Liu

Extract Cash Payments Book ofA.Liu

02/05

1,446.52

01/05

324875

1,526.16

07/05

3,486.72

04/05

324876

905.70

11/05

1,538.90

08/05

324877

2,404.38

11/05

436.84

12/05

324878

1,702.86

12/05

2,360.20

15/05

324879

1,296.98

21/05

1,039.30

20/05

324880

561.40

30/05

846.76

28/05

324881

1,958.30

The Best Bank Ltd

Bank Statementfor A.Liu

Date

Particulars

Debit

Credit

Balance

Broughtforward

2,981.98 Dr
01/05

Cheque#324875

1,526.16

4,508.14Dr

Cash/chequesdeposit

$733.10

3,775.04Dr
02/05

Cash/chequesdeposit

1,446.52

2,328.52Dr
05/05

Cheque#324856

934.02

3,262.54Dr
07/05

Cash/chequesdeposit

3,486.72

224.18Cr
11/05

Cash/chequesdeposit

1,538.90

1,763.08Cr
12/05

Cheque#324877

2,404.38

641.30 Dr

Cash/chequesdeposit

436.84

204.46 Dr
15/05

Cheque book fee

50.00

254.46 Dr
17/05

Cheque #324879

1,296.98

1,551.44Dr
18/05

Cash/chequesdeposit

2,360.20

808.76Cr
21/05

Cheque#324878

1,702.86

894.10 Dr
24/05

L. Mami chequedishonour

551.56

1,445.66Dr

Dishonourfee

15.00

1,460.66Dr
25/05

Cheque #324876

905.70

2,366.36Dr
26/05

Cash/chequesdeposit

1,039.30

1,327.06Dr
31/05

Cheque#324880

561.40

1,888.46Dr

Cash Receipts Book

Cash Payments Book

Date

Details

Amount $

Date

Details

Amount $
01/05 Cash/Cheques deposit 733.10 01/05 Cheque #324875 1,526.16
02/05 Cash/Cheques deposit 1,446.52 05/05 Cheque#324856 934.02
07/05 Cash/Cheques deposit 3,486.72 12/05 Cheque#324877 2,404.38
11/05 Cash/Cheques deposit 1,538.90 15/05 Cheque Book Fee 50.00
12/05 Cash/Cheques deposit 436.84 17/05 Cheque #324879 1,296.98
18/05 Cash/Cheques deposit 2,360.20 21/05 Cheque#324878 1,702.86
24/05 L. Mami cheque dis - 551.56 24/05 Dishonourfee 15.00
26/05 Cash/Cheques deposit 1,039.30 25/05 Cheque #324876 905.70
31/05 Cheque#324880 561.40
Total 10,490.02 Total 9,396.50

Bank100

Date

Details

Folio

Debit

Credit

Balance

01/05

 Balance b/d

N/A

3,182.90 CR
31/05 Receipts N/A
31/05 Payments N/A

BankReconciliationStatementasatMay31

Debit balance as per Bank Statement

$1,888.46
Add: Unpresented Cheques

#324881

1,958.30

Sub-total

$3,846.76
Less: Outstanding Deposits

846.76
Credit Balance per the Bank Ledger Account

$3,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Im really struggling with those question. A quickly remind that this not a test or exam, those are revision questions. My VC | The IIE's V X Bb Lecturer Slides - A x 5 Module Options X Module...

Q:

Im really struggling with those question. A quickly remind that this not a test or exam, those are revision questions. My VC | The IIE's V X Bb Lecturer Slides - A x 5 Module Options X Module...

Q:

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Q:

Hello, from the following, what am i doing wrong please. 13. From the following information for A. Liu prepare for May 31: Cash Receipts and Cash Payments Books for May Bank Ledger Account fo...

Q:

QS 6-14 The Organic Food Co.'s Cash account shows a $5.500 debit balance and its bank statement shows 55,160 on deposit at the close of business on August 31. Prepare a bank reconciliation using the...

Q:

Essay Question 182 Management by exception focuses only on those variances management considers important. List three factors that managers use in deciding whether or not to investigate a variance...

Q:

What am I doing wrong here? Please do not answer this question if you are tutor gleineobidos as they have provided 4x incorrect answers to this question already. Activity 6: Bank Reconciliations The...

Q:

Activity 6: Bank Reconciliations The April Bank reconciliation statement contained the following items: An outstanding deposit $733.10, and Unpresented cheque #324856 for $934.02 For May: Extract:...

Q:

Required information CC5-1 Accounting for Cash Receipts, Purchases, and Cash Payments and Reconciling Items (LO 5-3, LO 5-4, LO 5-5) [The following information applies to the questions displayed...

Q:

I have attached a few questions in the word doc. If you need any additional information please let me know thank you! Buttermilk Bakery has provided the following cost data for the last year when...

Q:

When setting up a new Team member (member of your firm) in QuickBooks Online Accountant, you can assign which of the following user permissions to the new Team member. Accounts receivable Accounts...

Q:

Accusearch operated Abika.com. It sold personal telephone records. Customers could buy "details of incoming or outgoing calls from any phone number, prepaid calling card or Internet Phone." This...

Q:

ing Enabled: Exam ~~ 2 G Every month, managers across the Bateman Manufacturing get profit and loss statements for all divisions and butiness units. They look at one another's performance and know...

Q:

The following transactions pertain to 2018, the first year of operations of Fuzhou Company. All inventory was started and completed during the accounting period. All transactions were cash...

Q:

The time to complete a construction project is normally distributed with a mean of 60 weeks and a standard deviation of 4 weeks. (a) What is the probability the project will be finished in 62 weeks...

Q:

On January 1, 2014, Stream Company acquired 30 percent of the outstanding voting shares of Q-Video, Inc., for $770,000. Q-Video manufactures specialty cables for computer monitors. On that date,...

Q:

Susan Williams has been the production manager of Medical Suppliers, Inc., for the past 17 years. Medical Suppliers, Inc., is a producer of bandages and arm slings. During the past 5 years, the...

Q:

Steve Goodman, production foreman for the Florida Gold Fruit Company, estimates that the average sale of oranges is 4,700 and the standard deviation is 500 oranges. Sales follow a normal...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

Boles and Johnson (A-7) examined the beliefs held by adolescents regarding smoking and weight. Respondents characterized their weight into three categories: underweight, overweight, or appropriate....

Q:

The side effects of nonsteroidal antiinflammatory drugs (NSAIDs) include problems involving peptic ulceration, renal function, and liver disease. In 1996, the American College of Rheumatology issued...

Q:

Refer to the study by Carter et al. [A-9], who investigated the effect of age at onset of bipolar disorder on the course of the illness. One of the variables studied was subjects family history....