Reconciliation account sap что это
What is SAP Reconciliation Account?
SAP financial accounting has several sub ledgers, including accounts receivable, accounts payable and asset accounting. An account is maintained for each customer, vendor or asset in the sub ledger. When preparing financial statements the details of these individual accounts are not necessary. Instead, every asset, customer or vendor account is linked to a certain SAP reconciliation account, also known as a control account. Each SAP reconciliation account is used to reconcile the sub ledgers with the general ledger. SAP reconciliation accounts are reported on the financial statements, while the individual sub ledger accounts are not.
The SAP general ledger is linked to the sub ledgers. For every transaction posted in the sub ledger, the same value will be updated to the corresponding reconciliation account.
Creating SAP Reconciliation Account
SAP reconciliation accounts are created very similar to all other general ledger accounts. There are just a few attributes that need to be set correctly. Transaction code FS00 is used to create reconciliation accounts centrally.
In this tutorial, we will not walk through the entire account creation process, as a reconciliation account is created in much the same way as any other general ledger account. Instead, let’s examine account 160000 for AP (Accounts Payable) reconciliation. We will walk through the three main areas where a reconciliation account differs from other accounts.
To display a reconciliation account use transaction code FS00 or you can use the following menu path:
Menu path for creating a reconciliation account
You will be taken to the screen below: 
Displaying a reconciliation account
The first area that denotes that this is a reconciliation account is the control data in the “Type/Description” tab. Here, you should note that the account group “Recon.account ready for input” is selected. Also, all reconciliation accounts should be identified as balance sheet accounts: 
Displaying a reconciliation account
Click on “Control Data” tab and check the second area that has to be maintained when creating a reconciliation account. In the field “Recon.account for acct type” you select between assets, customers and vendors to specify which sub ledger the account reconciles: 
Displaying a reconciliation account
Finally, click on “Create/bank/interest” tab and check the field status group. The field status group for all reconciliation accounts is G067: 
Displaying SAP reconciliation account
Assigning SAP Reconciliation Account to Sub Ledger Account
Now that we have seen how to set up a reconciliation account, complete the process by learning how to assign it to a sub ledger account. Each sub ledger account has to be linked to a certain reconciliation account for its postings to be recognized in the financial statements. Let’s see how it’s done by looking at an already created vendor.
Use transaction code FK03 to display a vendor or use the the following menu path:
Menu path for displaying a vendor
You will be taken to the screen below: 
Displaying a vendor
Enter a valid company code and vendor number, select the “Accounting info” tick box and press enter. The reconciliation account 160000 examined earlier is assigned in the “Recon. account” field for this vendor: 
Displaying a vendor
The result is that for every posting recorded under vendor 36, the general ledger updates with the same amount via reconciliation account 160000.
Posting a Vendor Invoice
Finally, let’s see how a reconciliation account is updated when you post an invoice for a vendor.
To post a vendor invoice use transaction code FB60 or you can use the following menu path:
Menu path for posting a vendor invoice
Fill in the vendor number examined above (vendor 36 in our case) and all details necessary for posting an invoice: 
Posting a vendor invoice
Now post the invoice and click “Document > Display” on the top far left of the toolbar to display the created document: 
Displaying invoice document
You will see the following screen. Here you see that vendor 36 has been credited with 2000 BWP. Click on general ledger view: 
Displaying invoice document in entry view
You can see the reconciliation account 160000 assigned to the vendor account is updated by the transaction above: 
Displaying invoice document in general ledger view
The end result is that reconciliation account 160000 was also credited with 2000 BWP. Therefore, every time you post a transaction to a sub ledger account the reconciliation account will be updated with the same amount in real time. In order to maintain a clean reconciliation with the sub ledger, SAP reconciliation account can only be updated by the system through the sub ledger. Direct posting to SAP reconciliation account is prohibited by the system.
Related Posts
9 thoughts on “What is SAP Reconciliation Account?”
Here the recon account itself is the GL account. So when vendor posting is done, credit to vendor account is automatically posted to associated recon GL account (160000). Please note that that the recon account is just a name given to the GL account which is used as a posting account for all the vendor sub-accounts. We cannot create reports and statements out of thousands of sub-GLs so attach a GL to each of them and name it as recon account. Thanks.
I downloaded a debtors age analysis for a recon account. now the balance has changed due to entries that were posted. instead of generating a new F.99, is there a way that a line item can be displayed so that i can see what are the entries that went through?
If I want to reconcile AP sub ledger with GL, Which report should I run on SAP for AP sub ledger to compare with GL report for reconciliation purpose or what’s the procedure for doing AP- GL reconciliation
Recon account should be credited in the above case..
The subledger transactions will be
Dr Purchase or Expense
Cr Vendor
In GL you will not have the list of vendors but a few reconciliation accounts like Domestic Vendors, Foreign Vendors etc. So for transaction above the GL View will be as below
Dr Purchase or Expense
Cr Reconciliation Account.
This means when SAP posts crediting the vendor in the Subledger this flows to GL module will same credit to Reco account. Hope this helps
reconciliation account
Смотреть что такое «reconciliation account» в других словарях:
Account aggregation — is a method that involves compiling information from different accounts, which may include bank accounts, credit card accounts, investment accounts, and other consumer or business accounts, into a single place. This may include a database or may… … Wikipedia
Reconciliation of nostro account — Reconciliation of nostro accounts is the process of matching the statements received from the NOSTRO banks with the postings kept by the automated system … International financial encyclopaedia
account reconciliation services — A cash management service. One or more of a series of bank services designed to aid a deposit customer in the reconciliation of its bank account balance. A basic account reconciliation service may simply be a listing of paid checks in serial… … Financial and business terms
Reconciliation (accounting) — In accounting, reconciliation refers to a process that compares two sets of records (usually the balances of two accounts) to make sure they are in agreement. Reconciliation is used to ensure that the money leaving an account matches the actual… … Wikipedia
Reconciliation and Unity Commission — The Reconciliation and Unity Commission is a proposed government body to be set up if the Reconciliation, Tolerance, and Unity Bill, which was introduced into the Fijian Parliament on May 4 2005, is passed. The legislation proposes to empower the … Wikipedia
Reconciliation — An accounting process used to compare two sets of records to ensure the figures are in agreement and are accurate. Reconciliation is the key process used to determine whether the money leaving an account matches the amount spent, ensuring that… … Investment dictionary
account reconciliation — 1) A procedure for confirming that the balance in a chequebook matches the corresponding bank statement. This is normally done by preparing a bank reconciliation statement 2) A procedure for confirming the reliability of a company s accounting… … Accounting dictionary
account reconciliation — 1) A procedure for confirming that the balance in a chequebook matches the corresponding bank statement This is normally done by preparing a bank reconciliation statement 2) A procedure for confirming the reliability of a company s accounting… … Big dictionary of business and management
reconciliation — See: account reconciliation, bank reconciliation statement … Accounting dictionary
reconciliation — See account reconciliation; bank reconciliation statement … Big dictionary of business and management
account recs — See account reconciliation services … Financial and business terms
How to use Bank Reconciliation Account in Payment Program
SAP introduces a new G/L account type C (Cash Account), which has two sub types B (Bank Reconciliation Account) and S (Bank Subaccount).This new feature can help customer significantly reduce the numbers of G/L accounts.
In this blog post I’ll guide you how to implement the new feature in payment program step by step.
Error of G/L Account Determination
Once the new bank reconciliation account is used in the house bank account, it will impact on the G/L account determination in payment program.
If you schedule a payment run then, you get an error message FZ 314 “G/L account does not exist in company code” in the log of the payment program.
Error log of payment program
Before we know how to resolve this issue, I would like to introduce the new concept of the bank reconciliation account.
Bank Reconciliation Account
Traditionally, a bank account is represented with a set of G/L accounts often constructed in the following way:
Bank GL logic at SAP
Here, G/L subaccounts on a bank current account are just like “legs on a spider.” The system must provide a set of G/L subaccounts for every bank account, thus making the number of G/L accounts huge. In some extreme cases, 70% of G/L accounts are occupied by banks.
Why can’t we re-model the relationship between a bank account and a G/L account? Just let numbers of bank accounts use one special G/L account, that is a bank reconciliation account.
Then, we just need one set of subaccounts to manage different clearing methods.
The classic G/L account representation of a bank account and the new bank reconciliation account can run side by side. It just depends on what kind of G/L account is used in the house bank account.
The new model brings the following benefits:
Definition of Bank Reconciliation Accounts and Subaccounts
SAP introduces a new G/L account type C (Cash Account) and two sub types B (Bank Account) and S (Bank Subaccount):
| Term | Definition |
| Bank Reconciliation Account | |
| Bank Subaccount |
We can log in to the system to see the new functionality. If you are a G/L accountant, you can open the app “Manage G/L Account Master Data.” Below are screenshots of a bank reconciliation account and of a bank subaccount:
Bank Reconciliation Account
Bank Sub GL Account
I will explain how to assign the house bank account to the reconciliation account in the next step.
Defining a House Bank Account
If you are a cash specialist, you can open the app “Manage Bank Account”, select a house bank account, and then go to House Bank Account Connectivity:
House Bank Account Data
If you enter a bank reconciliation account, the property “Bank Reconciliation Account” will be populated automatically.
The question then is how to find out which subaccount should be used in the payment program.
Bank Account Determination
For the automatic payment program, we can use the SSCUI Set Up Bank Determination for Payment Transactions (1010045).
It’s still possible to config the bank subaccount as a classic bank G/L account just like the house bank account DEBK2/DEAC2 in the screenshot. However, once you set a house bank account to new bank reconciliation account, just like DEBK1/DEAC1 in the screenshot, the legacy configuration of bank subaccount becomes grayed out. If you’re trying to create a new config record for DEAC1, you will find that you can’t enter a bank subaccount any more.
The last question is how to find the subaccounts for different payment methods.
Account Symbols
Configuration for account symbols reuses the functionality of Electronic Bank Statement.
Go to the configuration for Electronic Bank Statement via the SSCUI Make Global Settings for Electronic Bank Statement (101024). First, you need to create an account symbol and select the SIP (self-initiated payment) relevant checkbox.
Then, assign an overlaid rule to the account symbol.
You can now assign the account symbol to payment methods in the SSCUI Assign Account Symbol to Payment Methods (103557).
We can open the app “Manage Automatic Payments” to delete the proposal and re-run it.
The proposal and the payment document are generated on the sub G/L account successfully.
Call to Action
If you want to know more about the relevant master data and configuration maintenance, you can refer to the following links,
Defining House Bank Accounts
Assigning G/L Accounts to House Bank Accounts
Automatic Determination of Bank Subaccounts
In case of any further questions, please leave a comment below and I will try to answer you.
What is the use of reconciliation account in SAP FI Module?
Last Modified on June 19, 2020 by Editorial Staff
Reconciliation account in SAP is a general ledger account assigned to the business partner master record to record all transactions in the sub ledger.
Posting to the sub ledgers are automatically get posted to the assigned reconciliation account by which the general ledger will always be up to date. It is a prerequisite for creation of vendor master.
Every transaction in an account of a sub-ledger is automatically posted to the general ledger. This integration is guaranteed by the reconciliation account in SAP. It must be assigned to every customer or vendor master record.
This is done be entering the respective General Ledger account in the Reconciliation account field of the customer master record. While posting to the customer master, these accounts in SAP has following functions:
It ensures that the total of all General Ledger account balances is always zero. This is a prerequisite for creating a balance sheet at any time. Therefore, it is no longer necessary to transfer account balances from sub-ledger to General Ledger accounts, since the balances are updated automatically in the general ledger.
Via the reconciliation account in SAP, the screen lay out for posting to the customer master can be determined. For example, the fields for entering hedging transactions for foreign currency can be suppressed, if such transactions are not carried out in a company. Further Via these accounts, currencies in which the corresponding customer account should be posted can be specified.
Generally, a common reconciliation account in SAP is assigned to several customer accounts. It’s displayed on the balance sheet under the balance sheet item “Sundry Debtors”.
Several reconciliation accounts are required if you want to have different account balances separately on the balance sheet, such as domestic receivables and foreign receivables.
Note: SAP and SAP logo is a registered trademark of SAP AG in Germany and in several other countries. We are not affiliated or related to any division or subsidiary of SAP AG.
Reconciliation Accounts and Special G/L Indicator
Most SAP people might be asking, what is a reconciliation account in SAP Financial Accounting? Well, my dear readers surely you will be enlightened by this article.
First…
You must understand the definition of general ledger. General ledger is the main accounting record of a business which uses double-entry bookkeeping. In SAP, the central task of G/L accounting is to provide a comprehensive picture for external accounting and accounts. Transactions that have a financial impact are captured by the general ledger. The transactions could be originated from other modules. Example, posting of goods receipt (MIGO) performed by purchasing personnel (MM module) have already a financial impact. It increases the inventory balance and increases the GR/IR clearing account. The accounting journal entry the transactions MIGO create is debit (dr) Inventory account (G/L) and credit GR/IR clearing accounts (G/L).
The general ledgers summarize all financial transactions of a Company. It is the the basis of the preparation of the Company’s Financial Statements.
Now, let’s dig it further
Reconciliation Accounts are G/L accounts that receive postings from a subsidiary ledgers. Meaning, transactions data are not posted directly to recon accounts. Example of recon accounts are Accounts Receivable, Accounts Payable and Fixed Assets G/L. For accounts receivable G/L the subsidiary ledger is the customer account. All transactions with the customers are posted directly to the customer account and the recon account is automatically updated. How this thing happen? Well, when you create a customer account you specify under the Company Code data the reconciliation account.
All normal transactions to the customer e.g. sale of goods are posted to the recon account defined in the customer master data. Next question would be, what G/Laccount should be updated for postings of customer down payment (advance collection)? For proper accounting, downpayment should not be posted to Accounts Receivable – trade. It should be posted to different G/L account e.g. Advances from customer. Well, how would the said transaction be posted to Advances accounts.
This is one of the cases where the idea of special G/L indicator comes in. With the use of special G/L indicator you can specify in the set-up what G/L account advances transactions be posted. Standard posting key of customer transaction with special G/L indicator are 09 (dr) and 19 (cr). The system will always require you to indicate the special G/L indicator when you use the said posting keys.