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?
I
im4gltr
March 22, 2019
Solved

TRANSACTION DETAIL BY ACCOUNT REPORT

  • March 22, 2019
  • 1 reply
  • 68 views

I love the Transaction Detail by Account report but for the life of me I can not get the "split" detail to print when I am trying to print the report from Quickbooks.  So, I tried exporting the data to Excel (in hope that it would be different, duh?) and of course, I still on get the word "Split", not the actual transaction detail that make up the split transactions.  Of course, I now have an "immediate" requirement to provide the report with ALL the detail transactions, which means the actual data detail, not the word split.  I realize than if I select the word "split" after running the report, I can see the "split detail" and I can print that detail after the "split" window opens, but then I would have to do that each time and attach separate pages to the report that the Board wants only in hard copy.  They do not want to access the report on line and open each split detail transaction and retrieve the information that way.  PLEASE tell me there is a way I can open all of the "split" transactions prior to printing the report and that they will then be reflected on the report as the regular transactions on the report.

 

I'm so sorry and I pray I'm making sense and that there is someone who can help me.  I'm sure I'm like everyone else and there is a new requirement from management daily that they want yesterday and this is one of the many I receive.  Please let me know if I can help you help me in any way.

 

Please if someone can help me, I will be very grateful.

Thanking you in advance,

IM4GLTR

 

    Best answer by mazar

    Hello,

     

    The thing to remember is that the "Transaction Detail by Account" report will show you the details of BOTH sides of the transaction.  The debits and credits.  This can often be confusing.

     

    In the screenshot I included, that's 1 transaction that has 2 items being sold and collecting sales tax.  I added the columns for debits and credits so it might be easier to see the money breakdown.

     

    You can see the total amount collected and how it was broken down.  The line that shows the total collected into the checking account shows SPLIT, but the other lines total up that SPLIT and show each amount broken down.

     

    So here's my question.  What is management wanting to see exactly and are they open to the report being displayed in a different way as long as ALL the money breakdown is shown?  For example, if you remove the split column from the report, it will still show the breakdown of ALL the money involved in the transaction and what accounts were affected by each amount.

    1 reply

    M
    mazarAnswer
    Level 6
    March 22, 2019

    Hello,

     

    The thing to remember is that the "Transaction Detail by Account" report will show you the details of BOTH sides of the transaction.  The debits and credits.  This can often be confusing.

     

    In the screenshot I included, that's 1 transaction that has 2 items being sold and collecting sales tax.  I added the columns for debits and credits so it might be easier to see the money breakdown.

     

    You can see the total amount collected and how it was broken down.  The line that shows the total collected into the checking account shows SPLIT, but the other lines total up that SPLIT and show each amount broken down.

     

    So here's my question.  What is management wanting to see exactly and are they open to the report being displayed in a different way as long as ALL the money breakdown is shown?  For example, if you remove the split column from the report, it will still show the breakdown of ALL the money involved in the transaction and what accounts were affected by each amount.

    I
    im4gltrAuthor
    March 22, 2019

    this is resolved 

    A
    ashneale
    April 3, 2019

    Hi there, @StPeter.

     

    I'm here to help share additional information about running a transaction journal in QuickBooks Desktop (QBDT).

     

    As of now, there isn't a single report showing a complete journal details for every transaction in QBDT. However, you can run any report/s, make the necessary customization and refresh the page. After, run a transaction journal in every transaction.

     

    An example, if you're opening/running the Transaction List by Customer report.

     

    1. Click on the Reports menu.
    2. Select Customers & Receivables.
    3. Click on Transaction List by Customer.
    4. Make the necessary customization.
    5. On the report's page, select a transaction (invoice, payment, and others).
    6. Press Ctrl+Y on your keyboard once you've open the transaction. Once done, you'll now be routed to the Transaction Journal of that specific transaction.

    You can read this article to learn more about transaction journal report in QBDT: View the Transaction Journal report in QuickBooks Desktop.

     

    Please know that I'll be right here to help you if you have any other questions about running reports in QBDT. I'll be always happy to help you!


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

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