Hi
Is there as way of setting up a default bank payment tax code. At present when transactions are posted via the bank feed, when you click on bank payment to create a match the default code is T1 (20%) obviously this is incorrect, for example when i am trying to create a wage payment. also when you change the TC it doesn't automatically change the net figure back to the gross figure, you can not also scroll down through the unmatched transactions to see the imported gross figure. manually adding together the net and vat element is not really feasible. is there an easier way i'm missing. Im using Cash accounting by the way.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Changing the VAT/Tax code in Bank Postings
-
- User
- Posts: 2
- Joined: 08 Mar 2018, 15:54
- Sage Version: v2018 24 UK/Europe/Africa
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Changing the VAT/Tax code in Bank Postings
Typically all bank transactions against accounts are non VAT so the default is normally T9
With Cash accounting this changes things as the VAT needs to be accounted for on the Receipt/Payment not the matching Invoice.
Bank feeds are a fairly new feature and may improve over time. You might like to feed back to Sage on this.
I have a custom importer for my bank statement, it changes tax codes depending on the account the monies came from/goes to. But I am very lucky as my bank (co-op) gives me the bank account no and sort code to use as a key to find the account, taxcode etc.
With Cash accounting this changes things as the VAT needs to be accounted for on the Receipt/Payment not the matching Invoice.
Bank feeds are a fairly new feature and may improve over time. You might like to feed back to Sage on this.
I have a custom importer for my bank statement, it changes tax codes depending on the account the monies came from/goes to. But I am very lucky as my bank (co-op) gives me the bank account no and sort code to use as a key to find the account, taxcode etc.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 2
- Joined: 08 Mar 2018, 15:54
- Sage Version: v2018 24 UK/Europe/Africa
Re: Changing the VAT/Tax code in Bank Postings
It just seems a really backward way of doing things when you use cash accounting, how can the bank know how the vat will be distributed? I have fed back to sage, so hopefully this may be in one of their releases.
I have just discovered that if you use the f9, you can actually manually add the vat amount to the net so you can get the Gross figure that way, but just seems a lot of work. Although after migrating over from Tas bank feeds are a huge improvement!
You win some and loose some i suppose!
I Appreciate you your responce
I have just discovered that if you use the f9, you can actually manually add the vat amount to the net so you can get the Gross figure that way, but just seems a lot of work. Although after migrating over from Tas bank feeds are a huge improvement!
You win some and loose some i suppose!
I Appreciate you your responce
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Changing the VAT/Tax code in Bank Postings
The bank doesn't know, that is why human intervention is required.
If you had 2 transactions on a customer account one for £40+£10 Vat and one for £50 with no Vat, when you receive £50 the vat element of that receipts for your VAT return depends on which transaction it pays.
If you get money before you raise the invoice (receipt on account) you have to tell sage what the VAT code is...
Sage is organised well enough that you can not match a T0 receipts to a T1 Invoice.
People often get stuck on working out how to deal with this when a payment on account had the wrong VAT code on it when it was entered.
If you had 2 transactions on a customer account one for £40+£10 Vat and one for £50 with no Vat, when you receive £50 the vat element of that receipts for your VAT return depends on which transaction it pays.
If you get money before you raise the invoice (receipt on account) you have to tell sage what the VAT code is...
Sage is organised well enough that you can not match a T0 receipts to a T1 Invoice.
People often get stuck on working out how to deal with this when a payment on account had the wrong VAT code on it when it was entered.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 13 guests