Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
B
Burroak
September 2, 2025
Question

Transaction by account

  • September 2, 2025
  • 1 reply
  • 55 views

I am trying to help my neighbor create a report that looks like what I use for my church, but I can't figure out how it was made. She essentially wants the transaction detail by account report but also wants in addition the beginning balance for each account reported as well. 

My church report is a memorized report called transaction by account, showing the beginning balance. But I didn't make the report nor can I figure out how it was made.

1 reply

J
JaneDave_IQuickBooks Team
QuickBooks Team
September 2, 2025
You can generate a transaction detail report with a beginning balance by customizing the General Ledger report, Bur.
 
QuickBooks Online (QBO) currently doesn't have a built-in feature to directly add a Beginning Balance column to the Transaction Detail by Account report. While this feature is not included in this specific report, the General Ledger report does. You can filter and adjust this report to see the transaction activity for a single account over a specific time period.
 
Here’s how you can customize your report:
 
  1. Go to the Reports section in the left menu.
  2. Search for General Ledger in the search bar and select the report from the results.
  3. Click Customize in the top right corner to adjust the report.
  4. Under Rows/Columns, add or remove columns such as Memo or Transaction Type, and reorder them by dragging.
  5. In Filters, select the specific accounts to include (e.g., assets or liabilities).
  6. Click Run Report to apply your changes and preview the updated report, which displays each account's beginning balance, transactions, and ending balance.
  7. Once satisfied, click Save Customization in the top right. Give the report a descriptive name, like Transaction Detail with Beginning Balance, and memorized the report for easy future access in the Custom Reports section.

 

I've included this photo below for you to picture out the finished report:

 

 

This new memorized report provides all the information your neighbor needs, with the added benefit of being easy to recreate and modify further.

 
You can also refer to this article for additional information: Customize reports.
 
Feel free to revisit this thread if you need further assistance.
B
BurroakAuthor
September 3, 2025

This got me almost there. I have the report made that I want, now how do I remove extra line items that I don't want to see on the report such as inventory asset, accounts payable, payroll liabilities, etc. I tried to filter to just "bank accounts" but all these additional lines remain on the report even if they are zero.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement