Skip to content

FinJinni

QuickBooks Custom Reporting, Consolidation and Automation

  • Our Products
    • FinJinni Professional
    • FinJinni Importer
    • FinJinni SAAS
    • FinJinni for Reckon
  • Pricing
  • Support
    • Support Policy
    • Knowledge Base
  • Store
  • Use Cases
    • Reporting
    • Budgets
    • Business-Critical Reports
    • Articles
      • Keep Your QuickBooks Data Accessible
      • Consolidated Reporting
      • Month End Report Automation
      • Custom Inventory Reports
      • Automating Commissions
      • Integrate Power BI with QuickBooks
      • Restaurant and Retail – 4-4-5 or 13×4
      • 10 Ways QuickBooks Users Can Benefit From AI
  • Free Trial
  • Get Demo
  • 0

Welcome to FinJinni Support

  • Support
Other Support Options:   Support Policy   |   Contact Us

FAQ

7
  • Getting Started
  • Security
  • Support and Assistance
  • Compatibility
  • Features
  • Reporting
View all 7 articles

Getting Started

9
  • Before You Begin
  • Quick Start Guide
  • Installation
  • Trial Version
  • First Time Setup
  • First Time Setup QuickBooks Online
View all 9 articles

Using FinJinni

3
  • Using FinJinni Professional
  • Running Queries and Creating Reports
  • Using Other Applications with the FinJinni Database
View all 3 articles

QuickBooks Company Setup

11
  • QuickBooks Company Setup
  • Cash Reporting Settings
  • Advanced Inventory Settings
  • Using Custom Fiscal Years
  • Budget Reporting for QuickBooks Desktop
  • Advanced Loading Options
View all 11 articles

Advanced Data Loading Features

13
  • Loading Budget Data From Outside QuickBooks
  • Loading Journal Entries From Outside QuickBooks
  • Loading Other Transactions From Outside QuickBooks
  • Adding Customers and Vendors to QuickBooks
  • Loading Data into User-Defined Tables
  • Automatically Loading Custom Data Files
View all 13 articles

SQL Server Topics for Advanced Users

7
  • Using Custom SQL Logins
  • Using FinJinni to Manage Your Databases
  • Installing and Configuring SQL Server Express
  • Using Azure SQL Databases
View all 7 articles

Building Queries

11
  • Building Queries
  • Date Range
  • Choosing Query Fields
  • Custom Fields
  • Account, Class and List Filters
  • The Transaction Filter
View all 11 articles

Features

7
  • Saving Your Query for Later Reuse
  • Writing Output to SQL or a File
  • Building Consolidated/Comparative Queries
  • Using Drill-Down to Show Details
  • Creating Formatted Reports
  • Customizing Query Styles
View all 7 articles

FinJinni Validation and Cash/Expense Reporting

4
  • FinJinni and QuickBooks Trial Balance Comparison
  • FinJinni and QuickBooks Online Validation
  • FinJinni and QuickBooks Desktop Cash Reporting
  • FinJinni and QuickBooks Desktop Reimbursed Expenses
View all 4 articles

Advanced Topics

4
  • Custom Query Fields (Calculated Fields)
  • Running Queries Automatically
  • Excel Extension Functions for SQL Access
  • Using Consolidation With A QuickBooks Condensed File
View all 4 articles

References

2
  • FinJinni Data Tables and Views
  • FinJinni Report Columns
View all 2 articles

What's new in FinJinni

1
  • Change Log
View 1 article
  • FAQ
    • Getting Started
    • Security
    • Support and Assistance
    • Compatibility
    • Features
    • Reporting
    • Troubleshooting
  • Getting Started
    • Right Network Users
      • Starting with Right Networks
      • Add the Excel Add-in while using Right Networks
    • Before You Begin
    • Quick Start Guide
    • Installation
    • Trial Version
    • First Time Setup
    • First Time Setup QuickBooks Online
    • Licensing FinJinni
  • Using FinJinni
    • Using FinJinni Professional
    • Running Queries and Creating Reports
    • Using Other Applications with the FinJinni Database
  • QuickBooks Company Setup
    • QuickBooks Company Setup
    • Cash Reporting Settings
    • Advanced Inventory Settings
    • Using Custom Fiscal Years
    • Budget Reporting for QuickBooks Desktop
    • Advanced Loading Options
    • Consolidating Multiple Companies
    • Using Multiple Currencies
    • Scheduling a Data Sync
    • Sending Email Event Notifications
    • FinJinni Reporting on QuickBooks Reimbursed Expenses
  • Advanced Data Loading Features
    • Extending the QuickBooks Data Model with Custom Fields
      • Extending the QuickBooks Data Model with Custom Fields
      • Customizing the Chart of Account
      • Adding Custom Fields to Classes
      • Adding Additional Custom Fields to Items and Entities
      • Adding Custom Fields to Companies
      • Using the Upload Function in Excel
      • Consolidated/Combined Format for Uploading Custom Fields
    • Loading Budget Data From Outside QuickBooks
    • Loading Journal Entries From Outside QuickBooks
    • Loading Other Transactions From Outside QuickBooks
    • Adding Customers and Vendors to QuickBooks
    • Loading Data into User-Defined Tables
    • Automatically Loading Custom Data Files
  • SQL Server Topics for Advanced Users
    • Installing and Configuring SQL Server Express
      • Automatic Install of SQL Server Express
      • Setting Up Shared Access for SQL Server Express; Multi-User Access
      • Migrating FinJinni from old system to new system
    • Using Azure SQL Databases
      • Setting Up Azure in FinJinni
      • QuickBooks Load Performance with an Azure Database
    • Using Custom SQL Logins
    • Using FinJinni to Manage Your Databases
  • Building Queries
    • Building Queries
    • Date Range
    • Choosing Query Fields
    • Custom Fields
    • Account, Class and List Filters
    • The Transaction Filter
    • Custom Filters
    • Zero-Row Suppression
    • Showing Net Values on Budgets
    • Using Multiple Currencies
    • Output Choices
  • Features
    • Saving Your Query for Later Reuse
    • Writing Output to SQL or a File
    • Building Consolidated/Comparative Queries
    • Using Drill-Down to Show Details
    • Creating Formatted Reports
    • Customizing Query Styles
    • Other Functions on the Excel Ribbon Bar
  • FinJinni Validation and Cash/Expense Reporting
    • FinJinni and QuickBooks Trial Balance Comparison
    • FinJinni and QuickBooks Online Validation
    • FinJinni and QuickBooks Desktop Cash Reporting
    • FinJinni and QuickBooks Desktop Reimbursed Expenses
  • Advanced Topics
    • Custom Query Fields (Calculated Fields)
    • Running Queries Automatically
    • Excel Extension Functions for SQL Access
    • Using Consolidation With A QuickBooks Condensed File
  • References
    • FinJinni Data Tables and Views
    • FinJinni Report Columns
  • What's new in FinJinni
    • Change Log

Contact Us

sales@gypsybi.com

support@gypsybi.com

About Us

Useful Links

Privacy Policy

Articles

EULA

 

FinJinni® is a trademark of Gypsy BI LLC. © 2018-2025 Gypsy BI LLC. All Rights Reserved

Your cart

Cleantalk Pixel