🎥 Video Walkthrough
For a step-by-step guide, watch this video walkthrough of running a databook in Audit Sight:
🔍 Databook 101
🔗 For Connected Accounting Systems
When syncing data from a connected accounting system, Audit Sight typically retrieves 36 months of historical financial data. However, the exact timeframe may vary based on the specific accounting system. We recommend reviewing the relevant connection guide for detailed information on data availability.
📂 For Non-Connected Accounting Systems
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
Not all accounting systems provide AR and AP Aging reports. While Audit Sight can still retrieve the underlying details, it’s important to check the connection guide for each system to understand what data will be available.
📑 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: If using a connected accounting system, ensure the latest data is synced. If working with a non-connected system, upload the required financial reports from the general ledger.
-
📂 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?
The databook module fee is charged per connected accounting system or per legal entity. Users have unlimited refresh capabilities for up to 3 months from the initial request. Pricing can differ for small vs large accounting systems. Check your contract for more information.
🔗 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?
After the initial connection, you can refresh the databook for a 3-month period for free.
🔁 How does refreshing work for connected systems ?
For connected accounting systems, data can be refreshed as long as the client or your team does not delete the connection. For QuickBooks Desktop, a new backup file must be uploaded each time to refresh the data.
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! 🚀
