Blivande: Open Finance 2.0

Monthly report & update

Income projections

Expense projections

Result projections

Monthly report & update

Hugi Asgeirsson

Last edited 229 days ago by Diana Monsberger

Create a new report around the 15th of every month. (Expand for instructions)

Click

New monthly report

⁠

Check the bank balance on the 15th or the closest date available.

How to check the bank balance at a historical date.

Log on to Swedbank, check go the account transaction history. Find a transaction as close to the 15th as possible and look in the column "Bokfört saldo". Enter that number in the report.

Go through every step in the report. There are buttons in the report card that take your to the relevant pages. Check in with

Area leads⁠

to review the numbers. Check the boxes when you are done with each step.

After making updates, check the

Liquidity projection chart⁠

. If the liquidity looks like it will fall below 100.000 at some point, bring it up with the team.

Write a very short report. A few sentences are enough. A report could be:

‘Co-created Gardens’ project needed to use more of its budget earlier than expected, so more money was spent this month than was planned. Event income is adjusted to 50,000 in March because of low demand, but we will run our own parties in April to meet the 75,000 target. This loss of expected income not affect our liquidity enough to worry at this point. We may dip below 150.000 kr in the bank in June.

Use the slider to indicate approximately how much time you spent on the report. We do not want to waste time on reporting, and hopefully these steps should not take more one day per month, though it might take longer while learning the steps. Track your time spent on reporting so that we can change our way of working if it is taking too long!

Now the monthly report card should have turned green and you are done. Good job! You will present the report to the team on the monthly finance and strategy meeting. If we need to take action, we decide together what to do.

Why report around the 15th of each month?

Because much of our income and expenses are charged at the start or end of the month. Rent is paid at the end of the month, salaries are paid at the end of the month and memberships are usually charged at the start of the month. By reporting on the 15th we are more likely to get consistency.

⁠

New monthly report

⁠

Monthly report

Monthly report

Date of update

1/30/2023

Person

Hugi Asgeirsson

Bank balance on the 15th

kr1,462,776

3/15/2023

Person

Diana Monsberger

Bank balance on the 15th

kr811,877

4/17/2023

Person

Diana Monsberger

Bank balance on the 15th

kr579,334

5/15/2023

Person

Diana Monsberger

Bank balance on the 15th

kr418,871

6/18/2023

Person

Diana Monsberger

Bank balance on the 15th

kr650,300

7/26/2023

Person

Diana Monsberger

Bank balance on the 15th

kr348,530

9/19/2023

Person

Diana Monsberger

Bank balance on the 15th

kr240,000

10/18/2023

Person

Diana Monsberger

Bank balance on the 15th

kr165,000

11/21/2023

Person

Diana Monsberger

Bank balance on the 15th

kr86,600

12/20/2023

Person

Diana Monsberger

Bank balance on the 15th

kr1,143,000

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.