How to use the spreadsheetWhenever you make a purchase:•add a row to the bottom of the spreadsheet (i.e. after the last transaction), entering appropriate formulas in K and L, and:–if you have a receipt ...enter the next file reference number in column B,write that file reference number on the receipt, andadd the receipt to your accumulated receipts(keep these in order so you can find a particular receipt easily);–enter the date in column C;–enter 100,000 in column D;–enter the payee in column F.•If the entry is in Canadian dollars, you enter the amount of the purchase in column I. If the entry is for a US-currency charge, you instead enter the US dollar amount in column G and a formulain column I; the formula decides whether to estimate the Canadian equivalent of the US value of the charge in column G, or to copy a Canadian equivalent value that you later enter in column H.When a statement arrives (see pages 15-16 for an example):•Assign it the next statement number in sequence.•Process each transaction listed on the statement, in order, assigning each a “posting order” sequence number. In particular, locate each such item on the statement, enter the statement number in cell D of the corresponding row on the spreadsheet, and enter the posting order sequence number in cell E.Verify also that the transaction amount shown on the statement is identical to the amount entered in the spreadsheet. If the transaction is in US dollars, the amount of the purchase will be shown both in US dollars (which you should compare with the amount you copied from the charge slip to your spreadsheet) and in Canadian dollars. In the latter case, enter the Canadian amount in column H.If — horrid thought! — you find a disagreement, you must examine your receipt to determine whose error it is, and either correct your spreadsheet or attack your credit card company and the merchant, as appropriate.•If you find an item on the statement for which there is no row in your spreadsheet, you have a choice. If you believe the charge is legitimate, then you make a row in the spreadsheet for it. If you don’t recognize the charge, then you call Visa and dispute the charge. For purchases made in person you can demand a copy of the charge slip, showing your signature, and if the merchant can’t produce the receipt, the charge should be removed from your account. For mail order purchases the situation is less clear. If you argue plausibly, the charge will probably be removed, provided you don’t have a history of making such claims Assignment 6Page of 813
regularly. Often it is worth discussing the charge first with the merchant, who may acknowledge an error and promise to tell Visa to credit your account. (But check your next statement!)•Finally, you change the last statement number in cell G2 and examine the statement balance at the bottom of the spreadsheet. If it agrees with the ending balance on your statement, you’re done. If not, you need to determine whether it was you or your credit card company that made the mistake.