Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
LadyAg
Level 2

Report Routing

Hello,

 

I am new to QBA, but trying to catch up.  The very long-time accountant in me wants to know exactly where each report pulls its' information from, but this information does not seem readily available.

For instance, I have run a  "Transaction Detail by Account".  One of the column headers is "Full Name".  

1) I noticed a few "Full Names" were not printed on the report.  These "full names" are actually account names, so I can't imagine why not every "Full Name" column would be filled out.  2)  Since I don't know exactly where the columns from this report are pulled from, I can't investigate to see why some lines were missing this information.

 

Thanks for any and all help!

 

This actually occurred in the Sample Company, which I can experiment on without causing any lasting damage elsewhere.  T

 

1 Comment 1
MarkAngeloG
QuickBooks Team

Report Routing

Hi there, @LadyAg.


Welcome to QuickBooks Online Accountant (QBOA). It’s fantastic that you’re diving in and looking to understand how reports in QBOA pull their data. Let’s break down the specifics of the Transaction Detail by Account report and address the missing information in the Full Name column.

 

In the Transaction Detail by Account report, the two columns you see serve slightly different purposes:

 

  1. First Account Full Name Column (Main Account):
    • Represents the source account tied to the transaction.
    • For example, the account where money is coming from, such as a bank or savings account.
  2. Second Account Full Name Column (Categorization Account):
    • Reflects the destination or categorization account.
    • For example, if you recorded an expense for a meal, this column would show the account categorized, such as Meals.

If the transaction is directly tied to an account (without an associated name), the column may appear blank. This behavior is typical for entries like journal adjustments, transactions with multiple line items categorized into different accounts, or Payroll Check.

 

To determine why some lines lack this information, click on the transaction in the report to open its detailed entry. Check to see if it's categorized properly or if it has multiple line items categorized into different accounts. You can experiment in your Sample Company to categorize these transactions and rerun the report to see the changes reflected.

 

Moreover, you can also consider customizing your reports to experiment with their displayed data, and memorize it to access the report easily in the future.

 

If you’d like to learn more about how reports in QuickBooks are structured or need help about anything, feel free to ask. I’m here to assist as you explore QBOA.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us