It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → FA Modifications → Editable Tax Field
Hi
I want to make tax field editable on direct purchase invoice & supplier invoice so that I can adjust few pence difference to match VAT on supplier's invoice (after update of tax, total amount should also update). Could you please let me guide how to do this or can this be done on next release of frontaccounting.
Thanks
Hi
I want to make tax field editable on direct purchase invoice & supplier invoice so that I can adjust few pence difference to match VAT on supplier's invoice (after update of tax, total amount should also update). Could you please let me guide how to do this or can this be done on next release of frontaccounting.
Thanks
Belgian VAT regulations only allows declaration for the VAT on the suppliers invoice. When the VAT on the invoice is not correct calculated it is not allowed to match it. So, the VAT on suppliers invoices has always to be entered by a editable tax field to have correct VAT declarations. VAT inclusive invoices ( no VAT shown) are not allowed for VAT declaration and VAT may not be calculated and declared. So two unique accounts for each VATtax-type are not needed . Only sales invoices have to be calculated for VAT. For EU, non EU transactions and other received non VAT invoices where VAT must be declared by the receiver of the goods the VAT has to be declared as Payable and as deductible, so two calculated tax lines are needed for the booking. This is not solved with negative bookings but must be booked debit and credit. I have read the UK VAT entry but I think it is not the solution.
In some occasions only a part of the VAT may be declared, for example when buying a car 50% of the VAT is deductible and the other 50% must be booked as an expense as non deductible VAT. When purchases are made who are partially for private use only the professional used amount of VAT may be declared.
IT is necessary to have a editable tax field in the suppliers form!!!
There are more problems and issues to be solved in Frontaccounting before it can be used for EU bookkeeping with legal VAT declarations integration.
I am a bookkeeper not a computer-programmer, so some help is needed to get this program work for most Europe Countries.
Make one like Shipping at the bottom of the invoice or make a service item called, say, VAT Ajustments, with no tax and use it as a free form value.
Caveat: Must remember to do it each time one is needed.
Make one like Shipping at the bottom of the invoice or make a service item called, say, VAT Ajustments, with no tax and use it as a free form value.
Caveat: Must remember to do it each time one is needed.
My government want to know the total of o vat sales I made. When I make an Item o Vat for VAT correction the amount I fill in in the form will be totalized to my O VAT sales or not?
I really do not understand very well how this VAT thing works in FA but I think what you propose may influence the turnover.
Because tax lines posted in tax_trans_details table are not exactly the figures in purchase invoice, adding a service line does not work. When you enter VAT only line say for £0.02, the logic which posts the line to the above table will calculate net amount on £0.02 VAT (£0.10 @ 20% VAT) and post in the tax table which is wrong. There is not extra net purchase. It's just the VAT difference on the supplier invoice of few pence which I want to adjust so that my system purchase invoice agrees to supplier's invoice. In UK you have to show all VATable & Zero VATable sales & purchases excluding VAT on VAT return. FA also ignores zero VAT/tax transactions being posted to tax_trans_details table if you post invoice using form "Suppliers Invoice". So for UK purpose, only use "Direct Invoices" and make all suppliers as UK VAT registered (assign 20% VAT tax). I still do not agree with the logic of posting it's own calculation for tax purpose.
Thanks
Because tax lines posted in tax_trans_details table are not exactly the figures in purchase invoice, adding a service line does not work. When you enter VAT only line say for £0.02, the logic which posts the line to the above table will calculate net amount on £0.02 VAT (£0.10 @ 20% VAT) and post in the tax table which is wrong. There is not extra net purchase. It's just the VAT difference on the supplier invoice of few pence which I want to adjust so that my system purchase invoice agrees to supplier's invoice. In UK you have to show all VATable & Zero VATable sales & purchases excluding VAT on VAT return. FA also ignores zero VAT/tax transactions being posted to tax_trans_details table if you post invoice using form "Suppliers Invoice". So for UK purpose, only use "Direct Invoices" and make all suppliers as UK VAT registered (assign 20% VAT tax). I still do not agree with the logic of posting it's own calculation for tax purpose.
Thanks
Thank you for the explanation. So, when entering a suppliers invoice with different items who may or may not have different tax rates, Vat is calculated for each item on each line. When the total VAT calculated does not correspond with the total VAT on the received invoice the correction can not be made by adding an other line. When I make an Item called Vat-correction with 0% tax the correction will be made on the GL account and my VAT declaration will be correct or not?
A basic accounting rule is that the books show the real state of transactions. When, for example, a payment is made, it may be booked as paid the moment the payment shows on your bank account and not when the order for payment is made. The time the money can be in transaction the money-transaction is normally booked in the TRANSFERS account. The same when money is booked from one bank account to an other bank account of the company. When cash money is brought to the night-safe of the bank, this money should be in transfer till it is correctly booked on your bank-account by the bank. The account TRANSFERS should show al movements of money and allow reconciliation. This principle is not followed by FA. This is not a problem because the program allows reconciliation of the bank-accounts afterwards but this is not proper bookkeeping.
The logic in booking the VAT on suppliers invoice has the same principle. You may not book what is not real. The amount of VAT on the suppliers invoice is the real VAT declared by the supplier. Good bookkeeping does not allow to calculate the VAT for suppliers invoices because the result may not show the real situation due to errors of the supplier. UK VAT regulations is no exception on this rule. Only the VAT on a legal suppliers invoice may be declared. For suppliers invoices it is not advisable to let calculate the VAT for each item, one editable entry for amount VAT edited on the suppliers invoice is enough. Simple booking and no errors can be made because your bookings must be in balance. Posting it's own calculations is not allowed for suppliers invoices.
FA is , as far as I can tell, a very good program and should be easy to use for everybody. I use bookkeeping programs a long time and have problems with the approach of this ERP program because till now Bookkeeping and supplies were two different things for me. I keep books, my clients keep the supplies. I am learning!
Thanks
For VAT declaration purposes suppliers should have different VAT categories for domestic, EU, non EU purchases and other received non VAT invoices where VAT must be declared by the receiver of the goods. They may be assigned a VAT tax( 20%) debited to the VAT deductible account. On a second line we have to credit the same VAT tax to there specific VAT payable GL account, Eu, non Eu , etc.. because I need these for VAT declaration. This way I think it should work but it is not possible because suppliers direct invoice does not accept credit bookings.
To solve this I need TAXcategories which can be assigned a creditable account and a debitable account, as it is now, but the VAT tax must be booked automatically to both accounts, credit and debit, when the supplier is assigned to that specific TAX category. Is this possible?
For direct supplier invoice editable tax amount entry possibility would be a great help and solving a lot of problems. This may be because I am used to editable tax entry for suppliers invoices but I do not think so. I still use an old DOS based booking program where tax is calculated automatically but the TAX window can be erased and changed by the correct amount. Even changed by a formula, for example the tax amount x 50%. I still use this program for small businesses where a lot of purchases are partially for private use. Easy and quick. One time entry.
Hello guys,
If you need to be able to enter the tax yourself, then use Supplier Invoice in the right pane. Set the supplier to be tax exempt (a tax group with no taxes).
Select the rows to be invoiced.
Then use the GL items at the bottom to enter your Purchase tax.
And save the invoice. That's it.
If you need to enter both Import tax (outgoing) and pucrhase tax (ingoing) then you should create a Quick Entry like this:
Call it Import.
Select Supplier Invoice/Credit type.
Say your Sales tax is 23% and your Import Tax account is 2151 and Purchase Tax account is 2150.
Then these two quick entry rows should be set:
% amount of base 2151 Import Tax -23.00
% amount of base 2150 Purchase Tax 23.00
Let us say you have items for $1000.
Then select the Import quick entry and enter the amount of 1000.
Now the import and sales tax rows are automaticly calculated.
Instead of using quick entries you could also enter these lines directly in the GL Items. Save the Invoice.
That should do it.
This operation for using the Supplier Invoice on the right pane will require a Direct GRN before the Supplier Invoice, but you can freely enter your tax amount.
/Joe
In may case negative bookings are not the solution. The VAT-tax must show as payable and deductible on the proper accounts so they must be booked debit and credit. The amounts must show on the balance.
As I stated before. Accounting-books must show at all times the real situation of the company and negative bookings must be avoided as much as possible, if not avoided at all. Questions may be asked about negative bookings. An accountant who uses negative bookings? That's why credit notes are created.
Booking a suppliers invoice should be a simple process because nothing has to be calculated. FA is a good ERP system and not an accounting program, therefore there is an other approach about the way things are done. Making it more difficult is not the answer.
To solve EU, non EU purchases and other received non VAT invoices where VAT must be declared by the receiver of the goods I need TAXcategories which can be assigned a creditable account and a debitable account, as it is now, but the VAT tax must be booked automatically to both accounts, credit and debit, when the supplier is assigned to that specific TAX category. Is this possible?
Hello demille.
Are you an accountant, then look at the GL booking for the supplier invoice after above entries.
You will see that the GL accounts are update4d correctly, so are the Tax (VAT) Report.
I guess this was the original subject (about editing the VAT), right?
/Joe
BTW the quick entries should be done by an expert.
FrontAccounting forum → FA Modifications → Editable Tax Field
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.