Can i export excel spreadsheet into quickbooks?

Please provide me solution.

Add Comment
1 Answer(s)

Yes, you can easily export excel spreadsheet into QuickBooks. These spreadsheets may contain the lists of Customers, Vendors, Payroll and transactions as well as Items.

Let’s start to export excel spreadsheet step by step:

To export Customer/Vendor/Payroll list and transactions:

    • Open the Customer/Vendor/Payroll
    • Click on the Excel drop-down and select:
        • Export Customer/Vendor/Employeelist to export data such as name, balances and contact information.
        • Export Transactionsto export transactions.
    • Select whether to create a new worksheet or update an existing worksheet  In the Export window.
    • Click on the Export QuickBooks opens MS Excel and you can edit the information as needed.

To export Items:

    • Click on Item List from the Lists menu.
    • Click on the Excel drop-down error and select Export all Items.
    • Select whether to create a new worksheet or update an existing worksheetIn the Export window.
    • Click on the Export QuickBooks opens MS Excel and you can edit the information as needed.

To export Reports:

If you want to change a report’s appearance or contents, you can also export reports and customize it in Excel without affecting your QuickBooks data

    • Open the report you want to export.
    • Click on the Excel drop-down at the top of the report.
    • Choose whether you want to create a new worksheet or use the report data to update or replace an existing worksheet.
    • Click on the Export QuickBooks opens MS Excel. You can edit your data as needed.

Hope this answer will be helpful for you. For more information about importing invoices into QuickBooks and many more, dial QuickBooks Online Support Phone Number 1-855-441-4417. You can ask any query related to QuickBooks from well qualified and experienced accounting experts.

Read here about QuickBooks Payroll Support

Answered on July 21, 2017.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.