Thanks dwg. Had a play and based on your suggestion have created 2 categories. An Income (the 25% HMRC add) and an expense.
There has to be both to balance out that it's not real money in my account. I then just include the income one in a report with all the other standard tax bits. So in the report I see 'income' of the 25% of the donations (plus any tax refunds should I be so lucky!) - then the expense bit shows all the PAYE income tax deductions.
So long as _I_ understand it, then it sort of works! :)
I should have added, the transaction on the (e.g.) credit card has three splits: If the actual, real donation is £100, then there's a split line for £100 with the category 'Charity' - then an income split line for the '25% gift aid bit HMRC add' for £25 with the 'income' category above then a third for the same amount as the expense, so the total for the transaction on the credit card is the £100.
Ah, but if I donate £100 to the charity, the _Government_ add the £25 and that goes direct to the charity. However, I want to record that element in my MD account.
But I never actually see the £25. Hence why I show it as a 'ghost' income which has another paired expense so that my account never shows it as part of my Net Worth. I just want to see £100 to charity and then the 'ghost' £25.
The point being that if in any year I pay zero income tax, I cannot make any gift-aid donations at all as I have paid no tax.
I can only make gift-aid donations where I have paid MORE in income tax than the 25% the Govt adds.
If you add an entry for £100 and split it £75 to the charity and £25 to gift aid MD records £100 against your account which is wrong.
Instead create an account called HMRC Gift Aid. Record the transaction as normal, i.e £75 paid to your charity and then record a separate transaction from your HMRC account to your charity, ie the £25. You end up with:
Credit card -£75.00
HMRC Gift Aid -£25.00
The last thing your need to do is exclude the HMRC Gift Aid account from you networth report.
Over time you will track how much Gift Aid you have donated. If any transaction gets invalidated because of insufficient tax paid you can delete the transactions.
You do not have to enter the Gift Aid transactions at the time of incurring the cost. It can be done at any time.
I do not know if this approach would do what you want but it may give some ideas.
I receive some Tax credits for corporate tax pad on some dividends as I need to track these amounts and report on them. I do it via 2 categories - these credits do not really change my net worth just impact the tax I need to pay. Hence on the Expense side I have created a category call Imputation Tax and on the Income side one Called Franking credits (the names are significant locally) and I perform a transfer between the two categories for the amount involved.
In the UK you can claim charitable donations as an offset to tax. If you Gift Aid it then you give up the right to claim this offset. Instead the Charity receives the tax relief as an extra donation. You as an individual never see the money, it is not part of your net wealth. @Red if I understand it correctly wishes to track this money. Tracking the Gift Aid allows you to calculate your total donations to charity. The approach of using an account shows how much the Government has donated to your charities and allows you to keep it outside your net worth. I am not sure you can do this with Categories as the other side will be against one of your account and thus will be included in the net worth.
When I started using Moneydance I wanted to keep everything in one place rather than having heaps of separate files, I have not achieved my goal as yet since Moneydance lacks some investment actions I really need but have gone a long way.
One of the things I wanted to achieve was to have everything I needed for Taxation reporting in one report, with Reckon I would have to take the data from it and plug it into one or more spreadsheets. With Moneydance the Taxation reports I receive from various investments I enter the data from by using category to category transfers in the appropriate account thus meaning I get an Income and Expense report that gives me much of the data I need, capital gains are still separate but they are so country specific it would need Moneydance to have a report writer to deal with them but at lest I can have the raw numbers in MD.
I still need to have spreadsheets for Investments (especially for RoC transactions) but at least I can store them in the Moneydance Data set structure.
As I started using Moneydance before Tax Date usage was available in many reports. I have used the principles of Accrual accounting to assign payments to the correct time period notwithstanding that they are often paid in a different one, and to facilitate this I use a category like you would an account, even having it visible and usable from the side bar.