QuickBooks Consolidation

By adminUncategorized

FinJinni solves the problem of consolidated reporting in QuickBooks by exporting all your QuickBooks companies’ data to a common database. Below we will show you how FinJinni creates consolidated reports.

Consolidating Multiple Company Files:

Open the Excel add-in and press the “Query” button. This will open the query builder screen.

Choose the report you want from the template menu on the left. Then move to the center to choose your date. Below that you can choose which companies you want to report on from the drop down menu.

  • There is no limit to the number of company files you can consolidate.
  • You can map your companies to a common chart of accounts.
  • FinJinni can consolidate data from QuickBooks Desktop, Online and both together.

Consolidating Multiple Currencies:

You must enable multi-currency reporting in FinJinni before you load data from your company files. There is a check box on the setup screen for this option. Then use the setting option to choose which exchange rate will be used.

  • If you are consolidating results from multiple companies, all currency values reported will be converted to the currency that you select for the report, even if each company uses a different home currency.
  • You can select the currency to be used in each Query separately

Combine Data From Multiple Sources:

FinJinni can combine data from multiple sources both inside and outside of QuickBooks. Click here to see samples of Consolidated Financial and Trends. Contact us with your custom reporting needs. sales@gypsybi.com