Notes
Slide Show
Outline
1
Did You Know?
  • Congress allocates funds to the USDA FS WO for the NF to the RO for the B&F at each SO and then to the districts for the SSS to monitor by EBLI, WA and Job Code to reconcile with FFIS.
2
ALEX
  • Helping the US Forest Service keep track of the money.
3
Keep Track of the Money
  • Coming In
    • Allocations for Annual Budget
    • Allocations for Projects
    • Fee Collections
4
Microsoft Office XP
    • If you have Microsoft Office XP then there is no need to purchase any other supporting software.


    • ALEX is a database accessible through Microsoft Office XP.


5
Current Installation
  • Georgia
  • Tennessee
  • North Carolina
  • Mississippi
  • Arkansas
6
Benefits
  • Works within Microsoft Office XP
  • Provides reports for reconciliation with FFIS
  • Tracks planning and expenses for each site or structure
  • Tracks allocations and collections in the same database
  • Provides daily balancing of collections
  • Reports funds available per forest, subunit and site
  • Shares one database with multiple users at the same time
  • Provides consistency of data across different locations
  • Tracks obligated, actual and projected expenses
  • Provides quick access to accurate reports
  • Saves time!
7
Tracks Projects, Allocations, Collections, Expenses and Salaries
  • By Job Code & Resource Area
  • By EBLI Fund & Work Activity Code
  • By Budget Object Group & Code
  • By Employee & Salary Code
  • By System Transaction Code
  • By Site, Facility, Structure or Trail
  • By GAO Expenditure Classification
  • By Vehicle & Property Codes
  • By Supplier & Contractor
8
Project Work Plans
  • Provides project planning within Job Code.
    • Employee hours, days and per diem
    • Equipment EOR and FOR rates
    • Supplies and Contractors
  • Provides immediate comparison of planned expenses against actual expenses.
  • Provides cross reference of employees, equipment and contractors per project.
9
Allocation and Collection Reports
  • Total Allocations and Collections
    • By Date Range
    • By Job Code
    • By EBLI Code
    • By Work Activity Code
    • By Budget Object Group
  • Total Collections per Site
    • By Percentage of Distribution
10
Collections
  • Prints Bills for Collection
  • Tracks Money From Collection Sites
  • Automatically Distributes to Job Codes
    • For example:
      • 80% for Fee Demo Site
      • 15% for Fee Collection Support
      • 5% for Fee Collection Reserve
  • Helps Balance to Bank Lockbox Deposits
  • Helps Balance to NFC reports
11
Expenses by GAO Codes
12
Expense Reports
  • By Date Range
  • By Location or Subunit
  • By Job Code
  • By Collection Site
  • By EBLI Code
  • By System Transaction Code
  • By Vendor or Contractor
  • By Budget Object Code
  • By Employee
  • By Pay Period
13
Track Salaries by Employee
  • Social Security Number
  • Employee Name
  • Location or Subunit
  • Hours Worked vs. Hours Planned
  • Pay Period
  • Base Rate / Cost to Government Rate
14
Keep Track of Your Money
  • Know where the money came from.
  • Know where the money went.
  • Know how much money is available, daily.
15
ALEX
  • Get it and keep track of your money.
16
Contacts
  • J Tom Kinser
  • Cymations Inc
  • Cumming, GA
  • www.cymations.com


  • (404) 909-2776
  • tom@cymations.com


  • Microsoft Certified Solution Developer & Trainer
  • Barbara Harper
  • Retired US Forest Service
  • Jacksonville, FL



  • (904) 655-8050
  • bsharper@att.net