Managing Chapter Finances Using Quicken

1
Managing Chapter Finances Using Quicken

• Leadership Summit
• Charleston, SC
• June 17-18th, 2005
• Sam Smith
• Chief Financial Officer

2
Managing Chapter Finances Using Quicken

• Why Use Quicken ?
• Easy to learn
• Efficient data input
• Availability of reports
• Easy to display information in Chart Format
• Speed of bank reconciliations
• Query feature

3
Managing Chapter Finances Using Quicken

• Cost of Quicken software
• Ranges from 30 for Basic edition to 80 for Home
  and Business edition
• Between these two are Deluxe and Premier editions
• Deluxe adds Personal Wealth module
• Premier adds Investment Management module
• Home and Business adds Business module

4
Managing Chapter Finances Using Quicken

• This presentation is based on the Basic edition
• Includes all features which would typically be
  used by a chapter
• Includes export to Excel feature for sending
  via e-mail etc.

5
Managing Chapter Finances Using Quicken

• Presentation will cover
• Set-up
• Account categories (and sub-categories)
• Cash/Bank Deposits
• Check writing
• Financial Reports
• Balance your checkbook
• Queries
• Budgets

6
Managing Chapter Finances Using Quicken

• Set-up
• Quicken Guided Tour

7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
Managing Chapter Finances Using Quicken

• Account Categories

20
(No Transcript)
21
Managing Chapter Finances Using Quicken

• Cash/Bank Deposits

22
(No Transcript)
23
Managing Chapter Finances Using Quicken

• Check Writing

24
(No Transcript)
25
(No Transcript)
26
Managing Chapter Finances Using Quicken

• Financial Reports

27
Managing Chapter Finances Using Quicken

• Designing Financial Reports
• Hit reports, cash flow, income and expense (one
  of several predefined reports in Quicken).
• Hit preferences, setup,calendar and currency,
  working calendar, fiscal year, starting month
  July.
• Hit preferences, reminders, reports and graphs,
  set default date range and default comparison
  date range either full fiscal year or year to
  date
• Select date range typically custom date, select
  interval typically month, quarter, or year

28
Managing Chapter Finances Using Quicken

• Designing Financial Reports
• Hit customize
• Display, enter title, choose cents or no cents
• Accounts select both checking and savings or
  just checking
• Categories elect to show all or just those used
  for chapter financial report
• Category Groups select all
• Advanced elect to show just main categories or
  main and sub categories

29
Managing Chapter Finances Using Quicken

• Designing Financial Reports
• Then save report
• Then print report
• All reports may be displayed in traditional
  format or graphic format
• Reports may also be exported to Excel. Hit Export
  data, Excel compatible format, select
  destination, name file and save

30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
Managing Chapter Finances Using Quicken

• To export Quicken reports to Excel
• At Chapter Financial Report page
• Hit export data
• To Excel compatible format
• Create in appropriate folder and type in file
  name
• Hit open and go to Excel

35
Managing Chapter Finances Using Quicken

• To export Quicken reports to Excel
• Text Import Wizard choose delimited and hit
  next
• Select tab and hit next
• Select general and hit finish
• Adjust presentation in Excel edit titles etc.

36
Managing Chapter Finances Using Quicken

• Balance Your Checkbook

37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41

42
Managing Chapter Finances Using Quicken

• Queries

43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
Managing Chapter Finances Using Quicken

• Budgets

50
(No Transcript)
51
(No Transcript)
52
(No Transcript)
53
(No Transcript)
54
(No Transcript)
55
Other

• To add to or delete from toolbar
• Hit customize
• Select from list on left of screen
• Checks are ordered through Quicken
• Frequency of Reports/Transactions
• Bank Reconciliations Monthly
• Income Statement Monthly
• Checks As needed
• Backup - Monthly