Overall List of Finance Functionality

General Information

This is an overall list of functionality that should be aimed for in the Finance module which originated from the Petra Finance Module. The order and importance of implementation is subject to prioritization.

Finance Setup

• Currencies
• Corporate Exchange Rates
• Daily Exchange Rates
• Method of Giving
• Method of Payment
• Analysis Types
• Form Design
• Define HOSA & ICH Email Destinations

General Ledger Setup

• Accounts
  • Maintain Accounts Hierarchy
    • Display hierarchy
    • Create/Edit accounts (incl. whether suspense or foreign currency accounts)
    • Move accounts within hierarchy
    • Activate/deactivate accounts
  • Rename Accounts (ie. change account code, updating all history accordingly)
• Cost Centres
  • Maintain Cost Centre Hierarchy
    • Create/Edit Cost Centres
    • Move Cost Centres within hierarchy
    • Activate/deactive Cost Centres
  • Link Cost Centres to Partners
  • Rename Cost Centres (ie. change Cost Centre code, updating all history accordingly)
• Analysis Attributes
  • Setup Shepherd
  • Associate Analysis Types with Accounts
  • Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)
  • Set list of possible Analysis Values
• Enable/Disable Sub-systems (Gift, AP)
• Define Calendar
  • Start date
  • Number of periods
  • Start/End dates for each period
  • Number of forward posting periods
• General Parameters
  • Ledger name
  • Base Currency
  • International Currency
  • Enable/Disable use of Suspense Accounts
  • Enable/Disable budgeting
  • Enable/Disable branch processing
  • Specify standard report text on selected reports
  • Data Retention (GL & Gift)

General Ledger

• GL Batch Maintenance
  • Batch Search
  • Journal Search (necessary?)
  • Transaction Search
  • Batch/Journal/Transaction grid (incl. Posted/Unposted filter)
  • Create/Edit/Delete/Print Batch Header
  • Create/Edit/Delete/Print Journal Header
    • Standard journals
    • Allocation journals
    • Re-allocation journals
    • Revaluation journals
  • Create/Edit/Delete/Print Transactions
  • Import Transactions
  • Reverse batch
  • Reverse journal
  • Post Batch
  • Posting Register Reprint
• Recurring Batch Maintenance
  • Batch Search
  • Journal Search (necessary?)
  • Transaction Search
  • Batch/Journal/Transaction grid
  • Create/Edit/Delete/Print Batch Header
  • Create/Edit/Delete/Print Journal Header
    • Standard journals only
  • Create/Edit/Delete/Print Transactions
  • Submit Batch

• Import/Export
  • Import batch
  • Export batch

• Display Balances
  • Foreign Currency Accounts
  • Suspense Accounts
  • All accounts

• Reports
  • Balance Sheet
  • I&E
  • Account Detail
  • Trial balance
  • AFO Report
  • Analysis Attributes
  • Internal Transfer
  • Expense Acct Detail
  • Extract Suspense
  • HOSA Reprint
  • Executive Summary
  • Surplus/Deficit

• Month-end

• Year-end

• Foreign Currency Revaluation

• International Currency Revaluation (if necessary - depending on whether intl balances are stored)

• Resummarisation of balances (if necessary - depending on whether summarisations are stored)

Budgeting

• Budget Maintenance
  • Budget import
  • Budget grid (display all accounts with budgets attached)
  • Set Budget Type for a CC/Acc Combo
  • Budget Edit for current & next year for each Budget Type:
    • Adhoc
    • Inflate after n periods
    • Inflate off base
    • Same each period
    • Split total
• Autogenerate Budgets for year
  • Based on last years budget
  • Based on last years actuals
• Submit (consolidate) budget

Gift Processing

• Setup
  • Admin Grants
  • Motivation Group - Done Wolfganguhr 10:38, 31 May 2011 (UTC)
  • Motivation Detail - Done Wolfganguhr 10:38, 31 May 2011 (UTC)
• Gift Batch Maintenance
  • Batch Search
  • Transaction Search
  • Gift Batch/Transaction grid (incl. Posted/Unposted filter)
  • Create/Edit/Delete/Print Batch Header
  • Create/Edit/Delete/Print Gifts
  • Import Gifts
  • Field Change Adjustment
  • Gift adjustment
  • Gift reversal
  • Gift detail reversal
  • Gift Batch reversal
  • Post Gift Batch
    • Incl. fee processing
• Recurring Gift Batch Maintenance
  • Batch Search
  • Transaction Search
  • Gift Batch/Transaction grid
  • Create/Edit/Delete/Print Batch Header
  • Create/Edit/Delete/Print Gifts
  • Import Gifts
  • Submit Recurring Gift Batch
• Import/Export
  • Import Gift Batch
  • Export Gift Batch
• Receipting
  • Periodic Receipts
  • Receipt per Gift (on Gift Post)
  • Receipt Control
    • Receipt per gift
    • Change receipt numbering
• Gift History
  • Donor history
  • Receipient history
• Reports
  • Recipient Gift Statement
  • Recipient Gift Totals
  • Recipient Gift Email
  • Donor Gift Statement
  • Donor Gifts to Selected Fields
  • Donor Gift Summary to Selected Fields
  • Donor Gift Totals
  • Donor Gift Tax Claim Report (Selected Fields)
  • One year monthly gift report
  • Total giving for selected Recipients
  • Field Gift Totals
  • Field leader gift summary
  • Field leader gift summary (2)
  • Total gifts through field
• Swiss Tax-Deductibile gift functionality

ICH

• Stewardship
  • Stewardship calculation
  • Stewardship Reports
    • HOSA
    • Fees report
    • Stewardship Report
    • Auto-Email HOSA & RGS to each field
    • Email Export to head-office (for branch processing)
• ICH Ledger
  • Import Stewardship file
  • Automated Bulk Stewardship import
  • Reports
    • Fund Balance
    • ICH Statement
    • Stewardship Status Report