Data Review Services for QuickBooks® Users
Find the Problems Before They Become Bigger Problems
If your QuickBooks® accounting records don't look right, but you're not sure what's causing the problem, a Data Review can be a smart first step.
QuickTrainer reviews your QuickBooks® data to help identify unusual account balances, reconciliation discrepancies, duplicate transactions, misclassified entries, old receivables or payables, and other accounting inconsistencies that may affect the accuracy of your financial information.
A QuickBooks® Data Review is designed to help answer an important question:
What is going on inside my QuickBooks® file, and what needs attention?
When a Data Review Makes Sense
You may benefit from a QuickBooks® Data Review when:
Your Profit and Loss report doesn't look right Your Balance Sheet contains balances you don't understand Bank or credit card accounts won't reconcile Accounts Receivable contains old or incorrect balances Accounts Payable contains bills that should no longer be outstanding Income or expenses appear to be duplicated Undeposited Funds has an unexpected balance Clearing accounts are not clearing properly You suspect transactions have been categorized incorrectly You've recently taken over the bookkeeping from someone else You're preparing for tax time or year-end You're considering a QuickBooks® Cleanup but don't yet know the extent of the problems
Sometimes the first step isn't immediately changing transactions.
The first step is understanding what happened, why it happened, and what needs to be corrected.
Data Review Pricing and Time Required
QuickTrainer's QuickBooks® Data Review Services are billed at $150 per hour, with a one-hour minimum.
Most Data Reviews take approximately one to two hours, depending on the size, condition, and complexity of your QuickBooks® file. A typical review therefore costs between $150 and $300.
If additional time is ...
What We Review
Every business uses QuickBooks® differently, so our Data Review is tailored to your accounting file, business needs, and daily workflows.
Depending on your situation, we may review areas such as:
Bank and credit card accounts Bank and credit card reconciliations Balance Sheet accounts Profit and Loss activity Accounts Receivable Accounts Payable Undeposited Funds Clearing accounts Bank Transactions Duplicate transactions Uncategorized or misclassified transactions Chart of Accounts Customer and vendor balances Transactions affecting prior accounting periods
Our goal is to identify accounting problems, unusual balances, and transactions that may require additional investigation, correction, or cleanup.
Reconciliations
Reconciliations are one of the first areas we may examine when reviewing a QuickBooks® accounting file.
During a Data Review, we may look for:
Bank accounts that have not been reconciled regularly Credit card accounts that have not been reconciled Beginning balances that do not agree with prior reconciliations Previously reconciled transactions that have been changed or deleted Old unreconciled transactions that remain in the account Duplicate transactions causing reconciliation discrepancies Reconciliation adjustments that may require further investigation Differences between QuickBooks® account balances and financial institution records
A reconciliation problem is often a symptom of a larger accounting issue elsewhere in the file.
Identifying these discrepancies can help determine whether additional investigation or corrective work is necessary.
Balance Sheet and Profit & Loss Review
Your financial statements can reveal a great deal about the condition and accuracy of your QuickBooks® accounting data.
During a Data Review, QuickTrainer examines your Balance Sheet and Profit and Loss reports for balances or activity that may require additional attention.
This may include:
Negative asset balances that require explanation Unusual liability balances Old or uncleared balances in clearing accounts Unexpected loan balances Income recorded in incorrect accounts Expenses recorded inconsistently Large or unusual changes from one accounting period to another Account balances that appear unreasonable or inconsistent with business activity Transactions posted to accounts that are rarely used
The goal is not simply to look at the numbers.
We want to determine whether the numbers make sense.
Accounts Receivable and Accounts Payable
Old customer and vendor balances can remain in QuickBooks® for years if Accounts Receivable and Accounts Payable are not reviewed periodically.
During a Data Review, we may examine:
Accounts Receivable
Old unpaid customer invoices Unapplied customer credits Unapplied customer payments Duplicate invoices Customer payments applied incorrectly Negative customer balances Invoices showing outstanding balances that may already have been collected
Accounts Payable
Old unpaid vendor bills Unapplied vendor credits Duplicate bills Bills that may already have been paid Negative vendor balances Bill payments that may have been entered or applied incorrectly
Reviewing Accounts Receivable and Accounts Payable can help identify inaccurate balances, duplicate transactions, and other issues that may be affecting your financial reports.
Once these issues are identified, QuickTrainer can recommend appropriate next steps, including QuickBooks® Cleanup Services when corrections are necessary.
Bank Transactions and Duplicate Activity
The Bank Transactions area in QuickBooks® Online can save time, but it can also lead to duplicate or incorrectly categorized transactions when not managed properly.
During a Data Review, QuickTrainer may look for:
Downloaded transactions that were added instead of matched to existing transactions Duplicate income transactions Duplicate expense transactions Bank Rules that incorrectly categorize transactions Bank transfers incorrectly recorded as expenses Credit card payments recorded or categorized incorrectly Bank deposits added separately from transactions already recorded in QuickBooks® Transactions assigned to incorrect general ledger (G/L) accounts
Automation can save time, but proper accounting oversight is still essential.
Identifying these issues can help explain why account balances, reconciliations, or financial reports may not be accurate.
Bank Rules in QuickBooks® Online: What to Do and What to Avoid
Undeposited Funds and Clearing Accounts
Undeposited Funds and clearing accounts can reveal important clues about the accuracy of your QuickBooks® accounting records.
When these accounts contain old or unexpected balances, additional investigation may be necessary to determine whether transactions have been recorded properly.
During a Data Review, QuickTrainer may examine:
Old customer payments remaining in Undeposited Funds Bank deposits that may have been recorded more than once Customer payments that were never included in a recorded deposit Clearing accounts with balances that have not cleared as expected Third-party payment processor transactions that have not cleared properly Payroll and merchant service clearing account balances Transactions that may have been posted to incorrect general ledger accounts
Unexpected balances in these accounts can provide valuable clues about duplicate transactions, missing deposits, incorrect account assignments, or other accounting problems.
Our goal is to identify the cause of these balances and recommend appropriate next steps when corrections are necessary.
What You Receive After the Review
A QuickBooks® Data Review is more than simply identifying accounting errors.
Our goal is to help you understand what we found, why certain issues may be occurring, and what should happen next.
After completing your Data Review, QuickTrainer provides a written summary of our findings and recommendations, delivered by email.
We also schedule a follow-up conversation to discuss the findings, answer your questions, and determine who will be responsible for any recommended corrective work.
Depending on what we discover, our findings may include:
Areas that appear to be working correctly Transactions or balances requiring further investigation Accounting issues that should be corrected Reconciliation discrepancies Potential duplicate transactions Workflow problems that may be creating recurring errors Areas that may require cleanup Recommendations for improving your bookkeeping procedures
Our goal is to help you understand why something is a problem—not simply tell you that it is wrong.
What Happens Next?
If the review identifies accounting problems requiring corrections, QuickTrainer can discuss whether separate QuickBooks® Cleanup Services are appropriate.
If the review reveals workflow issues rather than significant accounting problems, One-on-One Training for QuickBooks® Users may be the best next step to help you use the software more accurately and confidently.
If your business would benefit from ongoing assistance, QuickTrainer also offers Bookkeeping Services for QuickBooks® Users to help maintain accurate and consistent records going forward.
Data Review for QuickBooks® Online and Desktop
QuickTrainer provides Data Review Services for businesses using both QuickBooks® Online and QuickBooks® Desktop.
Whether you use QuickBooks® Online or Desktop, our goal is to help identify accounting problems that may be affecting the accuracy of your financial records.
The review is customized based on the version of QuickBooks® you use, how your business operates, and your specific accounting concerns.
Depending on your software and the issues involved, we may examine reconciliation history, account balances, transaction activity, financial reports, and other areas that require attention.
Our focus is on helping you understand what needs attention and recommending appropriate next steps.
Data Review Before Cleanup
A Data Review can be especially helpful before beginning QuickBooks® Cleanup Services.
Although these services are closely related, they serve different purposes:
Data Review: Diagnose accounting problems, assess the condition of your QuickBooks® file, explain the findings, and recommend appropriate next steps.
QuickBooks® Cleanup: Correct identified accounting problems, repair inaccurate balances, and resolve transaction or reconciliation issues.
A Data Review helps us understand the condition of your accounting file before determining what cleanup work may be necessary.
Sometimes the problems are relatively minor and require only a few corrections. Other times, several areas of the accounting file may need attention.
Not sure whether you need Cleanup Services?
Before investing time and money in a cleanup project, QuickTrainer can review your accounting data to help identify what actually needs attention.
Starting with a Data Review can help establish a clearer plan for correcting problems, prioritizing the work, and determining the next steps.
Any corrective work is discussed and authorized separately before billable Cleanup Services begin.
