Skip to main content
I
im4gltr
March 22, 2019
Solved

TRANSACTION DETAIL BY ACCOUNT REPORT

  • March 22, 2019
  • 1 reply
  • 0 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
    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 

    IamjuViel
    IamjuViel
    March 22, 2019

    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.

    Terms & ConditionsAccessibility statement