Myown10-key: how to balance your checking account without first entering all of your transactions

MyOwn10-Key - How To Balance Your Checking Account Without First Entering All Of Your Transactions

Keywords: checkbook, balancing, checking, account, myown10-key

Balancing your checking account against statements from your financial institution is a monthly task that I highly recommend. Not only can you make mistakes, but the people who process your checking account transactions are subject to human error as well.

Mistakes in your checking account and/or checkbook register can be small or large, and in your favor or in the bank’s favor. To keep everyone honest, and to prevent potentially nasty financial surprises, do yourself a favor and balance your checking account every month.

Step-by-step Instructions

Balancing your checking account with the aid of your computer does not mean that you first have to enter all of your checking account transactions into a program. Here’s the step-by-step procedure for doing your balancing, without entering any transactions, using myOwn10-Key.

1. Start one copy of the program. Press Ctrl+O to display the Open dialog box. Browse to the Sample Tapes folder that is located below the folder where the program is installed. Double click on the “Balance Checkbook.ptc” filename.

This will load the balancing etape into the program. Press F11 to place the program in collapsed mode and then, if needed, drag the window borders to expand the window size so that you can see the entire etape including all of the Notes. Move the program window as far as possible to the left on your monitor screen.

2. To avoid over-writing the master “Balance Checkbook” etape file, click on the File menu and then the Save As command. Select a folder and enter a filename of your choosing for the new copy of the balancing etape. Click the Save button.

3. Start a second copy of the program. If needed, press F11 to also place this second copy of the program in collapsed mode. Place the second program window to the right of the first. Resize both windows as needed to give yourself as much etape viewing area without overlapping the two windows.

You can gain monitor viewing space in the second copy of the program by turning off the etape line numbers as well as removing the subtotal column. While the second copy of the program is in Expanded mode (pressing F11 toggles between Expanded and Collapsed modes), click on the Tape menu and then either the Line Numbers or Subtotal Column commands. For the Line Numbers command, you will also have to click on the None option.

4. On the balancing etape in the first, or left hand window, change the “Ending balance on statement” value on line 2 to agree with the ending balance shown on your account statement.

To make this, or any of the following etape value changes, right click anywhere on the etape row being changed. This will open the Change Tape Entry window in which you change the Tape value and then click on the OK button.

5. In your checkbook register, check off all of the cleared transactions that are listed on the account statement. This includes deposits, checks, and other withdrawals.

If there are any fees, such as for monthly account maintenance or for new checks, ensure that those fees are recorded in your checkbook register. Check these fee transactions as cleared since they appear on the current statement. If needed, bring your register balance up to date to reflect the new entries.

As an aid to help keep track of, and find the oldest, uncleared transaction in your checkbook register, draw a line down the column in which you check off cleared items. Start the line at the beginning of the check register and stop the line just above the oldest, uncleared transaction. As you check off newly cleared transactions, continue the line so that it always stops just above the oldest, uncleared transaction.

6. Using the second, or right hand copy of the 10-key program, add up all of the deposits in your checkbook register that have not yet appeared on a statement. Change the “Deposits not on statement” value on line 3 of the balancing etape to this total.

To start a new etape section while preserving all preceeding etape sections, either press F3 or the left arrow key. Either of these keys will, if needed, add a final subtotal to the bottom section of the tape and then start a new etape section.

7. Using the second, or right hand copy of the 10-key program, add up all of the checks and other withdrawals in your checkbook register that have not yet appeared on a statement. Change the “Checks/Withdrawals not on statement” value on line 4 of the balancing etape to this total.

8. On the balancing etape, change the “Ending balance in register” value on line 5 to agree with the last balance in your checkbook register.

9. The “Total recorded in other than register” value on the balance etape is for amounts in your checking account that you keep track of separate from your checkbook register. If you keep track of any of the funds in your checking account separate from your checkbook register, change the “Total recorded in other than register” value on line 6 to the total of these separate funds.

Balancing

When your checking account is in balance with the account statement, the end subtotal on the balancing etape, line 7, will now be zero (0.00). If this end subtotal is not zero, here are a few suggestions for trying to find the error.

* Verify that the ending balances from both the account statement and your checkbook register have been entered correctly on the balance etape.

* Verify that all subtotals from the second, right hand etape have been copied correctly to the balancing etape.

* Review the account statement to see if there are any charges, such as new checks or monthly fees, which have not been entered in your checkbook register.

* Compare the deposit, check and other withdrawal amounts listed on the account statement with the amounts recorded in your checkbook register to see if there are any disagreements.

* Re-add all of the uncleared deposits in your checkbook register that have not yet appeared on an account statement to ensure that this total on the balancing etape is correct.

* Re-add all of the uncleared checks and other withdrawals in your checkbook register that have not yet appeared on an account statement to ensure that this total on the balancing etape is correct.

* Re-do the arithmetic in your checkbook register since the last time you balanced. (Finding the last place you balanced is easy if you draw a line under the last balance in your checkbook register each time you finish balancing your account.)

If you find no obvious errors, you have the option of visiting your financial institution to get help. Or you can force your checkbook register into balance with your account by adjusting the ending balance in your checkbook register. The notes at the bottom of the balance etape have instructions for the two options for forcing your account into balance by either adding or subtracting the out-of-balance amount from your check register balance.

Whether or not you decide to force your account to balance depends on the impact making such an adjustment will have on your account balance. Only you can decide whether forcing your account to balance is something you want to do.

When You Are Done

When you are done balancing your checking account:

1. Close both copies of the program. Whether or not you save either the balancing or calculation etapes is entirely up to you.

2. In your checkbook register, draw a line under the last balance to indicate where you last balanced your account. You know that all transactions above this line are in balance. If there is a problem with balancing the next statement, you will only have to concern yourself with checking for errors in entries following the last underlined balance.

George Gilbert writes software for personal computers. Titles include myOwn10-Key, myOwnPayday, Person On Call, Trend Importer and Double Text. Find out more about these innovative, award winning programs at www.2goodsoftware.com.


Previous Articles Highlighter:

New Exchange Traded Fund Makes Sophisticated Investment Strategies Available To ETF Investors (1)
After dissecting stock sectors every which way, new funds were established that moved into the areas of commodities by allowing investors to invest in oil, metals and currencies. Now the choices are becoming even more sophisticated.

Despite Slowdown California Home Prices Set New Record (2)
Andrew Goldman is president of Metal Rabbit media services, the operator of www.carealestateinvest.com. Andrew has contributed articles on finance and environment to severl publications over the last ten years.

Two New Exchange Traded Funds Allow Unique Oil Investment Strategies (3)
If the initial shares were offered at $60 a barrel, that means oil prices over a period of 3 days would have to move about $51 up or down away the $60 buying price.

New Fund For Indian Investors Can Benefit U.S. Investors (4)
Other fund houses such as DSP Merrill Lynch are interested in introducing these types of funds. Exchange Traded Funds are a new concept to Indian investors, but buying and selling gold is not.

Exchange Traded Funds Venture Further Into Foreign Currency Markets (5)
Depending on who you talk to, this could be a good or bad thing. These funds could be a good investment in an environment of a weakening dollar, which is what we have now.

California Foreclosure Activity Up By The Biggest Margin In 14 Years- Is The Bust Starting? (6)
In San Diego and Sacramento home values are flat. These are two areas in California that saw appreciation rates soar. San Diego and Sacramento are two areas in California that are vulnerable to falling home prices.

Using ETFs To Invest In A Good Performing Commodity Sector You May Have Missed (7)
There is a commodity that investors may not be aware of that is posting good returns. That commodity is water There is a growing world demand for clean water worldwide.

Best Performing Exchange Traded Funds For 2006 Thru August (8)
Spain has strong economic gains and low interest rates. To keep everything in perspective, Europe as a whole is out performing the US markets. Spain is outperforming the rest of Europe.

Real Estate Schemes Prey On Homeowners And Lenders (9)
This scenario does not always pan out. Just ask the investors who poured into the Phoenix market and are still holding their properties. The housing bubble has not burst but the markets have changed.

California Real Estate Market Gives Mixed Messages (10)
The average price of a luxury home in San Francisco is $2.92 million. So what direction is the California Market moving? There are investors cashing in on their profits and getting out, however most homeowners are not investors.

A New Exchange Traded Fund May Have A Major Impact On Long Term Silver Prices (11)
You can now but an ETF that invests in gold, silver or oil. When the equity markets are looking dull, investors can now move their money into funds that are driven by commodities.

Another Way Of Looking At The Gold Price Meltdown (12)
During this same period of time, demand for gold related Exchange Traded Funds has risen 23%. India is the largest buyer of gold in the world. Indian investors will soon be able to buy gold ETFs on Indian Exchanges.

New Powershare ETFs Give Exchange Traded Fund Investors New Ways To Profit In Down Markets (13)
Areas such as Emerging Markets, Japan, and commodities that have attracted a lot of investor confidence over the past year are now spotty. Individually these new Exchange Traded Funds can be very volatile.

A Unique Precious Metals Exchange Traded Fund Is Launched Under A Cloud Of Worry (14)
This new fund which tracks the Gold Miners Index happened to have been launched during one of the most precipitous drops in precious metals prices seen in years. No wonder why you may have missed its launch.

Home Sales Continue To Drop In Southern California (15)
Last spring it was 27 days, now it is 48. The county to watch is San Diego. It was the first county to accelerate in home value appreciation and the first to slow.

A Risky Investment Becomes Commonplace (16)
Now with the addition of newer investment vehicles into the market, these investments are becoming more commonplace. All over the world both investment institutions and individual investors are fueling commodity prices with their investments.

Will Long Term Home Ownership Lead To Profits Or Declining Values? (17)
The report indicated that if you owned a home from 1986 thru 2005 in 50 of the largest metropolitan areas, you did very well. During that period of time, if you owned a home for 10 years or more, you profited 100% of the time.

A Foreign Exchange Traded Fund Investors Should Consider (18)
The long slumbering Japanese economy is now coming alive. After years of deflation this economy is finally waking up. For the last several years Japan's unemployment rate has been above 5%.

One Of The Most Popular Exchange Traded Funds Will Soon Have Solid Competition (19)
This new fund will be very similar to an existing index. This is the ArcaEx Tech 100 index. Over the past five years the ArchEx Tech 100 index has trounced the performance of the QQQQ.

What Do You Need To Know About Car Loans? (20)
Just as with any other loan, it really pays to shop around for your car loan. One of the big questions is new car or used car. This will greatly impact your loan's APR, as generally new car loans get better rates.

Newer Articles Highlighter:

Credit Card Types: Unsecured (1)
This is a yearly fee that is charged to your account or may have to be paid in advance. Annual fees are more often associated with secured credit cards but you may see them with unsecured as well.

The Benefits Of Gathering Relocation Information (2)
It is also a good idea to look for relocation information that assists you in creating a guide and time line for your move. There are many great tips that can save you a lot of time and are worth investigating before starting the moving process.

Cashback Credit Card For Reward-Loving Individuals (3)
Aside from earning rebates, you are also entitled to extended warranties, unlimited protection for purchases, and personal accident insurance for the cardholder. As previously mentioned, it is interest-free for the fist 12 months.

Holiday Insurance - A Necessity Or A Luxury? You Decide (4)
A conscientious traveler knows the difference. Lokking After Your Property On Holiday Personal Effects Coverage is holiday insurance that covers a traveler in the event that their baggage is lost, stolen or damaged in the course of the trip.

How To Get Real Estate Listings Via Real Estate Marketing Articles (5)
Instead, you should expect little to any immediate success from your initial mailings. Direct marketing is truly a mid to long range strategy in terms of getting listings and making sales.

Introduction To Stocks (6)
Most of the advice they provide is based on research done by analysts who work for the brokerage house. A discount broker is someone who gives you zero advice, and just executes your market orders for you, but does nothing else.

Understanding A Balance Sheet (7)
You do not need to be an expert or a financial analyst to understand and evaluate financial information, but you should know what to look for so you can determine whether you should invest in a certain company.

Penny Stocks: A Good Investment (8)
3) Consumer Demand: Will there be a demand for what the company is selling? Sometimes a company has a great new invention or an exciting technology, but if it is not something practical that consumers are going to want or need, then it does not matter how great it is.

Understanding Auto Insurance (9)
It covers you if you are involved in an accident and the other driver was at-fault, but that other driver either does not have insurance or their coverage is not adequate to compensate you for your damages.

Common Investment Scams (10)
Eventually, the pyramid collapses when money owed to the previous investors is more than what can be raised. Next on the list is an outright illegal practice called the pump and dump.

P/E Or PEG, Which Is Better? (11)
Or, the low ratio might indicate that the company is currently undervalued, making it a good buy because as long as the company is expected to have stable earnings growth in the future, then the share price will go up.

Tax Consequences Of Municipal Bonds (12)
A particularly perplexing aspect of municipal bonds is known as the de minimus tax rule. This rule asserts that if you purchase a bond at a discount equal to or greater than a quarter point per year until maturity, then instead of paying a capital gains tax on the increase in principal, you will pay taxes equivalent to your ordinary income tax.

Introduction To Mutual Funds (13)
Carefully examine the fee structure and investment strategy before investing and you should do fine. Jim Pretin is the owner of www.forms4free.com, a service that helps programmers make email forms.

Introduction To Day Trading (14)
Another popular trading strategy is called short selling. This is where the trader borrows a stock from a financial institution and then sells it, hoping that the price will go down in the near future so that the trader can buy the stock back at a lower price when it comes time to return the stock to the lender.

What Mergers Mean For Your Investments (15)
(If both companies are in good shape, then joining them together will likely make each entity stronger; if one company is in trouble, then the other will be saddled with the problems of the other) 2) How many shares will you have after the merger takes place?

Understanding Your Insurance Policy (16)
You should skim through the huge packet of terms and conditions that are attached to your policy and then call your agent or broker with any questions or concerns you might have.

Is Your Stockbroker A Crook? (17)
Use all of the recommendations outlined in this article when evaluating your financial professional and you should do fine. Jim Pretin is the owner of www.forms4free.com, a service that helps programmers make HTML forms.

Introduction To The Forex Market (18)
However, individual traders are starting to get in the mix, using internet discount brokers such as Etrade to participate in the currency exchange market. There is no central exchange or meeting place for the Forex.

Stock Market Basics (19)
They allow you to place your market orders online, and the website itself is the broker. Internet brokers usually charge a much smaller commission than anyone else. A full-service broker offers a wider array of investment vehicles for you to put your money into, such as stocks, bonds, derivatives, annuities, and some also sell life insurance.

The FOREX Market Is A Goldmine (20)
base currency. The Forex markets are generally considered to be less volatile than then stock market because within the course of a trading day, it is highly unlikely for the value of a single currency to move all that much.


Leave a Comment