How to Get the Right QuickBooks Desktop or Online Reports

You can import QuickBooks Desktop Excel Trial Balances into Tallyfor.  Tallyfor works with QuickBooks Pro, Premier and Enterprise.

This method can also be used for Quickbooks Online in the event that you don't have the necessary permissions to connect via API.

Example Reports

Sample excel downloads for your reference.

QBD

Trial Balance

Account Listing

QBO

Trial Balance

Account Listing

QuickBooks Desktop

1. Export 2 reports as Excel.

Tallyfor requires a pair of reports, 1) The "Trial Balance" and 2) the "Account Listing" report. Both are found under the Quickbooks Menu item Reports/Accountant & Taxes. See screenshots below.

Reports/Accountant & Taxes/Trial Balance

Reports/Accountant & Taxes/Account Listing

Use the Excel dropdown to create a New Worksheet.

Do not use the PDF version, or CSV versions of the reports.

2.  Import files into Tallyfor

Now that you have the right reports, In the MENU section of Tallyfor, click on the QBD tab.  Then locate and select each file.  Finally, click Import files.  

You do not need to modify the reports in any way. QuickBooks may add an extra tab. You may or may not delete this tab. DO NOT rename Sheet 1.

QuickBooks Online (Import Option)

If you don't have the required access to your client's QBO account, we can import the reports from QBO as well.

1. Here are the right reports to get (XLS format required): 

For the Account List report, you need the CLASSIC VIEW. Please click "Switch to classic view"

2. Import files into Tallyfor

Now that you have the right reports, In the MENU section of Tallyfor, click on the QBD tab.  Then locate and select each file.  Finally, click Import files.  

Tips and Troubleshooting

1. DO NOT rename Sheet1. The sheet needs to be named "Sheet1" or the file won't import.

2. The Tallyfor importer reads the default report output of QBD. Do not modify the reports. Modifying the reports may prevent the file from importing. You may need to revert to the default report formatting in QuickBooks.

4. QuickBooks may add an extra tab. You may or may not delete this tab. 

5. File won't import if there are three additional three rows in header.

If, after following the steps outlined in the article, you are not able to import the QuickBooks reports into Tallyfor, please note if the Account Listing and Trial Balance reports have have an additional three rows in the header with the account details. QBD has some settings that may or may not add these rows into the header. Tallyfor does NOT need those headers. If the reports have these three rows, please delete the first three rows of each file and then save the Excel files. Deleting these rows will allow the reports to be imported.

6. Spacer columns are required.