Upload a disbursement report

1. From Treasury, select Reconcile transactions and disbursements. The Reconcile transactions and disbursements page appears.

2. Under Tasks, select Upload disbursement report. The Upload disbursement report screen appears.

   Note: You can also upload a disbursement report from the Treasury page. Under Credit card reconciliation, select Upload disbursement report.

   Warning: The disbursement report file must be a comma-separated values (*.csv) file, and its header row must contain the field names. If your processor includes other information in the header of its disbursement report, copy and paste the disbursement information into a new file to upload.

3. Upload the *.csv file of the disbursement report to use to reconcile credit card transactions.

   1. Select Upload file. The Upload file screen appears.

   2. In the Disbursement report file field, select Choose file.

   3. Browse to the disbursement report file to upload and select Open. You return to the Upload file screen. In the File name field, the selected disbursement report file appears.

   4. Select OK. You return to the Upload disbursement report screen.

      Tip: To select a different disbursement report file, select Clear file, and then select Choose file to browse to and select the correct file.

4. In the Report format field, select the type of disbursement report to upload.

   You can add and edit report formats as necessary. For example, you can add a new format or edit the columns included in a format. For information about how to manage report format, refer toManage Column Mappings for Disbursement Report Formats.

5. Select whether the first row of the report file is the header row.

6. Select Save. The program automatically searches the database for the transactions included in the disbursement report and marks them as Reconciled. You return to the Reconcile transactions and disbursements page.

   Note: The View by transaction, View by disbursement, Suspect charges, and Card chargebacks tabs display any pending credit card transactions in your database not included in the disbursement report. These transactions may indicate transactions that the payment processor marked as suspect, transactions held or refunded by the processor due to a chargeback request from the cardholder, or transactions to be processed in a separate disbursement. We recommend you investigate these transactions to determine why they are pending. For information about how to manually mark a transaction as pending, refer toMark a Transaction as Reconciled or Pending.

   Note: The Unmatched disbursements tab displays any transactions in the disbursement report that do not match a revenue transaction. Your organization may have submitted these transactions to the processor from outside of the program, or the automatic reconciliation may not have successfully matched these transactions with their counterparts in the database. For information about how to manage these transactions, refer toView Unmatched Disbursements.