English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I would like a log sheet, but Im not sure how to set one up for my bills. Any help!?!?!

2007-01-08 02:01:00 · 7 answers · asked by Amerz 1 in Business & Finance Other - Business & Finance

7 answers

I'll email you the Excel sheet I've been using for close to 10 years!

~Lisamae

2007-01-08 02:13:39 · answer #1 · answered by boo's mom 6 · 0 0

First you organize your bills by the "due" dates.
Then you organize by level of importance (mortgage, utilities, car loan, credit cards).
Then you divide them by the number of pay checks you get in a month.

If you get paid twice a month you want to pay the stuff due the end of the month from your first check to allow for mail time. So the stuff due the first of the month you pay out of the last check of the month. If you do it right you are always ahead of the game. Remember to leave room for some spending/grocery money as well each pay. It takes a while to figure out a system that fits your budget and your time. It can be as simple as a sheet of paper in a notebook that you check off as you go or as complicated as a computer program. It's all about what is comfortable to you that gets the job done. Good luck

2007-01-08 02:10:53 · answer #2 · answered by Barbiq 6 · 0 0

Well if you have Microsoft Office you could design a simple spread sheet that would allow you to keep track of your bills.
Another way would be to consolidate all your bills or should I say slips so you know what you have comming in for a monthly pay out and then figure out what your Income is.
Knowing the exact amount of both will allow you to figure how much you will have for a weekly spending. This way you can put yourself on a Nice Budget.

2007-01-08 02:12:16 · answer #3 · answered by slimb20413 3 · 0 0

You have to prioritize things. First Rent. You need a place to live.
Then Heat and electric. Then Phone..but only if you need it. Not as a luxury. After that Utilities:water, sewer, trash. Then car insurance. After that then credit cards then medical.

Months Jan........ Feb........March.........April
Rent
Heat
Electric
Phone?
water
sewer
trash
car ins
credit cards
medical
It's easier if you pay your bills once a month. If they are backed up then try to pay them in order of due date. But keep the first 3 in that order.
If bills are overdue and you are trying to catch them up then arrange them by due date. Try to pay at least 75% of the bill. Add the extra onto the next bill. Mark down next to each bill how much you paid and what date. Work across the page instead of different pages. Then month by month you can see what you paid and to whom. Column each pay section off. Write the name of the month at the top of the columns. Good luck.

2007-01-08 02:20:47 · answer #4 · answered by Me2 5 · 0 0

Set up a spread sheet in excel if you have it.
In the first column, put the dates of your expected paychecks (ie the 1st and 15th, every two weeks, etc). Leave plenty of room between dates. In the next column, right next to the date, put your projected pay amount (if your paycheck varies due to a fluctuating hourly schedule, commission, whatever, I find it best to put the lowest amount you expect to make that pay period).
If you have more than one source of income (dividends, checks from Grandma, whatever), list that below your primary income in the same column.

In the next (third) column, list the amount you pay monthly on all your bills and expected expenses (don't forget to add in an entry for gas, groceries, etc!!). Put just the dollar amount here, and make it a negative amount (ie, -20.00).

In the column next to that, write a one-word description of the expense next to the corresponding bill amount (so, for example, you pay $20 a month to your Sears credit card. Column 3 will have the dollar amount of -20, and right next to that in column four, write "sears").

Leave the column after the description open so that you can put in verified payment information, such as confirmation numbers, what check number you used to pay it and the date was paid or sent out, etc.

Now, at the bottom of your list of bills, leave a few blanks so you can fill in other unforeseen expenses. Below that, click on a cell in your spreadsheet, and go to the autosum button (the one that has the funky looking E or backward looking 3 symbol). Clicking on that will give you the option to select which cells you want to add together, and it'll automatically suggest something (usually the column above). holding down your Ctrl key, click in each of the boxes that has a dollar amount--all the bills, and all your income. When you hit ok, a dollar amount will automatically appear in the cell you just formatted. Since you put your expense amounts in negatives (-20.00), it will automatically subtract these numbers from your income, telling you right away how much money you'll have left over after bills each paycheck.

If it turns out that you have too many expenses on one paycheck as opposed to another, this will help you figure that out and adjust your billpaying habits accordingly (ie if you have too many bills on one paycheck, and plenty left over on the next one, pay one (or a few) of your bills ahead on the second paycheck and just get into the habit of paying those bills ahead of time, rather than on time. They only get angry when you pay late, not when you pay early).

2007-01-08 02:29:30 · answer #5 · answered by Woz 4 · 1 0

A good idea nice and cheap is to go get a blotter calendar for your desk. Mark all the bills on it in the appropriate days. This way it's easy to see when something is coming up ans you can also organize your due dates to match your paydays a little better.

2007-01-08 02:11:31 · answer #6 · answered by Ricky J. 6 · 0 0

try this...

2007-01-08 02:04:18 · answer #7 · answered by Anonymous · 0 0

fedest.com, questions and answers