QuickBooks Tip – Quick Report on Transactions

QuickBooks Tip – Quick Report on Transactions

Using QuickBooks, how do I get a report of all invoices?  How can I see the Sales Receipts (checks, bills, estimates, etc.) that I have entered into QuickBooks?  You can get a report on transactions several ways, but I’ll share a quick and easy way to do it in QuickBooks.  It is surprising how many people overlook the Transactions tab in the centers.

In the customer (or vendor or employee) center in QuickBooks, click on the Transactions tab as shown.  Then, you can select which type of transaction (Invoices in this example), filter and select the date desired.  You can sort by clicking on the column heading (by Num in this example) and  you will see a total too.  Then, you can print or export the report if needed.

In the quick report, you can right click and select Customize Columns to add/remove columns or change the order of the columns too.

Now, be honest how many of you overlooked or forgot about the Transactions tab?  Make sure to share it with your clients or others — they will appreciate it!

14 thoughts on “QuickBooks Tip – Quick Report on Transactions

  1. Jai

    Hi, how do you get hours from an invoice onto a report so you can see how many hours were billed to a customer in a time frame?

  2. Jim O'Connor

    DUH, I spent a lot of time trying to figure out how to get this report. Thank you very much.

    Jim O

  3. Joan Miceli-Muhlbauer

    Perfect timing Michelle! New client with invoice transactions being imported from a third party company into QB. Things are a mess! Showing client another way for her to find and match invoices verses the online company will be very helpful.

    Thank you as always!

  4. Ellie

    I found your tip to be quite useful, and yes, I’d overlooked the obvious in the past!

    Thank you for pointing it out to us!

  5. Paula Kelley

    Good tip. I use the transactions tab all of the time. I create these reports constantly. I usually create the report by other methods though. I sometimes forget to do that from the transactions tab area. This is a good reminder for me.

  6. doug king

    How can I pull or export a list of ‘sold to’ from the sales receipts?
    I need to email or send them letters but can find no way to export or even list them.

    1. Michelle Long Post author

      You can export customer details (i.e. address, etc.) by going to File > Utilities > Export or you can print mailing labels via File > Print Forms > Labels

      You can also create letters within QuickBooks — check under the Customer Center and click on Word or the Customer menu for Prepare Letters

  7. Ritainnj

    Great tip! I have not found a way to create a report that will show all bank deposits with a total for a specific month?

    1. Michelle Long Post author

      Yes there is — In the Vendors Center, click on the Transactions tab & Checks.

      You’re not blind — lots of people don’t notice (or don’t click) on the tab. Hmmmm….I just thought of something similar that is frequently overlooked. Watch for another ‘Quick Tip’ post about it later today. 🙂