Splitting transactions

David sunfish62 at yahoo.com
Fri Jan 11 02:04:35 EST 2013


I'd keep it simpler : I'd have the two expense accounts you mention, and when I received the bill and paid it, I'd create a single payment transaction split between the two parts.

For example, say I received a bill for 150, with 100 for gas and 50 for electric:

Assets:Current assets:Checking.   -150
Expenses:Utilities:Gas.   100
Expenses:Utilities:Electric.  50

Of course, the A:P approach would work, if that's your thing.

HTH,
David



_____________________________________________
From: Graham Stoddart-Stones <gstones at pacifera.com>
Sent: Thu Jan 10 19:35:59 PST 2013
To: Niranjan Rao <nhrdls at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: Splitting transactions


Niranjan: 


Here is one suggestion: 


1. Set up Expense:Utility:Gas 
2. Set up Expense:Utility:Electric 
3. Set up Liability:Accounts Payable:xxxx (name of your service provider) 
4. Set up a Vendor Account for your service provider 


When you receive an invoice from your service provider, enter it via Business, Vendor, New Bill, and enter the invoice as two lines - one for the Gas, and one for the Electric, applied to the relevant Expense Accounts. When you Post the Bill, allocate it to the Liability: Accounts Payable for your service provider. 


You will then be able to see at any time what you have paid for Gas, what you have paid for Electricity, and what is paid/due to your service provider. 


There are other ways of setting this up, please note that this is just one option. In particular, setting up your Accounts Payable is a matter of choice: the reports will only run on the top-level Accounts Payable, so if you set it up as I have suggested, that report does not run properly (e.g. you will not get an Ageing report on your Payables), but you will be able to see at a glance what your Liability is to each vendor. It is a matter of choice, which may depend upon how many accounts you are running, and how big the whole system is - ie just household, or an entire business 


Hope this makes sense 


Graham 
----- Original Message -----

From: "Niranjan Rao" <nhrdls at gmail.com> 
To: gnucash-user at gnucash.org 
Sent: Friday, 11 January, 2013 3:06:26 AM 
Subject: Splitting transactions 

Hi there, 

I am a brand new user of gnucash - have been using it for may be two days. 
To put things in perspective I have almost next to nothing knowledge of 
accounting. But I did went through the manual on the site. Still trying to 
set the all the accounts. 

I have one provider that provides both gas and electric. I want to track 
individual spending on gas and electric as well as how much I pay to 
provider. In other words, I want to know my total bill for the month was 
xxx, but still want to split the bill in individual parts. I am trying to 
assign gas/electric portions to appropriate accounts. What is the best way 
to see my total bill to my service provider? 

By the way, is it possible to open the document in complete window without 
frame. It's big and reading it in existing frame makes it difficult. I know 
I can open it in different tab etc, but still.... 

Thanks, 

Niranjan 
_____________________________________________

gnucash-user mailing list 
gnucash-user at gnucash.org 
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. 

_____________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
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.


More information about the gnucash-user mailing list