This PO has items that are non-inventory, and is set to taxable in the header. The tax rate is 10.25%
When creating the pquote, I entered in the cost of each item, and it correctly calculates and adds it to the tax estimate on the bottom of the pquote. E.g. line 1 had a cost of $17.09 (prior to any sales tax).
If you click one of the receipts, it shows Cost: $17.09, Cost Breakdown - Cost: $15.34, Cost Breakdown - Tax: $1.75.
The “Cost Breakdown - Cost” is incorrect. This calculation removes the sales tax from the $17.09 value… it doesn’t seem to be used anywhere, so maybe it doesn’t matter.
If you click on the ledger for this item, it puts the cost ($17.09) into GL account (in this case, lab expenses) and unvouchered receipts account.
What it should also be doing when the item is received is putting the tax component ($1.75) into sales tax payable and offsetting the same GL account (i.e. lab expenses), but this doesn’t happen.
once you go to voucher this, add receipts from the PO to the ledger, and click on the button to add sales tax, you end up with a split that automatically sends a credit to the “Sales Tax Payable account” and debit to “Accounts Payable”. See ledger. Accounts payable is later cleared out once the payment is complete and the cash leaves our bank account.
However, the amount that is in the Sales tax payable account remains after the PO is paid and closed out… leaving us to clear that out with a manual ledger entry? that’s not very convenient… a simple fix would be to add an entry to sales tax payable as I have described above.
Sales tax is not calculating correctly on the receipt, though the receipt is correctly breaking down the Part cost from the Part record and the Sales Tax (though incorrect amount calculation). We will be looking into that on our end.
If Sales Tax is already included in part cost, it should not recur as an additional line on Voucher. It only needs to be included once.
There should be no accrual to Sales Tax Payable in this case. Your vendor is receiving the sales tax portion from your payment so you shouldn’t be hitting Sales Tax Payable at all in this case.
If there is no Sales Tax already in the Receipt cost breakdown, then if adding a split to the Voucher for Sales Tax, the DR on that split line should be to the Non-Inventory Lab Supplies and Expense GL account as part of the total cost of the Non-Inventory part.
Please let me know if you have more questions. I will also get back to you about the incorrect cost breakdown.
#2: I guess we could add it in to each line item, but that would be more work.
#3: I looked at this again – the reason it hit that is because there’s a GL transaction mapping setting for “PO Tax Account”, which we routed to our Sales Tax Payable account… that doesn’t make sense to have it route to any one account. Normally for a PO, I would think it should be routed to the same account as the line (if it is taxable).
I guess the scenario is what to do if we send a PO via pdf to a vendor for non-inventory items. We can’t include the sales tax in the part cost, otherwise that throws the vendor off. The normal way is to set the sales tax globally in the header or on a line item basis. What I was hoping/expecting to happen was that if we did that, and set a GL expense account for each item (whether it is non-inventory lab supplies, office supplies, etc), then when we receive a voucher, the sales tax portion should go to that GL account. It’s more manual math to apportion the sales tax by hand once we receive the voucher if we mix items that have different GL expense accounts e.g. office supplies, lab supplies, computer supplies, etc. on the same PO… Would be nice if the ERP did this for us
Vikas, #2 should not be necessary. #3 PO Tax account setting may be what is causing (part of) the problem. And CETEC ERP should be handling this for you if set up properly. We are looking into the issue with other production support team members to get this resolved as soon as possible.
