Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowSolved! Go to Solution.
Good day, @louisgeorges2000!
You can unmatch and exclude your banking transactions to delete them. I'm here to help you how.
Once done, you have the option to exclude and delete each banking transactions.
Let me show you how:
Right after excluding your banking transactions, go to the Excluded tab. Click Batch action choosing Delete to delete your banking transactions. Please know that deleted banking transactions cannot be downloaded again.
Here's an article to learn more about the steps:
You might also check this handy article for future reference: How to Upload More Than 90 Days of Bank Transactions?
I'll be always around to help you if you have any other concerns.
Hello there, Louisgeorges2000.
As what they say, when you're making money, then your business is doing good.
Also, thanks for providing us with more information. Regarding your main concern, when the transactions are downloaded from the bank, these payments have been deducted with the Paypal fee already. This is the reason why you're unable to match them to the invoices.
When you receive the invoice payments, deposit the money to the Undeposited funds. On the Bank Deposit page, add a Paypal fee (expense) to deduct it from the amount. This way, you can match the transactions on the Banking page. Please check the screenshot as your reference.
You'll have to undo the transactions so it will go back to the For Review tab. Once you're done adding the paypal fee in the payment, you'll be able to match the transactions already.
Please leave a comment below if you need more of our help. We'll get back to you as soon as I can.
Can I delete all the "banking" transactions without deleting my invoices and start over from scratch?
Good day, @louisgeorges2000!
You can unmatch and exclude your banking transactions to delete them. I'm here to help you how.
Once done, you have the option to exclude and delete each banking transactions.
Let me show you how:
Right after excluding your banking transactions, go to the Excluded tab. Click Batch action choosing Delete to delete your banking transactions. Please know that deleted banking transactions cannot be downloaded again.
Here's an article to learn more about the steps:
You might also check this handy article for future reference: How to Upload More Than 90 Days of Bank Transactions?
I'll be always around to help you if you have any other concerns.
OK, I'm making some good progress. All my banking transactions are reconciled and the balances and fees match.
But all those paypal sales receipts still shows up in my "all sales" tab and when I tried to delete them I get this message" This transaction has been deposited. If you want to change or delete it, you must edit the deposit it appears on and remove it first."
How do I delete them?
Hello there, Louisgeorges2000.
The payment has been deposited already in your bank account. We'll have to delete the deposits first before we can proceed with deleting the sales receipts.
Here's how:
Now, delete the Paypal sales receipts.
Let us know if you need more help. We're right here for you.
I deleted a couple just to test it and my "all sales" report did go down but my paypal bank balance and my paypal "in quickbooks" got all out of sync.
I guess those transactions are supposed to be there, I'm just not marking them correctly. I'm logging them in as sale, should I mark them as something else?
FYI I'm using paypal merchant to run my clients' credit cards and when I see the transactions on my banking tab I just click add.
UPDATE: I just looked at my net income for last month and compared it to my account balance for that month plus the money I paid myself and it's pretty close. Maybe I am making that much money. :)
Hello there, Louisgeorges2000.
As what they say, when you're making money, then your business is doing good.
Also, thanks for providing us with more information. Regarding your main concern, when the transactions are downloaded from the bank, these payments have been deducted with the Paypal fee already. This is the reason why you're unable to match them to the invoices.
When you receive the invoice payments, deposit the money to the Undeposited funds. On the Bank Deposit page, add a Paypal fee (expense) to deduct it from the amount. This way, you can match the transactions on the Banking page. Please check the screenshot as your reference.
You'll have to undo the transactions so it will go back to the For Review tab. Once you're done adding the paypal fee in the payment, you'll be able to match the transactions already.
Please leave a comment below if you need more of our help. We'll get back to you as soon as I can.
I'm still struggling to make the math add up. I went ahead and added up all the money I transferred from paypal with the fees, the checks from my clients I deposited to my business bank account on top of all the money I invested to cover payments when I started the business.
This is what it looks like.
And this is the report from quickbooks, it doesn't seem to match.
I can't make heads or tails from this report. The paypal sales are too low. Does this adds up?
I'm seriously considering going to Upwork and hiring a quickbooks accountant to go over this to make sure it's right. Any ideas would be greatly appreciated. Thanks!
Hi louisgeorges2000,
Let's match the Profit and Loss report and Paypal transactions. To do that, you'll have to run a Profit and Loss report and make the Report period as This Month. Then, let's pull up the Paypal transactions. This way, we can identify what is causing the matching issue.
Also, I'd encourage consulting for a ProAdvisor so they can advise you on how to deal with the transactions from Paypal that aren't matching in QuickBooks.
Keep posted if you need anything else. Have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.