Working with QuickBooks Accountant’s Copy file

Having the (Accountant’s Copy) file open in QuickBooks and clicking ‘Read Trial Balance Data’ button in ExcelFSM, if you get the following message




this is simply because your client’s file has the checkbox ‘Don’t allow any applications to access this company file’ checked





Granting access permission

With the (Accountant’s Copy) file open in QuickBooks:

From the ‘Edit’ menu, choose ‘Preferences’
select ‘ Integrated Applications’ from the list on the left
click the ‘Company Preferences’ tab
uncheck the checkbox ‘Don’t allow any applications to access this company file’


Click OK


Now, clicking ‘Read Trial Balance Data’ button in ExcelFSM, you will get the following QuickBooks – Application Certificate



Select oYes, always; allow access even if QuickBooks is not running.


Click Continue



Click Done


Having been granted permission to access the QuickBooks company file, ExcelFSM can now proceed with the ‘Read Trial Balance Data’ process.




To avoid having to uncheck that checkbox everytime

While editing preferences, you get aware that the checkbox change will not be exported to your client.


To avoid having to uncheck that checkbox everytime, you can ask your client to uncheck it in his QuickBooks company file, therefore the Company Preferences of the Accountant’s Copy file you will received will already be set.

Clicking ‘Read Trial Balance Data’ button in ExcelFSM, you will get the QuickBooks – Application Certificate.



To avoid having to grant access thru the QuickBooks – Application Certificate everytime

You can ask your client to download ExcelFSM Free 30-Day Trial to grant ExcelFSM access to the QuickBooks company file (thru the QuickBooks – Application Certificate), therefore the Accountant’s Copy file you will received will already be set.

Clicking ‘Read Trial Balance Data’ button will have ExcelFSM proceed.




To 'Read Trial Balance Data' from a client's file while QuickBooks is not running

If you need to 'Read Trial Balance Data' from a QuickBooks client's file while QuickBooks is not running (example: to prepare consolidated financial statements), simply change the Accountant's Copy file into a regular QuickBooks company file.