gnucash-user Digest, Vol 121, Issue 35
ringoriginal
ringoriginal at yahoo.com
Tue Apr 23 14:14:14 EDT 2013
I have windows XP (and no I don't use my phone for GNUcash, I just don't
have internet at home). I've read through the help manuals and all the FAQ's
nothing about printing.
If I do a screen shot of an open report showing the menu File open and send
it here will the jpeg show?
Connected by DROID on Verizon Wireless
-----Original message-----
From: gnucash-user-request at gnucash.org
To: gnucash-user at gnucash.org
Sent: Tue, Apr 23, 2013 16:04:09 GMT+00:00
Subject: gnucash-user Digest, Vol 121, Issue 35
Send gnucash-user mailing list submissions to
gnucash-user at 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-request at gnucash.org
You can reach the person managing the list at
gnucash-user-owner at 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: Selecting which account for import bank statement
(Derek Atkins)
2. Re: CreateSpace / Royalties / Automatic Splitting? (Derek Atkins)
3. Re: Printing (Derek Atkins)
4. Re: Printing (ringoriginal)
5. Re: CreateSpace / Royalties / Automatic Splitting? (greyproc)
6. Re: Printing (David Carlson)
----------------------------------------------------------------------
Message: 1
Date: Mon, 22 Apr 2013 13:47:59 -0400
From: Derek Atkins <warlord at MIT.EDU>
To: Andrew Wasielewski <andrew at wasielewski.co.uk>
Cc: gnucash-user at gnucash.org
Subject: Re: Selecting which account for import bank statement
Message-ID: <sjmr4i2ihio.fsf at mocana.ihtfp.org>
Content-Type: text/plain; charset=us-ascii
Hi,
Andrew Wasielewski <andrew at wasielewski.co.uk> writes:
> Hello,
>
> I am just starting to use GnuCash to run the accounts for the RMC
> which manages the development where we live. I need to import bank
> statements for bank transaction reconciliation in .QBO format. The
> first time I ran this I got prompted to select which GnuCash account
> to import into, and the import itself works fine. However all
> subsequent times the import is to the same account without giving me
> the choice, even though I have more than one account of type "Bank".
> In production this won't matter as we only have one account, but while
> I am testing different configurations it will be very useful to be
> able to choose.
>
> I have looked through on-line documentation and all the config
> settings I can find, but don't see anything relevant.
GnuCash will automatically attach the account code in the imported file
to the account that you choose, so no, it will not ask you to bind the
import-account to the gnucash account multiple times. The result is
that if you import a file with the same account code it will not ask
you, because according to the data source you are importing the same
account again.
There are two workaround to reset this (other that hand-editing the data
file):
1) Import a data file with a different (or bogus) account code and
re-select the account you want to reset.
2) Create a temp account, delete the account you want to reset, move all
the transactions to the temp account, and then rename the temp
account to the account you just deleted.
> Any help much appreciated,
> Andrew
>
> PS: Is this list still the best way to post questions? I can't find a
> forum anywhere.
Yes, this is it. Forums are for Lusers.
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
------------------------------
Message: 2
Date: Mon, 22 Apr 2013 13:51:21 -0400
From: Derek Atkins <warlord at MIT.EDU>
To: greyproc <greyproc at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: CreateSpace / Royalties / Automatic Splitting?
Message-ID: <sjmmwsqihd2.fsf at mocana.ihtfp.org>
Content-Type: text/plain; charset=us-ascii
Hi,
greyproc <greyproc at gmail.com> writes:
> Thank you for the response!
>
> The transactions I have in .csv are just single transactions. I wish to
> arbitrarily split the amounts when I import them into GnuCash. Is writing
a
> script to convert the .csv file to .ofx, containing the distributions I
want
> the only way of accomplishing this, or is there facility within GnuCash
> itself for allowing me to automate these actions?
>
> Ie, Account A has $100. I want to, upon creating the transaction,
> immediately distribute $50 to Account B and $50 to Account C (as
> liabilities).
>
> Is this possible?
I'm not sure exactly what you are asking here. Perhaps you can use a
firm example? But by the statement of your question I would suggest
that you read the GnuCash Guide to better understand Double Entry
Accounting. I say this because your statement "Account A has $100"
doesn't make sense.
If your question is: Given a transaction that says to credit my checking
account $100, can I split that $100 into, e.g., $50 to
Expenses:Groceries and $50 to Expenses:Home Goods, the answer is no, you
cannot do that automatically, and OFX does not support Split
Transactions. The only import technology that supports that would be
QIF, but you would need to form the QIF file itself to declare the
transaction as a split transaction. GnuCash cannot auto-split a
transaction.
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
------------------------------
Message: 3
Date: Mon, 22 Apr 2013 13:55:21 -0400
From: Derek Atkins <warlord at MIT.EDU>
To: ringoriginal<ringoriginal at yahoo.com>
Cc: gnucash-user at gnucash.org
Subject: Re: Printing
Message-ID: <sjmip3eih6e.fsf at mocana.ihtfp.org>
Content-Type: text/plain; charset=us-ascii
ringoriginal<ringoriginal at yahoo.com> writes:
> How do I print out my account reports when the PRINT button isn't
> highlighted?
Have you tried File -> Print
But I don't understand your initial complaint -- when I'm sitting in an
account report the print button is active.
What version of GnuCash are you using? OS/Distro?
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
------------------------------
Message: 4
Date: Mon, 22 Apr 2013 14:18:51 -0400
From: ringoriginal<ringoriginal at yahoo.com>
To: "Derek Atkins"<warlord at MIT.EDU>
Cc: gnucash-user at gnucash.org
Subject: Re: Printing
Message-ID: <56ecff47-16aa-47a5-adfe-c4f5d0938e3c at blur>
Content-Type: text/plain; Format="Flowed"; DelSp="Yes";
charset="US-ASCII"
I have the latest version since I downloaded only 2-3 weeks ago. But the
print button under the menu file has never been active. I tried exporting to
MS word but that didn't work either.
Connected by DROID on Verizon Wireless
-----Original message-----
From: Derek Atkins <warlord at MIT.EDU>
To: ringoriginal <ringoriginal at yahoo.com>
Cc: gnucash-user at gnucash.org
Sent: Mon, Apr 22, 2013 17:55:27 GMT+00:00
Subject: Re: Printing
ringoriginal<ringoriginal at yahoo.com> writes:
> How do I print out my account reports when the PRINT button isn't
> highlighted?
Have you tried File -> Print
But I don't understand your initial complaint -- when I'm sitting in an
account report the print button is active.
What version of GnuCash are you using? OS/Distro?
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
------------------------------
Message: 5
Date: Mon, 22 Apr 2013 13:24:33 -0700 (PDT)
From: greyproc <greyproc at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: CreateSpace / Royalties / Automatic Splitting?
Message-ID: <1366662273967-4661424.post at n4.nabble.com>
Content-Type: text/plain; charset=us-ascii
> If your question is: Given a transaction that says to credit my checking
> account $100, can I split that $100 into, e.g., $50 to
> Expenses:Groceries and $50 to Expenses:Home Goods, the answer is no, you
Yes, that's exactly what I meant (except, of course, splitting to an author
and an illustrator).
> cannot do that automatically, and OFX does not support Split
> Transactions. The only import technology that supports that would be
> QIF, but you would need to form the QIF file itself to declare the
> transaction as a split transaction. GnuCash cannot auto-split a
> transaction.
Thank you for the answer.
I was hoping that GnuCash could 'learn' the split transactions the same way
it learns the top level ones (ie, the way the csv import is able to
'remember' what I did for a similar transaction --- an awesome feature which
is really working well for me).
Every item of deposit (each book sold) is split into smaller payments
(royalties), and I had wanted to show this as a split on each transaction.
(ie $100 comes in (Asset:Bank), showing 10 transactions of $10, and for
each, $4.50 goes to author (Liabilities:Royalties:Author), $4.50 to
illustrator (Liabilities:Royalties:Illustrator), and $1 to company
(Equity:Revenue)...)
Of course, now, it seems I'm being overly pedantic, and the right way (or,
at least, the way I'm going to do it) is to just do one transaction at the
end of each quarter, to disburse the money appropriately to the 3 accounts
(from Equity:Revenue:Book_Sales).
--
View this message in context:
http://gnucash.1415818.n4.nabble.com/CreateSpace-Royalties-Automatic-Splittin
g-tp4661363p4661424.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
------------------------------
Message: 6
Date: Mon, 22 Apr 2013 16:42:01 -0500
From: David Carlson <david.carlson.417 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: Printing
Message-ID: <5175AEA9.6030909 at gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
On 4/22/2013 1:18 PM, ringoriginal wrote:
> I have the latest version since I downloaded only 2-3 weeks ago. But
> the print button under the menu file has never been active. I tried
> exporting to MS word but that didn't work either.
>
> Connected by DROID on Verizon Wireless
>
> -----Original message-----
> From: Derek Atkins <warlord at MIT.EDU>
> To: ringoriginal <ringoriginal at yahoo.com>
> Cc: gnucash-user at gnucash.org
> Sent: Mon, Apr 22, 2013 17:55:27 GMT+00:00
> Subject: Re: Printing
>
> ringoriginal<ringoriginal at yahoo.com> writes:
>
>> How do I print out my account reports when the PRINT button isn't
>> highlighted?
>
> Have you tried File -> Print
>
> But I don't understand your initial complaint -- when I'm sitting in an
> account report the print button is active.
>
> What version of GnuCash are you using? OS/Distro?
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
There is no version of GnuCash for 'Droid'. Please read the version
from the splash screen or the Help:About screen and tell Derek which
operating system that your computer uses. You might also consider
reading the fine manuals.
David C
------------------------------
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
End of gnucash-user Digest, Vol 121, Issue 35
*********************************************
More information about the gnucash-user
mailing list