Thursday, September 12, 2013

Tricks of the Trade

I have said everything here in earlier posts, but these suggestions bear repeating:

When projecting a new budget, List Regular Expense estimates to the nearest ten dollar average.  It helps to locate them visually,  Thus, if the monthly phone bill average is $38.73, project it as $40 until it becomes specified.  The same goes for water, electricity, cable, and other utilities.  Mortgage or rent payments, however, will normally be specific, so enter them exactly.

Nonvariable and contracted amounts such as loan payments or auto payments are normally specified to the penny,

The principle here is that future amounts, both income and expenses, aren't often exact.  They are estimates until they become known.  So keep them rounded on both left and right sides till then.  It makes them easier to locate and edit.

For the same reason, list Regular Income and Regular Expenses in the same order and numbering vertically.  The left, Cashflow side will break down each category or item of income or expense chronologically, so where each appears will depend on days of the week and weeks in the month, when banks are open and other matters.   But ease of visual location and referencing from one side to the other still applies,

I like to consider each year in thirds, for my planning.  January through April, May through August, and September through December works for me.  The summer months have their own character and needs such as vacation planning or possibly moving, but September through April is the school year, when people tend not to switch their lives around so much.

The most active third for budgeting is September through December, I believe, when stores already put out reminders and merchandise for Halloween, Thanksgiving, and Christmas buying.  The least active is winter into spring, when budgets often have their best chance to catch up and expenses are at the most stable part of the year.


Begin 2014 planning now.  Clean up a 2013 budget or use a new template, but create your 2014 budget now, and save it as "budget14" or other clear identifier.  Keep it off your desktop except to update it so you won't mix its data with budget13 data.  Update it over the next three months as you learn new information, but always save it in a separate, safe location.  That way you will be able to seamlessly transition from the end of this year to the beginning of next year.

Once 2014 begins, put your budget13 in My Documents with previous years, keep budget14 on the desktop, and bring up budget13 only to update it through January till revisions end, then print a final copy and bind it for reference.

There are several principles involved here, but the main one is to keep only the current working year's icon on the desktop.

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.