First, within or below this article I will include a sample record of Excel checkbook (or a link to it) you can use to experiment or even use as your checkbook register. It would be better if you can access this file before reading. I began this creation by simply building an Excel worksheet that looked like a check register with all or some columns you want. I have two columns of figures, one for the amount of the transaction and another to the new equilibrium. However, with Excel, you can insert a formula in the "balance" for the new balance is calculated automatically. The formula would be the cell of the previous "equilibrium" at 'F3' my sample, plus the amount of the following transaction ('E4'). The formula is = (F3 + E4). Note that you will always be '+', entering retires as you enter them '- $ 50.00 (note negativa'-'). You only need to enter the formula once and then copy and paste it below the cells. Excel will automatically adjust the formula for the placement of the cell (s) you paste it into.You may notice that in my examples I put a variety of codes such as 101, phone, online, EFT and R3. It is seen how the payment was made. A number is just a check number. "Phone Codes, online" and "EFT" refers to payment by phone, online payment and electronic funds transfer (or automatic transfer), respectively.
No comments:
Post a Comment