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.

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 tagged).
  • Visual identifier for transactions.
  • If Entry Number and Entry ID are not tagged, each transaction is assigned a random unique identifier.
  • In the Sequence Gaps AnalyticsAI test.

Requirements

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

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.
  • 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 tagged as non-posted are not used for calculating sum of transactions for data completeness checks.
  • Transactions tagged as posted are used in AnalyticsAI tests.

To learn more, see AnalyticsAI test results.

Requirements

  • 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