Skip to main content
P
People10
June 17, 2021
Question

Trial Balance download - cross year with specific date

  • June 17, 2021
  • 1 reply
  • 0 views

When I tried to download the Trial Balance for the period April 1st 2020 to March 31st 2021 it is not showing the proper value. It shows only the values till April 1st 2020 to Dec 31st 2020 as my books are closed for the year 2020. I dont know how to get the cross year trial balance to produce it to an Indian company.

1 reply

AlexV
AlexV
June 17, 2021

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:

 

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

P
People10Author
June 17, 2021

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.

AlcaeusF
AlcaeusF
June 17, 2021

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. 

Terms & ConditionsAccessibility statement