The Book-keepers Forum (BKF)

Post Info TOPIC: Till discrepancies for retail company on Sage 50


Newbie

Status: Offline
Posts: 2
Date:
Till discrepancies for retail company on Sage 50
Permalink Closed


Hi all.

Please excuse my complete lack of knowledge on the subject. I'm not trained in accounts at all and have never had to do this before. My manager is away and i'm having trouble getting my head around the way i was shown to process till discrepancies at end of day banking for our retail stores. Put in the simplest terms as i'm a complete newbie at this, i need someone to clarify for me when a bank receipt is used and when a bank payment is used. So if one of our stores contacts me to say that their till was down by say £25.00 when they cashed up, then their end of day report would state that they took £25.00 more than they actually have to bank. In that scenario would i process the difference as bank payment or a bank receipt?

 

I'm sorry if that doesn't make alot of sense, as i say i'm flying blind here! Thank you in advance :)



__________________


Senior Member

Status: Offline
Posts: 259
Date:
Permalink Closed

Hi Sarahlou,

Till down - actual cash less than till roll total
Till up - actual cash more than till roll total

Accounting (ignoring VAT for simplicity)
Dr Bank Cr Sales with till roll total

The bank statement will record the actual cash lodged so:

  • if the till is down, you'll have to process a bank payment (Cr Bank Dr Sales or a special Till Discrepancy account) for the discrepancy
  • if the till is up, you'll have to process a bank receipt (Dr Bank Cr Sales or a special Till Discrepancy account) for the discrepancy

Then the bank in Sage and the bank statement will have the same aggregate amounts processed and will reconcile.

Hope this helps.

Regards,



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Sarahlou wrote:

Hi all.

Please excuse my complete lack of knowledge on the subject. I'm not trained in accounts at all and have never had to do this before. My manager is away and i'm having trouble getting my head around the way i was shown to process till discrepancies at end of day banking for our retail stores. Put in the simplest terms as i'm a complete newbie at this, i need someone to clarify for me when a bank receipt is used and when a bank payment is used. So if one of our stores contacts me to say that their till was down by say £25.00 when they cashed up, then their end of day report would state that they took £25.00 more than they actually have to bank. In that scenario would i process the difference as bank payment or a bank receipt?

 

I'm sorry if that doesn't make alot of sense, as i say i'm flying blind here! Thank you in advance :)


 If you are using Sage, you can create a cash discrepancies account.  You may be able to do this on any software, if you don't use sage.

Lets say till sales are £100 and only £90 was banked.  You have a cash receipt of £100, £90 is transferred to the bank, and £10 is paid to the cash discrepancy account, which is usually a cost to the company.

 

 



__________________


Newbie

Status: Offline
Posts: 2
Date:
Permalink Closed

Thank you so much, that was a huge help!! Just another one for you, again please excuse my lack of knowledge on the subject. But if one of our stores reports a till issue to me- in that the money they have to bank at the end of the day is all correct, but the Z-reading at the end of the day on the till has a mistake on it for whatever reason, do i still need to fix this on Sage even if there wasn't actually a money discrepancy?



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About