[GNC] How to automate $ value on the contra account when editing a transaction

Michael Hendry hendry.michael at gmail.com
Thu Dec 6 12:32:06 EST 2018


> On 6 Dec 2018, at 15:41, Derek Atkins <warlord at MIT.EDU> wrote:
> 
> DIW <wasserland44 at gmail.com> writes:
> 
>> Hi Derek,
>> 
>> I tried the Autofill method you describe.  
>> 
>> It was indeed a revelation.
>> Thank you. For years I have been using the Duplicate Transaction
>> method.  Though it didn't jump to to edit the amount nor did it edit
>> the contra account - if I understood you correctly?
> 
> I'm not sure what you mean here.  When you tab out of the description
> and it autofills the transaction, the next cell you get to should be the
> amount, so you can change the amount for the current transaction.  It
> skips over the transfer account.
> 
> IFF the transaction is a basic, 2-split transaction (and you're in basic
> ledger mode) then if you adjust the amount it will also also adjust the
> contra-account amount.  HOWEVER, if it's a split transaction, or if
> you're in an expanded-view ledger mode then no, it will not adjust the
> contra amount -- you will have to edit it manually.
> 
>> That said, using autofill, tab, is a much better method, just as you
>> say.
>> 
>> I see that I have started an interesting discussion on the subject :-)
> 
> Indeed, you have.
> 
>> Regards
>> Dave W
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek

Hi, Dave.

It’s also quite simple to revise a simple autofill transaction to split it several ways and leave GC to do the arithmetic.

For example, I usually only fill up with petrol at the Tesco Service Station, but the kiosk sells milk, snacks, newspapers, coal, logs etc.


When I start to enter a new transaction, I get an autofilled transaction between my credit card account and Expenses:Motoring, like this:

https://www.dropbox.com/s/wlbwp8biyul3051/Screenshot%202018-12-06%2017.03.38.png?dl=0

I can see the whole transaction by right-clicking and selecting Split Transaction

https://www.dropbox.com/s/h4fhlaan14dlf1o/Screenshot%202018-12-06%2017.04.05.png?dl=0

Let’s say I bought £20 worth of petrol that day, but also bought some groceries for £15, and some coal for £25.80.

First I edit the Motoring figure - making it £20. The unallocated balance appears below:

https://www.dropbox.com/s/wuugwok77sv5ha6/Screenshot%202018-12-06%2017.04.37.png?dl=0

Then I put Expenses:Household into the “Account” space against the unallocated balance, and edit that so that it reads £15:

https://www.dropbox.com/s/sudqipi3peidyfo/Screenshot%202018-12-06%2017.05.18.png?dl=0

Finally, I allocate the cost of the coal to Expenses:Heat Light & Power

https://www.dropbox.com/s/b4tzf3pxdk9m5ts/Screenshot%202018-12-06%2017.05.48.png?dl=0

If I made a typing error, the remainder will appear as an Imbalance-GBP entry.

Regards,

Michael






More information about the gnucash-user mailing list