Ask the support agent

Just ask a direct question or search related articles from the Knowledge Base.

Support Center / Workpaper Agent / Deposit Reconciliation

Deposit Reconciliation In Workpaper Studio

Prepare Deposit Reconciliation work from the template through Workpaper Studio when raw files need to become an import-ready workbook, resulting in a validated workbook ready for import from the Studio sidebar.

Workflow

Step 1

Open Workpaper Agent

Start in Truewind on Workpaper Agent > Templates so the Builder entrypoints are available for a new deposit workflow.

Step 2

Choose the Deposit Reconciliation template

Start from the Deposit Reconciliation template when you want Builder to prepare the first workbook from raw files instead of entering Studio with an existing workbook.

Step 3

Upload the source files

Add the raw files the template needs before asking the agent to prepare the workbook.

Step 4

Generate or confirm the SOP

Make sure the workpaper has SOP content before preparing, because Builder will block Prepare when SOP content is missing.

Step 5

Click Prepare

Start the prepare run from Builder once the uploads and SOP are both in place.

Step 6

Wait for the prepared workbook

Let the prepare run complete before moving into Studio or the next Deposit Reconciliation step.

Step 7

Open the prepared result in Studio

Open the resulting Studio workpaper after the prepare run completes so you can continue with readiness and import.

Step 8

Open the workbook in Studio

Start in Truewind on Workpaper Agent > Studio when the workbook already exists there and you are ready to continue into Deposit Reconciliation.

Step 9

Open the Deposit Reconciliations panel

Switch the right-side Studio panel from Chat to Deposit Reconciliations so the readiness card is visible.

Step 10

Check whether the ERP connection banner is showing

If Studio shows Connect ERP, stop here and finish the ERP connection first because import cannot continue without it.

Step 11

Read the readiness message

Look for the current readiness state before clicking anything, because the workbook must be validated before the import controls appear.

Step 12

Click Prepare if the workbook is not ready

This matters because if Studio says the workbook is not ready, including cases where the required TW_Staging tab is missing, click Prepare in the Deposit Reconciliations panel.

Step 13

Confirm Prepare started

Wait for the Prepare started toast so you know Studio successfully queued the request for the agent.

Step 14

Wait for the agent run to finish in chat

Keep the chat panel open while the agent works for a few minutes and finishes updating the workbook.

Step 15

Confirm the TW_Staging tab now exists

Check the workbook after the run and confirm the TW_Staging tab was created, because Deposit Reconciliation import depends on that tab.

Step 16

Open the Deposit Reconciliations panel again

Return to the Deposit Reconciliations panel after the run so the updated readiness state and import controls reload.

Step 17

Confirm the workbook is ready to import

Wait until the panel says the workbook is ready before trying to choose a clearing account or import.

Step 18

Select a clearing account

This opens the clearing-account dropdown and lets you choose the exact account that should receive this import in Deposit Reconciliations.

Step 19

Import the workbook

Run the import only after the workbook is ready and the clearing account is selected so Deposit Reconciliation accepts the file.

Step 20

Confirm the imported upload opens in a new tab

After import succeeds, Studio opens the Deposit Reconciliations upload in a new tab so you can continue the downstream workflow there.

What this workflow does

This workflow covers both stages of the Deposit Reconciliation path:

preparing the first workbook from raw files in Workpaper Agent
validating and importing that workbook from Workpaper Studio into Deposit Reconciliations

FAQ

When should I use the Deposit Reconciliation template instead of starting in Studio manually?

Use the template when you have raw source files and need Workpaper Agent to prepare the first workbook before you continue in Studio.

What should I expect after Prepare finishes?

The run produces a prepared workbook you can open in Studio, then validate and import through the Deposit Reconciliations panel.

What happens if the workbook is not ready to import?

If Studio says the workbook is not ready, click Prepare in the Deposit Reconciliations panel. The agent runs for a few minutes and updates the workbook so the readiness check can run again.

Why is the TW_Staging tab important?

The import workflow depends on the TW_Staging tab. If it is missing, the workbook is not ready for import and you must run Prepare to generate it.

Limitations

The prepared workbook still depends on source-file quality

If the raw files are incomplete or inconsistent, the prepared workbook may still need review or another Prepare pass before it is ready to import.

Deposit Reconciliation import does not happen from Builder

Builder only prepares the workbook. The actual readiness check, clearing-account selection, and import happen later inside Studio.

Import stays blocked without a valid TW_Staging tab

Deposit Reconciliation import will not continue until the workbook includes a valid TW_Staging tab with the importer-ready structure.

Clearing account selection is required before import

Even after the workbook becomes ready, import cannot start until you choose the exact clearing account that should receive the workbook downstream.

Troubleshooting

The prepared workbook opens in Studio but still is not import-ready.

Open the Deposit Reconciliations panel in Studio, review the readiness message, and run Prepare again if the workbook is still missing TW_Staging or other importer-ready content.

The wrong raw files were used during preparation.

Start a new run from the same template with the correct uploads instead of trying to force the existing workbook into the wrong import path.

The Deposit Reconciliations panel says the workbook is not ready.

Click Prepare, wait for the chat run to finish, then reopen the Deposit Reconciliations panel and confirm that TW_Staging now exists.

Import is disabled even though the workbook says ready.

Open the clearing-account dropdown and select the exact clearing account first. The Import button stays disabled until an account is selected.

Was this helpful?

Need more help?

Ask for human help about this article and provide any feedback.