On 30 September 2022, Piston Limited had a balance in its 'Cash in Bank' general ledger account of $13,034.30 debit. The bank statement from ANZ bank on that date showed a credit balance of $19,495.00. A comparison of the September 2022 bank statement with the 'Cash in Bank' general ledger account and the bank reconciliation for August 2022 revealed the following facts (ignore GST): Ref: (1) Electronic Funds Transfers (EFTs), totalling $1,770.10, from the August 2022 bank reconciliation has still not been presented to the bank. (2) Cash sales of $2,945 on 20 September 2022 were deposited in the bank. The general journal entry was incorrectly recorded as $2,954. Piston Limited's bank statement showed the correct amount of $2,945 was recorded. (3) From the review of the September 2022 cash journals, it was established that outstanding EFTs totalled $3,567.10, and outstanding deposits were $1,190.40. (4) On 24 September 2022 Piston Limited made a payment (EFT no. 3485) for $540.80 to J. Smith for an accounts payable payment. The EFT no. 3485, which showed up on the bank statement on 25 September 2022, was incorrectly recorded in the 'Cash in Bank' general ledger account as $450.80. (5) A $3,000 note receivable was collected by the bank for Piston Limited on 15 September 2022, plus $80 interest. The bank charged a bank fee of $20 for this transaction. These items were not accounted for in the 'Cash in Bank' general ledger account. (6) The bank statement showed that the bank returned a dishonoured accounts receivable made by a customer (K. Davis) for $647.10 on 28 September.

Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter5: Cash Control Systems
Section: Chapter Questions
Problem 2AP
icon
Related questions
Question

 Prepare a bank reconciliation for Piston Limited as at 30 September 2022.

On 30 September 2022, Piston Limited had a balance in its 'Cash in Bank' general ledger account of
$13,034.30 debit. The bank statement from ANZ bank on that date showed a credit balance of
$19,495.00. A comparison of the September 2022 bank statement with the 'Cash in Bank' general
ledger account and the bank reconciliation for August 2022 revealed the following facts (ignore
GST):
Ref:
(1)
(2)
(3)
Electronic Funds Transfers (EFTs), totalling $1,770.10, from the August 2022 bank
reconciliation has still not been presented to the bank.
Cash sales of $2,945 on 20 September 2022 were deposited in the bank. The general journal
entry was incorrectly recorded as $2,954. Piston Limited's bank statement showed the correct
amount of $2,945 was recorded.
From the review of the September 2022 cash journals, it was established that outstanding
EFTs totalled $3,567.10, and outstanding deposits were $1,190.40.
(4)
On 24 September 2022 Piston Limited made a payment (EFT no. 3485) for $540.80 to J. Smith
for an accounts payable payment. The EFT no. 3485, which showed up on the bank statement
on 25 September 2022, was incorrectly recorded in the 'Cash in Bank' general ledger account
as $450.80.
(5)
A $3,000 note receivable was collected by the bank for Piston Limited on 15 September 2022,
plus $80 interest. The bank charged a bank fee of $20 for this transaction. These items were
not accounted for in the 'Cash in Bank' general ledger account.
(6) The bank statement showed that the bank returned a dishonoured accounts receivable made
by a customer (K. Davis) for $647.10 on 28 September.
Transcribed Image Text:On 30 September 2022, Piston Limited had a balance in its 'Cash in Bank' general ledger account of $13,034.30 debit. The bank statement from ANZ bank on that date showed a credit balance of $19,495.00. A comparison of the September 2022 bank statement with the 'Cash in Bank' general ledger account and the bank reconciliation for August 2022 revealed the following facts (ignore GST): Ref: (1) (2) (3) Electronic Funds Transfers (EFTs), totalling $1,770.10, from the August 2022 bank reconciliation has still not been presented to the bank. Cash sales of $2,945 on 20 September 2022 were deposited in the bank. The general journal entry was incorrectly recorded as $2,954. Piston Limited's bank statement showed the correct amount of $2,945 was recorded. From the review of the September 2022 cash journals, it was established that outstanding EFTs totalled $3,567.10, and outstanding deposits were $1,190.40. (4) On 24 September 2022 Piston Limited made a payment (EFT no. 3485) for $540.80 to J. Smith for an accounts payable payment. The EFT no. 3485, which showed up on the bank statement on 25 September 2022, was incorrectly recorded in the 'Cash in Bank' general ledger account as $450.80. (5) A $3,000 note receivable was collected by the bank for Piston Limited on 15 September 2022, plus $80 interest. The bank charged a bank fee of $20 for this transaction. These items were not accounted for in the 'Cash in Bank' general ledger account. (6) The bank statement showed that the bank returned a dishonoured accounts receivable made by a customer (K. Davis) for $647.10 on 28 September.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
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
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage