Withholding tax confusion

Please as advised assign an account or an inventory item to each of them. As they are nothing gets purchased at all by these invoices. Clearing the Suspense account is a must, see https://www2.manager.io/guides/7106

Any balance in Suspense signals a problem. Never attempt to clear the Suspense account with a journal entry. That only hides problems and usually makes both your Balance Sheet and Profit and Loss Statement inaccurate. Problems that caused transactions to post to Suspense must be identified and corrected.

First correct things then review.

Well as they were not assigned to an account and ended up in Suspense there is no problem deleting them and creating a new one, this time with all the fields completed so it will show as duplicate if doing it again.

All transactions that show up in the Suspense account are incorrect.

Trying to understand what is wrong while they are still in the Suspense account is a waste of time. Either delete or correct the transaction before analysing what is the problem

1 Like

I’m lost, I understand what you are saying about the suspense account, but I don’t understand how it relates to the withholding tax issue. I deleted the previous purchase invoice (24386).

I created a new purchase invoice, and assigned it to the expense account “House rent”.

View:

Edit:

Withholding tax payable:

Summary: Accounts payable for that supplier

These are my test
Purchase Invoice


Edit view of Purchase Invoice

Summary / Withholding tax payable

Drill down on supplier

Summary / Accounts Payable

Drill down on supplier

All seems good for me

Yes, looks correct. So what the frick is happening on my end? :grin:

I am sorry to say but you are reluctant to follow my advise. As such I am sure others will now take over as I explained several times what you need to do.

@eko That was not my intention. I read through your replies again and I’m not sure what I failed to provide.

Are you saying that other transactions in suspense are causing this issue?

The first explanation you provided was that there were 2 purchase invoices, but that was not the case.

Second explanation was to delete the purchase invoice and do another one assigned to an expense account. I did that, but the issue persists.

I apologize in advance if I missed something, but as of now I don’t understand why the purchase invoice reflects like this. What @Joe91 showed is the expected behavior.

I advised to delete both of them because they are in suspense and create a single new one. This would not result in two Purchase invoices but one.

I’m not ruling out that I’m losing my mind here or that I’m missing something.

The two entries in suspense were caused by one (1) purchase invoice as I showed above. When I deleted that purchase invoice, both of those entries disappeared.

I then created one (1) new purchase invoice and allocated it to the expense account (house rent) and I showed the results. That one (1) purchase invoice gives me 2 entries into the Withholding tax payable account and 4 entries into the accounts payable for that supplier.

Show screenshots

Also of your complete summary screen

I showed that, you asked me to show the edit screen preciously for the two entries (that came from the same purchase invoice).

Perhaps I don’t understand what you are asking for. I will do it again tomorrow, I need to understand what is happening as this is really messing things up for us.

As you started new as you claim then there would be no evidence of any existing Purchase order. I also advised to use History because when you undo (via History view screens) all that was there related to these purchase invoices would disappear. The shortcut was to delete them. You must realize that whatever you did needs to be illustrated with screenshots.

I thought it was illustrated.

Trying again here.

I did 2 things. I created a new supplier for testing purposes and I created one (1) purchase invoice that looks like this:

Edit screen looks like this:

Summary-Withholding tax payable-Withholding tax test supplier looks like this:

This is my history showing the creation of the test supplier and the purchase invoice. I also changed the date on the summary from a specific date to instead show “today”.

Please let me know if this is what you asked for.

@WildTZ I have been playing around with a test business, and managed to create some issues be it different to yours but equally problematic. To resolve your issues:

  1. Undo all the under investigating Purchase Invoices in History. Be sure you undo all of them from latest to earliest entries. (You need to view each of them and click Undo).
  2. Create a new Invoice and complete all the fields. Most importantly is to select a Supplier and at least 1 item, this could be an Inventory or a non-Inventory item (for example a service). It does not work when selecting an account.

@Lubos may look into this but I expect that this is how it is supposed to function.

Thank you very much for your input. I hope I understood correctly. This is what I did.

  1. I went into history and undid the test purchase invoices.

  2. I went into ‘Settings’ and created a “non-inventory item” call “house rent” that assigns to the “house rent” expense account.

  3. I created a new purchase invoice.

Edit:

View:

Summary-Withholding tax payable:

History:

Same problem.

Questions:

  1. Is this the expected behavior (I guess no).

  2. What could cause this?

  3. What do I do?

Click on the Journal tab in the View Purchase Invoice screen above

What is your base currency?

Our base currency is USD.

Here is the Transaction Journal for the purchase invoice.

Very strange as you say

What happens if you change the amount from 1,111 to say 5,000?

Presumably you are using the built-in Withholding tax accounts and not a customised account ?