Reconciliation of Budget Balance with GL Balance (tfbgc3110m000)

Use this session to compare the amounts posted in the General Ledger with the amounts posted in Budget Control. By default, only the documents with differences are displayed after you have run the reconciliation process. A report will be printed with the differences by budget balance type. You can zoom to the details of the integration- the logistic- and the financial transactions as well as the budget transactions via zoom sessions. The budget adjustments and Journal vouchers can also be maintained from this session. Differences can be accepted and excluded from a subsequent reconciliation run.

Field Information

Budget Year

The year for which the budget is valid. The year corresponds to the fiscal year defined in the General Ledger module.

Short Description of Year

The description or name of the code.

Budget

The budget code.

Description

The description or name of the code.

Budget Currency

The currency in which the budget amount is expressed.

Budget Level

The budget level. For a budget structure, you can define up to nine summary levels.

  • Level 1 of a roll up structure always determines how the accounts on your ledger chart of accounts (ledger detail accounts) roll up to the first summary level of budget accounts.
  • Levels 2 through 9 always determine additional summary levels within your budget structure. Allotment, commitment, encumbrance, expense, payment, and available balances on levels 2 through 9 are always the sum of the balances of the level immediately below these levels ( Example, the balance at Level 2 always equals the sum of the balances of the budget accounts at Level 1).
Account

The budget account code.

Dimension 1

The dimension.

Account Description1

The description of the budget account.

Account Description2

The second description of the budget account.

Period

The budget period.

Budget Account

The balance of the budget account which is being reconciled.

General Ledger

The balance of the ledger account which is being reconciled.

Difference

The difference between the general ledger balance amount and the budget account balance amount.

Budget Commitment

The balance of the type commitment, for the budget account.

Ledger Commitment

The balance of the type commitment, for the ledger account.

Difference Commitment

The difference between the commitment balance of the ledger account and the budget account.

Budget Encumbrance

The balance of the type encumbrance, for the budget account.

Ledger Encumbrance

The balance of the type encumbrance, for the ledger account.

Difference Encumbrance

The difference between the encumbrance balance of the ledger account and the budget account.

Budget Receipt Expense

The balance of the type receipt expense, for the budget account.

Ledger Receipt Expense

The balance of the type receipt expense, for the ledger account.

Difference Receipt Expense

The difference between the receipt expense balance of the ledger account and the budget account.

Budget Expense

The balance of the type expense, for the budget account.

Ledger Expense

The balance of the type expense, for the ledger account.

Difference Expense

The difference between the expense balance of the ledger account and the budget account.

Total Budget

The total balance of the budget account including the balances of all the balance types.

Total Ledger

The total balance of the general ledger including the balances of all the balance types.

Difference Total

The difference between the total balance of the ledger account and the budget account.

Ledger Account

The ledger account code.

GL Dimension 1

The dimension.

Document Type

The origin of the document. Example, Purchase Order, Journal Voucher or Budget Adjustment.

Document

The document number of the document.

Document Line

The document line number.

Commitment

The commitment balance of the budget account.

Encumbrance

The encumbrance balance of the account.

Receipt Expense

The receipt expense balance of the account.

Expense

The expense balance of the account.

Total

The total balance of the account including the balances of all the balance types.

Amount in GL

The balance of the account in the general ledger.

Difference

The difference between the account balance in the budget account and the general ledger.

Exception Amount

The amount blocked during the budget check process.

Status in GL

The status of the General Ledger , after the budget check process.

This field can have the following values:

  • Finalized
  • In Other Period
  • Logged
  • Mapped
  • Posted
  • Not Applicable
  • Not Finalized
  • Not Present
Checked

If this check box is selected, the budget transaction with a difference with GL is accepted. When a new reconciliation process is run, the already checked transactions can be skipped.

Text

If this check box is selected, a text is present.

Sequence

The sequence number of the reconciliation process. The process can be run as many times as the user wants, optionally the previous reconciliation data can be overwritten.

Document Company

The company in which the original document is created.

Document Reference

The document reference, if any.

Distribution Sequence

The sequence number of the distribution.

Document Subtype

The subtype of the original document.

This field can have the following values:

  • Additional Cost
  • Cost
  • Order Line
  • Receipt Line
  • Not Applicable
Transaction Type

The transaction type of the budget transaction. Example Adjustment, Commitment, Encumbrance, Expense and so on.

Balance Type

The type of adjustment made on the budget balance.

This field can have the following values:

  • Allotment
  • Budget
  • Commitment
  • Encumbrance
  • Expense
  • Receipt Expense
  • Not Applicable
From Budget Transaction

If this check box is selected, the origin of the reconciliation line is budget control.

From GL

If this check box is selected, the origin of the reconciliation record comes from General ledger.