Trial Balance download - cross year with specific date

Hello People10!

I know the reason why the data on your Trial Balance report is incorrect. Let me help you.

You'll encounter issues when running the said report if you selected two different Fiscal Years (FY). The Trial Balance report shows only the data from the current FY. We need to make sure that we set the reporting period that falls in the same FY.

If you're unsure, you can check or edit the first month of your FY by following these steps:

1. Go to the Gear icon and select Account and settings.
2. Select the Advanced menu.
3. From the Accounting section, update the First month of fiscal year. Then, tap Save and Done.

For more financial reports and the steps to personalize them, please check these links:

• Reports included in your QuickBooks Online subscription

• Customize reports in QuickBooks Online

Need more assistance? Keep on posting here and we'll help you. Take care!

Hi Thanks for the update, but I want to have the Fiscal year intact and want to download the TB for the said period. If I cannot change the Fiscal Year which will create problem in my US accounting.

Hi @People10,

I appreciate you for getting back to us here in the Community. I can help you download the information you need in QuickBooks Online.

The Trial Balance report can only show data from the current fiscal year. Currently, the option to download the report for that specific period is unavailable.

As a workaround, I recommend running the General Ledger report. You can customize the columns, as well as the Report period.

1. On the left navigation bar, click Reports.
2. Scroll down and select General Ledger under For my accountant.
3. Click the small gear icon within the report.
4. Add the columns you want to show in the report. 
5. Choose the date range.
6. Hit Run report.
7. View the details. 

I've also attached an article about memorized reports, like how to set a schedule and email information for a memorized report or group in QuickBooks: Memorize reports in QuickBooks Online.

Feel free to hit that Reply button if you have any additional questions or concerns about the workaround. The Community and I will be here to help you. 

Thanks AlcaeusF for the update!! This realy help in finding the report atleast.

However I have tried this report and got the details which I needed. But my querry is why is it not possible to get a cross Fiscal Year TB out directly with one click. I thought QB is having this facility. If there is any way that I can get the Trial Balance with just selection of date range (which is cross Fiscal Year), it would be a great help for me. Because I have to do further edit the report to provide it to outsider when I get the GL report as mentioned by you.

Thanks in advance.

Great to have you back, @People10.

I'll share some information about the "Fiscal Year" option on report dates. The fiscal year date has repercussions in your Trial Balance report, it requires your financial statements and the assistance of your accountant.

Thus, this option is unavailable from the Report period in the Trial Balance report. You'll want to use the Custom option instead.

Learn more about customizing reports in this article: Customise reports in QuickBooks Online.

If you need help with other tasks in QBO reports, browse this link here. It has our general topics with articles.

Let me know if you still have questions or concerns with the reports. I'll be here for you. Take care and have a great day ahead.

My client's FY is from 01/05/2022 to 30/04/2023. This may be what is called a cross fiscal year period. I need to download TB for this period. What are the steps to follow?

I can help you with that, @Makalliwa. 

Creating a trial balance report in QuickBooks Online is a fairly straightforward process. We'll need to set the date to a custom range so you can enter the date manually and then export the report.

1. Go to Reports in your QuickBooks 

2. Select Trial Balance from the list.

3. Set the date to Custom range.

4. If you want to adjust your trial balance report in any way, click Customize Report. 

5. Click Run Report.

After that, you can export the file to Excel or PDF.

I've provided screenshots for your reference: 

Furthermore, you can save your customization settings for easy access to the report in the future. Most reporting tools provide options to save customizations or create templates. See this page for your guide: Create, access, and modify memorized reports.

Please inform me if you require further guidance in managing your reports. I will assist in the process.

I needed report from mid-July 2023 to mid-July 2024. I set the start in July, however the report shows expenditure from 01 July 2024 to mid-July 2024 only. Please help.

Hello there, Rabi. I'll share details about generating a report to show data in a specific period inside QuickBooks Online (QBO).

1. Access your QuickBooks Online company.
2. On the left navigational bar, click the Reports tab.
3. In the Search bar, enter Trial balance and then click the report.
4. Enter a specific period.
5. Below the Display columns by field, click the Dropdown arrow and select Months.
6. Once done, click the Run report button.
   
   

• Customize reports in QuickBooks Online
•  Memorize reports in QuickBooks Online
  
  

Please don't hesitate to visit the Community space or comment below if you need more assistance getting data from reports inside QuickBooks. You can also post here again if you have additional questions about the program. We'll be around to lend a helping hand right away. Keep safe.