Hi, I'm from Italy. Im'currently evaluating Billigs2 Beta for my business, but I need some help in order to build My invoices.

I need to build an Invoice that looks like this :

SUBTOTAL = 1000,00
INPS 4% = 40,00
TOTALE IMPONIBILE = 1040,00 (subtotal + INPS 4%)
IVA 20% = 208,00 (20% of TOTALE IMPONIBILE)
TOTALE FATTURA = 1248,00 (TOTALE IMPONIBILE + IVA 20%)
RITENUTA D'ACCONTO -20% = -208,00 ( -20% of TOTALE IMPONIBILE)
NETTO A PAGARE = 1040,00 (TOTALE FATTURA + RITENUTA D'ACCONTO).

Is this possible? I know this may sound silly, but in my country a freelance like me HAVE TO respect this parameters

Thanks.

Hi Luca

It is possible to build an invoice that does what you want; however, the invoice wouldn't be able to work with some of the customizations available in the "options" sheet when you actually send invoices. Our built-in templates work no matter what kind of taxes you have (no matter what country you're in), but if you design one specifically for your purposes, it won't be as flexible. As long as you're sure that you will always have the same lines at the bottom of the invoice, it's possible to do what you're asking.

We haven't yet made available documentation that will help you design the invoice, but I can help walk you through it a little bit here.

Essentially, what we would want to do in your case, is replace the special tax table that we have at the bottom of our built-in invoice templates. Our table first shows a subtotal (that is the table's header row), then it lists all the taxes that apply to the invoice (that is the table's data rows), then it shows the total due (that is the table's summary row).

In the case of your design, we would most likely use a series of one-line-height boxes in place of that table. Each "line" box would have to boxes inside of it, one for the "label" and one for the "amount." There would be 7 "line" boxes--one for subtotal, INPS, TOTALE IMPONIBILE, etc..

I recommend playing around with a blank invoice template, so learn how to make and style boxes the way that you'd like them to appear. Then, we can work through how to build those into the existing invoice template, and to get the right data out of the database.

Could you possibly also provide English translations of the Italian? That way we can figure out what information is in the database, and what tokens to use to "get" the right data.

Thx,

ciao Adam.

i have the same problem as Luca.. nut i think that the "template" way is wrong.

it should be possible to define better the Taxes, expecially where they apply to..

in our case, the Consolidated taxes input should:
1) define the order of the taxes
2) define what do a NON compounded tax apply to (if to the subtotal of previous taxes, or to a specific one)

what do you think?

stefano

Hi Adam,

I'm writing from Italy too, and, worst for us, all here have the same problem compiling our invoices, where some field have to be multiplied for some tax percentage and some other have to subtract other percentage!
I'm going to try to help in this topic:

SUBTOTAL = 1000 €
INPS 4% (tax #1) = 40 € this have to be addeded to subtotal, so:

IMPONIBILE (Total fee) = 1040 € this amount have to be multiplied for a second tax rate:
IVA 20% (tax #2) = 208 € the total would be now:
TOTAL AMOUNT = 1248 € but this, for italian fiscal law, IS NOT ALL, we have then to indicate something to retain:

RITENUTA DI ACCONTO (taxes to be paied in advance for us by the client) = -200 € but, warning, this is a negative percentage to be calculated from the very first SUBTOTAL, whitout any taxes, so we have to conclude:

TOTAL TO BE PAYED = (TOTAL AMOUNT - RITENUTA DI ACCONTO) = 1048 €

That's complicated enough, isn't? Well, this is Italy!!!

As far as this implementation will be supported on Billings we need to continue using FileMaker for our invoices...

Ciao a tutti,

Marco

(actually Studiometry does all these things very well.. unluckily it's a very buggy and with terrible interface, that's why i want to jump into Billings 2 (i have already bought it )

quote:

Originally posted by marco fazio:
SUBTOTAL = 1000 €
INPS 4% (tax #1) = 40 €
IMPONIBILE (Total fee) = 1040 €
IVA 20% (tax #2) = 208 €
TOTAL AMOUNT = 1248 €

RITENUTA DI ACCONTO (taxes to be paied in advance for us by the client) = -200 € but, warning, this is a negative percentage to be calculated from the very first SUBTOTAL, whitout any taxes, so we have to conclude:

TOTAL TO BE PAYED = (TOTAL AMOUNT - RITENUTA DI ACCONTO) = 1048 €

That's complicated enough, isn't? Well, this is Italy!!!

Since i'm a freelance too, i also have to follow your scheme.
After calculating "TOTAL AMOUNT" I have to add some expenses (Spese Anticipate, Art. 15 D.P.R. 633) that don't have taxes (kilometers, highways, hotels...).
Would be nice if "RITENUTA DI ACCONTO" could be disabled from TOTAL TO BE PAYED, 'cause some freelance don't have to include it (Regime fiscale agevolato, Art 13 L.23/12/2000 n° 388).

Well... we're in Italy!

I live in Belgium and have a similar yet different problem. For my business I have 2 different tax rates....

Normal VAT is 21% but there are some businesses that only have to charge 6% - of course both apply to me in different situations.

For example - I am a photographer and copyright is taxed at 6%

But if I have to deliver the images to a client on a CD I charge for the service of burning the disc which should be taxed at 21%.

So I would like to apply a different tax to individual slips as needed but not have a tax calculated on the total amount of the invoice.

So idealy an invoice would look something like this...

Copyright Licensing Fee: €1000
VAT Copyright 6%: €60

CD Burning: €50
VAT Products/Services 21%: €10.50

Subtotal: €1050
VAT: €70.50

TOTAL: €1120.50

Is this possible?

quote:

Originally posted by Jock Fistick:
I live in Belgium and have a similar yet different problem. For my business I have 2 different tax rates....

Normal VAT is 21% but there are some businesses that only have to charge 6% - of course both apply to me in different situations.

For example - I am a photographer and copyright is taxed at 6%

But if I have to deliver the images to a client on a CD I charge for the service of burning the disc which should be taxed at 21%.

So I would like to apply a different tax to individual slips as needed but not have a tax calculated on the total amount of the invoice.

So idealy an invoice would look something like this...

Copyright Licensing Fee: €1000
VAT Copyright 6%: €60

CD Burning: €50
VAT Products/Services 21%: €10.50

Subtotal: €1050
VAT: €70.50

TOTAL: €1120.50

Is this possible?

Yes this is possible. Simple add the different tax rates in the preferences and then choose the appropriate tax rate on each slip.

quote:

Originally posted by Matalyn:

quote:

Originally posted by marco fazio:
SUBTOTAL = 1000 €
INPS 4% (tax #1) = 40 €
IMPONIBILE (Total fee) = 1040 €
IVA 20% (tax #2) = 208 €
TOTAL AMOUNT = 1248 €

RITENUTA DI ACCONTO (taxes to be paied in advance for us by the client) = -200 € but, warning, this is a negative percentage to be calculated from the very first SUBTOTAL, whitout any taxes, so we have to conclude:

TOTAL TO BE PAYED = (TOTAL AMOUNT - RITENUTA DI ACCONTO) = 1048 €

That's complicated enough, isn't? Well, this is Italy!!!

Since i'm a freelance too, i also have to follow your scheme.
After calculating "TOTAL AMOUNT" I have to add some expenses (Spese Anticipate, Art. 15 D.P.R. 633) that don't have taxes (kilometers, highways, hotels...).
Would be nice if "RITENUTA DI ACCONTO" could be disabled from TOTAL TO BE PAYED, 'cause some freelance don't have to include it (Regime fiscale agevolato, Art 13 L.23/12/2000 n° 388).

Well... we're in Italy!

It can done the way Adam spoke about above. But we will discuss this internally to see if there is something easier.

Do you know if this system used in other countries?
It's the first time I'm, personally, hearing of such a complex scheme.

Hi all,

Well the spanish system is quite similar to the italian, just a little easier:

All products (just a few exemptions) are charged with IVA (VAT), with a 16% as general type, but with special types of 7% and 4% depending on the product and/or the customer.

Also, some professionals pay a 18% of "IRPF" that I understand is like the italian "RITENUTA DI ACCONTO" so a professional invoice may be:

B.I. - BASE IMPONIBLE (Total amount of the invoice without any tax)
+ IVA 16% OF B.I. (other times it may be 7% or 4% or a mixture of the three types depending on the products)
- IRPF 18% OF B.I.
= TOTAL AMOUNT

Also, if i'm not wrong, for all the European Union countries it is mandatory to show in all our invoices our VAT number and, it is also mandatory to include the Customer's VAT number there.

This program is very interesting for me, but taxes treatment and VAT identifications must be improved in order to buy it.

Best Regards,

F. Xavier Piñol

Some words about the situation here in germany as of now:

Generally there are 2 tax rates. The rates are currently 7% (i.e. for food and newspapers) and 19%.

We are more or less forced to imprint the tax rate and amount per invoice line item.
At the bottom of the invoice next to the total we have to show all the different taxrates with their totals.

As far as i could see in the demo there is no way to get the tax amount (subtotal) per slip/line? Or can this be done by formula?
In general it would be nice to have direct access to all entered values of the slip.

BTW - i order anyway now, because i can add that functionality with "fixed" invoice templates.

quote:

Essentially, what we would want to do in your case, is replace the special tax table that we have at the bottom of our built-in invoice templates. Our table first shows a subtotal (that is the table's header row), then it lists all the taxes that apply to the invoice (that is the table's data rows), then it shows the total due (that is the table's summary row).

In the case of your design, we would most likely use a series of one-line-height boxes in place of that table. Each "line" box would have to boxes inside of it, one for the "label" and one for the "amount." There would be 7 "line" boxes--one for subtotal, INPS, TOTALE IMPONIBILE, etc..

Please to be more clear. I'm triyng Billings 2 but one-line-height box is not possibile to make inside the app.
I want reproduce this layout:
subtotal-> 1000 €
first tax 4%-> 40 €
first subtotal -> 1040 € (subtotal + first tax)
second tax (vat) 20% -> 208 €
TOTAL AMOUNT -> 1248 € (first subtotal + second tax)

I want to buy Billings but i need this schema for my business.

Please please explain clearly how to reproduce that. Thanks

Hy !

In France we have this special needs. I have made my own design invoice now, but to made the social charge calculator I need to apply to the "total due" a percentage like "1000€ x 0,85"

It is possible to do that ? make your personnal value...

It is the F-Script the sollution to made the calcul ?

Re-

I have test the Adam's idea, and it work (I have create consolited taxes with all my need : CRDS 1%, CSG Déductible 5,1%, CSG Non Déductible 2,1%, Cotisationmaladie 0,85%, Total due to me 91,15%, Total due to social agency 9,85%) BUT...

He memorize a total invoice with 108% of taxes !

So the invoice printed can be good, but the total in the interface is wrong. It's impossible to applicate withholding taxes ? Or made our own calcul ??

Hi,
I'm from Italy too, I'm a freelancer and have the same problem.
I'm unable to set up taxes with the following scheme:

Subtotal: 1000€
INPS 4% of Subtotal: + 40€
Total: 1040€
20% Tax of Total: + 208€
-20% Ritenuta of Total: - 208€
Total to pay: 1040€

Any help please?

Best regards,
daniele