The FinJinni consolidation feature can be used to provide contiguous reporting after a QuickBooks desktop
company file has been “condensed”, which is how QuickBooks reduces the size of a file by eliminating past
transactions.

FinJinni has two settings for loading a company file that come into play here – the first is the “Stop Loading
at End of Year” setting under “Advanced Options” on the company setup screen. This is used with the file
before condensing to load all historical data up to a specified end year. Suppose for example that a condense
operation is planned to remove all transactions before 1/1/2021. Then the End Year in FinJinni would be
set to 2020. A data load will be done using the name for “COMPANY-1” to load all data up to and
including 12/31/2020. (Replace COMPANY-1 with a name you assign to your company.)

The next setting is the “Starting Year For Load” setting on the company setup screen. This is used to load
all data from the newly condensed file starting at the first retained year, in this example, 2021. A data load
will be done using the name for “COMPANY-2” to load all data starting at 1/1/2021.. (Replace
COMPANY-2 with a second name you assign to the new company file.)

Now, when you create reports, you can use the consolidated companies to produce contiguous reports. You
will have all transactions up to 12/31/2020 from the first company file and all transactions from 1/1/2021
on from the second. FinJinni automatically consolidates these for reporting.

There are a few special considerations:

The Balance Sheet on 12/31/2020
At the one date of 12/31/2020, each company will have a balance sheet. For the second company, starting
balances will be loaded on this date. This will duplicate the balance sheet numbers if you choose both companies
on a balance sheet report. It is best to choose the first company only from FinJinni’s company-selection
drop-down on the query screen.
If you need to choose both companies on a balance sheet report, for example, a trend report, use a custom
filter to eliminate the second copy of the balance sheet on this date:
company_id <> ‘COMPANY-2’ OR trans_date <> ‘2020-12-31’

Cash-Basis Reporting in 2021
Due to the way that QuickBooks handles cash-basis reporting, transactions from 2020 and 2021 can be
“linked”. E.g. if a Bill from 2020 is paid in 2021. In some cases QuickBooks will not remove these properly
from the condensed file or will use a journal entry to adjust the numbers.
If you are using cash-basis reporting for these years, you should examine the P&L and Balance Sheet from
QuickBooks to see if any adjustments are needed. FinJinni can import adjustments as journal entries that
only appear on cash reports. Refer to the FinJinni Professional Administration Guide for more information
about importing journal entry transactions.