hi!

I work with kmymoney for a while now and it's really good.

One thing I can't figure out though is: I want to have some categories doing split transactions automatically to a certain % of the incoming money.

For example I work on some jobs but have to pay a certain percentage as fee or provision to another person. I understand that I could set this up as "tax" somehow but then I don't know how to make sure the "fee" or provision gets ascribed to the right account.

So the basic question here is how to configure split transacion in an automated way with a certain preconfigured split that is sent to different accounts without manually calculating the right split ammounts everytime.

I am a bit lost here. Any help?

thx for reading,
piedro

There is no way to do that at the moment. You can have estimated amounts, but then you'll have to modify the amounts when you enter each transaction. Sorry about that.

That is really sad ...

Is there any way (as a workaround) to configure different tax accounts? Meaning: Can i set up to which account the tax is transfered?
If so I could set up an account for the tax of let's say 25%. But then use this tax account to retransfer the money elsewhere?

Just an idea....

thx for your attention,
piedro

p.s.: the tax spliiting process hsows me that the autosplit feature clearly is implemented in the program ... just not exactly my way ...

seems really complicated ...

Is there a way to use an account or category as tac account and also tax the same account?
E.g. have an account designated as tax account for 27.5 percent called "provison" and mark it also as taxable for 19% VAT?

proabably the easiest solution from a conceptual view would be to allow the split transaction dialog to accept percentages also instead of exclusivly absolute values (or to accept a formular as entered in the Kcalc interface ...

thx ,
piedro

Let's see, I try to understand what you need to do.

First you need to identify the accounts you will need for this. The first one is your checking account (C) which keeps the money actually earned and spent. Next, you have an income category (I) and a provision earned (PE), which is also of type income. Then you have an expense account named provision paid (PP).

PE needs to be setup as VAT account (mark the 'VAT category' option in its tax settings). Assign it the percentage you have to put aside. Create a PE for each percentage/recipient you need.

I needs to be setup as income category. Mark the 'Enable auto VAT assignment' and select PE as the respective account. Create an I account for each existing PE one. Select 'Gross amount' on the tax tab.

Create PP as regular expense account

Now if you receive money, create a transaction in the C account. Use I as the category and enter the gross amount of the payment (the part that goes into I plus the one that goes into PE). Enter the transaction. This should automatically create the splits as you want them. Changing the gross amount recalculates the splits.

If you need to make a payment of the provision, create a transaction in C and select PP as the category. Setup a report showing PE and PP to get an overview of the situation.

I hope that makes sense somehow.

@ ipwizard: thx you so much!

I got confused at some point cause it's a bit more complicated in my setup than that and I probably should get more basic knowledge on accounting also.
Now I figured it out and it woks! Yay and hearts to you!

But to be honest it's still a quite crude workaround for a missing basic feature.
Here are the two major problems I had to solve after I could get something working by adapting my accounts to your pattern:

- VAT isn't calculated like normal percentages for provisions. So if you set the I category to use the gross amount you can not use the percentage you want to set aside for the PE account. You have to transform your percentage to represent a VAT percentage. E.G. if you set the VAT precentage to 25% it will actually only get 20% into the account. Cause you want a direct percentage of the full gross amount and not (like VAT is calculated) the percentage of the net amount that iadded to the net amount to get the gross amount. What you have to calculate to transform the right percentage is to use this formula:

VAT (which has to be enter to get the right results) = 100 * ( 1 / ( 1 - (the expected percentage / 100)) -1 )

This works perfectly just doesn't look nice - for example if you have to give away a big chunk, let's say 2 thirds of of your earnings, then you have to enter 200% VAT which is a bit counter intuitive. Still works though ...

- the second issue is that you cannot use your Income category I to also designate a split for your real VAT! You can't have a double split by this system as far as I can see ... You can however use I as an arbitrary account and then retransfer the money every now and then to the correct permanent income category which is then set up to split the tax ... a bit clumsy, but works and is still less effort than manually splitting every time!


So thx again, your solution really help me to sort things out, I am very happy!

Clearly the best solution imho, as I suggested before, would be to simply add a possibilty to set up a percentual split option in the split transaction dialog (well I know it's not just the GUI) ...

cya,
piedro