Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
LParrish
September 27, 2023
Question

Trial Balance Report

  • September 27, 2023
  • 2 replies
  • 35 views

How do i fix my trial balance, when i enter specific dates it shows an accumulated total starting from when we switched to enterprise in 2020? I need specific totals for the date range i put in?

2 replies

R
RCVQuickBooks Team
QuickBooks Team
September 27, 2023

Let's perform some troubleshooting steps to run the correct data when running the Trial Balance report, LParrish.

 

When running the report, we'll need to select the Custom option in the Dates field. Then, enter the date period in the From and To fields. On the Report Basis, choose Accrual or Cash. To learn the difference between Cash and Accrual basis and how to set them as preferences in QuickBooks Desktop for Windows, check out this article: Differentiate Cash and Accrual basis.

 

See the screenshot for your reference:

 

Here's how to run the report: 

 

  1. Go to Reports on the top menu.
  2. Choose Accountant & Taxes.
  3. Select Trial Balance.
  4. Choose Custom in the Dates period and enter the date period in the From and To fields.
  5. On the Report Basis, choose Accrual or Cash. 
  6. Press the Refresh tab. 

 

If the same thing happens, we can narrow down the solution to the program itself. There might've been a damaged component that prevented the Trial Balance report from calculating the correct total. Before we do anything else, let's ensure QuickBooks is updated to the latest release. This helps apply the necessary patches that fix common program and file issues.

 

Once done, install QuickBooks Tool Hub and then run the Quick Fix my Program utility. This tool helps resolve major issues and errors that a user might face while working in QuickBooks Desktop. We recommend running it on Windows 10, 64-bit for the best experience. Here's how to install the software:

 

  1. Close QuickBooks.
  2. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install, then agree to the terms and conditions.
  5. When the installation is finished, double-click the icon on your Windows desktop to open the tool hub.

 

Once done, it's time to run the Quick Fix my Program utility:

 

  1. From the tool hub, select the Program Problems tab.
  2. Select Quick Fix my Program.
  3. Click OK and then open QuickBooks again.

 

To learn more about this process, check out this article: Repair your QuickBooks Desktop for Windows. I'm also adding this article to learn how to obtain the different tools that will help you fix common issues and errors: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

Moreover, browsing this resource helps you save your report customization to use the same filter and format in the future is a breeze in QBDT.

 

Feel free to update us after performing the solutions, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. You have a good one. 

L
LParrishAuthor
September 27, 2023

I did everything you listed and it did not fix the issue. i am running version 1.5.0.0.  Also running Windows 10 64 bit.  I have been selecting Cash but the numbers are still an accumulation from previous years. It is doing it on multiple accounts now that I have looked into it. Do I need to unistall QB and Reinstall ?

C
Carneil_C
Level 6
September 27, 2023

I appreciate your reply, @LParrish.

 

Let me provide additional troubleshooting steps to help sort out this issue with your trial balance report and get back to business in no time.

 

You'll want to try opening a sample company file and then pulling up the same report to verify if it shows the same behavior. If not, utilize the Verify and Rebuild data tool. This way, we can identify and resolve the most commonly known data issues within your company file.

 

Here's how: 

 

  1. Choose Window, then Close All.
  2. Go to the File menu, and then click Utilities.
  3. Select Rebuild Data.
  4. Follow the onscreen instructions to back up your data.
  5. When the tool finishes, select OK.
  6. Navigate to the File menu, then click Utilities.
  7. Click Verify Data, then select Rebuild Now once QuickBooks finds an issue with your company file.

 

Please see this article to learn more about how you can fix data damage to your company file: Fix data damage on your QuickBooks Desktop company file.

 

If the issue persists on the sample file, we can now try uninstalling and reinstalling QuickBooks again. However, I recommend contacting our QuickBooks Desktop Support Team to guide you through the process. 

 

I'll be around if you need further assistance with managing your reports in QBDT. I'm determined to help you succeed. Take care always.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement