Settlement Pattern Library
Net deposit triage for NetSuite reconciliation
Use this pattern when the bank deposit is easy to see but the source detail behind it is hard to defend.
The method
How do you triage a net deposit that does not tie to NetSuite?
Net deposit triage identifies why a single bank deposit does not match NetSuite sales activity. The operator method breaks the deposit into gross activity, refunds, processor fees, marketplace adjustments, reserves, and timing gaps before deciding whether the difference is expected, missing, or needs finance review.
Key takeaways
- Treat the net deposit as an outcome, not the reconciliation source.
- Break the deposit into activity categories before matching to NetSuite.
- Separate expected timing from missing or misclassified source detail.
- Keep the unresolved difference visible with a reason and owner.
01 · The pattern
What causes a net deposit to miss NetSuite?
The deposit is usually net of many events that NetSuite stores separately. Sales, refunds, fees, chargebacks, reserves, and adjustments can all move cash without sharing the same event date or record type. Triage starts by decomposing the deposit into those categories before looking for a ledger fix.
| Signal | Likely cause | Operator response |
|---|---|---|
| Deposit is lower than gross sales | Fees, refunds, reserves, or chargebacks are netted out | Separate each deduction category before posting the net result. |
| Deposit crosses period boundaries | Settlement cutoff differs from NetSuite posting date | Classify as timing only when the source detail supports it. |
| Source lines have no NetSuite match | Missing order, failed integration, or unmatched adjustment | Hold as an exception with owner and reason code. |
02 · The pattern
What is the safe order of operations?
A safe triage path moves from source evidence to posting, not the other way around. First collect the payout or settlement detail, normalize the categories, map each category to NetSuite treatment, review unresolved lines, and only then post the reconciled deposit or adjustment.
- Confirm the source file and payout period.
- Group activity by business meaning before account treatment.
- Match source lines to NetSuite transactions where possible.
- Route unresolved differences to a review gate.
03 · The pattern
When should the pattern become a workflow?
Net deposit triage should become a governed workflow when the same categories recur, when finance repeats the same spreadsheet rebuild, or when the close depends on one person's knowledge. That is the signal to define matching rules, exception reasons, ownership, and posting controls.
Shared vocabulary
What terms matter on this page?
These definitions keep the method precise and extractable for answer engines, while giving finance a shared vocabulary for source files, NetSuite treatment, and review gates.
Net deposit
A net deposit is the cash amount that reaches the bank after a channel deducts fees, refunds, reserves, and adjustments.
Gross activity
Gross activity is the full source-level sales, refund, fee, and adjustment detail before it is compressed into the payout.
Reason code
A reason code explains why a source line did not reconcile and what review path should happen next.
Where it goes next
When the pattern becomes an operating decision
This pattern sits between the settlement library, productized reconciliation, and the service paths that explain why the mismatch keeps recurring.
If this reconciliation pattern is caused by connector behavior, the operating decision belongs with a Celigo NetSuite integration partner. If the issue comes from a stalled implementation or brittle partner handoff, compare it with NetSuite HealthCheck and recovery. If the same pattern recurs every close, evaluate Vista Recon against the full NetSuite payout reconciliation.
Authorship
Who wrote this guide?
Written by Dave Charland, Founder, Altura Innovation. Last updated 2026-06-16.
FAQ
Frequently asked questions
Need this pattern converted into a governed workflow?
Tell us where the source file, NetSuite record, and close process stop agreeing, and we will help scope the safest Vista Recon path.