Export

From this area, you can export General Ledger account balances to a Microsoft Excel file, which can then be imported into a third-party financial software system for reporting purposes.

The following workflows are available:

• Add a General Ledger Export Batch
• Cancel a General Ledger Export Batch
• Edit/View a General Ledger Export Batch
• Export Batch - General Ledger
• Finalize a General Ledger Export Batch
• Modify Next Scheduling/Recurrence
• Print a List of General Ledger Export Batches

To access the General Ledger Export area, follow the steps below:

1. To access the General Ledger area from the Home screen, do one of the following:
   • Click General Ledger on the navigation panel.
   • Click Areas > General Ledger on the menubar.
   • Click the down arrow next to Home on the options bar and select General Ledger.

   To access the General Ledger from another area of the program, do one of the following:

   • Click Home > General Ledger on the menubar.
   • Click the down arrow next to Home on the options bar and select General Ledger.
2. Click Export on the navigation panel or Areas > Export on the menubar.

The screen is comprised of the following sections:

• Menubar

  

  The following options are available from the menubar of the Export area:

  1.  
     • File
     • • New
       • • Export
         • Receipt
         • Disbursement
         • Voucher
         • Journal Entry
         • Reconciliation
         • • Premium Payable
           • Direct Bill Commissions
           • Pr/Br Payables
           • Government Payables
           • Bank
         • Budget
         • • GL Budget
         • Import
         • • Direct Bill Transaction
           • Receipt
           • Reconciliations
         • Activity
         • Sticky Note
       • Open
       • Delete
       • Print
       • • List
         • Barcode
       • Exit
     • Edit
     • • Undo
       • Cut
       • Copy
       • Paste
       • Delete
       • Select All
       • Desired
       • Required
     • Areas
     • • General Ledger Home
       • Receipts
       • Disbursements
       • Vouchers
       • Journal Entries
       • Reconciliations
       • • Premium Payable
         • Direct Bill Commissions
         • Pr/Br Payables
         • Bank
       • Budgets
       • • GL Budgeting
       • Import
       • • Direct Bill Transactions
         • Receipts
         • Reconciliations
       • Export
       • Activities
     • Home
     • • Accounts
       • General Ledger
       • Reports/Marketing
       • Procedures
       • Configure
       • Utilities
       • Email
     • Locate
     • Actions
     • • Cancel Batch
       • Export Batch
       • Finalize Batch
       • Modify Next Scheduling/Recurrence
     • On Demand
     • • Default/Recurring Entries
       • General Ledger Register
       • Status of Accounts
     • Access
     • • Activities
       • Transactions
       • Notifications
     • Links
     • myEpic
     • SMS
     • Help
     • • Applied Epic Help
       • Applied KnowledgeBase
       • Applied Epic Release Notes
       • Online Chat / Log a Case
       • About Applied Epic July 2023
• Options Bar

  

  The following options are available from the options bar of the Export area:

  1. • Home
     • • Accounts
       • General Ledger
       • Reports/Marketing
       • Procedures
       • Configure
       • Utilities
       • Email
     • Locate
     • Actions
     • • Cancel Batch
       • Export Batch
       • Finalize Batch
       • Modify Next Scheduling/Recurrence
     • On Demand
     • • Default/Recurring Entries
       • General Ledger Register
       • Status of Accounts
     • Access
     • • Activities
       • Transactions
       • Notifications
     • Links
     • myEpic
     • SMS
     • New
     • • Export
       • Receipt
       • Disbursement
       • Voucher
       • Journal Entry
       • Reconciliation
       • • Premium Payable
         • Direct Bill Commissions
         • Pr/Br Payables
         • Government Payables
         • Bank
       • Budget
       • • GL Budget
       • Import
       • • Direct Bill Transaction
         • Receipt
         • Reconciliations
       • Activity
       • Sticky Note
     • Print
     • • Listview
       • Barcode
     • Save
     • Undo
• Navigation Panel

  The navigation panel is on the left side of the screen.

  

  The navigation panel consists of the following buttons:

  1. • General Ledger Home
     • Receipts
     • Disbursements
     • Vouchers
     • Journal Entries
     • Reconciliations
     • Budgets
     • Import
     • Export
     • Activities
• List

  To change the export batches that display in the list, click the Export – General Ledger view filter and select one of the following:

  • Current: Display all batches with a Status of Processing, Created, Failed, or Exporting, along with their associated scheduled jobs.
  • Last 6 Months: Display all batches entered within the last six months. Currently scheduled batches and jobs are omitted from this view.
  • Search: Enter search criteria to locate export batches. You cannot locate any currently scheduled batches/jobs using the Search view.

  Use the Search where bar to narrow the batches that display in the list if necessary.

  To change the columns that display in the list or the order in which they display, click the Select Columns link label.

  The Criteria frame displays the following information for the selected batch:

  • Mapping file: Description of the mapping file used
  • Destination: Export file destination
  • File name: File name of the export file
  • Month: Month parameters set for the export file
  • Date: Date parameters set for the export file
  • Agency: Agency associated to the export batch

  The History frame displays a list of actions that have been performed on the batch, along with the date and time of each action and the user who performed it.