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

Matching Integrated Retail Sales with Bank Deposits

Ok, here is my problem that no one seems to be able to help me with... My retail POS system exports my daily sales into QB at the close of the day. This is imported in the following way:

Total Daily Sales - imported as an Invoice and is debited into AR

The broken out payment methods are also imported and are applied as 'Deposits' against those invoices (cash, debit, credit). These deposits credit AR and debit my sales and GST accounts. All good so far. My problem is this - QB is linked to my bank accounts. So QB pulls in my actual bank deposits (perfect, as I need them in order to do my bank rec), but the 'Deposits' that QB is applying to the 'Invoices' are ALSO going directly into my bank register. So I am getting duplicate payments showing up in my bank register. Here is my question - is there not a way to 'Match' these QB auto deposits in the 'Bank entries to review' section (or another way) with the actual physical bank deposits? I've turned off 'Automatically apply credits' but it hasn't made a difference.

7 Comments 7
LeithG
Level 7

Matching Integrated Retail Sales with Bank Deposits

Hi GreePeaceHempire:

 

From the banking tab, under Rules, are there any rules setup with Deposits and a check mark under the 'Auto-Add' column?  This might be why items are auto-posting instead of letting you do a match to existing transactions.

GreenPeaceHempire
Level 1

Matching Integrated Retail Sales with Bank Deposits

No, that's what I thought too.  But I have no rules set up at all for deposits....

LeithG
Level 7

Matching Integrated Retail Sales with Bank Deposits

Okay, are there any rules at all with Auto-Add checked? maybe you could post screenshots of any of those rules and see if one of them is the culprit?  Maybe it was just poorly named and is responsible even if it seems like it shouldn't be?

GreenPeaceHempire
Level 1

Matching Integrated Retail Sales with Bank Deposits

Here they are... 1 of 2 pics

GreenPeaceHempire
Level 1

Matching Integrated Retail Sales with Bank Deposits

2 of 2....

LeithG
Level 7

Matching Integrated Retail Sales with Bank Deposits

So these 11 are the only ones marked Auto-Add in the whole thing?

Might be worth giving support a shout if so.  Something is posting these transactions and if it's not a banking rule, I'm for sure stumped.

GreenPeaceHempire
Level 1

Matching Integrated Retail Sales with Bank Deposits

I uploaded 2 pics, so there's a few more...but still, I can't see anything either.  I've been on the phone with support SEVERAL times, and they haven't been able to help me.  That's why I thought I'd reach out to the community.  Thanks for trying though!

Need to get in touch?

Contact us