How to Enter Constellation Bills into QuickBooks Using Text Blaze

Learn a quick and efficient method to enter Constellation bills into QuickBooks using a Text Blaze snippet. Follow our step-by-step guide to streamline your billing process.

10 May 2025 By Tim Moody

In this guide, we'll learn how to efficiently enter Constellation bills into QuickBooks using a Text Blaze snippet. This process involves duplicating previous bills and updating necessary details, ensuring accurate financial records. We'll also explore how to navigate Constellation's website to retrieve billing information and use QuickBooks' features to streamline the entry process. By the end of this guide, you'll be able to manage these entries with ease.

Example 1

In QuickBooks: open the Vendor Center and pull up Constellation Energy's account

Step #1: Click on "Vendors" — Click on "Vendors"

Step #2: Click on "Constellation Energy Services of NY" — Click on "Constellation Energy Services of NY"

You'll notice there are six bills per month, similar to National Grid. They are always dated on the last day of the month. Currently, I'm adding the March bills and reviewing the February bills, all dated February 28th. I'll pull them up, duplicate them, and make necessary changes.

In your browser: pull up Constellation Energy's website

Go to their website. I'm using Vivaldi, but there's also a bookmark in Chrome that leads to Constellation's website. A link is provided at the bottom of this guide, also.

Click on the email address or phone number field. A dropdown will appear, and you can select it. (if it doesn't, you may not be logged into Bitwarden)

Step #4: Click on "exretailb2c.b2clogin.com" — Click on "exretailb2c.b2clogin.com"

That will log you in. Once logged in, you will see the balance summary at the top.

After entering all six bills into QuickBooks, we should see this number for the total.

Scroll down to view the billing history.

The top six are the ones we want, and it also shows some from the previous statement below.

Take note of two things quickly. Unlike National Grid, this website does not list which cabin it is. The only way to differentiate is by the number following the dash at the end of the customer billing group number.

You have -5, -0, -3, -4, -1, and -2. In QuickBooks, you'll see the same numbers followed by the cabin or building they correspond to. (In QuickBooks, it's organized in a way that makes sense - you know, in numerical order... 🤔)

Step #8: It's laid out from -0 to -5. On their website, it's not, which is a bit frustrating, so pay close attention to that. — It's laid out from -0 to -5. On their website, it's not, which is a bit frustrating, so pay close attention to that.

You can proceed in any order, but I'll start in QuickBooks and go down the list. We'll begin with -0, and if I look at Constellation, the second line is -0.

Copy the $$ amount for the bill you're entering!

You need to copy the amount of money. If you don't, you can't use this snippet correctly, because it will paste whatever you've copied into the amount field.

Tip: Double-click the amount to highlight it, then right-click and choose Copy.

Step #9: Double-click on "$183.75" — Double-click on "$183.75"

Step #10: Right-click on "$183.75" — Right-click on "$183.75"

Step #11: Click on "Copy" — Click on "Copy"

Duplicate the previous month's corresponding bill

Open QuickBooks and locate the corresponding bill from the previous month.

Step #12: Double-click on "02/28/2025" — Double-click on "02/28/2025"

Click "Create a Copy," then STOP!!

Step #13: Click on "Create a Copy" — Click on "Create a Copy"

When the "Duplicate Bill" prompt appears on your screen,

DO NOT click "OK" !!

Step #14: DO NOT CLICK! — **DO NOT CLICK!**

Immediately type "/con" without the quotations

(con is short for Constellation, not Trump!)

This single snippet does everything else for you, and in a few seconds, you'll find yourself back at the account screen.

Verify it worked correctly

Look up and you should see that a duplicate bill was created and dated at the end of the previous month.

Step #15: Voila! It worked 👍 — Voila! It worked 👍

Check the details. Today is April 24th, and this bill is dated March 31st - perfect.

The amount matches exactly with what we copied from Constellation's website - perfect.

Example 2

Now, you can bring up the next one, which is -1, for the Gate Cottage.

Step #16: Double-click here — Double-click here

Click "Create a Copy."

Step #17: Click on "Create a Copy" — Click on "Create a Copy"

Then, return to the browser and look for "-1," which is the sixth option down, as their website is not intuitive.

Double-click on the amount of money to highlight it, then copy it using your preferred method.

Step #19: Double-click on "$ 146.60" — Double-click on "$ 146.60"

For example, you can use a keyboard shortcut instead of right-clicking, if you prefer.

Type "Ctrl + C"

Return to QuickBooks.

Step #21: Click on "A duplicate Bill has been created . and save the Bill ." — Click on "A duplicate Bill has been created . and save the Bill ."

Sorry, graphical glitch - not sure why it is displaying like that in the above image.

Do not click "OK" on that prompt. Instead, type /con

Quickly check, and you should see that the bill has been duplicated and dated March 31st with the new dollar amount.

Step #22: Click on "Accounts Payable" — Click on "Accounts Payable"

Repeat this for the remaining items. Once you get the hang of it, the process is very quick to enter all 6 bills.