Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Import Transactions

Import Transactions

Transactions are typically data related to time-stamped orders, invoices, sales process activities, or payments. Transactions can come from a variety of external systems. You can import transactions if your instance has transactions enabled.

Navigation

Navigation Icon5.png Navigate to
Integration > Import Data
.

Import Transactions

Before you can import transactions, you need to create your transaction field definitions. Your transaction field definitions determine what columns appear in your transactions template.
Transactions only import to child accounts, using the same mapping available for Actuals or Plan imports. You can't import linked accounts with
Show actuals if linked account has them
 enabled because the General Ledger Account won't hold its own Actuals.
See Transactions for details.
  1. Select
    Transactions
    as the Import Type.
  2. Click
    Download template
     and follow its instructions to fill in the data you need to import.
  3. Click
    Choose File
     and browse to the template you edited and click
    Import
    .
  4. Click
    Continue
    .
Transaction Example Import Template
The columns for a transaction import vary depending on your transaction field definitions.
The Transactions import template has columns for:
  • Posting Date (Required): A date field for the transaction posting date.
  • Transaction Type (Required): The transaction type.
  • Account (Required): The account code for the transaction. This column header can also use the label Account Code.
  • Level Code (Required): The level the transaction applies to.
  • Transaction Amount (Required): The amount for the transaction.
  • Description: A text field.
  • <Dimension> Code: A dimension code field. Enter the code of the dimension. Required when you enter a dimension on a row. Example: Product Code.
  • <Dimension> Name: A dimension name field. Enter the name of the dimension. Optional when you enter a dimension on a row so that you can use a name that's different from the code while the data import automatically creates the dimension values. Example: Product Name.

Delete Transactions During Import

When you import you can choose to delete existing transactions as part of the import.
If you select No, your import adds to the existing transactions.
If you select Yes, provide a date range and choose which transactions get removed before the import begins.
Transactions can only be deleted during the import process.