3305 Main Street Ste 019 Vancouver, WA 98663

OCI – Sample Reports

Office Connector Import

Sample Reports

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

Report Name Description
AP Invoice This example worksheet imports a single AP invoice. More complex solutions involving multiple invoices, more data validation and calculations could be based on the core aspects of this example.
Read more...
AR Invoice This example worksheet imports a single AR invoice. More complex solutions involving multiple invoices, more data validation and calculations could be based on the core aspects of this example.
Read more...
AR Invoice Form (ocq) This example provides a printable form for importing a single AR invoice into Accounts Receivable. This template uses Office Connector Query to provide convenient lists for Customer, Job, Standard Items.
Read more...
CM Clear Checks (ocq) This example worksheet demonstrates how to use Office Connector to mark checks as cleared. Office Connector Query provides a list of checks that can be cleared by placing an "x" in the "Cleared?" column.
Read more...
EQ Recurring Cost Entries This example worksheet imports cost entries into the Equipment module. You could use this example to import a set of recurring costs (such as monthly depreciation) on a routine basis by changing the Accounting Date and Transaction Date for each run.
Read more...
GL Budget (ocq) This example worksheet imports budgets into General Ledger. This example uses Office Connector Query to provide the list of accounts and budget types.
Read more...
GL Journal Entries This example worksheet imports a batch of journal entries into General Ledger.
Read more...
GL Journal Entries no Prefixes (ocq) This example worksheet imports a batch of journal entries into General Ledger. This is intended for companies that have a GL Account format that does not include a prefix.
Read more...
GL Journal Entries with Prefixes (ocq) This example worksheet imports a batch of journal entries into General Ledger. This is intended for companies that have a GL Account format that includes a prefix to identify entities such as companies, divisions, or departments.
Read more...
GL Transaction Import File Creator This example template provides the ability to query data from an Excel workbook that contains GL Transaction data and then use that data to create an import file for Sage 300 CRE General Ledger.
Read more...
JC Cost To Complete (ocq) 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 Direct Cost Entries This example imports a batch of direct cost entries for Job Cost. Entries intended only for General Ledger can also be created in the same batch.
Read more...
JC Direct Cost Entries (ocq) This example imports a batch of direct cost entries for Job Cost. Entries intended only for General Ledger can also be created in the same batch. This example uses on Office Connector Query to provide convenient lists for Jobs, Cost Codes, Categories and Accounts.
Read more...
JC Estimate (ocq) This example imports an estimate into Job Cost. Office Connector Query is used to provide convenient lists for Cost Codes and Categories. Please read the Important Note shown in the disclaimer below about how this template can affect existing jobs.
Read more...
JC Purchase Order (ocq) This example provides a printable form for importing purchase orders into Job Cost. Office Connector Query is used to provide convenient lists for Vendor, Job and Cost Codes.
Read more...
PM Charge Entries This example imports a batch of charge entries into Property Management.
Read more...
PM Payment Entries This example imports a batch of payment entries into Property Management.
Read more...
PR Time Entry (ocq) This example is a time sheet that can be imported into Payroll. Office Connector Query is used to provide convenient pick lists of employees, jobs, cost codes and pay IDs.
Read more...