Reporting areas reference

Reporting areas correspond with data objects. Each reporting area provides different data for your report. Refer to the following Reporting area tables for information on each Reporting area.

Accounts Payable

Accounts Payable reporting areas

Reporting area	Description
AP adjustments	Track AP purchase invoice adjustment detaisl, including dimensions, labels, amounts, GL accounts, Projects, suppliers, customers, employees, and related Accounts Payable accounts.
AP purchase invoices	Track AP purchase invoice transaction details including dimensions, labels, amounts, GL Accounts Payableaccounts, Projects, suppliers, customers, employees, and related accounts.
AP payments	Track AP purchase invoice and payment transactions details, including dates, amounts, dimensions, General Ledger accounts, entities, projects, accounts, and items.
AP payments legacy	Track payment transaction details, including project information, dates, amounts, dimensions, General Ledger accounts, entities, suppliers, classes, and items.
AP transactions	Track details on AP purchase invoice transactions, including amount, dimensions, type, account, supplier, related accounts, and labels.
Supplier	Track Supplier details. Includes supplier, parent, General Ledger accounts, General Ledger group, location, Accounts Payable term, inventory control price list, amounts, 1099 information, and payment information.
Wells Fargo payment manager	Track data entry details for payment processing. Reduces the chance of errors when posting a payment.

Accounts Receivable

Accounts Receivable reporting areas

Reporting area	Description
AR adjustments	Track Accounts Receivable adjustment transaction details, including payments, keys, dates, amounts, General Ledger accounts, customers, dimensions, and deferred revenue.
AR sales invoices	Track transaction details including account labels, allocations, invoice details, General Ledger accounts, record information, exchange rate data, currency, dimensions, and time hierarchies.
AR payments	Track AR sales invoice and payment transaction details, including AR sales invoice payments, keys, dates, amounts, General Ledger accounts, customers, dimensions, and deferred revenue.
AR pymt detail	Create reports that record payments and cash receipts against AR invoices. Captures additional details, such as credits that might have been applied to an invoice.
AR transactions	Track details on Accounts Receivable transactions, including amount, dimensions, type, account, customer, related accounts, and labels.
Customer	Track customer details. Includes location, parent customer, account labels, General Ledger accounts, dimensions, terms, credit limit, amount due, and Order Entry details.
Projects	Track project information. Includings name, contacts, description, type, status, dimensions, manager, customer, dates, amounts, duration, and summary financial balances.
Projects transactions	Track project estimate details, including dimensions.

Cash Management

Cash Management reporting areas

Reporting area	Description
Bank deposits	Track bank deposit details, including account labels, status, departments, deposits, suppliers, projects, dimensions, amounts, and record numbers.
Credit card	Track credit card transaction details, including transactions, account information, suppliers, project, General Ledger accounts, amounts, class, project, and item.
Reconciliation match report	Create reports of bank reconciliation matches easily and efficiently.

Company

Company reporting areas

Reporting area	Description
Assignment	Track the individual internal activities needed to complete a checklist.
Checklist	Track checklist details, including Checklist ID, Checklist name, Checklist owner, and Checklist status.

Construction

Construction reporting areas

Reporting area	Description
AP payment detail	Track AP payments to AP bills, adjustments, advances, and other transactions.
AP retainage	Track release retainage withheld on customer bills by creating a release retainage batch.
AR retainage	Track release retainage withheld on customer invoices by creating a release retainage batch.
Change requests	Track project change request entries and header information, including dimensions and related objects.
Cost code resources	Track resources for project tasks (cost codes) mapped to project contract lines so billable expenses are attributed to the correct project contract line.
Cost codes	Project tasks (cost codes) mapped to project contract lines so that billable expenses are attributed to the correct project contract line.
Cost type	Provides a reference of the Construction projects Cost Type dimension configuration with Project and Task objects.
Lien waiver detail	Provides compliance detail that combines related AP bill and AP payment detail records.
Payroll report check	Tracks employee check details, such as salary or an hourly wage, and whether an overtime multiplier applies to an employee. For more information, go to the Construction Payroll help center.
Payroll report check summary	Automates employee check details, such as salary or an hourly wage, and whether an overtime multiplier applies to an employee. Calculates the appropriate state and federal withholding taxes. For more information, go to the Construction Payroll help center.
Payroll report compensation table	Provides a reference for your payroll compensation configuration selections. Includes related report objects for trade and trade level configuration.
Payroll report compensation table rates	Provides a reference for your payroll compensation table rates configuration. Includes related report objects for trade, trade level, and compensation table configuration.
Payroll report employee	Provides a reference of the configuration details for construction payroll employees. For more information, go to the Construction Payroll help center.
Payroll report gross pay	Automates calculating employee gross pay related to Construction projects. For more information, go to the Construction Payroll help center.
Payroll report pay modifier	Automates calculating employee pay modifiers related to Construction projects. For more information, go to the Construction Payroll help center.
Payroll report pay modifier rate	Provides a reference for your payroll configuration selections. Includes related report objects for system, employee, compensation, and compensation trade level pay modifier configuration. For more information, go to the Construction Payroll help center.
Payroll report pay modifier setup	Provides a reference for your configuration selections for system, employee, compensation, and compensation trade level pay modifiers for payroll. For more information, go to the Construction Payroll help center.
Payroll report PTO accrual schedule	Provides a reference of the PTO Accrual Schedule setup information and accrual rates for construction payroll. For more information, go to the Construction Payroll help center.
Payroll report PTO activity	Automates calculating employee PTO related to Construction projects. For more information, go to the Construction Payroll help center.
Payroll report tax	Automate calculating employee taxes related to Construction projects. For more information, go to the Construction Payroll help center.
Payroll report tax setup	Categorize and setup information for payroll report taxes to extend construction payroll reporting. Fields include Tax ID, State/Province, Reporting level (Federal, State, Local), Tax category (WC, SUI, SIT, etc.), and Tax type.
Payroll report timecard	Track employee time for each time category, on construction related projects. For more information, go to the Construction Payroll help center.
Payroll report timecard summary	Track employee overtime, travel time, and vacation time for construction related projects. Applies the appropriate cost for each time category on a per-project basis. For more information, go to the Construction Payroll help center.
Payroll report trade	Provides a reference of the Construction Payroll trade setup details including trade level definitions and tax classifications. For more information, go to the Construction Payroll help center.
Project change orders	Tracks construction project change orders. Linked change requests are available through the Change Requests reporting area.
Project contract	Order entry project contract header information and totals.
Project contract billing detail	Aggregate Order Entry invoice amounts and related information by project contract line. This is used for reporting and generating formatted construction invoice documents for project contract billings.
Project contract billing summary	Aggregate Order Entry invoice amounts and related information by project contract invoice. This object can be used for reporting and generating formatted construction invoice documents for project contract billings where the line detail is not required.
Project contract line task	Manage the mapping of billable tasks to a Timw an Materiasl (T&M) project contract line.
Project detail	Combine project transactions for different objects, including General Ledger, Purchasing, Accounts Payable, Accounts Receivable, Order Entry, Project estimates, Project contracts, and more.
Project estimates	Track task and cost type dimensions to categorize project actual and estimated costs at detailed levels. Project estimates posted to General Ledger (GL) budgets.
Project summary billing detail	Create reports focused on summarized expenses for project contract lines that use T&M summary billing.
T&M billing rate tables for project contracts	Create reports focused on the rate tables for each type of billable expense. The rate tables are used when billing project contract lines configured for T&M billing.
Vendor compliance	Create reports focused on the vendor compliance records used to manage compliance in Purchasing and Accounts Payable.
WIP schedule	Provide WIP schedule header information, including report ID, period begin and end dates, state, and more.
WIP schedule project	Provide WIP schedule project summary totals. Totals include project cost estimate, job to date cost and billing values, profit, overbilling and underbilling amounts, prior year totals, and fields for CFO and PM forecasted values.

Contracts

Contracts reporting areas

Reporting area	Description
Contract billing schedules	Manage billing schedule information, including the start and end dates, schedule status, and associated contract line number.
Contract billing templates	Customize billing identifying template information, including the template name, description, and status.
Contract expense	Manage expense information for either a contract or specific contract line, including the expense item, amount, expense templates, and start and end dates.
Contract expense schedules	Manage expense schedule status and type, using the Contract expense schedule entry object as the primary data source.
Contract MEA allocation detail	Manage multiple-element arrangement (MEA) allocation details.
Contract MEA bundle	Manage multiple-element arrangement (MEA) allocation information, including the allocation name, effective date, and adjustment type.
Contract revenue schedules	Revenue schedule status and type. Use the Contract revenue schedule entry object as the primary data source.
Contract revenue templates	Customize revenue template information, including template name, recognition method, and recognition source.
Contract sub-ledger links	Manage General Ledger posting information for a contract, including links to the contract, contract line, revenue schedule, billing schedule, and expense schedule.
Contract usage	Manage contract usage details, including contract information, validity, dates, customer, dimensions, and amounts.
Contracts	Manage contract information, including contract name, customer name, start and end dates, and renewal term.
SaaS metrics	Track default performance cards and graph components in the Software Digital Board Book dashboard. Uses the account, account group, or account group category names used to calculate the corresponding metric.

Fixed Assets Management

Fixed Asset Management reporting areas

Reporting area	Description
Assets	Reporting area for the Asset dimension that includes FIXEDASSET and CLASSIFICATION fields.
Depreciation Schedule	Depreciation schedule header for Fixed Assets Management that includes DEPRECIATIONSCHEDULE fields.
Depreciation Schedule Detail	Depreciation schedule entries and related fields for Fixed Assets Management, including DEPRECIATIONSCHEDULEENTRY and DEPRRULE [ASSETDEPRECIATIONRULE].

General Ledger

General Ledger reporting areas

Reporting area	Description
GL account	Manage detail information about your General Ledger account, including record and account number, normal balance, status, close into, dimensions, tax codes, project, customer, supplier, and category.
GL account group	Manage General Ledger account groups details, the grouping of your accounts, including type of account group, type of grouping, list of members in the account groups, formulas used, and filtering by dimensions.
GL budget	Manage budget detail information.
GL budget vs actuals	Manage budget and General Ledger detail information, including named budget and journal entry header and detailed line item information.
GL detail	Manage General ledger details posted directly to the General Ledger from Accounts Payable and Accounts Receivable, including journal entry header and detailed line item information.
GL document detail	Manage details on General Ledger directly posted transactions from Order Entry and Purchasing, including journal, posting dates, reporting method, children, journal entry modifications, amount, cleared state, dimensions, currency, and account information
GL dynamic allocations	Manage General Ledger dynamic allocation details, including source, basis, target, and reversing accounts.
GL entry	Manage a comprehensive list of journal entries, including posted and draft transactions.
GL transaction	Manage General Ledger transaction details for individual transactions, including record and transaction number, description, journal, balance, reversal date, attachments, and creation information.

Inter-entity transactions

Inter-entity transactions reporting areas

Reporting area	Description
Department	Manage information about each department, such as Name, Department ID, When created, and Record number.
Inter-entity transactions	Manage Inter-entity transaction details on system generated inter-entity transactions and source General Ledger journal data.
Location	Manage location information for each entity/location such as Name, Location ID, Record number, and VAT Reg No.

Inventory Control

Inventory Control reporting areas

Reporting area	Description
Build kits	Track component items and kits that are removed from inventory and the number of stockable kits you build are added to inventory. The Physical Inventory report reflects this change.
Costing	Track all inventory costing for standalone and kit items, including all Order Entry, Purchase Order, and Inventory Control transactions, and related dimensions.
Inventory	Track Inventory Control transaction detail lines, including all dimensions and price, quantity, total fields.
Inventory document entry tracking	Track Inventory Control transactions with individual serial numbers and lot tracking, including all dimensions and price, quantity, and total fields.
Item	Track individual items including General Ledger group, product line, tax group, location, and other data dependent on configurations.
Location	Manage information about each entity/location such as Name, Location ID, Record number, and VAT Reg No.

Order Entry

Order Entry reporting areas

Reporting area	Description
Drop ship history	History of generated drop ship transactions from Order Entry to Purchase Order.
Location	Manage information about each entity/location such as Name, Location ID, Record number, and VAT Reg No.
Order Entry	Mange Order Entry transaction detail lines, including all dimensions and price, quantity, total fields.
Order Entry document tracking	Manage Order Entry transactions with individual serial numbers and lot tracking, including all dimensions and price, quantity, and total fields.
Order Entry subtotals	Track Order Entry subtotal information as defined on the transaction definition.
Recurring Order Entry	Track Order Entry transactions from Recurring Templates (header only), including all dimensions and price, quantity, total fields.
Revenue recognition schedule	Track Order Entry Revenue Schedule with entries. Displays General Ledger Accounts, dimensions, and basic timesheet info.

Projects

Projects reporting areas

Reporting area	Description
Projects	Manage project information, including name, contacts, description, type, status, dimensions, manager, customer, dates, amounts, duration, and summary financial balances.
Projects transactions	Manage transactions charged to projects (including Time, Expenses, Accounts Payable, Purchase Order) with status, billable flags, dimensions, dates, quantities, and amounts.
Task resources	Manage project information, including employee, task, schedule dates, estimated duration and actuals.
Tasks	Manage project information, including task name, project, class, time type, item, billable flag, dates, and duration.

Purchasing

Purchasing reporting areas

Reporting area	Description
Drop ship history	Track the history of generated drop ship transactions from Order Entry to Purchase Order.
Purchase document entry tracking	Track purchasing transactions with individual serial numbers and lot tracking, including all dimensions and price, quantity, total fields.
Purchase order	Track purchasing transaction details, including all dimensions and price, quantity, total fields.

Taxes

Time reporting areas

Reporting area	Description
VAT/GST tax	Manage general tax details applied to the sale of goods and services.
VAT/GST tax submissions	Manage general tax submissions applied to the sale of goods and services.

Expenses

Expenses reporting areas

Reporting area	Description
Employee expense	Manage employee expense details, including status, employee information, project, dimensions, General Ledger account, amount, amount paid, non-reimbursable amounts, reference info, and payment type.
Employees	Manage employee information, including name, title, manager, dimensions, earning type, earning rates, personal information, and reimbursement information.

Time

Time reporting areas

Reporting area	Description
Timesheets	Manage employee timesheet details, including employee name, dimensions, billing flag, project, time type, date, hours, cost rate, and bill rate.