If your accounting records do not look quite right but you are not sure what the problem is, a Data Review can be a smart first step.

QuickTrainer reviews your QuickBooks® data to help identify unusual balances, reconciliation problems, duplicate transactions, misclassified entries, old receivables or payables, and other accounting inconsistencies that may be affecting the accuracy of your financial information.

A Data Review is designed to help answer an important question:

What is going on inside my QuickBooks® file, and what needs attention?

Request a Data Review

You may benefit from a Data Review when:

• Your Profit & Loss does not look right

• Your Balance Sheet contains balances you do not understand

• Bank or credit card accounts will not 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 recently took over the bookkeeping from someone else

• You are preparing for tax time or year-end

• You are considering a QuickBooks® Cleanup but do not yet know the extent of the problems

Sometimes the first step is not immediately changing transactions.

The first step is understanding what happened, why it happened, and what needs to be corrected.

Every business uses QuickBooks® differently, so our Data Review is tailored to your file and your accounting workflow.

Depending on your situation, we may review areas such as:

• Bank and credit card accounts

• Reconciliations

• Balance Sheet accounts

• Profit & Loss activity

• Accounts Receivable

• Accounts Payable

• Undeposited Funds

• Clearing accounts

• Bank Transactions

• Duplicate transactions

• Uncategorized or misclassified activity

• Chart of Accounts

• Customer and vendor balances

• Transactions affecting prior accounting periods

The goal is to identify areas that may need additional investigation, correction, or cleanup.

Reconciliations are one of the first places we may look when reviewing a QuickBooks® file.

We may review whether:

• Bank accounts have been reconciled regularly

• Credit card accounts have been reconciled

• Beginning balances agree with prior reconciliations

• Previously reconciled transactions have been changed or deleted

• Old unreconciled transactions remain in the account

• Duplicate transactions are causing reconciliation differences

• Reconciliation adjustments have been used

• The QuickBooks® balance agrees with the actual financial institution balance

A reconciliation problem is often a symptom of a larger issue somewhere else in the file.

Your financial statements can reveal a great deal about the condition of your QuickBooks® data.

We review your Balance Sheet and Profit & Loss for balances or activity that may deserve additional attention.

This might include:

• Negative asset balances

• Unusual liability balances

• Old clearing account balances

• Unexpected loan balances

• Income posted to the wrong accounts

• Expenses posted inconsistently

• Large or unusual changes from one period to another

• Accounts with balances that do not appear reasonable

• 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.

Old customer and vendor balances can remain inside QuickBooks® for years if they are not reviewed periodically.

We may examine:

Accounts Receivable

• Old unpaid invoices

• Customer credits

• Unapplied customer payments

• Duplicate invoices

• Payments applied incorrectly

• Negative customer balances

• Amounts that may already have been collected

Accounts Payable

• Old unpaid bills

• Vendor credits

• Duplicate bills

• Bills that may already have been paid

• Negative vendor balances

• Payments that may have been entered incorrectly

Cleaning up Accounts Receivable and Accounts Payable can make your financial reports much easier to understand.

The Bank Transactions area in QuickBooks® Online can save time, but it can also create duplicate or incorrectly categorized transactions when it is not used properly.

We may look for:

• Transactions that were Added when they should have been Matched

• Duplicate income

• Duplicate expenses

• Incorrect Bank Rules

• Transfers categorized as expenses

• Credit card payments recorded incorrectly

• Deposits added separately from existing QuickBooks® transactions

• Transactions assigned to the wrong G/L account

Automation is useful, but transactions still need accounting oversight.

Undeposited Funds and Clearing Accounts

Undeposited Funds and clearing accounts are designed to hold transactions temporarily.

When they contain old balances, there is usually something that needs to be investigated.

We may review:

• Old customer payments remaining in Undeposited Funds

• Deposits that were recorded twice

• Payments that were never included in a deposit

• Clearing accounts that are not returning to zero

• Third-party payment activity that has not cleared properly

• Payroll or merchant service clearing balances

• Transactions that may have been posted to the wrong account

These balances can often provide important clues about what is happening inside the file.

A Data Review is not simply a list of errors.

Our goal is to help you understand what we found and what should happen next.

After the review, we can discuss:

• Areas that appear to be working correctly

• Transactions or balances that need further investigation

• Accounting issues that should be corrected

• Reconciliation problems

• Potential duplicate transactions

• Workflow problems that may be creating recurring errors

• Areas that may require cleanup

• Recommendations for improving your bookkeeping process

We believe you should understand why something is a problem—not simply be told that it is wrong.

A Data Review can be especially helpful before beginning a QuickBooks® Cleanup.

The two services serve different purposes:

Data Review = diagnose, assess, explain, and recommend.

Cleanup = correct and repair the problems that have been identified.

A review allows us to better understand the condition of the file before deciding what cleanup work may be necessary.

Sometimes the problem is relatively small.

Other times, several areas of the accounting file may need attention.

Either way, starting with a review can help establish a clearer path forward.

Data Review for QuickBooks® Online and Desktop

QuickTrainer provides Data Review services for businesses using both:

• QuickBooks® Online

• QuickBooks® Desktop

The review is customized based on the version of QuickBooks® you use, the way your business operates, and the specific concerns you have about your accounting records.

QuickTrainer is located in Wilmington, North Carolina, but our Data Review services are available to businesses throughout the United States.

Using secure remote technology, we can review your QuickBooks® file and discuss our findings with you without needing to be physically present in your office.

Whether you are located in Wilmington or across the country, you can receive personalized help from an experienced QuickBooks® professional.

Jim Merritt has been helping businesses with QuickBooks® since 2001, and QuickTrainer, Inc. opened its doors in September 2006.

We understand that business owners do not want accounting jargon or vague answers.

They want to know:

What is wrong?

Why did it happen?

What needs to be done to fix it?

That is the approach we take with every Data Review.

We explain what we find in clear, practical terms and help you determine the appropriate next step.

A QuickBooks® Data Review can help you find out.

Before investing time and money into a cleanup project, let QuickTrainer take a closer look at your accounting data and help identify what actually needs attention.

Request a Data Review

You can also:

📞 Call QuickTrainer at 910-338-0488
📧 Email: [email protected]
🌐 www.qti-wilmington.com

QuickTrainer, Inc. is an independent QuickBooks® consulting and training company and is not affiliated with or employed by Intuit Inc. Intuit and QuickBooks® are trademarks and/or service marks of Intuit Inc.