Finance | Project Operations, Human Resources, ...

Vendor Tax Invoice - GST

(0) Share

Report

Posted on by NZNZ123

Hi team

Hope you all well!

In our system when we enter a supplier invoice, we enter it is GST inclusive and then on posting it posts the GST exclusive amount to the ledgers where it is suppose to go.

Is there a way, where for a vendor, we can enter the invoice as GST exclusive instead and on posting it will calculate the required GST and also post the gross amount of the invoice to the vendor account?

Thanks!

mia

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

Can you please explain through one example with accounting entry? What are you trying to achieve?

Was this reply helpful? Yes No
NZNZ123 90 on at

Like (0)

Report

Sure.

So say there is an invoice from ABC Cleaners for $120 (GST inclusive)

In the vendor tax invoice journal I would enter 120 in the credit field against the vendor. Then when I post, $10.91 9 (auto calculated) would go to GST account (10%), then $109.09 would go to say "cleaning" ledger code.

However, is there a way I can enter the invoice in the tax vendor journal as 109.09 instead and then on posting, the GST is calculated and then the gross amount is also calculated.

hope this make sense

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hello Mia,

Have you tried with "price include tax" = no for the journal you are using?

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Yes, If you enter 109.09 as Credit keeping Price inclusive = No, it will calculate GST= 10.91

On posting it will be Vendor Credit = 109.09 +10.91

Cleaning ledger Debit = 109.09

GST Debit = 10.91

Price inclusive = no can be found on Vendor invoice journal header itself.

Was this reply helpful? Yes No
NZNZ123 90 on at

Like (0)

Report

nope? how do i get to that screen or note?

Was this reply helpful? Yes No
NZNZ123 90 on at

Like (0)

Report

This is my screen.

Where i have circled i enter the GST inclusive amount. And GST auto calculated etc..

But is there somewhere where I can instead enter GST EXCLUSIVE? maybe i need to change settings as some invoices have many lines and i need to manually calculate GST inclusive which is stupid.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

The journal you are using to book the gst inv, on the setup there is the option.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Only place where you can see gross amount if you enter Inclusive is "GST Screen " click on GST button and below grid you can see the "GST amount"

There is not way where you can see Base amount on journal line by entering inclusive amount.

For entering exclusive amount, yes you have to calculate manually or just enter inclusive and let system do back calculation.

Was this reply helpful? Yes No
NZNZ123 90 on at

Like (0)

Report

Thank you!

Seems like it is the way.

I have an invoice with multiple items on it with GST exclusive amounts so its a hassle to manually calculate the gross and then to enter it into D365. ne easier if the ssytem can just do what it is told :)

Was this reply helpful? Yes No