hi people i have 2013 pro

Options
Chris Bullen
Chris Bullen Member Posts: 1 ✭
edited August 2019 in Reckon Accounts (Desktop)
hi people i have 2013 pro is it possible to import an edited excel sheet back into quickbooks, what i need to do is overwrite badly spelt customers.

Comments

  • Robert Smeallie_9600650
    Robert Smeallie_9600650 Member Posts: 83 ✭
    edited January 2019
    Options
    Chris,

    Was the Excel Spreadsheet created from the 2013 Quickbooks Pro in the first instance so that the columns in the spreadsheet line up with the fields in an exported company file from QuickBooks? Also is the Excel version the same as the one that had the exported file opened in it? Modern versions of Excel made changes to file format of the spreadsheet file. You can though save the edited excel spreadsheet file as a previous version to maintain compatibility with.QuickBooks Pro 2013

    If you have spelling mistakes in the customers names were they in the Quickbooks Pro from which the spreadsheet was generated, or are they incorrect in the spreadsheet and correct in the Quickbooks company file?

    If they are incorrect in the spreadsheet then to ensure compatibility with the Quicken company file change them to match, then once they are imported into Quicken QuickBooks Pro correct the spelling in there. If you change the spelling in Quickbooks to Match the spreadsheet spelling then it may not recognise it as an exported file being re-imported after information was added. 

    Check those things and see if it solves the problem.

    Cheers
    Robert Smeallie

Categories