{"id":33043,"date":"2021-02-03T03:22:55","date_gmt":"2021-02-03T03:22:55","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=33043"},"modified":"2021-02-10T03:24:48","modified_gmt":"2021-02-10T03:24:48","slug":"bulk-upload-tool-guide-for-internal-connections-frns-3","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=33043","title":{"rendered":"Bulk Upload Tool Guide for Internal Connections FRNs"},"content":{"rendered":"

February 3, 2021<\/span><\/p>\n

Attached:\u00a0Category-Two-Internal-Connections-Version-21.0 EXAMPLE<\/a><\/p>\n

Attached:\u00a0Bulk Upload Guide – Internal Connections – FY 2021<\/a><\/p>\n

~ Great Time Saver ~<\/p>\n

~ Much Easier This Year Due to C2 Changes! ~
\n<\/strong>~ Helpful (Essential) Guide Attached ~<\/p>\n

When applying for E-rate funding for Internal Connections, the Form 471 requires every component to be listed on its own FRN Line Item.\u00a0 Although you no longer have to list the entities receiving the equipment or the associated costs, creating these FRNs can be time consuming, as many of you have discovered over the last five years.\u00a0 To ease this burden, USAC has created off-line Templates that can be completed and then uploaded into the Funding Request instead of manually creating\/adding FRN Line Items.\u00a0 While Templates are available for all C1 and C2 service types, the Internal Connections Template is the one I believe will save PA applicants the most time and will be most-used.\u00a0 The Internal Connections template has modified for FY 2021 to make 2 tabs optional(!), and the correct version to use is V21.0 and is available at:\u00a0\u00a0https:\/\/www.usac.org\/wp-content\/uploads\/e-rate\/documents\/Forms\/bulk_upload_templates\/Category-Two-Internal-Connections-Version-21.0.xlsm<\/a>.<\/p>\n

Bulk Upload\/Template Guide<\/strong><\/p>\n

To assist applicants with completing the Internal Connections Template and Bulk Upload process, I\u2019ve created the attached Guide which I strongly encourage you follow as you complete your first Template.\u00a0 Also attached is a completed Example Template so you can see what yours should look like.<\/p>\n

What Are the Basic Steps for Using the IC Bulk Upload Process?<\/strong><\/p>\n

Applicants will create the off-line Template, validate for errors, then save to their computer when no errors are showing.\u00a0 Then they will create the Form 471 and funding request in EPC.\u00a0 At the \u2018FRN Line Item\u2019 screen, click \u201cBulk Upload\u201d instead of Add FRN Line Item, and upload the Template. \u00a0EPC will then create a task within 1 minute with the Bulk Upload results.\u00a0 Applicants should review all of the FRN Line Item data that was imported to ensure accuracy.\u00a0 All data can be revised at this point, or applicants can delete the FRN Line Item information, and upload a revised Template if they so choose.<\/p>\n

Advantages to the Using IC Bulk Upload Template?<\/strong><\/p>\n