Cash deposit creates duplicate transaction in bank feed

The Sage help reccommends recording cash till sales in a separate 'bank' and then using the Deposit function to record when some of that cash is taken to the bank. That’s fine, but there is of course already a transaction in the bank feed because it syncs with the bank account.

A simila problem exists with payroll – Sage posts a lump sum for the payroll but then I also have all the bank transactions for each member of staff, so duplication again.

It is supposed to work like this, am I doing something wrong?

  • 0

    Hi Jamie

    Thank you for contacting Sage City

    Firstly recording Cash Receipts into the Cash account (think of it as your safe) and then recording a ‘Deposit to Bank’ is the correct way to record these transactions as this is effectively what happens in real life, you would then match the bank feed to the deposit.

    Secondly when you run the Payroll the posting to the accounts is the total value of the employee net wages posts to the selected bank account in the settings. When your bank feed brings in the transactions from the bank then these will show as each employee.

    You have 2 options, delete the employee wages from the bank feed, or, change the integration settings so the payroll posts everything on the salary journal apart from the banking element (select the ‘Post employee net wages to liability account’ option) and then record the employee wages from the bank feed.  If you need any assistance with this then please do call us on 0191 479 5911 and we will be glad to help 

  • 0 in reply to Geoff Davidson

    Thank you, I think I’m getting the hang of it now.