Re: [GNC] Account setup for reports

I wrote a REXX program (Perl would also work) to do text processing on a QIF file, creating a new QIF file. The Quicken QIF transaction: ^ D1/ 7'16 T75.60 CX Pdr. miller Mfjt cleaning L[fjt-tex-check]/fjt:160107 gets turned into: ^ D1/ 7'16 T75.60 CX Pdr. miller Mfjt cleaning L[fjt-tex-check] S

Re: [GNC] Account setup for reports

That's an interesting idea. I can't imagine it would involve too much-- swapping the slash with a line feed and the appropriate account strings. I don't recall the QIF format that exactly, though, to be sure. David On April 27, 2022 9:56:29 PM EDT, Fred Tydeman wrote: >Has someone written a p

Re: [GNC] Account setup for reports

Has someone written a program to transform a *.QIF file into another *.QIF file with the Quicken class data (the text after the '/' in the Cat field) into dummy split transactions with the class data as the account on dummy split? Since a gnucash transaction can have multiple splits, that is a way

Re: [GNC] Account setup for reports

Thank you. Comment 6 with the dummy accounts added as $0 splits seems good enough for my needs. On Wed, Apr 27, 2022 at 2:44 PM flywire wrote: > https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html > is part of a discussion on classes. > ___

[GNC] Account setup for reports

https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html is part of a discussion on classes. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mail

[GNC] Account setup for reports

[Sorry for the bad posts, but I was having issues with the other email program] I would like to produce reports that show: money spent on meals, hotels, ... money spend on various trips In Quicken, the transactions were coded as: Expense:meals/home Expense:meals/20210112 Expense:hotel/2

[GNC] Account setup for reports

[Sorry for the bad posts, had problems with email program] I would like to produce reports that show: money spent on meals, hotels, ... money spend on various trips In Quicken, the transactions were coded as: Expense:meals/home Expense:meals/20210112 Expense:hotel/20210112 Expense:mea

[GNC] Account setup for reports

[It appeared in my email program that the previous post has a Subject line] ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you ar

Re: [GNC] Account setup

thanks a million. Rogier Fentener van Vlissingen

Re: [GNC] Account setup

Rogier The GunCash Help manual https://www.gnucash.org/docs/v4/C/gnucash-help/trans-edit.html discusses this very briefly " press the Split button on the Toolbar or select Actions → Split Transaction". The entry of multisplit transactions is discussed in detail in the help manual at https://ww

Re: [GNC] Account setup

thanks, I agree with you, in this case though it is about the one time setup of the opening balances, and I made a typo, but I was not able to figure out how to edit the transaction. But I think maybe I have it now, I think it is you go in to the GL Journal and then you can edit the line items. Th

Re: [GNC] Account setup

On 9/28/2021 1:16 PM, Rogier F. van Vlissingen wrote: Thanks to everyone for helping out. What worked for me in the end was 1. to set up the COA first, without attempting any opening balances, and then 2. to create a single transaction to set up the opening balances on 1/1/2020.

Re: [GNC] Account setup

Thanks to everyone for helping out. What worked for me in the end was 1. to set up the COA first, without attempting any opening balances, and then 2. to create a single transaction to set up the opening balances on 1/1/2020. As it was, I had an ending trial balance on 12/31/2020, bu

Re: [GNC] Account setup

On 9/22/2021 10:14 PM, davidcousen...@gmail.com wrote: Rogier, Retained Earnings is an equity account so a retained earnings balance is recorded against equity itself as follows if your past retained earnings were a net profit (credit or +ve balance in your pevious set of accounts). If a net los

Re: [GNC] Account setup

Thanks to all of you for responding. I will sort it out now, - Fortunately, the number of accounts is small, so it is manageable. - Unfortunately, that trial balance is all I had, plus some manual corrections that were made at tax time that will have to be entered once I set it up, then do a year e

Re: [GNC] Account setup

Rogier, Retained Earnings is an equity account so a retained earnings balance is recorded against equity itself as follows if your past retained earnings were a net profit (credit or +ve balance in your pevious set of accounts). If a net loss (debit or -ve balance_ then the debit and credit would

Re: [GNC] Account setup

E.g. "retained earnings" has a balance, but in the set up screen there is a greyed out "zero" and I cannot set up the opening balance. Can I edit that later? I tried this before, but was never able to figure it out. You did NOT tell us the "state" of the books of this business. And you sai

Re: [GNC] Account setup

No, you don't want Imbalance-USD to have a balance. That's a safety-valve account that GnuCash uses when you make an unbalanced transaction by mistake. Opening Balances is for personal books. For a business you have two kinds of Equity: Paid in Capital, which is the money that you and any partne

Re: [GNC] Account setup

I guess that goes to Imbalance-USD, but then how does that balance out? Or is it that once all the amounts are correct, it will balance and the imbalance must revert to zero? How does that happen if some of the opening balances were non-zero out of thin air? On Wed, Sep 22, 2021 at 4:21 PM Rogier

Re: [GNC] Account setup

OH, thanks Yeah, I already proceeded, I filled in the opening balances where I could, and am now starting to create the other accounts which did not exist in the standard chart of accounts, but trying to go and edit "retained earnings" I do not see how I can add the opening balance. it's not too

Re: [GNC] Account setup

Roger, I found it easier to leave all the opening balances at zero while setting up the chart of accounts (COA).  Then I create one massive opening transaction dated (in your case) 12/31/2019. That way, if I find I forgot one account, I can add it later then go back and adjust the opening tr

[GNC] Account setup

I am struggling to move an existing business into gnucash. Have a closing trial balance @ year end 2019 In the setup screen I don't necessarily have all the accounts, so I imagine I can set them up later, but some accounts that area available do not let me put in an opening balance. E.g. "retai