Skip to main content

CCH ProSystem - Payment import template

Christa Mason
Updated

Summary

CCH ProSystem has a payment import utility for an additional cost from CCH (not Aiwyn). If you subscribe to this tool, Aiwyn can help you build out to import template in CCH ProSystem.

Included in this article:

Set up CCH ProSystem AR payment import utility

Once installed, your Aiwyn Implementation Manager can assist your firm in creating the template in the CCH ProSystem AR import tool.

  1. Open the application (must be installed on firm user’s computer)
  2. The first time you use the utility you won’t have any templates set up yet, so you’ll get prompted to create a template (first screenshot below) and be taken directly to the “Manage Templates” screen.
image (36).png
  1. In the “Manage Templates” screen, click the “Create New Template” button
image (37).png
  1. In the “Manage Templates” screen, you see all the fields needed to create a template
  2. Name the template “Aiwyn Import”
  3. Select “Yes” for “Importing Check Numbers”
  4. Select “Yes” for “Importing Client Numbers”
image (38).png
  1. Enable Display for 5 Columns by selecting the checkmarks 1-5
  2. Display Order 1:
    1. Header to Display = “Client ID”
    2. Excel File Column = “A”
    3. Select the bullet point for “Contains CltNum.EngNum”
  3. Display Order 2:
    1. Header to Display = “Invoice Number”
    2. Excel File Column = “B”
    3. Select the bullet point for “Contains Invoice Number”
  4. Display Order 3:
    1. Header to Display = “Payment Amount”
    2. Excel File Column = “C”
    3. Select the bullet point for “Contains Amount to Apply”
  5. Display Order 4:
    1. Header to Display = “Check No”
    2. Excel File Column = “D”
    3. Select the bullet point for “Contains Check Number”
  6. Display Order 5:
    1. Header to Display = “Type”
    2. Excel File Column = “E”
    3. No bullet point selection
  7. Save template changes
  8. To test, once the firm receives their first Payment Export File from a deposit, you can import the payments using the tool.

 

CCH ProSystem payment import process

  1. Firm admin, the day of a deposit, download the file “payment export” sent to the Payment Notification Email Recipient.
  2. Open it, save as Excel file (it comes as CSV but must be saved/imported as Excel).
  3. Go to the CCH ProSystem Payment Import Utility
  4. Select the Aiwyn Import template from the drop down list
image (39).png
  1. Choose the saved payment export file and select Go
  2. Select Go under “Validate Data”
  3. All items will be Validated with green checkmark indicating “ok to import”
  4. Select Go under “Import Data”
image (40).png
  1. Receive an on screen confirmation:
image (41).png
  1. At that point, the firm needs to “Post the Register” (this is a common action for them)
    1. Go to “Update AR”
      image (42).png
    2. Choose deposit date
      image (43).png
    3. Select all the Client entries
    4. Click Register
    5. Click Post

 

Example import file template

Here is an example file format. 

Client ID Invoice Number Payment Amount Check No Type
12345.001 87456 500 999999 CC-Invoice-65566-32144
12345.001 87455 450 999999 CC-Invoice-65567-32144

Also, attached to this article is an example payment import template, displaying what we could provide in your own file.

Work with Aiwyn Implementation to build your corresponding Aiwyn payment import template so that the file we send matches the template you've built in CCH ProSystem.

Related articles