I have run a report and I want to export to excel and it won't let me do it but in a .CSV file any idea why, my Excel is up to date! When i use the .CSV file it won't open because it says it found a problem with it's content! Any ideas what is going on
This type of issue happens when there’s an update done in Microsoft office while QuickBooks Desktop version is not yet updated. An updated version of QuickBooks requires an updated version of Microsoft office and vice versa. To fix this, let’s repair QuickBooks first to make sure its components are in good condition. Once done, update QuickBooks to the latest release.
Stay in touch if you have additional concerns about QuickBooks.
I'm here to help you export the WIP report to Excel so you can get back to business. Let's get started.
You may want to turn on the Progress Invoicing, create an estimate, and invoice some percentage. After that, open the Job Work Progress Summary report.
Go to the Edit menu at the top menu bar.
In the Preferences window, select Jobs & Estimates at the left menu bar.
Go to Company Preferences tab.
Do you do progress invoicing? and "Yes".
Create an estimate:
From the QuickBooks Home screen or on the Customers menu, select Estimates / Create Estimates.
On the Customer: Job drop-down, select a customer or customer job. If the customer or job is not on the list yet, you can click Add New.
Fill in the relevant information at the top of the form like the Date and Estimate #.
In the detail area, select the item(s) you propose to do or include as a sale. Note: When you select or add an item, the description and amount are automatically populated based on the description and unit cost entered when the item was set up. You can delete or modify this when creating Estimates.
(Optional) If you want to apply for a discount, you need to create a discount item.
From the QuickBooks Lists menu, choose Item List.
Right-click anywhere and select New.
In the New Item window, select the Type on the drop-down and choose Discount.
Enter an Item Name/Number and a brief Description.
In the Amount or % field, enter the discount amount or percentage. If your discount amounts vary, you may want to leave the Amount or % field blank and enter the amount directly on your sales forms.
From the Account drop-down, choose the income account you want to use to track discounts you give to customers.
Select an appropriate Tax Code for the item then OK.