Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started