(803) 252-7128 afoa@fatsandoils.org

Starting Tuesday, April 18, 2023, the new Export Sales Reporting and Maintenance System is open for User Acceptance Testing.

USDA needs all exporters to enter the ESRMS 2.1 Test System to become familiar with how it works and to test the bulk electronic upload process. It is absolutely critical that ALL exporters perform user acceptance testing to ensure that they can comply with reporting required by Sec 812 of the Agricultural Act of 1970, as added by the Agricultural and Consumer Protection Act of 1973 (38 FR 28055, 39 FR 18630). Furthermore, USDA must have feedback from all exporters to ensure the functionality and compatibility of the final system design.

ESRMS 2.1 and the ESRMS 2.1 Query System are to be used as TEST SITES ONLY.

New data entered in ESRMS 2.1 is for testing only and is not to be used for any other purpose.
All data entered in the test site will be purged prior to the launch of ESRMS 2.1.

PLEASE NOTE:  All regular weekly data entry should be done in legacy ESRMS found here:  ESRMS Home- Export Sales Reporting and Maintenance System (ESRMS) (usda.gov)

The ESRMS 2.1 UAT site can be found at the following link:  https://esrms.fas.usda.gov/ .  Please use your existing ESRMS eAuthentication credential to access the ESRMS 2.1 site. If you experience any problems logging into to ESRMS 2.1, please contact Amy Harding at ESR@usda.gov .

Please remember that your legacy ESRMS Firm Number has been updated to a new ESRMS 2.1 Exporter Number. To access your ESRMS 2.1 Exporter Number, open the Weekly Data Entry screen and begin typing your Exporter Company Name in the “Export Name” field and select your Exporter Company Name. Your Exporter Number will be in parenthesis next to your Exporter Company Name. If you experience any problem finding your ESRMS 2.1 Export Number, please contact Amy Harding at ESR@usda.gov .

Attached for your convenience are the electronic data upload CSV and JSON file templates and the Help Instructions. Please note data entry into either a CSV or JSON file template must be done exactly as indicated in the Help Instructions.

The manual data entry option is also available for those electing not to use the electronic data upload option.

Any questions regarding the electronic data upload or manual data entry processes should be directed to Amy Harding ESR@usda.gov .

We would like to direct your attention to the following site: https://forms.office.com/g/x6e2h0yE36 . You will find our ESRMS 2.1 User Acceptance Testing Feedback Form. Please complete this form as you move through user acceptance testing so we can gather your feedback regarding your experiences working in ESRMS 2.1. Multiple entries are welcomed and will be accepted.

The ESRMS 2.1 will be available for user acceptance testing until Friday, June 30, 2023. Please provide feedback no later than Friday, June 30, 2023. USDA will consider additional user acceptance testing opportunities after reviewing the feedback provided. If you would like to provide additional feedback regarding the upgrades to ESRMS 2.1, please do so via the Export Sales Reporting and Maintenance System Federal Register Notice to the Paperwork Reduction Act scheduled to be released on May 1, 2023.

USDA/FAS appreciates your assistance with testing ESRMS 2.1.

Amy Harding

Export Sales Reporting -Team Lead


202-641-4935 (cell)

• If you’d like a copy of the FileImportTemplate, please contact AFOA@fatsandoils.org and someone will share a copy with you.

• Also, we have “Help Instructions for Electronic Data Transfer Screen” if you need it.  Please request a copy from AFOA@fatsandoils.org