Docs
RevRec comes with several in-built standard reports that allow you to view and analyze various metrics and statistics about your revenue. The reports provide comprehensive revenue information from different perspectives. They include a GAAP-based ASC 606 view and an analytical view.
A RevRec Admin user can customize RevRec standard reports based on your unique business needs to track key metrics that are critical to your business. Contact RevRec Support for more details.
The standard reports are built under seven significant categories Revenue, Sales, Billings, Control and Validation, Accounting, Forex, and Service Delivery. The following table contains all the standard reports that are available on the RevRec site for your immediate access under various categories:
Category | Report |
---|---|
Favorites | Your most viewed reports |
Revenue | Unearned Revenue Rollforward |
Revenue Backlog | |
Unearned Revenue WaterFall | |
Revenue Backlog WaterFall | |
Sales & Invoice | Sales Order |
Invoices | |
Unbilled Receivable Rollforward | |
Sales Order Control | |
Expense | Deferred Expense Rollforward |
Deferred Expense Waterfall | |
Control and Validation | Invoice Control |
Journal Entry Control | |
Revenue Control | |
Order Control | |
Service Delivery Control(Units Delivered) | |
Service Delivery Control(Percentage Delivered) | |
Job Errors | |
Monthly Trend/Reasonableness | |
Accounting | Journal Entry Report |
Forex | Forex Exchange Rates |
Forex Transalation by Order | |
Service Delivery | Service Delivery Rollforward(Units Delivered) |
Service Delivery Rollforward(Percentage Delivered) | |
Security & Audit | Audit Trail |
Security Events |
The Favorites folder contains your favorite reports for you to conveniently access reports you use the most. You can mark a report as favorite by clicking the star icon next to any report name.
You can access the following standard reports under the Revenue category:
You can access the following sales and invoices-related standard reports under the Sales & Invoices category:
You can access the following expense-related standard reports under the Expense category:
You can view the following control reports under this category:
The Journal Entry Report under the Accounting category reports the accounting journal entries for revenue, commissions, and tax based on the account mappings.
Forex reports are accessible if you have enabled the multi-currency feature in your RevRec site. You can view the following Forex reports in this category:
You can access the following standard reports under the Service Delivery category:
You can find and download data files that you choose to export from the Sales Order page, including Sales Order, Revenue, or Expense exports, in CSV file format.
You can access the following security and audit-related standard reports under the Security & Audit category:
The Sales Order Manual Update report is designed to display all sales orders manually edited through the user interface, highlighting records modified by the user. It offers customizable filters and export options to facilitate efficient data analysis.
To access the Sales Order Manual Update report, follow these steps:
This report provides a comprehensive view of all records related to sales orders manually updated through the user interface. This includes the modifications made to sales orders via scheduled sync jobs, import jobs, and changes made by specific users. The report serves as a valuable tool to track and monitor the entire set of records for sales orders, offering transparency and accountability in every modification made.
To filter the data based on specific criteria to narrow down the results. Follow the steps below:
1.Enter the desired filter criteria in the following filter options:
In addition to the default columns, you can add or remove columns from the report's search result grid. To customize columns, follow the steps below:
Click Column Chooser or a similar option in the report interface.
A Column Chooser window will appear, displaying a list of available columns.
Drag the column from the list and drop it into the grid to add the column.
Drag the column from the grid and drop it into the Column Chooser to remove the column.
You can export the data from the Sales Order Manual Update report for further analysis.
Follow the steps below: 1.Click the Export button.
2.A pop-up will appear with a count of records. 3.Once confirmed, data will be exported to a CSV file. 4.CSV file can be downloaded from the exported data tab as shown below.
The exported CSV file contains all versions of the sales order records. Users need to identify the modification version based on the manual update flag. This flag distinguishes manually edited records from those modified through sync jobs or import jobs, providing clarity on the source of each modification.
You have the flexibility to drill down and apply filters to any report, allowing you to customize them according to your specific metric requirements. If you prefer to keep these reports exclusively for your own access, they will be saved under User Reports. Alternatively, if you wish to share these reports with other users, they will be stored under Shared Reports.
Please contact RevRec Support for more information on customizing and storing reports.
Was this article helpful?