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.