The company's accounting and financial entries are extremely important in the construction of the Income Statement and also in financial analyses, as we can use this consolidated data to analyze accounts payable, receivable, vertical and horizontal analysis of the company.

To construct these analyses, it will be necessary to import both accounting entries and financial entries.

In this first step, we must download the model file and fill in the accounting data according to the necessary organization, following the following steps:

Download the file "LançamentosContabilidade.csv" at the end of this step.
Complete and organize the tab with the information:
- Branch Code
- Movement Date
- Account Code (accounting)
- Cost Center Code
- Release Status
- Entry Type (D-> Debit, C -> Credit)
- Batch (Accounting)
- Lot Item (Accounting Lot Item)
- Value(Absolute)
If you already have a file of accounting entries with this data, you will need to prepare the data to have the same final format of fields and typing.

In this second step, we must download the model file and fill in the financial data according to the necessary organization, following the following steps:

Download the file "LançamentosFinancial.csv" at the end of this step.
Complete and organize the tab with the information:
- Issue Date (Title)
- Expiration Date (Title)
- Payment Date (if any)
- Branch Code
- Company Code (Customer or Supplier)
- Expense Type Code (according to financial nature)
- Accounting Account Code
- Bank Code
- Category Code
- Origin (Securities Payable, Receivable, Advances)
- Type of Movement (Exit or Entry)
- Status (Completed or Open)
- Movement Code
- Installment (if any)
- Schedule
- Original Value (without discounts, interest or fines)
- Interest Value
- Fine Value
- Discount Value
- Amount Paid (Absolute)
If you already have a financial entry file with this data, you will need to prepare the data to have the same final format of fields and typing.

After completing these analytical release reports, it will be necessary to restore the Data Preparation package in the desired environment and import this file (together with the "General Records" file) to process the data necessary for the data files. output that will be used as a basis for the DRE and analyzes in Power BI.

Modelos de Análises com Preparação de Dados e Power BI

Data Visualization with Power BI