Meter Reading Reports
Top 


The three meter reading reports are identical except for which meter fields they report. Any of these reports may be disabled, if the corresponding Site Data Fields for meter support are disabled. They show the site name, the current occupant (the reservation scheduled for today, if any), the last reading date, and the last reading. Reservation access level is required to view this report.

These reports show the current meter reading as well as an input field to "batch" enter new readings (which can also be used for recording the readings on the printed report). If the Rates are set up properly for automatic charge calculation, this is the easiest and quickest way to add meter charges to reservations. It can also be used to adjust the readings for sites with no reservation.


Setting Up for Meter Support

Before using these reports, you'll need to have some things set up for meter support. Refer to the "Setting up for Electric, Gas and Water Meters" section in Maintenance for details on setting up the database for doing meter readings.


Report Settings

Show only sites with previous readings -- This is selected by default, which generally will be any sites that actually have meters. If you want to see all sites even if they don't have previous meter readings (such as when entering readings for the first time), uncheck this box.

Filter by last reading date -- This allows you to select a date range for the last reading. This is handy for getting a list of meters that need to be read (and customers billed) for the current day or week. By default, the start date will be 45 days ago and the end date will be 25 days ago, so it will show any readings up to 2 weeks "overdue" and any readings that will be "due" within about 5 days (assuming a monthly reading schedule. These dates can be changed as preferred, and the changes will be saved in terms of the number of days prior to the current day (so for instance the 45-to-25 days range is saved, not the actual dates).

Reservation types to show/charge -- Regardless of which sites are shown, you can select which reservation types to show on those sites. For instance, if you read all meters but only want to add meter charges to your Monthly reservations, then click Select Resv Types and select only the Monthly type. All non-monthly reservations will be hidden from the report (but the sites will still be shown). Therefore when new meter readings are entered in batch mode, the last reading of the sites with no occupant listed will be updated as, but no charges will be added to a reservation. In addition, you can use this to disable all reservation types, in which case no reservations will be shown at all. You can do this to enter the starting meter readings before adding charges the first time, or if you simply want a reading report with no reservation information.

Actual date of reading -- If you don't have time to do all of the bookkeeping on the same day that the meters are read, you can set this date to effectively back-date the readings. Not only will it show this date in the site's "last reading" information, but it will also use this date to determine which reservation (occupant) should be billed for the electricity (whoever was in the site on that date), and also which meter rates should be used (if you have multiple rates that depend on the date).

There may also be other cases where you want to set the "actual date" -- for instance if someone checked out yesterday but you didn't check the meter until today, and now someone else has checked in that site, then set this date to yesterday so that the previous occupant gets charged instead of the new occupant. Likewise, if the new season rates take effect today but you want to give someone the previous electric rates for last month's usage, back up this date to use the previous rates.

Show / charge previous occupant (up to 31 days prior) if the site is currently empty -- This can be handy if you only read meters once per month even though the occupant might have left sometime earlier in the month. Of course it would have no effect if a new occupant is already in the site (in which case you need to use the "Actual date" setting above), but if it's at the end of the season and nobody new is coming in, then you can use this option to make sure charges go on the last occupant even though they're gone already.

All of the options above are saved in the database and will be used the next time you use any meter reading report (all of the meter reports use the same option settings).

By default the list is sorted by site, but you can change this to any order you like. Once you have the list showing what you need, you can print the list. There should be plenty of room left on the paper to enter the new reading, so it can be used as a walk-around list.


Right-click and double-click

Functions to enter readings or view details are available on the right-click menu -- click on any cell that's not empty, such as the Site Name or Occupant. You can enter new readings and add the charges to the current reservation, or enter manual adjustments without charging a reservation. You can also view site details or reservation details.

Note that the double-click function is different depending on which column you click on and whether a reservation is shown:

Site Name -- Double-clicking in this column will open Site Details, where you can directly enter a meter reading without charging a reservation.

Occupant -- Double-clicking in this column will open Reservation Details. From there you could go to New/Edit Transactions to enter charges if desired (but there's a more direct way to enter meter charges, described below.)

Reading Date or Meter Reading -- Double-clicking on one of these columns will open a dialog where you can enter the new meter reading. However there is a slight difference depending on whether a reservation is shown. When the site has no occupant shown, you simply enter the reading and Save it, and the site's reading is updated. If there is an occupant shown, it will actually open the Transactions / Select Rates for the occupant's reservation and then the meter reading entry dialog. When you enter a reading here, the charges will be added to the reservation automatically. For more information, see Entering Single Meter Readings below.

Batch Reading Entry -- Double-clicking in this column will simply put the cursor in that field so you can enter a new reading for batch processing (see below).


Entering Single Meter Readings

You can manually adjust readings from the right-click menu (Site Details) or by double-clicking on any Site Name. This will open the Site Details dialog, where you can enter a new reading. Remember, however, that entering a reading this way will clear the reservation link so you won't be able to use the "View reservation read by" button, and also does not add charges to a reservation.

Select the Add Meter Charges to Reservation option from the right-click menu, or double-click on the old meter reading, to quickly enter a meter reading and have the appropriate charges added to a reservation. This will take you directly to the Transactions dialog with Select Rates opened up to show the appropriate rates definitions for the meter (electric, gas or water as appropriate). If there is only one rate available, that rate will automatically be used and all you have to do is enter the new reading. Just enter the new reading, (and the actual date of the reading if it wasn't today), and press the "Done (auto-close...)" button on the meter reading entry dialog to immediately close the transactions dialog and get back to the meter list.

Note that meter wrap-around is handled automatically, as long as the correct wrap-around figure is set in Maintenance / Park Setup / Parks. For instance if the meter only has 4 digits and the last reading was 9900 but it now shows 0200, just enter 200 and it will know that 300 units were used.

If you need to enter other charges or want to print a receipt immediately, then instead of using the "Done..." button, click Save after entering the new reading. The Transactions / Rates dialogs will remain open.

You can also open the Reservation Details for the site's current occupant by double-clicking the occupant name. You will then be able to use that dialog's New / Edit Transactions button to add a meter charge for that reservation as above (it just takes a few more steps this way).

After entering a reading (or multiple readings), you can use the Print buttons at the bottom to print receipts, envelopes, or labels for all of the reservations with new readings.


Entering Multiple Meter Readings (Batch Entry)

When many meter readings need to be entered and charges applied to reservations, the batch entry method is quickest. Just click on the empty "Batch Reading Entry" column for the site -- the cell will be blue (selected) -- and type the new reading, then press Enter or Tab to step to the next row. The new readings will remain in this column and will be in a light yellow color. As with single readings, wrap-around is handled automatically (if the wrap-around is within a 25% range). An error will be shown if the figure you enter cannot be understood as either greater than the previous reading or a reasonable wrap-around.

If you have linked/synchronized reservations, you may have the option to Handle synchronized reservations individually. If this box is checked, the meter charges for each site will be added to the individual reservations. However, other charges for synchronized reservations are usually added to the Master reservation instead of the individual reservations -- so to be consistent and avoid having to print multiple invoices, leave this option unchecked.

You can also select the date of the actual readings. This will not affect the date of the charges (that will always be the current day), but if the meters were actually read on a previous day, select the appropriate date here so that the information is correct on the sites. (If some meters were read on different dates, enter readings from each day one at a time, set the reading date, and Add Charges... then repeat for each additional day, resetting the date each time.)

IMPORTANT: When using batch entry, make sure that the Occupant column shows the names for all of the reservations to be charged -- if no Occupant is shown for a site, then the reading will be changed on the site without adding any charges to a reservation. If you don't see all of the appropriate occupants, then you probably need to select the correct type(s) in "Reservation Types to show / charge" at the top. You may also need to check the "Show / charge previous occupant" box if you're trying to add charges to reservations that already checked out.

Once all of the batch readings are entered, click the "Add Charges & Update Readings" button. Charges will be automatically applied to each of the current reservation (if there is a reservation for the site of the appropriate Reservation Type it will be shown in the Occupant column), and the site will be updated with the new reading. These steps may be repeated to enter more readings if necessary, just don't close the dialog before printing invoices or else it won't remember which ones need to be printed.

There are two Rates Setup requirements for adding meter charges automatically:

1. There must be one and only one meter rate defined (for that meter type) with the "Ask for meter reading" option that will apply to the current reservation on the current date. If there is more than one, an error will be reported and the reading will not be updated. Note that if you have multiple rates defined with different date ranges, it will use the one that applies to the current date, regardless of the reservation's dates.  
 
2. There may also be one other meter rate that does not have the "Ask for meter reading" option. This can be used for a non-multiplying "base rate" that applies each time the meter is read, for instance if your charges require a $5 per month base fee plus actual usage.  


After all of the readings are entered (using either the single or multiple method), you can print the invoices for all of the new charges, and also print labels or envelopes if needed. Using these buttons will open the appropriate dialogs to print Batch Receipts or Mailing Labels/Envelopes. Further options for printing can be found in those sections. As long as the Meter Reading report dialog is kept open, it will remember which reservations have new charges to be printed so you can use the print functions multiple times as needed.

Note: Be careful about using batch entry to enter "adjustment" readings or charges for short-term customers -- when using the "Add Charges" function, it will assume that the current reservation in each site should be charged for the meter. So if the wrong customer is already on that site when the readings are entered, the charges will be applied to the wrong reservation. In this case you should find the correct reservation and go through its Transactions / Select Rate(s) to enter the new meter reading. Or if it's just an adjustment with no charges to be applied to a reservation, use the Site Details to enter the new reading.

Page URL http://CampgroundMaster.com/snews/meterreadings.html

Campground Master Home