Issues with Sage bank transactions

Hi,

I am using Sage 50 Accounts and have an issue with my bank transactions.

I posted customer receipts and can see these transactions when I go to the transactions tab, I can also see them in the customer activity and if I pull a bank report - daybook customer receipts and summary the transactions show. The problem is when I view the bank account activity I cannot see the transactions, if I try to complete a bank rec the transactions do not show up. If I look at the summary page when I select the bank accounts I can see that the transactions are reflected in the bank balance however when I pull the activity the balance shows different?

Any ideas on what is causing this or what I can do?

  • Hi Sharan,

    Bank transactions in Sage 50 Accounts can grouped in the bank activity and the bank reconciliation area of the software in Sage Accounts. This means they won’t appear as individual transactions, but will contribute to the overall balance of the bank account and will also show in the relevant customer / supplier account.

    You can change the grouping settings at any time to suit your business needs in Settings > Bank Defaults.

    You can find full info on bank transaction grouping, including how to change these settings, here.

  • Hi Paul,

    These transactions have been entered as a customer receipt not the bank receipt batch function and also they are not on the same date I am missing transaction in the bank rec screen and the bank activity screen that cover a few months. I can see that on the face on the bank accounts summary that these transaction are reflected in the balance however when I pull the bank activity the balance shows differently.
  • Also Paul the grouped transactions options is not selected in my bank defaults.
  • Hi Sharan,

    As well as the items possibly being grouped, there are a few other different reasons as to why these transactions may not appear in the bank rec and the bank activity screens, e.g. dates posted conflict with dates entered in the bank rec and the bank activity screens, bank account posted to, search applied to bank account activity, etc.

    You can contact our Support team on 0845 111 5555 or via web chat and they’ll be able to carry out a full, in-depth investigation into this for you.