Hi Carol,
If you are using Sage 50 Pro - in the bank module if you look at the left side of screen there should be a section called Cash Register.
When you click on this it will ask you to set it up - just follows the prompts. I am unsure if this facility is in the basic Sage 50 Accounts but if not you can just setup another Bank in the Chart of Accounts using a nominal code starting with 1 and call it Cash Register.
Once the Cash Register has been setup:
Do a bank transfer from Cash Register to your normal bank account for every pay-in - for cash/cheques paid into bank use the number of the pay-in as the ref. For credit/debit card receipts the ref I use is POS (for Point-of-Sale) with the date applicable so for card receipts on 30 Dec my ref would be POS3012.
At the end of the month when you get the sales report:
Enter the sales as a Bank Receipt to the Cash Register which will allow you to enter the monthly 20% Vat items separately showing the net figure and the Vat using code T1, then the same for 5% using code T5 and anything zero rated would be T0 and if you have exempt sales then T2.
This will post the sales and the Vat into the correct section of Vat Return.
Providing all the sales and cash etc received as payment have been rung up correctly on the till then your Cash Register in Sage should be back at zero. However mistakes do happen and provided you have been notified of an error by staff then you can adjust the sales figures prior to posting the monthly figures to the Cash Register.
I usually check the amount showing in Cash Register agrees with the monthly sales totals and do the adjustments on the month-end report prior to posting the sales in sage. Sometimes there will be a Cash Shortage or Overage which I post to a nominal code starting with 8 so that the Cash Register is back at zero ready for the next month.
I hope this makes sense to you and you can understand. If not feel free to email me and I will send you my phone number:
mms@mmauran.plus.com
Marilyn
|