Repair corrupt or damaged QuickBooks company file using QuickBooks file repair utility How to identify corruption in QuickBooks Company file? Experts say that the most crucial step towards Can I use this software on Quickbooks for Mac? I have corrupted company file that needs to be repaired. From the start, QB for Mac files have not been easily transferrable from Windows to Mac. The Windows user needs to do a special export, to create a mac.QBB file and then it has to be imported into your Mac. It often doesn't work properly (like once a year) and then you are absolutely screwed.

Round Tripping is a process where you need to convert your QuickBooks Desktop for Mac file to a QuickBooks Desktop for windows file or vice versa. It is done due to different types of database each program uses. Round tripping is used either to complete an import to QBO or to enable your accountant to make changes on your Mac file. To know more about the restrictions, how round tripping is done, and the usual errors, select the appropriate topic: • • • • • Restrictions There are some restrictions for QuickBooks for Windows to create a backup for QuickBooks Desktop for Mac and vice versa: • You must have the Admin password to complete the process. • If prompted to change password during conversion, the new password must be used all throughout the process to avoid confusion.

• QuickBooks Desktop for Mac and Windows should have the same year version; e.g. If you have QuickBooks Desktop for Mac 20186 you need to use QuickBooks Desktop for Windows 2016. • QuickBooks Desktop for Mac should not be updated once you create a backup for Windows. • You should not enter data in your QuickBooks for Mac file while it is being converted, otherwise, you need to reenter the data when you receive your file back. • Avoid processing payroll in the QuickBooks for Windows version of the file. The payroll data that you enter will be lost when the file is converted back to QuickBooks for Mac since it does not have internal payroll. • You cannot round trip to QuickBooks Enterprise Solutions (QBES) because QBES cannot produce a QuickBooks Desktop for Mac backup.

• Some data may or may not be converted due to lack of features in QuickBooks for Mac compared to QuickBooks for Windows. Check for a complete list. Prepare your QuickBooks Desktop for Mac file for conversion Here are some file preparation steps for your QuickBooks Desktop for Mac file to ensure the process goes smoothly: • • Check for any special characters in the file name and company name, such as!@#$%^&*. If there are any, rename the file to remove the special characters. Note: Company name is under QuickBooks menu > Preferences > My Company. • Check for any memos with names longer than 50 characters or containing special characters such as!@#$%^&*.

• Go to Reports menu, then select Custom Transaction Detail Report. • In Modify Report window, select Dates drop-down, then choose All. • Under Columns, select Memo, then select OK to run the report. Mke windows compatible for mac file system. • Remove the memos with more than 50 characters/special characters from their corresponding transaction. • Delete all memorized transactions and memorized reports. Convert your Mac company file to a Windows file • Open the company file in QuickBooks Desktop for Mac. • Create a copy of your company file for Windows.

• Go to the File menu then select Utilities > Export > To QuickBooks for Windows. • In the Save As field, type a name for the file. For the Where field, select Desktop then Save. Note: An instructional PDF file will be available to print as reference when restoring the file.

• Rename the company file to avoid overwriting the updated copy when it is returned. • Send the backup to the Windows machine using whatever method you prefer (e.g., DVD, external hard drive, flash drive, FTP web site, or secure transfer service).

• Restore the backup using QuickBooks Desktop for Windows. • Go to File menu, then select Open or Restore Company. • Select Restore a backup copy (.qbb) then Next. • Select Local backup, then Next. • Select the backup from the location it was saved in then select Open. • When asked to update the file to the new version, type yes, then OK. Convert your Windows company file to a Mac file • • Open the company file in QuickBooks Desktop for Windows.