report: aggregate interest per account

Maf. King maf at chilwell.net
Thu Apr 24 16:25:03 EDT 2008


On Thursday 24 Apr 2008, Tarlika Elisabeth Schmitz wrote:
> I presume the following is not possible:
>
>
> I need to produce a list of all bank accounts that received interest
> during the tax year, ideally with the interest total and tax deducted
> at source total. (In the UK, banks deduct 20% and pass it on to the
> Revenue.)
>
>
> The best I could come up with is a transaction report listing all
> transactions against the Income.Interest account during the year and
> then go through them one by one.

Hi,

Can you run the transaction report on income:Interest (and 
Expense:Tax_Taken_Off_Interest) and subtotal by "other account"?

Just a though, and I haven't looked at the options drop-down combo

FWIW, I have Income:Interest-Gross and Income:Interest-Net to reflect the way 
that different banks show the interest they have paid.  Also, I'll note that 
with the change in layout of the UK tax return this year, it is my 
understanding that you only need the net interest total, not gross and tax 
deducted as in previous years

HTH,
Maf.


More information about the gnucash-user mailing list