Standard FinJinni Reports
FinJinni has nearly 200 standard reports covering every QuickBooks functional area. To make it easier to find the report you need, this reference shows them grouped by their primary purpose:
- Company Financials
- Sales, Customers and Receivables (plus Invoice Payment Analysis)
- Purchases, Vendors and Payables (plus Bill Payment Analysis)
- Jobs, Time Tracking, Employees & Payroll
- Items and Inventory
- Budgeting
- General Information, System Maintenance
- Specialty Reports, Custom Reports
Click here for complete list.
A Note on Summary vs. Detail Reports:
Reports that are called “Summary” reports will automatically total values based on the field selected. For example, if you choose The Month as a field, you will get the total for the month. If you choose Customer Name, you will get the total for that customer. You can use the same report to show a high-level or more detailed report simply by choosing appropriate fields.
Reports that are called “Detail” reports do not summarize and will usually show one line per transaction (or transaction line-item if the report has that level of detail).
Company Financial Reports
These are reports from the General Ledger, in one of several categories:
- All General Ledger accounts, Trial Balances
- Balance Sheet accounts only
- Profit & Loss accounts only
- Cash Flow reports (combination of Balance Sheet with P&L)
Sales, Customers and Receivables
Sales-related and customer-related report groups are:
- Sales Transactions, summary and detail, filtered or grouped by customer, product, sales-rep, etc.
- Pending Sales (Sales Orders)
- Invoice and AR aging
- Invoices and break-down of Payments against them
- Sales Tax Liability
- General customer information and balances
Purchases, Vendors and Payables
Purchase-related and vendor-related report groups are:
- Purchase Transactions, summary and detail, filtered or grouped by vendor, product, etc.
- Purchase Orders
- Bills and AP status and aging.
- Bills and break-down of Payments
- General vendor information and balances
Jobs and Time, Employees and Payroll
There are a number of report groups in this area. It should be noted that most of the reports in other areas can also be totaled by job.
- Estimates and Estimates vs. Actuals comparisons
- Profit and Loss by Job
- Time Worked by Job, optionally with Employee and Item detail
- Payroll information
- General employee information
Items and Inventory
Most of the financial and sales reports can be filtered or totaled by item. In addition, these groups are available:
- Sales and Purchases of Items, including Top-n Item reports
- Inventory Item Status and Aging
- Inventory Site and Lot reports
- General Item Information
Budgeting
For budget reports, the data for budget can either come from QuickBooks or be entered into FinJinni from Excel, bypassing QuickBooks. In both cases, the same comparison reports are available:
- Actual vs. Budget, by account, class, date group (e.g. MTD, YTD).
- Actual THEN Budget, showing actuals up to a cut-off and budget for the remainder of the year.
- Budget Summary and Detail
General Information, System Maintenance
This area covers a number of basic reports, such as account and class lists, plus reports used to verify proper system operation.
Specialty Reports, Custom Reports
Here we describe and list a number of specialized and custom reports that have been created for customers in the past. These and more are available for customization to meet your specific requirements.
On the Query screen under Financial Queries, General Ledger:
General Ledger Summary for Date Range
General Ledger Detail for Date Range
General Ledger Trend by Time
Account Activity Summary by Month
Trial Balance as of Date
Trial Balance Activity Summary
Trial Balance Comparative by Company
GL - All Detail, Accrual & Cash
Under Financial Queries, Balance Sheet:
Balance Sheet Detail for Date Range
Balance Sheet Activity Summary
Balance Sheet Activity Trend
Balance Sheet Balance Trend
Balance Sheet w/ Account_Hierarchy
Balance Sheet Comparative by Company
Balance Sheet Comparative w/ Account_Hierarchy
Balance Sheet Summary with Class Detail
Balance Sheet Summary with Class Across
Balance Sheet Current/Prior-Year Comparative
Under Financial Queries, Profit & Loss:
Profit & Loss Summary for Date Range
Profit & Loss Detail for Date Range
Profit & Loss Trend by Time
Profit & Loss Summary w/ Account_Hierarchy
Profit & Loss Comparative by Company
Profit & Loss Comparative w/ Account_Hierarchy
Profit & Loss Summary with Class Detail
Profit & Loss Summary with Class Across
Profit & Loss MTD/YTD Comparative
Profit & Loss Fiscal Month/Year/Prior
Under Financial Queries, Cash Flow:
Statement of Cash Flows
Cash Flow Expected by Week
Sales, Customers and Receivables Reports
On the Query screen under Sales Queries, Closed Sales:
Sales by Customer Summary
Sales by Customer Detail
Sales by Item Summary
Sales by Item Detail
Sales by Ship Address Summary
Sales by Ship Address Detail
Sales Detail for Date Range
Under Sales Queries, Trend Analysis:
Customer Sales Trend by Time
Item Sales Trend by Time
Sales Rep. Trend by Time
Under Sales Queries, Sales-Rep Queries:
Directory of All Sales Reps
Sales by Sales Rep. Summary
Sales by Sales Rep. Detail
Top Sales Reps by Revenue
Sales Commissions Summary
Sales Commissions Detail
Under Sales Queries, Pending Sales:
Pending Sales by Customer
Pending Sales by Item
Pending Sales by Sales Rep.
Pending Sales Detail for Date Range
Under Customer & Receivable Queries, AR & Invoices:
AR Aging Summary as of Date
AR Aging Summary, Showing Age Across
AR Aging Detail
Open Invoice Aging Summary
Open Invoice Detail
Open Invoice Detail by Item
Open Invoice Summary by Item
Under Financial Queries, Payment Analysis:
Invoice Days-To-Pay Summary
Invoice Payments Detail by Payment Date
Invoice Payments Detail by Invoice Date
Invoice Payments Summary by Payment Date
Invoice Payments Summary by Invoice Date
Invoice Payments Allocation (QBD)
Invoice Payments Allocation (QBO)
Under Financial Queries, Sales Tax Liability (QBO):
Sales Tax Owed from Sales
Sales Tax Owed by Month
Sales Tax Detail
Under Customer & Receivable Queries, Accounting & Performance Reports:
Top Customers by Revenue
Top Customers by Qty of Invoices
Balance Summary by Customer
Balance Summary by Job
Under Customer & Receivable Queries, Customer Directory:
Directory of All Customers/Jobs
Directory by State, City, Zip
Directory of New Customers as Of Date
Directory of Inactive Customers as Of Date
Purchases, Vendors and Payables Reports
On the Query screen under Purchases Queries, Completed Purchases:
Purchases by Vendor Summary
Purchases by Vendor Detail
Purchases by Item Summary
Purchases by Item Detail
Purchases by Customer Summary
Purchases by Customer Detail
Purchases by Ship-To Summary
Purchases by Ship-To Detail
Purchases PY/CY Comparative
strong>Under Purchases Queries, Purchase Orders:
Completed Purchase Order Summary
Completed Purchase Order Detail
Completed Purchase Order by Job Summary
Completed Purchase Order by Job Detail
Open Purchase Order Summary
Open Purchase Order Detail
Open Purchase Order Summary by Job
Open Purchase Order Detail by Job
Under Vendor & Payable Queries, AP Reports:
AP Summary by Vendor, as of Date
AP Summary by Item, as of Date
AP Detail by Item, as of Date
AP Aging Summary
AP Aging by Vendor
Bill & Credit Details
Bill & Credit Item Details
Balance Summary by Vendor
Under Vendor & Payable Queries, Trend Analysis
Vendor Payment Trends by Time
Under Financial Queries, Payment Analysis:
Bill Payments Detail by Payment Date
Bill Payments Detail by Bill Date
Bill Payments Summary by Payment Date
Bill Payments Summary by Bill Date
Bill Payments Allocation (QBD)
Bill Payments Allocation (QBO)
Under Vendor & Payable Queries, Vendor Directory:
Directory of All Vendors
Directory by State, City, Zip
Directory of New Vendors as of Date
Directory of Inactive Vendors as of Date
Jobs, Time Tracking, Employees & Payroll Reports
On the Query screen under Job & Time Reporting, Estimates:
Estimates by Customer
Estimates by Item
Estimates by Sales Rep.
Estimates Detail for Date Range
Estimates vs. Actuals Comparison Summary
Estimates vs. Actuals Detail by Item
Estimates vs. Actuals Summary w/ POs
Estimates vs. Actuals Detail w/ POs
Estimates vs. Actuals w/ POs, SOs
Under Job & Time Reporting, Profit & Loss:
Profit & Loss Summary by Job
Profit & Loss Detail by Job & Item
Under Job & Time Reporting, Time Tracking:
Time Worked by Job & Item
Time Worked by Employee Detail
Under Employee & Payroll Queries, Payroll:
Payroll Paycheck Detail
Payroll Vendor Payments Detail
Payroll Vendor Liability Adjustments
Under Employee & Payroll Queries, Employee Directory:
Directory of All Employees
Items and Inventory Reports
On the Query screen under Item & Inventory Queries, Inventory Items:
Inventory Acquisition & Disbursements by Item (FIFO)
Inventory Purchases & Sales by Item
Inventory Item Transaction Detail
Inventory Items in Stock (Calculated)
Inventory Item Ages (FIFO)
Inventory Item Ages Breakdown
Under Item & Inventory Queries, Inventory Sites & Lots:
Inventory Items by Site
Inventory Purchases & Sales by Lot
Inventory Acquisition & Disbursements by Lot (FIFO)
Inventory Lots in Stock (Calculated)
Inventory Lot Transaction Detail
Under Item & Inventory Queries, Accounting & Performance Reports:
Top Items by Revenue
Top Items by Margin
Top Items by Units
Top Items by Gross Profit
Under Item & Inventory Queries, Item Directory:
Directory of All Items
Directory of All Items w/ Price Levels
Directory of Items by Vendor
On-Hand Items by Valuation
On-Hand Items by Cost
On-Hand Items by Units
On the Query screen under Financial Queries, Budget Reports:
Profit & Loss Actual vs. Budget
P&L Actual vs. Budget by Class
P&L Actual vs. Budget, Month & YTD
P&L Actual by Month vs. Budget Total
Profit & Loss Actual THEN Budget
Budget Summary for Date Range
Budget Detail for Date Range
Budget Detail by Account & Class
General Information and Maintenance Reports
On the Query screen under System Information Queries:
Account Information
Posting Accounts Only
Class Information
Company Information
Currency Exchange Rates
Sales-Rep List
Transaction Date to Fiscal Period Mapping
User-Defined Budget Data
User-Defined Journal Entries
User-Defined Transaction Postings
Inventory Bought/Sold Allocations by Lot
On the Query screen under System Maintenance Queries:
Trial Balance Variance (QuickBooks Desktop)
Trial Balance Detail (QuickBooks Desktop)
QuickBooks Online Transaction List
QuickBooks Online Transaction Variances
QuickBooks Company Retrieve Status
Check for Invalid Item Setup
Balancing Adjustments
Transaction Custom Field Data
Alert Log
Specialty and Custom Reports
These are reports that have been written for specific customer requirements. Although not available as standard reports, if you need one of these or a similar report, it can be provided as a custom report ($250 discount on your first one).
In addition to single custom reports, complete reporting workbooks can be produced, with multiple categories of reports all tied to a common date range (such as end of month).
Financial Queries:
P&L Comparison with Quarters
P&L by Service Employee
Balance Sheet Current/Prior-Month/Year Comparative
Custom Cash Flow Calculations, Cash Flow with POs
Sales and Purchasing Reports:
AP Summary and Detail showing Paid Bills
Purchase Orders vs. Billed Amounts
Item & Inventory Queries:
Inventory Needed for [Sales] Orders
Inventory on [Purchase] Orders
Inventory Assembly Contents
Inventory Age Reports, Days in Stock
Job & Time Reports:
Work-In-Progress, Scheduled and Completed Status Reports
Employee Bonus Reports Calculated by Job
Sales-Rep Commissions Calculated by Job
Time & Expenses by Job
Budget Reports:
P&L Actual vs. Budget, Fiscal Week/Month/Year
P&L Actual vs. Budget, 3-Month Rolling
P&L Actual vs. Budget by Customer or Vendor
Balance Sheet Actual THEN Budget