General Ledger - Show Description in separate lines

Hi PChan2019 

Apologies, INP is a standard tax code, however, thank you for providing your screenshots.

I notice on the first screenshot of the transaction i.e. the one showing the Spend Money transaction that the Cheque no is 763. However, in the screenshot you have provided of the transaction the journal/cheque no is 762. Have you provide the correct transaction and updated the cheque no since taking the screenshot or are we looking at separate transactions?

However, in saying that, I haven't been able to replicate what you are describing within my testing. If you have provided the correct transaction would be interested to know what happens if you open the transaction, select the tax arrow and then select the Recalculate button - you will get a message relating to it could impact tax values select Ok to that. The reason for that message is that the recalculate button recalculates the tax component of a transaction basically it refreshes the transaction. If that impact that transaction, are you able to delete and re-enter that transaction? Does it still create that situation upon re-entry?

Hi Steven_M 

Apologies - I have attached the wrong screenshot. But atually both 762 and 763 appeared to have the same problem. 

I have reattahed 4 screenshots,

1. General Ledger 

2. Spend Money for 762

3. Spend Money for 763

4. Transaction Journal 

I followed your steps to recalculate the tax. After I clicked on the tax arrow, the tax information box appear but there is nothing come up or change after i click onto the recalcualte button. I have also attached the tax information box screenshot. 

Thanks,

Phoebe 

Hi PChan2019 

Thank you for providing those additional screenshots and information.

The system is designed to behave as your screenshots have indicated if an INP - Input tax code is used. What happens is that Input tax codes are specialised tax codes that are used to record the import duty payable on a purchase without changing the total amount of the purchase. 

In your case, as the transaction is being entered as a tax-inclusive amount that is going against the account is the tax exclusive value. The way INP works is that it will add the tax amount to the first transactional for the same account line's tax exclusive value as it does need to account for tax portion.

For example, take the $598 Spend Money transaction, this has two amounts $510 and $88 inclusive / $463.63 and $80 exclusive ($54.36 tax) to the same account. To account for that tax portion the tax amount is added to the first transactional line with that INP tax code, so $463.63 becomes $517.99*.

*It's actually broken down into individual line amounts and then the tax portion is made up of that then combined before being rounded off, so its a slightly different number

Hi Steven_M 

Thank you. Your explaination make so much sense! 

I just had a quick look on MYOB website explaining the INP code. It stated that 

If you enter input-taxed purchases as tax exclusive, set the Rate at 10%.

If you enter input-taxed purchases as tax inclusive, set the Rate at 0%.

Does that mean under the Spend Money Transaction, i should have entered the line amount as $463.63 and $80 when i have the INP rate currently set at 10%? 

Or it doesnt matter how i am entering, the tax amount must be added to the first line?

Thanks,

Phoebe 

Hi PChan2019 

The Tax-inclusive option on the transaction is only how you enter the values it will not impact the overall transaction and the account recording of the transaction. The system will complete the process mentioned in my earlier thread with a tax inclusive or tax exclusive transaction that uses an INP that records to the same account.