CashTrax is a Cash Tracking Budget Spreadsheet.

To begin make an ascii file named budget.cat. Each line in this file has a category name up to 16 characters. Maximum number of categories (lines) is 100. If a category name has a plus sign + in it then CashTrax will consider the category as income, otherwise the category is outgo.

Click on CashTrax.exe (alt-Enter toggles to full screen.)

You should see a spreadsheet with a category column, a Year To Date column, and Jan to Dec months columns. The current date is in the category column and headings row.

The next row in the category column is named TOTALS. Following are your named categories.

Keys Arrow keys moves cell -- the following moves page   PgUp,PgDn,Tab,Sh-Tab,Ctrl-rtArrow,Ctrl-ltArrow   Home homes to A5 cell   F1 this screen   --   any key to return   F2 edits cell specified   F5 goes to cell specified   Ctrl F6 deletes row below highlighted cell   F7 adds a new category row below highlighted cell   F8 copies cell content on left   F9 recalculates spreadsheet TOTALS and YTD values   F10 saves spreadsheet in SprdSh.txt   Enter ADDS edited numeric cell to previous value   Alt = replaces numeric cell with edited value   forward slash / ends the program   leading $ in saved filename makes printable files

Recalculation

After pressing the F9 key, CashTrax sums over the columns for each category going from Jan to the current month, putting the sum in the YTD column. Then CashTrax sums over the rows for columns YTD to the current month, putting the sum in the TOTALS row.

Ending CashTrax

After pressing the forward slash key CashTrax will ask if you want to return to the program. Entering N and CashTrax will ask for a 8-char filename. If you enter nothing, nothing will be saved. Entering a filename CashTrax will save the current spreadsheet in an ascii file you named with extention ".txt" . If you enter a filename with a leading dollar sign $, CashTrax will save (after stripping the $) five files. Ascii ".txt", ".YTD", and ".asc" files. The ".YTD" file has just the first two columns. The ".asc" file is a printable spreadsheet. The fourth file is ".htm" and the fifth file is a revised "budget.cat"

Restarting CashTrax with Saved Spreadsheet

Edit CashTrax.bat substituting your filename in place of file_name and then click on CashTrax.bat

If you do not specify a filename, then CashTrax looks for "SprdSH.txt" to import. If SprdSH.txt is not available then CashTrax starts a new spreadsheet reading budget.cat .