/
How to run ACH reports for International Chapters

How to run ACH reports for International Chapters

Owned by Brian McLaren (Deactivated)
Last updated: Jan 28, 2021

We distrute money to the International chapters quarterly. Their money is distrubted via International Wire transfer that is manually processed. When a distribution is sent to the international chapters, the finance team includes a courtesy distribution report via email because most international chapters don't have a dedicated staff person with Component Portal access.

Step-by-step guide

These are the steps to create the distribution

  1. Open the Finance application
  2. Select the dates for the receipts you want to distribute (usually quarterly, e.g., Oct 1 - Dec 31)
  3. Select "Quarterly" as the distribution type
  4. Create the distribution.
  5. Once the batch number has been created, select the distribution date (this is the date that the bank will most likely transfer the money)
  6. If there are negative distribtuions, then select "Remove negative distributions"
  7. Download the summary report and detail reports
  8. After you have downloaded these reports, then select "Commit Batch"

These are the steps to create the distribtution report that is emailed to the chapter as a courtesy

  1. Go to "Reports"
  2. In the folder tree, select "All folders" then "ACH Reports" and click on the "International Distribution Report"
  3. Select "Edit" and then adjust the filter for your "Distribution Batch" and "Chapter Name"
  4. Clickon "Run"
  5. Use the down arrow next to "Edit" and select "Export" to export the file
  6. Choose the "Formated Report" and save it
  7. Open the report and adjust any refunds to be negative and overwrite the total with a sum formula
  8. Save the report again with the appropriate report name and attach it to the courtesy email to for the chapter.


Make sure your filter exactly matches the Chapter name and the batch number

Example

  • Chapter name = AIA Canada Society
  • Distribution batch = 000123