Accounting data describes the money that we know we have spent or that we highly expect to receive.
Accounting transactions airtable#
CS&S provides us a monthly dataset of the last 6 months of all of all our accounting transactions.
This is in a Google Sheet that is automatically updated each day.
It includes the last 6 months of any transaction 2i2c has made (if we need more than 6 months of history, ask
email@example.com for a custom data dump).
Update our accounting data airtable#
We have a semi-automated process to update the data in our accounting table. Here are the steps to follow:
Confirm that the Google Sheet has been updated by checking the
Automatic Operations Events Logtab.
Delete all of the records in the accounting table.
Import the google sheets data. Go to
Google sheets account.
Here’s an image of the menu you want:
You’ll see a list of Google Sheets in our account. Import the one titled
2i2c FYE23 Account Transactions - Auto Generated.
Skip first rowoption during the import, so that we don’t import the section title names.
This should automatically import the data into the proper columns, you don’t need to do anything else.
When this action happens, an AirTable automation will run and attempt to link each new record with a corresponding Contract, using the
Xero ID field.
If a contract with the record’s
Xero ID is found, then a linked record will be created in the
Here’s a brief video describing the above process.
CS&S generates monthly reports for our current financial situation. You can find them in our financial reports folder.
Below are some Frequently Asked Questions along with a more detailed description of these reports.
How much Net Income does 2i2c have?#
Net Income is a combination of the following things:
Our Cash on Hand.
Income for which CS&S has
Costs for which CS&S has received an invoice but not yet paid.
To find this number, follow these steps:
Scroll to the bottom of the
Use the number in the
This will be at least one month out of date
CS&S prepares our monthly reports using last-month’s data.
This means that the definition of
Net Income is true as of the end of the window used in that report.
This is usually about a month in the past.
accounting:remaining-in-contracts for how to correct for this gap.
Detailed monthly reports description#
See Overview of CS&S accounting reports for more information about these sheets.
CS&S accounting contact#
Code for Science and Society has an accounting team that puts together our monthly reports, helps us define annual budgets, and can provide us guidance on accounting questions.
We also have a dedicated project accountant named Josmil Reyes that focuses his time on 2i2c.
If you have any questions for CS&S regarding accounting, send an e-mail to
firstname.lastname@example.org and it will be routed to Josmil.
We also have a page in our KPIs website that provides public summaries of this information for transparency to external stakeholders.