Spreadsheets for Budget and Accounting in GeoGebra
Now let’s look at how to use Spreadsheet in GeoGebra to create and your budget and accounting. To be fair, sometimes it might be more convenient to use Excel , but GeoGebra is suitable for the task, too.
Example 1
Erica Clementine is making an overview of all income and expenses she expects in a certain month. Her budget is shown below.
| Income | Amount | Expenses | Amount |
| Bookstore (part-time) | $ | Bus card | $ |
| Walking dogs | $ | Phone subscription | $ |
| Pocket money | $ | Food and snacks | $ |
|
|
| Clothes and shoes | $ |
|
|
| Entertainment | $ |
|
|
| Other | $ |
Towards the end of the month, Erica did her accounting and entered the actual income and expenses during the month. She has the following accounting figures:
| Income | Amount | Expenses | Amount |
| Bookstore (part-time) | $ | Bus card | $ |
| Dog sitting | $ | Phone subscription | $ |
| Monthly allowance | $ | Food and snacks | $ |
|
|
| Clothes and shoes | $ |
|
|
| Entertainment | $ |
|
|
| Other | $ |
In addition, Erica already had $ in her bank account at the start of the month.
She compares her budget and accounting in GeoGebra. The final result looks like this:
Follow the instructions below to learn how you can make your own budget and accounting, just like Erica’s above. Here is the template she used:
Note! When you enter your own income and expenses, you’ll get a spreadsheet that looks a bit different than the one in the template, unless you have the exact same income and expenses as Erica. But if you follow the instructions below, you’ll always get a spreadsheet that works correctly.
GeoGebra Instruction 1
Income
- 1.
- Open
Spreadsheetin
Menu. - 2.
- In column
A, enter the entries for the income in your budget. - 3.
- You start by entering “Income” as the column header. Below will be all the names of the various incomes. When all the entries for income have been listed under the header, finish by typing “Total Income” on the line below.
- 4.
- In column
B, type “Budget” as the header (preferably on a line higher than where you typed “Income”). - 5.
- Fill in the budget figures from the exercise so that they match the entries for income.
- 6.
- In column
C, type “Accounting” as the header, so that it has the same row number as “Budget”. - 7.
- Fill in the accounting figures from the exercise so that they match the income names.
- 8.
- In column
D, type “Deviation in $” as the heading, so that it has the same row number as “Budget”. - 9.
- In column
E, type “Deviation in %” as the heading, on the same row number as “Budget”. - 10.
- You will find “Total Income” by selecting all the cells with “Income” entries, and then using the command
Sum
. You must do this column by column for “Budget”, “Accounting” and “Deviation in $”.
Look at Example 1 and the pictures below when working with the instructions. There you find one picture with the numbers and one picture with the formulas.
GeoGebra Instruction 2
Expenses
- 1.
- In column
A, enter the names of all the expenses you have in your budget. - 2.
- Start by entering “Expenses” as the heading, and then list all the names of the various expenses below. When all the entries for expense are entered, finish by typing “Total Expenses” in the line below.
- 3.
- In column
B, enter the budget figures from the exercise so that they match the names of the expenses. - 4.
- In column
C, enter the accounting figures from the exercise so that they match the names of the expenses. - 5.
- You can find “Total Expenses” by selecting all the cells with the values of “Expenses”, which are below each other, and pressing
Sum. You must do this column by column for “Budget”, “Accounting” and “Deviation in $” in order to calculate all the totals.
GeoGebra Instruction 3
Deviations in $ and Deviations in %
- 1.
- You can find “Deviation in $” for “Income” by typing
=. Then tap the cell that contains the value of “Income”, which is under “Accounting”. Then press the minus sign, and then click on the cell that contains the value of “Income”, which is under “Budget”. PressEnter.= <the cell with the value of “Income” in “Accounting”> <the cell with the value of “Income” in “Budget”>
Enter - 2.
- You can find “Deviation in $” for “Expenses” by typing
=. Then press the cell that contains the value of “Expenses”, which is under “Budget”. Then press the minus sign, and then the cell that contains the value of “Expenses”, which is under “Accounting”. PressEnter.= <the cell with the value of “Expenses” in “Budget”> <the cell with the value of “Expenses” in “Accounting”>
Enter - 3.
- You find “Deviation in %” for “Income” and “Expenses” by typing
=. Then press the cell that contains the value of “Deviation in $”. Then press the division sign , and then the cell that contains the value of “Revenue” or “Expenses”, which is under “Budget”. Multiply this by 100 and pressEnter. You need to do this in turn for all the different entries for income and expenses.= <the cell with the value of “Deviation in $”> / <the cell with the value of “Income” (“Expenses”) in “Budget”> * 100
Enter
GeoGebra Instruction 4
Surplus and Deficit for Budget and Accounting
- 1.
- You’ll find “Surplus / Deficit” by clicking the cell on the right and typing
=and clicking the cell containing the value of “Total Income”, then the minus sign. Then press the cell that contains the value of “Total Expenses”. PressEnter. - 2.
- You need to do this column by column for “Budget” and “Accounting”.
Note! Positive numbers mean surplus and negative numbers mean deficit.
GeoGebra Instruction 5
Surplus and Deficit for Deviations in $
You will find “Surplus / Deficit” by clicking on the cell on the right and typing =, then clicking on the cell that contains the value of “Total Income”. Then press the plus sign, and click on the value of Total Expenses. Press Enter.
Surplus and Deficit for Deviations in %
You can find “Deviation in %” by typing =, and clicking on the cell that contains the value of “Surplus / Deficit”, which is below “Deviation in $”. Then, press the division sign and click on the cell that contains the value of “Surplus / Deficit”, which is under “Budget”. Press Enter.
GeoGebra Instruction 6
Money at the Beginning and End of the Month
- 1.
- In column
A, below your setup, type “Money at the Beginning of the Month” and “Money at the End of the Month”. - 2.
- “Money at the Beginning of the Month” is usually given in the accounting exercise. Enter this directly into column
B. - 3.
- You find “Money at the End of the Month” “Money at the Beginning of the Month” “Surplus / Deficit”, both of which are under “Accounting”. This is done by typing
=and clicking on the cell that contains the value of “Money at the Beginning of the Month”, then pressing the plus sign, and then clicking on the cell that contains “Surplus / Deficit”, which is under “Accounting”. PressEnter. Explicitly,= <the cell with the value of “Money at the Beginning of the Month”>
<the cell with the value of “Surplus / Deficit” in “Accounting”>
Enter
To get a better overview of the actual deviation between the budget and the accounting, you should find the deviation both in dollars, and in percent.
