Requirements

• Access Control

  • Requiring logins, TigerCore already has this feature

• Term information
  • Date range
  • Somewhere that keeps record of WHO the current treasurer is (and ties entries to that name)
• Budget
  • Spreadsheet with provided fields and automatic calculations OR
  • Ability to create custom spreadsheet (they would be required to identify the total, etc.)
• Financial Report maker
  • Take from the ledger information about expenses and revenue and create a detailed report about
• Backup
  • is Tiger* prepared for Kaboom?
• Ledger
  • multiple spreadsheets/ledgers available
  • update current account total and current float
  • update and view of budget line for expenses and revenue (drop-down menu in ledger to select which kind of expense or which )
  • Balance Viewer (expenses and revenue thus far, should be equal to current account and float)
  • Description = Expense Type (this should be a limited, but updateable set), Payee (same deal), other details
• (Semi-Automatic) Reconciliation Form
  • A form that takes the date range of the bank statement and an entry for each statement field which then automatically creates a reconciliation field based on the ledger and bank statements thus far
  • Use the date initially provided to send treasurer a reminded to do the reconciliation
  • Automatically fill in the date range on newly created forms
• Search Function:
  • Date, Payee, Expense type, other details, amount (range), etc.
• DSU Compliance enforcer
  • Reconciliations done reasonably on time (reminders)
  • If lots of entries are done at one time, provide them a reminder (once, per treasurer) that they should be doing their paper ledger records immediately after the transaction
  • A reminder to submit all paper records (ledger, receipts, invoices, cheques, etc.)
• Print form in PDF

  • Need to design some sort of template for Info -> Pages

• Uploading minutes and highlighting sections of the meeting. OR maybe just a reminder to make sure each field is accounted for either via pre-approval or minutes, highlight by hand if needed
• Note Taker/Spreadsheet
• Sample Cheque Creator
  • for ledger entries which are cheques, pop-up a cheque (pretty!)

RoR Tutorial

• On "Test-driven" development
• Tentative Schedule: Tuesday, January 15, 2008 @ 5:30pm

Tasks

• Get SVN setup by someone on tech
• Setup trac, get accounts for each of us
• Take our current requirements and make trac tasks out of them
• Ask one of the previous Tiger people how it's setup on slammer (get us started and introduced to what is already there) (how is it integrated into the web server?)
• Create a design of the system
  • architecture design
  • database schema
• Everyone pick an initial task (EVERYONE)