PerfectParser Docs
User GuidesParser Setup Guides

Utility Bill Parser Setup Guide

Step-by-step dashboard guide to configure a utility bill parser, define fields, run bulk extraction, and export results.

Before You Start

Before setting up your parser, ensure you have:

  1. A PerfectParser account (sign up at perfectparser.com).
  2. A healthy credit balance (each utility statement page processed consumes 1 credit).
  3. A sample utility bill (PDF, PNG, or JPEG) to use during the parser setup.

When creating a new Utility Bill Parser, choose the document organization structure that matches your files:

  • Single Document Per File: Select this option if each statement file represents a single month's bill (even if it spans multiple pages of consumption charts).
  • One Document Per Page: This option is rarely used unless you scan multiple single-page bills together.

We suggest configuring the following schema fields for your Utility Bill Parser to capture all essential utility billing data.

Field NameTypeDescription
provider_nameTextThe company billing you (e.g., British Gas, PG&E, Comcast).
account_numberTextThe utility customer account ID.
invoice_numberTextThe unique billing invoice number.
billing_periodTextThe statement date range (e.g., May 10 to June 9, 2026).
due_dateTextThe deadline for the payment.
current_chargesNumberCharges incurred during the current billing cycle.
previous_balanceNumberUnpaid balance carried over from previous months.
total_amount_dueNumberThe overall total balance due.
usage_detailsTableTable containing metrics like service_type (e.g. Electricity, Water), usage_amount (e.g. kWh, Gallons), rate, and total.

AI Instructions (Optional)

To help the AI parser extract field values with maximum accuracy, copy and paste the following prompt instructions into the AI Instructions (Optional) field during setup:

Extract the utility provider name, customer account number, billing invoice number, billing period, payment due date, current billing cycle charges, previous balance, and total amount due. Also extract the usage details table containing the service type, usage amount (with units like kWh), rate, and subtotal.

Step-by-Step UI Setup

Follow these steps to set up your Utility Bill Parser using the single-page setup in the PerfectParser dashboard.

Step 1: Create the Parser

Log in to your dashboard, click Parsers in the left-hand navigation menu, and click the New Parser button.

Step 2: Configure Name and File Organization

In the Parser Details & Setup section:

  1. Enter a clear, recognizable name in the Parser Name field (e.g., "Utility Bills").
  2. Choose your document structure under How are your files organized? (e.g., select Single Document Per File).

Step 3: Upload your Sample Utility Bill

Upload your sample document by dragging and dropping it into the upload box on the left-hand Sample Document Preview panel, or clicking the box to choose a file from your computer.

Uploading a sample utility bill in the New Parser screen

Step 4: Run Auto-Detection

Once the document finishes uploading:

  1. Copy the prompt from the AI Instructions (Optional) section above and paste it into the AI Instructions (Optional) box.
  2. Click the Auto-Detect Fields button. The AI will analyze the sample document's layout and suggest extraction fields within 10 to 15 seconds.

Step 5: Verify and Refine Fields

Review the generated schema on the right. You can rename fields, change data types, or edit the helper descriptions to guide extraction. When you are satisfied with the schema, click Create Parser at the bottom right.

Reviewing and configuring detected fields in the parser schema editor

Step 6: Run a Batch Extraction

To process your utility bills:

  1. Click Bulk Extraction in the left sidebar or the top header.
  2. Select your newly created Utility Bills parser.
  3. Upload one or more utility statement PDFs. PerfectParser will start extracting data immediately.

Starting a new bulk extraction batch

Step 7: Export Extracted Data

Navigate to Batch History in the left sidebar or click the Batch History tab on the parser details page. Click Show Files to inspect individual statement extractions, view confidence scores, and verify the structured output.

Viewing files and inspecting confidence in Batch History

To download your structured data:

  1. Click the Export button on the completed batch card.
  2. Select Export as Excel or Export as CSV from the dropdown menu to download the structured table directly to your computer.

Exporting the structured extraction results to Excel or CSV


Developer Integration

If you want to automate utility bill parsing programmatically inside your applications:

Looking for product features and use cases?

See the Utility Bill Data Extraction solution page.