Reports List

<< Click to Display Table of Contents >>

You are here:  Retrieve > Reports >

Reports List

There are universal reports available for all vault bridge types as well as unique reports specific to the bridged accounting systems.

 

Note: If this icon is present, ReportsscreenAdministrationtabReportImageicon-mh, you can click it to view a copy of the active document in the Document Viewer.

 

 

 

Universal Reports

 

AP Approval Alert Invoices Report

 

This report lists those invoices, per vendor, with approval alerts. The report includes the due date and invoice total and identifies the assigned processor.

 

Use this report to review invoices with approval alerts.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

 

 

AP Approved Invoice Detail Report

 

This report lists the invoice details of each approved invoice that has not yet been exported. The single value you can select is the vault number. This report is by vault.

 

Use this report to identify approve invoices that are pending export.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Processor ID

This report will run for All Processors or a specific processor based on your field dropdown selection.

 

 

AP Discount Status Report

 

This report lists those invoices with eligible discounts that are still available, based on the discount date. You can select specific reviewers; the default is all (0). Select dates for discount date expiration and invoice start dates. The Discount Date default is the current date. You can choose to include--or not include--approved invoices in the report. This report is by vault.

 

Use this report to locate invoices where the discount is about the expire.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Reviewer ID

This report will run for All Reviewers or a specific reviewer based on your field dropdown selection.

Discounts Expiring By

This report will run with the discount expiration date entered or click the calendar icon to find a date.

 

 

AP Do Not Pay Invoices

 

This report lists those invoices that were marked as Do Not Pay. Per vendor, the report includes the invoice number, the date the invoice was placed on Do Not Pay status, the invoice due date, the date the invoice was entered in Sage Intacct Paperless and the invoice total.

 

Use this report to review invoices with a Do Not Pay status.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered or click the calendar icon to find a date.

 

 

AP Export Detail Report

 

This report lists, by vault, all the invoice headers and detail lines that were included in an export for a specific date. Exported batches have a date/time stamp instead of a calendar. Click F4 for the lookup of the export date/time stamps. Select the exported batch with the precise date/time stamp. Totals for the number of invoices and number of lines display, as well as total tax, freight, discount and retainage amounts. You can sort this report by Invoice ID; Vendor is the default sort. The Vault Number and Name display in the report header.

 

Use this report to identify all invoices that were exported in a particular batch.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Export Batch ID

This report will run for the export Batch ID entered.

 

 

AP Invoice Approval Activity Report

 

This report tracks all approvals, those approvals by assigned reviewers or only proxy approvals. The report can be filtered by vault, reviewer or date range.
View invoices and the lines each reviewer approved and when, and when each invoice was exported. You can look at a single reviewer or activity for an entire vault based on a specific time range.

 

Use this report to determine whether reviewers are reviewing and approving or using proxies.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Begin Approval Date

This report will run for the beginning approval date entered or click the calendar icon to find a date.

Ending Approval Date

This report will run for the ending approval date entered or click the calendar icon to find a date.

Approved By

This report will run for All Approvers or a specific approver based on your field dropdown selection.

 

 

AP Invoice Detail Report

 

This report lists line and coding details for a specific invoice. This report includes a Document sub report for displaying matched documents. Click the document icon in the 2nd tier to access a copy of the image. The Documents sub report displays matched documents on the report.

 

Use this report to view a specific invoice's line and coding details.

 

Parameter

Permissible Value

Invoice ID

This report will run for the Invoice ID entered. Click help on locating the invoice ID.

 

 

AP Invoice Drilldown Report

 

This reports lists, in vendor order, all invoices matching the invoice date range. This report includes the number of invoices per vendor.

 

Use this report to see all invoices active in APFlow™ by vendor, to drill down to view images, coding and notes, and identify the reviewer. Use this report as a search tool.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Vendor

This report will run for the vendor ID selected through the lookup or enter 0 to select all vendors.

Invoices >$

This report will run for all invoice dollar amounts greater than the number entered.

Job Number

This report will run for the job number selected through the lookup or enter 0 to select all jobs.

GL Code

This report will run for the GL code selected through the lookup or enter 0 to select all GL codes.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered or click the calendar icon to find a date.

Processor

This report will run for All Processors or a specific processor based on your field dropdown selection.

 

 

AP Invoice History by Job Report

 

This report if for job tracking within a specific date range. This allows project managers to track what they have spent by job and by vendor.

 

Use this report to track job costs.

 

Parameter

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Job Number

This report will run for the job selected through the lookup or enter 0 to select all jobs.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered of click the calendar icon to find a date.

 

 

AP Invoices Ready For Export Report

 

This report lists by vault, each invoice--with header and line field details--that is ready for export.

 

Use this report to identify all approved invoices that have not been exported for a vault.

 

Parameter

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

 

 

AP Invoices With Discounts Report

 

This report lists all invoices, by vendor, that fall between the dates with discount amounts.

 

Use this report to identify those invoices with upcoming available discounts.

 

Parameters

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered of click the calendar icon to find a date.

 

 

AP Outstanding Invoice Aging By Processor

 

This report lists invoice aging per processor. Double click the processor name to access invoice aging details. A By Status sub report for that processor generates.

 

Use this report to see how long invoices take to move through the process before they are approved and to see how many invoices are waiting to be approved.

 

Parameters

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Processor

This report will run for All Processors or a specific processor based on your field dropdown selection.

 

 

AP Outstanding Invoice Aging By Reviewer

 

This report lists invoice aging per reviewer. Double click the reviewer name to access invoice aging details. A By Status sub report for that processor generates.

 

Use this report to see how long invoices take to move through the process.

 

Parameters

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Reviewer ID

This report will run for All Reviewers or a specific reviewer based on your field dropdown selection.

 

 

AP Outstanding Invoice Aging By Vendor

 

This report lists invoice aging per vendor. Double click the vendor name to access an invoice aging details sub report. Click the link in the Reviewers column to view the list of individual reviewers in another sub report.

Click in the Documents column to view the document related to the invoice in a third sub report. Click the ReportsscreenAdministrationtabReportImageicon-mh icon to view the actual invoice. This report includes Exported Invoices status filtering.

 

Use this report to see what the cumulative dollar amount per vendor remains outstanding.

 

Parameters

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Vendor

This report will run for the vendor selected through the lookup or enter 0 to select all vendors.

 

 

AP Outstanding Invoices By Job

 

This report lists invoices, by job and then by vendor, all invoices that are outstanding by a specific date. Invoices for the vendor display even if the Job field is left blank. There is a grand total that includes all listed invoice totals.
Note:  Invoices not coded to jobs are included in this report.

 

Use this report to see the invoices in the system by job.

 

Parameter

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Job Number

This report will run for the job selected through the lookup or enter 0 to select all jobs.

 

 

AP Processor Entry Statistics Report

 

This report lists processors, per vault, and the number of invoices they have entered and the number of lines per invoice. Click the date link to access an Invoices Entered by Processor on date sub report detailing the invoice and due dates, along with the invoice total.

 

Use this report as a visual of processor production.

 

Parameter

Permissible Values

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Begin Entry Date

This report will run for the beginning entry date entered or click the calendar icon to find a date.

Ending Entry Date

This report will run for the ending entry date entered of click the calendar icon to find a date.

Processor

This report will run for All Processors or a specific processor based on your field dropdown selection.

 

 

AP Processor Status Report

 

This report lists, by vault and then by processor, the number of invoices assigned to each processor and each invoice's status.

 

Use this report to see how many invoices each processor is working and the status of those invoices.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

 

 

AP Secondary Vendor Drilldown

 

This report lists, by vault and then by secondary vendor, the invoices where those secondary vendors are named. Click the link in the Invoice # column to access the sub report with a specific vendor's invoice details. This sub report includes the invoice line number, the amount, the date and the status. The original date indexed and by whom is also listed.

 

Use this report to track secondary vendors paid through credit cards.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Secondary Vendor ID

This report will run for All Secondary Vendors or a specific secondary vendor based on your field dropdown selection.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered of click the calendar icon to find a date.

Invoices >$

This report will run for all invoice dollar amounts greater than the number entered.

 

 

AP Top Vendor Report

 

This report lists the top 50 vendors, per vault and then by invoice total dollar amount. Each vendor in the list displays with the number of invoice and the number of invoice line details.

 

Use this report to identify your top 50 vendors.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Top X Number

This report will run for the number of vendors entered.

Report By

D = This report will display in invoice dollars.
N = This report will display in the number of invoices.

Begin Invoice Date

This report will run for the beginning invoice date entered or click the calendar icon to find a date.

Ending Invoice Date

This report will run for the ending invoice date entered of click the calendar icon to find a date.

 

 

AP Unapproved Invoice Listing

 

This report can be set to display reviewer information when the total invoices outstanding for that reviewer are greater than a specific dollar amount.

 

Use this report to track reviewers and their invoices waiting for approval.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Vendor

This report will run for the vendor selected through the lookup or enter 0 to select all vendors.

Processor

This report will run for All Processors or a specific processor based on your field dropdown selection.

 

 

AP Unapproved Invoice Listing by Reviewer

 

This report displays reviewer information and lists each reviewer's unapproved invoices.

 

Use this report to track reviewers and their invoices waiting for approval.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Reviewer ID

This report will run for All Reviewers or a specific reviewer based on your field dropdown selection.

 

 

APFlow™ Proxy Rights Audit Report

 

This report lists all proxy rights given to system users. Each system user is listed identifying for whom they have rights and whether notifications are in place.

 

Use this report to determine who has proxy rights.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Proxy User ID

This report will run for All Proxy Users or a specific proxy user based on your field dropdown selection.

 

 

APFlow™ User Rights Report

 

This report lists all proxy rights given to APFlow™ users. Each APFlow™ user is listed identifying for whom they have rights and whether notifications are in place.

 

Use this report to determine who has APFlow™ proxy rights.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

Checked Out Documents Report

 

This report lists, for the current vault, those documents that are checked out. Report details include the document description and ID, when the document was checked out (date and time), by whom, their client ID and IP Address.

 

Use this report to identify who has checked out a particular document.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

Deleted Documents Report

 

This report lists all those document that were deleted within a specific date range. Click the document label link to access a sub report that includes a description of the deleted document, when it was deleted and by whom.

 

Use this report to research if a document was deleted and who deleted it.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Document Type

This report will run for All Document Types or a specific document type based on your field dropdown selection.

Begin Deletion Date

This report will run for the beginning deletion date entered or click the calendar icon to find a date.

Ending Deletion Date

This report will run for the ending deletion date entered of click the calendar icon to find a date.

Deleted By

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

DocRoute™ Proxy Rights Audit Report

 

This report lists all proxy rights given to DocRoute™ users. Each DocRoute™ user is listed identifying for whom they have rights and whether notifications are in place.

 

Use this report to determine who has DocRoute™ proxy rights.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

Document Audit Log

 

This report tracks the activities performed against a specific document such as modifications, routing activities.

 

Use this report to identify what changes were made to a document or to its meta data.

 

Parameter

Permissible Value

Document ID

This report will run for the Document ID number entered. Click help on locating the ID of a document.

 

 

Document Index Statistics Report

 

This report displays document indexing statistics by index date range, vault and user id. Filtering by user and vault is available.

 

Use this report to review the number of indexed documents within a certain time range, by a user and by vault.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

Beginning Index Date

This report will run for the beginning index date entered or click the calendar icon to find a date.

Ending Index Date

This report will run for the ending index date entered of click the calendar icon to find a date.

 

 

Document Inventory Report

 

This report lists, for the current vault, the number of documents based on the document type.

 

Use this report to drill down for a list of documents with a specific document type.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Document Type

This report will run for All Document Types or a specific document type based on your field dropdown selection.

Category

This report will run for All Document Categories or a specific document category based on your field dropdown selection.

Begin Index Date

This report will run for the beginning index date entered or click the calendar icon to find a date.

Ending Index Date

This report will run for the ending index date entered of click the calendar icon to find a date.

Indexed By

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

Document Security Detail Report

 

This report lists, per vault, document security around a specific document type. Access by role details what can or cannot be done; specifically, indexing, adding pages, deleting pages, distributing, deleting snapshots and manage read-only. The members of each role are listed. This report is available for every document type.

 

Use this report to see what role has what access based on the document type.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

 

 

Document Type Detail Report

 

This report lists each document type and includes setup details such as the description, category and retention period as well as index details and security groups information, per vault.

 

Use this report to review document type setup details.

 

Parameter

Permissible Value

Document Type

This report will run for All Document Types or a specific document type based on your field dropdown selection.

Category

This report will run for All Document Categories or a specific document category based on your field dropdown selection.

 

 

Purged Documents Report

 

This report lists documents, by vault, that were purged within a specific date range. Details include a description of each purged document and who purged the document, and indicates the status of the document before it was purged.

 

Use this report to research purged documents.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

Begin Purge Date

This report will run for the beginning purge date entered or click the calendar icon to find a date.

Ending Purge Date

This report will run for the ending purge date entered of click the calendar icon to find a date.

 

 

Queue List By User

 

This report details queue information assigned to users. Queues include barcode and OCR queues and identifies what type of queue(s) the user has.

 

Use this report to view queues assigned to users.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

System Audit Report

 

This report lists audit details on administration changes with details on changes; specifically, who did what and when.

 

Use this report to track changes made to the administrative configuration (Security Groups, Document Types) through the Global Settings page.
Check out old value vs. new value and determine what was done, when it was done and by whom.

 

Parameter

Permissible Value

Begin Audit Date

This report will run for the beginning audit date entered or click the calendar icon to find a date.

Ending Audit Date

This report will run for the ending audit date entered of click the calendar icon to find a date.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

User Activity Audit Log

 

This report lists every time a user logs in and logs out of Sage Intacct Paperless within a specific date range. It also includes identifying what a user does, what documents are opened, etc.

 

Use this report to see what user activity within the system.

 

Parameter

Permissible Value

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

Begin Audit Date

This report will run for the beginning audit date entered or click the calendar icon to find a date.

Ending Audit Date

This report will run for the ending audit date entered of click the calendar icon to find a date.

 

 

User Login Audit Report

 

This report lists system login detail for a specified report period. The report details the number of times the user logged in to Sage Intacct Paperless. Drill down to view login time stamp and machine.

 

Use this report to determine when a user logs into the system and on what machine.

 

Parameter

Permissible Value

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

Begin Audit Date

This report will run for the beginning audit date entered or click the calendar icon to find a date.

Ending Audit Date

This report will run for the ending audit date entered of click the calendar icon to find a date.

 

 

User Setup Detail Report

 

This report lists, by user, how each system user is set up. This report uses information entered in Global Settings | Users.

 

Use this report to review how users are set up without having to access Global Settings and look at each user individually.

 

Parameter

Permissible Value

Active Only?

Click the check box to include active users only.
Leave the check box blank to include all users.

User ID

This report will run for All Users or a specific user based on your field dropdown selection.

 

 

Vault Detail Report

 

This report displays, by current vault, the information that was entered in Vault Settings. This report displays the vault logo, if one exists.

 

Use this report to review vault setup without having to access Vault Settings and look at each vault individually.

 

Parameter

Permissible Value

Vault Number

This report will run for All Vaults or a specific vault based on your field dropdown selection.