Filename: payments.csv
This file contains a list of all payments made by a customer. This details the date that a payment was made, the payment type, and how much of the payment was applied to an invoice. This does not allow you to specify which invoice the payment was applied to. Any payments whose applied amount is less than the payment total will have the remained used as credit and applied to any open invoices.
Importing payments with all payments as applied will not show the individual payment applying towards a specific invoice. This can be done, however, by setting all invoices to 0 paid, and all payments as 0 applied. Payments and invoice totals must balance for this to work correctly, or the account will have a balance which may not be what was intended. Verify the invoice/statement balance for each customer before using this method.
This has the following columns:
| Column Name | Description |
|---|---|
| customer_original_id | the unique id for the matching record in the customer file. Multiple entries for the same customer are accepted and all will be added separately. |
| total | The total amount successfully paid for this single payment |
| applied | The amount from the total that was applied to an invoice. This can be less than the total if some of the payment was not applied towards any invoices - unapplied payments act as a credit on the account. This should not be greater than the total. |
| date | The date that this payment was made MM/DD/YYYY |
| type | The payment type can be one of (“CHECK”, “CASH”, “STORE CREDIT”, “VISA”, “AMEX”, “MASTERCARD”, “DISCOVER”, “VOID”) |