Question
The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2017, is shown below. SANDHILL CO. Bank Reconciliation October 31, 2017 Cash
The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2017, is shown below.
SANDHILL CO. Bank Reconciliation October 31, 2017 | ||||
---|---|---|---|---|
Cash balance per bank | $ 12,557.90 | |||
Add: Deposits in transit | 1,530.20 | |||
14,088.10 | ||||
Less: Outstanding checks | ||||
Check Number | Check Amount | |||
2451 | $ 1,260.40 | |||
2470 | 684.20 | |||
2471 | 844.50 | |||
2472 | 428.50 | |||
2474 | 1,050.00 | 4,267.60 | ||
Adjusted cash balance per bank | $ 9,820.50 |
The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following checks and deposits.
Bank Statement | ||||||||
---|---|---|---|---|---|---|---|---|
Checks | Deposits | |||||||
Date | Number | Amount | Date | Amount | ||||
11-1 | 2470 | $ 684.20 | 11-1 | $ 1,530.20 | ||||
11-2 | 2471 | 844.50 | 11-4 | 1,211.60 | ||||
11-5 | 2474 | 1,050.00 | 11-8 | 990.10 | ||||
11-4 | 2475 | 1,640.70 | 11-13 | 2,575.00 | ||||
11-8 | 2476 | 2,830.00 | 11-18 | 1,472.70 | ||||
11-10 | 2477 | 600.00 | 11-21 | 2,945.00 | ||||
11-15 | 2479 | 1,730.00 | 11-25 | 2,567.30 | ||||
11-18 | 2480 | 1,330.00 | 11-28 | 1,650.00 | ||||
11-27 | 2481 | 695.40 | 11-30 | 1,186.00 | ||||
11-30 | 2483 | 575.50 | Total | 16,127.90 | ||||
11-29 | 2486 | 940.00 | ||||||
Total | $ 12,920.30 |
The cash records per books for November showed the following.
Cash Payments Journal | Cash Receipts Journal | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Date | Number | Amount | Date | Number | Amount | Date | Amount | |||||||
11-1 | 2475 | $ 1,640.70 | 11-20 | 2483 | $ 575.50 | 11-3 | $ 1,211.60 | |||||||
11-2 | 2476 | 2,830.00 | 11-22 | 2484 | 827.80 | 11-7 | 990.10 | |||||||
11-2 | 2477 | 600.00 | 11-23 | 2485 | 974.80 | 11-12 | 2,575.00 | |||||||
11-4 | 2478 | 538.20 | 11-24 | 2486 | 940.00 | 11-17 | 1,472.70 | |||||||
11-8 | 2479 | 1,703.00 | 11-29 | 2487 | 398.00 | 11-20 | 2,954.00 | |||||||
11-10 | 2480 | 1,330.00 | 11-30 | 2488 | 800.00 | 11-24 | 2,567.30 | |||||||
11-15 | 2481 | 695.40 | Total | $ 14,465.40 | 11-27 | 1,650.00 | ||||||||
11-18 | 2482 | 612.00 | 11-29 | 1,186.00 | ||||||||||
11-30 | 1,494.00 | |||||||||||||
Total | $ 16,100.70 |
The bank statement contained two bank memoranda:
1. | A credit of $ 2,387.00 for the collection for Sandhill Co. of an electronic funds transfer. | |
2. | A debit for the printing of additional company checks $ 86.70. |
At November 30, the cash balance per books was $ 11,455.80 and the cash balance per bank statement was $ 18,065.80. The bank did not make any errors, but Sandhill Co. made two errors.
Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2017. (List items that increase balance as per bank and books first.)
SANDHILL CO. Bank Reconciliation choose the accounting period choose the accounting period |
---|
select an opening name for section one select an opening name for section one |
---|
$ enter a dollar amount | |||||
select between addition and deduction select between addition and deduction |
: | select a reconciling item select a reconciling item |
---|
enter a dollar amount | |||||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction select between addition and deduction |
: | select a reconciling item select a reconciling item |
---|
select a Check Number select a Check Number |
---|
$ enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | ||||
select a Check Number select a Check Number |
enter a dollar amount | |||||
enter a total amount for this reconciling item | |||||
select a closing name for section one select a closing name for section one |
$ enter a total amount for the first section | |||||
select an opening name for section two select an opening name for section two |
$ enter a dollar amount | |||||
select between addition and deduction select between addition and deduction |
: | select a reconciling item select a reconciling item |
---|
enter a dollar amount | |||||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction select between addition and deduction |
: | |||||
---|---|---|---|---|---|
select a reconciling item select a reconciling item |
$ enter a dollar amount | ||||
select a reconciling item select a reconciling item |
enter a dollar amount | ||||
select a reconciling item select a reconciling item |
enter a dollar amount | |||||
enter a subtotal of the three previous amounts | |||||
select a closing name for section two select a closing name for section two |
$ enter a total amount for the second section |
eTextbook and Media
List of Accounts
Prepare the adjusting entries based on the reconciliation. (Note: The correction of any errors pertaining to recording checks should be made to Accounts Payable. The correction of any errors relating to recording cash receipts should be made to Accounts Receivable.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.)
Date | Account Titles and Explanation | Debit | Credit |
---|---|---|---|
Nov 30 | enter an account title to record electronic funds transfer received by bank on November 30 | enter a debit amount | enter a credit amount |
enter an account title to record electronic funds transfer received by bank on November 30 | enter a debit amount | enter a credit amount | |
(To record electronic funds transfer received by bank) | |||
Nov 30 | enter an account title to record charge for printing company checks on November 30 | enter a debit amount | enter a credit amount |
enter an account title to record charge for printing company checks on november 30 | enter a debit amount | enter a credit amount | |
(To record charge for printing company checks) | |||
Nov 30 | enter an account title for the adjusting entry based on the reconciliation to correct error in recording check on November 30 | enter a debit amount | enter a credit amount |
enter an account title for the adjusting entry based on the reconciliation to correct error in recording check on November 30 | enter a debit amount | enter a credit amount | |
(To correct error in recording check) | |||
Nov 30 | enter an account title for the adjusting entry based on the reconciliation to correct error in deposit on November 30 | enter a debit amount | enter a credit amount |
enter an account title for the adjusting entry based on the reconciliation to correct error in deposit on November 30 | enter a debit amount | enter a credit amount | |
(To correct error in deposit) |
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