This guide shows you how to reconcile Drypowder payments and consumed credit memos manually into ECI Spruce. You will:
- Download the payment file
- Enter invoice payments in ECI Spruce Payment Entry
- Post the payments and the credit memos in ECI Spruce Posting
Download payments file
Follow the instructions in Download Payments File, 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.
Drypowder CSV column | Spruce Mapping |
account_id | Customer |
job_id | JobID |
payment_id | CheckNum |
payment_amount | CheckAmount |
document_id | Apply DocId |
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):
- In the download file, note the
applied_document_idandpayment_amount. You’ll enter these values in Spruce.
- In Spruce, find the invoice that matches the
applied_document_id(See Spruce screenshot)
- Enter the
payment_amountin the the Apply column for the matching invoice (See Spruce screenshot)
Post the payments
Click Post (F8). You are done.