Manage Column Mappings for Disbursement Report Formats

From Treasury, you can upload a disbursement report from a payment processor to reconcile credit card transactions in your database with the transactions included in the report. To reconcile transactions, the program searches for transactions that meet the criteria of the report's transactions.

Tip: The program automatically provides column mappings for the disbursement report from Blackbaud Merchant Services. To use this format, select BBMS in the Report format field on the Upload disbursement report screen.

If necessary, you can add an additional column mapping for a payment processor when you upload a disbursement report. You can also edit an existing column mapping. For example, if the payment processor adjusts the columns included in the disbursement report, you may need to edit the column mappings.

You may need to edit the column mapping created for a disbursement report format, for example, if the payment processor adjusts the information included in the report file. You can edit the column mapping as necessary when you upload the disbursement report.