Finance Progress

From OpenPetra Wiki
Jump to navigation Jump to search

General Information

This is list of finance functionality along with an indication of progress and a list of things that still need to be done to complete each section. This is a work in progress, I am just adding sections as I go through testing...

Validation needs to be added to all screens so I have not specifically stated that for each one, though I have taken that into account when estimating the percentage done.

Finance Setup

  • Currencies (90%)
    • Display Format field is displayed in edit frame as "Number of Decimals". Either that needs to be renamed to display format or there needs to be some logic that converts between number of decimals and display format (eg. ->>>,>>>,>>>,>>9.99 displays number of decimals as 2) (bug#2052)
  • Corporate Exchange Rates (90%)
    • Still a bit more testing required (import + effect of changing used rates)
  • Daily Exchange Rates (90%)
    • Still a bit more testing required (import + effect of changing used rates)
  • Method of Giving (95%)
    • Although they are shown in Petra as well, it might be worth removing "Used by recurring gifts", "Involves a Trust" and "Involves a tax rebate" unless they are actually going to be used in OpenPetra (they are not used in Petra).
  • Method of Payment (95%)
    • Although it does also exist in Petra, it might be worth removing or renaming Special Method of Payment. In Petra it is basically a flag that prevents deletion of the method of payment and is used for Methods of payment that have special functionality associated with them (so is not really relevant on the maintenance screen). If it was to remain then renaming to Not Deletable? might be more helpful.
  • Analysis Types (90%)
    • Setup Shepherd missing (may be able to live without)
    • Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)
  • Form Design (0%)
  • Define HOSA & ICH Email Destinations (100%)

General Ledger Setup

  • Create Ledger (70%)
    • Need to add some additional accounts to the default COA (eg. ICH accounts). Will need to ask whether ICH should be asset or liability
    • Bugs (2156-2159)
    • May need to be linked more closely to ledger settings screen
  • Delete Ledger (100%)
  • Accounts (60%)
    • Need accounts displayed in full list, not just hierarchical view
    • Need print functionality
    • Account Rename not working (bug 2350)
    • May need some additional restrictions (eg. summary and posting account types should match)
    • Should disallow foreign currency accounts for income and expense accounts
    • Need Budget Control flag
  • Cost Centres (20%)
    • Need ability to add/remove foreign cost centres (Ledger->Setup->Tables->Foreign Ledgers in old Petra)
    • Should not allow cost centres to be created beneath a posting cost centre (eg. I was able to create a cost centre under 9900 in ledger 99)
    • Need delete functionality
    • Need Cost Centre Type field (Local/Foreign)
    • Need to be able to set Equity Settings on the Cost Centre
    • Need to be able to set Project Constraints
    • Need ability to create Non-ICH funds and set clearing account (new functionality as of Petra 2.2.19)
    • Need to lock down System Cost Centres (eg. 4300S)
    • Need to be able to move Cost Centres within hierarchy
    • Need Cost Centre rename
    • Need Cost Centre link to Partner
    • Need Print functionality
  • Enable/Disable Sub-systems (0%)
  • Define Calendar (only needed as part of ledger creation) (10%)
    • Need to be able to specify start and end dates of each period (currently can only specify number of periods)
      • An alternative that might be acceptable would be to only allow 12 or 13 periods and have the 13th period automatically set to the last day of the financial year.
  • General Parameters (50%)
    • The following parameters cannot yet be entered (even on ledger creation). It should be possible to set these on an existing ledger (not just on creation)
      • allow use of suspense accounts
      • enforce budget control
      • data retention
      • enable branch processing (need to check whether this is still needed)
      • Specify standard report text on selected reports (need to check if this is used)
    • Needs to be possible to view calendar settings (read only is fine)

General Ledger

  • GL Batch Maintenance
    • Batch Search (0%)
    • Transaction Search (0%)
    • Batch/Journal/Transaction grid (60%)
      • Moving between rows is much too slow
      • Bugs (#803, #804, #807, #1336)
    • Create/Edit/Delete/Print Batch Header (70%)
      • No print option
      • Should not allow blank description
      • Bugs (#800-#802, #805-#806, #841, #1380)
    • Create/Edit/Delete/Print Journal Header (20%)
      • No print option
      • Should not allow blank description
      • Journal description should default to batch description
      • Bugs relating to setting of exchange rate (#811-#814)
      • Need Allocation journals
      • Need Re-allocation journals
      • Need Revaluation journals
    • Create/Edit/Delete/Print Transactions (50%)
      • No print option
      • Should not allow blank narrative
      • Bugs #821, #1337
      • Key Ministry list needs to populate with appropriate list if a foreign cost centre is selected along with account 3300. List should be disabled the rest of the time
      • Some work needed on analysis attributes
      • Needs to check on Save that budget not exceeded (if account has budget control flag set). (this may be there already but not possible to test because no budget control flag on Account setup
    • Import Transactions (0%)
      • Can't import transactions into an existing journal (can only import a whole batch currently)
    • Reverse batch (0%)
    • Reverse journal (0%)
    • Post Batch (still testing)
      • Test Batch and Post Batch need to check debit/credit total against hash total
      • Posting register
      • Bugs (#808-#810)
    • Posting Register Reprint (0%)
  • Recurring Batch Maintenance (0%)
    • Batch Search
    • Journal Search (necessary?)
    • Transaction Search
    • Batch/Journal/Transaction grid
    • Create/Edit/Delete/Print Batch Header
    • Create/Edit/Delete/Print Journal Header
    • Create/Edit/Delete/Print Transactions
    • Submit Batch
  • Import/Export
    • Import batch (70%)
      • Daily exchange rate record should be created if a foreign currency journal is imported
      • Doesn't provide option to accept, for example, "100" as "0100" (Petra does this, presumably to help with problems caused by csv generation in Excel)
      • bugs (#1338, 1376, 1377, 1410 - 1412)
    • Export batch (80%)
      • bugs (#1339, 1344, 1346)
  • Display Balances
    • Foreign Currency Accounts (0%)
    • Suspense Accounts (0%)
    • All accounts (0%)
  • Reports
    • Balance Sheet (50%)
      • Needs option to select Cost Centre(s), including Cost Centre Breakdown option and option to toggle between showing inactive cost centres or not
      • Needs Auto-Email option
      • bugs
    • I&E (50%)
      • Needs Auto-Email option
      • Cost Centre Breakdown not working
      • Can't test "All Cost Centre" options because of dire performance
      • lots of bugs
    • Account Detail (70%)
      • Needs Auto-Email option
      • Needs "Display local CC's First" option
      • Various Bugs
      • Performance needs to improve
    • Trial balance (70%)
      • Needs "Display local CC's First" option
      • Needs major performance improvements
      • Need to clarify purpose of Sort by Department option
      • bugs
    • AFO Report (0%)
    • Analysis Attributes
      • Will test later once firm decision on Alwyn's multi-dimension reporting
    • Internal Transfer (70%)
      • Although this doesn't exist yet it is effectively just a very specific account detail report so once Account Detail report is finished this is trivial (and may not even be needed as a separate report?)
    • Expense Acct Detail (70%)
      • Ditto Internal Transfer
    • Extract Suspense (70%)
      • Ditto above
    • HOSA Reprint
    • Executive Summary (0%)
    • Surplus/Deficit
    • Posted Batch (0%)
      • I couldn't find this anywhere
  • Month-end (60%)
    • UI needs improvement
    • Needs to run ICH calculation
    • Needs suspense account printing
    • Needs automatic report printing
  • Year-end
  • Foreign Currency Revaluation (20%??)
    • Several major bugs (1509-1512)
  • 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 import (20%)
    • Doesn't support correct import format (bug 1469)
    • Bugs (1466)
  • Budget maintenance (40%)
    • Needs printing
    • Need to show the actual budget period values in the grid
    • Needs some sort of Find facility (a filter, with wildcards, by Cost Centre and/or Account might suffice)
    • Doesn't cope with anything other than a 12 period ledger (bug 1455)
    • bugs (1437-1439, 1444-1446, 1453-1455, 1463-1465)
  • Autogenerate Budgets for year (20%)
    • Can't get it to actually generate budgets (1473)
    • bugs (1470, 1472)
  • Submit (consolidate) budget (90%)
    • Needs more extensive testing with a "real" database but looking good
  • Budget Export (20%) - not provided in Petra
    • Doesn't support correct file format (bug 1469)

Gift Processing

  • Setup
    • Admin Grants (75%)
      • Needs delete & print
      • Bug 1069
    • Motivation Group (90%)
      • Needs Delete button
    • Motivation Detail (30%)
      • Can't enter non-GIFT motivation details (bug 964)
      • No Motivation Short Code (for display on receipts)
      • No local description
      • No link to Key Ministries
      • No "Populate Gift Description"
      • No "Tax deductible" check-box
      • No "Export to Caleb" check-box
      • Admin fee lists could do with being a bit larger so descriptions can be read
      • Currently cost centre list only includes local CC's. This might be ok except that Petra allows Foreign CC's so if installing OpenPetra for an existing site there might be a problem (eg. South Africa db has a motivation with cost centre 4100)
  • Gift Batch Maintenance
    • Batch Search (50%)
      • Can filter by year & period but might be better to filter by batch description and date range as in "old" Petra
    • Transaction Search (0%)
    • Batch Header (View/Create/Edit/Delete/Print) (70%)
      • Needs validation that date is in open period
      • Needs some sort of link to Daily Exchange Rates (currently exchange rate just entered manually)
      • Needs print functionality
      • Various bugs (893, 895-897, 934-936)
    • Gifts & Details(View/Create/Edit/Delete/Print) (50%)
      • Need to automatically pick up previous gift from selected donor
      • Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY)
      • Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup)
      • Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup)
      • Needs print functionality
      • Grid needs re-design to make distinction clear between normal and split gifts (see forum entry: https://sourceforge.net/apps/phpbb/openpetraorg/viewtopic.php?f=14&t=221)
      • Recipient class currently unlimited. Probably needs to be limited to FAMILY, PERSON or UNIT.
      • Recipient field doesn't seem to be getting picked up properly (bug #1001)
      • Various bugs (979-982, 984-985)
      • Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity)
      • Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field [see Specification for Worker Field ] properly implemented)
      • Admin grant processing (can't easily test for this yet as not implemented in month-end
    • Import/Export Gifts (0%)
      • Can only import whole batches at present
    • Field Change Adjustment(0%)
    • Gift reversal (70%)
      • Many bugs (1002,1004-1008,1015,1018,1023-1024,1052)
    • Gift adjustment (70%)
      • See Gift Reversal bugs
    • Gift detail reversal (70%)
      • Set Gift Reversal bugs
    • Gift Batch reversal (70%)
      • See Gift Reversal bugs
    • Post Gift Batch (50%)
      • Needs fee processing
      • No warning currently for gifts to EX-WORKERs. Some equivalent to that is probably needed (in Petra it is based on EX-OMER special type)
      • Needs to check that any Key Ministries being given to are still active
      • Need warning if confidential flag not ticked for any donors that have the anonymous donor flag set
      • Need to get up-to-date cost centre and account based on recipient/motivation (leaving cost centre untouched if a reversal)
      • Need to be able to post batches with zero batch total (eg. if it is an adjustment batch where just the donor name is changed). See bug 1086.
      • iConnect stuff (mainly telling bbec that posting successful)
      • bug 1084
  • Recurring Gift Batch Maintenance
    • Batch Search (0%)
    • Transaction Search (0%)
    • Batch Header (View/Create/Edit/Delete/Print) (70%)
      • Need printing
      • Deletion fails (bug 1098)
    • Gifts & Details (View/Create/Edit/Delete/Print) (60%)
      • Need printing
      • transaction numbers not re-used (bug 984)
      • needs redesign to match gift detail tab (bug 1099)
      • Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity). Label is there but not functional.
      • Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY)
      • Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup)
      • Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup)
      • Recipient class currently unlimited. Probably needs to be limited to FAMILY, PERSON or UNIT.
      • Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field [see Specification for Worker Field ] properly implemented)
    • Import Recurring Gifts (0%)
    • Submit Recurring Gift Batch (80%)
      • Needs checks for EX-WORKERs and expired Key Ministries
  • Import/Export
    • Import Gift Batch (60%)
      • Bugs 1025, 1070, 1073-1080
      • Currently processing stops at the first validation error. It may be necessary to change it to process the whole file to present a list of errors. This is a change we made to Petra for iConnect so may not be an immediate priority but should be considered.
      • iConnect extras (handling reversal reference + logging)
    • Export Gift Batch (60%)
      • Base currency export doesn't work (just exports in transaction currency still) (Bug 1074)
      • Currently ignores Recipient and Field fields (bug 1341)
      • Summary export not properly implemented (bug #1343)
      • Other bugs (bug #1342, 1345)
  • Receipting
    • Periodic Receipts (?)
      • difficult to test without Partner Finance details and form design
    • Receipt per Gift (on Gift Post) (50%)
      • need option to cancel receipt printing (bug 1056)
      • need to be able to select receipt form to use (once form design is implemented in some way)
      • needs further testing once form design implemented
      • Problems with cancelling printing (bug 1327)
      • needs connection to print dialog (when there is one)
    • Receipt Control
      • Receipt per gift (70%)
        • Problems with cancelling printing (bug 1327)
        • needs connection to print dialog (when there is one)
        • need to be able to select receipt form to use (once form design is implemented in some way)
        • needs further testing once form design implemented
      • Change receipt numbering (100%)
  • Gift History
    • Donor & Receipient history (80%)
      • Add links to donor and recipient statements (not essential but Petra does have them on File menu)
      • View should go straight to the actual gift not just the batch containing it
      • Bugs (1330,1331)
  • Reports
    • Recipient Gift Statement
    • Recipient Gift Totals (0%) - May not be needed?
    • Recipient Gift Email (0%)
    • 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 (0%)

Accounts Payable

  • Create and maintain Supplier (100%)
  • Create and maintain invoice / credit note (70%)
    • Missing Early Payment Discount
    • "Use Tax Account/CC" missing. Button there but no functionality. Don't know whether this is actually used in Petra.
    • No options on screen to Approve or Reverse
  • List of suppliers and outstanding invoices (80%)
    • Missing Find by AP number (not sure whether this is actually needed)
  • Post an invoice (90%)
    • Various bugs
    • Should give warning if attempting to post to inactive accounts/cost centres
  • Approvals (0%)
  • Early Payment Discount (0%)
  • Invoice Payment (incl. partial payments) (40%)
    • "Print Cheque" disabled
    • No Early Payment Discount
    • Missing Tools Menu (sequential cheque numbering, global reference, global bank account & single invoice per payment)
    • No way to remove an invoice from the payment (ie. some sort of remove invoice button)
    • Payment by Transfer is missing
    • Can't test multi-supplier payments due to bug in outstanding invoices tab (bug #1991)
    • Various bugs
  • Analysis Attributes (100%)
  • Maintain defaults (0%)
  • Reverse Payments
    • Can't test due to unhandled exception
  • Reverse invoices (80%)
    • Can't reverse open invoices (ie. cancel them). Needs to be some way of cancelling an unposted invoice whether using reverse option as in Petra or having a separate cancel button
    • A few bugs
  • Import/Export (0%)
  • Cheque/Remittance printing (20%)
    • No cheque printing
    • Remittance does get printed but no control over output as far as I can see
  • Reports
    • Account Detail (100%)
    • Aged supplier list (90%)
      • Bug 2078
    • Current Accounts Payable (80%)
      • Missing "print detailed codes" option. No idea whether that is actually needed.
      • bug 2044
    • Invoice list (0%)
    • Supplier Statements (0%)
    • Payment Report (to be produced on payment and available for reprint) (85%)
      • bug 2097

ICH

  • Stewardship
    • Stewardship calculation
      • Needs to cope with non-ICH funds (eg. India)
      • bugs (1432, 1435)
      • bug 1435 prevents further testing
    • Stewardship Reports (1%)
      • HOSA (initial implementation exists)
      • Fees report
      • Stewardship Report
      • Auto-Email HOSA & RGS to each field
      • Email Export to head-office (for branch processing)
  • ICH Ledger (0%)
    • Import Stewardship file
    • Automated Bulk Stewardship import
    • Reports
      • Fund Balance
      • ICH Statement
      • Stewardship Status Report