Category
Finances
Last edited by
aloceros
Last edited time
Nov 25, 2022 6:51 PM
The BF Finances spreadsheet tracks Beanstalk Farms and Bean Sprout expenses. It is used to record all transactions made by the BFM and BSM, record payments made on behalf of Beanstalk Farms by contributors, track reimbursements and community grants, and prepare the monthly operations report.
Access is BF General:
Viewable by all of Beanstalk Farms. Editable by BFC members and Operations. Please contact an editor if you need to make changes.
Instructions by Tab:
BFM Transactions - a summary of BFM transactions and finances.
- List every transaction made by the BFM in chronological order.
- Each month, open a “Period” in column A by rolling forward the balances in columns D-F from the previous period.
- Record each transaction in a row.
- “Category” matches the categorizations in the monthly operations report.
- Transactions representing fund transfers (not expenses) are shaded yellow.
- Use the “Reimburse” and “Paid” columns to track pending reimbursements or payments. For detail on accounting for reimbursements, see below.
- At the end of each month, close the period by summing the opening balances and the transactions. Verify the ending balances match the BFM’s on-chain balances.
BFM Comparative - aggregates expenses by category and payroll expenses by BFC member for analysis.
- Sum category totals from column H of the “BFM Transactions” tab.
- Source the payroll breakdown from the “Silo Calculator” tab of the payroll spreadsheet. See .Using the BF Payroll Spreadsheet
BSM Transactions - a summary of BSM transactions and finances.
- Uses the same format as BFM Transactions.
Grants - records community and development grants.
- These tabs are used to record grants.
- In the “Batch” column, enter the same batch number for all grants to be paid as one BFM transaction.
- When the grants are paid, mark paid in column E, batch the grants, and record the transaction on the “BFM Transactions” tab. Enter the batch number under “Notes”.
Reimbursements - records expenses to be reimbursed by BF.
- Currently, this tab is used only by a couple contributors. Anyone else should notify Operations prior to incurring reimbursable expenses.
- Contributors paying for reimbursable expenses should submit reimbursement requests in columns D-I.
- In the “Batch” column, enter the same batch number for all expenses to be reimbursed as one BFM transaction.
- In the “Paid By” column, enter the person to be reimbursed.
- In the “Reviewed By” column, enter the Operations reviewer.
- Sum the amount “Owed” for each batch and create a pending transaction on the “BFM Transactions” tab. Enter the batch number under “Notes”. Use the “Reimburse” and “Paid” columns to track the status of reimbursements.