Sunday, July 21, 2013

Estimates, Adjustments, Commitments, Actualities, and Records

Budget amounts almost never remain unchanged from the time they first appear till the time they last appear as a locked-in number-- often not finalized until a new calendar year is weeks or even months underway.

They begin as budgeted estimates for a new budget year, whether estimated income, estimated expenses, or estimated charges.  By their very nature they are based on the future, all of them.  But they are also based on the best knowledge available at the time they are created,  For example, if a car loan payable monthly is due to be paid off in September, the user wouldn't need to schedule its paynent estimates on through December.  Cars, furniture, and other big ticket items with monthly payments as well as home mortgage loans provide the user with the most accurate estimates of future costs.

Estimates of income likewise are based on current knowledge  as well as past experience averages.  Takehome net paychecks. for example, can be estimated into a new year budget as a continuing expectation if the user expects to continue in the same job with the same benefits and deductions.  If, however, he knows of impending raises, promotion, or other basis for adjustment, new year estimates need to be refined taking these into account.

Another important consideration in setting up a new year budget is the dates users need to schedule payments and can expect to receive regularly-scheduled paychecks.  Some months, for example, have five Fridays where most have only four, so Friday paychecks will need adjustment for the extra, third paycheck in those months.  It is easy to appreciate that any new year budget needs to be set up with a good annual calendar in one hand, such as those found on the back of checking account registers.

Credit card payments, like mortgage payments, need to be scheduled each month on the last day certain to be received and credited before incurring added interest charges--usually at least 3-5 days before the due date if paid by bank online payment. even sooner if paid by mail.  A week in advance is usually a safe bet.

Another considation in setting up estimates is rounding amounts.  Since the user is dealing with numbers which are almost certain to change significantly in any case, it is helpful to avoid penny accuracy and go with large, whole numbers that are expected to be close to reality, then refine them as actual numbers begin to replace estimates over a few months' time.

Thus, if the power bill average average monthly paymemt in 2013 is $273.46, use $275 or better yet, $280 for the estimate setting it up in 2014,  The rounding will help it stand out to the eye as an estimated amount when you're scheduling it to be paid on such and such a date, and help to locate it across the cashflow/budget sides until it becomes an exact, to-the-penny known amount.

At that point the amount is no longer an estimate.  But it isn't yet a realized, paid sum yet either.  It is now an adjustment, and because it is still scheduled to happen in a future time, is still subject to revision.  Until it is actually paid or earned, it can't be classified as a commitment.

So when does a particular budgeted amount become an actual, unchangeable figure?  Pagemonth Home Budgets are designed to treat a number differently through its evolution by the use of decimal position, location, and checkmarks, (forward slashes /)

A number doesn't get exact penny treatment till it becomes an adjustment or commitment.  And it doesn't get a checkmark to its right until it becomes an actuality--in other words, writing the check or  scheduling it for online payment is one thing.  Mailing the check or confirming that an amount has been made by the bank elevates the number to a commitment.  But only confirming that the amount has been received and cashed by the recipient rates a checkmark! 

All that may seem needless quibbling over straws, but trust me, it is not.  Until any amount, whether income, expense, or charge, passes the test of being confirmed by the bank at each phase (and reconciled by the user's statement records even beyond that!), any checkmark is premature.

When we get our finalized charge statement either online or by mail, we can check off everything on it to the right of entries,  And in doing so we can visually spot items that still remain to be paid on the next one, or found by backtracking on a previous one.

And when we receive our finalized checking account statement either online or by mail, we can check off each item on it to the right of entries, and again, easily spot discrepancies if any have occurred.  The checked entry says the amount is now a record of actual experience, and says it not only to the computer screen workspace and spreadsheet file for the year, but also to the printed month pages and end-of-year summary page that follows them sometime by the end of January the following year.

At that point I print and bind my final hard copy of the previous year, ready for reference as I study previous experience and set up my next year's budget amounts, prepare for birthdays and holidays, taxes, vacations and trips to come.

Done in this way from rough estimate to bound record, your Pagemonth Home Budget will serve you well throughout each year.




Sunday, July 14, 2013

Percentages

Our Pagemonth.com Budgeting101 page offers a table of percentages of net income an average family might spend for housing, food, clothing, and other expenses.

Below that table we caution that the percentages are very general and not fixed. that each user has different goals and needs, and that the experts' percentages are intended as guidelines only.

Yet our visitors seek even these general guidelines to help them create their own budgets more than any other concern about our spreadsheet setup or support matters.  People recognize that effective budgeting begins with a good sense of how much they should strive to spend in these areas.

My source for these percentages was the Today Show on NBC that I taped and used for the table, adding the suggested Pagemonth categories that seemed to match best.  I have used these percentages since 1980 as averages that still seem sensible to me.

Here I want to comment on each category in more detail, beginning with 25% for housing and utilities: mortgage or rent, power, water, phones (including cellphones), cable or satellite signal), but also including charges for lawn care and pool maintenance and repairs if applicable, trash pickup, and any other charges related to upkeep of the home and property.  However, The 25% would not include the initial costs of purchasing the home or advance payments required to rent the property and held in escrow or by the landlord to be returned after sale or moving.

Food as 15% would include groceries, meals out, cash for snacks and so forth.  Elsewhere I have recommended using a weekly amount of cash for groceries and adjusting it as experience suggests, but I recognize that many prefer to buy all groceries by credit or debit card, and that's understandable, especially for those who do not want to carry a large amount of cash in pocket or purse.

Clothing as 5% of discretionary income is adjustable depending on need.  It isn't even necessarily a monthly expense.  Some may have clothing supplied as uniforms by enployers that may affect the percentage needed, for example.  Or clothing needed for new jobs.  Or families caring for more than one or two children may spend much more than 5%.  Seasonal spikes like back-to-school can skew it as well.  It is a percentage that should be averaged over several months, if not the entire year, to determine.

Medical costs at 5% include any doctor, nursing, dentist, hospital, and prescription costs not covered by the user's health insurance. 

Transportation at 15% might seem high until one realizes it includes not only bus, train, air or boat transportion on a regular basis but also car payments, car insurance, fuel and oil, and all upkeep and repairs.

Debt payments at 15% also include money needed to pay for credit purchases and fees and all loan payments including interest and lender charges.  Debit card purchases, however, are treated by Pagemonth like checks being cashed, in that they are deducted from the user's checking account at the time of use.  They are not included in the 15% for debt payments.

5% for Savings may be the hardest amount to maintain, because it isn't required to be paid to anyone else.  It is also the easiest to reduce or skip in any given month.  But among all expenses it is perhaps the most necessary to financial health.  It builds future security, equity for credit, solvency against catastrophy and a basis for retirement if set aside religiously.  Pagemonth advises treating it as a Regular Expense--the first to be paid each month, before other needs may make it difficult.

These guideline percentages still leave 15% of discretionary income for miscellaneous purchases and investments at the user's discretion, and for many that's about right.  There is no need to force income into the recommended amounts, but they can provide a useful comparison to the user's actual expenses over several months' time.



Saturday, July 6, 2013

A Bit of History

I  created Pageamonth Home Budget in 1980 with the beginning of Windows 3.1.  But I had been developing it as a personal home budget long before that--since Tandy (Radio Shack) offered 40-character widths, in fact, and before that as a hand-ruled pen-drawn matrix of rows and columns on plain paper that I filled in by pencil and changed by eraser--lots of erasures as you might imagine.

My attempts to keep a personal budget go back even further.  I was noting my income and expenses in spiral notebooks by 1970, as a single man in living in Chicago.  It seems I've been obsessed with financial recordkeeping my whole adult life.

When the Internet spread, I offered my Pageamonth Budget for $19.95 through Spreadsheet Marketplace and other affiliates, and sold a few dozen of them to U.S. buyers, eventually building my own website, www.pageamonth.com to support those spreadsheets with setup and help pages. 

In the past several years, however, with the economy sliding into severe recession, my ad costs far outweighed my earnings, and I switched to giving my budgets away to anyone who wanted them, with no limits.  I realized people needed to budget more than ever but couldn't afford to buy a good home budget themselves.  I also hoped that by giving them away I could attract enough more visitors to click the budgeting-relevant ads Google placed on my pages, that my ad revenue could offset my rising Pagemonth ad costs.  I also set up a donation button in case people downloaded my budgets and benefitted from using them and wanted to give back something to help defray my costs.

I truly believed, naively, that users would spread the word and others would visit, download, spread the word even further, and grow my ad and donation revenue..

It didn't work out quite that way.  I was soon unable to advertise to the US market, the most expensive on earth, and had to keep minimal ads going worldwide on only the $1.00 per day I felt I could afford,  A dollar a day given away to advertise a free spreadsheet didn't generate enough ads to enough places enough of the time, even to the world markets, to generate more than a few cents return on my dollar cost, didn't work.   As for donations, no one has ever donated a penny. Not even once. 

A year ago on July 10 I determined to try to sell my spreadsheets again, contacted my former affilite www.spreadsheetmarketplace,com, and asked them to sell my budgets again, which they agreed to do pending editorial preparation. 

If and when they do place my spreadsheet on their pages again at $9.95, I will again quit giving them away and cost them at or above their price so as not to undercut them, and from then on I will rely on them and other affiliates.

Today Pagemonth Home Budgets remain free and unrestricted in any way to anyone who wants them.  They are available at the bottom of our homepage for instant, unlimited  downloads, as are the free blank templates that match them in Excel and Works formats..

We urge anyone interested to get them free now, however, because our free giveaway could change to a cost basis at any time.

--N.B. Kauffman

Tuesday, June 25, 2013

This July 4 Declare Your Financial Independence!

Independence Day is fast approaching, and this year's July 4 is a great time to declare your financial independence by taking control of your money!  Pagemonth Budget is ready, willing, and able to help.  We are again offering all of our budget and template spreadsheets absolutely free..

Go to the bottom of our homepage, instantly download our free budget in the Excel or Works version you prefer, grab a free template in that version as well, and you can begin taking charge of your finances in minutes, for no cost whatsoever and at absolutely no risk.

How can we afford to give our products away?  We rely solely on revenue from financially relevant product and service ads that Google places on our pages and pays us a few cents when visitors click on them.  We also accept donations through Paypal and major credit cards.

So our revenue is 100% ad and donation based.  It costs users nothing, and depends solely on the growth of the number of visitors to our website to download our free products. 

We want to help you become financially independent, and we know our spreadsheets can help.  If they help you, spread the word so we can remain free for everyone.

Friday, June 7, 2013

Why Budgets Work

Some visitors to Pagemonth.com are interested in our home budget spreadsheet--but only some.  Most are interested in finding advice on home budgeting itself, especially how much they should budget for food, clothing, shelter, transportation, savings, emergencies, repairs and maintainance, and so on.  It is the single most asked question everyone wants advice on.

I found evidence of this in designing our budget and our website support pages at Pagemonth.com.  By far the most visited page after our homepage has been Budgeting 101, where we chart out basic percentages of net income many experts recommend spending on those broad categories for an average home budget.

It astonished me to find that very few were interested in our pages on assistance setting up or using the spreadsheet itself, or the FAQ's we used to answer users' questions and concerns, or our contact page, or even our blog, compared to the interest in "How much should I budget for ____?" fill in the blank.

And it got me thinking, why is it that budgeting works in the first place?  It has to be more than just recording income, expenses and charges on a regular basis.  Those are the actual numbers, and no doubt they act on our psyches to confirm our suspicions and perhaps goad us to try to cut back in some things or try to earn more income, use our credit cards less frequently, or otherwise keep them in mind.

But then I realized, no, that's not really what makes budgets work.  It's not what has happened in the past.  It's what could happen in the future unless we make adjustments.  In other words, budgets work mainly because they force us to look ahead.  Unlike our checkbooks and bank statements, home budgets project a future scenario of getting and spending we think could happen, and what the future needs could do to our future balance through the remainder of the year.

And it's pretty strong motivation if we see projected balances we can't live with.  It makes us think twice before getting things we really don't need or settling for an income we can't comfortably live on. 

But it also gives us the motivation we need to adjust our getting and spending to project future balances we can live with, even thrive on--to set up an end-of-December balance that leads like a beacon in the darkness.

Admittedly, actual experience numbers show us that unpredictable expenses are going to happen sometimes that knock our budgets way off, so we try to build in buffers within our budgets to handle them.  Sometimes, also, we catch a break and get some unexpected money as well, but we can't count on it.  Our budget plans have to project realistically, and one can't count on surprises.

So budgets work because they extend our view, reminding us of how we got to our present situation and showing a future we may be in, a telescopic view if you will, while we are still in the present, with time to adjust for it.

Tuesday, June 4, 2013

Using Dates and Checkmarks

Pagemonth Budgets all have narrow columns for dates to the left of item descriptions, both on the Cashflow and the Budget sides.

Likewise, Pagemonth Budgets have even narrower columns to the right of item descriptions for checkmarks, which we indicate with a forward slash (/).

Both of these columns are found framing item descriptions in Income, Expenses, and Charges.  It is useful to understand what they are there for and how to use them effectively.

The first thing to realize is that no dates or checkmarks have any inherent value or significance in themselves.  The dates for income and expense items exist solely to assist locating their duplicate entries on another part of the page  In your sample budget, for example, cell A12 shows the January rent dated January 5, and cell L7 repeats January 5. for that month's mtg/rent.

The dates to the left of charged items, however, are entered manually either when you charge an item to your credit card or when you plan in advance to do so, enabling you to budget an "guesstimate" amount of credit for vacation charges a few months ahead if you wish to.  When those actually occur, you'll correct your guesstimate to reflect real amounts charged on that vacation.

The benefit is, of course, that you're planning ahead for expenses you anticipate so you can enter that amount in addition to the normal amount of your monrthly charges you budget for.  And if you end up not having to pay that much, or elect to spread it out over a few months, it's easily adjusted.  I try to overbudget for my vacation credit charges and have some left over to return to checking when I get back.

Since charge cards give 30 days before interest is added, I base my credit payoffs on when that interest would begin to accrue and make sure to pay it all off in full ahead of that date.  Credit card interest can destroy your budgeting.  It's normally the highest rates allowed under the law and it can bleed you dry if you let it.

As for the checkmark columns to the right of items throughout Pagemonth Budgets, I recommend not checking an item off until it is confirmed in some way.  For income items, that would normally be confirmed by your online bank checking account.  Your paycheck was added when?  Okay, check.  But don't do it based on projected dates.

Again, for charges, check items off when you have confirmation through a credit statement or online completed transaction list, not before.

Used in these ways, the dates and checkmarks in your Pagemonths Budgets will make editing, finding, and confirming all entries on each monthpage much easier to keep track of, and an unchecked entry can be located and corrected even several months back if need be for some tardy creditor.



Sunday, May 26, 2013

Updating and Revising

No effective home budget is cast in stone from the outset.  Keeping a budget means continuously revising projections in the light of new information and updating changed amounts already entered.

Further, revising and updating needs to happen again when bank records catch up with deposits and expenses on their online account data, and finally when their monthly statements are issued and you reconcile the bank's finalized data against your physical checkbook.

As you check off items in bank statements, check them off also on your Pagemonth Budget or other budget you use, as well as checking them off in your checkbook, and reconcile your statements in a timely manner, taking into account such items as check printing fees, late charges or low balance fees if they occur. 

If any amounts from bank records need to be revised in a previous month of your computer budget, add extra income amounts in category 503 and extra fees or penalties in category 120 as other income and miscellaneous expenses, respectively. dating the entries on the dates the bank records indicate.

What these retroactive changes will do, of course, is change your previous months' balances and make any printing you have already done obsolete.  This is why I suggest a monthpage printout at each month's beginning and another at it's end, and a third printout of that month only after all its amounts are reconciled and no further revision will be necessary.  In that way your final. bound pages will accumulate through December accurately.  And keep in mind your final year Summary won't be finalized until mid-January of the following year when your bank statement data through December appears online.

Updating previous data is half the battle of accurate revision.  The other half is revising projected income, expenses and charges as new information becomes known.  Especially during January changed figures typically happen to force revised expenses.  Vendors who put off raising utility bills during late autumn tend to use January, the first of the year, as the time to spring them on you.  Government does the same, raising taxes as of January.  Employers often do the same, adjusting payrolls because the holiday buying season is over.  But often employers will use January as a time to issue promotions as well, and perhaps new hiring.

All of January's changes require revisions in budgeted amounts, perhaps throughout the year.  Another key time is when you prepare and file tax returns.  If you have kept your Pagemonth Budget updated vigilantly throughout the previous year, your tax preparation will be much easier, for you will have totals of deductible expenses available with no added calculations.

Revisions and updating also become frequent around vacation times as you try to free up money to take trips and try to anticipate charges you will incur on them, and when you'll be able to pay those off.  Back to school always has its costs to handle, as does moving to a new job or city, often as autumn begins.  And after that, of course, it's time to begin the holiday buying season planning again.

So there really is no time of the year when a home budget, whether it be ours or someone else's, can be unattended to "run on its own."  Every decent home budget must be closely monitored and continually updated and revised, daily, weekly, monthly, until at last you can put the previous year's final numbers behind you,