Question: Bank Statement DATE: 1/25/2015 Balance Last Statement Balance This Statement $ 7,675.45 No. Amount No. Amount $ 4,569.15 Reconciled Checks & Other Debits Deposits &
Bank Statement DATE: 1/25/2015 Balance Last Statement Balance This Statement $ 7,675.45 No. Amount No. Amount $ 4,569.15 Reconciled Checks & Other Debits Deposits & Other Credits Date Balance 210 316.30 1/3/09 7,359.15 211 275.00 1/4/09 7,084.15 214 350.00 1/6/09 6,734.15 212 650.00 1/6/09 6,084.15 213 575.00 1/6/09 5,509.15 1,150.00 1/6/09 6,659.15 216 750.00 1/9/09 5,909.15 215 600.00 1/9/09 5,309.15 975.00 1/12/09 6,284.15 217 60.00 1/14/09 6,224.15 SC 15.00 6,209.15 219 400.00 1/16/09 5,809.15 850.00 1/16/09 6,659.15 220 75.00 1/18/2009 6,584.15 223 1,275.00 1/21/09 5,309.15 218 140.00 1/21/09 5,169.15 221 175.00 1/22/09 4,994.15 227 350.00 1/24/09 4,644.15 222 75.00 1/24/09 4,569.15 PLEASE EXAMINE YOUR STATEMENT AT ONCE. IF NO ERROR IS REPORTED IN 10 DAYS THE ACCOUNT WILL BE CONSIDERED CORRECT AND VOUCHERS GENUINE. ALL ITEMS ARE CREDITED SUBJECT TO FINAL PAYMENT C = CERTIFIED CHECK T = DEBIT OR CREDIT SC = SERVICE CHARGE OR = OVERDRAFT R = RETURNED CHECK
| Check Register | The blue shaded boxes need to be filled in. | ||||||
| LEGEND | CURRENT BALANCE | ||||||
| DC = Debit Card | AP = Automatic Payment | ||||||
| ATM = Automated Teller Withdrawal | BP = Online Bill Pay | ||||||
| AD = Automatic Deposit | TR = Online or Phone Transfer | ||||||
| Reconciled | CHECK/CODE | DATE | TRANSACTION | DESCRIPTION | WITHDRAWAL | DEPOSIT | BALANCE |
| Starting balance | $7,675.45 | $7,675.45 | |||||
| 210 | 1/1/2015 | Power House | Utility bill | $316.30 | |||
| 211 | 1/1/2015 | Office Pro | Office Supplies | $275.00 | |||
| 212 | 1/4/2015 | Rent-a-Space | Rent | $650.00 | |||
| 213 | 1/4/2015 | Computer Warehouse | Purchase software | $575.00 | |||
| 1/5/2015 | Deposit | $1,150.00 | |||||
| 214 | 1/5/2015 | Southland Auto Mart | Pay on account | $350.00 | |||
| 215 | 1/7/2015 | Office | Maintenance Fee | $600.00 | |||
| 216 | 1/8/2015 | Cash | $750.00 | ||||
| 1/11/2015 | Deposit | $975.00 | |||||
| 217 | 1/12/2015 | Transportation Costs | $60.00 | ||||
| 218 | 1/14/2015 | Insurance premium | $140.00 | ||||
| 219 | 1/15/2015 | Warehouse Associates | Pay on account | $400.00 | |||
| 1/15/2015 | Deposit | $850.00 | |||||
| 220 | 1/16/2015 | Supplies | $75.00 | ||||
| 221 | 1/17/2015 | Communication Link | Phone bill | $175.00 | |||
| 222 | 1/18/2015 | Up-to-the-Minute News | Advertising | $75.00 | |||
| 223 | 1/19/2015 | Furniture World | Office Furniture | $1,275.00 | |||
| 224 | 1/20/2015 | V-Tech Products | Computer purchase | $650.00 | |||
| 225 | 1/22/2015 | Coral Distributors | Pay on account | $850.00 | |||
| 226 | 1/23/2015 | IRS | Quarterly Employee FITW | $2,400.00 | |||
| 227 | 1/23/2015 | State Dept of Revenue | Quarterly Employee SITW | $350.00 | |||
| 1/25/2015 | Deposit | $2,800.00 | |||||
| 228 | 1/25/2015 | Cash | $500.00 | ||||
| 229 | 1/26/2015 | Office Repairs | $200.00 | ||||
| Totals |
| Balance your Account | |||||
| Checks Outstanding | |||||
| Check Number | Amount | Enter your checkbook balance | |||
| Add any credits made to your account through interest, etc. as shown on this statement (Be sure to enter these in your chedckbook) | |||||
| Subtotal | |||||
| Subtract any debits made to your account through debit card and bank charges, account fees, etc. as shown on this statement. (Be sure to enter these in your checkbook) | |||||
| Total | |||||
| Note: Cells G17 and G28 (the one's in blue, need to be equal. | |||||
| Adjusted checkbook balance | |||||
| Bank Balance shown on the bank statement | |||||
| Add deposits shown in your checkbook, but not shown on this statement, because they were made and received after the date on this statement | |||||
| Subtotal | |||||
| Subtract checks outstanding | |||||
| Adjusted bank balance |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help