Question: Please carefully view the Reconciliation Detail and Summary reports below. List and describe all the errors you find: Reconciliation Detail Wells Checking, Period Ending 03/14/2016

Please carefully view the Reconciliation Detail and Summary reports below. List and describe all the errors you find:

Reconciliation Detail
Wells Checking, Period Ending 03/14/2016
Type Date Num Name Clr Amount Balance
Beginning Balance 128,888.73
Cleared Transactions
Checks and Payments - 33 items
Type Date Num Name Clr Amount Balance
Check 02/16/2016 1212 Cos Enterprise x -15,000 -15.000.00
Check 02/16/2016 1213 Matt Rosen x -1,000 -16,000.00
Check 02/16/2016 Stripe1(BGS) x -16.21 -16.016.21
Check 02/19/2016 x -100,000 -116.016.21
Check 02/19/2016 1214 Grease Lightning x -1,900.00 -117,916.21
Check 02/19/2016 x -101.12 -118.017.33
Check 02/22/2016 1216 Matthew Malby x -1,700.00 -119.717.33
Check 02/22/2016 1217 Daniel Sweeney x -426.00 -120.143.33
Check 02/22/2016 Internet Business x -167.00

-120.310.33

Check 02/22/2016 Zapier x -50.00 -120.360.33
Check 02/23/2016 x -4,365..39 -124,725.72
Check 02/23/2016 x -1,850.52 -126.576.24
Check 02/23/2016 x -1,110.31 -127.686.55
Check 02/23/2016 x -972.60 -128.659.15
Check 02/23/2016 x -641.02 -129,300.17
Check 02/24/2016 Farmers Insurance x -66.01 -129.366.18
Check 02/25/2016 x -0.11

-129.366.29

Check 02/26/2016 x -9,153.52

-138 519.81

Check 02/26/2016 x -3,501.97

-142.021.78

Transfer 02/26/2016 x -500.00 -142,521.78
Check 02/29/2016 x -15,000 -157,521.78
Check 02/29/2016 x -1,900 -159.421.78
Transfer 02/29/2016 x -968.09 -160.389.87
Transfer 02/29/2016 x -23.50 -160,413.37
Check 03/02/2016 MID7307 x -25.19 -160.438.56
Check 03/03/2016 Google Svcsapps x -25.00 -160,463.56
Check 03/03/2016 Intuit x -13.47

-160.477.03

Check 03/04/2016 x -1,243.61

-161,720.64

Check 03/04/2016 x -69.12 -161.789.76
Check 03/04/2016 Amazon x -6.18

-161.795.94

Check 03/08/2016 Direct Pay x -10.00

-161,805.94

Check 03/14/2016 Banner Life Insurance x -68.25

-161,874.19

Check 03/14/2016 Banner Life Insurance x -27.13 -161.901.32
TOTAL CHECKS AND PAYMENTS -161,901.32

-161,901.32

Deposits and Credits - 16 items
Deposit 02/16/2016 Stripe1 (BGS) x

16.21

16.21

Deposit

02/17/2016

Clickbank. x

76.44

92 65

Deposit

02/17/2016

Stripe1 (BGS) x

1.110.31

1.202.96

Deposit

02/17/2016

Clickbank. x

3.770.46

4.973.42

Deposit

02/18/2016

Stripe1 (BGS) x

641.02

5.614 44

Deposit

02/19/2016

Stripe1 (BGS) x

4.365.39

9.979.83

Deposit

02/22/2016

Stripe1 (BGS) x

972.60

10.952.43

Deposit

02/24/2016

Clickbank. x

2.117.64

13.070.07

Transfer

02/24/2016

x

13.928.34

26.998,41

Deposit

02/25/2016

x

0.03

26,998.44

Deposit

02/25/2016

x 0.08

26.998.52

Deposit

02/29/2016

x

100.000.00

126.998.52

Deposit

03/01/2016

x

1,243.61

128.242.13

Deposit

03/02/2016

Clickbank. x

35.37

128.277.50

Deposit

03/08/2016

MID7307 x 0.97

128.278.47

Deposit

03/09/2016

Clickbank. x 32.82

128,311.29

TOTAL DEPOSITS AND CREDITS

128.311.29

128.311.29

TOTAL CLEARED TRANSACTIONS

-33.590.03

-33.590.03

CLEARED BALANCE

-33.590.03

95.298.70

Please carefully view the Reconciliation Detail and Summary reports below. List and

Reconciliation Detail
Wells Checking, Period Ending 03/14/2016
Type Date Num Name Clr Amount Balance
Uncleared Transactions
Checks and Payments - 1 item
Check 02/29/2016 1218

-16.735.51

-16.735.51
TOTAL CHECKS AND PAYMENTS -16.735.51 -16.735.51
TOTAL UNCLEARED TRANSACTIONS -16.735.51 -16.735.51
REGISTER BALANCE AS OF 03/14/2016

-50.325.54

78.563.19

NEW TRANSACTIONS
CHECKS AND PAYMENTS - 5 ITEMS
Check

03/18/2016

1017

Slessa Design Conc...

x

-193.71

-193.71
Check

03/21/2016

Zapier

x

-50.00

-243.71

Check

03/22/2016

Farmers insurance

x -66.01

-309.72

Check

03/23/2016

Intemet Business

x -167.00

-476.72

Check

03/25/2016

x -32.00

-508.72

TOTAL CHECKS AND PAYMENTS -508.72 -508.72
DEPOSITS AND CREDITS - 4 ITEMS
Deposit

03/16/2016

Clickbank.

x

64.43

64.43
Deposit

03/22/2016

MID7307

x

97.00

161.43

Deposit

03/23/2016

MID7307

x

0.01

161.44

Deposit

03/23/2016

Clickbank

x

50.87

212.31

TOTAL DEPOSITS AND CREDITS

212.31

212.31

TOTAL NEW TRANSACTIONS

-296 41

-296 41
ENDING BALANCE

-50,621.95

78.266.78

describe all the errors you find: Reconciliation Detail Wells Checking, Period Ending

Reconciliation Summary
Wells Checking, Period Ending 03/14/2016
Mar 14, 2016
Beginning Balance

128,888.73

Cleared Transactions

Checks and Payments - 33 items

-161,901.32

Deposits and Credits - 16 items

128.311.29

Total Cleared Transactions

-33,590.03

Cleared Balance

95.298.70

Uncleared Transactions

Checks and Payments - 1 item

-16.735.51

Total Uncleared Transactions

-16.735.51

Register Balance as of 03/14/2016

78.563.19

New Transactions

Checks and Payments - 5 items

-508.72

Deposits and credits - 4 items

212.31

Total New Transactions

-296.41

Ending Balance

78,266.78

03/14/2016 Type Date Num Name Clr Amount Balance Beginning Balance 128,888.73 Cleared

Reconciliation Detail Reconciliation Detail Reconciliation Summary Nells Checking, Period Ending 03/14/2016 Reconciliation Detail Reconciliation Detail Reconciliation Summary Nells Checking, Period Ending 03/14/2016

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!