Financial Report Guide

REPORT NAME

DESCRIPTION

REPORT (TAB)

Sales Chronologically Written

This will provide a hard copy list of all sales orders written for the time period. This report is driven by the sales order creation date. This is a list of sales that are in progress.

Job Costing

Sales Chronologically Invoiced

This will provide a hard copy list of all the invoicing created for the time period. This report is driven by the invoice creation date. This is the sale revenue that has been posted to the income statement for the same time period.

Accounting

Purchases by Vendor

This report is a reference to the material costs per product by specific vendors. This report is driven by the material costs that have been verified on accepted payables.

Analysis

Purchases by Buying Group

Run this report if you participate in a buying group or purchasing spiff by the vendor. Please note: This report is driven by the product catalog’s relationship to accepted payables and needs to be properly set up in order for the report to be accurate. This report will provide a hard copy of the products purchased with the buying group specification.

Analysis

Total Sales (Written) (Personnel)

This report provides the same information as the Sales Chronological report however it is categorized by sales personnel. 

Job Costing

Financial Inventory by Type

This report is a list of the inventory on hand and inventory that has been invoiced with an ordered status and shows the financial value (verified and unverified). This report has to do with the financial movement of inventory.

Inventory

On Hand Inventory by Type

This report is a list of the inventory received and physically on hand. This report shows the unverified and verified cost values per inventory record. This report has to do with the physical movement of inventory.

Inventory

Received (All) (Customer Payments)

This report is a list of all customer payments collected for a specific date range.

Accounting

Trial Balance

Enterprise Financials

This report lists the current balance in each of the general ledger accounts for a specific date range. This report also shows the total debits and total credits in two additional columns.

Enterprise Module

Balance Sheet

Enterprise Financials

This is a statement of company assets, liabilities, and equities balances for a specific date range. 

Enterprise Module

Income Statement

Enterprise Financials

This report indicates the company’s income from operations (loss or profit) for a specific date range. This report is a reflection of Income, Cost of Goods Sold (Purchases), and general expenses.

Enterprise Module

Receivables Aging

This is a list of Accounts Receivable (A/R) owed to the company. This report reflects the outstanding invoices customers owe the company.

Accounting

Payables Aging

This is a list of Accounts Payable (A/P) the company owes its vendors. This report reflects the outstanding invoices the company owes to material, sub-contractors, and general expense vendors.

Accounting

Sales Taxes

This report is a historical record of the sales taxes collected on invoiced sales orders for a specific date range. An account inquiry must be printed to show any payments against sales tax collected.

Accounting

Unapplied Funds

This report displays customers that have monies available on their account that have not been used against customer invoices. This report is driven by the Deposit general ledger account.

Accounting

JobRunner Rev Rec WIP (As of Date)

Enterprise Job Costs

JobRunner ONLY

This report lists all open projects and their percentage of completion information in order to make month-end adjustments based on the costs in excess of billings and the billings in excess of costs figures. 

Enterprise Module