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 | ||||

| 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 | ||||

| 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 |

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
Get step-by-step solutions from verified subject matter experts
