Where's a good place to hire a good quicbooks specialist to reorganize all my transactions for the past month and a half?

louisgeorges2000 · ‎February 15, 2019

I just started to use quickbooks and I was using paypal for invoicing so my clients could use the "pay now" button. But I just realized how difficult it is to match my paypal transactions with my customer's activity feed on quickbooks and turns out I was adding them as sales receipts. Quickbooks was adding all those paypal sales as income on top of the money I was transfering from paypal to my business bank account so now it shows I have double the income I'm suppose to have. I tried to delete them but it won't let me and if I try to create more transactions to rectify everything I'm just gonna dig myself deeper into that hole. Is there a way to hire a quickbooks specialist for just a few hours and go over all my transactions for the past month and a half? There's not that many.

JonpriL · ‎February 15, 2019

Good day, @louisgeorges2000!

You can unmatch and exclude your banking transactions to delete them. I'm here to help you how.

Go to the Banking page.
Under the In QuickBooks tab, put a check mark on the checkbox of each transaction you want to unmatch.
Click Undo.

Once done, you have the option to exclude and delete each banking transactions.

Let me show you how:

On the Banking page, click For Review tab.
Select the checkbox of each transaction you want to delete.
Click Batch actions.
Choose Exclude Selected.

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.

View solution in original post

Kristine Mae · ‎February 17, 2019

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.

View solution in original post

louisgeorges2000 · ‎February 15, 2019

Can I delete all the "banking" transactions without deleting my invoices and start over from scratch?

JonpriL · ‎February 15, 2019

Good day, @louisgeorges2000!

You can unmatch and exclude your banking transactions to delete them. I'm here to help you how.

Go to the Banking page.
Under the In QuickBooks tab, put a check mark on the checkbox of each transaction you want to unmatch.
Click Undo.

Once done, you have the option to exclude and delete each banking transactions.

Let me show you how:

On the Banking page, click For Review tab.
Select the checkbox of each transaction you want to delete.
Click Batch actions.
Choose Exclude Selected.

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.

louisgeorges2000 · ‎February 16, 2019

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?

Kristine Mae · ‎February 16, 2019

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:

Click Accounting, then choose Chart of Accounts.
Choose the bank, then click View register.
Look for the deposit, then click to open the transaction.
Click Delete.
You'll receive a message, "Are you sure you want to delete this transaction?", choose Yes.

Now, delete the Paypal sales receipts.

Let us know if you need more help. We're right here for you.

louisgeorges2000 · ‎February 17, 2019

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. :)

Kristine Mae · ‎February 17, 2019

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.

louisgeorges2000 · ‎February 17, 2019

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!

Joyce_P · ‎February 17, 2019

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!

Topics

Training

Community

Resources

Where's a good place to hire a good quicbooks specialist to reorganize all my transactions for the past month and a half?