How To Make Expenses Spreadsheet
Discovering how to make expenses spreadsheet can keep an individual or a business organized and on track. Information can be sorted according to different specifications and all of the important data can be available immediately.
- Decide on and open an expenses spreadsheet program. There are a few expenses spreadsheet programs available. Choose the one that works best for you. Many computers come with a program already installed that includes expenses spreadsheet software.
- Create a list of expenses. After skipping a few rows down, create a list of expenses. You can list them generically, like “house payment” or “cell phone” or fill in the specific name of the company.
- Divide the expenses into sections by date. Is there an expense that is incurred weekly? In the cell at the top left column, write “weekly.” Place all of the weekly expenses here. Skip two rows and write “monthly.” Continue until you have listed all expenses and each one falls into a time category.
- Fill in amount of the expense. To the right of each of the expenses, in the next column, put the amount. Some may not be the same every time. Try to come up with an average amount. Label this column “amount billed.” Even if you aren't billed for groceries, it gives you an idea of how much you were planning to spend.
- In the next column to the right, fill in the amount you paid. Label this column, “amount paid.” This shows which bills were paid in full, which still need to be paid, and which bills were more or less that you had planned.
- Add up all the expenses. Begin by everything in the “amount billed category.” You can do this in sections; by week, month, and year or tally up all of the expenses together. Next, add up everything in the “amount paid” category. Again, you can tally all of the amounts paid at one time, or sort by time. Use the sum function on the expenses spreadsheet to make this process easier.
This expenses spreadsheet now lists all of the important expenses. If you want to add more information, create new columns. For example, if you want to list all of the contact information for each bill, add columns to the right for an address and phone number. If you are dealing with credit cards, you can add a column that shows the entire amount owed on the card.