Ask the support agent

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

Support Center / Deposit Reconciliation / Setup

Add clearing account in Sage

Create and map a clearing account in Sage when Deposit Reconciliation needs a destination account, resulting in a clearing account that can be selected during account setup and file import.

Workflow

Step 1

Open General Ledger

Start in Sage on General Ledger so you can create the clearing account in the chart of accounts first.

Screenshot showing General Ledger in Sage

Step 2

Open General Ledger again

Stay in the General Ledger area until the account-management options are visible.

Screenshot showing the General Ledger area in Sage

Step 3

Open General Ledger accounts

Use the accounts list to create the new clearing account instead of trying to map an account that does not exist yet.

Screenshot showing General Ledger accounts in Sage

Step 4

Add an account

Start a new account record in Sage before entering the account details.

Screenshot showing Add in the Sage accounts page

Step 5

Enter the account number

Use the number your team wants for the clearing account so it fits the existing chart-of-accounts structure.

Screenshot showing the account number field in Sage

Step 6

Enter the account name

Name the account clearly so it is easy to recognize later in Deposit Reconciliation.

Screenshot showing the account name field in Sage

Step 7

Enter the account code

Use the code Sage expects for this ledger record so the account can be saved without validation errors.

Screenshot showing the account code field in Sage

Step 8

Choose Cash and Cash Equivalents

Set the account classification correctly so Deposit Reconciliation maps to the right balance-sheet bucket.

Screenshot showing Cash and Cash Equivalents selected in Sage

Step 9

Set it as a balance sheet account

The clearing account should sit on the balance sheet rather than the income statement.

Screenshot showing Balance sheet account selected in Sage

Step 10

Set it as a non-closing account

This keeps the clearing account open across close periods for ongoing reconciliation activity.

Screenshot showing Non-closing account selected in Sage

Step 11

Save the account

Create the Sage account before you return to Deposit Reconciliation.

Screenshot showing Save in the Sage account form

Step 12

Open Deposit Reconciliations

Return to Truewind and open Deposit Reconciliation so you can use the new clearing account there.

Screenshot showing Deposit Reconciliations in Truewind

Step 13

Add an account

Start a Deposit Reconciliation account record before mapping the new clearing account.

Screenshot showing Add Account in Deposit Reconciliation

Step 14

Enter the account name

Use the same or a recognizable name so the Deposit Reconciliation account matches the Sage clearing account.

Screenshot showing the Deposit Reconciliation account name field

Step 15

Open ledger account mapping

This lets you connect the Deposit Reconciliation account to the Sage clearing account in the chart of accounts.

Screenshot showing the clearing-account mapping selector

Step 16

Choose the clearing account

Pick the exact Sage account you created so imported deposits land in the intended ledger.

Screenshot showing the selected Sage clearing account

Step 17

Create the mapping

Save the Deposit Reconciliation account after the ledger mapping looks correct.

Screenshot showing Create in Deposit Reconciliation account setup

Step 18

Open the clearing account

Review the created account directly to confirm it is available for the next import step.

Screenshot showing the created clearing account in Deposit Reconciliation

Step 19

Select the account

Confirm the correct clearing account is selected before you proceed to upload a file.

Screenshot showing the selected clearing account in Deposit Reconciliation

Step 20

Open file upload

The account is ready once you can move into the file-upload step for the selected clearing account.

Screenshot showing the file upload step in Deposit Reconciliation

What to verify

the clearing account exists in Sage
the Deposit Reconciliation account maps to that Sage account
the file upload step opens for the selected account

FAQ

Why do I need a clearing account before using Deposit Reconciliation?

Deposit Reconciliation needs a mapped clearing account so imported deposits can post to the correct ledger account.

Limitations

The account must exist in Sage first

You cannot finish the Deposit Reconciliation account setup until the clearing account exists in the Sage chart of accounts.

Troubleshooting

The clearing account does not appear in Deposit Reconciliation.

Confirm the account was saved in Sage and then refresh the Deposit Reconciliation account picker before trying again.

Was this helpful?

Need more help?

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