How To Upload Bank Information From Excel To Quickbooks Premier

Have you ever needed to import data from Excel into Quickbooks?

In this scenario, nosotros're going to presume that maybe you intermingled some personal and business expenses on a personal credit card. You then went on to download the transactions from your credit card company every bit an Excel sheet and deleted all the transactions that weren't business related. This will leave you with an Excel file of business transactions that will need to be imported into QuickBooks. You lot tin can accomplish this in a handful of ways but we're going to evidence you just ane here.

The first affair nosotros need to practise is clean upwardly our excel file a little bit. Some Credit Card Companies add together headings that can throw off the mechanism that QuickBooks uses to parse the banking file.

You might notice that the file we're working with is an XLS file. This will non be usable by QuickBooks – we need it to be in CSV format. Converting the file is pretty direct forwards. All yous need to practise is click, File and Save As and change the file blazon to CSV.

Use CSV file so Quickbooks can use it as an import.

At present that we take our file ready up, we need to cull which account nosotros want to add together the file to. For this example, we're going to choose the Petty Cash account.

Once we click on Petty Cash, we'll be taken to the accounts screen and nosotros'll exist able to upload our file. Click downward pointing arrow next to the Updated button in the upper right-hand part of the screen. That will drop down a menu and nosotros'll be able to click on "File Upload" from there.

On the next screen, we need to tell QuickBooks where we're getting our data from. It will want to know if we're giving it a file local on our calculator or uploading directly from our banking establishment. In this example, we exported our CSV previously and that file lives locally on our estimator.

Now that nosotros've located our file, nosotros demand to work with QuickBooks to tell it how to apply this file and where information technology needs to go. On the adjacent page, you'll be presented with a prompt that says "Select a QuickBooks account for the bank file you want to upload." In our instance, we're going to assign register.csv to our Fiddling Greenbacks annals. You don't always have to assign an existing register, you lot can always "add together new" and make a new account for your situation.

The adjacent footstep is a fleck more tricky but in one case you do it a couple of times, it will go second nature. Here, we are asked to tell QuickBooks how to interpret the information from each column and how to map that data into a transaction. For instance, our QuickBooks transaction has a Date column and our excel spreadsheet has a appointment cavalcade for each transaction. QuickBooks also has a field for Description. The well-nigh like column to description is Column four, Memo. Finally and perchance the most important part is the data for the amount of the transaction. QuickBooks is smart plenty to know that some times banks separate payments and deposits into dissimilar columns and sometimes banks lump all the figures into ane cavalcade and utilise negative and positive values to distinguish the two types of transactions.

The next pace is to assistance QuickBooks in parsing through the transactions. We'll click side by side and in the subsequent screen, QuickBooks will nowadays all our transaction data to us as it has been interpreted. You lot'll see the matching dates, descriptions, and amounts and if everything looks good, yous can click next and begin the import.

If everything looks skilful, nosotros take the import by clicking "permit's go."

We however have some piece of work to practice subsequently nosotros finish the import as these items do non become put abroad automatically. We'll be able to confirm this by looking at our Piddling Greenbacks tile in our register list. The dollar value for Lilliputian Cash is still zero and we have 44 items in our to-exercise list.

And then there you lot have it! Now you know how to batch import your transactions into QuickBooks Online from a banking file. The remaining steps on how to process these transactions now that they're in QuickBooks can be found in my How to Code Cyberbanking in QuickBooks Online article.

If y'all'd like to see a video walk-through of this information, delight see beneath.