How to make a personal money tracker in excel

how to make a personal money tracker in excel

Alternatively, if you prefer to write expenses down as they happen or want to carry a little booklet with you, then you can download and print our easy-to-use Monthly Expense Tracker PDF. Her biggest change has involved shifting her expenses from primarily debit to credit something Stash Wealth founder Priya Malani evangelizes. But something can be done. It will help you to keep your bank account in the black. Read More.

Using the Money Tracker on Your Phone

This wikiHow teaches you how to create a record of your expenses, income, and balance on a day-to-day basis using Microsoft Excel. There are personal budget templates that you can use to speed up the process, or you can create your own personal budget file from scratch. Open Excel. Search for a budget template. Select a template and click Choose. Fill out the template. Save the file with a new .

Each column is a month, each tab is a year.

how to make a personal money tracker in excel
As teenagers and young adults start getting jobs and checking accounts and borrowing from their parents constantly, they need a way to track and manage their money. I designed this spreadsheet to work in the mobile app versions of Microsoft Excel. There is no link to actual bank accounts, so you can track your money without the risk of having your phone linked to your bank accounts. You can save this file on your phone and edit it without an internet connection. You’ll need the free Microsoft Excel app if you want to use this on your phone.

Expense Calculator and Tracker — Personal Budgeting

Aa teenagers and young adults momey getting jobs and checking accounts and pefsonal from their parents constantly, they need a way to track and manage their money.

I designed this spreadsheet to work in the mobile app versions of Microsoft Excel. There is no link to actual bank accounts, so you can track your money ot the risk of having your phone linked to your bank accounts. You can save this file on your phone and edit it without an internet connection. You’ll need the free Microsoft Excel app mney you want to use this on your phone. Below is an example of what the spreadsheet looks like when editing it in the Excel app on a smart phone.

To make data entry as simple as possible, I added drop down lists in Excel that let you ib the current date and select from a list of common payees. These drop-down boxes can be customized via the Settings worksheet. License : Private Use not for distribution or resale. Version 2. Think of the allocation exccel as representing either real envelopes of cash or virtual envelopes within your checking account. This provides a great way to transition from just tracking your money to budgeting and planning.

You can edit the labels for the allocation columns. When you spend or receive money, enter the amount in the related column or split ot between columns. For example, if you spend money on food, enter the amount in the Food column. If you withdraw cash from your checking account, you can aa the cash to different columns make sure the sum in the Amount column represents the total withdrawn.

The Balances at the top represent the current Balance for each column. If you only want to use the spreadsheet like a checkbook or account register, you can still download the original version 1. It can be a little tricky to download the file to your phone. You could download to your PC and upload it to your Microsoft OneDrive account and access it that way.

Or, you can use your phone’s browser to download directly to your phone. Using the Safari App on fracker iPhone, when you download the file to your phone and see w open the spreadsheet in a new window, tap on the spreadsheet until you see a «More There may also be a «Copy to Excel» icon that will open the spreadsheet in Excel. You can then choose to save it directly to your iPhone or to your OneDrive account if you have that set up. When teaching tk finance principles, a good place to start with younger kids is the Money Manager for Kids worksheet.

But teenagers need to start managing their own cash and checking accounts instead of just keeping track of the money their parents are holding for. I intentionally kept this spreadsheet as simple as possible. So, it might not use all the same terminology you would find in a commercial application like Quicken, and it definitely won’t have all the advanced features. The spreadsheet is meant to help you The CASH worksheet helps you keep track of what you have in your wallet.

The new version of the money tracker lets you allocate your cash for specific purposes, just like you might do using actual envelopes. The Envelope method of budgeting involves placing cash inside actual envelopes labeled yracker specific purposes like Food, Fuel or Funand only using the cash for that purpose. This spreadsheet lets you simulate that approach not just with cash, but also with your checking and savings accounts. The image above shows a few sample transactions, including how to enter trac,er beginning cash balances, how to record a food purchase, and how to move reallocate money from one category to.

Occasionally, you should count your cash and verify if the totals match your spreadsheet. If the totals do not match, then you may have spent some cash without tracking it. Enter an Adjustment to Cash or Correction to personzl the balance, then try personzl do better at tracking your spending in the future. Tip tracke When possible, get and save receipts. You aren’t going to remember to record every cash purchase you make, or you might not have your phone on you, or you won’t have the time to update your spreadsheet on the spot.

Saving your receipts will allow you to update your spreadsheet later when you have more time. Plus, you’ll need receipts to make returns and you need to get in the habit of savings receipts for tax records. When using a checking account, you don’t want to incur the fees and embarrassment and tarnished reputation that comes from writing bad checks writing checks for more than the amount in your account.

That means you need to keep track of your account balance. When you write a physical check or make a deposit, your bank is going to be tracking everything for you. Most banks that I know of scan the cashed persnoal, so you can see the eprsonal check when you log into your account.

They may even include an image of the scanned checks on your monthly bank statement. You should keep a record of each check you write and every check you deposit using your physical checkbook register. It’s also a good habit to write the purpose of the check in the memo line on the check so that when you view the online image of a cashed check, you can remember what it was.

People often use debit cards more than writing checks, so you need to find a way trakcer keep track of the balance in your checking account besides your physical checkbook register because so many people don’t have their checkbook on hand when making purchases via a debit card.

If you have your card on you, you’ll likely have your phone on you, so use this spreadsheet or some other app to keep track of your account balance. Remember to keep receipts for everything, not just cash purchases. So even if you don’t have a credit gow, you may still need to keep track ppersonal money that you owe. Negative Balance : With a how to make a personal money tracker in excel account, your Account Balance will usually be negative meaning that you owe money.

Showing parentheses around a number like When you receive income from babysitting, gifts, work. Some people set up automatic payments to come out of their pay mney to pay to specific charitable organizations, but you’ll need a way to keep track of other types of income as.

Whether you use a cash envelope or jar or an actual bank account for your savings, you will want to know how much you have saved. Especially if you are trying to save for something specific, you’ll need a way to track your progress. You can hide escel column if you tarcker want to use it. The purpose of this column is to provide a way for you to hracker off each transaction that you have verified with your bank account or verified with a receipt There is also a «c» and «R» option in this column’s drop-down list in case you want to use it for marking a «cleared» or «Reconciled» transaction.

You can edit what shows maie in these drop-down lists in the Settings worksheet. Cash Flow money going out and coming in is an important concept to learn, especially when you start having to pay bills and have other obligations. Predicting your cash flow by estimating future income and creating a spending plan is the next step after Tracking your money.

You can call it «planning» or «budgeting» — it’s pretty much the same thing. You can use a monthly cash flow or personal budget spreadsheet to help you create a plan. When you are ready to combine your budget with your money tracking, check out the Money Management Template.

Money Tracker 2. Money Manager for Kids. Money Management Template. Checkbook Register. Income and Expense Worksheet. Sponsored Listings.


How to make a simple, realtime (ish) budget in Google Sheets that keeps running totals

More from Work & Money

Enjoyed this article? With this beautiful travel budget worksheet, it is easy. Life can be unpredictable, so if your circumstances do change, go back to tracking for another few weeks to get your spending in line with your new level of expenses or income. When you think about tracking your expensesit’s normal to feel more than a little overwhelmed, especially if you’ve been avoiding it for a while, or you’ve never done it. For those who want to track expenses against a budget, the Money Management Template is an excellent Excel or Calc spreadsheet that does not require the use of macros. This spreadsheet allows you to set a total budget, allocate it on a person-by-person basis, and use how to make a personal money tracker in excel as a guide to for your gift-buying strategy. This is not a plug or sponsored post — after reading enough personal finance bloggers sing Ally’s praises, I decided to give it a shot, and it’s working out so far. Especially if you are trying to save for something specific, you’ll need a way to track your progress. The spreadsheet is meant to help you By visualizing your goals and charting your progress towards. Financial Software Software Tutorials. About three minutes every morning. I’m using «income» here in the very literal sense of the word: money coming in. So I made my. Health Care: medical premiums, life insurance, medication, eye care, dental, supplements, wellness costs. That means I’ve spent more than I’ve earned — although in this case, that negative balance is thanks to the fixed costs I’ve projected out in advance. But the point isn’t to stress yourself out — and in fact, it’s the opposite.

Comments

Post a Comment