Skip to main content
June 8, 2023
Question

Invoice Transaction journal

  • June 8, 2023
  • 1 reply
  • 0 views

Where can I find the transaction journal entries for our customer invoices, using Quickbooks online?  I need to see how the invoice that is imported uses each account, and how to map the correct account numbers to each transaction line. I don't see where Quickbooks online allows that access for more than a general knowledge of accounting.

1 reply

June 8, 2023

Hello, BCAaccounting.

 

There are two ways to locate the transaction journal entries for invoices in QuickBooks Online. I'll lay down the steps to help you find them. 

 

We can open a certain invoice, then check the transaction journal information from there. Here are the steps: 

 

  1. Go to Sales, then click the Invoices tab.
  2. Open an invoice. 
  3. On the invoice screen, click the More button.
  4. Select Transaction Journal

 

If you need to check multiple invoices, we can use the customized Journal report instead:

 

  1. Go to Reports.
  2. In the search box, search for Journal, then click the result. 
  3. Click the Customize button.
  4. Check Transaction Type, then select Invoice.
  5. Add other customization settings if needed.
  6. Once done, click Run report

 

Both methods allow us to see the accounts associated with the invoices, including the debit and credit columns. 

 

About the account numbers, I take it that you're also trying to see them in the journal. In this case, we'll just want to make sure to enable it in your settings and ensure they are showing in your reports. 

 

A guide about enabling and using them can be found here: Use account numbers in your chart of accounts in QuickBooks Online

 

After managing those invoices, I'll also add this article if you need help creating customer statements: Create and send customer statements in QuickBooks Online.

 

You can reply here again if you have more concerns about your invoices and how the accounts affect your books. My team and I will be around to help. 

June 13, 2023

In the first solution, my invoices do not show a more button to see the individual invoice journal. The second solution in reports pulled the information that I needed to see the transaction journal entries.

 

For the account numbers, the sales tax for one state is going to the correct account number for sales tax liability.  However, another state is going to a generic Sales Tax Agency Payable.  When I click on it, it just takes me to the invoice, not where I can edit the account number to the correct sales tax liability account. It sometimes goes the correct state, sometimes to the generic.

JenoP
June 13, 2023

Hi there, BCAaccounting.

 

I imported a couple of invoices in my account and I'm getting the More button when I opened it. Can you share a screenshot or tell us what you can see in your invoices? We just want to make sure that we are giving you the right information and steps to sort this out.

 

Please reply back to us to share more details. We look forward to it.