sped ecf on hana/tdf

Copyright Phoron Consulting GmbH www.phoron.com

SPED ECF on HANA/TDFPhoron Consulting GmbH

Rafael Pin Rodrigues

SAP Finance Consultant

About Phoron

SPED ECF Legislation

Blocks and Registers ECF

Process and Functionalities SAP ECF

Phoron SPED ECF

SAP TDF / ECF

Questions

About Phoron

Consulting that fits.

Phoron

Facts aboutPhoronBasic Data

Established in 2004

Medium-sized and owner-managed

Over 100 employees worldwide

SAP Recommended Expertise Partner

Facts aboutPhoronSAP Partner of the Year 2015

in Recognized Expertise

We were awarded for our

Solutions in the field of PLM (SAP PPM)

Expert know-how in the field of Finance

Specialized solutions in the field of Brazilian processes (NF-e)

Facts aboutPhoronLegal Entities Worldwide

SAO PAULOBranch Office

STUTTGARTBranch Office

VIENNAHeadquarter

Facts aboutPhoronRollouts to Over 30 Countries

ArgentinaAustriaBelarusBrazilBulgariaCanada

ChinaCroatiaCzech Rep.FranceGermanyGibraltar

HondurasHungaryIndiaItalyJapanLiechtenstein

MacedoniaMaltaMexicoPeruPolandPortugal

RomaniaRussiaSerbiaSlovakiaSloveniaSouth Korea

SwedenSwitzerlandTaiwanUKUSA

SPED ECF

Escrituração Contábil DigitalEscrituração Contábil Fiscal

Legislation

LegislationEscrituração Contábil Fiscal

Replaces old DIPJ and LALUR (Livro deApuração do Lucro Real).

The report is composed of several informationthat affect the tax base amount for CSLL andIRPJ calculation.

It must be submitted annually, through ECFPVA, until the last working day of July.

LegislationEscrituração Contábil Fiscal

Law:Decreto nº 6.022, de 22 de janeiro de 2007, e alterações posteriores - SPED. Instrução Normativa RFB nº 1.420, de 19 de dezembro de 2013 - ECD.Instrução Normativa RFB nº 1.422, de 19 de dezembro de 2013 - ECF.Ato Declaratório Cofis nº 101, de 29 de dezembro de 2016 – ECF layout.

Scope: Retrieve ECD Chart of Account and Accounts Balances and its relation to the Referential Accounts. Retrieve ECF balances from the year immediately preceding. Balance sheet diaries, Balance sheet and files with release evidence. List details of additions and exclusions regarding IRPJ and CSLL taxes amounts, including tax loss carryforwards and negative basis of CSLL.Costs related Production, Resale and Services processesInformation of Import and Export Transactions

Application:First report on September 2015.Legal entities with IRPJ/CSLL Real profit, Presumed profit, Arbitrated profit, Immune and Exempt and Participating account companies (SCP) are required to report SPED ECF to RFB.

Blocks and Registers ECF

ECF BlocksSPED ECF Blocks

Block Block Name Scope SAP TDF/ECF and Phoron ECF

0 Opening the File and IdentificationInformation available in the Organizational Structure, Questionnaire and ECF Selection Screen.

C ECD Recovered Information (block retrieved by system - not imported)

Block fully recovered from SPED ECD file.

E Recovered ECF Information Previous and Fiscal Calculation of ECD Recovered Data (Block recovered by the system -not imported)

Block fully recovered by the PVA system.

J Chart of Accounts and Mapping Block fully recovered from SPED ECD file.

K Balances of the Accounting and Reference Accounts Block fully recovered from SPED ECD file.

L Net Income - Real ProfitBalances of equity accounts (L100) and P/L accounts (L300) are recovered from SPED ECD. The remaining records (L200 and L210) can be calculated/generated by Phoron ECF.

M E-LALUR and e-LACS Calculated and generated by Phoron ECF.

N Calculation of Income Tax and Social Contribution (Real Profit)

Calculated and generated by Phoron ECF.

P Presumed profit Not covered by Phoron ECF.

T Arbitrated Profit Not covered by Phoron ECF.

U Immune or Exempt Not covered by Phoron ECF.

W Country-by-Country Statement Under Implementation for Phoron ECF.

X Economic Information Calculated and generated by Phoron ECF.

Y General information Generated by Phoron ECF.

9 Closing the Digital File Generated by TDF/ECF and Phoron ECF.

Data Retrived from SPED ECD

SPED ECF

Process and Functionalities SAP

SAP Process & FucntionalitiesSAP Process for SPED ECF

SAP decided not to develop a solution forSPED ECF in ERP.

SAP solution is focused on generating theSPED ECF report, not in implementing allcalculation of IRPJ and CSLL.

The standard solution for SAP TDF/ECFdelivers around 30%* of all data required forSPED ECF.

* Source: SAP

SAP Process & Fucntionalities

Source: SAP

TDF Components

SAP Process for SPED ECF

Source: SAP

TDF/ECF Overview

Phoron SPED ECF

Integration ERP - TDF

Phoron ECFPhoron SPED TDF/ECF

A product for SAP ERP, integrated to SAPTDF/ECF.

ECF file can be extracted in SAP ERP or in SAPTDF/ECF.

Uses a structure of tables to faciliate the loadto SAP TDF/ECF using the “Phoron connector”.

Phoron ECFECF ERP

Phoron ECFSPED ECF on SAP TDF

Based on SPED ECF for ERP.

Database model created to use the “PhoronConnector” to load ECF data from ERPsolution to TDF/ECF layer.

Simple integration using the “Phoronconnector”.

SAP ERP

SPED ECF (ERP Solution)

Phoron ECFSPED ECF on SAP TDF

TDF/HANA

“Phoron Connector”

ERP relevant tables

SLT Replicated tables

TDFECF Layer

SAP TDF / ECF

SAP TDF/ECFSPED ECF on SAP TDF

Source: SAP

TDF Components

SAP TDF/ECFSPED ECF on SAP TDFORGSTR01 – Maintain Organizational Structure

SAP TDF/ECFSPED ECF on SAP TDFTOM – Tax Obligation Monitor

SAP TDF/ECFSPED ECF on SAP TDFSPED ECF Report

SAP TDF/ECFSPED ECF on SAP TDFSPED ECF Report – Questionnaire

SAP TDF/ECFSPED ECF on SAP TDFSPED ECF Report - Execution

SAP TDF/ECFSPED ECF on SAP TDFSPED ECF Report – CheckList

Questions?

Phoron Consulting GmbH

Österreich

T: +43 1 748 36 02

F: +43 1 748 36 22

E: office@phoron.com

www.phoron.com

Rafael Pin Rodrigues

SAP Finance Consultant

M: +55 19 99212-2187

E: Rafael.Rodrigues@phoron.com

sped ecf on hana/tdf

Technology

manuel utilisateur - tdf

tdf responsive design101_v1

ppt on tdf

sped 568 collaboration skills in special education sped 568

sped education

tbm ecf md ecf efx sb brochure

tdf renal dysfunction naicker - tdf renal dysfunction... ·...

department of special education - ric€¦ ·...

final report - tdf

special education...

sped count process - azed.gov · 7.1 sped count process ......

education specialist credential programs master of science...

tdf nonwoven co.,ltd

sap tdf admguide

ecf mindspark training academy€¦ · introducing ecf...

sped 12 ict and sped

special programs - ode.state.or.us · sped database what is...

bpm pro cycling euro tdf

sped presentation2

2016 tdf-overview