Get the course, "Bulletproof Bookkeeping® Mastery Course with QuickBooks Online"
nerdyurl.com/B...
And register to get notified about my upcoming eCommerce Course,
"Bulletproof Bookkeeping® Course with QuickBooks Online for eCommerce"
nerdyurl.com/e...
Index
1:23 SaasAnt better application to reconcile downloaded PayPal statements
2:15 Video begins with data
2:34 Quick formatting, bolding titles, dates, formats all on the excel sheet
3:10 Ctrl + S , saves your changes
3:50 Getting rid of negative numbers, focus on money in, sort by description
5:15 Important to note
5:47 All payments will get mapped to a single item, deposits into PayPal
6:36 Deal with money out now,
7:45 Anything with fees associated will go to PayPal fees account
8:00 Remove duplicates in CSV
8:30 Alt + down arrow will give you a drop down in excel
9:00 Payment reversal could be a refund or a payment reversed that you did
9:39 Last thing of money out, for import purposes multiply negative number by negative one
11:15 Sales receipt, Seth already has a saved mapping but the key is to choose the option
multi line mapping for multi column.
12:15 If you are looking for something you click inside and type what you are looking for
13:13 Seth uses the default empty columns, uses for the customer "PayPal payments"
13:29 Second empty column he will add in PayPal clearing
14:40 In order to create the right audit trail
15:52 Next step gives you a preview of what it looks like
16:29 Interface on SaasAnt, lets you know exactly what its working on
17:20 When you have mapping saved, system allows you to reconcile in 5 minutes
17:35 Shows you what has been completed, choose the next one for it to complete
18:30 reviewing the preview for money out
20:44 Shows you the errors clearly
21:36 New import, recent uploads, warns of duplicate file and continue
22:31 What the deleter does, you can look at already imported files or go to QB Online Real time files
23:47 Reconcile, check that other deposits amount are in your transactions
25:30 Creating a bank deposit for clearing account PayPal holds
26:26 Difference in the reconciling for 437.07
27:13 Example of when you choose in PayPal to take the money directly out of your account
27:30 Stick the transaction in uncategorized for now then recode and review later
This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.
5 сен 2024