TaxPoint Enhanced Report · ERP data

TaxPoint Enhanced Report: from RFUMS to item-level ERP data.

Standard VAT reports often show only the posted totals. TaxPoint Enhanced Report builds an enriched item-level data model on top of them for VAT, Intrastat, environmental taxes, customs and finance controls.

Many VAT processes start with a standard ERP report. In SAP, RFUMS is a well-known example. The report is useful for VAT totals, but usually too limited for substantive tax control. You see the posting, tax code, tax base and VAT amounts, but not always what was actually sold, purchased, shipped or taxed.

That is where the problem starts. A VAT return can reconcile numerically, while the tax team still cannot properly assess whether the underlying transactions were processed correctly. For that, you need item-level data: materials, quantities, weights, ship-from, ship-to, commodity codes, countries, incoterms, master data and tax classifications.

The Enhanced Report is therefore the data layer underneath further review and dashboarding. As a next step, the same dataset can be made locally searchable and filterable with TaxPoint Intelligence.

RFUMS shows what was posted, not always why

RFUMS is designed as a VAT report. It helps make amounts visible by document, tax code and reporting period. For the return, that is valuable. For modern indirect tax controls, it is often not enough.

In practice, such a standard report contains only a limited set of fields. It does not include, for example, ship-from and ship-to data, material lines, quantities, weights, commodity codes, country of origin, plant information, tax classifications and many relevant customer or supplier details. Those are precisely the fields that determine whether a transaction is logical from a VAT, Intrastat or customs perspective.

The point is not that RFUMS is wrong. The point is that RFUMS has a different purpose. It is a VAT totals report, not a full item-level tax data model.

TaxPoint builds the missing data layer

TaxPoint Enhanced Report turns a limited ERP or VAT export into a rich, controllable item-level report. We combine the relevant ERP tables, standard reports, master data and additional tax mappings into a dataset in which every relevant transaction line has sufficient context.

In SAP, RFUMS may be the recognisable starting point, but the method is not SAP-dependent. The same principle works in other ERP systems as well. The key is understanding the underlying transactions, the relationships between tables and the tax logic needed to move data from posting level to a control-ready item level.

The result is a report that shows not only which VAT was posted, but also which goods, services, counterparties, countries, quantities and classifications sit behind that posting.

Dozens of additional fields around the same transaction

The Enhanced Report does not add columns simply because they are available. The enrichment is focused on the questions that tax, finance and compliance actually need to answer. Examples include:

  • material number, description and product information;
  • commodity code, country of origin and Intrastat-relevant characteristics;
  • quantity, weight, units and logistics data;
  • departure country, destination country, ship-from, ship-to and plant information;
  • incoterms, document types, transaction types and relevant dates;
  • customer, supplier and VAT registration details;
  • tax code, item tax code, tax code description and tax classifications;
  • tax base amounts, VAT amounts, currency, deductibility and reconciliation fields;
  • flags for Intrastat, EC Sales, reverse charge and triangulation.

These fields are often not available together in standard reports. Sometimes they sit in different ERP tables. Sometimes they can only be derived indirectly. Sometimes fields must be cleansed, normalised or remapped before they are usable for tax control.

The most important step is the right level of detail

A report only becomes useful when the level of detail is right. For many controls, document level is too broad and tax-code level per invoice is insufficient. The question is often: which item line caused this tax outcome?

TaxPoint Enhanced Report therefore brings data back to item level where needed. Logistics, financial, master data and tax fields are brought together around the same transaction line. At the same time, the report must remain controllable. Enrichments must not multiply rows, double-count amounts or make transactions disappear.

That is why the Enhanced Report includes an auditable approach: source files, transformations, exceptions, reconciliations and controls remain visible. The dataset must be richer, but also well supported.

A data layer for VAT, Intrastat, environmental taxes and finance

The first use case is often VAT. With item-level data, you can perform better controls on tax codes, rates, ship-from and ship-to logic, VAT numbers, reverse charge, EC Sales, VAT-group transactions, tax classifications and unusual patterns.

But the value does not stop there. For Intrastat, fields such as commodity code, quantity, weight, country of origin, destination country and incoterms are essential. For environmental taxes, material, product, volume and logistics characteristics can be decisive. For customs, goods flows, origin, value, counterparty and transport context matter.

For finance, this is useful more broadly as well. An enriched item-level report makes it easier to explain postings, analyse differences, review AP/AR flows, investigate cut-off questions and compare source data with return or management reporting.

SAP is an example, not the limitation

Many organisations recognise the RFUMS example because SAP is widely used for VAT reporting. But TaxPoint Enhanced Report is not a SAP-only concept. Every ERP system has standard reports built for operational or financial purposes, while tax and compliance need different combinations of fields.

The TaxPoint approach is therefore ERP-independent: determine which tax and finance questions the organisation needs to answer, identify the relevant source fields and relationships, transform the data to the right level of detail and make the output controllable. The result is a report that aligns with the reality of the transaction instead of the limitations of a standard export.

Enhanced Report builds the dataset, Intelligence makes it navigable

TaxPoint Intelligence complements the Enhanced Report. The Enhanced Report builds the rich, controllable item-level dataset. TaxPoint Intelligence then makes that dataset searchable, filterable and sortable in a local dashboard environment.

That sequence matters. First the data must be substantively right: the right source, the right level of detail, the right enrichments and a well-supported reconciliation. Only then does the dashboard become truly valuable, because users can click from findings to transactions, source rows and invoice details.

The practical outcome

TaxPoint Enhanced Report turns a limited standard export into a workable tax and finance data model:

  • from document or tax-code totals to item-level insight;
  • from loose ERP fields to a consistent control dataset;
  • from manual searching in exports to targeted analysis;
  • from VAT return only to broader VAT, Intrastat, environmental tax, customs and finance controls;
  • from unclear source logic to an auditable route from ERP data to reporting.

Want to get more out of your ERP data?

We help determine which fields, tables, controls and output structure are needed to turn standard ERP reports into a usable item-level tax and finance data model.

Discuss your situation