IMPORTING BANK STATEMENTS INTO QUICKBOOKS USING PDF BANK STATEMENTS OR CVS FILES

Description: 

In this video we show you how to import bank statements into QuickBooks and how the tools like 2QBO Convert Pro works to convert from PDF bank statements or CSV bank statements into QuickBooks format

 

Video:


 

Table of contents:

 

  • 00:00:00 – Introduction (how to download bank transactions into QuickBooks).
  • 00:00:48 – File formats from the bank (.QBO file, CSV file, QIF file, PDF bank statements) and explaining each one of them.
  • 00:03:02 – Chase bank example to download a type of file (step by step) (QBO, CSV, QIF).
  • 00:06:04 – After downloading the file you choose, search your file by the name of the one you download and open it.
  • 00:06:42 – Access to QuickBooks online and convert the file from different formats (QBO in this case).
  • 00:06:44 – How to upload the file in QuickBooks online (go to transactions, banking and click on file upload, then choose the file clicking on browse and importing it from downloads, hit next and select the bank account that you want to connect).
  • 00:07:54 – Categorizing accounts on QuickBooks online.
  • 00:09:06 – Explaining the same process to upload the file but in QuickBooks Desktop (steps: file menu, utilities, import, web connect files, import your .QBO file).
  • 00:10:38 – Categorizing accounts QuickBooks Desktop.
  • 00:11:23 – PDF bank statements (could be an original PDF downloaded from the bank account or scanned PDF from paper bank statements).
  • 00:12:12 – How do you know when a PDF is an original version from the bank.
  • 00:12:37 – Tool 2QBO convert pro and how it works.
  • 00:17:09 – Difference when the PDF has been scanned from the bank statement.
  • 00:17:48 – PDF plus version (tool that can read scanned statements).
  • 00:19:25 – How to manually add payments in case the program misses a payment.
  • 00:19:51 – CSV or Excel files (obligatory 3 columns: date, payee, amount) and how it works.
  • 00:22:40 – Options.
  • 00:23:55 – Convert software website.
Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published. Required fields are marked *



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022