[GNC] Splitting a Transaction (SOLVED)

Mon Dec 19 06:12:37 EST 2022

Good Morning from an even wetter but warm (14.5 C) Wales

Thank you all for your further thoughts and useful suggestions.  For the 
benefit of any following Newbies I will quickly summarise what I think 
one needs to know about Split Transactions.

    1.   The Help System does not yield useful guidance but it is there 
if one knows where to look: §6.4 Multiple Split Transactions 
[https://www.gnucash.org/docs/v4/C/gnucash-help/trans-multi-enter.html 
<https://www.gnucash.org/docs/v4/C/gnucash-help/trans-multi-enter.html> 
]
    2.  Separate out your spilt transaction source documents into a 
batch and then post them all together.
    3.  Before starting go to Edit\Preferences\Register Defaults and 
select Auto-Split ledger
    4.  For an example try Tesco £15.20 to be split into Groceries 
£11.50 and Dog Food £3.70.
    5.  Enter Tesco in the Memo column and then hit Tab which wil take 
you to the next (brown) line. Enter 15.20 in the 'Withdrawal' (Credit) 
column. Note that the Account column now shows the name of your Bank 
Account.
    6.  Tab to the next line and enter Dog Food in the Memo column and 
hit Tab
    7.  Your cursor is now in the Account column. Click on the drop down 
list and select the account in which you record Dog Food.
    8.  You will notice that there is 15.20 in the 'Deposit' (Debit) 
column. Hit Tab and then enter 3.70
    9.  Hit Tab 3 times to get to the Memo box on the next line down. 
Enter Groceries then Tab to the 'Account' column.
    10. Use the drop down list to find the account under which you 
analyse Groceries.
    11. Since Groceries are the remainder of the invoice amount you will 
see that the 'Deposit' column shows the right amount. When there are 
more analysis items simply Tab to the 'Deposit' column and enter the 
amount for the next analysis.  Carry on with that process until there no 
more un-analysed parts of the invoice.
    12. Finally, hit return.

Having posted up your batch of split transaction invoices go back to 
Edit\Preferences\Register Defaults and select Basic ledger.  This will 
hide the extra lines that are shown when doing split transactions.  This 
gives a 'cleaner' display for non spilt transactions.

To find out what can go wrong and how to fix it scroll though this 
thread.

End of Suggestion.

My thanks go out to everybody who has contributed to this thread.  I am 
pleased to report that this learning has been well practiced as I set 
out to reconcile the bank.  What showed up was that Quicken had been 
randomly (or more correctly haphazardly) losing transactions.  That 
accounts for the odd results I was getting that warned me it was time to 
give up on Quicken after 36 years of use.  Happily I was able to fill in 
many of the gaps then drop in a big 'adjusting balance' to get the 
accounts and the bank statements to align.  Hopefully my record keeping 
should be more normal from now on.

Regards

Pete

------ Original Message ------
From: "Adrien Monteleone" <adrien.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Sent: Sunday, 18 Dec, 2022 At 22:14
Subject: Re: [GNC] Splitting a Transaction (Newbie Question)
Indeed, §6.4 Multiple Split Transactions, particularly steps 10–15 cover 
this.
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-multi-enter.html 
<https://www.gnucash.org/docs/v4/C/gnucash-help/trans-multi-enter.html>
Regards,
Adrien
On 12/18/22 4:04 PM, Adrien Monteleone wrote:
Though I also suspect this is covered in the Documentation which gets 
rare attention from new users. (I'll have to drag that up to confirm 
myself.)
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447