Skip to content
  • There are no suggestions because the search field is empty.

Troubleshooting Numbers Not Matching in Reach Reporting

Common causes and solutions for data discrepancies between Reach Reporting and your accounting software.

Troubleshooting Numbers Not Matching in Reach Reporting

When your numbers in Reach Reporting don't match what you see in your accounting software, there are several common causes and troubleshooting steps to resolve the issue.

Step 1: Sync Your Data

The first step is always to ensure your data is up to date:

  1. Check Last Sync Date: Verify when your company was last synced to ensure you're working with current data.
  2. Manual Sync: Click the sync button in the lower left corner of your company to pull the latest data from your accounting software if it was not synced recently.
  3. Wait for Sync Completion: Allow the sync process to complete fully before comparing numbers.

Step 2: Confirm Accounting Basis

The accounting basis setting must match between systems:

  1. Check Company Settings: Go to your company settings and verify the accounting basis (Cash vs. Accrual).
  2. Match Your Bookkeeping: Ensure this setting matches what you're using in your bookkeeping software.
  3. Refresh After Changes: If you change the accounting basis, refresh your browser and check that the numbers match.

Step 3: Verify Data Sources

Make sure you're pulling actual data from your accounting software:

  1. Check for Custom Rows or Columns: Custom rows/columns with manual entries won't sync with your bookkeeping. Look for rows/columns you may have added manually, denoted by a wrench icon next to the row number or above the column.

      2.  Confirm Data Source: In the metric or statement builder, verify that rows and                     columns are pulling from your actuals from the Chart of Accounts, not custom                   calculations or budget/forecast data. Click the gear icon above the column or                   next to the row to see the column or row type.

       3.  Review Formulas: Check if any custom formulas are affecting the totals.

Step 4: Check Class and Department Filters

Filters can significantly impact the data you're seeing: 

  1. Column Filters: Look for the funnel icon above each column in your metrics and statements. If the funnel is red, filters are applied.

      2.  Row Filters: Click the gear icon next to individual rows to check if row-level filters               are overriding column filters.

      3.  Clear Filters: Remove any class or department filters temporarily to see if this                     resolves the discrepancy.

      4.  Unspecified Classes: To see if the difference is coming from unspecified classes,               sum up each class and subtract the sum from the number you are seeing in your             bookkeeping. Compare the difference to your bookkeeping’s unspecified classes               report.

      5.   Match Your Bookkeeping: Ensure your filters match exactly what you're                                comparing in your accounting software.

Step 5: Review Account Status

Hidden or inactive accounts can cause discrepancies:

  1. Check Inactive Accounts: In your company settings, look for the "Hide inactive/deleted accounts" option.
  2. Unhide Temporarily: Temporarily show inactive accounts to see if they contain relevant data.
  3. Sync Inactive Accounts: For QuickBooks Desktop connections, ensure "Sync Inactive Accounts" is enabled in the Desktop Connector settings if your date ranges include periods when accounts were active.

Step 6: QuickBooks Specific Settings

For QuickBooks Online:

  • Set View to Classic: In QuickBooks Online, make sure your view is set to "Classic" when comparing reports. Reach Reporting pulls data from the "Classic" view, not the "Modern" view. You can switch views in the upper right corner of QuickBooks Online reports.

For QuickBooks Desktop:

  • Verify Sync Settings: In the sync settings window, try syncing with the boxes checked for "Use Classes" and "Sync Inactive Accounts".

Step 7: Company Name Verification

Sometimes, company name changes can cause confusion:

  1. Check Company Settings: Go to your company settings in Reach Reporting.
  2. Clear Company Name: Delete the company name field temporarily to see if it matches your bookkeeping software exactly.
  3. Verify Match: Ensure the company name in Reach matches exactly what's in your accounting software.

Step 8: Check Date Ranges

Verify that your date ranges in Reach match what you're comparing in your accounting software. 

Step 9: Additional Troubleshooting Steps

If the above steps don't resolve the issue:

  1. Review Book Month: Ensure your book month setting reflects the correct period.

      2.   Compare Statement Types: Make sure you're comparing the same type of report             (P&L vs. Balance Sheet, etc.).

      3.   Unlocked Statements: In unlocked statements, any new or deleted accounts                     done in your bookkeeping won’t update in the unlocked statement. Those                           changes can be manually added to the unlocked statement. There is an                             indicator next to the title of the statement when you’re in the editor mode, which               will show you the missing accounts.

When to Contact Support

If you've tried all the above steps and the numbers still don't match:

  1. Document the Discrepancy: Note the specific amounts that don't match and which accounts are affected.
  2. Provide Screenshots: Take screenshots of both Reach Reporting and your accounting software showing the discrepancy.

Contact Support: Use the chat feature or email support@reachreporting.com with your findings.

 

 

Go to the Reach Reporting app>

ARE YOU NOT CURRENTLY USING REACH REPORTING?

learn more at reachreporting.com

We are dedicated to helping you.

- Need Additional Help?

Your success is important to us.

Whether you're working as a CFO of a business or part of an accounting firm, Reach Reporting is here to improve your working knowledge of reporting and provide service tips and skills to ensure you're at the top of your game. 

We make sure that you have access to staff members that are best suited to help you. We work together to resolve issues and create memorable moments that empower you to enhance your reporting skills.

We are here to listen to you. We understand that using new technology can be frustrating, so we can answer questions or jump on a quick zoom call. Our entire staff has an in-depth knowledge of Reach Reporting and can quickly direct you to best practices to improve your reporting. 

We are here focused on providing solutions that save you time and increase your value. We continue to improve each day and look forward to visiting with you. Your communication with us is vital and appreciated. 

Please feel free to chat with us by clicking the help chat bubble in the lower right-hand corner of this page.

Reach out to your Reach Reporting Rep and schedule a zoom meeting by clicking the meeting link in their email signature.

Or schedule to join our onboarding webinars


Foundations Webinar

Reach Reporting is dedicated to helping provide a knowledge base that is easy to understand and informative. If you still have questions that have not been answered, please let us know by emailing support@reachreporting.com, chatting with our support team, or calling us at (877) 467-7637. We are here to ensure that you have a positive experience with Reach Reporting, as we want to continue to be the reporting solution you trust. 

Need more access to Reach Reporting Resources?

Reach Reporting has a wealth of knowledge and a robust online community to support you as you create reports that provide powerful insight. Please look into the following resources.

Reach Reporting Blog: We add blogs to our site every month to give you great information in a fun and friendly manner.

Case Studies: We interview one company per month to help our clients highlight how they are using Reach Reporting and how it is improving their services and firm offerings. These case studies are invaluable to our community.

Knowledge Center: From simple to complicated, we provide step-by-step guidance to utilize every aspect of Reach Reporting in our robust knowledge center.

Video Tutorials: We know watching is sometimes easier than reading, which is why all of our tutorials are video-based in the video tutorial section of Reach Reporting and Youtube.

Social Networks: Join us on FaceBook, LinkedIn, Youtube, and Twitter.

Competitor Comparisons: We have looked at all the reporting solutions on the market. We provide you with an in-depth look at Reach Reporting compared to some of the strongest competitors out there on our competitor comparison page. 

Monthly Newsletter: Go to the footer of reachreporting.com and sign up to receive the Reach Reporting newsletters delivered directly to your inbox. Our newsletters cover tips and tricks, current events in accounting, strategies to improve your advisory services, and much more.

We look forward to helping you build insightful reports,

The Reach Reporting Team.