# Currency Valuation and VAT Reconciliation Pack

> A four-component pack that brings period-end valuation and tax checks together: daily automatic import of central bank exchange rates, an exchange difference preview for foreign currency open items, reconciliation of VAT by tax code with the tax G/L accounts, and a comparison of subledger and reconciliation account balances. Installation is a single transport.

- Type: Package, Custom development
- Module: FI
- Installation and adaptation: XL (9–14 working days)
- Version: 1.0
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/packages/currency-valuation-and-vat-reconciliation-pack/


## Why a package?

Currency valuation must use the right rate, the VAT return must agree with the ledger and the subledgers must match the general ledger; yet these checks are often done in Excel after the period is closed. The pack runs the four checks with the same company code and period selection: the rate table is filled automatically every day, the valuation effect is visible before posting, and VAT and reconciliation account differences are found before filing and closing. With separately ordered reports, the same selection, authorization and distribution settings are built four times.

## What's in the package

- Daily Central Bank Exchange Rate Import Interface (https://nekuhub.com/en/programs/central-bank-exchange-rate-automatic-import/): Source: writing daily central bank rates into the rate table
- Foreign Currency Open Items Exchange Difference Preview Report (https://nekuhub.com/en/reports/foreign-currency-open-items-exchange-difference-report/): Valuation: exchange difference per open item before posting
- VAT by Tax Code vs Tax G/L Account Reconciliation Report (https://nekuhub.com/en/reports/vat-tax-code-gl-account-reconciliation-report/): Tax: tax code totals compared with the VAT accounts
- Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check) (https://nekuhub.com/en/reports/subledger-reconciliation-account-balance-check-report/): Reconciliation: customer and vendor subledger against the reconciliation account

## What you receive

- Transport request: ABAP source code, transaction codes and message class
- Background job variant and rate type mapping for the exchange rate interface
- Installation and user guide (TR/EN)
- Account, tax code and authorization adjustment for your system
- User training

- Compatibility: SAP ECC 6.0 and S/4HANA (on-premise and Private Edition). On S/4HANA, G/L and subledger amounts are read from ACDOCA and tax lines stay in BSET. The exchange rate interface needs internet access from the SAP system to the rate file published by the central bank.
- License: One-time license; the source code stays with you. Optional yearly support and updates.

## Version history

- v1.0 (2026-11-17): First release: the rate interface, three control reports and a shared company code and period selection.

## Frequently asked questions

### Does the exchange difference preview post a valuation?

No. The report only revalues open items at the key-date rate and shows the unrealized exchange difference; the valuation posting is made with the standard period-end transaction.

### Does the VAT reconciliation replace the tax return?

No. The report checks before filing that tax code totals agree with the ledger; the return format and rates are checked against current regulation during installation.

### Can a rate source other than the central bank be used?

The interface is written to read a published rate file. For a different source, the file format and access method are assessed during installation and priced by effort range.

---
Let us install this package on your system: https://nekuhub.com/en/request-a-quote/?report=r2r-currency-vat-reconciliation-pack
