Skip to main content
June 11, 2019
Question

I receive a email transfer for full or partial payment of invoice. How to specifically reconcile to proper account? Quickbooks options are not clear

  • June 11, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 11, 2019

Hello Brent,

 

When you receive a customer payment, you can deposit it directly to your bank account or to the Undeposited Funds account.

If you choose the Undeposited Funds account, you'll need to create a bank deposit:

  1. Click the Create menu (+) and select Bank Deposit.
  2. Select the bank account in the Account field.
  3. Enter the deposit date.
  4. Under the Select the payments included in this deposit section, mark the customer payment.
  5. Click Save and close.

Once you've deposited the payment, it will now affect your account register. This should also show when you reconcile the said account.

You can use this general article to know more about reconciliation in QuickBooks Online: Reconcile Hub.

 

If you have more questions about this, you can provide additional details and screenshots. This would help us know what steps we can do to fix your problem. Thank you in advance!

 

Whaia Trading
May 17, 2020

Hi, new to Quickbooks!   Quickbooks, Square and our Bank Account all linked.  All going well,  bank account was in balance until received some etransfer payments (for full payment) from customers.  We raised invoice in Square and customer sent payment by etransfer.  Funds were auto-deposited into the Bank Account. The Square invoice were marked as Paid by Cash (etransfer isn't an option), so in Quickbooks invoice shows as "Paid (Not Deposited)".  Reading thru all the Q&A and help, I proceeded with doing a bank deposit for the transactions, however Quickbooks treated as double payments, since we already have deposit transaction from our linked bank account.  Having deleted this deposit, bank account is now reconciled and balanced.  So in order to clear the invoices in Quickbooks, and stay in balance, should I do the deposit, and then "exclude" the bank deposit transactions from the bank reconcilliation?  I don't like the idea of excluding anything, so is there a better way to clear off the "Paid (Not Deposited)" invoices?  ..... thanks for your help, appreciate it  :-)     

AddieC
May 18, 2020

Hi Whaia Trading. You're exactly right! If you run into duplicates in your bank feed, you'll simply Exclude one as you've mentioned above. It sounds like you've got a good grasp on the software so far. It can be a bit tricky when working with third-party apps, so if you ever need further assistance, our tech support team would be happy to help.