Skip to main content
October 14, 2022
Solved

Cannot get the trial balance printing out the figures for the correct period even when I put the correct period in

  • October 14, 2022
  • 1 reply
  • 0 views
Profit and Loss and Balance Sheet working fine
Best answer by GeorgiaC

Hi MI441, thanks for posting on the Community - what period are you entering on the trial balance report? Please note that QuickBooks only accounts for a 12 month TB and the report will run from the first day of the month selected as the 'first month of the financial year' in the advanced account settings. 

1 reply

GeorgiaCAnswer
October 14, 2022

Hi MI441, thanks for posting on the Community - what period are you entering on the trial balance report? Please note that QuickBooks only accounts for a 12 month TB and the report will run from the first day of the month selected as the 'first month of the financial year' in the advanced account settings. 

MI441Author
October 14, 2022

I’m putting in April 1st 2022 to September 30th 2022 - just wondering how to sort this.

October 14, 2022

You got me here to share some insights about how the report period works on the reports in QuickBooks Online, MI441. 

 

The Trial Balance populates from the selected month in the settings. The report will only run from the first of the month entered, so in your example, we will have to set it by April. Here's how:

 

  1. Go to the Gear Icon and then select account and settings
  2. Click the Advanced tab and then in the accounting section edit the First month of the fiscal year. 
  3. Hit Save and Done.  

 

 

Know that each report in the system has a different default period. To view the details your desired transactions, we need to manually select the date range from the drop-down menu. To do this, here's how:

 

  1. Go to the Reports tab.
  2. In the search field, type in Trial Balance.
  3. Then, click on the drop-down arrow in the Report period, or modify the date range.
  4. Click Run Report.

 

If we want to view the desired transactions and display it by months. Here's how:

 

  1. Go to the Reports tab.
  2. In the search field, type in Trial Balance.
  3. Then, click on the drop-down arrow in the Report period, or modify the date range.
  4. Select Months from the Display columns by drop-down.
  5. Click Run Report.

 

We can also export the report in Excel to make the necessary changes in the report. I'll guide you how:

 

  1. Go to the Reports menu.
  2. Type in Trial Balance in the search bar, then click to open.
  3. Set the correct date range.
  4. Select Months from the Display columns by drop-down arrow.
  5. Click on the Run Report button.
  6. Choose the Export drop-down arrow.
  7. Select Export to Excel.

 

If the same thing happens, we can perform some basic troubleshooting steps to isolate the issue. At times, the accumulated cache in your browser causes odd behavior when running the financial reports. Let's start by accessing QuickBooks Online in a private or incognito window. Just refer to the shortcut keys I've listed below:

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + P
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

If you're able to view the trial balance data it without any issues, go back to your regular browser and then clear its cache and cookies to start over fresh. Alternatively, you can switch to other supported browsers.

 

To learn more about the different reports that you can pull up in QuickBooks Online and on how to customise them, you may check out these links: 

 

 

You can always update after performing the steps as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. Have a great day ahead.