cancel
Showing results for 
Search instead for 
Did you mean: 
treasurer56
Level 1

Looking for a report of account transactions for the year that includes the actual account balances, instead of just the current year's balance

 
2 Comments 2
SarahannC
Moderator

Looking for a report of account transactions for the year that includes the actual account balances, instead of just the current year's balance

Hello there, @treasurer56. It's nice to have you here.

 

Let's pull up a report that can generate the details you need.


We can run the Transaction Detail by Account report and modify it to your desired setup. This way, QuickBooks will generate bank balances with the transactions associated with it.

 

You'd need to customize your desired date to get the data according to that period. Let me show you how:

 

  1. Go to Reports on the left panel.
  2. In the search box, enter Transaction Detail by Account. Then, click the Customize button in the upper-right corner.
  3. In the Rows/Columns section, include the BalanceTransaction TypeAmount, and DateNote: You can change the columns or add more if you want. 
  4. In the Filter section, put a checkmark on the Distribution Account.
  5. Click the drop-down arrow and tick all the accounts you want to display on the report.
  6. Then, hit Run report and ensure to set the correct dates.

 

You can also export the report to add more details from the Excel. Click the Export icon and select Export to Excel. That will do. Let's see this sample screenshot:

 

Here are some articles that provide additional details about managing reports in the Online product:
 

 

Let me if you have other follow-up questions about it. I'm right here to help you figure them out. Have a good and take care always, treasurer56.

SarahannC
Moderator

Looking for a report of account transactions for the year that includes the actual account balances, instead of just the current year's balance

Hi treasurer56,


Hope you’re doing great. I wanted to see how everything is going about running a report that includes the actual account balances. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

Need to get in touch?

Contact us