Tips on how to convert CSV to QBO

Quickbooks is an accounting software program that helps small and medium companies carry out monetary operations comparable to expense monitoring, reconciliation, and invoicing. Quickbooks imports transaction information from uploaded financial institution statements to carry out monetary operations.

So as to import transaction information, financial institution statements must be uploaded in Quickbooks supported codecs comparable to Quicken (QFX), QuickBooks On-line (QBO), Quickbook Supported CSV, or Microsoft Cash (OFX).

Nonetheless, in case your financial institution statements are in a format not supported by Quickbooks comparable to CSV, PDF, or XLSX, you can not import your transaction information straight.

It’s worthwhile to convert them to Quickbooks supported format in order that they are often uploaded into Quickbooks. Therefore, on this weblog, we’ll take a look at strategies to transform CSV to Quickbooks supported codecs.

Tips on how to Convert CSV to Quickbooks Supported Format

We are going to take a look at strategies that can permit us to import transaction information from financial institution statements in CSV to QBO or Quickbooks supported codecs. Let’s take a look at these two strategies:

Manually changing CSV to QBO utilizing Microsoft Excel/Google Sheets

Google Sheets/ Microsoft Excel don’t permit changing CSV to QBO format. Nonetheless, we are able to simply convert incompatible financial institution statements in CSV format to Quickbook supported CSV format. This is how you are able to do it:

1. Open a clean google Spreadsheet by clicking right here.

2. Import your financial institution assertion to google sheet by clicking on File->Import adopted by importing your financial institution assertion.

3. The financial institution assertion seems just like the picture under. Take away all extra textual content aside from the financial institution transaction desk.

4. Quickbooks helps CSV in solely two codecs. Therefore, we’ll modify our CSV in one of many codecs. Be sure that the column headers have the identical title.
   a. Three-column format: This has date, description, and quantity.
   b. 4 Column Format: This has date, description, credit score, and debit.

5. Submit modification, the sheet will seem like this. Now we have eliminated extra columns and have named the headers in accordance with the QBO format.

6. Modify the date column to make sure that it’s in dd/mm/yyyy format. Choose all of the dates and click on on Extra Codecs (123 icon) -> Date dd/mm/yyyy format.
   NOTE: If you don’t see this selection explicitly then click on on Extra Codecs (123 icon) -> Customized Date and Time. A window will open. Specify the date format as dd/mm/yyyy and click on on Apply.

7. The financial institution assertion is now appropriately formatted. Obtain it as CSV and add on the Quickbooks platform

8. If you happen to see an error, make sure that you:

   1. Take away any zeros (0) from the file. Depart these cells clean.
   2. Appropriate any transactions that show numbers within the Description column
   3. Ensure that the dates are in one format.
   4. Some banks add the day of the week within the Date column (for instance, 20/11/2018 TUE). It’s worthwhile to take away the day of the week.

Changing CSV to QBO with Nanonets

The above technique is appropriate for one-time use. If it’s worthwhile to add recordsdata each day to Quickbooks, then it’s higher to automate conversion of CSV to QBO with Nanonets. Nanonets can seamlessly extract information from financial institution statements and export it to Quickbooks. 

Right here’s tips on how to convert a financial institution assertion (Quickbooks On-line/Desktop) utilizing Nanonets.

1. Join free on app.nanonets.com. No bank card is required.

2. Click on on New Workflow->Financial institution Assertion. Your mannequin might be created. Click on on Add to add your financial institution assertion (in PDF or XLSX). You can too arrange auto-forwarding through e-mail to mechanically add your financial institution statements to Nanonets.

3. Nanonets’ highly effective OCR extracts the info from financial institution statements.

4. Click on on Again->Workflow->Last Outcomes to pick out the fields to export to Quickbooks.

5. Choose Date, Description, Debit, and Credit score fields from the Last Outcomes.

6. Go to the Export part and click on on Browse all export choices. Choose Quickbooks from the window.

7. Title your integration and click on on Configure in Workflow.

8. Register to your Quickbooks account and comply with the directions to setup the Quickbooks integration.

9. That’s it! Now you can mechanically export financial institution statements to Quickbooks with none problem.