Payment Allocations Export

Finding the Payment Allocations Export

To generate an export of payment allocations, open Exports, select Create Export, then select Payment Allocations under Finance. You need both the Access Exports Module and Access Finance Module permissions.

Configuring the Export

From

The start of the payment date range. The whole day is included.

To

The end of the payment date range. The whole day is included.

Creating the Export

After setting the date range, click on “Create Export”.

Downloading the Export

When the export is ready it will appear on the Exports page where you can click on Download to save it to your device.

Exported Fields

• The CSV file will include several important headings:
  • Payment ID: The unique identifier for each payment.
  • Date: The date of the payment.
  • Payment Reference: The reference number for the payment.
  • Payment Type: The method or type of payment.
  • Payment Amount: The total amount of the payment.
  • Allocated Amount: The total amount allocated from the payment across all invoices. This value is repeated for each allocation row from the same payment.
  • Invoice: The associated invoice number.
  • Invoice Date: The date when the invoice was issued.
  • Amount: The amount of this payment allocated to the invoice on this row.

The CSV contains one row per payment allocation, ordered with the newest payment first. A payment split across several invoices produces several rows. A payment with no allocations produces no row.