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 AP.

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 BalanceYou want to download theTrial Balance, NOT the Adjusting 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): 

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 andselect each file.  Finally, click Import files.  

Tips and Troubleshooting

1. DO NOT rename Sheet1

2. You do not need to modify the reports in any way.

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

4. File won't import

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.

Still need help? Contact Us Contact Us