Your first settlement reconciliation
Post a batch of settled payments to the Spruce general ledger and verify the result. About ten minutes.
This tutorial walks you through posting a settlement to the Spruce general ledger and verifying the result. By the end, you will understand how payments, settlements, and GL postings connect in Drypowder.
Plan on about ten minutes. You will need at least one settled payment in the system to follow along.
What is a settlement?
A settlement is a batch of related incoming payments that have been processed and deposited. Settlements appear on the Settlements tab of the Payments page. Each settlement tracks whether its invoices, credit adjustments, and debit adjustments have been posted to the Spruce general ledger.
Step 1: Navigate to the Settlements tab
Click Payments in the left sidebar, then click the Settlements tab. You will see a list of settlement records. Each row shows:
| Column | What it tells you |
|---|---|
| Settlement ID | Unique identifier |
| Created Date | When the settlement was created |
| Payment Count | Number of payments in this batch |
| Posting Status | Whether invoices, credits, and debits have been posted |
| Resolved | Whether the settlement has been marked as reconciled |
Step 2: Open a settlement
Click on a settlement row to see its details. The detail view shows which payments are included and the posting status for each category:
- Invoices — Posted or not posted, with timestamp
- Credit Adjustments — Posted or not posted, with timestamp
- Debit Adjustments — Posted or not posted, with timestamp
If nothing has been posted yet, all three categories will show as unposted.
Step 3: Post to the GL
Click the Post action to open the posting wizard. If your dealership uses Spruce integration, you will see two options.
Auto-post (ECI Spruce): Drypowder posts the settlement data directly to the Spruce general ledger through the integration. The wizard shows a progress indicator while posting and confirms when complete. This is the fastest path; no manual file handling required.
Manual post: Drypowder generates a CSV file that you download and upload to your ERP yourself. Use this option if you prefer to review the data before it hits the GL, or if your dealership uses file-based integration rather than direct Spruce connectivity.
For this tutorial, choose whichever method your dealership uses. If you are on Spruce with direct integration, auto-post is the recommended path.
Step 4: Verify the posting
After posting completes:
- The settlement's posting status updates to show Posted with a timestamp for each category (invoices, credits, debits).
- If you auto-posted, the payments are now reflected in the Spruce GL. You can verify by checking the customer's account in Spruce.
- If you manually posted, upload the downloaded file to your ERP and then return to the settlement to update the posted timestamps.
Step 5: Resolve the settlement
Once you have verified that everything is posted correctly, click Resolve to mark the settlement as reconciled. This flags the settlement as complete so you can distinguish it from settlements that still need attention.
Resolving is optional but recommended. It keeps your settlements list clean and makes it easy to see at a glance which settlements are fully processed.
Step 6: Download a summary
If you need a record of the settlement for your files, click Download Summary CSV. This generates a CSV with all payments in the settlement, including amounts, payment methods, and dates. It is useful for month-end records or sharing with your controller.
What you just did
You took a batch of settled payments, posted them to the Spruce GL (either automatically or via file), verified the posting, and marked the settlement as reconciled. That is the core settlement workflow in Drypowder.
What to do next
- Reconcile and post settlements — The how-to guide for daily and monthly reconciliation workflows.
- Payments page reference — Full documentation of the Incoming Payments and Settlements tabs.
- How payments flow from invoice to GL — Understand the full journey from customer submission to general ledger entry.