Why do uploaded bank transactions show garbled description and payee in Quickbooks online?

Incorrect descriptions and payee information often stem from formatting and mapping errors, JE36. Let me explain why this happens and how we can resolve it.

When importing your bank transactions into QuickBooks Online (QBO), you need to follow the specified formats. Adhering to these guidelines will help ensure that your transactions are accurately recorded in the appropriate columns, minimizing the risk of any errors in your records.

Since you already imported your transactions, it's best to exclude them so you can upload the correct transactions. Moving forward, it is essential to follow a specific format to ensure they are imported correctly. You can choose from two available formats:

1. 3-Column Format: This includes the following columns: Date, Description, and Amount.
2. 4-Column Format: This includes the following columns: Date, Description, Credit, and Debit. Ensure that you format your transactions correctly to facilitate a smooth import process.

You can also view these articles to learn more about formats in CSV:

• Format CSV files in Excel to get bank transactions into QuickBooks
• Manually upload transactions into QuickBooks

Please let us know if you have further questions regarding importing your transaction in QBO. We're here to back you up.