excel spreadsheet for monthly income and expenses

#EXCEL SPREADSHEET FOR MONTHLY INCOME AND EXPENSES FOR FREE#
#EXCEL SPREADSHEET FOR MONTHLY INCOME AND EXPENSES PDF#
#EXCEL SPREADSHEET FOR MONTHLY INCOME AND EXPENSES PLUS#

Get started for free Get started for free How to fill out the spreadsheet for income and expenses

#EXCEL SPREADSHEET FOR MONTHLY INCOME AND EXPENSES PDF#

You can print the PDF template for income and expenses if you wish to have a paper log for your small business transactions and fill it out manually.Īutomatic mileage tracking and IRS-compliant reporting. You can copy the sheet for each month, or continue adding rows for expenses throughout the quarter or year.

Simply delete the examples in area B10:G14 and start adding in your transactions. The formula in the Balance column is set to calculate the balance after each indicated transaction. The Google Sheets and Excel spreadsheet versions of the small business income and expenses template contain a few examples of income and expenses. It is also helpful for your own benefit, for a simple overview of your business’ financial situation.ĭon’t forget to keep receipts and invoices of all business expenses, in order to claim them and lower your taxable income at tax time. It will come in handy at tax time when you can easily look over your money in and out for the year back. Prefer the analogue way? Print your template and you can keep it on your person, or fill it out at home each day.Īn income and expense sheet is a monthly or yearly record of your business-related expenses that you will need in order to keep track of your small business expenses and income. If you use an Excel spreadsheet or a Google Sheet, you will be able to log your small business income and expenses on the go, from your phone or computer. Get the free small business spreadsheet for income and expenses Making this process easier will save you time and headaches, and the simplest way to do that is by using an already set-up template. But remembering to do so on a daily when you have multiple other things to take care of and run your business may be hard. Recording your business income and expenses is vital for every small business. How to fill out the spreadsheet for income and expenses How to use the income and expenses small business spreadsheet Select both B14 and B15 and Autofill the cells F16-F27.Get the free small business spreadsheet for income and expenses

Next, click on cell B14 and enter “=F14/8” hit the enter key once to select cell B15 and type “=F15/8” into this cell and hit enter again after keying that entry.

#EXCEL SPREADSHEET FOR MONTHLY INCOME AND EXPENSES PLUS#

Autofill the cells D16-D27 by selecting cells D14 and D15 and dragging the black plus sign (this appears when holding your cursor over the bottom right corner of D15 while both D14 and D15 are selected) from D15 from D27. Continue by selecting cell D14 and enter the formula “=F14/2” then select cell D15 and enter “=F15/2”.

Select cell F14 and enter “9200” (Note: For this example we have chosen to use the estimates provided on the University of Tennessee-Knoxville website.) Next, fill in cells F15-F27 in the same manner. Use the AutoFill feature mentioned earlier to fill in cells F7-F10. Select cell B6 and enter “=F6/8” then select cells F5 and F6. To begin, select cell B5 and enter “=F5/8” (Note: For this budget we have assumed that a semester is four months long, thus a two-semester school year would consist of 8 months). The process for filling in the Monthly Budget Income Categories is essentially the same as it was for the Semester Budget Income Categories. This will automatically fill cells D7-D10 with the correct formula, hence saving time. Click on the bottom right corner where the cursor has become a black plus sign (this appears when holding your cursor over the bottom right corner of D6 while both D5 and D6 are selected) and drag it down through cell D10. Select cells F5 and F6 and hold the cursor over the bottom left corner of cell F6 until the cursor becomes a black plus sign, as shown in the figure below. After this, select cell D6 and enter “=F6/2” and hit the enter key. Next, select cell D5 and enter “=F5/2” this will give us the appropriate amount for the semester since, in this case, a school year consists of two semesters. You will obviously choose numbers that reflect your personal income categories.) For this example we will enter the following numbers into the corresponding cells: o “4800” in F5 o “6000” in F6 o “8000” in F7 o “8000” in F8 o “2000” in F9 o “360” in F10 II. (Note: the numbers used in this budget are based on amounts determined to be average by the University of Tennessee-Knoxville. Begin by selecting cell F5 and enter the amount of income received from jobs.

Excel spreadsheet for monthly income and expenses