Budget Code Substitution Rules

When entering or importing cash flowsClosed Movement of money in and out of a company., the budget codesClosed Customizable combination of alphanumerical characters representing the assignment of flows to categories of activity. are automatically assigned. With the optional setting of substitution rules in Sage XRT Solution, you can also assign budget codes during the reconciliation process.

From Cash module, select Budget Code Substitution Rule in the Setup - Other menu.

A screenshot depicting the function addressed in the current paragraph.

In the Condition section, you can select the entity for which you want to create a substitution rule:

  • Account

  • Company

  • Bank Branch

  • Bank

The Flow Subcategory and Flow Code fields enable you to specify which flows will be assigned a budget code during reconciliation.

In Cash Flow Field, select the property to be scanned by the reconciliation process, and in Cash Flow Field Value, select the value to be found for assigning a budget code. You can limit the search scope by using the Scan - Start Position option.

In the Budget Code section, select the code to be assigned to the flow.

Click Save to validate the creation of the substitution rule.

Examples

Bank

BTC Amount Transaction date Description
05 1000.00 EUR 01/11/2023 Payment for SXA License
05 2000.00 EUR 01/11/2023 Payment for SXA License
05 3000.00 EUR 01/11/2023 Payment for Sage 100 License

After the reconciliation process and the application of the budget code substitution rule:

Cash

Flow Amount Transaction date Description Budget Code
RECVDTSF 1000.00 EUR 01/11/2023 Payment for SXA License XRT Product
RECVDTSF 2000.00 EUR 01/11/2023 Payment for SXA License XRT Product
RECVDTSF 3000.00 EUR 01/11/2023 Payment for Sage 100 License L100 Product