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.
Current data methods: QuickBooks Online direct connection, QuickBooks Desktop backup (.QBB) uploads, and accounting exports.
Video Walkthrough
For a step-by-step guide, watch this video walkthrough of running a databook in Audit Sight:
Databook 101
For QuickBooks Online Connections
QuickBooks Online is the supported direct accounting connection. Audit Sight typically retrieves 36 months of historical financial data; confirm the available period before generating the databook.
For Uploaded Accounting Data
If your accounting system is not directly connected, Audit Sight generates the databook by pulling financial reports from the uploaded general ledger.
Important Notice About AR and AP Agings
AR and AP aging availability depends on the accounting data supplied. Review the QuickBooks Online or QuickBooks Desktop upload guide, or confirm that the required supporting data is included in your exports.
Databook Report Sections and Inclusions
The databook is structured into four key sections:
1. Accounting Reports and Underlying Data
| Report Name | Description |
|---|---|
| ๐ Profit and Loss | Monthly earnings for the company |
| ๐ฐ EBITDA | Calculation of earnings before interest, taxes, depreciation, and amortization |
| ๐ Balance Sheet | A statement of the assets, liabilities, and equity at a specific point in time |
| ๐ Trial Balance | Financial report listing closing balances of all general ledger accounts |
| โ๏ธ Journal Entries | All journal entries recorded for the period. This is also known as the transaction report or general ledger |
2. Revenue and Receivables
| Report Name | Description |
| ๐ฅ Customers | Listing of customer information and related contacts |
| ๐งพ Invoices | Listing of individual invoices issued |
| ๐ณ Payments | Listing of payments made by customers and their related invoices |
| ๐ Credit Notes | Listing of credits issued to customers |
| ๐ AR Aging by Customer | Breakdown of accounts receivable aging by customer |
| ๐ AR Aging Totals | Summary of AR aging totals |
3. Expenses and Payables
| Report Name | Description |
| ๐ข Vendors | Listing of vendor information and related contacts |
| ๐ Bills | Listing of bills received |
| ๐ต Bill Payments | Listing of payments made to vendors and their related bills |
| โณ AP Aging by Vendor | Breakdown of accounts payable aging by vendor |
| ๐ AP Aging Totals | Summary of AP aging totals |
4. Banking Information
| Report Name | Description |
| ๐ Bank Transaction Listing | Detailed listing of banking transactions by account and by day |
How to Generate and Review a Databook
- Sync Data or Upload Reports: Sync the QuickBooks Online connection, upload a current QuickBooks Desktop backup, or provide the required accounting exports. Upload banking data separately when needed.
- ๐ Navigate to the Databook Module: Access the databook within Audit Sightโs interface.
- ๐ Select the Reporting Period: Choose the time frame you need to analyze (e.g., last 12 months, last 36 months).
- ๐ค Download and Share: Check your inbox for a link to download the databook.
Frequently Asked Questions (FAQ)
How is the databook module priced?
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 if my accounting system is not supported?
If your accounting system is not directly connected, you can manually upload financial reports from your general ledger, and Audit Sight will generate a databook based on that data. The databook will be limited to the Accounting Reports.
Can I refresh the databook?
Yes. Provide updated accounting data, confirm the period, and request an updated Data Book. Your firmโs agreement defines refresh charges and included usage.
How does refreshing work for connected systems ?
QuickBooks Online data can be refreshed while its authorization remains active. For QuickBooks Desktop, upload a new backup (.QBB). For other systems, provide updated exports. Banking data must be refreshed through uploads.
By leveraging the databook, auditors and analysts can efficiently ๐ compile financial insights, ๐ identify trends, and โก streamline workflows. If you have questions about specific accounting system connections, refer to our Integration Guides for additional details! ๐