Accruals Details (AP Accruals Dashboard)

Overview

The Accruals Details panel delivers a detailed and interactive view of all accrual records for a selected period. This table enables users to perform reconciliation, apply flexible grouping, filter results, and export to CSV—supporting compliance, audit, and month-end close activities.

Users can toggle between This Month and Last Month. The Group By menu allows summarization by Line, Accrual Group, or Supplier. Filtering and pagination features support efficient review and data extraction.


Line Group

When the Group By menu is set to Line (default), the table displays each accrual record at the PO/PR line level, with one row per transaction. Use this mode for detailed investigation, transaction validation, and data extraction.

Table 1. Line Field Descriptions

Column NameDescription
Line NumberIdentifier for the relevant purchase order (PO) or purchase requisition (PR) line.
Line IdentifierValue distinguishing the line within a multi-line document.
Accrual GroupGroup responsible for managing the accrual entry.
SupplierVendor associated with the PO/PR line.
Reach Out StatusStatus of communication or outreach to the supplier (e.g., "Workflow Expired").
Bot Estimated AccrualAmount estimated by Auditoria’s automation for this record.
Confirmed AccrualUser-reviewed and finalized accrual amount.
Accrual SourceCalculation method or data source used for the accrual (e.g., straight-line).
CommentOptional user notes relevant to the accrual entry.
Difference Between Bot Estimated and Confirmed AccrualDifference between automated and confirmed accrual values.

Figure 1. Accruals Details Table, grouped by Line


Interacting with the Panel (Line Group View)

  • Date Selection: Choose This Month or Last Month to display records for the relevant period.
  • Group By: Use the Group By selector to group by line, accrual group, or supplier.
  • Filtering: Click the filter icon (funnel) to display filter controls under each column header.
  • Sorting: Click on any column header to sort by that column (ascending/descending toggles on repeated clicks).
  • Pagination: Use pagination controls at the table’s bottom to browse if more records are present than the current page displays.
  • Export to CSV: After applying filters, use the export icon to download the onscreen table data to a CSV file. Export and filtering are only available in Line group.

Filtering and Exporting Accrual Records (Line Group Only)

Filtering and exporting to CSV are available only when the table is grouped by Line.

How to Filter Accrual Records

  1. Click the Filter icon. Filter fields will appear under each column header.
  2. For any filterable column:
    • Select a comparison operator (containsequalsgreater thanless than, etc.).
    • Enter a value (such as part of a supplier name, status, or currency threshold).
  3. Combine multiple filters for highly targeted results using AND logic between fields.
  4. To remove a filter: Clear the value in the field or reset the table to its default view.

Table 2. Common Filterable Fields

ColumnOperator(s)Description
Line NumbercontainsFilter on all or part of a PO/PR number
Line IdentifiercontainsFilter on unique line labels or elements
Accrual GroupcontainsFilter by one or more group names
SuppliercontainsFilter by vendor/partner name
Reach Out StatusinFilter by status value(s)
Bot Estimated Accrualless than, greater than, equalsNumerical filter for expected accrual
Confirmed Accrualless than, greater than, equalsNumerical filter for confirmed accrual
Accrual SourcecontainsFilter for calculation method/source
CommentcontainsFree text filter on user notes
Difference Between Bot Estimated and Confirmed Accrualless than, greater than, equalsFilter variances for threshold review

Not all columns are filterable. Filters and export are not available for Accrual Group or Supplier summaries.


Group By Options

The Group By feature enables users to aggregate and summarize accrual records by business-relevant dimensions. Available grouping modes are Line (default), Accrual Group, and Supplier. Switching modes updates the table’s fields and granularity.


Accrual Group

When the Group By menu is set to Accrual Group, the table aggregates accrual records by their assigned business or process group, with one row per group. Use this view for entity-level analysis, process ownership review, and assessment of group-level accrual balances and variances.

Table 3: Accrual Group Fields

Column NameDescription
Accrual GroupName of the business or process group
Sum of Bot Estimated AccrualRolling total of automated accrual estimates
Sum of Confirmed AccrualRolling total of user-confirmed accruals
Difference Between Bot Estimated and Confirmed AccrualVariance at the group summary level

Figure 2. Accruals Details Table grouped by Accrual Group


Supplier

When the Group By menu is set to Supplier, the table summarizes accrual records by vendor, so each row represents the total accrual activity for a single supplier. Use this grouping for vendor-level reconciliation, supplier audit, and managing account balances across all transactions with a given supplier.

Table 4: Supplier Fields

Column NameDescription
SupplierVendor name
Accrual GroupGroup(s) associated with these supplier lines
Sum of Bot Estimated AccrualTotal estimated accrual across all supplier records
Sum of Confirmed AccrualTotal confirmed accrual for the supplier
Difference Between Bot Estimated and Confirmed AccrualSupplier-level variance

Figure 3. Accruals Details Table grouped by Supplier

Important:

  • Filtering and CSV export are only available in Line group view.
  • Accrual Group and Supplier summary views are for status review and do not support transaction-level filtering or exporting.

Tip: Use Line-level filters and export to create audit-ready extracts and supply them to management, auditors, or other stakeholders as required.