Click Admin > Import/Export Payments list > Import Payments. The Import Statements window displays.

Note: The CSV file can only be imported once. If a row contains an incorrect format, correct the format and create a new CSV file for re-importing the relevant rows, as indicated in the Results window.

Click Import Payments to browse to your CSV file.

Note: The CSV file header fields must be in the following format:

• Date
• BankAccountID
• CompanyID
• ContactID (required for all PaymentsTypes besides Bank Payment In and Bank Payment Out)
• PropertyID
• UnitID
• NomRefCode
• PaymentType (required)
• ChequeNumber (required for PaymentType Cheque)
• Payee (required forPaymentType Cheque)
• BACSStatus
• Narrative
• Credit (required for PaymentTypes Bank Payment In, Payment In)
• Debit (required for PaymentTypes Cheque, Chaps, BACS, Direct Debit, Standing Order, Bank Payment Out)

Note: The ContactID can be obtained by clicking Admin > Import/Export Payments > Export Contacts.

Note: For PaymentType, the type must be one of the following:

• Bank Payment In
• Payment In
• Cheque
• Chaps
• BACS
• Direct Debit
• Standing Order
• Bank Payment Out

Note: For BACSStatus, the status must be one of the following:

• Not Queued
• Manually Processed
• Queued

To obtain the BankAccountID, CompanyID, PropertyID, UnitID, ContactID or NomRefCode, click Admin > Import/Export Payments and select the relevant list to export. The IDs are exported to an .xlsx file.

Introduced in version 2016.3.8.2653