Importar y gestionar datos

You can import trial balance, general ledger, and subledger data into your engagement from a variety of sources.

Data import files, such as Excel or CSV files, are referred to as data sources, which you can then configure and assign to a dataset on the Datasets page. Multiple data sources can be assigned to a single dataset. In addition, you can also import unstructured data—data that cannot be readily assigned to any of the existing dataset types—by selecting the Other dataset type. The import source and dataset options available to you vary based on your product.

Any engagement can have several types of datasets, which are collections of data normally found in an engagement. Each dataset stores data related to a different aspect of an engagement and has predetermined fields. See descriptions of datasets and their fields in Dataset types described.

To learn more about importing and managing your data, see these related topics:

Data sources and datasets explained, an example

The diagram conceptualizes the differences between data sources and datasets. See also Resolve data import conflicts for more information on how data conflicts can arise and how to solve them.

Data sources in relation to datasets

Elemento Descripción
1 One or more data sources can be imported into a dataset. Each data import file is listed as a separate data source. There is a data conflict between ImportFileA and ImportFileB in the data row whose Supplier ID is 1234 in both files. In this case the user has opted to keep the data in ImportFileA.
2 The resulting dataset does not necessarily contain all the data rows from all data sources depending on how any potential data conflicts are resolved.
3 You can view the data making up a dataset by exporting the dataset.

Dataset types described

Tipo de conjunto de datos Descripción
Libro mayor Asientos del libro mayor
Balance de comprobación A worksheet in which all ledgers are compiled into debit and credit columns in order to ensure a company's bookkeeping system is mathematically correct.
Cuentas por pagar — Facturas

The Accounts payable—invoices dataset contains all invoices received during the period under review.
Cuentas por pagar — Pagos efectuados

The Accounts payable—payments Made dataset contains all payment transactions (check, wire transfer, cash, and so on) made during the period.
Cuentas por pagar — Proveedores

The Accounts payable—suppliers dataset contains all details related to the Supplier such as Contact details, address, credit limit and so on.
Cuentas por pagar — Saldos abiertos

The Open accounts payable dataset contains details regarding all open, unpaid, or unresolved payable transactions as of the close of business on a specified date.
Cuentas por cobrar — Facturas

The Accounts receivable—invoice dataset contains all invoices generated during the period under review.
Cuentas por cobrar — Cobro recibido

The Accounts receivables—cash received dataset contains all payment transactions (check, wire transfer, cash, and so on) received during the period.
Cuentas por cobrar — Clientes The Accounts receivable—customers dataset contains all details related to the customer, such as contact details, address, credit limit and so on.
Cuentas por cobrar — Saldos abiertos The Accounts receivable—open balances dataset contains details regarding all open, unpaid, or unresolved customer transactions as of the close of business on a specified date.
Transacciones de inventario Captures all transactions affecting inventory accounts during the time period specified (for example, receipts, shipments, transfers, returns, and adjustments).
Inventario disponible Captures the on-hand inventory quantities of items by location and amounts as of the specified date.
Otros Unstructured transaction data that does not follow a predefined schema. Select this option to import data that does not correspond to any of the dataset types described here. Each file you import using this dataset type is considered its own dataset.