blogPg5_monPay.html eMONEY: A USER GUIDE

The purpose of this exercise is to list all Monthly Payments.



MONTHLY PAYMENTS DEFINED

You may recall that Monthly Payments are payments due each month, on or about the same date, usually for the same amount, and for which you receive a statement. They are easy to estimate and set aside money for because the amount and due date are known in advance. That's what scheduled expenses are; expenses for which the due date and amount are known in advance.


THE MONTHLY PAYMENTS TEMPLATE

The table headings are LINE ITEM (generic expense name), # (acct no.), DUE (date), and AMOUNT.

Monthly Payments are listed chronologically, by due date, to make it easy to tell where you are in the monthly cycle. But there's a wrinkle.

Due dates falling on the first or second of the month are problematic. To avoid unnecessary complications (explained below), due dates falling on the first or second of the month should be considered due on the previous 28th. Where you have the option to choose a due date, choose dates from the 3rd and the 28th, inclusive.

Below is an example of a completed Monthly Payments table, one that might be used by a high school senior working and earning her own money, living with her parents.

The Monthly Payments table (below)



The MONTHLY PAYMENTS table ...

To

To.

INSTRUCTIONS

  1. Do.
  2. Do.



In the example above, as in all other tables in this guide, column and row headings, as well as labels, are shown in black (blue) font, income in green, and expenses in red. Totals and Subtotals are either black or red, depending on whether the result is positive or negative.



Read more, or proceed.




INCOME DEFINED

A Monthly Payments table for a single person, or couple who are, themselves, their sole means of financial support, would contain many more items, like Rent, Water, Electricity, Heat, Phone, perhaps redit ard payments, may be a car loan.

Download a sample workbook here. Make a copy of workbook for personal use, and save the original (in case something goes wonky). You can always download another sample workbook if need be. And I welcome any suggestions you might have for their improvement. But it's a good idea to reserve the download as a back up, and work from a copy.

Please confine your entries to within the rectangle defined by a blue border. You should not need to edit the Column Headings, and the Amount column displays the results of hidden formulas that should not be overwritten.

I have locked the sample workbook, so that it cannot be Edited. However, that protection does not extend to copies. You may protect parts of the worksheets yourself by selecting  Data > Protect sheets and ranges.

Add rows below row 6. If you add rows below row 7, the worksheet will not calculate the TOTAL correctly.




"Success is measured not by the scope of our possessions but rather, by the extent to which we are able to live life on our own terms."



Nashville, IN USA

Email

MONEY: A USER GUIDE

© 2023 Richard Stringfellow



Design: HTML5 UP

*