Skip to main content
December 21, 2017
Solved

Export memorized Transaction List from Quickbooks to an Excel sheet

  • December 21, 2017
  • 1 reply
  • 0 views

I want to export my Memorized Transaction List from Quickbooks to an excel sheet.  How to I do that?

 

(Title has been edited by moderator for clarity)

    Best answer by MorganB

    Hey there markmcnally,

     

    Welcome to the Community. I'd be glad to lend a hand.

     

    Exporting your Memorized Transaction List can be done by going to Reports >  List > Memorized Transaction Listing > use the drop down under the Excel option on that report to create a new worksheet. This would enable you to export the list, however all that can be imported into your account is the customer list, vendors inventory parts, non-inventory and assemblies from Excel.

     

    I hope you find this helpful. I'm only a post away if you have any other questions.

    1 reply

    MorganB
    MorganBAnswer
    December 21, 2017

    Hey there markmcnally,

     

    Welcome to the Community. I'd be glad to lend a hand.

     

    Exporting your Memorized Transaction List can be done by going to Reports >  List > Memorized Transaction Listing > use the drop down under the Excel option on that report to create a new worksheet. This would enable you to export the list, however all that can be imported into your account is the customer list, vendors inventory parts, non-inventory and assemblies from Excel.

     

    I hope you find this helpful. I'm only a post away if you have any other questions.

    January 10, 2018

    Thanks Morgan,

     

    I do have another question about Quickbooks Online auto populating email address is you can help?

    MorganB
    January 10, 2018

    Hello,

     

    I'm glad to help.

     

    Is your question about email addresses auto-populating in invoices, or on another form? If customer information contains an email address, the system will automatically include the email address when the customer (or vendor) is chosen when creating a transaction.

     

    Also, which version of QuickBooks are you using?

     

    I look forward to hearing back from you.