IMPORTING (COPY/PASTE FROM EXCEL) BANK DATA INTO QUICKBOOKS DESKTOP ACCOUNTANT

Description:

In this video we show you how to clean up the data before import, how to create an account to each transaction, how to copy/paste deposits from excel to QuickBooks and how to reconcile and reclassify transactions

 

Video:


 

Table of contents:

 

  • 00:00:43 – How to clean up the data before import.
  • 00:04:56 – How to split or separate my debits from my credits.
  • 00:06:53 – Select all the payees and come into QuickBooks to create all those payees as customers (step by step) and then the same process but as vendors.
  • 00:08:58 – Go to accountant menu, click on batch enter transactions and start with checks or bank debits (copy/paste checks/debits).
  • 00:12:10 – Create an account and copy down to put every single transaction to an expense account in this case (example).
  • 00:12:55 – Copy/paste deposits or credits from excel to QuickBooks.
  • 00:14:35 – Reconcile (steps: click on reports, company financial, profit and loss standard, dates, last fiscal year, then click on banking and begin your reconciliation process).
  • 00:16:12 – Reclassify transactions (income and expenses).
  • 00:21:08 – Profit and loss progress after reclassifying transactions.
Hector Garcia

Hector Garcia

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

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.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

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