Spreadsheet Export
Spreadsheet Export gives you the ability to export actual numbers, and budget numbers, and encumbrances (Fund product only) for all accounts from General Ledger. Spreadsheet Export will export in spreadsheet format to any location you choose. This creates a quick and simple way to extract and customize general ledger information for additional reporting purposes, transmit general ledger information to auditors and accountants, as well as assist in reconciliation processes.
To export data to a spreadsheet or text format file:
1 From the General Ledger navigation pane, select Reporting > Export Spreadsheet.
Click thumbnail to view Business image.
Click thumbnail to view Fund image.
2 Select the fund number, range of accounts and periods, source, and format you will use for this export. You can also filter the report using the Account Filter option.
NOTE: If you want to include beginning balances in the export, enter 0 in the Starting Period field.
3 Select the Include Column Header check box if you want to view column headings in the preview and exported file.
4 If you want to verify the formatting and information before you export, select the Preview button. You can select Back to return to the default window or export from the preview window.
5 Click Export to begin the process.
 
Published date: 09/30/2021