This article explains how to import current meter readings in bulk from the Meter Processing screen in RMS using a CSV file.

Overview

The Meter Processing Read Import allows properties to upload current meter readings in bulk using a two-column CSV file, rather than entering each reading manually on the Meter Processing Reading List. This is useful for properties that record meter reads externally (for example, in a spreadsheet) and want to transfer them into RMS in one step.

Import File Format

The import file must be a comma-delimited .csv file containing two columns in the following order:

• The file must be saved in a comma-delimited .csv format.
• Microsoft Excel can save files in a .csv format that matches these requirements.
• Fields must not contain commas.
• A header row is optional. The import will process correctly whether or not the column headers (Area, Current Read) appear as the first row of the file.

Importing Reads via Meter Processing

The Import option is available for all three utility types: Electricity, Gas, and Water.

1. Go to Utilities > Meter Processing > Electricity, Gas, or Water.
2. Apply the required filters (View, Property, Category, Rate Type) and select Refresh to load the Reading List.
3. Select Import from the Reading List toolbar.
4. Browse for and select the prepared .csv file.
5. Confirm the import. The Current Read values are populated on the Reading List.
6. Select the checkbox next to each reading you want to process, then select Process from the toolbar.
7. Review the calculated charges and select Apply to post the charges to the reservation accounts.

< Previous Article: How to Process Meter Reads