Office Connector Query

Sample Reports

The following Report Templates come with every copy of Office Connector Query. All Report Templates fall under the Limited Warranty for Packaged Excel Templates.

Report NameDescription
AP Vendor QueryA 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 EndThis 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 CustomerThis 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 AnalyzerThis 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 OwnersProvides a report of who has ownership of an Event 1 Software concurrency that is in use.
Read more...
GL Account ExplorerThis 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 DetailThis 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 StatementThis 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 CommentsThis 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 BalanceThis report produces a standard trial balance listing all accounts with their current balance and current period activity.
Read more...
JC Cash Flow Analysis by JobThis 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 CompleteThis 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 ReconciliationThis 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 WeatherThis report produces a Job list with links to online maps and weather information.
Read more...
JC Job ScheduleThis 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 TransactionsThis 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 ProgressThis report produces a schedule of Work In Progress for jobs in-progress based on stored master file totals.
Read more...
PM Aging Summary by TenantThis 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 ListThis 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 TenantThis report provides the Tenant activity by reporting all the transactions as of the charge date.
Read more...
PR Employee QueryThis 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 EndThis 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 ViewThis 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 TransactionsUse 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...