TRANSACTION DETAIL BY ACCOUNT REPORT

this is resolved 

That’s music to our ears, @im4gltr.

I appreciate you for getting back to me and letting me know that my colleague, @MJA66-87 was able to provide you with the information you need on your end.

We’ll be sure to keep adding easy-to-use features to this software so it becomes a more versatile tool for you. Stay tuned to our blog for announcements: https://intuit.me/2L2zqTv.

On the other hand, if there are any features you’re having trouble locating or any that aren’t working as they should, these articles will come in handy: QuickBooks Online Help Articles.

Here in the Community, we are committed to helping you save time and stay organized, so please feel free to reach out to us here if there’s anything you need.

I need to see the complete journal details for every transaction within one (or more) accounts in a single report.  If the transaction is a check I need to see which account the check came from.  If the transaction is a transfer I need to see from which account.  If a deposit was credited to this account which asset account has the debit.  

I have columns for debits and credits but still only the side of the entry for the account in question shows up.  If I include SPLIT details I get only GJ and Transfers; no checks, deposits, credit card transactions or any other transaction types. 

I hope I'm making sense.  I have a bit of an old mess to clean-up and looking at and reporting the journal details one transaction at a time is going to take far too long.

Thank you for responding so quickly.  Yes, that's the report but I'm still not getting both sides of the transaction when I filtered to the account in question.  Logically, I can see why that doesn't work.   Instead of showing me the complete transaction journals for a specific account, the report is filtering out every transaction except the ones on the account in question.   Classes might help but these are old entries and classes were not used back then.    

THANKS SO MUCH!

Thanks, Jen.  I've seen that option in QBO but I'm using the desktop version in this case.

Thanks, Jen.  I've seen that option in QBO but I'm using desktop. 

How can I get the memo/description to print for checks written in QBO when I run the report?

Thanks for joining us in this thread, ashneale.

Let me provide some information about the report you need in QuickBooks Online (QBO).

The memo and description should show up if you run the Transaction Detail by Account report in QBO. This report gives you detailed information per transaction and line item.

I've attached some screenshots below, so you'll know what I'm referring to.

You can also check out this article to learn more about available reports in QBO: Run Reports.

That should do it. Let me know if you have further questions about the report. I'm always around to help. Have a nice day.

I am trying to run the report for 2 specific equity accounts. Under customize, filter, I choose those 2 accounts but no data comes up? 

My report DOES NOT list the memo details for the accounts I need detail for.  It pulls the memo for some, but not others. There is no rhyme or reason which ones it pulls and which ones it doesn't. I write checks in the register and enter the memo and only some of them are pulled into the Transaction Detail by Account report. Specifically, I entered a check for Partner Retirement Deferrals and put the year in the memo section. When our CPA runs the report NO INFORMATION is listed in the memo/distributioon column. 

Thanks for getting back to us in the Community, @ashneale.

I appreciate all the steps you've done to get this working. Allow me to step in for a moment and help make sure that the memos will show on the report.

Since not all the memos are showing after customizing the Transaction Detail by Account report, let's perform other troubleshooting steps that can help us isolate this.

To start off, logging into your QBO account using a different or a private browser. There are times that the browser is full of frequently accessed page resources, thus causing some unusual responses. To use a private browser, here's how:

• On your keyboard, press Ctrl + Shift + N (Google Chrome).
• Ctrl + Shift + P (Firefox or Internet Explorer).
• Control + Option + P (Safari).

Once logged in, try to pull up the report again to double-check. If all the memos are now showing, return to your default browser and perform clear cache. Every so often the cache can become overwhelmed with older data which can potentially cause viewing and performance issues. Clearing it will refresh the system, and you'll be able to work with a clean slate.

I'm confident that this will get you pointed in the right direction.

Please let me know how it goes in the comment section. As always, I'm a post away should you need anything or have any questions. Take care and have a good day!

Nope, didn't work.

If I go back and enter detail in the description field, it will pull the data, but I am usually entering checks in the register and the only option is entering in the memo section. How does it decide where to pull the detail from?

Hi again, @ashneale.

I appreciate you taking the time on getting back to me and for trying the steps I've provided to get this working.

Ideally, memos that are added on the checks should show on the memo/description column in the report. Since you're still having the same results, I highly suggest reaching out to our Support Team so they can check this using their screen-sharing (remote access) tool. They can also perform other troubleshooting steps to fix this for you. Here's how to reach them:

1. On your QBO account, click Help (question mark icon) at the upper right.
2. Select Contact Us at the bottom to connect with our Support Team.

Please let me know how it goes after contacting them by posting a reply. I'll be here should you have any follow-up questions or concerns. Take care always!

I have this problem too.  The VAT man wants to see the VAT Detail report, but the  Memo/Description field in the rest are blank, even though every entry has a description.  The only thing that does show up is the odd memo. An hour with support who's best fix is to ask me to send some company feedback. 

So the only way I can make this report acceptable for HMRC is to copy the Description from each item and add it to the Memo Field.    FFS it would be easier using a spreadsheet. 

The Journal report is a great way to see transactions with all debits and credits by account.  For very quick analysis all accounts for a period of time this is how I use the report (I repeated these steps a couple times and go from scratch to review in about 4 minutes):

Create a variant of the Journal Report

1. add account type as first column
   1. remove Dr and Cr columns and add Amount as last column
2. customize report date - example 01/01/2020 to 07/31/2020
3. Memorize report

Go to: Excel: Create New Worksheet: Create a Comma Separated Values (CVS) fileCVS from Memorized report to Excel

1. Clean up CVS to accommodate a pivot table report from the data (get rid of unused accounts and subtotals)
2. Filter CVS report on Amount $0 and delete all rows with Amount $0
3. Highlight cells 2 row below header in Trans #, Type and Date columns, use find blanks, then plus cell above and control enter to fill all cells with Trans #, Type and Date for each row.
4. Check the amount column to ensure it foots to $0, thus no mistakes made so far.
5. Create pivot table from the CVS database
6. Save as Transaction Detail Excel Report on your computer

 Use pivot table and detail to review all accounts for the full period.

1. You can use the Account Type and Account to review different sections of the financial statements
2. Add additional pivot table rows as needed for your analysis.

I use the transaction detail by account as a starting point a lot. I need the memo/description information on the report, but I think I'm not seeing it because it's part of the split transaction. I need to run a report monthly on a bank credit card account, and list all the charges that were processed with the expense account that was charged (or credited), the memo/description, along with the date, amount, tran type, and the rest that is normally on this report. Should I use a different type of report? 

Thank you for visiting again the QuickBooks Community, tgeorge. I'll ensure to provide a specific report so you can view all the details that you want while running your business.

The Transaction Detail by Account report that you've mentioned is correct in achieving your goal. However, there's another option to quickly run and customize a report that shows the monthly on a bank credit card account. Then. list all the charges that were processed with the expense account, and the memo/description, along with the date, amount, transaction type. 

Here's how:

1. Go to the Gear icon and choose Chart of Accounts.
2. Choose a specific account.
3. Click the drop-down arrow under the Action column. Then, choose Run report.
4. Click the Customize button.
5. Click the change columns link.
6. Checkmark Memo/Description, date, amount, and Transaction type boxes.
7. Go to the Filter down arrow. Then, choose Distribution Account and select the appropriate account associated with the charges.
8. Click Run report.

To see further details on how you can customize the report to show the particular data you need, you can open this article: Customize reports in QuickBooks Online.

Lastly, you may refer to this article to see a table list that contains which reports are available for your version of QuickBooks Online: Reports included in your QuickBooks Online subscription.

Don't hesitate to post again or click the Reply button below and reach back out to me if I can be of additional assistance. I'll be around to help you out. Take care!

Thanks for showing me another way to create a report. 

I think it may be that memo/description is able to only pick up one or the other? I'm attaching a word doc with some transactions that don't have anything under the memo/description (I apologize that I didn't include heading for the columns-was trying not show company info.) The top snip is what is on the report, and the bottom snip is what is on the actually transaction. I use rules often, so this probably has a rule that I don't have anything in the memo. The blank seems to over rite the description from the actual transaction.

So it looks like this is a problem with QBO?