$ MASH YOUR CASH: If you use one of the popular financial programs [such as Quicken, MSMoney, etc.] and have a hard time keeping current with making the daily entries, you can consolidate multiple cash transactions into one daily, weekly or even monthly entry. Typically small cash expenditures account for the majority of financial transactions, and they can be a real pain to keep track of.
For example, suppose you had $50 at the start of the week, got $100 out of the ATM machine and now have $35. You went to the grocery store several times, the gas station, a few fast-food spots and the hardware store. You may have receipts for some of these items and remember how much some items cost, but other expenditures you don't remember; besides making a whole list of small entries into your financial program isn't the most efficient use of your limited time.
  • Starting Cash $50
  • ATM Withdrawls $100
  • Ending Cash $35
  • Amount Spent $115
  • Rather than trying to reconstruct [and estimate] these transactions, allocate them to various expense categories based on prior patterns of expenditures. Review one or two month's prior cash expenditures, calculate the percentages that constitute the major expense categories, and allocate current cash transactions by the calculated percentages.


    97 CLEAN-UP: If you use financial software, before archiving the 97 data set and starting a new data set for 98, review your account balances for accuracy and completeness. Even if not yet paid, record amounts you owe for 1997 as well as income you have earned in 97 but not yet received. Typical unrecorded expenses/income include utilities, taxes, interest, insurance as well as holiday purchases made by credit card and year end bonuses. Make estimates if actual amounts are not available.
  • 1 - For income earned but not received by the end of 1997, create a Receivable [asset] account. Record the expected income to the Receivable with a credit [increase] to the applicable income account.
  • 2 - For expenses incurred but not recorded/paid by the end of 1997, create a Payable [liability] account. Record the expense to the Payable with a debit [increase] to the applicable expense account.
  • 3 - For further information on how to adjust account balances see MONEY SOFTWARE - in particular the subject covering Integrity of Accounts.
  • 4 - If you expect a material income tax refund in 1998 for 1997, record this expected refund in 1997. This may well cause a debit, i.e. receivable, balance in your tax liability account, but will accurately reflect the income tax expense for the year.
  • 5 - When each item that was recorded in 97 to an asset/liability account is received/paid in 98, the clearing entry is made to the Receivable/Payable account in 98, not to income or expense. If there are differences between the original entry and the final receipt/payment, then an adjusting entry to income/expense can be made which will clear to zero the unresolved difference.
  • 6 - NOTE: Most financial software has an "archive" option. By archiving prior year's transactions, your new data set will be much smaller, your program will run faster and the necessary periodic back-ups will take less time.

  • CORRUPT DATA SETS: On occasion or even more often, a data set for a financial program becomes "corrupt"; the program's "exe" file cannot open your personal financial data. There are various solutions/ workarounds to this problem. Remember, although a fully functional data set is the ideal condition, what you really are aiming at is the recovery of your data which may be accessible in another format.
  • 1- Replace the corrupted set with your back-up set, if you have one. Before replacing the corrupted data-set, save it to a new location; you may be able to recover data that post-dates the back-up set.
  • 2- Many financial programs have a restore/re-index function which can straighten out the problem.
  • 3- Look in your "Temp" folder or other locations; sometimes an improper shut-own puts your data set in limbo as a "tmp" or other type file [such as an .01 file].
  • 4- Run scandisk; part of your data-set may be corrupted and scandisk may be able to recover it or create a useable "chk" file.
  • 5- Call Tech support; they may have suggestions. But be advised; they may charge for data recovery and/or want you to send them a copy of your data set which exposes your private financial data.
  • 6- If you have another financial program which is "dormant", try the export/import function.
  • 7- Re-install the program from the original disk[s].
  • 8- Use the "Quick View" function and/or a word processing application to "read" the data set files. Often you will be able to find your account names, entries and scheduled transactions which you can re-construct into a new data-set. Most any file on your hard-drive, regardless of type, can be "opened" with a standard word processing program; although it will act as a word-processing file in this mode, you can recover data from it.
  • 9- Future problems can be minimized with current back-ups, running two different financial programs simultaneously [using import/export to save time if desired], and/or periodically printing to disk or paper current financial information in your data set.

  • COMPRESS FINANCIAL ENTRIES: If you want to track your profit/loss but can't be bothered with all the accounts and myriad transactions, you can boil them down to two account types and one entry per day or less. There are only two account types:
  • 1- REAL ACCOUNTS - These are all the Balance Sheet accounts, that is the Assets and Liabilities.
  • 2- NOMINAL ACCOUNTS - These are all the Income Statement [AKA Profit and Loss] accounts, that is the Income and Expense accounts.

    Since a net debit [increase] to Real accounts is a net credit [profit] to Nominal accounts and conversely a net credit [decrease] to Real accounts is a net debit [loss] to Nominal accounts, all financial transactions over a time period can be reduced to one. [The vernacular term "in the black" describing a Profit refers to the Real accounts; the simultaneous condition in the Nominal accounts would be "in the red".] Even if you only have a spreadsheet program or happen to use investment software [such as Fund Manager, Fidelity Investments, Wealth Builder, etc.], you can create a Profit/Loss account to emulate financial software that will track your ongoing financial activity.

  • EXIT ON CANCEL: When trouble comes, many of us blame the computer, the operating system or the current program. But sometimes the trouble is of our own making. There are a few simple routines you can use to avoid these troubles:
  • 1- When working in dialogue boxes, where you can change settings or delete items, always EXIT the box on the CANCEL option unless you purposefully want to change a setting and know what your old setting was. Do not select the OKAY option just to close a box; exit on CANCEL; you may have inadvertently changed something.
  • 2- Backup often. And create new registry back-ups, and emergency recovery and system disks.
  • 3- When working on long files, SAVE your work at various intervals.
  • 4- Don't delete files unless you are sure of the outcome. Save a copy in a safe location until you are sure you won't need it.
  • 5- If you deleted E-mail you want to read again, many e-mail providers have an option where you can save recent e-mail on their server. For instance for AOL, access MAIL on the MENU Bar and select Mail You've Read/Sent; AOL will save mail up to seven days if you so choose.
  • 6- When "reading" files in their non-native applications, such as using a word processor to open a "dll", "exe", "ini" or scandisk created "chk" file, do not save the original file in the word processing format.

  • RE-TARGET SHORTCUT
    When you click on a shortcut that gets a message that the target is missing, it may be because you moved the target to a portable disk. Windows will try to find the target and even suggest an alternate location, but Windows does not generally look on portable disks.
    Missing Shortcut xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    x
    f Windows is searching for Games. To locate the
                         file yourself, click Browse.                                                        
    You can select the "Browse" option to find the target, but to re-target the old Shortcut, right click on it. Then select "Properties" from the drop-down menu. In the Properies dialogue box, select the "Shortcut" tab; change the drive letter [i.e. C in this case] on the "Target" and "Start in" lines. You can also "jazz" up the shortcut icon by selecting the "Change Icon" option.
    
    Open
    Explore
    Explore From Here
    Find...
    DOS Prompt Here
    Desktop
    Add to Zip
    NConvert ..... >
    Contents .....>

    Target ....... >
    Send to ...... >
    Cut
    Copy

    Create Shortcut
    Delete
    Rename

    Properties
    Games Properties xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    ?
    X
    __________________
    . . . _0_______Games

    ..Target type:. . .. . . . .. . . . . . . . . .xxxxxxxx

    ..Target location: . . . . . . . .C:\

    .. Target:..... . ....


    .. Start in:...... . ....


    .. Shortcut Key:...... .


    ..Run:                                 . . .. . . . .

    ......... . .... . ..
    . . .
    . . .
    .... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
    After correcting the Drive letter, check the related "ini" file [if any] in the Windows folder. References to the old drive letter should be changed to the new drive letter.


    IDLE WEB SPACE?: Do you have empty web-space from your ISP or other servers? {AOLers have 10MB available; several providers offer from 200KB to 3MB for free.} There are a few ways to use it other than storing a web-site.
  • 1- If your correspondent has an E-mail program that cannot handle attachments, then use the WWW to send the files. As long as you both have access to the WWW, upload the file attachment through FTP. Then send the URL in the e-mail to your correspondent who can download the file. Alternatively you can write an HTML page with a download link to the attachment and upload it.
  • 2- If your hard-drive is low on free space, store files on unused web space in zip format. If you have a posted web-site that has reached its limit of byte space, start linking additional files to a different FTP directory. If you are taking a trip without your computer or portable drive and want access to certain files, upload the files to your web-space.
  • 3- If you like to send greeting cards [such as Birthday, Christmas, Valentines, etc.], make up a card, upload it then send it's URL to your friends via email. One "card" can accomodate multiple recipients.
  • 4- If you ever have lost the ability to access the WWW but can still connect to your ISP, often you can still connect to FTP. From there you can upload and download from your own directory or that of others.
  • 5- Have you lost or corrupted your web-site files on your own system or are not sure what are the last files you uploaded? Then download files from your own FTP directory to recover them.

  • E-MAIL COOKIES: If your E-mail server only supports plain text, then the URL addresses must be converted to live links to access the web-sites. But with an HTML E-mail server, the links are live; this is very handy and time-saving. But there is a price to pay - COOKIES. Since HTML e-mailings are much like web-pages, the sender often attaches "cookie" files with the principal "letter". The e-mail cookie looks similar to a web-site cookie, such as this one received when using the Netscape e-mail program:
    Netscape xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    x
    ?   The server ad1.xyz.com
            wishes to set a cookie
            that will be sent
            to any server in the domain xyz.com
            The name and value of the cookie are:
            SB_ID=0724099831627945631073910456382
    
            This cookie will persist until Fri Dec 31 05:00:00
            1999
    
            Do you wish to allow the cookie to be set? 
    If you accept the cookie, a line of text will be placed in the "cookies.txt" file in the Netscape directory. {Internet Explorer's cookies are in the Temporary Internet Files folder as "txt" files.}
    For further information about "cookies", how to handle them, and how to set your browser preferences please see Are the Cookies Watching You?


    STRIP THE PIX: Often when browsing the web, you run across banners that have some picture elements in animated gifs that are very attractive. You would like to incorporate these elements in a picture of your own, but, of course, you don't want the advertising or some other elements. With a little free software [such as an animated gif program], you can strip off those pictures you want. When you see a banner you like, either save it directly or snatch it out of your cache folder. Using the "animated gif" program, open the file and select the "image strip" function. The result will be an entire strip of all the individual pictures. Save the strip in a format you can work with [such as "gif" or "bmp"]. Now you can cut out the pictures you want from the strip using a standard graphics program and save them as individual files with which to build your own pictures.


    V ARISE FROM THE DEAD: When a shareware program expires because of the time limit [commonly 30 days], if you reset your computer's date, often the program will work. Instead of making a shortcut to the expireware's "exe" file, make it to the program's folder. Inside the folder, create a "txt" file entitled "STOP-RESET DATE.TXT" whose contents enumerate operable dates. Before opening the expireware, reset your computer's date. A shortcut to the date/ time function [located in the Control Panel] can also be placed in the same folder. [Note: when making a shortcut from the date/time function, Windows95 will advise that the shortcut will be placed on the Desktop. From the Desktop, just copy or cut the shortcut and put it in the desired folder.] When you have finished with the program or just after you open it, reset the date to the current day.


    { WEBSITE WALLFLOWER?: Is your web-site lonely? Nobody but you ever seems to stop by for a look. A little free self-promotion is in order:
  • 1- List your site with Search Engines and Directories. If a description of your web-site is requested, use Keywords which cover broad categories.
  • 2- When you visit other web-sites, look for an "Add URL" graphic.
  • 3- Add Meta Tags to your web-page's Header using terms which "generously" describe your site's contents.
  • 4- Request Links [with description and graphics if possible] to your friends and correspondents web-sites.
  • 5- Announce your Web-site via E-mail with your correspondents- use Live Links if your e-mail supports them.
  • 6- Offer "freebies" or links to sites which offer free stuff.
  • 7- Enter your homepage in a Web-site contest. Be aware there are a few tricks and winning strategies to make your site do well in these contests. For some helpful tactics, see Everybody Wins This Contest.

  • LOST DLLS: Sometimes after a "crash" or re-installation of the Operating System, certain system files may be lost which are needed by some of your older programs. Old system files such as "mfcoleui.dll" or "cmdialog.vbx" may turn up missing. There are a few places you can look to obtain a replacement:
  • 1- Backups of your Windows/System folder. [Backing up this folder periodically can save future time and trouble.]
  • 2- Libraries of archived files that "clean-up" and/or "space- saver" programs make.
  • 3- File libraries on the WWW that are maintained by various companies and the FTP directories of such organizations as Winsite, Simtel and Microsoft.
  • 4- Web Search Engines can be useful tools for finding information about similar missing files which other users have experienced.

  • 4 PAGE AFTER PAGE: When you get involved in reading a web article that goes on for page after page after page, there is a faster way to get the entire article into your system so you can read it later at your leisure. As soon as a page loads, scroll down to the bottom of the page and click Next Page. Keep loading all the pages until the end of the article is finally reached. Now the entire article is "cached" where you can read it offline. [See Item #36 for instructions on how to use your cache files.] If you didn't have time to load all the pages of the article, when you are in the cache folder, right click on the "Next Page" of the last page loaded. Select the function that copies the URL to the next page in the article. Paste this URL to your Bookmarks/Favourites; next time you go online, you can resume downloading the rest of the article.

    NEXT PAGE
    Send Mail to:OJATEX@aol.com