There are numerous tips for creating an expense sheet as everyone has their own method to the madness of trying to keep track of your daily expenses, especially when money is tight. Some people like to keep a tally in their head while others want to keep a record of exact receipts in labeled folders; each individual have ways of doing this that make them more comfortable than others. However, there are a few general tips for creating an expense sheet which are helpful in just about any budgeting situation. Check out some of these tips below and pick and choose which ones make the most sense to you when trying to keep track of your personal spending.
Columns will be at the top of your expense sheet so that you can keep all of your expenditures very organized. These columns should be labeled as different categories that represent different aspects of the expense. So, for example, you will want a column that will simply be numbers of each line item of expense, a column beside that with the date of each expense labeled date and a column beside that labeled amount for how much each expense was. Those are the basic ones that you will need to start each expense sheet, though a whole host of other columns can be created, like reason or description, which will give the reason or the description for each individual expense and reference page, which will allow you to put copies of each receipt you may have kept in order behind the main pages of the expense sheet. However, these additions are up to you or whoever is asking you to put the expense sheet together.
If you want a more in depth expense sheet or expense report, you will want to keep all of your receipts from the first date you started the expense sheet and label them with numbers that correspond to the expense sheet (as mentioned in the paragraph above). Ideally, you will not want to put the originals on this larger expense report but rather make photocopies which can then be indexed behind the expense sheets at the front, so that if someone wants proof the purchase was made or the money was spent, they can flip to it easily. If circumstances where a receipt is not issued, you have to go to the people who you worked with on that expense and have them write, email or sign an original receipt, proving the transaction took place.
Each item on the expense sheet should be marked paid or unpaid, as these sheets will also allow you to plan for bills that you have to pay on a regular basis in the future, or people you have hired to do specific things for you who you will need to pay for their services. Make sure you add all of these invoices or clients to the expense sheet, so that you can keep track of who you have and haven't paid, as well as the money you have left over to pay them. Once you have paid them you should write paid on the expense sheet, so you know at a glance who still needs what you owe them.