How to set up text-to-account mapping in Business Central

To enhance efficiency in processing bank reconciliations via payment reconciliation journals, you can establish mappings between payment texts and specific debit, credit, and balancing accounts. This ensures that payments are automatically posted to the designated accounts when you post the journal.

To map text on recurring payments or bank transactions to accounts for automatic reconciliation you can use the following steps:

Search for Payment Reconciliation Journals in the global search icon, and then choose the related link.

Open a payment reconciliation journal or create a new journal if there is none.

 Go to Manual Application > Map Text to Account action. The Text-to-Account Mapping page will open.

In the Mapping Text field, enter any payment text that you would like to be mapped and posted to specific accounts without applying to an open entry. You can enter up to 50 characters.

In the Bal. Source Type field, specify if the payment will be posted to a general ledger account or to a customer or vendor account.

In the Bal. Source No. field, specify the account that the payment will be posted to, depending on your selection in the Bal. Source Type field. You can also specify on the Debit or Credit Acc. No. field the G/L Account No. to post the entry against if the Bal. Source Type selected is a G/L Account.

After you’ve finished mapping payment text to accounts changes will be automatically saved, then you can click the Close button. Click Yes on the prompt to save the changes and reapply the mapping rules.

Note: When you set up a text-to-account mapping, the resulting automatic payment application will have High – Text-to-Account Mapping in the Match Confidence field.

Repeat steps 3 through 6 for all text on payments that you want to map to accounts.

Once done, you can now post the payments and reconcile the bank account through from journal.