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.
Additional FAQs
Does the solution generate a unique, sharable URL for data connections?
Use the QuickBooks Online connection guide to request accounting data. For file uploads, send the relevant upload instructions to your client.
Is there a way to group various Income statement accounts outside of the Net Sales, COGS, Opex, etc. groupings? For example, if I wanted to combine two income accounts that the seller labels one as commission income, and the other as premium income, but I want both to just be commission income in net sales and then another mapping for one account labeled bonus income in net sales.
We’re happy to work with your team to build out additional grouping options for your deals' financial statements. This is a great approach to accommodate the common categories you encounter across deals.
If your team has any adjustments or proposed additions, our algorithm will learn and adapt to your mapping needs over time (based on key words and groupings). This means you won’t have to re-do the mapping again and again going forward for the same client & deal types.
When we rename the accounts in the dashboard, is there an easy way to revert that decision and go back to the original name that the target firm provided?
We don’t currently offer an “undo” button to revert to the original account names provided by the target firm. The best workaround is to re-ingest the data using the original upload documentation to restore the target-provided names.
The default data pull is 3-years + TTM. Is it possible to adjust the period to 5-years?
At this point no - our current module only supports 3. We can look to build this out in the future.
Does the standard Data Book provide separate cash-basis and accrual-basis outputs?
This standard Data Book workflow does not provide separate cash-basis and accrual-basis outputs.
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.
Can we provide accounting data without banking data?
Yes. Provide accounting data through QuickBooks Online, a QuickBooks Desktop backup (.QBB) upload, or supported exports. Upload banking data separately when required for Cash Proof or another workpaper; it is not part of the accounting connection.
If we change the chart of accounts (GL mappings) for specific accounts in the target’s ledger - is there functionality to track what is changed and benchmark this against the target’s mappings (so that we can see and track what was changed)?
Audit Sight automatically maps the target’s chart of accounts based on the GL account names & descriptions. You can change any mapping designation prior to generating your data book in Audit Sight. However we do not offer functionality to track what was changed in your mapping vs. the target (client’s) original GL mappings.
On the Chart of Accounts Tab you can see both the Fully Qualified Category (i.e. what the accounting system says) and the category used in the accounting system after running the data book