Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The bank portion of last months bank reconciliation for Sandhill Ltd. at February 28 was as follows: SANDHILL LTD. Bank Reconciliation February 28 Cash balance

The bank portion of last months bank reconciliation for Sandhill Ltd. at February 28 was as follows:

SANDHILL LTD. Bank Reconciliation February 28

Cash balance per bank $17,951
Add: Deposits in transit 3,119
21,070
Less: Outstanding cheques
#3451 $1,957
#3470 2,145
Reconciled cash balance $16,968

The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at February 28. The March bank statement showed the following:

SANDHILL LTD. Bank Statement March 31
Date Description Amounts Deducted from Account (Debits) Amounts Added to Account (Credits) Balance
Feb. 28 Opening balance 17,951
Mar. 1 Cheque, No. 3451 1,957 15,994
1 Deposit 3,119 19,113
2 Cheque, No. 3470 2,145 16,968
4 Deposit 1,973 18,941
9 Cheque, No. 3471 1,671 17,270
10 Returned chequeNSF, J. Mustafa 873 16,397
10 NSF fee 35 16,362
15 EFT, loan payment 1,202 15,160
19 Cheque, No. 3472 1,823 13,337
26 Deposit 3,260 16,597
31 EFT, collection on account from
M. Boudreault 613 17,210
31 Bank service charges and credit card fees 89 17,121

Sandhills cash receipts and payments for the month of March showed the following:

Cash Receipts Cash Payments
Date Amount Date Number Amount
Mar. 4 $1,973 Mar. 7 3471 $1,671
26 3,260 15 3472 1,283
31 4,013 29 3473 4,919
$9,246 $7,873
Additional information:
1. The EFT loan payment should have been recorded by the company on March 15, but this entry was missed. The payment included $84 of interest and a $1,118 payment on the loan principal.
2. The bank made an error processing cheque #3472.
3. The EFT collection from M. Boudreault was not previously recorded.
4. Bank service charges and debit and credit card processing fees totalling $89 were not previously recorded.

What is the formula to calculate the following, from the information above :

Cash balance per books at March 31: Expected Output: 18341

Deposit in transit at March 31 : Expected Output: 4013

Amount of the outstanding cheques at March 31: Expected Output: 4,919.00

Finding the Cheque with an error? What calculation must be done to find the wrong cheque?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting Concepts And Practice

Authors: Arnold J. Pahler

9th Edition

0324233531, 978-0324233537

More Books

Students also viewed these Accounting questions

Question

How flying airoplane?

Answered: 1 week ago