Intercompany Open Items Reconciliation Report
Short answer: A custom ALV report that matches receivable and payable open items between group companies by trading partner and reference number. Before the month-end consolidation it shows items that sit as a receivable in one company but have no payable in the partner company, or that differ in amount or currency.
- Estimated effort
- L · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FBL5N and FBL1N list each company code and account type separately; finding the partner's posting means matching two lists by hand in Excel. F.13 clears automatically within a company code and does not report unmatched items across company codes. Missing or different reciprocal postings are usually found through spreadsheet matching before consolidation.
Who uses it? Group accounting and consolidation teams, accounting teams that do intercompany billing and financial controllers.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BSIDCustomer Open Items | Intercompany customer open items (receivable side) | — | ECC + S/4 |
| BSIKVendor Open Items | Vendor open items in the partner company (payable side) | BSIK-BUKRS = ortak şirket kodu AND BSIK-XBLNR = BSID-XBLNR | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name and trading partner | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name and trading partner | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |
| T001Company Codes | Company code to company (RCOMP) mapping and currency | T001-BUKRS = BSID-BUKRS | ECC + S/4 |
S/4HANA notes
- BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
- BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes | 1000 |
| S_VBUND | Trading partner | Range / multiple | BSID-VBUND | No | GRP02 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 31.10.2026 |
| P_TOLAMT | Amount difference tolerance | Single value | — | No | 10 |
| P_MXBLN | Match by reference (XBLNR) | Radio button | — | No | X |
| P_MZUON | Match by assignment (ZUONR) | Radio button | — | No | — |
| P_ONLYDF | Show only differences and unmatched items | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSID-BUKRS |
| 2 | Customer (partner) | BSID-KUNNR |
| 3 | Customer name | KNA1-NAME1 |
| 4 | Partner company code | Calculated Company code in T001 whose RCOMP = trading partner (BSID-VBUND or KNA1-VBUND) |
| 5 | Reference | BSID-XBLNR |
| 6 | Receivable document | BSID-BELNR |
| 7 | Receivable amount | BSID-WRBTR |
| 8 | Payable document (partner) | BSIK-BELNR |
| 9 | Payable amount | BSIK-WRBTR |
| 10 | Document currency | BSID-WAERS |
| 11 | Difference | Calculated Receivable amount − payable amount (at the key-date rate if currencies differ) |
| 12 | Status | Calculated Matched, amount difference, currency difference or no reciprocal posting |
Sample output
| Company code | Customer (partner) | Customer name | Partner company code | Reference | Receivable document | Receivable amount | Payable document (partner) | Payable amount | Document currency | Difference | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 300010 | Doğa Lojistik A.Ş. | 2000 | 2026-0412 | 1800012501 | 250,000 | 5100007741 | 250,000 | TRY | 0 | Matched |
| 1000 | 300010 | Doğa Lojistik A.Ş. | 2000 | 2026-0418 | 1800012644 | 86,400 | 5100007802 | 84,000 | TRY | 2,400 | Amount difference |
| 1000 | 300010 | Doğa Lojistik A.Ş. | 2000 | 2026-0425 | 1800012790 | 37,800 | 0 | TRY | 37,800 | No reciprocal posting | |
| 1000 | 300022 | Ege Enerji Yatırım | 3000 | EXP-1107 | 1800012811 | 12,000 | 5100001904 | 12,000 | EUR | 0 | Matched |
How does the report work?
- For the selected company codes, the company (RCOMP) is read from T001.
- Receivable side: open items at the key date from BSID; the trading partner comes from BSID-VBUND, or from the customer’s KNA1-VBUND if empty.
- The partner company code is the company code in T001 whose RCOMP equals the trading partner.
- Payable side: vendor items in the partner company code are read from BSIK where the trading partner (BSIK-VBUND or LFA1-VBUND) is the reporting company.
- Items are matched by the chosen key (reference XBLNR or assignment ZUONR) in document currency. A difference above P_TOLAMT shows “Amount difference”; no counterpart shows “No reciprocal posting”. The opposite direction (our payables / partner’s receivables) is checked in the same run.
- If currencies differ, amounts are compared at the standard rate (rate type M) of the key date.
Performance notes
Read BSID and BSIK by company code and the set of trading partners; do the matching in memory with hashed tables. In groups with many companies, parallel background jobs per company pair can be used.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document FB03 opens from the document number on either side.
- Export to Excel
- Runs as a background job Can run in the month-end close calendar before consolidation.
- Send the result by email The difference list can be sent to the accounting teams of the companies involved.
Authorization objects
- F_BKPF_BUKAccounting document authorization for both company codes
- F_KNA1_BUKCustomer master authorization by company code
- F_LFA1_BUKVendor master authorization by company code
Frequently asked questions
What happens if the trading partner field is empty?
If the item has no trading partner, the one in the customer or vendor master is used. If both are empty the item is not treated as intercompany; this can be shown as missing master data in a separate warning list.
How are invoices in different currencies compared?
Document currencies are compared first. If the two sides posted in different currencies, amounts are converted at the standard key-date rate and the exchange difference is shown with its own status.
Does the report post the differences automatically?
No, the report only reads. The correction is posted in the relevant company with standard transactions; the detail list points directly to the document to correct.
Packages that include this solution
Month-End Close Control Pack
A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …
Related reports
Customer Receivables Aging Report
A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.