Finance and accounting
Finance and accounting#
Main documentation for 2i2c’s financial and accounting information.
A note on access
All 2i2c-specific accounting documents should be accessible on our Team Drive to anybody with a
We don’t control the access conditions for the CS&S documents described below, so if you don’t have access to these, ask the Executive Director.
We split our financial and accounting data between two places:
2i2c Drive Folder with our finance assets contains 2i2c-specific budgeting and modeling information. It is available to all team members.
CS&S Drive Folder with their finance assets contains assets that are stewarded by CS&S. It is available to 2i2c’c executive director.
Active grants and contracts#
We have a list of active contracts (hub services and development) at the following Google Sheet:
We have a list of active grants and links to important documentation for each at the following Google sheet:
CS&S keeps all of the contracts for our active grants in the following folder:
We have a Google Sheet that can be used to create rough budget projections given some input data about our income and expenses. The first tab explains how to use and interpret the sheet.
We get monthly accounting reports from our fiscal sponsor, CS&S. These are placed in a shared Google Drive that CS&S controls.
For those with access, you can find the accounting statement folder here:
Understanding accounting statements#
This is a quick guide to understanding the CS&S accounting statements as explained by their team.
The accounting statements represent realized income and expenses. This means that they represent things that have actually happened, not things that might happen in the future (even if they are written into a contract).
There are two relevant tabs to the accounting statements:
An append-only list of every transaction that has been linked to 2i2c. There are a few relevant columns:
A free-form description of the transaction. Sometimes this contains information about who paid us, or which contract it was linked to. We can use this to infer important metadata about a transaction.
A unique reference number for the transaction. It will begin with
INV-in the case of invoices for services rendered. This can be useful to cross-reference other transactions that might be linked to that invoice (usually, in the
- Debit / Credit
These are Costs like salaries and reimbursement, as well as Revenue like grant income and service invoices.
The type of transaction that occurred. This lets us categorize how we are spending and receiving money. E.g., did we pay for consulting services, did we pay for an online service, did we receive money for contracting, etc.
All of our income/expenses are tied to a particular grant, which is encoded here. We have a grant option for every active grant (e.g. the Columbia University Pangeo grant).
There is a special persistent category called
2i2c: General. This is a general fund where our contract revenue is placed and spent from. It is essentially “disposable income” with no strings attached.
The income statement is a summary of our financial situation at a moment in time. It represents realized funds, meaning that future transactions are not represented here. This means that some grant columns will have more realized income than is represented here (for example, when we expect another influx of cash on a multi-year grant).
There are three kinds of columns:
- Grant columns
There’s one column for each active grant, that describes the current financial situation on that grant.
There’s a column for 2i2c’s persistent general fund (
The final column has the sum totals across all of the other columns. It is the highest-level summary of our financial situation that we’ve got.
Common questions and how to answer them#
Here are some common questions and how to answer them with the information above.
How much cash on-hand does 2i2c have?#
Look to the bottom-right cell of the Income Statement.
This is the
Net Incomeacross all of 2i2c’s history with CS&S. This number is the amount of disposable cash on hand.
How much remaining funds should we expect in a grant?#
Find the column for that grant in the latest Income Statement.
Gross Profitrow for that grant.
Compare this with the total budget that we submitted for the grant (including our FSP fee).
The difference between the two is the amount we expect to receive in the future.
What is our burn rate?#
Go to our budget projections sheet.
Look at the
This shows our burn rate, along with 9 and 24 month cutoffs.