Forms – Export A Spreadsheet Of Certificate Holders And Property Interests

The list of certificate holders and property interests assigned to a certificate can be exported to a Microsoft Excel spreadsheet. The spreadsheet of certificate holders and property interests includes the interest fax number, email address, and all risk properties for the interest.

Export a spreadsheet of certificate holders and property interests

  1. Open a certificate of insurance.
  2. Select Other -> Print Selected Holders.
  3. Choose the desired holders by selecting the individual check boxes, selecting “Check All / Uncheck All”, or by right-clicking and selecting “Check Holders with / without email”.
    Spreadsheet of Certificate Holders
    Export a spreadsheet of certificate holders
  4. Select Export to create the spreadsheet.
    Spreadsheet of certificate holders
    Spreadsheet of certificate holders
  5. Select Print or Save As within Microsoft Excel.

Automatically Create Trust Accounting Reports

The reconciliation functions in Newton provide the ability to generate reports from the archive of processed items. The reconciliation functions can also be configured to automatically create and store .PDF copies of the trust accounting reports as each item is processed.

Automatically create trust accounting reports

The .PDF copies of the automatic trust accounting reports can be stored on the various attachment bands within Newton (Client Tab -> Attachments, Company Tab -> Attachments), or externally in a user-specified folder.

  • Reconcile Producer Payables can optionally email the producer’s .PDF report in addition to placing the .PDF archive in the user-specified Archive folder.
  • These settings apply to both individual reconciles and Batch Reconcile Company/Producer Payables.
  • The automatic actions do not require any additional steps, clicks, or prompts during processing.
Automatically Create Trust Accounting Reports
Automatically Create Trust Accounting Reports
Reconcile functions with automatic actions:
  • Bank Deposit Wizard
  • Bank Reconcile
  • Client Receivables
  • Company Payables
  • Company Receivables
  • Producer Payables (Includes .PDF or email)

Configure invoice reconcile actions

  1. Select AP -> Reconcile Payables.
  2. Select Other -> Select Actions When Reconcile Completes…
  3. Check to enable or disable the different report options. If Save report to archive is selected for any option, select the desired Archive Folder.
    Configure Automatic Actions
    Configure Automatic Actions

    (Each Newton user can have a different archive folder, providing the option to store the files in a secure local folder on the workstation.)

  4. Select OK.