Skip to main content
W
weichen3535
October 15, 2024
Question

Failed to import QBO file into Quickbooks Desktop

  • October 15, 2024
  • 3 replies
  • 0 views

I got an error after importing my QBO file to Quickbook Desktop Enterprise v23.
I have no clue on this message now. Does it mean that the format of QBO file is wrong?

 

3 replies

W
weichen3535Author
October 15, 2024

Here is the content of my QBO file:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20241015062559[0:GMT]
<LANGUAGE>ENG
<FI>
<ORG>B1
<FID>10898
</FI>
<INTU.BID>2430
</SONRS>
</SIGNONMSGSRSV1>
<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
<TRNUID>1
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>Success
</STATUS>
<CCSTMTRS>
<CURDEF>USD
<CCACCTFROM>
<ACCTID>2
</CCACCTFROM>
<BANKTRANLIST>
<DTSTART>20240606083107[0:GMT]
<DTEND>20240606083140[0:GMT]
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>97e531cd-f148-42e2-a1ce-e49a20f3d725
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>5ad517d6-59cb-44d6-b2fb-0ee85c6793c8
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0cd5c786-9efb-4ce0-bee1-9feb793b62bb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>2994b2c1-9f7c-4590-af35-3dbdaa7b0b36
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>16c1ea15-6cd2-4479-a116-bedf02d68840
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>de960535-641a-404d-91ad-fa4fa2872f0d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>62a72771-7d8e-47aa-8e8e-8527e7537119
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>332b36de-839b-4026-8a94-93fac4e2fb6d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>1bfc9510-8548-4a5b-9e47-b353fbb837bf
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>76ddaf3f-60af-493f-b5e4-4df0a862619d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>4bec22fa-4c36-49b3-9dd6-0f7aafafbc98
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>bd17468b-8cfe-49fa-a70c-6414a32c7f0e
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>f13aee2c-a727-4969-a228-0c309c570026
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>32850fa1-3fdd-4ff0-913a-e436e31321d2
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>6303e9d7-d911-443d-b090-6207b39edd11
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>e83c61b0-2972-4594-9052-1b5104a173d1
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>3b501e68-dac1-4d93-9c42-b913ae6c455f
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>849e2697-b220-46f7-93e4-b2ab674072cb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>a319afee-bdce-4b7c-bcfe-0e0ef0474c81
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>1038a957-19b5-4ea3-acbb-dcac8aa1eade
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0137c45c-a8ea-4a11-94e4-d96c5fb932b7
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>bb374de6-fe57-4b6d-b209-720d4ad1b4ca
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>6b913389-8a10-4b44-b205-aa47d7533f73
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>99cfef3b-d9d6-4aea-b291-f26383b8cbeb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>d3daa9d8-4dc4-45eb-b790-87ec8cecad22
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>95d58dc8-d796-4b35-980d-bdc44ed1edc7
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>db7c9e23-1b2b-4e2d-a281-54bbbc1d0955
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>ee05ad5f-7845-4a26-a4e7-e89ce3812fa2
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>4c789ee5-dd93-4e7a-be32-6cdde8038364
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>93f74878-d5f4-42bf-8edb-a2385d88eadd
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0c2651a2-8929-4530-9778-c4005b776860
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>97aa51ed-0d74-4e82-9e34-f7cc71b50222
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083107[0:GMT]
<TRNAMT>-100
<FITID>1ca41342-a8d2-4178-ad6e-11a9cd82d16d
<NAME>Rocket Rides
</STMTTRN></BANKTRANLIST>
<LEDGERBAL>
<BALAMT>-430
<DTASOF>20241015062559[0:GMT]
</LEDGERBAL>
<AVAILBAL>
<BALAMT>9998339.5
<DTASOF>20241015062559[0:GMT]
</AVAILBAL>
</CCSTMTRS>
</CCSTMTTRNRS>
</CREDITCARDMSGSRSV1>
</OFX>

W
weichen3535Author
October 15, 2024

Here is the content of my QBO file:

 

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20241015062559[0:GMT]
<LANGUAGE>ENG
<FI>
<ORG>B1
<FID>10898
</FI>
<INTU.BID>2430
</SONRS>
</SIGNONMSGSRSV1>
<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
<TRNUID>1
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>Success
</STATUS>
<CCSTMTRS>
<CURDEF>USD
<CCACCTFROM>
<ACCTID>2
</CCACCTFROM>
<BANKTRANLIST>
<DTSTART>20240606083107[0:GMT]
<DTEND>20240606083140[0:GMT]
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>97e531cd-f148-42e2-a1ce-e49a20f3d725
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>5ad517d6-59cb-44d6-b2fb-0ee85c6793c8
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0cd5c786-9efb-4ce0-bee1-9feb793b62bb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>2994b2c1-9f7c-4590-af35-3dbdaa7b0b36
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>16c1ea15-6cd2-4479-a116-bedf02d68840
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>de960535-641a-404d-91ad-fa4fa2872f0d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>62a72771-7d8e-47aa-8e8e-8527e7537119
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>332b36de-839b-4026-8a94-93fac4e2fb6d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>1bfc9510-8548-4a5b-9e47-b353fbb837bf
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>76ddaf3f-60af-493f-b5e4-4df0a862619d
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>4bec22fa-4c36-49b3-9dd6-0f7aafafbc98
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>bd17468b-8cfe-49fa-a70c-6414a32c7f0e
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>f13aee2c-a727-4969-a228-0c309c570026
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>32850fa1-3fdd-4ff0-913a-e436e31321d2
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>6303e9d7-d911-443d-b090-6207b39edd11
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>e83c61b0-2972-4594-9052-1b5104a173d1
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>3b501e68-dac1-4d93-9c42-b913ae6c455f
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>849e2697-b220-46f7-93e4-b2ab674072cb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>a319afee-bdce-4b7c-bcfe-0e0ef0474c81
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>1038a957-19b5-4ea3-acbb-dcac8aa1eade
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0137c45c-a8ea-4a11-94e4-d96c5fb932b7
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>bb374de6-fe57-4b6d-b209-720d4ad1b4ca
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>6b913389-8a10-4b44-b205-aa47d7533f73
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>99cfef3b-d9d6-4aea-b291-f26383b8cbeb
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>d3daa9d8-4dc4-45eb-b790-87ec8cecad22
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>95d58dc8-d796-4b35-980d-bdc44ed1edc7
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>db7c9e23-1b2b-4e2d-a281-54bbbc1d0955
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>ee05ad5f-7845-4a26-a4e7-e89ce3812fa2
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>4c789ee5-dd93-4e7a-be32-6cdde8038364
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>93f74878-d5f4-42bf-8edb-a2385d88eadd
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>0c2651a2-8929-4530-9778-c4005b776860
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083140[0:GMT]
<TRNAMT>-100
<FITID>97aa51ed-0d74-4e82-9e34-f7cc71b50222
<NAME>Rocket Rides
</STMTTRN><STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240606083107[0:GMT]
<TRNAMT>-100
<FITID>1ca41342-a8d2-4178-ad6e-11a9cd82d16d
<NAME>Rocket Rides
</STMTTRN></BANKTRANLIST>
<LEDGERBAL>
<BALAMT>-430
<DTASOF>20241015062559[0:GMT]
</LEDGERBAL>
<AVAILBAL>
<BALAMT>9998339.5
<DTASOF>20241015062559[0:GMT]
</AVAILBAL>
</CCSTMTRS>
</CCSTMTTRNRS>
</CREDITCARDMSGSRSV1>
</OFX>

AlverMarkT
AlverMarkT
October 15, 2024

I appreciate you sharing the error message details you encountered when importing the QBO file to QuickBooks Desktop (QBDT), weichen3535.

 

I'm here to provide guidance regarding the error message you encountered and share recommendations we can make for now.

 

The error message indicates that the QBO file downloaded from your financial institution may include a format with unsupported data fields. I'd recommend contacting your bank and informing them about the error message you received. This way, you can verify with them if they have specific settings for exporting QBO files specifically compatible with QBDT.

 

In the meantime, to keep your balances current, you can manually enter the transactions you need into your Credit Card account register. This will ensure that your financial records remain up-to-date.

 

When the error message is resolved, you might find this article helpful for reconciling accounts in QBDT: Reconcile an account in QuickBooks Desktop.

 

We'll be here in the Community if you have further updates about importing your QBO file to QBDT. We're committed to offering ongoing support. Take care!

    W
    weichen3535Author
    October 15, 2024

    I have a question: how can I know what format is compatible with QBDT? If I can find out the correct format, maybe I can try adjusting the QBO file and then upload it again.

    M
    MirriamM
    October 15, 2024

    Hello there, weichen3535.

     

    QuickBooks Desktop is designed to work with .QBO files that you obtain from your bank. To verify the format of your file, I recommend reaching out to your financial institution.

     

    Also, when you download the .qbo file, make sure to get your Web Connect file directly from your bank, not from within QuickBooks.

     

    Here's what you need to do:

     

    1. Sign in to your bank's website
    2. Find and download the Web Connect file (.qbo file).
    3. Open QuickBooks and your company file. Then follow the steps to import the .qbo file.

     

    If you encounter any issues with web connect import, you can refer to this article on how to address them: Fix Web Connect import errors.

     

    Once you've successfully imported your transactions, you can categorize and add or match them to your existing transactions in QuickBooks.

     

    Feel free to ask if you have more questions or concerns. You can always reach out to the Community, weichen3535.

    Terms & ConditionsAccessibility statement