Overview

Rules for Importing Payment and Deposit Transactions

• Payments and Deposits can only be imported through a Data Mapper.

A Payment must be applied to one Invoice through the Import. You can create multiple payments for the same Invoice, and for Invoices across Orders.

• Only Offline Payment Methods like banktransfer and checkmo can be used on your import.
• A Payment must list an Order Number and an Invoice Number.
• Set Payment Type to "Payment" for a Payment.
• If Payment Date is blank, the current date and time will be set as the Paid At.

Deposits

A Deposit can be created and applied to an Order which is not Invoiced.

• Deposits can only be created through Import if there are no Open or Paid Invoices.
• Deposit rows need an Order Number, but should not have an Invoice Number.
• The Payment Type for a Deposit payment is "Deposit".

Create the Transaction Import Data Mapper

Zoey can automatically import a CSV list of Transactions from an external system to record those payments, and update invoices. For that purpose we'll set up a Zoey Data Mapper to ingest the transaction data on a routine schedule.

1. Go to Integrations > Zoey Data Mappers. Set up your first Connection, or re-use an existing one to import that file from Dropbox, or an SFTP connection.
2. Then click Add Data Mapper to begin setting it up creating the mapper which will pull in your transaction data through the connection.
3. Set Zoey Object to Transactions and Type to File Import.
4. Under Mapper Template, select Transactions: Payment & Deposit CSV Import.
5. Enter the File Name, including .csv, and the File Import Folder where this file will be found.
6. Prepare your CSV using the rules above and template below, then upload it to that folder with the matching file name.
7. Save the mapper and select Run from its three-dot menu. Check that Payments appear on the specified Invoices and Deposits on the specified Orders.

Optional: Schedule the Import

Set Enabled and Use Schedule to Yes, then choose when and how often to run the import. Upload the CSV before each scheduled run.

---

Payment & Deposit Import Template

Use its format to import Payments and Deposits to your Orders automatically through Zoey Data Mappers!