Analytics
  • Introductions
    • 👋Hello Analytics!
    • 👩‍🎓Workflow Philosophy
    • 📹Build a Workflow
    • 🖨️Start from a Template
      • 3 Way Match
      • Accounts Payable - Analytical Review
      • Accounts Payable - Debt Aging and Approval
      • Accounts Receivable - Analytical Review
      • Accounts Receivable - Completeness, Write-Offs, and Manual Adjustment Testing
      • Account Receivable - Credit Aging and Approval
      • Accounts Receivable - Credit Limits and Balance Testing
      • Account Reconciliation
      • Automated Sampling
      • Benford's Law
      • CutOff Testing
      • Change Management Review
      • Disbursement Analysis
      • Fictitious Vendor Testing
      • Financial Account Variance Analysis
      • Fixed Assets - Depreciation Recalculation
      • Fixed Assets - Duplicate Identification
      • Fixed Assets - Negative NBV Check
      • Journal Entries - Analytical Review
      • Journal Entries - Anomaly Detection
      • Journal Entries - Approval and Suspicious Posting Testing
      • Journal Entries - Balanced and Suspicious Amount Testing
      • Journal Entries - Duplicates and Sequence Testing
      • Missing Data Check
      • New User Access Testing
      • Numerical Outlier Detection
      • Payroll - Ghost Employees, Analysis, and Duplicates
      • Payroll - Inactivity and Salary Confirmation
      • Procure to Pay - Duplicates and Suspicious Posting Testing
      • Procure to Pay - Mismatched Documents & Vendor Spend
      • Procure to Pay - Payments Remitted to Employees
      • Procure to Pay - Payment Timing and Terms Test
      • Procure to Pay - Vendor Master File Review
      • Risk Scoring
      • Segregation of Duties
      • Terminated User Access Testing
      • Travel & Expense Testing
      • User Access Review
    • 📓Release Notes
  • Workflows
    • 🎨The Canvas
    • 📏Setting Up
    • 👆Drag & Drop
      • 🖱️Click to Add
    • 🧰Tools
    • 🧮Expression Builder
      • Operators
      • Functions
        • Aggregate Functions
          • AVERAGE
          • CORR
          • COUNT
          • COUNTD
          • COUNTBY
          • COUNTIF
          • COUNTIFS
          • COVAR
          • COVARP
          • COVARS
          • MAX
          • MEDIAN
          • MIN
          • MAXBY
          • MINBY
          • PERCENTILE
          • RUNNINGTOTALBY
          • SIGN
          • SIN
          • SQRT
          • SQUARE
          • STDEV
          • STDEVP
          • STDEVS
          • SUM
          • SUMBY
          • SUMIF
          • TAN
          • VAR
          • VARP
          • VARS
          • ZN
        • Conversion Functions
          • TIMESTAMPTODATE
          • TODATE
          • TODECIMAL
          • TOINT
        • Date/Time Functions
          • DATEADD
          • DATEDIF
          • DATENAME
          • DATENORMALIZE
          • DATEPART
          • DATETRUNC
          • DAY
          • DAYS
          • WORKDAYS
          • HOUR
          • ISDATE
          • ISOWEEKDAY
          • ISOWEEK
          • ISOQUARTER
          • ISOYEAR
          • MAKEDATE
          • MAKEDATETIME
          • MINUTE
          • MONTH
          • NOW
          • QUARTER
          • SECOND
          • TODAY
          • WEEK
          • WEEKDAY
          • YEAR
        • Logical Functions
          • AND
          • BETWEEN
          • CASE
          • CHOOSE
          • CONTAINSWITHIN
          • IF
          • IFS
          • IIF
          • IN
          • IFNULL
          • ISBOOLEAN
          • ISDECIMAL
          • ISDURATION
          • ISINTEGER
          • ISNULL
          • ISNUMBER
          • ISSTRING
          • ISUNIQUE
          • NOT
          • NULL
          • OR
          • SWITCH
          • ALL
            • TOSTRING
          • ANY
        • Math Functions
          • ABS
          • ACOS
          • ASIN
          • ATAN
          • ATAN2
          • CEILING
          • COS
          • COT
          • COSEC
          • DEGREES
          • DIV
          • EVEN
          • EXPONENTIAL
          • FILLINFINITY
          • FLOOR
          • HAVERSINE
          • LOG
          • LN
          • ODD
          • MODULO
          • PERCENTILEOFVALUE
          • PERCENTILEVALUE
          • PI
          • POWER
          • RADIANS
          • RANDOM
          • ROUND
          • SEC
        • Table Functions
          • ENCODE
          • INDEX
          • INDEXBY
          • FILLNULL
          • FIRSTBY
          • GENERATEUNIQUEID
          • LASTBY
          • LOOKUP
          • MATCH
          • NTH
          • OFFSET
          • OFFSETBY
          • PREVIOUSVALUE
          • RANK
          • RANKBY
          • RECORDID
          • ROLLINGAVERAGE
          • ROW
          • RUNNINGAVERAGE
          • RUNNINGMAX
          • RUNNINGMIN
          • RUNNINGSTDEV
          • RUNNINGTOTAL
          • WINDOWAVERAGE
          • WINDOWMAX
          • WINDOWMIN
          • WINDOWCOUNT
          • WINDOWSUM
          • SEQUENCE
          • WINDOWMEDIAN
          • WINDOWSTDEV
          • WINDOWSTDEVP
          • WINDOWSTDEVS
          • WINDOWVAR
          • WINDOWVARP
          • WINDOWVARS
          • WINDOWCORR
          • WINDOWCOVAR
          • WINDOWCOVARP
          • WINDOWCOVARS
          • SMOOTHEDAVERAGE
        • Text Functions
          • ASCII
          • CHAR
          • CONCAT
          • CONTAINS
          • ENDSWITH
          • FIND
          • FINDNTH
          • ISEMPTY
          • JSONPARSE
          • LEFT
          • LENGTH
          • LOWER
          • LTRIM
          • MID
          • PROPER
          • RIGHT
          • RTRIM
          • SPACE
          • SPLIT
          • STARTSWITH
          • TRIM
          • SUBSTITUTE
          • UPPER
        • Window Functions
    • 🔗Parameters
      • File Input Parameters
      • Sample Tool Parameters
      • System Parameters
  • Tools
    • 🗃️Import
      • Import File
      • Import From API
      • Import From Integration
        • GitHub
        • Snowflake
      • Import Sample Data
      • New Table
    • ✨Clean
      • Find Replace
      • ParseJSON
      • Sample
      • Text to Columns
      • Validate
    • 💻Code
      • PythonCode
        • Fuzzy Match
    • 🤝Merge
      • Append
      • Join
    • 🧙Transform
      • Edit Columns
      • Add Columns
      • Select Columns
      • Filter
      • Sort
      • Deduplicate
      • Pivot
      • Unpivot
    • 📊Visualize
      • Chart
        • Bar
        • Line
        • Combo
        • Scatter
        • Histogram
        • Box
        • Pie
        • Area
        • Funnel
    • 📬Publish
      • Publish to Toolkit
      • Publish via Email
  • 📚Dictionary
Powered by GitBook
On this page

Was this helpful?

  1. Introductions

Start from a Template

Last updated 3 months ago

Was this helpful?

You're not alone on your audit analytics adventure. AuditBoard offers several out-of-the-box solutions, common across audit teams.

🖨️

This template covers three way matching. It verifies accounts payable expenses using a set of three different documents—the invoice, the purchase order, and the receipt listing.

Provides the building blocks to completing account, individual, or subledger level reconciliations. It will take your provided general ledger or account information and reconcile with sub-ledger or account information.

Performs various trend and analytical reviews on your accounts payable listing. It tests the period-over-period changes in spend by month, vendor, and your AP Turnover Ratio.

This template covers two areas related to accounts payable. It tests items related to accounts payable aging and also tests for proper debt approvals.

Performs testing on invoice completeness, write-offs to invoices, and manual adjustments to invoices.

Performs various trend and analytical reviews on your accounts receivable listing. It tests the period-over-period changes in sales by month, customer, and your AR Turnover Ratio.

This template covers two areas related to accounts receivable. It tests items related to accounts receivable aging and also tests for proper credit approvals.

Performs testing on the credit limits and total balance of customers.

Provides the building blocks for automated sampling. It takes a sample data set and determines the correct sample size using three different approaches: statistical methods, sampling guidelines, or a static sample size.

Provides you the building blocks for any analysis utilizing Benford's Law. It takes a sample data set and preforms Benford's analysis on the PO amount.

Verifies change tickets existence and the appropriate approval parameters surrounding the existing tickets.

This template aims to give you the building blocks for any cut off testing. It takes a sample invoice listing and journal entry listing file and does cutoff testing accordingly.

Identifies material changes in period over period cash disbursements which may require additional analysis. It additionally allows you to validate all disbursements were approved by the appropriate individual(s) in accordance with the defined policy.

Identifies potential matches between vendor and employee addresses to determine if fictitious vendors were created for fraudulent activities.

Performs a financial account variance analysis. It flags variances in trial balance amounts over an identified threshold.

Performs a recalculation of straight-line and MACRS depreciation of your fixed assets.

Identify duplicate fixed assets in your listing using a variety of information.

Identifies any assets in which their net book value is negative.

Performs various trend and analytical reviews on your journal entries. It tests the period-over-period changes in amounts booked to various accounts, trends in the various account combinations, as well as the total count and sum total of these bookings. This analysis helps identify significant changes or trends in your financial data across different periods.

Performs various tests to detect anomalies within your journal entry listing. It looks for missing descriptions, zero amount entries, adjusting entry identification and summarization, and manual entry identification and summarization.

Performs various journal entry tests. It flags journal entries which are posted and approved by the same user, posted at suspicious dates and times, and entries posted to accounts which are used infrequently.

Takes a look at your journal entries. It helps identify if your entries are balanced and if the imbalance is due to rounding. It also identifies suspicious entries by commonly used amounts as well as entries just below manual approval limits.

This template takes a look at your journal entries. It helps identify duplicates by ID and amount. It also helps you identify any JE ID's that might be missing in a sequence or out of an expected range of ID's.

Provides the building blocks to identify data fields or values that may be missing within your dataset.

Identifies newly provisioned users and validates they have appropriate permissions based upon their role. Additionally, it identities users who have recently changed roles and may have been inappropriately provisioned to a system.

Exposes any numerical outliers within your dataset for a specific field. This template utilizes Z-score or Median Absolute Deviation (MAD) to help discover any numerical data that might be considered an outlier.

Performs Payroll Review tests. Flag employees who may be getting paid but do not actually exist. Flags employees getting paid an amount different from the active salary amount according to their most recent pay adjustment. Identify salary adjustments that are anomalies in comparison to company average. Identify duplicate payments to employees, and anomalies with bonuses or overtime.

Performs Payroll Review tests. Flag inactive employees who may be getting paid. Flags employees getting paid (ADP Payroll) an amount different from their Employee Profile (Workday HR).

Automates the detection of duplicate and suspicious postings within the Procure to Pay (P2P) cycle associated with your Invoices, Purchase Orders, and Payment Listing.

Identifies any mismatched purchase orders and invoices among your listings and orders your top ten vendors by spend amount.

Automates the detection of payments remitted to employees within the Procure to Pay (P2P) cycle.

Automates the testing of payment terms and timeliness of payments to vendors.

Automates the review of key and relevant information for your vendor master file. Checking information like inactive vendors, valid TIN, and low spend.

Utilize a risk scoring approach to determine risk level of individual items within a dataset. This template provides you a basic guideline to setting up a risk calculation and determination on an individual transaction basis.

Identifies conflicts in the duties performed by your employees. This is done by utilizing employee listings, roles, and a conflicting duties table.

Identifies recently terminated users and validates whether they have appropriate system permission. Additionally, it identities users who have recently changed roles and may have been inappropriately provisioned to a system.

This template covers some of the common tests related to travel and expense. It tests for timeliness, multiple approvers, non business related expenses, duplicates, and receipt compliance.

Verifies that a user access review was performed completely and appropriately by the reviewer.

3 Way Match
Account Reconciliation
Accounts Payable - Analytical Review
Accounts Payable - Debt Aging and Approval
Accounts Receivable - Completeness, Write-Offs, and Manual Adjustment Testing
Accounts Receivable - Analytical Review
Accounts Receivable - Credit Aging and Approval
Accounts Receivable - Credit Limits and Balance Testing
Automated Sampling
Benford's Law
Change Management Review
CutOff Testing
Disbursement Analysis
Fictitious Vendor Testing
Financial Account Variance Analysis
Fixed Assets - Depreciation Recalculation
Fixed Assets - Duplicate Identification
Fixed Assets - Negative NBV Check
Journal Entries - Analytical Review
Journal Entries - Anomaly Detection
Journal Entries - Approval and Suspicious Posting Testing
Journal Entries - Balanced and Suspicious Amount Testing
Journal Entries - Duplicates and Sequence Testing
Missing Data Check
New User Access Testing
Numerical Outlier Detection
Payroll - Ghost Employees, Analysis, and Duplicates
Payroll - Inactivity and Salary Confirmation
Procure to Pay - Duplicates and Suspicious Posting Testing
Procure to Pay - Mismatched Documents & Vendor Spend
Procure to Pay - Payments to Remitted to Employees
Procure to Pay - Payment Timing and Terms Test
Procure to Pay - Vendor Master File Review
Risk Scoring
Segregation Of Duties
Terminated User Access Testing
Travel & Expense Testing
User Access Review
How to clone a template