June 07, 2006
Quicken
Work through the instructions that are below. You will learn how to use this financial package to maintain a checking account. Print whenever the instructions indicate then put in portfolio. You will print the following for your portfolio:
1. All Checks
2. Each months reconciliation
3. Memo
Record in your daily journal the transaction you ended on each day.
Congratulations! Last spring you were elected treasurer of our local BPA chapter. You are responsible for maintaining the BPA checkbook. You will make deposits, write checks, maintain the check register; and reconcile the bank statement bimonthly.
Go to file, then new. You want a new quicken account, this account is not held, it is at a financial institute (you can pick the name), choose manual, add only a checking account, the account name is SHS BPA Chapter, and the statement date is September 1 of the pervious year. For example, if it is currently 2006, begin dating your September 1 balance as 2005. The ending balance is $385.20. For check transactions in the Num column choose print check, or deposit which ever is appropriate for transaction type.
Complete the following tasks for the dates indicated:
September 1, previous year
The beginning balance for the BPA account is $385.20. Record this in the checkbook register.
Sept. 4 I purchased some items for our first BPA orientation meeting this week. Please issue Mrs. Fox a reimbursement check for $31.03. Be sure to record this in the checkbook register.
Sept. 27 The social committee needs to buy some items for our first club meeting that will be held this week. Issue a check to Wal-Mart for $13.18 for these miscellaneous supplies.
Sept. 30 Our membership drive is complete, and 25 students have decided to join BPA. Please prepare a deposit slip for the money received for dues ($13 per person) and record the deposit in the register. You will need a new income category for this (dues).
October 1 Issue a check to pay the district dues for our 25 members ($1 per person). Make the check payable to Bluffton High School BPA. Be sure to enter the check in the register. You will need a new expense category (Mem Dues) with 2 subcategories: National, State, and Local. This transaction category will be Local.
October 1 Issue a check for our state and national dues for each member ($12 per person). Make the check payable to Business Professionals of America. Category is National State.
October 25 Kristy Horn, the chairperson of our Service committee, brought in receipts for $26.32 for items she purchased for the Halloween party we are hosting for the Tucker Tots Childcare Center. Please reimburse her.
October 27 Ross Middleton purchased supplies for the November meeting. He has receipts totaling $6.49. Please reimburse him.
October 30 Our fund-raiser with Kleinhenn is now complete. Our total sales were $6,418. Our chapter gets to keep 42% of this amount as our profit. As soon as we have enough money in our account to pay Kleinhenn the amount we owe to them, please do so. (so what % will you need to reimburse???) (do you have enough money???) You do not need to make a deposit to our account.
November 2 Print Checks. Reconcile the checkbook for the months of September and October. New statement ending date is 10/30/06. The ending balance shown on the bank statement is $314.67. Check to Mr. Middleton is outstanding. There is neither service charge nor interest for our account. Print reports. Title is SeptthruOct.
November 1 We will be taking donuts to the poll workers at the election on Tuesday. Issue a check to Vogel’s Donuts for $12.00
November 5 Deposit the money received from the members today for the Kleinhenn fundraiser. You will need to create a new category of income, Fundraiser. A subcategory for this particular fundraiser (Kleinhenn). Worth noting here is that when you are able to pay the company, you will need to create an expense category, Kleinhenn Fundraiser. You make a single deposit as the total of all money received for November 5.·
Cindy Dunning-check for $150.00 and cash, $490.50
Ed Henry-cash, $95
Mark Slaven-check for $59.50
Joni Moss-cash, $145
Michelle Logan-check for $203 and cash, $100
Kirk Lewis-check for $305
November 6 Deposit today’s receipts from the fund-raiser·
Ross Middleton-cash, $365.50·
Jennifer Sample-cash, $120·
Kristina Rowe-check for $100.50
Kelly Swim-check for $49 and cash, $208·
Brandy Stewart-cash, $503·
Bruce Riddle-cash, $205·
Marla Dunlap-check for $69
November 7 Today’s fund-raiser receipts include:·
Shayna Marden-check for $204 and cash $62·
Kim Neal-check for $175·
Jake Upchurch- check for $135·
Scott Zook-cash, $100 and a check for $225.50·
Lela Price-cash, $356·
Lindsay Ice-cash $185
November 9 These students turned in their money for the fund-raiser today:
Rebecca Janney-cash, $200 and check for $350·
Chris Hahn-check for $265, and cash, $100·
Mark Catt-cash, $285·
Kathryn Briggs-check for $50·
Kristy Horn-check for $50 and cash, $348
November 13 The Civic Committee chairman needs a check for $15 to Wal-Mart to purchase supplies for the thanksgiving program we are having at the nursing home.
November 29 Kim Neal of the Social Committee is going to Marsh tonight to purchase a few things for our club meeting. Issue her a check for $12
December 1 Registration fees for District Leadership Conference need to be mailed in. All 25 of our students will be participating. The fees are $13 per person. Issue a check to Business Professionals of America for the total amount due
December 5 Our group will be giving each of the teachers in our building pencils with the BPA logo on them for Christmas presents. Please write a check to Newton Manufacturing for $30 for the pencils.
December 9 We have received the candy from Kleinhenn that we will be selling for the next fund-raiser. Please issue a check for $750.
December 15 Deposit the $560 cash that has been collected this week from the candy sales.
December 16 Issue a check to Wal-Mart for $6.39 for supplies for the December club meeting.
January 4 Deposit the $300 cash that was collected from our candy sales over the winter break.
January 5 Print checks. Reconcile the checkbook for the months of November and December. The ending balance on the bank statement is $2253.85. New statement date is Jan 4, current year. There are no outstanding checks, no service charge, and no interest for the account. However, the January 4 deposit IS outstanding. Print the report. Report name is NovthruDec
January 10 Candy sales for the week total $150 in cash.
January 15 I purchased some snacks for the students who will be staying after school this week to prepare for District contests next weekend. My receipts total $27.31.
January 17 Weekly candy sales receipts -- $250
January 24 Money from candy sales -- $500
January 30 Issue Ross Middleton a check to reimburse him for January club meeting expenses. He has a receipt for $5.01
January 31 Receipts from candy sales-- $170.00
February 6 Candy sales receipts--$180
February 8 Next week is National BPA Week (Vocational Education Week). The Civic Committee wants to give our advisory board BPA coffee mugs. Issue a check to Newton Manufacturing for $31.25 for the mugs.
February 10 Issue a check to BPA for State Conference Registration Fees. We have 10 students and one advisor attending. The registration cost per person is $18.
February 10 Our hotel bill for State conference is $1,350. Issue a check to pay the Westin Hotel that amount.
February 13 We will be delivering carnations to the nursing home residents tomorrow for Valentine’s Day. Prepare a check to George’s Flowers and Gifts for $50 for the flowers.
February 24 Ross Middleton needs a check for $20.03 for items he bought that will be used for the February meeting and State Leadership Conference preparation this week.
March 2 Print checks. Reconcile the checkbook for the months of January and February. The balance on the bank statement is $2142.28. New Statement Ending date is 2/24/Year. Check to Mr. Middleton is outstanding. There are no service charges, no interest earned and no outstanding deposits. Print the report. Name is JanthruFeb.
March 10 Four students and I will be going to nationals. We were able to get airline tickets for $150 each round trip. Please issue a check to American Airlines for the proper amount.
March 10 Issue a check to BPA for national fees. It is a $17 a person. We have 25 people.
March 20 The Social Committee has planned a pizza party for our Spring Fling. Issue a check for $90 to Papa John’s Pizza.
April 12 Mark Catt turned in $45 cash from his fund-raiser as well as a check for $235. Kristy Horn turned in $205 cash and a $15 check, and Maria Dunlap turned in $183 in cash.
April 19 We just completed our final fund-raiser and sold $2,142 from the Kleinhenn brochures. We owe the company 58% of that total to pay for the items. Issue a check for that amount.
April 21 Michelle Logan gave us a $450 check; Lindsay Ice paid $175 in cash; Mark Slaven turned in $95 cash; and Kirk Lewis turned in $195.50 cash.
April 25 Chris Hahn turned in $134.50 in cash; Brandy Stewart gave us $146.50 in cash; Kathryn Briggs turned in a check for $161 and $54 in cash; Jack Upchurch turned in $48.50 cash.
April 25 I will be going to Marsh this afternoon to get things for our April club meeting. I need to take a check for $10 to take with me to Marsh
April 25 Issue a check to the Hyatt Regency for our share of the hotel bill for Nationals which amounts to $1,230.
April 25 Issue a check for $240 to Blackford H.S. for state conference fees.
May 2 Print Checks. Reconcile the checkbook for the months of March and April. The bank statement balance is $1,507.31. New Statement ending date is April 25, year. Check is outstanding to Hyatt Regency. There is no service, no interest nor any outstanding deposit. Print the report. Name it MarthruApr.
May 15 The social committee is purchasing things for our final picnic at the park on Saturday. Issue a check to Marsh for $45.
May 17 We are purchasing certificates and pins from Newton Manufacturing for our graduating seniors. Issue check to them for $201.
May 25 Prepare a short memo to me letting me know what our final account balance is. Go to File…New in Word. Choose a Memo template of your choice. Include in your memo the information you think I should know about our financial status at this time.
Posted by ascummings at June 7, 2006 10:13 AM
Trackback Pings
TrackBack URL for this entry:
http://www.bsu.edu/eidm/journal/mt/mt-tb.cgi/400



