# SAP Intercompany Reconciliation Worksheet

> Source: https://netray.co/tools/sap-intercompany-reconciliation-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Pairwise intercompany balance comparison with difference, percent difference and reason tagging, ready for the close meeting.

## Category

sap

## Erp

SAP ECC / S/4HANA

## Audience

- Group controller
- Consolidation accountant
- SAP FICO consultant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Seller company code

**Key:** seller

**Type:** text

#### Buyer company code

**Key:** buyer

**Type:** text

#### Currency

**Key:** ccy

**Type:** select

**Options:**

- USD
- EUR
- GBP
- INR
- CNY
- ZAR

#### Receivable at seller

**Key:** recv

**Type:** number

**Format:** currency

#### Payable at buyer

**Key:** pay

**Type:** number

**Format:** currency

#### Difference

**Key:** diff

**Type:** number

**Expr:** recv - pay

**Format:** currency

#### Difference percent

**Key:** diff_pct

**Type:** number

**Expr:** abs(recv - pay) / abs(recv) * 100

**Format:** percent

#### Reason

**Key:** reason

**Type:** select

**Options:**

- None
- Invoice in transit
- Payment in transit
- FX rate difference
- Posted to wrong partner
- Pricing dispute
- Cut off timing

#### Owner

**Key:** owner

**Type:** text

**Rows:**

**Seller:** 1000

**Buyer:** 2000

**Ccy:** USD

**Recv:** 482500

**Pay:** 482500

**Reason:** None

**Owner:** AR 1000

**Seller:** 1000

**Buyer:** 3000

**Ccy:** USD

**Recv:** 215300

**Pay:** 207800

**Reason:** Invoice in transit

**Owner:** AP 3000

**Seller:** 2000

**Buyer:** 1000

**Ccy:** USD

**Recv:** 96400

**Pay:** 96150

**Reason:** FX rate difference

**Owner:** Treasury

**Seller:** 3000

**Buyer:** 2000

**Ccy:** USD

**Recv:** 58200

**Pay:** 61700

**Reason:** Posted to wrong partner

**Owner:** AP 2000

**Seller:** 2000

**Buyer:** 3000

**Ccy:** USD

**Recv:** 133000

**Pay:** 133000

**Reason:** None

**Owner:** AR 2000

**Totals:**

#### Total receivable

**Key:** recv

**Agg:** sum

**Format:** currency

#### Total payable

**Key:** pay

**Agg:** sum

**Format:** currency

#### Net difference

**Key:** diff

**Agg:** sum

**Format:** currency

**Summary:**

#### Net difference as share of receivables

**Key:** net_pct

**Expr:** abs(sum_diff) / sum_recv * 100

**Format:** percent

**Primary:** true

**Description:** Net only, offsetting differences hide gross mismatches.

**Notes:** Net difference can hide offsetting errors, so also review the largest absolute pairs. Enter both sides in the same currency, converted at the group rate, otherwise FX noise appears as a difference. The trading partner field on the GL or customer or vendor line drives intercompany reporting in SAP, so a wrong partner is a frequent cause of mismatch.

## Content

**Intro:** At group close the intercompany balances must match before consolidation can eliminate them. This worksheet lists each seller and buyer pair, computes the difference and records the reason, giving the close meeting a single list of what is open and who owns it.

**Sections:**

#### How to use the worksheet

**Body:** Enter one row per seller and buyer pair and currency. Take the receivable from the seller company code and the payable from the buyer company code at the same cut off, in the same reporting currency. The sheet shows the difference and the percentage. Tag the reason and an owner for every nonzero line, then export to Excel and circulate before the close call. Rerun after each correction until the differences clear or are explained.

#### Why balances fail to match

**Body:** The usual causes are timing: an invoice posted by the seller but not yet received or posted by the buyer, or a payment in transit across a bank holiday. Next come exchange rate differences when each side revalues at a different rate, then wrong trading partner assignment, pricing or quantity disputes, and cut off differences on shipments. Each cause needs a different owner, which is why the reason and owner columns matter more than the arithmetic.

#### Reading the totals

**Body:** A small net difference does not mean the reconciliation is clean. Two large offsetting errors net to nothing but both still break the elimination at entity level. Sort by absolute difference and clear the biggest first. Set a materiality line for your group, for example differences under a small fixed amount may be accepted and written to an elimination difference account at consolidation, with a note.

#### Common mistakes

**Body:** Common mistakes are comparing balances at different dates, mixing transaction and group currency, forgetting non trade intercompany items such as loans and recharges, and reconciling only receivables to payables while ignoring intercompany revenue and cost. For manufacturers also check intercompany stock transfers, since profit in inventory must be eliminated and requires the right transfer price records.

**Cta:** If your group close depends on pulling balances from several SAP systems by hand, we can help build a read only extract and matching view.

**Faq:**

#### Does SAP have a standard intercompany reconciliation tool?

**Answer:** SAP offers several, depending on release, including reconciliation functions in the group reporting and consolidation products and intercompany reconciliation apps in S/4HANA. Availability varies, so check what your license and release include.

#### Which currency should I use?

**Answer:** Use one common currency, normally the group reporting currency, at the same closing rate for both sides. Comparing local currencies directly creates false differences when rates differ.

#### What is the trading partner?

**Answer:** It is a field that identifies the partner company on intercompany postings. In SAP it is derived from the customer or vendor master and used in consolidation and reporting. A wrong or missing partner breaks matching.

#### Should I reconcile before or after revaluation?

**Answer:** Reconcile after foreign currency valuation is complete, otherwise the difference includes unposted revaluation. Many groups reconcile twice, once before valuation to find real errors and once after to confirm clean balances.

## Search terms

sap intercompany reconciliation template, intercompany reconciliation excel, intercompany balance matching worksheet, sap intercompany elimination check, intercompany mismatch report, group close intercompany template, sap trading partner reconciliation, intercompany difference analysis

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json