Account Reconciliation import

SUGGESTED

I am trying to figure out this bank reconciliation process in Sage. I'm coming from Xero so I think I am having a hard time due to having the old systems' process stuck in my head.

When importing a bank statement, Sage attempts to 'Autoclear' records but none do so. As a result Id have to either 'Manually Match' or 'Create a new' entry?

I am used to having a bank statement list and an Account transaction list of live system transactions, then I match the two.

Currently, Sage shows all of my imported transactions with the red flag as a 'new bank record' showing the source as 'bank'. BUT.... it won't (90% of the time) match  records to existing transactions. Many times I have a deposit with prepayments as well as payments for live invoices so I have to make 2 separate 'receive money' entries.

What am I missing? 

Is there just a lot to be desired in the account reconciliation functionality?

-Collin

Parents
  • 0
    SUGGESTED

    You can group multiple Receive Money entries into one deposit by giving them the same Deposit Ticket ID. You can either do that manually in the Receive Money window, or you can use Select For Deposit (in the Tasks menu) to choose receipts from a list and assign them all the same Deposit Ticket ID. Once you have the receipts grouped correctly into deposits, the individual receipts won't show on the  the bank rec, just the actual deposit amounts. That should allow you to match the imported deposits with the deposits in Sage 50.

    One caution, NEVER repeat a deposit ticket ID. Even if a deposit ticket was used in a prior year Sage 50 will still try to group the old items and the new items together into one deposit on the bank rec.

  • 0 in reply to StephenC

    Stephen, Thank you. I didn't even know that was a function as the training guides hadn't listed...or i missed it. Unfortunately it didn't really help. Are bank rec's really this cumbersome in Sage 50? I don't really need to create deposit tickets unless a check we receive contains invoice and prepayments?

Reply
  • 0 in reply to StephenC

    Stephen, Thank you. I didn't even know that was a function as the training guides hadn't listed...or i missed it. Unfortunately it didn't really help. Are bank rec's really this cumbersome in Sage 50? I don't really need to create deposit tickets unless a check we receive contains invoice and prepayments?

Children