3305 Main Street Ste 019 Vancouver, WA 98663

OCQ – Sample Reports

Office Connector Query

Sample Reports

The following Sample Reports come with every copy of Office Connector Query:

Report Name Description
AP Vendor Query A workbook created from this template allows you to search your vendor list for a specific vendor based on several criteria. Once you locate the vendor you want, a list of open and paid invoices for the vendor can be viewed.
Read more...
AP Year End This template can be used at year-end to identify a list of vendors for which 1099 information may be required.
Read more...
AR Aging by Customer This report produces an aging of Accounts Receivable invoices as of a specific date. The invoices are placed in aging columns based on the date entered for the current period end date.
Read more...
AR Aging by Customer (No Retainage) This report produces an aging of Accounts Receivable invoices as of a specific date. The invoices are placed in aging columns based on the date entered for the current period end date.
Read more...
Batch Analyzer This report provides a means to research the activity for a given batch by seeing its related transactions that were posted to other applications. This can be useful when trying to isolate a reconciliation difference. The Application of Origin and Batch Number fields serve as common pieces of information that tie together the data from multiple applications (subsidiary ledgers).
Read more...
Current Concurrency Owners Provides a report of who has ownership of an Event 1 Software concurrency that is in use.
Read more...
GL Account Explorer This report allows you to explore your chart off accounts and underlying detail interactively. Select which accounts you want to see, view their current balances, and then double-click to see transactional detail. Double-click on individual transactions to see mock-ups of invoices and checks.
Read more...
GL Account Ledger with Detail This report produces a ledger of accounts for a specified date range. Beginning and ending balances for the time period can be included. Additionally, closing entries can be included or excluded.
Read more...
GL Financial Statement This report produces a workbook containing a standard income statement and balance sheet based on account types and the parameters entered on the Admin worksheet. This template is intended for Sage 300 Construction and Real Estate data folders that do have a prefix for general ledger accounts,.
Read more...
GL Financial Statement - With Comments This report produces a workbook containing a standard income statement and balance sheet based on account types and the parameters entered on the Admin worksheet. This template is intended for Sage 300 Construction and Real Estate data folders that have a prefix for general ledger accounts.
Read more...
GL Financial Statement - With Comments (No Prefixes) This template produces a workbook containing a standard income statement and balance sheet based on account types and the parameters entered on the Admin worksheet. This template is intended for Sage 300 Construction and Real Estate data folders that not have a prefix for general ledger accounts,.
Read more...
GL Financial Statement (No Prefixes) This report produces a workbook containing a standard income statement and balance sheet based on account types and the parameters entered on the Admin worksheet. This template is intended for Sage 300 Construction and Real Estate data folders that do not have a prefix for general ledger accounts.
Read more...
GL Trial Balance This report produces a standard trial balance listing all accounts with their current balance and current period activity.
Read more...
JC Cash Flow Analysis by Job This template allows you to analyze your net increase or decrease to cash resulting from job activity such as cash receipts and costs paid.
Read more...
JC Cost To Complete This is an interactive report that provides a means to see date sensitive values for a job by cost code and then enter forecasted values. The cost at completion and over/under values are calculated and displayed real-time.
Read more...
JC GL Reconciliation This template produces a comparison of cost amounts posted to General Ledger and Job Cost to confirm that the two are in balance. Any differences are shown on the Delta worksheet.
Read more...
JC Job List with Maps and Weather This report produces a Job list with links to online maps and weather information.
Read more...
JC Job Schedule This report producers a graphical representation of job starts and durations based on Estimated, Revised, and Actual start/end dates for jobs that are unstarted or in-progress.
Read more...
JC Transactions This report produces a detailed transaction list for the desired job. You may select the range of dates and types of transactions to be included.
Read more...
JC Work In Progress This report produces a schedule of Work In Progress for jobs in-progress based on stored master file totals.
Read more...
PM Aging Summary by Tenant This template produces a workbook that contains a summary of rent roll information by property and tenant. Aging columns are included to show aged receivable amounts.
Read more...
PM Lease Expiration List This report produces a list of leases that are due to expire within the specified period. Select leases for a specific property or all properties. Quickly filter the list further using the autofilter buttons on each column heading.
Read more...
PM Tenant Ledger By Tenant This report provides the Tenant activity by reporting all the transactions as of the charge date.
Read more...
PR Employee Query This report provides a quick way to lookup information about a specific employee. An employee can be identified using their Employee ID or their Social Security Number. A list of checks that fall within the desired date range is included.
Read more...
PR Year End This report provides information that would be useful when carrying out year-end processes for Payroll. In addition, a simple allocation tool is included that can assist with calculation the allocation amounts for pay periods that may be split over a fiscal year or period.
Read more...
Quick View This report provides a high-level view of the various Sage 300 Construction and Real Estate applications allowing you to see at a glance which applications contain unposted transactions. Summary totals for subsidiary ledgers are also provided.
Read more...
Search for Transactions Use this report to find transactions that contain values that you supply. Matching transactions are displayed from General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Property Management.
Read more...