please look up the account file attached and import it into a test GNUcash , hope this is what you are aiming for. Use File-> import->Import Accounts from csv
it has Asset, Liability and Expenses structure Saludos Cordiales Murugan ________________________________ From: Kalpesh Patel <[email protected]> Sent: Wednesday, February 1, 2023 2:37 PM To: Murugan Muruganandam <[email protected]>; Kalpesh Patel <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]> Subject: Re: [GNC] how-to track refinancing and other cost related to it. Sorry I might not have been clear here. You are right, when it comes to GNC accounts. I was more thinking to make that placeholder as an asset account in GNC, and simply think of it as a placeholder from the functional perspective. ------ Original Message ------ Received: Wed, 01 Feb 2023 10:11:09 AM EST From: Murugan Muruganandam <[email protected]> To: Kalpesh Patel <[email protected]>, "[email protected]" <[email protected]>, "[email protected]" <[email protected]> Subject: Re: [GNC] how-to track refinancing and other cost related to it. > You cannot pass entries in placeholder account. It is just a header account. > > > > > Saludos Cordiales > > > Murugan > > ________________________________ > From: Kalpesh Patel <[email protected]> > Sent: Wednesday, February 1, 2023 11:13 AM > To: Murugan Muruganandam <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]>; Kalpesh Patel <[email protected]> > Subject: Re: [GNC] how-to track refinancing and other cost related to it. > > Can the placeholder be the asset account itself? Is that a good practice? > > ------ Original Message ------ > Received: Tue, 31 Jan 2023 09:05:37 AM EST > From: Murugan Muruganandam <[email protected]> > To: "[email protected]" <[email protected]>, > "[email protected]" <[email protected]>, Kalpesh > Patel <[email protected]> > Subject: Re: [GNC] how-to track refinancing and other cost related to it. > > > kalpesh > > > > following can be an option. create a master placeholder as FA shown here to > track the details. > > > > > > Dr Cr > > Loan Against Asset 1 Asset:FA:Asset1 Liability: Loan:Loan1 > > Expenses: FA:Loan Fees > > > > > > Refinancing 1 Liability: > Loan:Loan 2 > > Liability: Loan:Loan1 > > Asset: FA:Asset 2 > > Asset: FA:Asset 3 > > Expenses: FA:Loan Fees > > > > Refinancing 2 Liability: > Loan:Loan 3 > > Liability: Loan:Loan 2 > > Asset: Asset 4 > > Expenses: FA:Loan Fees > > > > > > > > > > > > > > > > > > > > > > > > > > > > Dr > > > > > > Cr > > > > > > > > > > Loan Against Asset 1 > > > > > > Asset:FA:Asset1 > > > > > > Liability: Loan:Loan1 > > > > > > > > > > > > > > > > Expenses: FA:Loan Fees > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Refinancing 1 > > > > > > > > > > > > Liability: Loan:Loan 2 > > > > > > > > > > > > > > > > Liability: Loan:Loan1 > > > > > > > > > > > > > > > > > > > > > > Asset: FA:Asset 2 > > > > > > > > > > > > > > > > > > > > > > Asset: FA:Asset 3 > > > > > > > > > > > > > > > > > > > > > > Expenses: FA:Loan Fees > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Refinancing 2 > > > > > > > > > > > > Liability: Loan:Loan 3 > > > > > > > > > > > > > > > > Liability: Loan:Loan 2 > > > > > > > > > > > > > > > > > > > > > > Asset: Asset 4 > > > > > > > > > > > > > > > > > > > > > > Expenses: FA:Loan Fees > > > > > > > > > > > > > > > > > > Saludos Cordiales > > > > > > > > Murugan > > > > > > > > > > From: gnucash-user > <[email protected]> on behalf of > Adrien Monteleone <[email protected]> > > Sent: Tuesday, January 31, 2023 12:40 AM > > To: [email protected] <[email protected]> > > Subject: Re: [GNC] how-to track refinancing and other cost related to it. > > > > Same way as on paper. > > > > Both of those are expenses. There may be a way to do that with > > sub-accounts though. I think some folks use an 'accumulated > > depreciation' sub-account to not affect the main asset account for that > > item. > > > > The same might be possible with the financing expenses, but are those > > really expenses of that particular asset? It was used as collateral to > > finance something *else* so I would think those financing costs are part > > of acquiring *them* and not the collateral. > > > > Regards, > > Adrien > > > > On 1/28/23 9:19 AM, Kalpesh Patel wrote: > > > Need some thoughts here as to how-to setup my accounts. Disclaimer: this > may > > > somewhat dwell into accounting side as well but given the wide breadth of > > > the user community wanted to hear all different ways to do setup GNC to > > > track everything down to last cent if possible. > > > > > > > > > > > > Situation is as follows: > > > > > > > > > > > > - An asset was purchased with cash > > > > > > - Took a loan out against it a year later > > > > > > - The loan was refinanced 8 years later which paid off > two other > > > assets in the process in addition to previous loan > > > > > > - The loan was refinance again one year later which paid > off > > > previous loan plus it helped finance another asset > > > > > > > > > > > > How should accounts be set up in GNC if someone wants to track the cost > of > > > financing plus the appreciation/depreciation that may be taking place > along > > > the way. > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > To update your subscription preferences or to unsubscribe: > > 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. > > >
Type;Full Account Name;Account Name;Account Code;Description;Account Color;Notes;Symbol;Namespace;Hidden;Tax Info;Placeholder ASSET;Assets:FA;FA;;;;;USD;CURRENCY;F;F;T ASSET;Assets:FA:Asset 1;Asset 1;;;;;USD;CURRENCY;F;F;F ASSET;Assets:FA:Asset 2;Asset 2;;;;;USD;CURRENCY;F;F;F ASSET;Assets:FA:Asset 3;Asset 3;;;;;USD;CURRENCY;F;F;F LIABILITY;Liabilities:Loans;Loans;;Loans;;;USD;CURRENCY;F;F;T LIABILITY;Liabilities:Loans:Loan 1;Loan 1;;First Loan;;;USD;CURRENCY;F;F;F LIABILITY;Liabilities:Loans:Loan 2;Loan 2;;Refinance;;;USD;CURRENCY;F;F;F LIABILITY;Liabilities:Loans:Loan 3;Loan 3;;Refinance 2;;;USD;CURRENCY;F;F;F EXPENSE;Expenses:FA Expenses;FA Expenses;;;;;USD;CURRENCY;F;F;T EXPENSE;Expenses:FA Expenses:Loan Fees;Loan Fees;;;;;USD;CURRENCY;F;F;F EXPENSE;Expenses:FA Expenses:Loan Interest;Loan Interest;;;;;USD;CURRENCY;F;F;F
_______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: 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.
