
Reports List

Bank Compliance Workbook (BCW)
Automation of month-end compliance reporting for Capital One, CIBC and other security industry banks

Monthly Business Analysis (MBA)
Management’s month-end business recap with supporting tables and charts for all key metrics

ESTA Template
Template supporting the metrics and benchmarking ESTA program

Monthly Division Analysis (MDA)
Key performance indicators by branch and/or department compared to budget and historical benchmarks

SNAPS Template
Template supporting the metrics and benchmarking NetOne SNAPS program

ASC 842 Operating Leases
Tool for creating journal entries to book monthly amortization on operating leases in compliance with GAAP

Benefit Payments Entries
Tool for creating journal entries to distribute insurance and other benefit expenses by branch and category

Credit Card Entries
Tool to code credit card transactions and build the journal entry

Deferred Revenue Detail
Calculates deferred revenue for each customer recurring item

GL Journal
Flexible account register for viewing all or selected transaction types with filtering and drill-down features

Job Accrual
Tool for estimating percentage of completion on jobs and building the month-end accrual journal entry

Job Margin Analysis
Reconciles job general ledger activity to detailed job reports and provides job accrual progression analysis

Job Over/Under Billing Adjustment
Builds the month-end journal entry to book an over/under billing adjustment if WIP/DRJ is not used

Open Holdbacks
Supporting schedule of open holdbacks (aka retention amounts)

Payroll Entries
Automates the creation of payroll journal entries for liabilities, payments, expense distribution and accrual

Trial Balance and Register
Trial balance supported by an account register that can be filtered by two or more branches

Benefit Deductions Entries
Tool for creating journal entries to distribute insurance and other employee deductions by branch and category

Commissions Tracking
Calculates job commissions due to reps using customizable payment plans, tracks payments, supports the GL liability

Deferred Labor Allocation
Creates the journal entry to clear deferred labor at month-end to the correct branches and categories

Expense Allocation
Tool for allocating insurance, depreciation, and other expenses to branches and categories

GL Reconciliations
Tool for managing month-end balance sheet account reconciliations

Job Adjustments
Creates journal entries to adjust WIP/DRJ to comply with the closed job recognition method of accounting

Job Over-Under Margin Analysis
Similar to Job Margin Analysis but for Over/Under Billing method

Job-Svc Transactions Analysis
A list of job and service transactions that don't reference a job or ticket, respectively

Open PO Receipts
Supports the GL balance with consideration for timing of receipts and bills

Recurring Revenue Adjustment
Compares recurring revenue to actual RMR records and builds a reclassification adjustment entry

Use Tax Calculation
Calculates use taxes on job and service parts based on your state tax laws

Accounts Payable Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Cash Flow Forecast
Tool to forecast cash flow on a weekly or monthly basis

Collections Activity
Shows key metrics regarding your collection efforts

Accounts Receivable Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Cash Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Customer Receivable Activity
Detail report of a customer's lifetime receivables activity through a specified date

Executive Dashboard
Sixteen key performance indicator (KPI) charts showing YTD vs. goals or estimates

Operations Dashboard
Trend and comparative analysis of Jobs, Service, Technicians and Prospects

Financial Dashboard
Trend and comparative analysis of RMR, Cash, A/R, Inventory and A/P

Closed Jobs Review
For use by managers to quickly evaluate closed job results on a weekly basis

Job Detail
Provides expansive job details when drilling down from various summary reports

Jobs Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Projected Job Hours
Calculates projected technician hour requirements in the coming months for jobs in queue

Unreconciled Job Parts
Detail list of job parts that need to be ordered or issued

Job Billings
Detailed list of invoices tied to jobs including pivot tables by item code and item type

Job Parts Cost Analysis
Analyzes a job's parts and labor costs and, optionally, builds a journal entry to adjust costs before closing

Open Jobs Review
A project management tool for tracking job costs to budget and facilitating determination of progress billings

Prospects Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Count and Cost Analysis
Analyzes part value changes when updating standard costs concurrently with a physical count

PO Tracking
Detailed listing of purchase orders with date, status and other filtering features

Parts Cost Review
Compares standard costs to primary vendor prices and calculates variances

Parts List
Detailed listing of inventory parts, parts ordered, and parts created

Inventory Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Parts Activity
Shows parts activity (received, used, adjustments, transfers) and calculates months on hand (MOH) for each part

Parts Count Sheet
Streamlined physical inventory count sheet

Parts Value and Audit
Calculates the value of on-hand parts and compares that value to the inventory journal

Cancellations by Notice Date
Detailed list of currently open cancellations in the cancellations queue by notice date

RMR Item Trend
A rolling 12-month analysis of each recurring revenue invoice item

RMR by Item Type
Customer list showing RMR by item type (i.e. monitoring, service, inspection, lease, etc.)

RMR Audit Info
Detailed list of recurring revenue accounts

RMR Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Recurring Revenue Comparison
Compares recurring revenue to RMR by customer within each GL account to easily isolate questionable differences

Cell Conversion Tracking
Tool to track progress on cell communication conversions

Inspections Due
Detailed list of inspections due with robust selection and filtering options

Service Analysis
Analysis of the cost of go-backs, unbilled tickets and other

Service Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Contract Analysis
Calculates profit/loss on service and inspection contracts and provides drill-down to ticket details

Open Tickets
Detailed list of open service tickets

Service Billings
Detailed list of invoices tied to service tickets including pivot tables by item code and item type

Tech Entry (Detail)
Timesheet by tech including chargeable and nonchargeable time, with the option to export to CSV for import to SedonaOffice

Tech Time Import
Tool for importing non-chargeable tech time into SedonaOffice from payroll or time entry applications

Tech Timesheet
Tool for creating and emailing daily/weekly timesheets using Flex automation

Tech Report Pack
Versatile roll-forward trend reporting with drill down to detail, pivot tables and charts

Tech Time Reconciliations
Tech time by branch, category, tech, labor type, and jurisdiction, often used for reconciling hours to payroll

Time Time Import (Misc Appts)
Tool for importing non-chargeable tech time into SedonaOffice from miscellaneous appointments

Customer Detail
Provides expansive customer details when drilling down from various summary reports

Customer Invoice Totals
Customer invoice and credit activity for a specified date range

Weighted Credit Score
Summary report of RMR by credit score buckets

Customer Growth
Invoice and RMR trends by individual customer

Customer Profitability
Accounting of a customer's lifetime value contribution through jobs, billable service and recurring contract services

AR Items
Listing of AR invoice items

Eligible RMR
Ages RMR based on open customer invoices to identify RMR at risk of cancellation

GL Edit Tracking
Detail report of GL transactions by edit date and user

Invoice Items Maintenance
Utility to update AR invoice items, including status, GL category, GL account, item type, and description

Net Sales
Report of net sales by customer, branch, and invoice type for a specified date range

RMR Tracking Fixes
Tool to insert records into the RMR tracking table to reconcile history to actual customer recurring down to the item level

Sales Tax Rates
Detail report of sales tax setup by tax group, including tax table rates and taxability by item type

Shared Expense Allocation
Automation of month-end department expense allocations to revenue/cost categories in support of the BUS

Troubleshooting Reports
Tool to identify and fix common customer, site, system, UDF, and service data errors

User Permissions
Tool to review a user's SedonaOffice permissions based on his/her assignment to one or multiple user groups

Daily Notes
Detail report of notes entered by user for a specified date range

Employees List
Listing of employees

GL Out of Balance Fix
Utility to fix GL issues, including missing GL accounts or out of balance entries

Invoice Payments
Detail listing of payments made on AR invoices for a specific date range

RMR Tracking Analysis
Isolates customer records where the recurring table and the RMR history table do not match

Revenue Breakdown
Revenue breakdown by branch location, including city, state and zip

Sales Tax Review
Detail report of sales taxes charged by item type for a date range, and used for sales tax filing

Stranded WIP
Detail report showing WIP that did not clear to the income statement for closed jobs and tickets

User Activity
Tool to review user activity with filters for user and date range

Vendor List
Listing of AP vendors