Skip to main content
L
Lhorie27
March 4, 2022
Question

Reconciliation using CSV File

  • March 4, 2022
  • 2 replies
  • 0 views

Hi!

 

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.

2 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
March 4, 2022

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

https://www.moneythumb.com/?ref=110

 

MarsStephanieL
MarsStephanieL
March 4, 2022

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 c.sv 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!

L
Lhorie27Author
March 4, 2022

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?

AlexV
AlexV
March 4, 2022

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!

Terms & ConditionsAccessibility statement