Skip to main content
G
GreenPeaceHempire
October 19, 2020
Question

Matching Integrated Retail Sales with Bank Deposits

  • October 19, 2020
  • 1 reply
  • 0 views

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.

1 reply

LeithG
LeithG
October 19, 2020

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.

G
GreenPeaceHempireAuthor
October 19, 2020

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

LeithG
LeithG
October 19, 2020

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?

Terms & ConditionsAccessibility statement