Showing results for 
Search instead for 
Did you mean: 
Level 2

Reconciliation using CSV File



I want to ask if I could use a CSV file in reconciling instead of PDF Bank Statement. When I ask my client to send Bank Statement, he always sends me a CSV File.

6 Comments 6
Fiat Lux - ASIA
Level 15

Reconciliation using CSV File

You can utilize a 3rd party tool to convert CSV or PDF files to QBO files and import them into your QBO account.


QuickBooks Team

Reconciliation using CSV File

Great to see you in the Community, @Lhorie27. Yes, you can reconcile the data from the bank via .csv file in QuickBooks Online (QBO).


You may want to upload the file first to the correct bank account that you want to reconcile. I'd be happy to guide you through the steps. 


Here's how:


  1. Go to the Banking menu and select the drop-down icon beside the Link account button.
  2. Select Upload from file and locate the csv file that was given by your client.
  3. Click the Continue button and map the data in the file correctly.
  4. Follow the on-screen instructions and select Done.


This is what it looks like:



Once done importing, you can now proceed to the reconciling process. I've got an article that contains the steps on how to reconcile: Reconcile an account in QuickBooks Online.


Please feel free to get back to me here for any additional questions about the reconciliation process. I've got your back. Take care!

Level 2

Reconciliation using CSV File

Hi @MarsStephanieL,


The question now is, do all the categorized items that I made for that month won't be doubled when I upload the CSV file?

QuickBooks Team

Reconciliation using CSV File

Good day, Lhorie27!

Let me further assist you in handling your client's transactions.

When you upload a CSV file, you can match the uploaded entries to the existing transactions in QuickBooks Online and this won't cause any duplicate. This is another way of bringing in the bank transactions aside from linking the bank account.

For the detailed steps, you can follow the instructions shared by my colleague or check this article: Manually upload transactions into QuickBooks Online.

Also, I added this link to learn more about what to do with the imported bank transactions: Categorize and match online bank transactions in QuickBooks Online.

Keep on posting here if you need our help in handling bank transactions. Take care always!

Level 2

Reconciliation using CSV File

Thank you for the response. I will be still needed the Beginning and Ending Balance, right?

QuickBooks Team
QuickBooks Team

Reconciliation using CSV File

Thanks for coming back, Lhorie27.


Yes, we need the beginning and ending balance when reconciling your bank accounts. If you're reconciling an account for the first time, we'll need to review the opening balance. Where it needs to match the balance of your real-life bank account for the day you decided to start tracking transactions in QuickBooks Online (QBO). 


When connecting your bank and credit cards to online banking, QBO automatically downloads transactions and enters the opening balance for you. You don't need to worry about the opening balance. Here's an article you can refer to for more details about reconciling an account in QuickBooks Online.


Also, when you start a reconciliation, you enter the ending balance from your bank statement. QuickBooks uses this to check for accuracy. Make sure you entered the correct amount. Here's how:

  1. While you're reconciling an account, in the Reconciliation window, select Edit info.
  2. Review the Ending balance and Ending date.
  3. Check your bank statement. Make edits as needed.
  4. When you're done, press Save.


Just in case QuickBooks Online doesn't match your bank statement at the end of reconciliation, follow the steps in this article to troubleshoot the issue: Fix issues at the end of reconciliation in QuickBooks Online


Feel free to visit our Banking page for more insights about managing your company's income and sales transactions.


Do you need more help completing other tasks in QuickBooks? Please let me know and I'll assist you with some guides and other pointers. Have a great day. 

Need to get in touch?

Contact us