NOTE: The bank deposit slip is setup for you to manually type the necessary information to successfully complete the assignment.
A. Cash receipts total $646.68; $2.68 was in coins.
B. Check payments were # 2387 for $67.00 from Sue Patrick and # 460 for $50.00 from Ronald Rodriguez.
C. Credit card payments were $25.00 and $67.00. Pam Adkins paid the $25.00 payment, and Brad Wilson paid the $67.00 payment. BANK DEPOSIT DETAIL PAYMENT | BANK NUMBER | BY CHECK OR PMO | BY COIN OR CURRENCY | CREDIT CARD | Check #2387 | 67 | 00 | | | | | Check #460 | 50 | 00 | | | | | P. Adkins | | | | | 25 | 00 | B. Wilson | | | | | 67 | 00 | | | | 2 | 68 | | | | | | 644 | 00 | | | | | | | | | | TOTALS | 117 | 00 | 646 | 68 | 92 | 00 | CURRENCY | 644.00 | COIN | 2.68 | CHECKS | 117.00 | CREDIT CARDS | 92.00 | TOTAL RECEIPTS | 2230.00 | LESS CREDIT CARD $ | 92.00 | TOTAL DEPOSITS | 2138.00 | DEPOSIT DATE: 01/04/2013 FIRM:____________________ |
BANK NUMBER | BY CHECK OR PMO | BY COIN OR CURRENCY | CREDIT CARD | Check #2387 | 67 | 00 | | | | | Check #460 | 50 | 00 | | | | | P. Adkins | | | | | 25 | 00 | B. Wilson | | | | | 67 | 00 | | | | 2 | 68 | | | | | | 644 | 00 | | | | | | | | | | TOTALS | 117 | 00 | 646 | 68 | 92 | 00 | CURRENCY | 644.00 | COIN | 2.68 | CHECKS | 117.00 | CREDIT CARDS | 92.00 | TOTAL RECEIPTS | 2230.00 | LESS CREDIT CARD $ | 92.00 | TOTAL DEPOSITS | 2138.00 | DEPOSIT DATE: 01/04/2013 FIRM:____________________ |
|
D. An insurance payment for Alejandro Sanchez arrived in the amount of $1374.32. The payment was from Aetna and was check # 309.
2. Reconcile the bank statement using the facts below. Use the information in questions A-D. Record your answers to the worksheet provided.
NOTE: The worksheet is setup for you to manually type the necessary information to successfully complete the assignment.
A. The checkbook balance is $4619.89.
B. The statement balance is $ 6792.79 (this amount includes the deposit of $2230.00 – do not add the amount in again).
C. Three checks are outstanding: Check # 5648 for $356.00, check # 5649 for $46.90; and check # 5650 for $ 1770.00.
D. Does the checkbook reconcile with the statement?
Ans.__Yes it does reconcile___ _
THIS WORKSHEET IS PROVIDED TO HELP YOU BALANCE YOUR ACCOUNT
THIS WORKSHEET IS PROVIDED TO HELP YOU BALANCE YOUR ACCOUNT
ENTER The NEW BALANCE shown on this statement _4562.79__________$ | | ADDAny deposits listed in your register or transfer Into your account which are not shown on this Statement. CALCULATE THE SUBTOTAL_6792.79_______ $ | SUBTRACTThe total outstanding checks and withdrawals from the chart at left______$ 2172.90 | CALCULATE THE ENDING BALANCEThis amount should be the same as the current balance shown in your check register ______$ 4619.89 |
ENTER The NEW BALANCE shown on this statement _4562.79__________$ | | ADDAny deposits listed in your register or transfer Into your account which are not shown on this Statement. CALCULATE THE SUBTOTAL_6792.79_______ $ | SUBTRACTThe total outstanding checks and withdrawals from the chart at left______$ 2172.90 | CALCULATE THE ENDING BALANCEThis amount should be the same as the current balance shown in your check register ______$ 4619.89 |
ITEMS OUTSTANDING | NUMBER | AMOUNT | 3648 | 356 | 00 | 5649 | 46 | 90 | 5650 | 1770 | 00 | | | | | | | | | | | | | | | | | | | | | | TOTAL | $2172 | 90 |
ITEMS OUTSTANDING | NUMBER | AMOUNT | 3648 | 356 | 00 | 5649 | 46 | 90 | 5650 | 1770 | 00 | | | | | | | | | | | | | | | | | | | | | | TOTAL | $2172 | 90 |
$2230.00 | $ | $ | +$______ |
$2230.00 | $ | $ | +$______ |
You May Also Find These Documents Helpful
-
(e) Paid cash on account to the company that supplied the office supplies in transaction (b), $1,800.…
- 209 Words
- 5 Pages
Satisfactory Essays -
2) Tinker, Inc., finances its seasonal working capital need with short-term bank loans, Management plans to borrow $65,000 for a year. The bank has offered the company a 3.5% discounted loan with a 1.5% origination fee. What are the interest payment and the origination fee required by the loan?…
- 421 Words
- 3 Pages
Satisfactory Essays -
F. Siegel discovered that the check had been paid and informed the bank that the check was…
- 339 Words
- 2 Pages
Satisfactory Essays -
b) Kleinberg Corporation was sued by a customer for product liability. The customer sought damages of $1,500,000. At the its December 31, 2012, year-end, the company obtained an opinion from their lawyers that the customer had a 75% likelihood of winning the suit with the damages likely to be assessed in the range of $800,000 to $1,200,000. Legal costs were estimated to amount to a further $150,000. In late January, before the company’s financial statements had been finalized, the company settled the claim with the customer for $800,000. The lawyers estimated their fees to be reduced to $80,000 because the matter was settled without going to court.…
- 907 Words
- 4 Pages
Good Essays -
1a. The maximum amount of money that the initial deposit can be expanded to is $50,000. With the use of the money multiplier, we were able to use the formula by taking the reciprocal of the reserved ratio and multiplying it by the initial deposit.…
- 386 Words
- 2 Pages
Satisfactory Essays -
2. Sally Corporation provided $1,500 of services to Artech Corporation; no billing had been made by December 31. ----- D…
- 757 Words
- 4 Pages
Powerful Essays -
The issue is to determine how the $300,000 fee that John received is to be…
- 2389 Words
- 9 Pages
Better Essays -
7. May 13: Herman received cash payments totaling $185,000 for legal services—$30,000 was for services previously billed to customers on February 12 and the remainder was for services provided in May not yet recorded.…
- 725 Words
- 5 Pages
Good Essays -
CHAPTER 7 Transaction No. 11 |FEDERAL DEPOSIT INFORMATION WORKSHEET | | | | |Employer | | |Identification Number 31-0450660 |Name Glo-Brite Paint Company | |Month Tax Year Ends 12 |Amount of Deposit 6443.08 | |Type of Tax (Form) 941 |Tax Period 4th Qtr | |Address 2215 Salvador St. |Phone Number (215) 555-9559 | |City, State, Zip Philadelphia, PA 19175-0682 | Transaction No. 25 |FEDERAL DEPOSIT INFORMATION WORKSHEET | | | | |Employer | | |Identification Number 31-0450660 |Name Glo-Brite Paint Company | |Month Tax Year Ends 12 |Amount of Deposit $6637.08 | |Type of Tax (Form) 941 |Tax Period 4th Qtr | |Address 2215 Salvador St.…
- 3316 Words
- 14 Pages
Satisfactory Essays -
d. Purchased equipment for the new addition for $30,000, paying $3,000 in cash and signing a note due in six months for the balance.…
- 1327 Words
- 6 Pages
Good Essays -
| A payment of $67 for insurance was posted as a debit of $42 to Prepaid Insurance and a credit of $42 to Cash.…
- 1816 Words
- 8 Pages
Satisfactory Essays -
3. What amounts should be recognized in the financial statements for the $25 million payment on June 15, 2012?…
- 363 Words
- 2 Pages
Satisfactory Essays -
NOTE: The checks are setup for you to manually type the necessary information to successfully complete the assignment.…
- 252 Words
- 2 Pages
Satisfactory Essays -
b. Purchased $4,000 of new instruments inventory; paid $1,000 in cash and owed the rest on…
- 316 Words
- 2 Pages
Satisfactory Essays -
In its place a pledge card was typed in to reflect the $15000 but was never signed by the defendant. It was a copy of this pledge card that was forwarded in connection of the assignment to supplier. In an effort to gain credit from the supplier, the plaintiff executed a personal guaranty. The obligation was secured through subscribed pledges. These pledges were than assigned to American Acceptance Corporation of Philadelphia, by the supplier.…
- 559 Words
- 3 Pages
Good Essays