Importing / Integrating Paypal with QuickBooks Desktop

Published on 29 Jan 2020 / In Accounting & Finance Software

** COMPLETE GUIDE by Hector Garcia, CPA
When using QuickBooks Pro, Premier, Accountant or Enterprise Editions, there are essentially 4 ways to import or integrate PayPal Transactions

00:00:00 – Intro (multiple methods to import paypal) (manual data entry, batch enter transactions from .CSV file, import IIF file, use bank feeds (2qbo convert pro tool)
00:01:29 – Manual data entry (step by step)
00:03:11 – Chart of accounts (PAYPAL)
00:04:31- Batch enter transactions
00:04:49- Accountant (batch enter transactions) (split deposits with payments, sort by gross amount, csv file) (start with the checks in QuickBooks Desktop)
00:07:05 – Customize columns
00:07:24 – Copy /paste checks from CSV file to QuickBooks Desktop (create vendors, categorize accounts)
00:09:06 – Deposits in QuickBooks Desktop (batch enter transactions) (copy/paste from CSV file to QuickBooks Desktop)
00:10:49 – Banking (reconcile) (begin reconciliation)
00:11:17 – Paypal (check transaction by transaction and reconcile)
00:11:34 – CSV file spreadsheet problem (options in paypal, pdf – all activity)
00:13:11 – Importing IIF file (step by step) (example)
00:14:29 – File tab (utilities, import, IIF files)
00:14:54 – Chart of accounts
00:15:20 – Edit account
00:16:11 – Reports (profit & loss) (report data)
00:17:00 – Write checks (reclassify accounts)
00:17:10 – Accountant (client data review, reclassify transactions)
00:17:43 – Use paypal bank register
00:18:07 – Lists (other names list)
00:18:32 – Using .QBO file as bank feeds (online banking) (how it works) (example)
00:20:00 – 2qbo convert pro tool (how it works) (bank feeds, matching, rules) (step by step) CSV or QIF to .QBO conversion, software is $249

Show more
0 Comments sort Sort By

Up next