{"id":688,"date":"2026-07-29T18:37:09","date_gmt":"2026-07-29T18:37:09","guid":{"rendered":"https:\/\/www.marshall.edu\/finance\/?page_id=688"},"modified":"2026-07-29T18:37:11","modified_gmt":"2026-07-29T18:37:11","slug":"banner-data-extract","status":"publish","type":"page","link":"https:\/\/www.marshall.edu\/finance\/banner-data-extract\/","title":{"rendered":"Banner Data Extract"},"content":{"rendered":"\t
\n\t\t\t\t\t\n
\n\t
\n\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"Marshall<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\n
\n \n Meet Marshall<\/span>\n <\/a>\n
\n
\n
\n
\n
\n
Welcome to Marshall<\/div>\n
\n Why Choose Marshall?<\/a>\n\n The Value of a Marshall Degree<\/a>\n\n Our Community<\/a>\n\n Our Blog<\/a>\n\n Our Stories<\/a>\n\n Our History<\/a>\n\n <\/div>\n <\/div>\n
\n
Leadership<\/div>\n
\n Office of the President<\/a>\n\n Board of Governors<\/a>\n\n Workforce and Economic Development<\/a>\n\n Academic Affairs<\/a>\n\n <\/div>\n <\/div>\n
\n
News & Marketing<\/div>\n
\n Events<\/a>\n\n Academic Calendar<\/a>\n\n News Releases<\/a>\n\n Branding Guide<\/a>\n\n University Marketing & Communications<\/a>\n\n <\/div>\n <\/div>\n<\/div>\n\n <\/div>\n <\/div>\n <\/div>\n<\/div>\n\n\n\t\t\t\t\t\t\n\n
\n \n Admissions<\/span>\n <\/a>\n
\n
\n
\n
\n\t
\n\t\t
Information For<\/div>\n\t\t
\n\t\t\tFirst-Year Freshmen<\/a>\n\n\t\t\tTransfer Students<\/a>\n\n\t\t\tInternational Undergraduate Students<\/a>\n\n\t\t\tGraduate Students<\/a>\n\n\t\t\tInternational Graduate Students<\/a>\n\n\t\t\tOnline Students<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
Getting Started<\/div>\n\t\t
\n\t\t\tVisit Campus<\/a>\n\n\t\t\tApply for Admission<\/a>\n\n\t\t\tApply for Financial Aid<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
Cost & Aid<\/div>\n\t\t
\n\t\t\tTuition<\/a>\n\n\t\t\tFinancial Aid<\/a>\n\n\t\t\tScholarships<\/a>\n\n\t\t\tEstimate Your Cost<\/a>\n\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n <\/div>\n <\/div>\n <\/div>\n<\/div>\n\n\n\t\t\t\t\t\t\n\n
\n \n Academics<\/span>\n <\/a>\n
\n
\n
\n
\n\t
\n\t\t
Degrees<\/div>\n\t\t
\n\t\t\tUndergraduate<\/a>\n\n\t\t\tGraduate<\/a>\n\n\t\t\tOnline<\/a>\n\n\t\t\tProfessional<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
More Programs<\/div>\n\t\t
\n\t\t\tHerd Academy<\/a>\n\n\t\t\tSchool of Medicine<\/a>\n\n\t\t\tSchool of Pharmacy<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
Resources<\/div>\n\t\t
\n\t\t\tAcademic Calendar<\/a>\n\n\t\t\tLibraries & Online Research<\/a>\n\n\t\t\tInternships & Career Development<\/a>\n\n\t\t\tColleges & Schools<\/a>\n\n\t\t\tCampus Bookstore<\/a>\n\n\t\t\tResearch at Marshall<\/a>\n\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n <\/div>\n <\/div>\n <\/div>\n<\/div>\n\n\n\t\t\t\t\t\t\n\n
\n \n Marshall Life<\/span>\n <\/a>\n
\n
\n
\n
\n\t
\n\t\t
Clubs & Organizations<\/div>\n\t\t
\n\t\t\tStudent Government<\/a>\n\n\t\t\tGreek Life<\/a>\n\n\t\t\tAthletics<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
Student Activities<\/div>\n\t\t
\n\t\t\tCommunity Service<\/a>\n\n\t\t\t\t\t\tCampus Rec<\/a>\n\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
Student Resources<\/div>\n\t\t
\n\t\t\tResidence Halls\/Living<\/a>\n\n\t\t\tStudent Affairs<\/a>\n\n\t\t\tStudent Health<\/a>\n\n\t\t\tStudent Policies<\/a>\n\n\t\t\tColleges & Schools<\/a>\n\n\t\t\tTitle IX Office<\/a>\n\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n <\/div>\n <\/div>\n <\/div>\n<\/div>\n\n\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\n \n\n\t\n\tRequest Info<\/span>\n<\/a>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t<\/path><\/svg>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t
Common Search Terms:<\/div>\n\t\t\t\t
\n\t\t\t\t\tadmissions<\/a>,\n\t\t\t\t\tapply now<\/a>,\n\t\t\t\t\tonline learning<\/a>,\n\t\t\t\t\trequest information<\/a>,\n\t\t\t\t\tschedule of courses<\/a>,\n\t\t\t\t\tacademic calendar<\/a>,\n\t\t\t\t\tbert<\/a>,\n\t\t\t\t\tregistrar<\/a>,\n\t\t\t\t\tlibrary<\/a>,\n\t\t\t\t\thuman resources<\/a>,\n\t\t\t\t\thousing<\/a>,\n\t\t\t\t\thr<\/a>,\n\t\t\t\t\twork order<\/a>,\n\t\t\t\t\tregistration<\/a>,\n\t\t\t\t\tjobs<\/a>,\n\t\t\t\t\tmubert<\/a>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\t\t\n\t\t\t\t\t\n
\n\t\n\t\t\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\tFinance<\/a>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t

\n\t\t\t\t\t\t\n\t\t\t\t\t<\/h1>\n\t\t\t\t<\/div>\n\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tAccounting<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tAccounts Payable<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tBudget<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tBursar<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tForms<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tPayroll<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tShared Services<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tResources<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tTraining<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tFAQ<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tContact Us<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\n\t\t\t<\/div>\n\n\t\n\n\t
\n\n\t\t\n\t\t\n\t\t\t\t\n\t\t
\n\t\t\t \n\t\t\t\n\t\t\t\n\t\t\t
\n\t\t\t\t

The extract option for a Banner form has been made available to those individuals with query privileges to said Banner form. Though the data will be stored in an electronic format outside of Banner, the information is not to be shared with individuals that do not have current query privileges to that data. In addition, all electronic storage of this information should be properly secured to protect the information from inappropriate access.\u2028Using the Data Extract feature of Banner will allow a user to download information from an on-line form to an Excel spreadsheet. Currently, three forms (FGIBDST, FGITRND, and FGIOENC) have been set-up to use this feature.<\/p>\n

Before you begin using data extract you need to get the templates that you will use from the accounting web page shown below:\u2028http:\/\/www.marshall.edu\/accounting\/uwforms.html<\/p>\n

Scroll down. Look in the \u201cBanner Related\u201d section and save the templates shown to your computer. Save them where you will be able to find them quickly. We will use these later.<\/p>\n

If you have any problems downloading these templates from the web, please contact\u00a0Selah Wilson.<\/p>\n

FGIBDST EXTRACT<\/strong><\/p>\n

To extract data from FGIBDST, access that form as you normally would for on-line inquiry purposes.\u2028Once the information appears on the screen, go to \u201cHelp\u201d on the toolbar. Hold down the Ctrl key and select \u201cExtract Data No Key.\u201d Keep Ctrl depressed till the download box appears then you click on \u201cOpen\u201d.
\nDo \u201cPage\u201d \u201cSave as\u201d Rename the file and save in C:\/Temp. On new Internet Explorer: to \u201csave as\u201d click on \u201cPage\u201d mid way on right side of screen or when box appears, choose \u201csave as\u201d and save to C: temp. ( it must be saved as a CSV file.)\u2028If says may contain features not compatible with CSV file\u2014answer yes\u2028Close file\u2028If ask if want to save changes, answer \u201cno\u201d\u2028In Excel, retrieve the FGIBDST template.
\nOn the toolbar, go to \u201cData\u201d, then \u201cImport External Data\u201d, then \u201cImport Data\u201d\u2028Select the \u201cTEMP\u201d folder, then select the appropriate extracted FGIBDST file. Make sure that \u201cFiles of type:\u201d reads \u201cText Files\u201d, \u201cAll Files\u201d, or \u201cAll Data Sources\u201d.
\nWhen the extracted file is selected, the Text Import Wizard Screen should appear.\u2028Select \u201cDelimited\u201d as the Original Data Type. Go to the Next screen.\u2028Select \u201cTab\u201d and \u201cComma\u201d as the Delimiters. Select \u201cFinish\u201d.
\nSelect \u201cExisting worksheet;\u201d and change the option to \u201c=$A$8\u201d.\u2028Click on \u201cOK\u201d. This will put the data into the template.\u2028IMPORTANT!! You must now save the file as an Excel file by going to \u201cFile\u201d and \u201cSave as\u201d. You may save this under the file name and folder of your choice. If you do not do this, you will be unable to use other Excel functions on the spreadsheet and may corrupt your template file.<\/p>\n

FGITRND EXTRACT\u2028<\/strong><\/p>\n

To extract data from FGITRND, access that form as you normally would for on-line inquiry purposes.\u2028Once the information appears on the screen, go to \u201cHelp\u201d on the toolbar. Hold down the Ctrl key and select \u201cExtract Data No Key.\u201d Keep Ctrl depressed till box below appears.<\/p>\n

You will see the following block of information, indicating the file where the extracted data has been stored.
\nChoose \u201cOpen\u201d. Do \u201cPage\u201d \u201cSave as\u201d Rename the file and save in C:\/Temp. It must be saved as a \u201cCSV\u201d file. If says may contain features not compatible with CSV file\u2014answer yes.
\nClose file.
\nIf asked if want to save changes, answer \u201cno.\u201d
\nIn Excel, retrieve the FGITRND template.<\/p>\n

On the toolbar, go to \u201cData\u201d, then \u201cImport External Data\u201d, then \u201cImport Data\u201d<\/p>\n

Select the \u201cTEMP\u201d folder, then select the appropriate extracted FGITRND file. Make sure that \u201cFiles of type:\u201d reads \u201cText Files\u201d, \u201cAll Files\u201d, or \u201cAll Data Sources\u201d.
\nWhen the extracted file is selected, the Text Import Wizard Screen should appear.<\/p>\n

Select \u201cDelimited\u201d as the Original Data Type. Go to the Next screen.
\nSelect \u201cTab\u201d and \u201cComma\u201d as the Delimiters. Select \u201cFinish\u201d.<\/p>\n

Select \u201cExisting worksheet;\u201d and change the option to \u201c=$A$7\u201d.
\nClick on \u201cOK\u201d. This will put the data into the template.<\/p>\n

IMPORTANT!! You must now save the file as an Excel file by going to \u201cFile\u201d and \u201cSave as\u201d. You may save this under the file name and folder of your choice. If you do not do this, you will be unable to use other Excel functions on the spreadsheet and may corrupt your template file.<\/p>\n

FGIOENC EXTRACT<\/strong><\/p>\n

To extract data from FGIOENC, access that form as you normally would for on-line inquiry purposes.\u2028Once the information appears on the screen, go to \u201cHelp\u201d on the toolbar. Hold down the Ctrl key and select \u201cExtract Data No Key.\u201dKeep Ctrl depressed till download box appears.<\/p>\n

You will see the following block of information, indicating the file where the extracted data has been stored.
\nChoose \u201cOpen\u201d. Do \u201cPage\u201d \u201cSave as\u201d Rename the file and save in C:\/Temp. It must be saved as a \u201cCSV\u201d file. If says may contain features not compatible with CSV file\u2014answer yes.
\nClose file.
\nIf asked if want to save changes, answer \u201cno\u201d\u2028In Excel, retrieve the FGIOENC template.<\/p>\n

On the toolbar, go to \u201cData\u201d, then \u201cImport External Data\u201d, then \u201cImport Data\u201d<\/p>\n

Select the \u201cTEMP\u201d folder, then select the appropriate extracted FGIOENC file. Make sure that \u201cFiles of type:\u201d reads \u201cText Files\u201d, \u201cAll Files\u201d, or \u201cAll Data Sources\u201d.
\nWhen the extracted file is selected, the Text Import Wizard Screen should appear.<\/p>\n

Select \u201cDelimited\u201d as the Original Data Type. Go to the Next screen.\u2028Select \u201cTab\u201d and \u201cComma\u201d as the Delimiters. Select \u201cFinish\u201d.
\nSelect \u201cExisting worksheet;\u201d and change the option to \u201c=$A$7\u201d.
\nClick on \u201cOK\u201d. This will put the data into the template.
\nIMPORTANT!! You must now save the file as an Excel file by going to \u201cFile\u201d and \u201cSave as\u201d. You may save this under the file name and folder of your choice. If you do not do this, you will be unable to use other Excel functions on the spreadsheet and may corrupt your template file.<\/p>\n

TIPS FOR EXTRACTING DATA<\/strong><\/p>\n

When extracting data from these on-line forms, remember that information contained in these on-line forms is current for all transactions that have been posted year-to-date at the time you are viewing the form.<\/p>\n

If expense information is needed for a particular month, you may retrieve the information by going to FGIBDST and select \u201cTransaction Detail Information\u201d (FGITRND). Select \u201cRollback\u201d. On the first line of information, delete the account code if you want to see all transactions or enter the particular account code you are investigating. In the block labeled \u201cPeriod\u201d, enter the fiscal month you want information on (July=01, August=02, etc.). Do \u201cControl\u201d \u201cPage Down\u201d. In the block labeled \u201cField Code\u201d, type in \u201cYTD\u201d. Click on the \u201cF8\u201d key. This will extract all transactions for that particular fiscal month for the requested account codes.<\/p>\n

Neither the FGIBDST nor FGITRND forms allow for year-to-date information to be requested as of the end of a particular month. You may want to extract each month separately and then build a year-to-date spreadsheet with that information.<\/p>\n

If you have questions or need further help, please contact\u00a0Selah Wilson<\/a>.<\/p>\n\n\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":945,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-688","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/pages\/688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/users\/945"}],"replies":[{"embeddable":true,"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/comments?post=688"}],"version-history":[{"count":1,"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/pages\/688\/revisions"}],"predecessor-version":[{"id":690,"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/pages\/688\/revisions\/690"}],"wp:attachment":[{"href":"https:\/\/www.marshall.edu\/finance\/wp-json\/wp\/v2\/media?parent=688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}