Re: [GNC] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

 What are txns? Transactions?
I sorted the Transaction Report by "amount" but I don't know how to limit the 
output to values greater than zero... or to values less than zero.
Do I do that on the Filter tab? And if so how?
If its Regular Expressions my eyes just rolled back in my head :-)
Thanks for  the help.


On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone 
 wrote:  
 
 On 11 May 2021 at 12:41, Fran_3 said:

> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.

Start by selecting only the relevant txns, perhaps?
e.g. Value has debits greater than 0.00



___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Equity Accounts - Opening Balance or no?

[David Cousens]

Troy,

The Opening Balances in Equity record the net worth of your Assets and
Liabilities at the time you open a new set of books/file. The option to
create them when creating a new file is to accommodate the situation where
you are transferring existing balances from a previous set of books/file.

If there are no existing Assets and Liabilities at the time the book is
opened then you would not create them, i.e  a new business the option should
be checked off.

You can always manually create the transactions at a later stage if you need
to.

To record the value of an existing asset you would debit the corresponding
asset account for the value and credit the value to the Equity:Opening
Balances account. 
 
To record a liability you would credit the corresponding liability account
for the value of the liability and debit  the value to Equity:Opening
Balances account. 

The Opening Balances option on file creation just creates these entries when
opening a new file using the balances entered for the Asset and Liability
accounts. It will not allow you to enter balances for other types of
accounts.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to Find... account

[Paul Kinzelman]

I've read thru the documentation about find and have a couple of questions
to which I can't find the answers in the docs...

Every time I go invoke Find, it comes up with the Refine current search
option set, not New search,
and I'm wondering why this is if I haven't done a previous search since 
I started

gnucash? Why wouldn't a new Find start out with New Search by default?

To do a Refine search, does the previous search have to be displayed in 
a tabbed

window or does it remember the previous search somehow? And why even have
that option when you can just do another Find while focused on the search
results window of the previous search?

More specifically, I don't understand the difference between 'Account' and
'All Accounts' as described in the documentation and I'm confused by
the d and e footnotes.

If I have an account open (like Visa) and I'm searching for a
transaction with the Expenses:Computer account in Visa, if I do:
Account | matches any account | Choose Accounts... Expenses:Computer
nothing will be found. But if I do
All Accounts | matches all accounts | Choose Accounts... Expenses:Computer
the transactions I want *are* found. Why is that?

In other words, footnote 'd' implies to me that
the Account I specify there merely establishes
the account in which I want to search, but then how do I specify the
'Transfer' account entry for which I'm searching within that account?



___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Equity Accounts - Opening Balance or no?

[Troy Spindler]

Hey all.

Does anyone know what's the difference between an Equity account with vs.
without having "Opening balance" checked off? From what I can tell, they do
the same thing.

I have a new business with its own Gnu Cash file, and I'm trying to record
my transfers from my personal accounts as equity rather than income. It
seems right to use an "Opening balance" account to record my initial
investments I made in the company, but should I treat all future transfers
from personal the same way? If so, what would a Equity account that isn't
an Opening balance account be used for?

Thank you,
Troy
___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need Transaction Report on Checking to show only Debits

[Fred Bone]

On 11 May 2021 at 12:41, Fran_3 said:

> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.

Start by selecting only the relevant txns, perhaps?
e.g. Value has debits greater than 0.00



___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

How can I create a Transaction Report on the Checking AccountAnd show only 
Debits?Or show only Credits?
Thanks for any help.
___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Migrating and updating version 2 to 3, originally RE: Migrating and updating version 2 to 4 (Geert Janssens)

[rmomxtx]

Thanks Geert,

Sending this again after I saw that my subject line was not specific. Sorry.


Just now getting around to the steps you suggested to migrate and update
version 2 to 3 and then to 4. I'm being treated for cancer so don't have the
usual energy plus I am doing this at a distance with friends in Mexico via
Zoom. Some answers to your questions and some questions of our own plus a
problem showing the sub-accounts on the chart of accounts.

1. "Saved custom reports is slightly ambiguous..." To clear that up, we are
talking existing report configurations that we have tweaked and saved to
"saved report configurations." 

2. You mentioned a migration tool. Is that a separate program or part of the
installation program? 

3. We chose the second approach, copying the data and metadata to the new PC
and doing the updates there. Stuck on upgrading from 2.6.21 to 3.11 on the
Windows 10 computer. Not sure we did the metadata part correctly.

4. Does metadata mean the entire .gnucash file found in
USERS/username/.gnucash? We did copy that entire file from the Windows 7
computer to the Windows 10 computer in the same place. We created a GnuCash
file in Documents on the new computer and copied over the data file there
from the Windows 7 computer. Then we installed the program, clicked "finish"
opened the program and opened the data file from the file in
Documents/GnuCash.

5. All the customer accounts were there and the chart of accounts was
complete. Didn't take much to remember how to add columns to the chart of
accounts page and sort on the account code. 

On the chart of accounts page, all of the parent accounts were closed with
the arrow to the left. Assets opened and showed all of the sub-accounts but
none of the other parent accounts would open. We have a further division
between cash and bank accounts and at least one of the sub-parent accounts
would not open. There are 3 levels of sub-accounts: banks and cash. Under
cash, there are several second level accounts plus about 4 cash reserve sub
accounts. 

We ran Action>Check and repair>Check and repair all. That seemed to work at
first as the rest of the asset sub-accounts and the liabilities sub-accounts
opened. But before the process finished the program crashed. We opened it
again and got the message that the program had closed abnormally. We opened
it normally to see if it worked and it had, at least as far as the cash
accounts were concerned. So we ran the Check and repair all option and the
asset and liability sub-accounts opened and the sub-account journals showed
transactions and had the correct balances. The rest of the parent accounts
still did not open correctly to show sub-accounts so we ran Check and repair
again. Got a little further this time but the program crashed again. 

We opened the program again with the same message that the program closed
abnormally. Chose open normally. This time the liabilities sub-accounts were
opened but none of the rest of the parent accounts opened. We tried another
idea, selected assets and ran Check and repair sub-accounts. That brought
back the asset sub-accounts to the second level. 

When we were running the Check and repair programs, we noticed that the
icons and menus were grayed out and accessible but did not see any other
indication that the program was running or when it would be finished. We may
have jumped the gun and tried to open some of the other parent accounts to
see the sub accounts before the process finished so we tried again and let
it alone to see if the icons and menus would come back as an indicator that
the process was complete.

We ran out of time and energy and decided to try again another day. We had
to go back to the Windows 7 computer to do a couple of accounting tasks that
needed to be done so we will have to start over but from where? 

The tweaked and saved reports did not migrate. 

Thanks again,
Roger

-Original Message-
From: gnucash-user  On
Behalf Of gnucash-user-requ...@gnucash.org
Sent: Wednesday, April 7, 2021 11:00 AM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 217, Issue 16

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of gnucash-user digest..."


Today's Topics:

   1. Re:  Migrating and updating version 2 to 4 (Geert Janssens)


--

Message: 1
Date: Wed, 07 Apr 2021 10:48:44 +0200
From: Geert Janssens 
To: Gnucash 
Cc: Roger Oliver 
Subject: Re: [GNC] Migrating and updating version 2 to 4
Message-ID: <1711197.tlkxdtw...@legolas.kobaltwit.lan>

[GNC] Budget Report - expressed as a percentage

[Bruce Lang]

Is there any possibility of considering adding to the Budget Report, the 
ability to select an option for the Diff column to display as a 
percentage of the Actual/Budget? It would make reporting somewhat more 
convenient. The feedback I receive from those who read the reports i 
they would prefer to see the difference expressed as a percentage 
achieved of the Budget (to compare against the months of the year - e.g. 
at 9 months, expect to see a 75% achievement).


--

Thanks,

*Bruce*



--
This email has been checked for viruses by AVG.
https://www.avg.com
___
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 are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Using the advanced portfolio report for mutual fund income

[Deva -]

I'm glad to hear that your problem is resolved.

Copying the list for the benefit of millenials (pre and post)...

Cheers,
Deva


Sent from Outlook


From: Alister Briggs 
Sent: 10 May 2021 17:59
To: pobox.d...@outlook.in 
Subject: Re: [GNC] Using the advanced portfolio report for mutual fund income


Hello Deva,

In fixing the problem with this report I am reminded of a quote from Winston 
Churchill in the early days of the second world war "Americans can always be 
trusted to do the right thing, once all other possibilities have been 
exhausted". I have done the same in respect to this GnuCash report. If I'd 
followed every step of your advice it would have been fixed much more quickly. 
Things started to go wrong when I entered the bank transaction into the staging 
account before entering each fund distribution. The transaction order entry in 
the staging account seems to be important. After that failure and several more 
my efforts faded. Then I read your email again and Eureka ... it works!

I apologise for the lateness of my response, and thank you for your advice.

Best regards

Alister


On 5/09/2020 4:31 pm, pobox.d...@outlook.in wrote:
Alister,

I had a similar problem when I recorded multiple stock buys in a single 
transaction covering over a dozen splits to account for purchases in different 
stock accounts along with its attendant brokerage and statutory levies. 
Advanced portfolio report would show incorrect brokerage amounts in that case.

The way I got around it was to create a dummy asset account (called $Cash in my 
case, but you can call it "Broker" or "Suspense” or “Staging” account, etc.). 
This is a dummy asset account that acts as a staging account - a sort of a 
bridge between fund/stock accounts and your bank account. This account is of 
simple type Asset (not Mutual Fund or Stock). And it can reside under the main 
“Investments” asset account. For example -

Assets:Investments:$Cash
Assets:Investments:Mutual Fund:Fund1
Assets:Investments:Mutual Fund:Fund2
.
.
. and so on...
Assets:Investments:Stocks:Stock1
Assets:Investments:Stocks:Stock2
.
.
. and so on...

The idea is, $Cash will always be a zero balance account after your record all 
your transactions.

With this structure in place, you can record multiple distributions from your 
fund house as if they were single distributions on each fund (as you stated in 
example 1), but instead of depositing your bank account, you would deposit your 
$Cash staging account instead. After recording your $75 distribution from fund 
1 and $25 distribution from fund 2 in the respective fund accounts, you would 
now have a balance of $100 in your $Cash (staging) account.

Now from your $Cash account, record a single transaction to move $100 from it 
to your bank account. This will bring your $Cash account back to 0.

$Cash account will not be visible if you have your settings to hide zero 
balance accounts, so you have to change that setting for you to use $Cash 
account every time.

Cheers,
Deva

On 04-Sep-2020, at 9:30 PM, 
gnucash-user-requ...@gnucash.org wrote:

Date: Fri, 4 Sep 2020 15:02:55 +1000
From: Alister Briggs mailto:aliste...@gmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Using the advanced portfolio report for mutual fund
income
Message-ID: 
<03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed

Can anybody help me work around a problem using the Advanced Portfolio
Report to report income on mutual funds where a single payment is made
for multiple funds? The Advanced Portfolio report requires atransaction
split to include a dummy transaction of zero value as shown below:

Scenario 1 - A single distribution payment per fund

Direct Credit CFS Distribution







100



100



Assets: Bank: CBA



100







Income: Mutual Funds: CFS: Fund1





100





Assets: Investments: Fund managers: CFS: Fund1



0



0











In this situation the Advanced Portfolio Report correctly reports the
income for Fund1 as $100.

Where more than one fund is paid the split becomes more complicated:


Scenario 2 - A single distribution payment for two funds

Direct Credit CFS Distribution







100



100



Assets: Bank: CBA



100







Income: Mutual Funds: CFS: Fund1





75





Assets: Investments: Fund managers: CFS: Fund1



0



0





Income: Mutual Funds: CFS: Fund2





25





Assets: Investments: Fund managers: CFS: Fund2



0



0



In this situation the Advanced Portfolio Report incorrectly reports the
income for both Fund1 and Fund2 as $100. How do I correct this so the
result for Fund1 is $75 and Fund2 is $25?

I am using GnuCash 4.1 on Windows 10 and fairly new user.


Thank you for your efforts

Alister


___