Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This involves the management of a project's finances- including project budgets and allocations from different funding sources as well as incoming and/or outgoing payments (disbursements).

Financial Management Data Model

...

*Financial object also related to ampi__Activity__c, and sometimes relates to other objects

...

page covers:

Table of Contents
minLevel1
maxLevel3
stylecircle

Related pages:

...

Financial Management: Overview

The Financial Management suite in Amp Impact includes four different features that support typical financial management processes in social impact organizations. This includes:

  • Budgets & Financials: The ability to track budgets and financial line items (or budget line items) to report on planned and actual expenditure.

  • Disbursements: The ability to schedule and track payments (or installments) to be made or received

  • Funds: The ability to manage pools of money (Funds) and allocate (or ringfence) funding to specific projects or grants.

  • Allocations: The ability to allocate funding from an Account, Fund, or Opportunity to a particular area.

Financial Management: Data Model

Below is the Financial Management functional area data model subset:

...

Financial Management: Summary of Key Relationships

There are five key relationships that are foundational to the overall use of Amp Impact:

  • Fund: This relationship enables organizations to manage the pools of money that can be allocated to projects/grants.

  • Budget: This relationship enables organizations to plan expenditure expenditures across categories, periods, activities or other segments.

  • Financial: This relationship enables organizations to analyze budget and expenditure lines.

  • Disbursement: This relationship enables organizations to schedule payments that are to be made or received.

  • Allocation: This relationship enables organizations to allocate funding to a Project from an Account, Fund or Opportunities.

Amp Object Label

Amp Object API name

Abbreviation

Object Description

Sample Use

Also Sometimes Called

Key relationships (Amp object's relationship in parentheses)

Sometimes connects to

Fund

ampi_xx_Fund__c

 None

Funds are pools of money that an

organisation

organization can define based on programmatic interests, donor interests, funding sources, etc. The object facilitates tracking available funds for grants, allocating money from funds to different grants or projects, and monitoring disbursements drawing from those funds.

An

organsiation

organization may define a "2022 WASH Initiatives" fund and track the aggregate amounts applied for, allocated, committed, and paid to grants/projects on Fund record. They can also monitor funds remaining in the fund.

Funding Source

Allocations (M2M between Fund and Project)
Disbursement (lookup to Fund)

Opportunity
Account
Grant

Budget

ampi__Budget__c

 None

The Budget object holds planned and actual expenditure (and/or revenue) by grouping together Financial records (aka Budget Lines). Users can see the total planned and actual amounts on the Budget record as well as the related Financials. A Grant/Project/

Programme

Program can have multiple Budgets, for instance one per partner, one per geography, or one per period.

The Education For All project has one Budget record that contains all the project's planned Budget Lines and actual expenditure. Before the project started, the budget was approved by the Country Director and Finance Director.

Forecast

Project (Budget is child on Master-Detail)
Financials (Budget is parent on Master-Detail)

Account
Fund

Financial

ampi__Financial__c

 None

Financials serve as Budget Lines and Expenditure Lines. Financials can be high-level (eg $300k on Salaries in Q1) or very detailed (eg $5k on Martha's January). The Financial object is child to the Budget object and the Reporting Period Object (both are required) and has an optional lookup to Activity for organization's looking to do Activity-based budgeting.

The Education For All project's budget has 10 Budget Lines stored on the Financial object. Each is categorized (eg Personnel) and sub-categorized (eg Benefits). Expenditure records are loaded into the Financial object monthly from the Accounting system, so that program staff can see Budget vs Actual for their projects.

Budget Line, Forecast Line

Budget (Financial is child on Master-Detail)
Reporting Period (Financial is child on Master-Detail)
Activity (Financial has a lookup to Activity)

Framework Objective (for "Result-based budgeting")
Allocation (for tracking which project funds will be or have been spent on what)
Assignment (for tracking detailed personnel costs)

Disbursement

ampi__Disbursement__c

 None

Disbursements are payments that have been made or scheduled to be made. Disbursements can either be inbound (i.e. received) or outbound (i.e. sent). Disbursements are sometimes tied to Grant or Progress Reports and could be connected to specific milestones if needed. They will sometimes undergo an approval process and often be used in integrations with ERP systems (eg schedule and approve Disbursements in Amp, make payment via ERP and have that data flow back to Amp).

The Education For All project has four scheduled Disbursements, including an initial payment of $50,000 and three subsequent payments tied to completion and approval of quarterly progress reports.

Payment, Tranche

Project (Disbursement is child on Master-Detail)
Reporting Period (lookup)
Fund (lookup)

Activity
Allocation

Allocation

ampi__Allocation__c

 None

The Allocation object can be used to record commitments of monetary resources to a project from different Accounts/Organizations, Funds, or Opportunities. A Project can have one or more Allocations. A Project with only one funder, might have just one Allocation, whereas a Project funded by multiple sources would have many.

The Education For All project has three funders; Org A, Org B, and Org C. Org A has committed $100k; Org B and Org C have each committed $50k. Additionally, the org itself has committed $50k of unrestricted funding to the project from the Unrestricted Fund record. Each of these Commitments is stored on the Allocation object.

Commitments

Project (Allocation is child in lookup)
Account (Allocation is child in lookup)
Fund (Allocation is child in lookup)

Opportunity
Project (second lookup if doing Allocations to and from Projects)
Geographic Area
Thematic Area

...