1 of 26

Budget and financial management. The story behind the numbers

(demonstration on a living organism… not presentation)

By Grzegorz Kopaczewski

Wikimedia Poland

2 of 26

Numbers are real, objective, eternal and unchanging entities.

This is confirmed by Plato and the lady from the tax office

3 of 26

Numbers are universal language, the combination of numbers makes a story

1. Exposition - the protagonist’s past and current state

2. Rising action - protagonist finds the goal or gets into troubles

3. More action - protagonist gathers the resources

4. Much more action - protagonist plans the action

5. Rising action - protagonist is on a way to achieve the goal

6. Trouble - conflicts are growing, resources are shrinking

7. Climax - protagonist success or fails

8. Resolution

4 of 26

1. Exposition - the protagonist’s past and current state

What went wrong and what went well in the past. How we were doing in 2023

5 of 26

1. Exposition - the protagonist’s past and current state

What went wrong and what went well in the past. How we’re doing…

6 of 26

2. Rising action - protagonist finds the goal or gets into troubles

Winter

is

coming

7 of 26

3. More action - protagonist gathers the resources

Revenue plan 2024

8 of 26

4. Much more action - protagonist plans the action

Budget 2024

9 of 26

5. Rising action - protagonist is on a way to achieve the goal

At the beginning everything

is

OK

10 of 26

Ad. 5. Let’s go into real numbers (almost Platonic sense)

=SUMA.JEŻELI(Rozliczenia!D:D;A3;Rozliczenia!F:F)+SUMA.JEŻELI(ZUSPIT!D:D;A3;ZUSPIT!F:F)

11 of 26

6. Trouble - conflicts are growing, resources are shrinking

Circumstances change,

we need to adjust

12 of 26

Ad. 6. We have spent too much!

13 of 26

7. Climax - protagonist success or fails

The truth is revealed

14 of 26

8. Resolution - protagonist realizes that he succeeded thanks to companions he works with

The team

15 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

16 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

17 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

18 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts (not too general, not too detailed)

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

19 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

20 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

21 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

22 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

23 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

24 of 26

TIPS

  • base your plan on the past ones (you won’t miss a cost)

  • start planning with revenue

  • fixed costs go first (salaries, rents, taxes…)

  • divide the budged into categories, groups, iron and reserve parts

  • update the spendings and revenues regularly, observe

  • don’t forget about additional costs (taxes, mostly…)

  • don’t be afraid of spreadsheets, use your imagination

  • be transparent (internally and outside)

  • be flexible and don’t panic!

  • trust co-workers

25 of 26

Thanks!

26 of 26

Photos

1.By © Marie-Lan Nguyen / Wikimedia Commons, Public Domain, https://commons.wikimedia.org/w/index.php?curid=7831217 CC-BY-2.5

2.Public domian: gov.pl: https://www.podlaskie.kas.gov.pl/urzad-skarbowy-w-augustowie/wiadomosci/aktualnosci/-/asset_publisher/I9Ki/content/dyzury-podatkowe-w-urzedzie-skarbowym-w-augustowie?redirect=https%3A%2F%2Fwww.podlaskie.kas.gov.pl%2Furzad-skarbowy-w-augustowie%3Fp_p_id%3D101_INSTANCE_Py89%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3D_118_INSTANCE_tv0J__column-1%26p_p_col_count%3D1

3. HikaruAmano https://commons.wikimedia.org/wiki/File:Winter_Is_Coming_(57167544).jpeg CC-BY-3.0

4. hedera.baltica https://commons.wikimedia.org/wiki/File:Winter_is_coming_(23276249716).jpg CC-BY-SA-2.0

5. Frank Kovalchek https://commons.wikimedia.org/wiki/File:Guess_who_is_coming_to_dinner%3F_(8351809331).jpg CC-BY-2.0

6. Jacek Durski.