If you receive an Error Message that says
"QuickBooks found an error when parsing the provided XML text stream",
These are the options for resolving the issue:
- Without opening your .QBW company file in a more recent version of QuickBooks, you can just run the QuickBooks Updates on a more current QuickBooks Desktop version if it is installed on your computer (and then reboot). For example, if you are working in QuickBooks 2018 and get this error, but you do have QuickBooks 2019 on your computer, you can run the QuickBooks Updates in the 2019 version and it will fix the 2018 version of QuickBooks, so you can continue working in 2018. That update in the more current year will fix the prior year's issue OR
- Upgrade your QuickBooks to 2021 (per Intuit).
As workarounds, you have these options:
1. Install an Upgrade of QuickBooks Desktop software
If you are using 2018 QuickBooks, for instance, and can install a more recent version of QuickBooks--2020 or 2021--you can run the QuickBooks Updates on the more recent version installed, reboot, and then--without actually upgrading the QBW file-- it should correct the issues using your 2018 QuickBooks.
If this does not work, Intuit recommends installing an upgraded, 2021 version of QuickBooks, and when opening the company file in 2021, the integration should work.
2. Try installing QuickBooks and Treasury Software on a new computer (without any other integrated applications); OR
3. Run a customized report from your QuickBooks company file and export the data to an Excel file. Then, import that Excel file to ACH Universal.
The way to do this:
In QuickBooks, go to Reports->Lists->Employee Contact List
[or Vendor Contact List, or Customer Contact List]
Click on the top left button to 'Customize Report'
Then add check marks next to the fields Bank Account Number, ABA Routing Number, and CHK/SAV to include those fields in your report.
Click 'OK' and run the report. Then, click the Excel button to flip the report into Excel, and 'Create New Worksheet'.
For low volume files, you can
Add a column for 'Amount' on the Excel sheet that was created. Fill in the amounts from the net payments showing in an exported bank register, or manually type in the amounts.
After amounts are entered, save the file, and then import it to Treasury Software. Follow these instructions:
https://treasurysoftware.zendesk.com/knowledge/articles/360010115994/en-us?brand_id=360000785393
For high volume files,
1. Without adding any columns (no 'Amount' column), you'll import the Excel file under the 'Profiles' tab in Treasury Software. Click on 'Import', select the Excel file that was created from QuickBooks and go through the import process, mapping the column headers to identify the data in each column. Continue through the import process until Finished. This will store all ACH recipients' bank information in the software.
Ref: https://help.treasurysoftware.com/hc/en-us/articles/360010353973-Creating-and-Using-Profiles
2. Then, a second import (Excel) file will be created using an export of the Check Register in QuickBooks.
The Check Register file is subsequently imported to ACH Universal, and you will only need two columns mapped when importing--the 'ACH_Name_Internal(Profile Lookup)' and the 'Amount' (or Amount Reverse Sign).
The Lookup field will connect to the banking information that has been stored.
Ref: https://help.treasurysoftware.com/hc/en-us/articles/360010241134-Mapping-Import-Data-Using-Profiles
Once your QuickBooks data is imported, you'll follow these instructions to create the ACH file: