cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here

Reply to message

View discussion in a popup

Replying to:
FateCandylaneT
QuickBooks Team

Reply to message

Thanks for the follow-up details you've shared today, candice. I've come to provide insights to help you import CSV files in QuickBooks Online.

 

If you're using the three (3) column format on your CSV document, you can manually review the payment amounts that are negative and for the deposits without a negative sign. However, if you're using the four (4) columns, place the payment under Credit and deposit under Debit. You'll need to confirm you've entered and modified this information accurately to ensure the credibility of the file to upload in QuickBooks. Thus, you'll need to review its details during the mapping and formatting stage. You can refer to this guide for more detailed insights: Common errors for importing bank transactions using CSV.

 

I've also added a screenshot for visual reference.

 

 

Moreover, I'm sharing this guide to help you review your downloaded bank transactions: Categorise and match online bank transactions in QuickBooks Online.

 

You're always welcome to leave a reply in this thread if you require further assistance importing transactions with CSV files. We'll be around to get you covered. Have a good one!