Re: Find Transaction Result – Can’t change View

Michael Hendry hendry.michael at gmail.com
Tue Mar 17 20:41:53 EDT 2015


> On 17 Mar 2015, at 17:48, farmerjohn <rich.lipscomb at gmail.com> wrote:
> 
>> Search output is considered a General Ledger (which is also always
>> expanded) because the Search Results are generally not limited to a
>> single account.  So no, there is no way to make it single-line mode.
> 
>> What exactly are you trying to do?  Perhaps there is a better way to do
>> it, perhaps using something like the Transaction Report? 
> 
> my wife has some out of pocket expenses she gets reimbursed for.  I print a
> report of those expenses that have not been reimbursed for (in
> expenses:teaching:supplies) as well as exclude the expenses she has been
> reimbursed for and its corresponding reimbursement pmt.
> (income:Reimbursements).  Presently, I am "tagging" with 'paid;' in the memo
> field for those expenses that have been reimbursed.   The transaction Report
> alows me to 'exclude'  "income:Reimbursements" which works well but I've yet
> to figure out a way to exclude expenses tagged as 'paid;' in the memo field. 
> Here are the matching transactions I would want to exclude in the report:
> 
> expense:supplies  DR 25   Cash CR 25                 // memo: paid;
> Cash DR 25  income:reimbursement  CR 25
> 

I would create a new Asset account - for example Assets:Current Assets:Reimbursable Teaching Expenses.

When your wife buys something reimbursable, the transaction should be between the Cash account and the new Asset account.

When payment comes in - let’s say it’s a cheque - then you will debit tour current bank account when the cheque is paid in, and the credit the Asset Account.

You know everything’s been repaid when the asset is zero.

Should your wife buy some items for personal use at the same time, simply split the debit between the liability account and the relevant expense account.

I use this method to keep track of reimbursement of vet’s fees by my insurance company - not all fees are reimbursable, so I have to split these between the asset account and the Net Vet Costs (expense) account.

Michael Hendry





More information about the gnucash-user mailing list