Sometimes you want to import your bank transactions into QuickBooks from Excel. By importing your data into QuickBooks from Excel, you take some in-depth analysis of your data. But If you think that the process of importing is difficult, you are wrong. Through the simple few steps, you will easily import your transactions in QuickBooks from excel CVS files.
In the article, we describe how to import your bank transactions into QuickBooks from an Excel CVS file. And also talk about the manual and automatic processes of importing your data.
Excel and CSV Files
Excel forms part of the Microsoft Office group of software. Excel is a very famous spreadsheet program developed by Microsoft for Windows, macOS, Android, and iOS.this program is used to keep data like numbers, formulas, text, charts, etc.
Moreover, a CSV (Comma Separated Values) files. This file is a simple text file that uses a comma to divided values. CSV files can be used with a greater part of the spreadsheets program just for Microsoft Excel or Google Spreadsheets. You can exchange your data in multiple apps.
Create Backup Before Importing Transaction into QuickBooks
Before you import your transaction into QuickBooks from Excel, we suggest you that create a backup of your data. Follow these steps to create your backup manually:
- Go to the File menu in your QuickBooks.
- Then switch to single-user mode, if you are not.
- Click on the File menu again.
- Select the company file backup option.
- Must select the option of making a local backup.
- After the window appears on your screen, then click on the Next.
- Must choose the location to save your backup data.
- Then set the number of backups according to you.
- After that, click on the OK.
- Go to the save option, then click on Next.
- Then, You have completed your manual backups.
There are two ways to import transactions into QuickBooks, they are manually, and automatic. Below, we will discuss both processes.
Manually Import Transactions into QuickBooks from Excel CVS File
If you want to import your transaction into QuickBooks from an Excel CVS file, manually. Follow these steps to import your transaction into QuickBooks from an Excel CVS file, manually:
Step 1: Go to the Banking Center
Here are the following steps for going to Banking Center:
- Firstly, open your QuickBooks Online.
- Then click on the Left icon bar.
- Select the Transaction and Banking option.
- Click on the Banking Transactions tab.
Step 2: Select the File Uploading Option
These some steps help you to select the file Uploading Option:
- Click on the Upload a file option. (that option mentioned on your screen)
- Then a window opens up of Uploading the file.
Step 3: Choose an Upload File
To choose your upload file, follow the steps given below:
- After the window of uploading a file is opened, click on the browser option to find a file to upload.
- Then select the file and click on Next.
Step 4: Select the QuickBooks Account
After choosing your update file, now you select the QuickBooks account. Here are the steps for selecting your QuickBooks account:
- Select the QuickBooks Account Which your want to import your file.
- If your account is not set, then set your account first.
- Click on Add New option to set up your account.
Step 5: Map the QuickBooks to Bank Field
These are the steps for mapping the QuickBooks to Bank fields:
- Map the file in the upload file to the fields shown in the QuickBooks Online Bank Account Mapping Fields.
- Then fill in the empty fields like date, the format of the date, description, debit and credit column, and CSV header row.
- Click on the continue.
Step 6: For Import click on the Transactions of the Bank
After mapping the QuickBooks to Bank fields, then turn to select the Bank transaction that you import. Follow the given steps below:
- Select the Bank Transactions That you want to import into your QuickBooks Online account.
- If the Bank Transaction is any unique type of character or formatting then change it and then import.
- Click on the Next, to confirm the importing the transaction of the into your QuickBooks.
Automatically Import Transaction into QuickBooks from Excel CVS File
You have learned in the above, that how to import transactions manually into QuickBooks. Now it’s time to see the automatic process for Importing your QuickBooks. Follow these steps to import your transaction into QuickBooks from an Excel CVS file, automatically:
Step 1: Search your Banking Account
The Automatic process is start with the search of your Banking Account. Here are the steps for searching your Banking account:
- Open your QuickBooks account.
- Click on the transaction from the QuickBooks home page.
- In the left menu, click on the Banking option.
- Then enter your Bank name in the search bar of the QuickBooks Banking tab.
- You can also select the Bank name from the mentioned list.
- Import the Banking Transaction if you are unable to search your bank in your QuickBooks.
Other Useful Resources:
Top 10 QuickBooks Alternatives that Fits Best For Your Small Business
Step 2: Log in to Your Banking Account
Follow the given steps for login to your account:
- In the same window, go to the login screen of the bank.
- Then provide the details of Users ID and Password to log in.
- Then you get access to your Bank account in QuickBooks.
- Then it takes some time to show all the information on the screen.
Step 3: Select the Bank Account in QuickBooks
If you want to select the bank account in your QuickBooks account for importing your transactions. Here are the steps:
- After connecting to your Bank, a screen open in front of you.
- On this screen, you show all the accounts you have in the banking you are accessing even it is one account or more
- To connect your every account with software, tick the box in the first column.
- By clicking the drop-down menu, choose the QuickBooks account that you want to link to the bank.
- Finally, your account is set up with the QuickBooks account for importing then bank transactions.
Step 4: According to the Date Range, Download the Transaction
To select the date range, carry out these steps:
- Download the transaction in the date range that is up to 90 days only.
- In case you want the transaction more than 90 days, then you have to import your transactions using a CSV file.
- Click on the link needed a shorter date range, for the short date range.
- Then select the date range and download the transaction.
- If your date of using QuickBooks is shorter than the 90 days, then also you have to use the shorter date range.
Step 5: Click on the Connecting
After selecting the date range, now you connect QuickBooks by following these steps:
- Verify both Bank and QuickBooks accounts, before connecting
- Once you verify both of them, then click on the connect (that button mentioned on the right side of the window).
- Then the process of downloading the transaction in the QuickBooks account is starting.
- After the complete download, a message is opened of success on your screen.
Step 6: Review your transaction
In the last step, you will review the transaction. Here are the steps for reviewing:
- Go to the QuickBooks Banking Center and see your transactions.
- Verify that everything is perfectly done or not.
- The process of automatically Importing your transaction into QuickBooks from the excel CVS file is completed.
You can follow the below-suggested video to get a clear direction of importing bank transactions into QuickBooks.
At the end of this post, we look for the best way to bring bank statements into QuickBooks, after reading the whole information shared in this post. After this post, if you still face any problem with the same or any QuickBooks-related problem, then you can contact EnterpriseThought for instant, and effective QuickBooks Support. We are always ready to help you. Lastly, we want to say thanks for visiting our site.