cancel
Showing results for 
Search instead for 
Did you mean: 
usertim2
Level 1

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

I've reconciled my bank accounts and equity and everything, but there is 1 temp checking account that QUickbooks payments have been entered into. And I don't know how to balance that in my books. Essentially it is double counting my income, but all my quickbooks payments are matched against invoices that I've sent out and marked as paid.
7 Comments 7
SarahannC
Moderator

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

Hello there, usertim2.

 

When you receive the invoice payment, use Undeposited Funds to post the amount. Once done, you make a deposit to post it to the right bank account. It will be tagged as one in the actual event. 

 

Since these are existing transactions, you can manually edit and change the payment to Undeposited funds.
ty.PNG

 

Once done, deposit it:

 

  1. Click (+ New) at the top-left
  2. Click Bank Deposit under Other
  3. Select which account in the Account dropdown to move the funds to
  4. Select the Payments to move using the checkboxes below
  5. Click Save and new at the bottom right.

 

Then, we'll have to link the deposit and the invoice:

 

  1. From the + New button, select Receive payment.
  2. Select the same customer.
  3. Select the Outstanding Transactions and the Credits.
  4. Click Save and close.

 

You can now then reconcile the account. Use this article for more information about reconciling your accounts:  Also, your Quickbooks payments should set up to Undeposited funds to avoid duplicates in the future.

 

Let me know if you have other questions. Take care always.

usertim2
Level 1

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

Thanks @SarahannC for your help and information. 

 

Unfortunately when I look at the Payment record I don't see a place where I can change the Account see attached

 

Also by your description, I think quickbooks payment is setting up the deposit already to my bank account, as I can already see that in 'deposits' 

 

Thanks again for the help, and let me know if you need more info! 

 

BettyJaneB
QuickBooks Team

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

I appreciate the additional details that you gave, @usertim2.

 

I'd like to ensure that you can reconcile your account smoothly. I want to ask for a screenshot of the payment that's showing up on your end. This can help me visualize and determine the root cause of this issue.

 

Please get back to me with the attachment, and we'll take it from there.

 

I'll be keeping an eye out for your response on this. Have a good one!

 

usertim2
Level 1

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

please see attached screenshot, all the paymenst look like this, missing the account Screen Shot 2021-06-02 at 10.43.18 AM.png

MaryLandT
Moderator

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

Thank you for the screenshot, usertim2.

 

I can guide you through how to change the account where payments are deposited in QuickBooks. 

 

You need to make sure payments and processing fees are recorded correctly by verifying the account selected on your settings. And, here are the steps you can follow:

 

  1. Go to Settings ⚙, then select Account and Settings.
  2. Select Payments from left the menu.
  3. On the Chart of Accounts section, select the pencil ✎ (edit) icon.
  4. For Where do you want to record payments?, choose the correct bank account.
  5. For Where do you want to record processing fees?, choose the proper expense account for tracking processing fees.
  6. Click Save, then Done.

 

After making the changes, you're now ready to process card payments for invoices and receipts.

 

In case you need to use other bank accounts, please browse this link to learn what types of accounts you can use: Change the account QuickBooks deposits payments into.

 

Now that your transactions are in QuickBooks, it's time to match and categorize them. The transactions go into your accounts after you review them.

 

Let me know if you have follow-up questions about your deposits. I'll be right here to provide the information that you need.

usertim2
Level 1

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

Ah! Ok, that seems to have worked for now. So I assume then that my bank records I'll just match to those payments and everything will be hunky dory? 

What do I do with all the items in that temp checking account? do I just delete them since they are duplicates? 

MaryLandT
Moderator

How do you reconcile the quickbooks payment temp checking account? right now it is double counting all my income that came from quickbooks payment

Yes, you're right that you'll match bank records with those payments posted on QuickBooks, usertim2.

 

For duplicate items, you need to delete them to prevent double entries in QuickBooks. Let me show you how:

 

  1. Go to Accounting from the left menu, then Chart of Accounts.
  2. Find the temp check account and click View register under the Action column.
  3. Locate the item and delete it.

If they're downloaded from the bank, you can simply exclude transactions. Follow this link for instructions and detailed steps: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Stay in touch with me if there's anything else you need with recording payments. I'll be around to help you.

Need to get in touch?

Contact us