Systrends Updates

Systrends eTariff Submit To Sandbox Tips

Systrends News Bites - 14 hours 14 min ago

There are a couple things that users should be aware of when it comes to submitting to the FERC Sandbox from eTariffManager.

1. You can submit to the Sandbox before generating an "actual" XML. Clicking the Submit to FERC Sandbox will generate a temporary XML in the backend, based on what is in the filing at the time of clicking the button.

2. If you get a validation error from the sandbox, you can correct your filing and resubmit. (Same goes for actual filings). You can submit the same filing ID to FERC if you received a Validation Rejection

3. PRIVILEGED and CEII documents are not put into XMLs that are sent to the Sandbox. This is for security purposes because the sandbox is an open port and the file can sit in the public folder on FERCs end for several minutes or hours before being picked up. You do not want public having access to them.

4. Because privileged documents are not sent the sandbox, it will not validate the rule regarding: For every "Attachment Reference" that is marked Privileged (or CEII) there must be a corresponding Public version of the "Attachment Reference"  - So please be aware of that.

5. It was discovered that the software is not enforcing the FERC size limit of 50MB per XML zip file when generating the Sandbox XML, but does enforce it when generating the actual XML. So you may have an XML larger than 50MB go through Sandbox, but not get generated in the queue.


Forums: Systrends News

eTariff Filing Tip: Original Filenames are going to FERC

Systrends News Bites - Thu, 05/28/2020 - 11:42
AttachmentSize FileName.png15.19 KB

There has been a change with eTariff 3.0 regarding filenames of attachments (and sections).

In version 2.0, the eTariff software would change the filenames of attachments (and sections) to a unique name, which was placed in the XML and sent to FERC.

Which meant the "unique filename" would appear in the FERC elibrary like this:

Now that version 3.0 will show the file name that you load it will look like this:

This means you should watch for 2 things when it comes to file names:

  1. You should make sure the filename is how you want it to be seen on FERC eLibrary
  2. Filename length limit (per FERC rules) is 60 characters!

If your file name is longer than 60 characters INCLUDING the format extension (.pdf, .docx, etc.) the software is going to cut off the beginning of the filename until it only has 60 characters total.

If you want to verify how the filenames will appear on FERC, just look at the filenames you loaded the Attachments Tab.

The Attachment tab shows the filename at the 60 character limit which is how they will appear in the XML and FERC.

So if you see part of your filename is cut off, that is because it is longer than the 60 Character (including file extension and spaces) and the software cut it down. So if it is not showing in the Attachments Tab how you would like, then you will need to shorten the filename

This is an example where the Attachment B is cut off at the beginning and not showing the company name like the other files.

If you want the first word showing (in this example "Garden"), then it is best to shorten the name by removing some words (or abbreviating) in the middle of the filename until the first word appears.

Forums: Systrends News

FERC Extended Deadline for Order 860

Systrends News Bites - Wed, 05/20/2020 - 14:13

FERC just released a notice that they are extending the implementation and filing deadlines for eMBRdata by 6 months


Forums: Systrends News

Check Out Systrends Promo Video

Systrends News Bites - Wed, 05/13/2020 - 07:35

A new promo video for Systrends has been posted. You can view it here

(opens in YouTube)

Feel free to let us know what you thought?

Forums: Systrends News


Systrends News Bites - Tue, 04/28/2020 - 10:01

If you are working from home during this unprecedented time and are connected to your company VPN and now find yourself having issues loading files into EQR or eTariff, try disconnecting from your VPN first and see if it will load.

or contact your IT department to see if they can allow for file transfer or uploading through the VPN to the specific url link to the application. 

Forums: Systrends News

New EQR Validation started Q1 2020

Systrends News Bites - Fri, 04/24/2020 - 07:21
AttachmentSize Example.png50.15 KB

The new FERC Validation states:

  • Rate Units must be equal to the Standardized Units (i.e. $/MWh or $/MW‐Month) if Transaction Quantity equals Standardized Quantity.
  • Rate Units must be equal to the Standardized Units (i.e. $/MWh or $/MW‐Month) if Transaction Price equals Standardized Price.

What this means is when you have MWh for Energy and MW-Mo for Capacity then you use the Standardized Quantity and Standardized Price columns and they should match the Transaction Quantity and Transaction Price columns.

If you have Flat Rate - Then the Standardized Columns should be Blank

Is you have KWH Or KW-Mo then the Transaction Price and Transaction Quantity will not be the same as you have to do the conversion in the standardized columns.


Forums: Systrends News

New eTariff Validation effective May 18th, 2020

Systrends News Bites - Mon, 04/20/2020 - 09:49
Take notice that, effective May 18, 2020, FERC will be implementing an updated validation error code    The new error code 176 will check to ensure that filings using the “Normal” or “Amendment” Type of Filing codes 
contain at least one actual tariff record that must be set to a change type other than Pro Forma.    If all the records/sections in the filing are pro forma change type then you will receive the validation error.
  For multiple records/sections in the filing you can have pro forma but at least one section must be set to another change type (new, change, cancel, etc.)   The filings codes that are effected are:   For Program Code E (TCS companies) – Filing codes 
  • (normal) 10, 20, 260, 280, 320, 340
  • (amendment) 130, 180
For Program Code M (MBR companies) – Filing codes 
  • (normal) 30, 60, 270
  • (amendment) 120, 170, 
For Program Code G (NGA Gas) – Filing codes 
  • (normal) 570, 630, 640, 650, 660, 680, 690, 750
  • (amendment) 600 
For Program Code K (NGPA Gas) – Filing codes 
  • (normal) 760, 1260, 1300, 1310, 1370
  • (amendment) 1270, 1350
For Program Code O (Oil companies) – Filing codes 
  • (normal) 830, 860, 870, 890, 920, 930, 960, 1070, 1250
  • (amendment) 1230
For Program Code F (Power Administrations) -  Filing codes 
  • (normal) 1220
The Commission’s eTariff system will reject filings violating this error code.
  So, Filings containing exclusively Pro Forma tariff records will receive the following rejection error in the validation email.   ---Error List
Failed Code 176: The filing category chosen requires the filing of at least one
actual (non-pro forma) tariff record.   Please note:
If you have ONE tariff record in one of those filing codes above and it is set to pro forma change type, you will get the validation error (rejection).
  But, if you have multiple records in the filing, than 1 or more can be set to pro forma but you must have one set to new, change, cancel or withdraw and you will not get the validation error. If you have any questions you can contact me ( or Michael Goldenberg from FERC ( Forums: Systrends News

EQR Deadline Extended to June 1, 2020

Systrends News Bites - Thu, 04/02/2020 - 09:28
To further provide relief to entities that are unable to meet deadlines due to
the ongoing impact of the COVID-19 emergency, pursuant to sections 385.101(e)
and 385.2008 of the Commission’s Rules of Practice and Procedure, 18 C.F.R. §§
385.101(e) and 385.2008 (2019), there is good cause to extend until June 1, 2020
the following deadlines for filings required by the Commission that occur on or
before June 1, 2020: (1) the deadline for filing the FERC Form Nos. 60 and 61; (2)
the deadline for filing the FERC Form No. 552 and; (3) the deadline for filing the
Electric Quarterly Report Form-920. Forums: Systrends News

FERC Changed their Website

Systrends News Bites - Wed, 03/25/2020 - 06:56
Please note if you go to EQR page on FERC they have changed the location of where you can find filing submissions and download previous quarter data. Go to EQR page and click 2nd quarter 2013 and earlier and click Reports: Data Inquiries & Tools... Forums: Systrends News

eTariff Version 3.0.1 will be Released Soon

Systrends News Bites - Wed, 03/18/2020 - 06:46

Most everyone has received the 3.0.0 version in some way (either production or Sandbox). Systrends will be coming out with a small 3.0.1 release this week. 

The release notes for the items that were added, fixed or enhanced will be in the help tab of the under release notes. You can review and test the items after the version is updated on your server.

To check and see what version your application is currently running, go to the Help Tab and click About to see what version you are running. The current version is 3.0.0 and the new one will be 3.0.1

One of the biggest changes is that filenames that are loaded will now go into the XML rather than the unique, unidentifiable name that the application used to change it to. So please make sure to use file names that you do not mind are shown in FERC eLibrary.

If you have any questions - Contact 

Forums: Systrends News

Systrends Support Procedure

Systrends News Bites - Fri, 02/28/2020 - 12:42
Systrends SUPPORT Procedure:   Please follow this procedure if you need assistance from Systrends support:   1. Under the Help Tab in eTariff and EQR, select “Submit Help Ticket”.  Fill out the, summary and description of issue and include your email address then select “create”   2. If step 1 is not sufficient, please send an email describing the problem/issue to    3. If Help Ticket (step 1) or email response (step 2) appears not to be enough for severity of the issue (in an emergency) please call 1-(888) 933-3582 (step 3)   NOTE: A call with a voice mail left at this number will initiate emails to several contacts in Systrends   4. If steps 1, 2 or 3 are not sufficient for the severity of the issue then please call one of our support manager’s cell phones (step 4): Renee Feeney (480-223-8639 ) or Michael Bruns      (480-323-6491 ) or Sree Desai  (480-747-3589).   5. If steps 1 through 4 are not satisfactory, please call Dave Darnell: 602-432-3353    Notes: Please do not leave emergency messages on the voice mail at our home office (1-480-756-6777) … if we are traveling the message may not be answered quickly. Please make sure you have created a help ticket (step 1), sent an email to support (step 2) and left a voice mail on 1-(888) 933-3582  (step 3) before escalating to step 4 or 5. Forums: Systrends News

MBR Companies Need to update Company Registration to Include MBR Database

Systrends News Bites - Thu, 02/27/2020 - 09:35

When a company is registered with FERC there is an eTariff, EQR, and 549 checkbox choices to select based on what the company will be submitting to FERC. 

Now there is a new MBR checkbox. 


You will need to go in to FERC Company Registration and check the new MBR checkbox. If this is not done before the end of the year you will not be able to submit to the MBR Data Collections Database (Order 860).

Please make sure you do this for EVERY company that you will submit MBR Data Collections filings for.


The checkbox is available now, so please make sure it is done as soon as possible. 


Forums: Systrends News

EQR 3.0 Coming this Week

Systrends News Bites - Tue, 02/25/2020 - 09:10

This week (Feb 24-28, 2020), the new EQR 3.0 version will be updated to all servers. Your username and password will remain the same as before. There is a user guide in the help tab of the software. You are encouraged to make a few practice filings before the next filing quarter in April. 

If you have questions or need some assistance with the new 3.0 version please contact

Forums: Systrends News

Original File Names Now in eTariff XML

Systrends News Bites - Tue, 02/25/2020 - 09:03

Please take note that the file name of your documents is now going to display in XML and will be sent to FERC. Systrends is no longer making them unique. The  filename will be displayed in FERC eLibrary.

This means you will want to make sure that the file name of your documents are what you want to appear in the eLibrary as shown in the example submission below that is from Systrends eTariff software.

The filename is underlined in blue and the Attachment Reference Type (selected from dropdown in attachments tab) is shown below the file name. If you have any questions please contact 

Forums: Systrends News


Systrends News Bites - Thu, 01/23/2020 - 08:40

Take notice that on February 27, 2020, staff of the Federal Energy Regulatory Commission (Commission) will hold a technical workshop on the relational database being built in accordance with Order No. 860 (MBR Database). 

The meeting will take place from 9:00 a.m. to 12:30 p.m. (EST) in the Commission Meeting Room, at 888 First Street, NE, Washington, DC 20426.  All interested persons are invited to attend.  For those unable to attend in person, access to the meeting will be available via webcast.

This workshop provides a forum for dialogue between Commission staff and interested parties to discuss development and implementation of the MBR Database, including the data dictionary, XML, XSD, submission process, and test environment.  Staff welcomes suggestions for discussion topics prior to the workshop.  Individuals may suggest agenda topics for consideration by emailing  An agenda of the meeting will be provided in a subsequent notice.

Due to the nature of the discussion, those interested in participating are encouraged to attend in person.  All interested persons (whether attending in person or via webcast) are asked to register at There is no registration fee.  Anyone with Internet access can listen to the meeting by navigating to’s Calendar of Events, locating the MBR Data Technical Workshop, and clicking on the link to the webcast.  The webcast will allow persons to listen to the technical conference and they may email questions during the meeting to



[1] Data Collection for Analytics and Surveillance and Market-Based Rate Purposes, Order No. 860, 168 FERC ¶ 61,039 (2019).

Forums: Systrends News

Q4 2019 EQR Date Issue - Because of Daylight Savings Time

Systrends News Bites - Mon, 01/20/2020 - 07:50

If you receive the following error:

Transaction End Date is required, should be in format YYYYMMDDHHMM and should be less than Quarter End and Greater than Begin Date.

and you see that the begin date is 1:55 am (201911030155) and then end date is 1:00 am (or 201911030100) you need to change the end date to end to 2:00 am (201911030200)

Daylight Savings Time ended on November 3rd, 2019 and is causing this issue.

Forums: Systrends News

FERC Reschedule Technical Conference for Forms

Systrends News Bites - Mon, 01/13/2020 - 14:04

Due to the rehearing that FERC granted from EEI's motion to request an extension for comments, FERC is now rescheduling the Technical Conference for the Forms under Docket RM19-12

Dates for comments on this proceeding are now open until March 2, 2020

The date for the technical conference in this proceeding also is rescheduled to
March 24 through March 26, 2020.



Forums: Systrends News

Systrends will Attend the FERC FORMS Technical Conference in Feb

Systrends News Bites - Wed, 12/18/2019 - 11:24

I wanted to let everyone know that Systrends will be sending a representative to the Feb Form Technical Conference in Washington DC.

Systrends has already begun research and development with XBRL format and will build software for the Form 1, Q3 and other forms for Electric, Gas and Oil. 

We may reach out to customers who would be interested in providing us feedback in what type of features they would like to see in the new software. 

Right now we need to wait for the technical conference and final rule from FERC


Thank You


Forums: Systrends News


Systrends News Bites - Mon, 12/16/2019 - 15:07
AttachmentSize Forms Technical Conference Notice.pdf138.26 KB Take notice that the Federal Energy Regulatory Commission (Commission) will hold a staff-led technical conference in the above-referenced proceedings on Tuesday through Thursday, February 4-6, 2020, from 9:00 am to 5:00 pm Eastern time.  The conference will be held in the Commission Meeting Room at Commission headquarters, 888 First Street, NE, Washington, DC 20426.  Staff anticipates issuing a supplemental notice and an agenda to provide additional information and a list of topics to be addressed prior to the technical conference.    Sounds like they will also be discussion MBR Data Collections requirement as well. Forums: Systrends News

FERC eRegistration Re-Certification

Systrends News Bites - Fri, 10/04/2019 - 10:12

The Commission will initiate an annual recertification of all eRegistered user email addresses. eRegistered user accounts whose email addresses cannot be validated will be deactivated.  Deactivated user accounts will not be able to transact business with the Federal Energy Regulatory Commission without reactivating their account including submitting filings in a docket or receiving notices/updates from any docketed matter   Information on the eRegistration recertification process is available at

So if your company has recently changed domains and your email is different than what might be registered with FERC please update your email with them... If it is not updated, submitting Tariff or EQR filings will not happen

Be sure to check all Managers listed for each company registration along with Filing Agents

Forums: Systrends News


Subscribe to Systrends aggregator - Systrends Updates Forum Front Page