How to Create your spreadsheet
1 Install the app
Open the Mac App Store then type ‘Numbers’ in the search bar in the topright corner. Press enter to search, then click on the app itself. Select Get, then Install App. Enter your Apple ID password to download and install.
2 Open Numbers
If this is your first time using Numbers, click the Open button in the App Store then choose Continue then ‘Create a spreadsheet’. Otherwise, launch it from your Applications folder and click New Document.
3 Select template
Select Personal Finance on the left, then click on Simple Budget > Choose. Before continuing click File > Save. Give your sheet a memorable name, then choose Numbers – iCloud from the Where drop-down menu below.
4 Change the currency
Highlight any cells containing dollar amounts (use to select multiple cells at any one time). In the top right sidebar, click the Cell tab, then use the Currency dropdown menu to choose the right one. There are loads of options.
5 Manage income
Enter your paycheck/salary amount under Money In. Then click any cell and choose Add Row Below to enter additional sources of income, for example, shares. The combined amount is displayed in Total Income.
6 Manage expenses
Amend the values in the Money Out table to reflect your regular monthly expenses. Feel free to add rows here as you did in the Money In section. These are added up and clearly displayed by Total Expenses.
7 Conditional highlighting
Now let’s get a little more adventurous. Click the cell containing Income Minus Expenses, then click Cell on the sidebar on the right. Click the Conditional Highlighting button then Add a Rule > Greater Than.
8 Apply rules
Now, in the field below ‘greater than’, enter 0. Click Add a Rule and choose the ‘less than’ option. Type 0 again. Click Done. The cell will now appear green for positive values and red for negative. You’ll know which is better!
9 Duplicate spreadsheet
click on the Budget tab at the top of the main interface and choose the Duplicate feature. click the new tab and choose to Rename – for example, ‘Budget-Sep 2017’. Enter your income/ expenses for this period.