Reconciliations - Producer/Broker Payable

The Producer/Broker Payable Reconciliations module is available only if an agency is set up to reconcile producers and/or brokers in System Settings.

The following workflows are available in this area:

• Add a Producer/Broker Payable Reconciliation
• Add Additional Items
• Approve a Producer/Broker Payable Reconciliation for Payment
• Associate a GL Item to a Producer/Broker Payable Reconciliation
• Batch Process Statements
• Close a Producer/Broker Payable Reconciliation Without Paying
• Delete a Producer/Broker Payable Statement
• Edit a Producer/Broker Payable Reconciliation
• Finalize a Statement
• Flag All Items
• Modify Payment Month
• Pay Statement - Producer/Broker Payable
• Print a List of Producer/Broker Payable Statements
• Remove Associated GL Item - Producer/Broker Payable
• Reopen Statement
• Reprocess a Statement
• Reverse a Producer/Broker Payable Statement
• Transfer of Funds

The following reports are available from this area:

• Default/Recurring Entries
• General Ledger Register
• Status of Accounts
• Transaction Reconciliation Report

To access the Producer/Broker Payable Reconciliations 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 Reconciliations on the navigation panel or Areas > Reconciliations on the menubar.
3. Click Pr/Br Payables on the navigation panel under Reconciliations.

The screen is comprised of the following sections:

1. • Menubar

     

     The following options are available from the menubar of the Producer/Broker Payable Reconciliations area:

     1. • File
        • • New
          • • Pr/Br Payables
            • 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
            • Export
            • Activity
            • Sticky Note
          • Open
          • Delete
          • Save
          • Print
          • • Listview
            • Barcode
          • Display Options
          • 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
        • • Approve for Payment
          • Associate GL Item
          • Batch Process Statements
          • Close Without Paying
          • Finalize Statement
          • Flag All Items
          • Modify Payment Month
          • Pay Statement
          • Remove Associated GL Item
          • Reopen Statement
          • Reprocess Statement
          • Reverse Statement
          • Transfer of Funds
        • On Demand
        • • Default/Recurring Entries
          • General Ledger Register
          • Status of Accounts
          • Transaction Reconciliation Report
        • Access
        • • Activities
          • Attachments
          • General Ledger
          • Transactions
          • Notifications
        • Links
        • myEpic
        • SMS
        • Help
        • • Applied Epic Help
          • Applied KnowledgeBase
          • Applied Epic Release Notes
          • Online Chat / Log a Case
          • About Applied Epic 2023
   • Options Bar

     

     The following options are available from the options bar of the Producer/Broker Payable Reconciliations area:

     1. • Home
        • • Accounts
          • General Ledger
          • Reports/Marketing
          • Procedures
          • Configure
          • Utilities
          • Email
        • Locate
        • Actions
        • • Approve for Payment
          • Associate GL Item
          • Batch Process Statements
          • Close Without Paying
          • Finalize Statement
          • Flag All Items
          • Modify Payment Month
          • Pay Statement
          • Remove Associated GL Item
          • Reopen Statement
          • Reprocess Statement
          • Reverse Statement
          • Transfer of Funds
        • On Demand
        • • Default/Recurring Entries
          • General Ledger Register
          • Status of Accounts
          • Transaction Reconciliation Report
        • Access
        • • Activities
          • Attachments
          • General Ledger
          • Transactions
          • Notifications
        • Links
        • myEpic
        • SMS
        • New
        • • Pr/Br Payables
          • 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
          • Export
          • 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

     Enter your desired search criteria to populate the list. Reconciliations matching the criteria selected in the filter display in the list. To sort by a different column, click the column heading by which you wish to sort. Click one more time to change the sort order (from ascending to descending, or vice versa).

     Click the Select Columns link label to change the columns that display in the list or the order in which they display.

     Detail for the highlighted reconciliation displays below the list.

     Search Bar

     To locate reconciliations that match specific criteria, use the search bar. Make a selection in each dropdown menu to locate the desired reconciliations. The fields vary, depending on the menu options you choose.

     

     These are the choices in the first dropdown menu:

     3. • Agency
        • Check #
        • Contract Description
        • Created Area
        • Date Entered
        • Discrepancy Statement
        • Due Date
        • Entered By
        • Master Statement #
        • Paid Area
        • Paid Status
        • Payment Address
        • Payment Contact
        • Pr/Br Code
        • Pr/Br Name
        • Recreated
        • Refer #
        • Reopened
        • Reversed
        • Rework
        • Statement #

     The choices available in the second dropdown menu vary, depending on the selection you made in the first dropdown.

     • Equals: Enter the search criterion (e.g., the exact company code, user ID) in the field to the right, or select the correct date from the dropdown calendar (if applicable). Click Find.
     • Contains: Enter at least one letter of the search criterion. Click Find.
     • Within Range: Search between two different calendar dates of your choice. Click the down arrow to the right of each field to choose dates from the dropdown calendars. Click Find.
     • If you selected Paid Status, select Paid or Unpaid from the second dropdown. Click Find.
     • If you selected Discrepancy Statement, select Discrepancy, Resolved, or Both from the second dropdown. Click Find.
     • If you selected Created Area, select Receipts or Reconciliations from the second dropdown. Click Find.
     • If you selected Paid Area, select None, Receipts, Disbursements, Vouchers, or Reconciliations from the second dropdown. Click Find.
     • If you selected Recreated, Reopened, or Reversed, select Include or Exclude from the second dropdown. Click Find.
     • If you selected Rework, select Include, Exclude, or Only from the second dropdown. Click Find.

     If you selected Pr/Br Code or Pr/Br Name, you must select Broker or Producer from the third dropdown menu before entering the search criterion and clicking Find.

     If you selected Refer #, you must select the type of General Ledger item from the third dropdown menu before entering the search criterion and clicking Find.

     To see the filter that is currently applied to the list, hover over the Search where text.

     You can apply multiple filters if necessary.

     1. To apply multiple filters to the list, do one of the following:
        • Click the Edit Filter button . 
        • Press [Ctrl] + E.
     2. The Edit Filter pop-up window displays. 
        
        Note: You can also use the Edit Filter button, rather than the search bar, to apply a single filter to the list if you prefer.

     

     3. Select and/or enter your desired search criteria using the dropdown menus and fields, and then click the Add button. The Name, Compare Type, and Criteria for your filter display in the list. Click one of these column headings to sort the list by that column. To reverse the sort order, click the column heading again.
     4. To apply additional filters, enter additional search criteria and continue clicking Add. To remove a filter from the list, select it and click the Delete button.
     5. Click Finish when you have applied all of your desired filters.
        
        To exit the dialog without applying any filters, click Cancel.
   • Criteria frame

     The following criteria options, selected when the statement was created, display for the highlighted statement:

     • Producer/Broker- Displays Type (PR=Producer, BR=External broker, IN=Internal broker) + Lookup Code + Account Name
     • Contract description (if applicable- producer statements may not require contracts)
     • Agency
     • Month/Date
   • Paid frame

     The following information displays for the highlighted statement (if that statement has been paid):

     • Paid: User who paid the statement, along with the date the statement was paid.
     • General ledger type: Type of General Ledger item used to pay the statement. Can be Disbursement, Voucher, Receipt, or Journal Entry.
     • Reference #: Refer # for General Ledger item used to pay the statement.
     • Amount: Displays the amount for the General Ledger item (or General Ledger detail row) that paid the statement.
     • Cheque #: Cheque number, if applicable.
   • Status frame

     All statuses that apply to the highlighted statement display in this frame. Possible statuses include:

     • Activities: Displays only if any activities are attached to the statement.
     • Suspended/Finalized/Processing/Failed: Displays the statement status.
     • Unpaid/Paid/Closed: Displays the paid status.
     • Reopened: Displays only if the statement has been reopened.
     • Reversed: Displays only if the statement was reversed or is an offsetting reversal entry.
   • Reversal frame

     If a statement is reversed or is an offsetting reversal entry, the following information displays:

     Statement #: Statement number for the offsetting statement (if the original statement is selected) or the original statement (if the offsetting statement is selected).

     Amount: Amount for the offsetting statement (if the original statement is selected) or the original statement (if the offsetting statement is selected).