[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