Tuesday, April 30, 2013

Using and Modifying Categories

Income and Expense categories are the designations that enable totals to be identified and grouped.  In our Pagemonth Budget spreadsheets the broadest category designations divide into the 500's for Income and the 100's for Expenses. 

Income (any amount that increases the home checking account balance) is further broken down as coming from the User, Spouse, or Other sources.

Income 501 (User's Income) includes regular or occasional payments to the budget's owner such as salaries, commissions, bonuses, social security and pension fund deposits.

Income 502 (Spouse's Income) includes regular or occasional payments to the user's wife, husband. or partner such as salaries, commissions, bonuses, social security and pension fund deposits.

Income 503 (Other Income) includes deposits into the home checking account from any other source, such as rebates or refunds, gifts, and checking fee adjustments, or income from miscellaneous sources.

Expenses (any amount that decreases the home checking account balance) are broadly grouped in our budgets into Regular, Other, or Charged.

Regular 101-119 Expenses include monthly or periodic payments for savings accounts, housing, food, clothing, phones, utilities, home maintenance, insurance, cash, credit providers, and loan payments,

Other Expenses 120-129 are paid occasionally, not monthly or periodically, including recreation, gifts, medical, professional, clothing, repairs, maintenance, gas and oil, tolls, and interest fees.  They are paid by cash, check, or debit card.

Other Expenses 130-140 include occasional deferred payment charges, including recreation, gifts, medical, professional, clothing, repairs, gas and oil. and tolls.  They are paid to credit card providers.

All of our spreadsheets provide an Other Expenses/Charges Summary box on the budget, right-
hand side of each month page, just above the bottom Summary, which totals these items for that month. 

Categories are used only on the budget side  and do not appear on the cashflow, left side of our spreadsheets.  They do, however, appear for each income, expense, and charge category in columns E and F as updating, annual totals to the nearest dollar.  And they are finally grouped once more on our Summary Page to the right of January's data.

Pagemonth Budget users may modify any cells, categories, or formatting of any items in our spreadsheets for their individual needs or uses once purchased in Excel or MSWorks versions, available at the bottom of our homepage,.  The only thing they are prohibited from is selling them, as our designs and formats are protected by copyright.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.