The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2022, is shown below. SANDHILL CO. Bank Reconciliation October 31, 2022 $12,667.90 Cash balance per bank Add: Deposits in transit 1,530.20 14,198.10 Less: Outstanding checks Check Number Check Amount 2451 $1,260.40 2470 684.20 2471 844.50 2472 427.80 2474 1,050.00 4,266.90 Adjusted cash balance per bank $9,931.20 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statements 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-19 EFT 2,442.00 11-15 2479 1.750.00 11-21 2,945.00 11-18 2480 1.330.00 11-25 2,567.30 11-27 2481 695.40 11-28 1,650.00 11-28 SC 93.80 11-30 1,186.00 11-30 2483 575.50 Total 18,569.90 11-29 2486 940.00 Total $13.034.10 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 820.70 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,705.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,460.30 11-27 1,650.00 11-18 2482 612.00 11-29 1,186.00 11-30 1,604.00 Total 16,210.70 The bank statement contained two bank memoranda: A credit of $2,442.00 for the collection from a customer for Sandhill Co. of an electronic funds transfer. A debit for the printing of additional company checks $93.80. 1. 2.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2022. (List items that increase
balance as per bank and books first. Round answers to 2 decimal places, eg. 5,275. 50.)
SANDHILL CO.
Bank Reconciliation
%24
%24
%24
>
>
>
>
>
>
>
>
>
> >
> >
>
Transcribed Image Text:Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2022. (List items that increase balance as per bank and books first. Round answers to 2 decimal places, eg. 5,275. 50.) SANDHILL CO. Bank Reconciliation %24 %24 %24 > > > > > > > > > > > > > >
The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2022, is shown below.
SANDHILL CO.
Bank Reconciliation
October 31, 2022
Cash balance per bank
$12,667.90
Add: Deposits in transit
1,530.20
14,198.10
Less: Outstanding checks
Check Amount
$ 1,260.40
Check Number
2451
2470
684.20
2471
844.50
2472
427.80
2474
1,050.00
4,266.90
Adjusted cash balance per bank
$9,931.20
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-19 EFT
2,442.00
11-15
2479
1,750.00
11-21
2,945.00
11-18
2480
1,330.00
11-25
2,567.30
11-27
2481
695.40
11-28
1,650.00
SC
93.80
11-30
1,186.00
18,569.90
11-28
11-30
2483
575.50
Total
11-29
2486
940.00
Total
$13.034.10
The cash records per books for November showed the following
Cash Payments Journal
Cash Receipts Journal
Amount
$1.640.70
Date
Number
Date
Number
Date
Amount
Amount
$ 575.50
11-1
2475
11-20
2483
11-3
$1,211.60
11-2
2476
2,830.00
11-22
2484
820.70
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,705.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,460.30
11-27
1,650.00
11-18
2482
612.00
11-29
1,186.00
11-30
1,604.00
Total
16,210.70
The bank statement contained two bank memoranda:
1.
A credit of $2,442.00 for the collection from a customer for Sandhill Co. of an electronic funds transfer.
2.
A debit for the printing of additional company checks $93.80.
At November 30, the cash balance per books was $11,806.80 and the cash balance per bank statement was $18,328.90. The bank
did not make any errors, but Sandhill Co. made two errors.
Transcribed Image Text:The bank portion of the bank reconciliation for Sandhill Co. at October 31, 2022, is shown below. SANDHILL CO. Bank Reconciliation October 31, 2022 Cash balance per bank $12,667.90 Add: Deposits in transit 1,530.20 14,198.10 Less: Outstanding checks Check Amount $ 1,260.40 Check Number 2451 2470 684.20 2471 844.50 2472 427.80 2474 1,050.00 4,266.90 Adjusted cash balance per bank $9,931.20 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-19 EFT 2,442.00 11-15 2479 1,750.00 11-21 2,945.00 11-18 2480 1,330.00 11-25 2,567.30 11-27 2481 695.40 11-28 1,650.00 SC 93.80 11-30 1,186.00 18,569.90 11-28 11-30 2483 575.50 Total 11-29 2486 940.00 Total $13.034.10 The cash records per books for November showed the following Cash Payments Journal Cash Receipts Journal Amount $1.640.70 Date Number Date Number Date Amount Amount $ 575.50 11-1 2475 11-20 2483 11-3 $1,211.60 11-2 2476 2,830.00 11-22 2484 820.70 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,705.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,460.30 11-27 1,650.00 11-18 2482 612.00 11-29 1,186.00 11-30 1,604.00 Total 16,210.70 The bank statement contained two bank memoranda: 1. A credit of $2,442.00 for the collection from a customer for Sandhill Co. of an electronic funds transfer. 2. A debit for the printing of additional company checks $93.80. At November 30, the cash balance per books was $11,806.80 and the cash balance per bank statement was $18,328.90. The bank did not make any errors, but Sandhill Co. made two errors.
Expert Solution
trending now

Trending now

This is a popular 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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education