Financial Management - perreaultcourtney/NBIFsummer_projects GitHub Wiki

Financial Management Tab

Made up of three sections:

1. Program Budgets: Specifies the amount of funding assigned to each program.

Fields

  • Program
  • Accessible Funds (source of money)
  • # of Awards Made
  • Program Budget
  • Paid
  • Allocated
  • % Utilization
  • Current Balance (remaining to be allocated)

Features

  • Deposit
  • Withdraw
  • Transfer

2. Funds: The pots of money individual programs draw from.

Fields

  • ID
  • Fund name
  • Authorized Programs (which programs can access these funds)
  • Fund Total ($$)
  • Available to programs
  • Paid
  • Allocated
  • % Utilization
  • Current balance

Features

  • Deposit
  • Withdraw
  • Transfer
  • Archive
  • Move to Folder
  • Move to Trash

3. Transactions: Records of any movement of money.

Fields

  • ID
  • Transaction Date
  • Payment Date
  • Description
  • Source (Program/Fund)
  • Administrator
  • Notes
  • Deposit ($$)
  • Withdrawal ($$)
  • Balance ($$)

Features

  • Notes

Program View

  1. Select Program
  2. Select Program Budget

Features:

  • Transactions
  • Summary (Total - Paid - Allocated - Balance)

Application View

Decision

  • Award or Decline
  • Amount
  • Payment Date (can assign total amount to separate payments)
  • Status
  • Allocated (Approved - Pending - On Hold)
  • Payment (Paid)
  • Cancelled (Refunded)

Decision Details

  • Decision
  • Value
  • Funding Sources (In terms of Program)
  • Date (with time)
  • Table with the following fields
  • Payment #
  • Date
  • Amount
  • Payment Status (checked)

Notes

Paid

  • currently only use allocation.

Export Feature

  • allows to create an excel file with transactions
  • could use filter to only export necessary ones (or just to organize them in separate files).

Automation for Payment Status set to paid.