Meanwhile, until someone devises a method of doing that winnowing and filtering of credit card purchases and payments, you may want to record those payments as being in the "Credit card" 'category', and live with the misleading pie chart, that in Apple's '09 example cost about the same amoount as the "Home" category.Ĭolumn E is to contain the amount of each recorded transaction, starting in cell E3. That could be done using another table to record and categorize CC purchases, then report the individual amounts to the Summary table, and the total amount of the CC payment recorded as an uncategorized expense (not picked up by the categories listed on the summary table). Credit card purchases do not come out of the chequing account on the day the purchase is made, but are gathered into a group, billed to the card holder on the billing date, and paid in full or in part by the due date, at which point, those funds come out of the account and the account balance is changed, and the amounts of the original purchases should be added to the amounts being tracked in the individual categories. The only payments that fit into Credit Card as a category are the annual fee on a 'premium' card, and interest chargees incurred when carrying an amount beyond the payment due date. Most card transactions are payments for items in one or more of the categories listed. One shortcoming in the original was the classification of "Credit Card" as an expense category, which it is not. A pop-up menu is used here for consistency. It is useful, though, to choose a single format and use it consistently.Ĭolumn C is for a brief description for each transaction.-where did the money go, or where did the money come from.Ĭolumn D is used to list the category of each expenditure. The all-number format used in the '09 version is not mandatory. The content of column B is the date for each transaction. Number entries are always payment by cheque, and, as these are different for every cheque, must be typed into the cell after deleting the pop-up menu from that cell (following the steps noted in column B). Notes in column B refer to the entry methods for the payment method of each transaction. Notes on the table diagram tell what type of data is entered in each column, nd what entry method is used. Data entry, other than the opening balance amunt in F1, begins in row 3.Īll data on the table, with the exception of the values in column F are entered values, entered either directly from the keyboard or chosen from a pop-up menu in the cell. Here's an image of my revised Register table, with notes on the contents of each column. The original template had two tables, The larger one is a register of checks and other spending from a checking account. Here are some reconstuction notes on the '09 template. The same template evolved into the Personal Budget template in later versions. Numbers '09 offered a Checkbook Register in it's Templates Chooser.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |