# Start from a Template You're not alone on your analytics adventure. Optro offers several out-of-the-box solutions, common across ARC teams.

Workflow Template	Description
3 Way Match	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.
Account Reconciliation	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.
Accounts Payable - Analytical Review	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.
Accounts Payable - Debt Aging and Approval	This template covers two areas related to accounts payable. It tests items related to accounts payable aging and also tests for proper debt approvals.
Accounts Receivable - Completeness, Write-Offs, and Manual Adjustment Testing	Performs testing on invoice completeness, write-offs to invoices, and manual adjustments to invoices.
Accounts Receivable - Analytical Review	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.
Accounts Receivable - Credit Aging and Approval	This template covers two areas related to accounts receivable. It tests items related to accounts receivable aging and also tests for proper credit approvals.
Accounts Receivable - Credit Limits and Balance Testing	Performs testing on the credit limits and total balance of customers.
Automated Sampling	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.
Benford's Law	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.
Change Management Review	Verifies change tickets existence and the appropriate approval parameters surrounding the existing tickets.
CutOff Testing	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.
Disbursement Analysis	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.
Fictitious Vendor Testing	Identifies potential matches between vendor and employee addresses to determine if fictitious vendors were created for fraudulent activities.
Financial Account Variance Analysis	Performs a financial account variance analysis. It flags variances in trial balance amounts over an identified threshold.
Fixed Assets - Depreciation Recalculation	Performs a recalculation of straight-line and MACRS depreciation of your fixed assets.
Fixed Assets - Duplicate Identification	Identify duplicate fixed assets in your listing using a variety of information.
Fixed Assets - Negative NBV Check	Identifies any assets in which their net book value is negative.
Journal Entries - Analytical Review	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.
Journal Entries - Anomaly Detection	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.
Journal Entries - Approval and Suspicious Posting Testing	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.
Journal Entries - Balanced and Suspicious Amount Testing	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.
Journal Entries - Duplicates and Sequence Testing	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.
Missing Data Check	Provides the building blocks to identify data fields or values that may be missing within your dataset.
New User Access Testing	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.
Numerical Outlier Detection	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.
Payroll - Ghost Employees, Analysis, and Duplicates	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.
Payroll - Inactivity and Salary Confirmation	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).
Procure to Pay - Duplicates and Suspicious Posting Testing	Automates the detection of duplicate and suspicious postings within the Procure to Pay (P2P) cycle associated with your Invoices, Purchase Orders, and Payment Listing.
Procure to Pay - Mismatched Documents & Vendor Spend	Identifies any mismatched purchase orders and invoices among your listings and orders your top ten vendors by spend amount.
Procure to Pay - Payments to Remitted to Employees	Automates the detection of payments remitted to employees within the Procure to Pay (P2P) cycle.
Procure to Pay - Payment Timing and Terms Test	Automates the testing of payment terms and timeliness of payments to vendors.
Procure to Pay - Vendor Master File Review	Automates the review of key and relevant information for your vendor master file. Checking information like inactive vendors, valid TIN, and low spend.
Risk Scoring	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.
Segregation Of Duties	Identifies conflicts in the duties performed by your employees. This is done by utilizing employee listings, roles, and a conflicting duties table.
Terminated User Access Testing	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.
Travel & Expense Testing	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.
User Access Review	Verifies that a user access review was performed completely and appropriately by the reviewer.