Auto-Reconcile Payments

Owned by Sara Glore
Last updated: Oct 21, 2021

This document will walk you through how to upload a file from your bank into USPS to Auto-Reconcile payments that have cleared the bank. 

Prior to using the Auto-Reconcile option, the 'Pay Rec Bank Format' must be set under Utilities/Automatic Payment Reconciliation/Pay Rec tab.  Please contact NWOCA Fiscal Support and they will set up the required format for your bank. 

Once the format is configured, follow the below steps to Auto-Reconcile payments.

  1. Download the file from your bank
  2. Go to Payments/Check Register
    1. Click on Auto-Reconcile on the top left hand side of the grid.
    2. A pop up box will display: 
      1. Reconciliation Date : enter reconciliation date
      2. Pay Rec Format: select format to match upload file
      3. Bank Account: select the bank account this disbursements were written against
      4. Click on Choose file: bank file on your computer

      5. Click on Upload 

  3. When the program is complete an Auto-Reconciliation Summary box will display.

    If desired you can download the summary as a PDF.