• From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Topic: Withholding tax deducted

Adding a facility to process withholding tax (WHT) would greatly improve the usefulness of FA where WHT is applicable - which it is in many places.

In simple concept it would entail coding similar to settlement discount. 

In the same way FA deals with settlement discounts on payments from customers and payments to suppliers, there is an additional, similar type of transaction commonly dealt with by accountants - withholding tax (WHT)

When certain (not all) customers pay me, they are obliged to deduct with-holding tax from the amount they pay me.

For example, I invoice $100 to my customer, and he will pay me $97 and then he will pay the $3 balance to the tax authorities - as a payment of tax on my behalf. 

As far as the customer is concerned his account with me is zero - the $3 should not appear on the statement I send him. 

The accounting for this would be

Dr Bank                                       97
Dr WHT deducted on my behalf      3  (balance sheet receivable account as opposed to the discount allowed GL acc)
Cr Debtors Control                     100 

There is no way I see to account for this in FA at the level of customer payment. 

The ideal solution would be to have, at the level of customer and supplier set up, an option to process withholding tax on customer or supplier payment.

The reverse can happen when I pay certain suppliers.  For example, if I pay my rent I need to deduct 5% tax and pay it to the tax man.

The accounting entry for this would be

Dr Rent                                  100
Cr Bank                                    97
Cr WHt deducted by me              3 (balance sheet payable account - as opposed to the GL acc for discount received)

When I pay the tax man the entry would then be

Dr WHt deducted by me              3
Cr Bank                                      3       


Mark

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Withholding tax deducted

I understand what you mean, but:

Why isn't the sales tax, 3$ paid by the seller, the invoice originator.?And why should the customer pay the tax? This tax is deductable for the buyer, and he can claim that from the tax authorities. Well I guess this the normal way of handling this.

Joe

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Withholding tax deducted

Different to vat which is what you refer to and needs to operate as well as vat

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Withholding tax deducted

Treat it as a WHT Tax Accrued account and the Rent Item as Tax Included.

apmuthu's Website

5 Reply by MarkAndrew (edited by MarkAndrew 01/13/2015 03:44:22 am)

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Withholding tax deducted

Thx. I understand but don't feel that the issue is addressed.
Example to illustrate:

An architect sells services for $1000. He charges $15 Vat on top of this. FA can process these 2 elements.  His customer pays him $970 (1000 less 3%) + $15 Vat = $985. He receives $985 into FA against the customer account.  It looks like the customer still owes him $30 (1000 +15 - 985).  But in reality the customer owes him nothing as the $30 is income tax withheld by the customer from the payment to the architect and paid directly to the tax authority. 

How do I remove the $30 from the customer account and put it in the WHT accrued account?

The ideal solution would be to transfer it there on processing of the customer deposit like we do with a settlement discount which is transferred from customer account to the discount allowed account.  Except in this case it is transferred to WHT accrued account.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Withholding tax deducted

Have you tried quick entries?

apmuthu's Website

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Withholding tax deducted

Hi
I tried quick entries.
Doesn't work when you need to affect customer and supplier accounts or where the base amount is variable.

Ideally the solution is to have a the Withholding Tax processed at the level of customer and supplier payments like a discount as detailed in earlier posts.  It could be configured in customer/supplier set up where the user could determine the % that should be withheld from the supplier payment or by the customer when he makes his payment and it could be offered as a option when processing customer and supplier payments.

Example:

In customer set up... +Withholding tax to be deducted by customer on payment  ..3..%
                                 +GL Allocation of Withholding Tax Deducted  ....5/2562...   (as selected by user from GL structure)

In customer payment screen...Amount of Discount  $x
                                              Amount of TDS         $x***

*** calculated like discount with reference to customer set up parameters and allocated to selected GL account as per customer set  up. Amount "Auto   filled" but with the option of manual over-ride.         

Sorry to only offer logic not a coded solution.

  • Registered: 07/31/2015
  • Posts: 2

Re: Withholding tax deducted

Hi,
I am from Pakistan where companies have to withhold the tax from payments. If I am a withholding agent then I have to deduct the withholding tax from the payment before giving to the service vendor.

For achieving this, I created the special % withholding GL account and recorded the amount while making the entries for supplier payment.

Same but inversely I am making when withholding tax got deducted from my payment by my client. I just record the customer payment with withholding tax deducted by customer for closing the invoice and when my customer give me the paid challan, I balance the witholding account with reference of that paid tax challan.

It makes all receivables balanced and nothing remains in customer balance. I have customized the Front Accounting for it for myself.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Withholding tax deducted

Would you like to provide the changes in db schema and the fileset to the project?

apmuthu's Website

  • Registered: 07/31/2015
  • Posts: 2

Re: Withholding tax deducted

Yes, I am customizing it myself as per the need. I am making this procedure as the part of customer and supplier payment so that we will not need any separate journal entry to record these taxes.
Currently, I am working on it to finalize it.

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Withholding tax deducted

Hi Shozab
Any further with WHT changes?
"Would you like to provide the changes in db schema and the fileset to the project?"
It probably is of benefit to many users.

12 Reply by Marc Paré (edited by Marc Paré 09/23/2015 06:17:47 am)

  • From: Waterloo Ontario, Canada
  • Registered: 05/10/2015
  • Posts: 19

Re: Withholding tax deducted

Is this the same as in my example here? https://frontaccounting.com/punbb/viewtopic.php?id=5950. I have to withhold Union dues and pay Pension dues from musicians fees.

Marc Paré's Website

  • From: Romania, Bucharest
  • Registered: 03/07/2016
  • Posts: 17

Re: Withholding tax deducted

I am from Pakistan. I have implemented withholding taxes at supplier payment successfully. But reports 202 (Ageing report) is not working properly. Did anyone fixed this report with withhodling taxes?

  • From: India, Chennai
  • Registered: 12/23/2017
  • Posts: 56

Re: Withholding tax deducted

Hello,
Anyone have implemented this code? Successfully!
Requesting for your update please!

Regards,
Bharathiraja Kaliyamoorthy

geesyscare's Website