Reconcile and post settlements
Post settlement batches to the Spruce GL.
Post settlement batches to the Spruce GL. The Settlements tab groups incoming payments into batches and tracks whether each batch has been posted.
Navigate to Settlements
Click Payments in the left sidebar, then click the Settlements tab. You will see a list of settlement records, each representing a batch of related payments. The list columns are Type, Completed, Payments, Accounts, Invoices, Discounts, Debits & Charges, Credits, Fees, Total, and Postings.
Post a settlement
Posting is the step that writes a settlement's payments to the Spruce general ledger. Once every category in a settlement is posted, that money is reflected in your GL.
From the Postings cell on a settlement, the available action depends on where the settlement is in the posting process: Start Posting to begin, Continue Posting to pick up where you left off, View Results once a posting has run, and Resolve Errors if a posting failed or only partially completed.
Auto-post invoices (ECI Spruce integration)
If your dealership has direct Spruce integration, invoices auto-post:
- Click a settlement row to open its detail view, then Start Posting.
- Drypowder sends the invoice data directly to the Spruce GL.
- The wizard shows progress, and the invoice posting timestamp is set automatically when complete.
Auto-posting invoices is the fastest method. No files to download, no manual data entry.
Auto-post invoices (other ERP integrations)
If your dealership connects to its ERP through a third-party integration partner rather than direct Spruce integration, posting can also complete automatically. Your integration partner reports the result back to Drypowder, and the wizard shows a progress step while it waits. There is no action to take while posting is in progress; the wizard advances to Completed once your ERP finishes.
If posting only partially completes or fails, the posting results list each affected payment line with its own status and the reason it failed, so you know what to check in your ERP. The same Download options for errors and completed lines are available here.
If your integration partner uploaded a supporting document with the posting, open it from the settlement row's action menu, alongside the CSV downloads. The entry only appears when a document was uploaded.
Post debit adjustments (manual)
In the posting wizard this step is titled Debits & Finance Charges. Debit adjustments are always posted manually, even on a Spruce integration:
- In the posting wizard, download the adjustment file.
- Post the adjustments in your ERP.
- Return to the settlement and confirm the posting.
Confirming records that you posted the adjustments. Drypowder cannot check your ERP to see whether they arrived, so post the file before you confirm.
Post credit adjustments and discounts (manual)
Credit adjustments are posted by hand. When the payments in a settlement captured a terms discount, the step is titled Credit Adjustments & Discounts, and the discounts are listed with the credits they belong to.
Check each discount yourself. Spruce takes the terms discount when a payment comes through the posting file, but not when you apply a credit by hand to clear a balance. Skip it and the discount stays on the account, so the dealership collects less than it billed.
- Open the credit posting step. Each row shows one credit and the account or document it applies to.
- Apply each credit in Spruce as its row directs, either Apply to oldest charges or Apply to the named document. Use the copy buttons for the document ID and the account ID.
- For each discount row, check in Spruce whether the discount was captured, and enter it if it was not. A row reads Discount on Job with the job ID, or Discount on account balance.
- Click Done posting credits.
To work from a spreadsheet instead, click Download credits CSV.
Do not add the discount rows together. Each row is one Spruce statement. A combined figure entered once leaves the discount unclaimed on every other row.
Statement and Current discount lines
A discount row may split into a Statement line and a Current line, each with its own amount.
The split tells you what is left to enter. Spruce takes the statement pool with the payment. It does not take the new-charges pool when you apply a credit by hand, so Current is the figure to check.
The split does not always appear. Drypowder shows it only when the two figures add up to the discount captured at the time of payment. When a billing cycle closes, the current discount rolls into the statement discount and the current bucket refills, so for a payment older than one cycle the two figures no longer match what was priced. The row then shows a single combined amount.
Resolve errors
If a posting fails or only partially completes, use Resolve Errors on the settlement to work through the items that did not post. There is no general "mark as reconciled" step beyond completing the posting for each category.
Download a summary
For record-keeping, click Download Summary CSV to get a file containing all payments in the settlement with amounts, methods, and dates.
Daily versus monthly workflow
Daily (about five minutes). Check the Settlements tab for any new settlements. Post them as they appear. Keeping up daily prevents a backlog at month-end.
Monthly. Review all settlements for the month. Confirm everything is posted. If any settlements still have unposted items or posting errors, investigate and post them before closing the books.
Related
- Your first settlement reconciliation — Introductory tutorial.
- Payments page reference — Full detail on the Settlements tab.
- How payments flow from invoice to GL — The full explanation.