How do I make an invoice that uses VAT and prepaid taxes? Please help

1

Please help how to setting and make invoice with VAT 11% and prepaid tax 2% (tax deducted)

This screenshot i make tax code in setting

gambar 3
gambar 31054Γ—650 38 KB

This screenshoot I make Invoice with Unit price is 100.000

gambar 2
gambar 21557Γ—323 27.5 KB

This The result of the invoice above

gambar 1
gambar 1986Γ—535 51.8 KB

I want the Invoice should be like this

Invoice

Thanks In advance

1 Like
2

Didn’t the withholding tax option work for you?

Kindly read this guide: Account for withholding tax on sales invoices | Manager

1 Like
3

I have the same problem as OP, I have also tried using the method you showed
By using the Withholding Tax option, we cannot change the label on the sales invoice.
Also on account allocation when receiving proof of tax deduction.
We have several types of prepaid taxes, while the Tax Withholding Receipt does not provide account options to group them based on the type of tax

4

Please show us screenshots of this as evidence. Thanks!

5

image
image1920Γ—1080 236 KB

6

I now understand that you do not like to call it withholding tax

7

Thanks for your advise.
Witholding tax is work, but in generally the position of this prepaid tax (PPh 23 ) is before sub total, and if we use witholding tax, my customer complain because we cant rename it or add some text like (PPh 23) to be a label, we was adding some noted in footer like witholding tax is (PPh 23) but again and again the customer dont want receive this form.

correct me if i am wrong i hope the invoice sales can solve this problem i was set code tax with multiple rates, but the number of subtotal dont match

image
image989Γ—465 11.7 KB

the subtotal must be 100 x 1000 = 100.000 but in sales invoice is 102.000

image
image1023Γ—541 46.5 KB

8

I do not recommend the use of negative tax codes as you have done in your illustration above. Negative tax codes are used for irrecoverable sales/Value added taxes on purchases.

@edwar_pangestu Will the ability to rename β€œWithholding Tax” to your desired label solve your problem?

@Ealfardan @eko @lubos can Custom themes be able to solve this problem? I think he can change the label to his desired label. Others may want to show it on invoices as Tax Deducted at source (TDS).

1 Like
10

because we have more than one type of Withholding Tax, so I have to create a Custom Theme for all of them :frowning:

     {% for total in table.totals %}
       
          {% if total.emphasis != true or total.label != "Sub-total" %}
                <tr>
                    <td colspan="{{ table.columns | size | minus: 1 }}" style="text-align: end; padding: 5px 10px{% if total.emphasis == true %}; font-weight: bold{% endif %}">
                        {% if total.label == "Withholding tax" %}
                            {{ "PPH 23" | replace: "Withholding tax", "PPH 23" }}
                        {% else %}
                            {{ total.label }}
                        {% endif %}
                    </td>
                    <td style="border-left-width: 1px; border-left-style: solid; border-left-color: #000; border-right-width: 1px; border-right-style: solid; border-right-color: #000; text-align: right; white-space: nowrap; border-bottom-width: 1px; border-bottom-color: #000000; border-bottom-style: solid; padding: 5px 10px{% if total.emphasis == true %}; font-weight: bold{% endif %}">
                        {{ total.text }}
                    </td>
                </tr>
          {% endif %}
            
        {% endfor %}

image
image705Γ—375 6.86 KB

1 Like
11

You can click on the withholding tax drop down and select Amount instead of Percentage . Amount gives you the ability to enter the exact amount you want withheld.

12

Yes, I know that. But you cannot use amount in Form Defaults.

13

The solution for which is a multi part tax code similar to is used for VAT/GST but Manager is yet to support this.

14

Thank you all solution was solve our problem

15

Thanks bro

16

Thanks for the code, thats very helpful

17

Actually support for this is already in the ideas catagory