cancel
Showing results for 
Search instead for 
Did you mean: 
LM3
Not applicable

Paid (not deposited)

How do i reconcile the "paid (not deposited)?  Is there an itemized daily report that i can run for my merchant charges that went to my bank?

7 Comments
Moderator

Re: Paid (not deposited)

Thank you for dropping by the Community, LM3.

 

I want to make sure this is properly addressed to you.

 

To reconcile that paid transactions, you need to record it first in QuickBooks as deposited before you reconcile.

 

Here's how:


   1. Go to Gear icon on the upper right.
   2. Under Your Company, click Account and Settings.
   3. Click on Payments on the left menu bar.
   4. Choose the proper bank account in the Where should we record Payments deposits? section.
   5. Click Save.


Once done, you may follow these article on how to Reconcile Accounts.


And for your second question, yes, there is a report that you can get for your merchant charges. You can download it through the Merchant Service Center.


Here's how:


   1. Sign in to Merchant Service Center.
   2. From the menu, choose Activity & Reports then select All Statements.
   3. Locate the month you want to see and click either View to open the statement in your browser or Download to save the statement on your computer as a PDF file.


You can also check this article for future references:


Search for deposits or fees in the Merchant Service Center


Feel free to reach out to me if you need anything else. I’ll be right here for further assistance.

Community Contributor *

Reconcile Quickbooks payments with deposits

The Quickbooks payments itemized deposits reports are only available in  US. 

I was told by Quickbooks merchant, there is no any report can tell you 

the itemized details of any deposit.

Hope it can be fixed soon.

For the time being, does anyone know how to reconcile the Quickbooks payments deposit with the invoices paid.

 

QuickBooks Team

Re: Reconcile Quickbooks payments with deposits

Hi there, JiongGao.

 

Thanks for joining the thread. I'm here with some insight to provide regarding your question about reconciling the QuickBooks payments deposit.

 

To clarify, is the deposit equivalent to the sum of all the invoice payments? If so, then you can go ahead and match these transactions. The steps below will guide you through the process:

 

To match downloaded bank transactions

  1. Click Banking in the left navigation menu.
  2. Select the transaction (deposit).
  3. Choose the Find other records or Find match button to open the Match transactions window.
  4. Change the From and To dates to make sure every invoice payment will show up.
  5. Make sure to select all of the invoice payments.
  6. Verify that the total of the selected transactions is the same as the amount of the downloaded transaction.
  7. Click Save.

Once you're done, I would recommend you check out the helpful article my colleague provided on how to reconcile accounts.

 

Lastly, I want you to know that your voice matters and I'm also looking forward to when the Itemized Deposit Report will be available for you. That said, I'm submitting feedback on your behalf. Feedback is sent to the Management Team to determine what we need to implement moving forward to provide the best QuickBooks experience.

 

Please know that I'm always here to provide help and answer any questions that you may have, so don't hesitate to reach out to me again. Thanks for coming to the Community, wishing you and your business all the best.

Community Contributor *

Re: Reconcile Quickbooks payments with deposits

Thank you for your reply.

Here is my frustration now:

Nov 7 2018 there is a deposit of $2398.

I have no idea of know the details of this deposit.

I open up Find other records 

And I go to the lower portion which is for quickbooks payments.

But, I have no way knowing for sure which invoice payments to select.

Since there is no report to confirm the details of this $2398.

I was told by merchant service, the reports are only available in US, NOT for CANADIAN.

 

Hope someone can shed some lights on this issue.

So far we need to go back to Oct 2018 to verify the deposit reconciliation, since there are about 10 invoice payment marked Quickbooks payments, but still in undeposited fund.

 

 

QuickBooks Team

Re: Reconcile Quickbooks payments with deposits

Hello there, @JiongGao.

 

Thank you for reaching out back to us and providing more details. I can help you search and match transactions on your Banking page.

 

Aside from the deposit amount and date, you can also use other information to help you search and match the transaction. My recommendation is you go to your Merchant Services Center to get more details:

  1. From the Activity & Reports menu, select Transactions.
  2. On the search field, enter the amount or date of the deposit.
  3. Scan through the result and get the other important details such as name, card type, and such.

For more information, please refer to this article: Search for transactions in the Merchant Service Center.

 

After getting the details, go back to your Match Transaction page and use those information in finding the transaction. 

 

 

That should get you going today, JiongGao. I'm still here to offer additional help if you have more questions for me. You can tag my name or leave a comment below. Have a good one.

 

Community Contributor *

Re: Reconcile Quickbooks payments with deposits

The merchant center is not available in Canada

Highlighted
QuickBooks Team

Re: Reconcile Quickbooks payments with deposits

It's good to have you here again, @JiongGao.

 

Allow me to step into this conversation and get you pointed in the right direction to get assistance with your deposit concern. 

 

To trace the deposits that are showing into your account, I'd suggest reaching out to our Customer Care Team. This team is the best resource for such inquiries as they're able to pull up your account securely while the Community is a public forum. 

 

They have the necessary tools to check on the transaction that was entered and received by QuickBooks Online. 

 

Also, here are some articles that you can check out about the QuickBooks Payments for Canada for your future reference:

This should get you on the right track.

 

Please let me know if you have any other questions about QuickBooks Payments or any QuickBooks concern. I'd be pleased to help you out. Have a nice day.

Need to get in touch?

Contact us