What to verify
- the clearing account is configured before import
- category and payee exceptions are resolved before posting
- the final reference link opens the expected ERP record
Ask the support agent
Just ask a direct question or search related articles from the Knowledge Base.
Support Center / Deposit Reconciliation / Overview
Deposit Reconciliation overview
Use Deposit Reconciliation when you need to import payout files, resolve mapping exceptions, and post or match deposit activity, resulting in posted or matched deposit records in the ERP.
Workflow
Step 1
Open Bookkeeping
Start in Truewind on Bookkeeping so you can access Deposit Reconciliation.
Step 2
Open Deposit Reconciliations
This opens the Deposit Reconciliation workspace where you manage uploads, exceptions, and posting.
Step 3
Review the clearing-account setup reminder
Deposit Reconciliation depends on a configured clearing account, so finish that setup before importing a file.
Step 4
Upload the deposit file
Start the import by selecting or dragging in the file you want to reconcile.
Step 5
Open Ready for Import
Move into the Ready for Import state after the file upload is accepted.
Step 6
Review file issues
Resolve any import issues shown here before continuing with the upload.
Step 7
Enter the TW_Stage description
Fill in the upload description so the staged file is easier to track later.
Step 8
Review category exceptions
Open the category exception list when Truewind cannot map a category automatically.
Step 9
Map unmatched categories
Manually map any category that does not have an exact account match in the ERP.
Step 10
Review payee exceptions
Open the payee exception list when uploaded payees do not auto-match to existing ERP payees.
Step 11
Review unmatched payees
Deposit Reconciliation supports manually matching a payee or creating a new payee with the uploaded contact details.
Step 12
Match an existing payee
Select the correct ERP payee from the dropdown when the uploaded payee already exists.
Step 13
Review contact details
Open the contact details when you need more context before choosing the ERP payee.
Step 14
Review the matched info
Use the green indicator to confirm the uploaded payee information matches the existing ERP record.
Step 15
Add a new payee
Use Add Payee when the uploaded payee does not exist yet and should be created in the ERP.
Step 16
Confirm payee details are carried over
Uploaded contact or address details can be carried into the new ERP payee profile.
Step 17
Create the payee
Save the new payee only after the imported contact details look correct.
Step 18
Review add-payee guidance
Use the add-payee path when the uploaded information should become a new ERP payee instead of matching an existing one.
Step 19
View all payees
Open the full payee list when you need to audit or compare the available records before mapping.
Step 20
Open all payee records
Use the all-records view when you need the full ERP payee context during exception handling.
Step 21
Review the overview page
The overview summarizes the imported file before you move into unmatched, ready, or done states.
Step 22
Review transfer exceptions
Exceptions highlight transfers that were not matched to bank-account transactions automatically.
Step 23
Open Unmatched
Use the Unmatched tab to resolve deposits that still need manual review.
Step 24
Review Ready
The Ready tab contains transactions that are fully prepared to post or match in the ERP.
Step 25
Review account totals
The totals section summarizes the balance for each general-ledger account in the current file.
Step 26
Open Ready again
Return to Ready when you are prepared to post or match selected rows.
Step 27
Select a row
Pick the deposit row you want to post individually first.
Step 28
Post individually to QuickBooks
Use the individual posting path when you want to send a single deposit to the ERP.
Step 29
Confirm the post
Finish the individual post only after the selected row is correct.
Step 30
Confirm the posted status
The row status should move through Posting and into Posted after the ERP action completes.
Step 31
Review the posted transactions
Open the posted-transaction view to verify what was sent to the ERP.
Step 32
Review grouped posting
Use the grouped posting flow when you want to review all ready transactions together by payee.
Step 33
Open Transaction Details
Review the transaction details before posting the grouped Journal Entry.
Step 34
Select the rows
Choose the rows that should be posted together in the grouped Journal Entry.
Step 35
Post grouped to QuickBooks
Start the grouped posting flow when the selected rows should be combined in one ERP Journal Entry.
Step 36
Review the Journal Entry
Inspect the grouped Journal Entry before posting it to the ERP.
Step 37
Post to QuickBooks
Finish the grouped ERP post only after the Journal Entry review looks correct.
Step 38
Review Done
The Done tab contains all deposits that have already been posted or matched successfully.
Step 39
Review posted record types
Deposit Reconciliation can create or match deposits, expenses, and Journal Entries depending on the selected workflow.
Step 40
Open Posted
Use the Posted view to inspect the finished ERP results for the imported file.
Step 41
Open the ERP reference link
Follow the reference link when you want to inspect the final ERP record directly.
FAQ
What should I set up before importing a deposit file?
Set up the clearing account first, because Deposit Reconciliation depends on that mapping before file upload and posting can proceed.
What kinds of exceptions can appear after import?
Common exceptions include unmapped categories, unmatched payees, and transfers that could not be matched to bank-account transactions.
Limitations
Category and payee exceptions may need manual review
Deposit Reconciliation can identify exceptions automatically, but some categories and payees still need manual mapping before posting.
Posted records still depend on ERP configuration
The final posting or matching behavior depends on the mapped clearing account and the ERP configuration behind that account.
Troubleshooting
The file is not ready to import.
Review the import file first and resolve the listed exceptions before trying to post or match deposits.
A payee does not match automatically.
Manually select an existing payee, or use Add Payee when the payee is new and should be created in the ERP with its contact details.
Was this helpful?
Need more help?
Ask for human help about this article and provide any feedback.