Transaction details described

When importing general ledger transactions from a CSV or Excel file, you must map fields, so the transactions data display properly in the engagement. In addition, certain fields are consistent across lines within an entry. During an import, these fields will be stored separately, being populated with the values from the first entry line within the entry. See How general ledger data is stored upon import for more information.

This topic describes the fields within the TRANSACTION DETAILS category that appear in the General ledger dataset.

Note that some fields are mandatory for specific data analytics tests to function properly. To learn more see, Mandatory fields for data analytics.

Entry Number (entry_number)

Sequential identifier that is unique to each journal entry.

Usage

  • Groups transaction lines into transactions (if Entry ID isn't assigned).
  • Visual identifier for transactions.
  • If Entry Number and Entry ID are not assigned, each transaction is assigned a random unique identifier.
  • In the Sequence Gaps AnalyticsAI test.

Requirements

  • If Entry ID is not assigned, there must be no blank Entry Number cells.

  • If Entry ID is assigned, only the first entry number value for each unique Entry ID will be imported.

Amount (amount)

Amount of the transaction line. This can be a positive value for a debit and negative for a credit.

Usage

  • Data reconciliation/completeness.
  • In these AnalyticsAI tests:
    • Duplicate Entries
    • Ends in 999
    • High Amounts
    • Rounded Amounts
    • 2-Digit Benford's
    • Zero Amounts

Requirements

  • Positive and negative values can be included in either of:
    • One column with negative values formatted in a standard negative formatting. Examples include:
      • -4000,00
      • (4000.00)
      • 4000.00-
    • Separate columns tagged "debit" and "credit".
  • Commas or periods are interpreted as decimal separators.

Detail Comment (detail_comment)

Description of the line entry.

Usage

In these AnalyticsAI tests:

  • Missing Descriptions
  • Specific Keywords

Posting Date (posting_date)

Effective date - data entry was posted (validated) to the general ledger, regardless of the date created.

Usage

  • Associates transactions with a date and fiscal period.
  • In these AnalyticsAI tests:
    • Duplicate Entries
    • Unusual Days

Requirements

  • To be viewed in the transactions list, transactions must be within fiscal-year range as set within the engagement.

  • Only the first Posting Date value for each unique Entry ID will be imported.

  • Date format must be properly set:
    • Day
      • D - one digit for days below 10 (e.g., 2)
      • DD - two digits (e.g., 02)
      • DDD - day of the year (e.g., 365)
      • DDDD - three digit day of the year (e.g., 002)
    • Month
      • M - one digit for months below 10 (e.g., 4)
      • MM - two digits (e.g., 04)
      • MMM - three letter abbreviation (e.g., Apr)
      • MMMM - no abbreviation (e.g., April)
    • Year
      • YY - two digits (e.g., 19)
      • YYYY - four digits (e.g., 2019)
    • Time
      • H HH - Hours (24 hour time) (e.g. 0..23)
      • h hh - Hours (12 hour time used with a A.) (e.g 1..12)
      • k kk - Hours (24 hour time from 1 to 24) (e.g. 1..24)
      • a A - Post or ante meridiem (Note the single characters "a" and "p" are also considered valid) (e.g. am pm)
      • m mm - Minutes (e.g. 0..59)
      • s ss - Seconds (e.g. 0..59)
      • S SS SSS ... SSSSSSSSS - Fractional seconds (e.g. 0..999999999)
      • Z ZZ - Offset from UTC as +-HH:mm, +-HHmm, or Z (e.g. +12:00)

Posting Status (posting_status)

Indicates whether the entry has been posted or not posted.

Usage

  • Transactions whose Posting Status is set to non-posted are not used for calculating the sum of transactions for data completeness checks.
  • Transactions whose Posting Status is set to posted are used in AnalyticsAI tests.

To learn more, see AnalyticsAI test results.

Requirements

  • Only the first Posting Status value for each unique Entry ID will be imported.

  • Less than 2,500 unique values. These values must be tagged to one of:

    • Posted
    • Non-posted

    Document Type (document_type)

    Enumerated field describing the original source document, with check, debit-memo, credit-memo, finance-charge, invoice, order-customer, order-vendor, payment-other, reminder, tegata, voucher, shipment, receipt, manual-adjustment, other.

    Usage

    • Filtering transactions based on journal type.
    • In the Unusual Users AnalyticsAI test.

    Requirements

    • Less than 2,500 unique values.
    • The data in the applicable column in the transaction import file (the CSV file) must be assigned to the document_type values below:
      • GJ - General Ledger Entries
      • CD - Cash Disbursement
      • CR - Cash Receipts
      • SJ - Sales Invoices
      • PJ - Purchases Invoices
      • PL - Payroll Ledger Entries
      • AR - Accounts Receivable Adjustments (credits, returns, other adjustments)
      • AP - Accounts Payable Adjustments (credits, returns, other adjustments)
      • FA - Fixed Assets Adjustments
      • IN - Inventory Adjustments
      • SC - Sales Contracts
      • SO - Sales Orders
      • PC - Purchases Contracts
      • PR - Purchase Requisitions
      • PO - Purchase Orders
      • GS - Goods Shipped
      • GR - Goods Received
      • OT - Other