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

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

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: 

• Customise reports in QuickBooks Online.
• Reports included in your QuickBooks Online subscription.

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.

That’s great, thank you!!

Could you advise on the below also:

Why has the retained earnings appeared on balance sheet on first set of accounts with it's account showing nil? That figure plus profit on balance sheet equals profit for the year. Also that retained figure has come forward to the next period. Why?

Thank you in advance.

Hi there, MI441.

I'd be glad to provide clarification on Retained Earnings.

QuickBooks Online uses a transfer called electronic swap to move money to Retained Earnings at the end of the fiscal year. This swap does not show on any report unless there have been other entries made to the Retained Earnings account.

Check this article to learn more about Retained earnings in QuickBooks Online: How to view Retained Earnings account details.

For future reference, you can also run different kinds of reports in QuickBooks Online: Run Reports In QuickBooks Online.

Let me know if you need further help managing your QuickBooks account. I'm always right here to help you.