Skip to main content
S
Samar Hadhoud
October 5, 2023
Solved

I have an account with EFS (Electronic Funds Source) Wex Company, and this financial institution is not on QB. How would I import my transactions?

  • October 5, 2023
  • 2 replies
  • 0 views
As a trucking company we use EFS cards for fuel and expenses. However, I couldn't find it on QB , and all major expenses are being paid from this card. What should I do in this case?
Best answer by CharleneMaeF

I'm here to help you manually import your EFS transactions, Samar.

 

We can add the data to QuickBooks Self-Employed using a CSV file. Beforehand, make sure to download the transactions. 

 

Here's how to import the spreadsheet:

 

  1. Go to the Profile ⚙ icon and select Imports.
  2. Select Import transactions.
  3. Follow the onscreen steps to upload the CSV file.
  4. Click Import.

 

For more details, please see this article: Manually Import Transactions.

 

Please note that the program will automatically create and add them to the default Cash account. 

 

You can also request support from your financial institution to allow EFS to integrate with the program.

 

 Additionally, I've added a that'll help you categorize your transactions:

 

 

Please keep us posted if you need additional assistance managing or importing your transactions. I'll be looking forward to hearing back from you. 

2 replies

C
CharleneMaeFAnswer
October 5, 2023

I'm here to help you manually import your EFS transactions, Samar.

 

We can add the data to QuickBooks Self-Employed using a CSV file. Beforehand, make sure to download the transactions. 

 

Here's how to import the spreadsheet:

 

  1. Go to the Profile ⚙ icon and select Imports.
  2. Select Import transactions.
  3. Follow the onscreen steps to upload the CSV file.
  4. Click Import.

 

For more details, please see this article: Manually Import Transactions.

 

Please note that the program will automatically create and add them to the default Cash account. 

 

You can also request support from your financial institution to allow EFS to integrate with the program.

 

 Additionally, I've added a that'll help you categorize your transactions:

 

 

Please keep us posted if you need additional assistance managing or importing your transactions. I'll be looking forward to hearing back from you. 

    S
    Samar HadhoudAuthor
    October 6, 2023

    Thank you for your reply. However, when I import the transactions manually, they will be listed under (Cash).

    Is there any problem with that?

     

    F
    FateCandylaneT
    October 6, 2023

    It's great having you back here on this forum, Samar. Let me share additional insights to help you manage imported bank transactions in your account.

     

    In QuickBooks Self-Employed, manually imported or entered transactions to your account, the program will automatically create and add them to the default Cash account. Since we can only modify the category assigned for that entry, we may consider entering the name of the bank account used in the Notes section for manual tracking.

     

    Also, since Electronic Funds Source (EFS) isn't available on the bank's list, we can manually request support from your financial institution to allow EFS to integrate with QuickBooks. Here's how:

     

    1. Go to the Gear icon and select Connect Bank.
    2. From the Search panel, enter your bank and click Still can't find your bank? option from the bottom.
    3. Enter your bank's web address (URL) in the field provided and select Request.

     

    Moreover, I've included this guide to help review and track the entries you've downloaded from your bank: Categorize transactions in QuickBooks Self-Employed.

     

    We'll keep this thread available so you can always reply in the comments below for any additional queries when handling transactions in your file. We'll be around to provide further help. Keep safe!

      P
      pltinc
      December 8, 2023

      Can somebody give me any details on how to categorize these types of expenses so they would reflect on the profit and loss report? 

      J
      jeanbiverly_
      December 8, 2023

      I've got some insights that can help you categorize your expenses, @pltinc. 

       

      You can use expense categories to organize your transactions. 

       

      If you're self-employed, you'll need to report your income and expenses using a Schedule C form, also known as Form 1040 as a reference when categorizing the transactions. QuickBooks Self-Employed can help match each transaction to a line on your Schedule C. 

       

      For information on Schedule C categories and how they appear on your financial reports, you can refer to this article: Schedule C and expense categories in QuickBooks Self-Employed. 

       

      You can also check the IRS website to stay up-to-date with the latest Schedule C information.

       

      Here's how to categorize a transaction:

       

      1. Go to the Transactions menu.
      2. Look for a transaction on the list.
      3. Choose Business if the transaction was for business, or select Personal for personal. If the transaction was both, pick Split.
      4. Review the category in the Category column.
      5. If you need to modify the category, click the category link. Choose a general type, then a more detailed category.
      6. Once you're finished, hit Save.

       

      Just in case you want to create a new transaction from a receipt image in QBSE, you can check out this article for more guidance: Record or attach expense receipts in QuickBooks Self-Employed.

       

      I'm always here to back you up if you need further assistance in categorizing your expenses. Feel free to reply.

      Terms & ConditionsAccessibility statement