This topic introduces the different types of financial reports that you can produce in Q360.
| Type | Options | |
| Income | · Consolidated P&L: 1 period or fiscal year
· Consolidated P&L: by sub-account for 1 period · Comparative P&L: 2 periods across different fiscal years · Combined P&L: 1 period segmented by branches or departments · Income versus budget · Income by branch, state or master |
|
| Balance Sheet | · Consolidated: 1 period
· Comparative: Last 2 periods with % change · Comparative: Last 2 period focusing on Sources and Uses (S&U) of cash |
|
| Trial Balance | · Standard Consolidated Trial Balance for each account
· Account Detail by sub-accounts (segments) |
|
| Sub Ledgers | · AR
· AP · Inventory · Inventory Purchase Suspense · Inventory Clearing · Sales Clearing |
· Project Deferred Revenue
· Project WIP Reconciliation · Inventory WIP Reconciliation · Project Retention · Service Contract Deferred Revenue · Fixed Assets · Pre-Paid Expense |
| Financial Ratios | · Current Ratio
· Quick Ratio · Return On Assets · Return On Equity |
· Debt To Equity
· AR Turnover · Average Collection Period |
| Taxes | · Accrued taxes by code
· Accrued taxes by invoice · 1099-MISC |
|
| Accounts Receivable | · Standard Aged Receivable (by Invoice date or by Due date)
· By Age (Current, 31-60,61-90,90+) · By Currency · AR by Customer Analysis · Customer statement (single customer or all customers) |
|
| Accounts Payable | · Standard Aged Payable (Voucher-based)
· By Age (Current, 31-60,61-90,90+) · Checks Register |
|
| Commissions | · Commissions Advice
· Commissions Paid |
|
| Purchasing | · Manufacturer Sales Forecast
· Expense by Vendor · Purchases by Master No. |
|
| Inventory Valuation | · By Branch
· By Master |
|
| Fixed Assets | · Fixed Assets Reconciliation | |
| Projects | · Project Status (WIP)
· Projected vs. Actual Hours · Project Delta · Project GP Change |
|
| Profitability (Completed / Ongoing) | · Projects Profitability
· Service Contract Profitability · Call Profitability · Sales Opportunity Labor Conversion · Customer Profitability |
|
| Time Billing | · Time billing Summary or Detail
· Employee Utilization by Labor Type |
|
| Forecasting | · Cash Flow Forecast
· Project Revenue/Cost Forecast · Project Backlog Projection · Labor Capacity Forecast · Service Contract Revenue Projection · Service Contract Invoicing Projection |
|
| Budgets | · Budget versus Actuals | |