Which Data Book does this article cover? This article covers the standard Data Book under Connected Modules. To populate your firm’s configured Excel template in TAS OS, see Generating and Using Your Firm Data Book.
Pricing and refresh terms: Your firm’s order form governs included products, usage, refresh terms, conversion fees, and additional services.
General FAQs
Do you have the capability to provide white label (branding) with your data book links & functionalities in our firm-specific software for tracking & processing deals (i.e., integration with Smartsheet)?
This standard Data Book workflow does not provide white-label embedding in a third-party deal-tracking tool such as Smartsheet. To populate your firm’s own Excel template, use Firm Databook in TAS OS after template configuration. See the Firm Data Book guide linked above.
How long does a QuickBooks Online connection last?
QuickBooks Online access depends on an active authorization. Check the connection status and reconnect when required. QuickBooks Desktop and other uploaded data require new files to refresh.
When a QuickBooks Online connection is disconnected - are we (the firm), our target, and Audit Sight all notified automatically?
Check the QuickBooks Online connection status in Audit Sight rather than relying on an email notification. If the connection is disconnected, the authorized user must reconnect before data can be refreshed.
When a QuickBooks Online connection is disconnected - are we charged again for reconnecting to QuickBooks Online?
Your firm’s agreement defines included products, usage, refresh terms, and any conversion or additional service fees. Contact your Audit Sight representative to confirm the terms for your firm.
How are we charged each time we refresh a data book on an existing target where we already have an active QuickBooks Online connection?
Your firm’s agreement defines included products, usage, refresh terms, and any conversion or additional service fees. Contact your Audit Sight representative to confirm the terms for your firm.
If we reconnect a disconnected QuickBooks Online connection - but decide not to run a Data Book because the deal is terminated - are we charged?
Your firm’s agreement defines included products, usage, refresh terms, and any conversion or additional service fees. Contact your Audit Sight representative to confirm the terms for your firm.
What do the notifications look like for the target when an active API connection and data pull is made?
QuickBooks Online is the supported direct accounting connection. Follow the QuickBooks Online guide and check the connection and sync status in Audit Sight to confirm authorization and data availability.
What aspects (if any) of Audit Sight’s Data Book are available if we do not connect via an API?
You can still generate a P&L statement, Balance Sheet, EBITDA summary, Chart of Accounts, Journal Entry detail, and Trial Balance if you generate a non-connected data book (by uploading only the target’s downloaded TBs and JE detail to Audit Sight).
If we run a multi-year (more than a TTM) P&L in the data book - are totals per year included in the analysis (Excel summary of the Data Book) so that we can easily build our pro-forma summaries?
No totals per year are provided - just a grand total for the period generated.
Can we run full Audit Sight Data Book functionality with a QBD (Quick Books Desktop) file back up - rather than connect via API?
Yes. Upload the QuickBooks Desktop backup (.QBB) and provide the required Admin credentials through the upload workflow. An additional conversion fee applies; refer to your contract. A new backup is required for refreshed data.
Is there a use case for your cash proofs and data books post deal - to assess if the target (client) is appropriately accounting for transactions & cash in its ledger - and to also assess whether there is misappropriation of cash in the business?
Yes - absolutely! Run a cash proof and/or data book at any point after your deal is closed to quickly and easily assess if there are inaccuracies in accounting/data reconciliation with banking cash flows in the business.
Does your solution consolidate accounts (many entities on one target deal) for multiple entities?
Yes - we do not automate or generate the elimination entries - but we do consolidate the entities in the data book output.
Can you specify what data is available in the data book if we use a non-connected system?
It depends on what data is available in the ERP (Quickbooks vs others) and if vendor details, customers, etc. are retained in the ledger.
Is our custom account mapping saved between data syncs across the deal cycle?
Yes - our algorithm is built to “learn” your account mapping designations so that the chart of accounts are consistent between deals based on client type and industry.
If we re-run a data book outside of the period (90 days) - but on the same data - is it an additional charge for the cash proof?
Your firm’s agreement defines included products, usage, refresh terms, and any conversion or additional service fees. Contact your Audit Sight representative to confirm the terms for your firm.
Does cash vs. accrual basis create separate data book outputs?
No. Separate cash-basis and accrual-basis outputs are not provided by this Data Book workflow.