First Previous - Page 1 of 1 - Next Last

Help needed please. What is correct procedure?

  • 77 posts
  • # 96705

Hi

im currently employed and have taken on the books of a pharmacy business. They are VAT registered and each month we claim back a significant amount of VAT. 

I'm just not sure if the way I am recording takings is correct. 

 

Not ot all sales are VATable so therefor if cash takings were say £100 I can't  put that in as T1 as it's not a straight 20% on sales. So maybe only £5.50 is VAT

The only way at present I get to record sales is when I do the weekly bank reconciliation. So from the bank statement I can see Cardnet sales each day. Then when the manager banks any cash takings I can see this on the statement too. 

 

At at present I have been entering all these amounts and putting T9 so that no VAT is recorded. (From Cardnet sales I wouldn't know how much if any VAT It includes)   THEN at end of the month the manager prints off a till printout for that month. It tells me how much VAT the monthly sales included so I journal this amount to VAT sales tax control account. This then is included in box 1 of my VAT return. 

my question is, basically is this the incorrect way to do this whole procedure? When it comes to the VAT RETURN I can see the VAT amount in box 1 but the net sales don't end up in their box (presumably because I enter them as T9!) 

 

How should I enter the sales? Is it ok to Enter them as T1 but then alter the VAT column to 0.00. And then do my journal at the end of the month as normal? 

how do,other retail business deal with this situation if the VAT isn't a straight 20% on all sales? 

Sorry if this sounds basic but I really want to get this correct. The manger refuses to do daily till reconciliations which doesn't help. 

ANY help would be greatly appreciated,

carol

  • 794 posts
  • # 96706

Hi Carol,

Are you using Sage software?

If you are, do you have the Cash Register facility within the bank section?

If you are I can advise the way I currently process sales/banking for a supermarket which has

lottery, paypoint etc!

Let me know and I will respond by return.

Marilyn

 

  • 77 posts
  • # 96708

Hi Marilyn

Yes I use Sage 50 at work. Not sure I've seen the cash register facility? But maybe it's there and I've Just not ever noticed it!

 

any help would be appreciated

thanks

Carol

  • 794 posts
  • # 96709

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


  • 160 posts
  • # 97385

Hi Carol,

I would normally if I didn't know the vat amount I would either not put them in until you get a report that shows all the vat amounts or enter the sales as t9 and then journal the vat into the control account and the vat liability account,

Kind Regards

Paula Welsh

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading