Financial Tracker Template

Financial Tracker Template

Download the template and rename it accordingly or make a copy and rename it. DO NOT try and edit the template copy.

The video tutorial below gives a visual walkthrough and directions to the usage of the financial template provided. It is a good resource to understand the correct input of data, and how to best utilize the spreadsheet. The written steps below correspond to the steps and directions given in the video.

How to Setup and Use the Financial Tracker Template

1. Set up the Accounts Tab
   1. Input all active and inactive accounts associated with your organization. Do not delete an account if it changes status and becomes inactive in the future or is currently inactive, check the inactive box on the far left of the spreadsheet.
   2. Only fill out columns A - D, Column E (Current Balance) will automatically be updated when the ledgers and expenses are updated on other tabs.

2. Set up Clients
   1. Click on the clients' tabs and fill out the name, the project associated with the client, and the forecasted income you expect to receive per month. This is the amount you expect to receive per month, not what you have actually received to date.
   2. The transfer line is for incoming and outgoing transfers between your various accounts, this ensures your balances remain accurate. Transfers are not from a client but between your accounts listed on the previous accounts tab.
   3. If a client is inactive, or the project is finished do not delete them click the “inactive” box on the far left. If you delete the client it will remove all of their transaction history and thus income associated with them.

3. Set up Expenses
   1. List every expense you have, the type of expense, and what account it is paid from. The accounts will automatically pull from your accounts tab and you can select the corresponding account from the dropdown menu.
   2. Similar to the clients tab there is a forecast section for the year and future years where you can record your expected expense per month for each line item.

4. Income Ledger
   1. Fill out the date of the transaction, a brief description, select the client from the drop-down or transfer, and what account the income went into.
   2. If it is a transfer you will fill out column E (it will be highlighted in yellow) Select the account it was transferred from.
   3. Check the box in Column G when the income has cleared

5. Expense Ledger
   1. Fill out the date, a brief description, select the expense from the drop-down (which will automatically populate and pull from the expense tab), the amount (a negative dollar amount), and from what account
   2. If it is a transfer you will fill out column F (it will be highlighted in yellow) Select the account it was transferred to
   3. Check the box in Column G when the expense has cleared

6. Snapshot - displays at a glance income, expenses, forecast, and the yearly total
   1. You can select the year and month from the drop-down menus to view each accordingly
   2. DO NOT edit the colored boxes. They are tied to formulas and pull data from other tabs. The ONLY edit or change you can make is the year or month from the dropdown menus at the top left.
   3. The left side shows the forecast, monthly, and yearly totals

7. Weekly
   1. A fully automated sheet breaks down the income and expenses for the week
   2. There are columns not only showing the income and expenses but outstanding incomes and expenses for each.
   3. Each week will automatically populate for each week based
   4. You can utilize the hyperlinks (2022, 20223, 2024, 2025) on the top right of the sheet to jump to the first week of each year

8. Year by Month
   1. Snapshot of the year - you can view the year by client, by expense, or the full year. Showcases cleared and outstanding amounts for income and expenses as well as year-to-date totals.
   2. DO NOT edit the colored boxes. They are tied to formulas and pull data from other tabs. The ONLY edits or changes you can make are the year drop-down or drop-down menus for client and expense.
   3. To view the year by client (in green) select the corresponding client from the drop-down menu and you will be able to view the income generated for the year from that client. This only applies to the top half - to clear it out and view the full year again delete the client name in the “view by client” box.
   4. To view the year by expense (in red) select the corresponding expense from the drop-down menu and you will be able to view the total expense for the year. This only applies to the bottom half - to clear it out and view the full year again delete the expense name in the “view by expense” box.

Click here to contact us, give feedback on this article, report errors, or address concerns regarding the portal resources.