Skip to main content
L
lisa-2i-t-com
October 23, 2024
Question

Uploading CSV bank file

  • October 23, 2024
  • 1 reply
  • 0 views

I downloaded a CSV file from the bank to upload into QB. However, there is only one date field to map in - I would like to show both the transaction date and the posted dates. Is there a way to do this? Thanks!

    1 reply

    G
    GianSeth_A
    October 23, 2024

    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:
     

    1. Download and view your CSV file.
    2. Click details under "Description."
    3. Modify by adding Posted and Transaction dates.
    4. 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!

    Terms & ConditionsAccessibility statement