Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Tolik
Level 1

EFS Integration

Good morning Everyone,

 

I want to import a bulk of transactions ( downloaded from EFS account as a CSV file) into Quickbooks Online. When I visited "Import" section, it asks for me different options like Bank, Customer, Vendors etc. I have tried to import those through "Bank" option but no luck.

Therefore, how can I import these ? As I know, there is no integration between Quickbooks Online and EFS (Wex Company).

5 Comments 5
MAnneJ
QuickBooks Team

EFS Integration

Hello there, @Tolik. Allow me to clarify things when importing data into QuickBooks Online (QBO).

 

The data we can import through a CSV file are payments and deposit transactions only.  Since you want to import bulk transactions from EFS as a CSV file, I'd suggest looking for a third-party application. However, if you have a specific bank for EFS entry then you may proceed to manually upload the transaction using the correct format. 

 

Here's how

 

The 3-column format has a Date, Description, and Amount column.

pic2.png

 

The 4-column format has a Date, Description, Credit, and Debit column. 

pic1.png

 

Additionally, I've added this helpful article for you to check if you're not able to import using CSV in QBO: Common errors for importing bank transactions using CSV in QuickBooks Online.

 

Feel free to reply to this thread if you need additional assistance in importing bank transactions and any QuickBooks-related concerns. Have a great day ahead.

4Gal
Level 11

EFS Integration

@Tolik 

You can use csb2qbo converter tool. It's $60 one time license.

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

 

Jenna-johnson
Active Member

EFS Integration

Curious to know how this worked out for you? I am currently in the same boat... needing to get my "bank" information linked to Quickbooks Online and am unable to due to having a EFS Fleet Card....

SIAB
Level 7

EFS Integration

@Jenna-johnson 

You can use the importer tool as mentioned by 4Gal.

jenop2
QuickBooks Team

EFS Integration

Hi there, Jenna.

 

I can see that a similar question about EFS integration was also asked in a separate thread. Let me share this link so you can read the response from one of the members of the QuickBooks Team: https://quickbooks.intuit.com/learn-support/en-us/banking/efs-electronic-fund-source-wex-company/01/...

 

Visit us again if you need anything else.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us