๐Books Review
The Books Review feature in Client Hub allows firms to efficiently review and resolve common QuickBooks data issues โ all within the Client Hub platform. This tool helps streamline monthly close processes and improves data accuracy without switching between systems.
โ๏ธ How It Works
Books Review is automatically enabled for any Client Workspace thatโs connected to QuickBooks.
You can access Books Review in the Firm-only section of the Clients & Workspaces page. This section is visible only to firm users.
All tools in Client Hub, including Books Review, share a consistent look and feel โ with the same column order and button layout. This makes it easier to navigate and perform reviews across different tools without relearning the interface.
๐ฌ Collaborate with Comments
Each Books Review item includes a Comments option under Actions. Use this to add internal notes or collaborate with your team while working through review items.
๐ What Books Review Helps You Catch
The current version reviews the following data points:
Expense Inconsistencies
Flags expenses that are categorized differently than the majority of transactions for that vendor over the past 12 months.
Purchases Without Payee
Identifies expense transactions missing a vendor/payee.
Purchases in a Parent Account
Highlights transactions posted to a parent account instead of a sub-account.
Large Transactions
Detects expense transactions over a threshold you set. Use the Set Large Transaction Limit option in Books Review to adjust the threshold to match your review needs.
Transactions Without Attachments
Lists expense transactions in QuickBooks without supporting documents attached, with the option to create a Client Task to assign to the client to add the attachment.
New Accounts
Surfaces recently created accounts to help you monitor and confirm whether they were set up correctly.
New Vendors
Shows newly added vendors, making it easier to review for duplicates or incorrect entries.
New Customers
Displays recently created customers, allowing you to confirm accuracy and avoid duplicates.
๐ Balance Sheet Review (AI Analysis)
AI compares the balance sheet to the previous period and highlights accounts that may require review based on changes in balances or activity patterns.
When you click Run AI Analysis, the system evaluates balance sheet accounts against the prior period and visually surfaces accounts that may need verification.
What the Shaded Rows Mean
-
Orange-shaded rows indicate accounts flagged by AI due to unusual or unexpected balance changes compared to the previous period. These may include large dollar movements, significant percentage changes, or balances that deviate from historical patterns.
Once reviewed, these rows can be cleared using the Mark as Reviewed option in the Actions column.
- Green-shaded rows are surfaced by AI Analysis when an account shows activity in the current period but had no amount in the prior period. This may be expected, or it may indicate new, miscategorized, or unintended activity. Green rows prompt the reviewer to verify that the current-period activity is accurate.
Green-shaded rows do not have their own review status. The review action applies only to orange-shaded rows.
Rows without shading were not highlighted by the AI and are shown for reference.
Viewing Transaction Details
All rows โ orange, green, and unshaded โ can be clicked to expand and view detailed transaction activity for the selected account.
From the expanded transaction view, you can select View in QuickBooks to open the transaction directly in QuickBooks, as long as the QuickBooks file is already open and logged in within another browser tab.
๐ Profit and Loss Review (AI Analysis)
AI compares the profit and loss statement to the previous period and highlights accounts with changes or activity patterns that may need review.
This analysis helps surface income, cost of goods sold, and expense accounts that could impact profitability or signal potential data issues.
What the Shaded Rows Mean
-
Orange-shaded rows highlight accounts flagged by AI due to unexpected or significant changes from the prior period. These may include sudden increases or decreases or activity that differs materially from previous trends.
After reviewing the activity, these rows can be marked as reviewed using the Mark as Reviewed option in the Actions column.
- Green-shaded rows are surfaced when an account has current-period activity but no amount in the prior period. These rows highlight newly active or resumed accounts so the reviewer can confirm that the activity is appropriate and correctly categorized.
Green-shaded rows support the review process but do not have a separate review status.
Accounts without shading were not flagged by the AI and do not require review.
Viewing Transaction Details
You can click any row โ shaded or unshaded โ to expand and review the transactions that make up the account activity.
Each transaction includes a View in QuickBooks option, allowing you to jump directly to the source transaction in QuickBooks when the file is open and logged in in another tab.
๐ Connect Clients to QuickBooks
If a client isnโt yet connected to QuickBooks, follow these steps:
- Go to Settings > Client Hub > QuickBooks Integration
- Follow the prompts to connect the Client Workspace to QuickBooks