Bank download matching transaction

SUGGESTED

I use the download bank transactions and then find the matching transactions.  Why can't I check off multiple transactions to balance to a deposit or EFT payments.

  • 0
    SUGGESTED

    Denise:

    To match transactions using the download banking transactions, you must understand a single bank deposit with several clients deposits will not match. The only way is to match everything you can, then close the matching window and go directly to the bank reconciliation screen and manually check off those deposits which correspond to the actual deposit(s).

  • 0 in reply to Agate

    Well maybe this is something sage should work on.  Seeing as lots of people use the Batch EFT uploads.  It shows one payment in the bank, but multiple transactions belong to that one payment.  Just a suggestion.  Thanks for your response.

  • 0 in reply to Denise Schneider

    to match exactly to the bank you will have to use a clearing account for your batch deposit or withdrawl then do a je to move it from the total from the operating account.  this has been brought up and its not at sage level its is at user level to understand the batch depositing will cumulate to one one however your entries also need to be as one to match.  we do single deposits so it does match and if there is keying error then it easily found which ar cheque is wrong.  the only thing that will not auto match is credit card as they do daily deposits and they are batched.  

  • 0 in reply to Agate

    Not sure if this would help you at all, but I have found that if I input all of the deposits from the payment service like "Global payments" in one general journal post for the entire month, if I make sure that after each line item that credits revenue I then debit the bank that matching amount on the next line, the matching transactions module will capture these as separate transactions and match them properly. Now that I think of it, this is the opposite issue than what you are having and I have not found a work around for that other than remembering or writing myself a note to make sure that I realize that one transaction is actually transaction A,B & C in Sage.

    This is an issue that I wish they would make an option for, so that we could move along more smoothly.