Workpaper agent + Deposit reconciliation workflow

Use the Deposit Reconciliation template when raw files need to become a workbook ready for the next deposit workflow, resulting in a prepared workpaper that can continue into Studio and Deposit Reconciliations.

Workflow

Setup workflow

Step 1

Open Workpaper Agent

Open the Workpaper Agent area where templates and the Builder entrypoints are available.

Step 2

Choose the Deposit Reconciliation template

Select the Deposit Reconciliation template instead of starting from a blank workpaper.

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 to finish

Let the prepare run complete before moving into Studio or the next deposit workflow.

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

Continue into Deposit Reconciliations

Use the Studio Deposit Reconciliations panel to validate readiness, select a clearing account, and import the workbook when it is ready.

What this workflow does

The Deposit Reconciliation template prepares raw-file inputs in Workpaper Agent and helps move them into the Deposit Reconciliations product workflow.

FAQ

When should I use this template instead of starting in Studio manually?

Use it when you have raw source files and want Workpaper Agent to prepare the first workbook before you continue into Studio and Deposit Reconciliations.

What should I expect after Prepare finishes?

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

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 Matching import does not happen from Builder

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

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.

Was this helpful?

Need more help?

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