Since the balance for the second entry onwards will record the current balance, you need to add the resulting difference between expenses and income to the balance in the previous entry. Thus, the spreadsheet will display positive cash flow if the cash on hand is more than an expense, and negative if the expense is greater than income.Įnter a second cost entry in cell line 4.Įnter the balance formula in cell G4. If you want the custom spreadsheet to display the money you have, the balance formula is = F3-E3.That way, if your expenses are greater than your income, your total expenses will have a positive number, making it easier for you to understand. If you want a special spreadsheet to display expenses, your balance formula is = E3-F3, that is, E3 is the cell containing the expense balance, and F3 is the income balance cell.
#Track expenses in excel how to#
How to set it up depends on your desire to see the budget in terms of expenses or cash owned. The balance will be determined by the difference between income and expenses as this is the first balance entry. The Freeze Panes option is in the menu" View"for Excel 2003 and below, and in groups" Window '"on the menu ribbon"View "for Excel 20.Įnter the balance formula in cell G3. After setting the column headings and headers, use the " Freeze Panes"so that the column heads are at the top when you scroll the page down.Enter these headings in cells A2 through G2, and adjust the column widths so that all the writing is visible. Here are some names and the order you can use, "Date", "Paid To", "Memo", "Expense", "Income" (or "Income", or "Deposit") and "Balance". Here, quotation marks are used to denote examples).Įnter column headings in Row 2. (Don't use quotation marks when writing names. Use a clear name, for example "Personal Budget", "Personal Expense Monitoring", or something similar. Method 2 of 2: Creating Your Own Paper To Track ExpendituresĮnter a name for the spreadsheet in cell A1. Or, you can simply write down the name and year of the working paper.
You can use the working paper name provided template or enter the name as desired. The information entered depends on template working paper used.
Enter the information into the appropriate cells.
0 kommentar(er)
