Which Personal Cash Flow Template

This worksheet is for people who don't like the word upkeep but nevertheless want to get a grip on their finances. Bones personal finance is mostly about managing greenbacks flow which means tracking and planning how money is inbound and leaving your existent and virtual pockets. This worksheet tin can be used for tracking your spending as well equally creating a budget.

Printable Monthly Cash Menstruum Worksheet

(PDF)

Printable Blank Monthly Cash Flow Worksheet

This printable PDF is a two-page worksheet that you can complete by paw. It is free to print and tin exist useful as a class handout. To download a version that you can edit and customize, download the spreadsheet beneath.

Monthly Greenbacks Period

for Excel

Monthly Cash Flow

Download

⤓ Excel

For: Excel 2007 or subsequently & Excel for iPad/iPhone

⤓ Google Sheets

License: Private Use (not for distribution or resale)

"No installation, no macros - but a simple spreadsheet" - past

Description

This worksheet was created to be used as an educational resource for personal finance classes. It includes a fairly comprehensive set of expense categories and was designed to be easy to understand and unproblematic to customize. It's mainly for people who don't already employ Quicken (yous can generate a report similar this from Quicken very hands via the Reports menu).

Although in that location are some really absurd things that can be done with Excel to make this worksheet more useful, I have intentionally kept this template unproblematic. Quicken was my personal tool of choice when it comes to personal money management (before they switched to a subscription fee). If you want to employ a gratuitous spreadsheet with the ability to enter transactions in account registers similar you practise in Quicken, you can try the Money Management Template.

Keep in listen that spreadsheets allow you to make more mistakes than software similar Quicken, because spreadsheets utilize formulas and calculations that you may mess up by accident.

A Couple Tips for Entering Amounts

Fixed Expenses: To enter expenses that are the same from month to month, you can enter the value, then select the cell and apply the elevate handle (the lower right of the selection box) to copy the value across to the other months.

Add Values within a Cell: To do some quick math such as calculation two values inside a jail cell, press = to start a formula, then enter a formula like =34+170 and press Enter.

Customizing Categories

Yous can edit the labels for the various categories in cavalcade B as needed. You may want to add more specific categories or delete some you don't need. Do this by inserting or deleting entire rows. When inserting rows, brand sure to copy the formulas in the Total and Average columns.

The formulas used for the cavalcade totals are prepare to go far easy to add and delete rows without messing up the template, as long equally you insert new rows within the range of rows referenced by the totals. You lot should notwithstanding verify the formulas used for the Totals if you insert rows.

Average Monthly Expenses

The Average column divides the Total past the number of columns to requite a monthly average. This can be particularly helpful if you have an annual, quarterly, or other periodic expense and want to figure out what monthly amount to set aside for that upcoming expense.

Creating a Monthly Budget that is the aforementioned each month requires that yous apply averages for variable expenses (fuel, food, etc.) and periodic expenses (insurance, tuition, subscriptions, etc.). A yearly cash menstruum analysis like this one can aid yous figure out what those averages are.

TIP: I of the benefits of using a spreadsheet for a written report like this is that you can add comments to a cell to provide more information about a particular expense (Correct-click > Insert Comment). For example, yous might add together a annotation to explain why you spent $200 on subscriptions in November. That may help you after if you are looking for ways to cutting back your expenses.

Biweekly and Weekly Instead of Monthly

A cash flow assay or budget can be defined over any period that yous want. The dates at the superlative of this worksheet don't affect whatsoever of the other numbers in the worksheet, so y'all could change these dates to whatever yous want them to be.

HINT: If you unhide the columns to the correct of the worksheet, you'll find a cell that lets you alter the appointment period to biweekly or weekly. If y'all change to biweekly periods, the Average volition represent a biweekly boilerplate.

Removing and Calculation Columns

If you wanted a vi-month cash menstruum, simply delete the last half-dozen columns before the Full cavalcade. Adding columns is also possible, but it volition require more experience working with Excel.

If you wanted to add columns for weekly or biweekly cash flow reports, you could copy and insert copied columns, but you'd need to insert them Earlier the current 12th cavalcade so that the Total and Average formulas remain correct (If yous insert them immediately before the Total column, the Total and Average won't include your inserted columns). You lot'd also need to set the formulas in the summary rows at the top of the worksheet (copy the formulas used for the 2nd column to the right).

Beginning/Ending Balance

The purpose of the beginning/catastrophe cash residuum section at the tiptop of this spreadsheet is to testify how much cushion you have in your spending account.

For the Start Balance, enter the sum of the amounts in your spending accounts on the chosen showtime appointment. A checking account, your wallet, and/or savings account might be considered a "spending business relationship" if coin leaves your possession from that account (similar paying bills from a savings account or paying a cab driver with money from your purse).

What is NOT a spending business relationship? Your Retirement Fund, Emergency Fund, College Fund, etc. Practise Not include the residual in any of the categories listed under "Allocations" in the Outflows section. Why? Considering we are treating transfers to these types of savings as Outflows from greenbacks accounts. If you lot included your Retirement Fund in the cash balance, then it wouldn't make sense to include "Retirement Fund" as an Outflow. Note again that this is meant to show how much cushion your spending account has.

Is a credit carte account a spending account? If you are paying the rest off each month, then yes. Yous would monitor your credit carte statement and allocate each transaction to specific expense categories. The transfer of money from your checking account to your credit card account would Non show upward in the cash flow statement in this case.

On the other mitt, minimum payments on credit card balance(due south) are included equally "Credit Card Payments" in the Debt department of the outflows.

TIP: Information technology is MUCH easier to keep savings separate from spending if yous are using dissever banking company accounts for each.