cancel
Showing results for 
Search instead for 
Did you mean: 
twhitley
Level 1

Can an single job estimate be exported in excel format?

 
13 Comments 13
MichaelDL
QuickBooks Team

Can an single job estimate be exported in excel format?

You've come to the right place, @twhitley.

 

While individual transactions can't be exported to Excel format, you can retrieve the data in table fashion using the Audit History. Here's how:

 

Copying Audit History to Excel

  1. From QuickBooks Online, navigate to the Sales tab > Customers section. Click the customer's name whose Estimate you need to export.
  2. Find the transaction from the list below. Click to open it.
  3. At the bottom of the Estimate screen, click More > Audit History.
  4. This page displays a table for every iteration of this transaction's history, meaning that a new table is created after every edit.

After some testing, I can confirm these tables can be copied directly to a similar range of Excel cells. We also offer an awesome guide on audit histories that I'm sure you'll find helpful. I'm including a brief video demonstration of this below:

 

By doing this, you can see a detailed explanation of every change that's been made to a transaction, and copy that information to Excel with ease. Please feel free to reach out to me here should ever need a hand with QuickBooks, I want to ensure your success. Thanks for bringing us your question and take care.

SmallStudio
Level 1

Can an single job estimate be exported in excel format?

How do you do this in QuickBooks Desktop?

I need the ability to export to excel everything listed on an estimate. Please advise.

FritzF
Moderator

Can an single job estimate be exported in excel format?

Thanks for joining this conversation, @SmallStudio.

 

To do this in QuickBooks Desktop (QBDT) run the Audit Trail. Then, instead of copying and pasting all the information listed on the Estimate, you'll be able to export it to Excel.

 

Here's how:

 

1. Go to Reports menu at the top.
2. Pick Accountant & Taxes and Audit Trail.
3. Click the Customize Report option.

78.PNG
4. On the Display tab, enter your preferred date on the Report Date Range section.


5. Now, go to the Filters tab.
6. On the Choose Filter section, select TransactionType, then Estimate.
7. Hit OK.

79.PNG

 

Once done, you can export it by clicking the Excel option, then Create New Worksheet and Export.

80.PNG81.PNG

 

 

That should point you in the right direction. Keep me posted on how everything goes in the comment. I'm always here to help. Have a good one.

Lynn5
Level 1

Can an single job estimate be exported in excel format?

Is it possible to print the template of the Estimate to Excel?

KhimG
QuickBooks Team

Can an single job estimate be exported in excel format?

Good day, @Lynn5.


Printing an estimate template in Excel format is currently unavailable in QuickBooks Online. Download it as a PDF file instead and use a converter app to get the outcome you want.


Here’s how:

  1. From the Gear icon, select Custom forms styles.
  2. Look for the template from the list and click the drop-down arrow under the Action column, then select Preview PDF.
  3. Choose the arrow down or download icon to save the template as a pdf file.

Form style 1.PNGForm style 2.PNGForm style 3.PNG

 

Read through Customize your invoices, estimates, and sales receipts in QuickBooks Online to learn more about the topic.


There are different programs available to change the file from PDF to Excel. I recommend visiting our App Center to find software that works best for you. 


Here’s an article to know more about the website: App Support.


Please let me know how this goes or if you need any assistance. I’m always here to keep helping. Have a fantastic day!
 

janineh
Level 1

Can an single job estimate be exported in excel format?

I am trying to do this same thing from QuickBooks Desktop, but what I need is the Qty, Item #, Description, Our cost, Cost to customer (ea), Total cost for line.  Basically everything that we enter onto the estimate.  There has to be a way to export this information instead of having to enter it all by hand.  Please help!

Angelyn_T
QuickBooks Team

Can an single job estimate be exported in excel format?

Thank you for joining the thread, @janineh.

 

In QuickBooks Desktop, you can import your estimate template by going to your Templates lists.

 

Here's how:

 

  1. Open your QuickBooks Desktop, then click on the Lists menu at the top menu bar.
  2. Choose Templates from the drop-down.
  3. Highlight the template you want to export.
  4. From the Templates drop-down, select Export. Verify the file name and choose the location of the file on your computer. Choose Save.

On the other hand, if you wish to export an estimate itself, open your estimate then click on the Print drop-down arrow and select Save as PDF.

 

For additional reference about using and customizing form templates, read this article.

 

Get back to me if you have any other questions. I'm a post away to help. Have a good day!

janineh
Level 1

Can an single job estimate be exported in excel format?

I appreciate the response.  But what I'm trying to do is pull information from a specific estimate that already has information on it, but is 3 pages long!  I don't want the template exported, but I want the information from the estimate exported to Excel, not as a PDF.  There has to be a way to do it, but I just haven't been able to find it.  thanks.

Anna S
QuickBooks Team

Can an single job estimate be exported in excel format?

Allow me to chime in, @janineh.

 

Since the information you need is considered part of a transaction (estimate), you won't be able to export them to Excel the way you mention. I know you said you don't want to use a PDF file, so I recommend checking out our third-party app options to export the information you need off the three-page estimate. This way, you can find an option that doesn't involve you manually entering all your data into an excel sheet.

 

Feel free to comment below if you have any other questions. I'm always here to help.

Fiat Lux - ASIA
Level 15

Can an single job estimate be exported in excel format?

CK Design
Level 1

Can an single job estimate be exported in excel format?

I had the same issue -- here's what I did. 

 

Copied the estimate -- hit save -- audit history -- highlighted all data -- copy/paste special into Excel -- deleted new copied estimate in QB online

 

Then I adjusted the format to suit my needs. 

 

Hope that helps!

alco1
Level 1

Can an single job estimate be exported in excel format?

wow , finally  solution , wow 

alco1
Level 1

Can an single job estimate be exported in excel format?

finally someone find the solution , you are good  

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us