ECI: Payment entry

Enter Drypowder payments and credit memos in ECI Spruce

1. Download the payment file

2. Enter invoice payments in ECI Spruce Payment Entry

3. Post the payments and the credit memos in ECI Spruce Posting

Download payments file

Enter invoice payments in ECI Spruce

1. Launch your company’s ECI Spruce portal and navigate to Receivables > Payment Entry.

2. Upload the CSV file into ECI Spruce using the steps in ECI Spruce Payment Entry > Import (F2)

3. Map the CSV header to the five F1-F5 columns

1. Delete the header row that contains column names or Spruce will display an error.

2. Delete all rows that where document_type = credit_memo. You’ll enter each of these in the posting step.

3. Click Process to process the imported payment file

Post the payments and credit memos in ECI Spruce

1. Launch your company’s ECI Spruce portal and navigate to Receivables > Posting.

2. Payments
1. Post the payments entered in the last step, using the instructions in ECI Spruce Posting
2. If you have any credit memos to post, proceed to the next step. Otherwise, skip to step 4.

3. Credit memos
1. Use the same instructions as those for payments, but you’ll need to manually select the invoices.
2. For each credit memo row in the CSV (document_type = credit_memo):
1. In the download file, note the applied_document_id and payment_amount . You’ll enter these values in Spruce.
2. In Spruce, find the invoice that matches the applied_document_id (See Spruce screenshot)
3. Enter the payment_amount in the the Apply column for the matching invoice (See Spruce screenshot)
 

1. Click Post (F8). You are done.