ECI Spruce: Reconcile Payments and Credit Memos

This guide shows you how to reconcile Drypowder payments and consumed credit memos manually into ECI Spruce.

You will:

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

Follow the instructions in Download Payment Files help doc, then proceed with this guide.

Enter invoice payments in ECI Spruce

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

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

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

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

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

Click Process to process the imported payment file.

Post the payments and credit memos in ECI Spruce

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

Payments

Post the payments entered in the last step, using the instructions in ECI Spruce Posting.

If you have any credit memos to post, proceed to the next step. Otherwise skip.

Credit memos

Use the same instructions as those for payments, but you’ll need to manually select the invoices.

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)

Post the payments

Click Post (F8). You are done.