It's great to have you here in the Community, Lisa. I'll share some information so you can download your CSV file correctly to QuickBooks.
When downloading data to QuickBooks Online (QBO). Your CSV file should include the following fields, Date, Description, and Amount. Bear in mind that only standard date formats are accepted.
You can modify your file to include a description with both posted and transaction dates. Just make sure the Date field is in a standard format (e.g., dd/MM/yyyy).
Moreover, make sure to select the correct columns during the mapping stage, as QuickBooks cannot interpret the data otherwise. You may consider the following steps to simplify the process:
- Download and view your CSV file.
- Click details under "Description."
- Modify by adding Posted and Transaction dates.
- Save and upload the transaction.
For guidance on how to match transactions from the Banking page, refer to this guide for more insights: Categorize and match online bank transactions in QuickBooks Online.
You can also explore these resources to gain more ideas on reconciliation, which may find helpful:
Let me know if you have more questions about importing transactions. I'm here to help. Best wishes!