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 - There is a screen, but you cannot add or delete, only edit existing records Pokorra 13:30, 8 June 2011 (UTC)
• Corporate Exchange Rates - not done yet Pokorra 13:30, 8 June 2011 (UTC)
• Daily Exchange Rates - You can edit and import currencies, but deleting and add does not work yet. Screen was written quite early, needs to be adjusted to recent templates / maintain table idea Pokorra 13:30, 8 June 2011 (UTC)
• Method of Giving - not done yet Pokorra 13:30, 8 June 2011 (UTC)
• Method of Payment - not done yet Pokorra 13:30, 8 June 2011 (UTC)
• Analysis Types - Done --Mshobohm 11:23, 1 June 2011 (UTC)
• Form Design - not done, should be replaced by the new HTML template system for printing mail merge letters Pokorra 13:30, 8 June 2011 (UTC)
• Define HOSA & ICH Email Destinations - not done yet Pokorra 13:30, 8 June 2011 (UTC)

General Ledger Setup

• Accounts
  • Maintain Accounts Hierarchy - basically works Pokorra 13:35, 8 June 2011 (UTC)
    • Display hierarchy - yes in a tree view Pokorra 13:35, 8 June 2011 (UTC)
    • Create/Edit accounts (incl. whether suspense or foreign currency accounts) - yes, you can create and edit accounts, and foreign currency accounts, but nothing done about suspense accounts yet Pokorra 13:35, 8 June 2011 (UTC)
    • Move accounts within hierarchy - not done yet Pokorra 13:35, 8 June 2011 (UTC)
    • Activate/deactivate accounts - yes Pokorra 13:35, 8 June 2011 (UTC)
  • Rename Accounts (ie. change account code, updating all history accordingly) - not done, we should do this with new primary keys as autoincrement/sequence IDs not account code Pokorra 13:35, 8 June 2011 (UTC)
• Cost Centres - basically works Pokorra 13:35, 8 June 2011 (UTC)
  • Maintain Cost Centre Hierarchy
    • Create/Edit Cost Centres - yes Pokorra 13:35, 8 June 2011 (UTC)
    • Move Cost Centres within hierarchy - no Pokorra 13:35, 8 June 2011 (UTC)
    • Activate/deactive Cost Centres - yes Pokorra 13:35, 8 June 2011 (UTC)
  • Link Cost Centres to Partners - no Pokorra 13:35, 8 June 2011 (UTC)
  • Rename Cost Centres (ie. change Cost Centre code, updating all history accordingly) - no, see comment for renaming account codes Pokorra 13:35, 8 June 2011 (UTC)
• Analysis Attributes
  • Setup Shepherd - no Pokorra 13:35, 8 June 2011 (UTC)
  • Associate Analysis Types with Accounts - yes, done by MH Pokorra 13:35, 8 June 2011 (UTC) 40% (TODO DELETE BUGFIX)--Mshobohm 17:56, 16 June 2011 (UTC)
  • Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it) - no Pokorra 13:35, 8 June 2011 (UTC)
  • Set list of possible Analysis Values - Setup of values can de done --Mshobohm 11:26, 1 June 2011 (UTC)
• Enable/Disable Sub-systems (Gift, AP) - no Pokorra 13:35, 8 June 2011 (UTC)
• Define Calendar - you can only define these parameters when creating a new ledger. We don't have functionality yet to modifiy the calendar of an existing ledger Pokorra 13:35, 8 June 2011 (UTC)
  • Start date
  • Number of periods
  • Start/End dates for each period
  • Number of forward posting periods
• General Parameters - you can only define these parameters when creating a new ledger. We don't have functionality yet to modifiy an existing ledger Pokorra 14:08, 8 June 2011 (UTC)
  • 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 - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Journal Search (necessary?) - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Transaction Search - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Batch/Journal/Transaction grid (incl. Posted/Unposted filter) - done Pokorra 14:13, 8 June 2011 (UTC)
  • Create/Edit/Delete/Print Batch Header - create edit cancel works, print does not Pokorra 14:13, 8 June 2011 (UTC)
  • Create/Edit/Delete/Print Journal Header - create edit delete works, print does not Pokorra 14:13, 8 June 2011 (UTC)
    • Standard journals - yes Pokorra 14:13, 8 June 2011 (UTC)
    • Allocation journals - not sure Pokorra 14:13, 8 June 2011 (UTC)
    • Re-allocation journals - not sure Pokorra 14:13, 8 June 2011 (UTC)
    • Revaluation journals - not sure Pokorra 14:13, 8 June 2011 (UTC)
  • Create/Edit/Delete/Print Transactions - create edit delete works, print does not Pokorra 14:13, 8 June 2011 (UTC)
    • Analysis Attributes
  • Import Transactions - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Reverse batch - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Reverse journal - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Post Batch - works, but needs review and testing. no deep calculation at the moment during posting Pokorra 14:13, 8 June 2011 (UTC)
  • Posting Register Reprint - not done, WU was working on that Pokorra 14:13, 8 June 2011 (UTC)
• Recurring Batch Maintenance - not done Pokorra 14:13, 8 June 2011 (UTC)
  • 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 - Done --Mshobohm 11:43, 1 June 2011 (UTC)
  • Export batch - Done --Mshobohm 11:43, 1 June 2011 (UTC)

• Display Balances - not done Pokorra 14:13, 8 June 2011 (UTC)
  • Foreign Currency Accounts
  • Suspense Accounts
  • All accounts

• Reports
  • Balance Sheet - done in Petra 2.3 Pokorra 14:13, 8 June 2011 (UTC)
  • I&E - done in Petra 2.3 Pokorra 14:13, 8 June 2011 (UTC)
  • Account Detail - done in Petra 2.3 Pokorra 14:13, 8 June 2011 (UTC)
  • Trial balance - done Pokorra 14:13, 8 June 2011 (UTC)
  • AFO Report
  • Analysis Attributes - done Pokorra 14:13, 8 June 2011 (UTC)
  • Internal Transfer
  • Expense Acct Detail
  • Extract Suspense
  • HOSA Reprint
  • Executive Summary
  • Surplus/Deficit
  • Posted Batch - Some Refactoring work has to be done before, but I think it is actually to be done Wolfganguhr 10:45, 31 May 2011 (UTC) (this Posted Batch Report might be about the Posting Register report Pokorra 14:13, 8 June 2011 (UTC))

• Month-end - Admin-Fee Setup does not work but the root routine is done Wolfganguhr 10:42, 31 May 2011 (UTC)

• Year-end - ich-fee setup does not work but the root routine is done Wolfganguhr 10:42, 31 May 2011 (UTC)

• Foreign Currency Revaluation - Done, actually to an from is exchanged Wolfganguhr 10:42, 31 May 2011 (UTC)

• International Currency Revaluation (if necessary - depending on whether intl balances are stored) - This is not intended to be implemented in this way Wolfganguhr 10:42, 31 May 2011 (UTC)

• Resummarisation of balances (if necessary - depending on whether summarisations are stored) - Actually it is not intended to implement this Wolfganguhr 10:42, 31 May 2011 (UTC)

Budgeting

no work has been done on budgeting yet Pokorra 14:14, 8 June 2011 (UTC)

• 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

Accounts Payable

AP is largely functional, although it needs to be assessed by a real user. Comments reflect a three-month re-work by Tim Ingham at the start of 2012:

• Create and maintain Supplier is complete.
• Create invoice / credit note is complete.
• List of suppliers and outstanding invoices works well.
• Post an invoice is complete.
• Invoice Payment works well. A number of invoices can be paid at once to one supplier, and several suppliers can be paid in one operation.
• Analysis Attributes are supported.
• Foreign currency transactions are supported, with re-valuation as required to balance the ledger.
• A payment can be "reversed" - OpenPetra creates matching credit notes / invoices to un-do the effect of a payment.
• A posted invoice can be "reversed" - OpenPetra posts matching postings to restore the ledger.

Not everything has been implemented - in particular:

• No Approval status support - all invoices are automatically in "approved" state.
• No support for early payment discount - this was found to be non-functional in Petra, so we conclude that there's no urgent need for it.
• No import or export - I have not found anyone who understands why we might want this.
• No cheque printing - the use of cheques is being replaced by electronic transfer.

Gift Processing

• Setup
  • Admin Grants - not done Pokorra 14:21, 8 June 2011 (UTC)
  • 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 - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Transaction Search - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Gift Batch/Transaction grid (incl. Posted/Unposted filter)100%? Grid and filter is there --Mshobohm 15:34, 6 June 2011 (UTC)
  • Create/Edit/Delete/Print Batch Header 75% (TODO print)--Mshobohm 15:32, 6 June 2011 (UTC)
  • Create/Edit/Delete/Print Gifts 75% (TODO print)--Mshobohm 15:32, 6 June 2011 (UTC)
    • gifts for workers still has to be done, current field etc. a lot of detailed functionality on the gift entry screen is probably still missing. use recipient from previous gift, use comment from motivation detail, add subscription for new donors.
  • Import Gifts - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Field Change Adjustment - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Gift adjustment - Done --Mshobohm 11:55, 1 June 2011 (UTC)
  • Gift reversal - Done --Mshobohm 11:55, 1 June 2011 (UTC)
  • Gift detail reversal - Done --Mshobohm 11:55, 1 June 2011 (UTC)
  • Gift Batch reversal - Done --Mshobohm 11:55, 1 June 2011 (UTC)
  • Post Gift Batch - done Pokorra 14:21, 8 June 2011 (UTC)
    • Incl. fee processing - not done Pokorra 14:21, 8 June 2011 (UTC)
• Recurring Gift Batch Maintenance
  • Batch Search - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Transaction Search - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Gift Batch/Transaction grid 100%? (grid is there) Mshobohm
  • Create/Edit/Delete/Print Batch Header - 50% (no print,no delete) Mshobohm
  • Create/Edit/Delete/Print Gifts -75% (no print) Mshobohm
  • Import Gifts - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Submit Recurring Gift Batch - 90% TODO if needed check recipient for EX-OM staff --Mshobohm 15:28, 6 June 2011 (UTC)
• Import/Export
  • Import Gift Batch - Done --Mshobohm 11:45, 1 June 2011 (UTC)
  • Export Gift Batch - Done --Mshobohm 11:45, 1 June 2011 (UTC)
• Receipting
  • Periodic Receipts - first version with HTML template works Pokorra 14:21, 8 June 2011 (UTC)
  • Receipt per Gift (on Gift Post) - not done Pokorra 14:21, 8 June 2011 (UTC)
  • Receipt Control
    • Receipt per gift - not done Pokorra 14:21, 8 June 2011 (UTC)
    • Change receipt numbering - not done Pokorra 14:21, 8 June 2011 (UTC)
• Gift History
  • Donor history - 90% (TODO Correct handling of Confidential or restricted gift) --Mshobohm 18:00, 16 June 2011 (UTC)--Mshobohm 11:55, 1 June 2011 (UTC)
  • Receipient history - 90% (TODO Correct handling of Confidential or restricted gift,TODO If needed Display Status or check for Batch status) --Mshobohm 18:00, 16 June 2011 (UTC)--Mshobohm 11:55, 1 June 2011 (UTC)
• Reports
  • Recipient Gift Statement -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • Recipient Gift Totals
  • Recipient Gift Email
  • Donor Gift Statement -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • 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 -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • Field Gift Totals -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • Field leader gift summary -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • Field leader gift summary (2) -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
  • Total gifts through field -- done by Bernd Pokorra 14:21, 8 June 2011 (UTC)
• Swiss Tax-Deductibile gift functionality

ICH

• Stewardship
  • Stewardship calculation Implemented by Chris, needs testing --Pokorra 11:01, 18 January 2012 (UTC)
  • 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