Configure, review, and edit journal-entry mappings

Open Workpaper Agent → Workpapers and select the workbook for the correct company and period. Check the source dates, accounts, amounts, payees, and dimensions. For Sage, confirm the intended posting entity.

Open Draft journal entries above chat and choose Prepare for the first draft. Preparation creates the structured Truewind tab when needed. For an existing draft, follow the panel’s Next step and wait for preparation and validation to finish.

When Truewind finds a new value it cannot confidently match, an uncertain match, or a mapping discrepancy between the workbook and ERP records, it requests your input. Choose Review mappings when the panel prompts you. For an existing draft, this action may be under the arrow beside the main button.

In Review mapping items, compare each spreadsheet value with the proposed account, payee, or dimension. Check Proposed mappings for unresolved choices and Applied mappings for saved workbook choices. Rows shows how many source rows share a mapping.

The screenshot shows Applied mappings for two saved accounts. Proposed mappings appear when a workpaper needs a choice. If no review is requested, continue to Preview in Step 4.

Open the value picker for each item needing a decision. Search by ERP name or code, select the intended active record, and check its entity scope. Complete fields marked with an asterisk, including any additional dimensions required by the selected account.

Choose Confirm mappings when offered. If you are correcting a prepared draft and see Update journal entries, first review the affected entry references. The update applies to the identified unposted entries; posted entries are unchanged.

Confirmed choices are saved with the workbook. Valid, reusable mappings are also saved to the organization’s mapping configuration for future use. Continue to Step 4 to verify the resulting draft lines. Steps 8–9 explain where to check and change the saved configuration for future use.

Return to the workbook and inspect the mapped journal-entry rows in the Truewind tab. Open Draft journal entries → Preview to compare dates, period, memo, accounts, descriptions, payees, and dimensions with the source. For Sage, check Posting entity. Scroll the line-item table horizontally to see additional columns.

Check each debit and credit amount, confirm Difference is zero, and complete your accounting review and required approval. Balanced or Ready to post does not mean approved.

If the panel says stale, wait for workbook edits to save, use Refresh, and review the updated Preview. The screenshot shows this stale state; posting is disabled until the draft is refreshed.

Once Preview is current and validation issues are resolved, select only the entries you have reviewed. Check the selected count, then click Post, such as Post (2) selected, to open the confirmation dialog.

Opening the confirmation does not send the entries. Return to Preview if the selection or accounting details need to change.

Review the confirmation before clicking its final Post button. For Sage Intacct, select the intended Journal book, or Use journal books from workpaper when offered and appropriate. Resolve unavailable-journal warnings first.

Post as draft is off by default. Enable it if you intend to create Sage drafts for later review and posting; leaving it off requests posting. This choice is separate from Sage’s approval requirements. Review any attachments offered by your integration.

Click the final Post once and wait for each entry’s result. If mapping review interrupts posting and offers Update and Post Journal Entries, treat that as a posting action: confirming it can resume submission.

The screenshot shows the demo’s saved Preview before its later edits, with Post enabled. It shows the button that opens confirmation, not the confirmation dialog or a completed posting.

Open Workpaper Agent → Journal Entries and find the submitted entries. Check each status and open the reference to review the saved date, memo, accounts, dimensions, and amounts against your final Preview. Keep the accounting-system reference.

Posting means the request is still running. Investigate failed entries separately. If the outcome is unclear, check the accounting system for the reference, date, amount, and memo before retrying; do not resend successful entries.

The screenshot shows an existing saved example, not a new posting from this walkthrough.

In the correct accounting company and entity, find the matching entry and compare its accounts, dimensions, dates, and amounts. Confirm there is only one intended posting.

For Sage Intacct, open General Ledger → Journal entries → the relevant journal → View transactions, find the reference, and choose View. Check State: Posted confirms ledger posting; Draft or pending approval still requires the Sage review/posting process. A successful send from Truewind does not by itself confirm Sage ledger completion.

The existing Sage screenshot illustrates the final State check.

After confirming the workbook mappings and completing preparation, open Settings → Workpaper Agent → Mappings in the same organization. Search for the workbook value or ERP value, or use the Dimension filter.

Compare the saved spreadsheet column and value with the dimension and ERP value. This is where you can review reusable mappings learned from workpapers. You do not need to create the mapping here before preparing the workbook.

If the saved choice is correct, no Settings change is needed. To change it for future use, continue to Step 9. A choice restricted to particular workbook rows is not a general organization default.

An Admin or Accountant can click Update mapping beside an existing row. In Update organization mapping, choose the intended Replacement Sage Intacct value. Check its full name and account code or record ID, then click Save mapping.

This changes future mapping decisions. It does not rewrite existing workbook mappings or open drafts. To correct an unposted draft too, return to Review mappings and repeat Steps 2–3, then check Preview.