IN THIS TUTORIAL, we’ll show you how to use one of Numbers’ standard templates to make your own personal budget.
The template has two tabs: Budget and Transactions. The Transactions tab houses all the details of money spent during the period covered by the budget. These are allocated into categories. In the Budget tab, a table uses functions and formulas to add up the values of all the transactions in a given category and put them in a cell in the Actual column. For example, the Actual column in the Entertainment row looks for all the cells in the Transactions table where the category matches “Entertainment” and sums the value of the transactions.