Re: [GNC] apply coefficient to an account

2019-03-05 Thread elvis
Hi Peter, I have a program in python to add a split like that to a qif file. I had it written to add Australian GST to my transactions after years of splitting them manually. So I download my bank file, run the program, then import with all the splits added. You might need to alter it

Re: [GNC] IRC access

2019-03-05 Thread David T. via gnucash-user
I agree. It would be appropriate to have brief information related to gnucash on IRC, with pointers to official resources.  90% of the content in the current page should go. The introductory paragraph followed by the server, channel, and link to IRC download and help pages should be it.  David

Re: [GNC] MySQL

2019-03-05 Thread David T. via gnucash-user
Thanks for clarifying. I'm probably also mixing some of this in with the whole Python on Macs issue. David On Wed, Mar 6, 2019 at 10:11, John Ralls wrote: David, For 2.6 yes. For 3.x everything is in the bundle for all three database backends just like Windows. Regards, John Ralls

Re: [GNC] IRC access

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 8:01 PM, Frank H. Ellenberger > wrote: > > Am 05.03.19 um 20:56 schrieb John Ralls: >> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/ >> >> Regards, >> John Ralls > > or read (and improve) the wiki ;.) > https://wiki.gnucash.org/wiki/IRC#Usage I don't think

[GNC] printing from version 3.2

2019-03-05 Thread Chris Roy-Smith
Hi, up until there was an update to gnucash v3.2 I had no problems printing, as all available printers were listed in the print dialogue. After the update to 3.2, I only get the option to print to file, or lpt. Printing to file works exactly as I would expect. However, printing to lpt

Re: [GNC] MySQL

2019-03-05 Thread John Ralls
David, For 2.6 yes. For 3.x everything is in the bundle for all three database backends just like Windows. Regards, John Ralls > On Mar 5, 2019, at 6:12 PM, David T. wrote: > > John, for MySQL, don't Mac users have to build Gnucash with the appropriate > libdbd-mysql dependency added in?

Re: [GNC] IRC access

2019-03-05 Thread Frank H. Ellenberger
Am 05.03.19 um 20:56 schrieb John Ralls: > LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/ > > Regards, > John Ralls or read (and improve) the wiki ;.) https://wiki.gnucash.org/wiki/IRC#Usage ~Frank ___ gnucash-user mailing list

[GNC] GNUCash 3.4 has bug for US Tax forms which is using wrong beginning value.

2019-03-05 Thread Brian via gnucash-user
I discovered that my 1120S entity had the wrong totals for the Cash/Assets on the Tax Income/Deductible Expenses Report (tax report) compared to the Transaction Record for the Account. I then ran the tax report with show transaction detail and noticed that the beginning balance was wrong. On

Re: [GNC] Delete multiple transactions (was: gnucash-user Digest, Vol 192, Issue 7)

2019-03-05 Thread David T. via gnucash-user
Of course, should the user wish to delete all records after a given date (or before) they could use the same filtering technique to create a view of the offending records and one by one delete them until the view is empty. This can happen pretty quickly, once the user tells gnucash to delete

Re: [GNC] MySQL

2019-03-05 Thread David T. via gnucash-user
John, for MySQL, don't Mac users have to build Gnucash with the appropriate libdbd-mysql dependency added in? ISTR at some point that we needed to build gnucash ourselves to add this functionality.  Or am I misremembering? David T. On Wed, Mar 6, 2019 at 3:50, John Ralls wrote: > On

Re: [GNC] Suggestions for personal use of GnuCash

2019-03-05 Thread David Cousens
Richard For personal use just select Common Accounts and deselect the Business Accounts when creating the account heirarchy. This is usually the default setup. For an existing heirarchy make sure there are no transactions to the A/R, A/P accounts ( transfer them to other accounts as appropriate)

Re: [GNC] Error on Receivable Ageing Report

2019-03-05 Thread Stephen M. Butler
On 3/5/19 2:33 PM, John Dablin via gnucash-user wrote: > Thanks for the link, it's reassuring that it's not a corruption of my > data file. I've no wish to get bogged down with building GC from > source, so I'll keep my fingers crossed that Ubuntu 19.4 provides > version 3.4. It's not a

Re: [GNC] Suggestions for personal use of GnuCash

2019-03-05 Thread David Cousens
Richard, Rich Shepherd's approach is aprt of the way to accounting for a loan made but one would not usually use the business features for doing this. When you borrow money the loan is setup as a liability account as you are obligated to pay it back. Where you make a loan it will be setup as an

Re: [GNC] Error on Receivable Ageing Report

2019-03-05 Thread John Dablin via gnucash-user
Thanks for the link, it's reassuring that it's not a corruption of my data file. I've no wish to get bogged down with building GC from source, so I'll keep my fingers crossed that Ubuntu 19.4 provides version 3.4. It's not a show-stopper anyway. John Dablin On 05/03/2019 21:54, Christopher

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Stephen M. Butler
On 3/5/19 10:29 AM, Peter Münster wrote: > On Tue, Mar 05 2019, Stephen M. Butler wrote: > >> Could those accounts be treated similar to stock?  Or another >> currency? > I guess no. There are just 2 type of accounts: income in EUR and expense > in EUR. All is imported from the OFX file of the

Re: [GNC] MySQL

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 12:56 PM, Keith Bellairs wrote: > > For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is > my xml file exportable to mysql? If so, is there a writeup? I tried a > couple of obvious things (save as, make myself a dba, create Gnucash schema > in mysql)

Re: [GNC] apply coefficient to an account

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 12:10 PM, Peter Münster wrote: > > On Tue, Mar 05 2019, John Ralls wrote: > >> Just edit the transaction and add a split. You can type '.3*123.45' and >> '.7*123.45' in the expense debit column, no need to get out your calculator. > > Sure. But how can I split *all*

Re: [GNC] gnucash-user Digest, Vol 192, Issue 7

2019-03-05 Thread David Cousens
At present there is no way to multiply select transaction records in the account registers for actions upon them including deleting them. Why do you need to start a new checking account? You can use the View->FilterBy to restrict displays to a specific date period and you can set the current

Re: [GNC] A/R, A/P and Balance Sheet Discrepancies

2019-03-05 Thread Rich Shepard
On Tue, 5 Mar 2019, Tom Balaban wrote: Any thoughts? Hi Tom, Have you looked to see if some transactions are still marked as uncleared? Perhaps that makes a difference when the report end date is prior to the current date. Rich ___ gnucash-user

Re: [GNC] Suggestions for personal use of GnuCash

2019-03-05 Thread Rich Shepard
On Tue, 5 Mar 2019, rro...@pdsconnect.me wrote: I ran dual last year with MMEX (using since 2013) and GnuCash for personal finances. Today I tried to set up loans/mortgages that I have lent, not borrowed, but could not select from assets. Richard, I am not an accountant but my off-hand idea

Re: [GNC] Error on Receivable Ageing Report

2019-03-05 Thread Christopher Lam
https://bugs.gnucash.org/show_bug.cgi?id=796772 Should be fixed in 3.4 On Wed, 6 Mar 2019 at 04:33, John Dablin via gnucash-user < gnucash-user@gnucash.org> wrote: > Has anyone any ideas about this? Should I have sent it to a different list? > John Dablin > > On 01/03/2019 12:20, John Dablin

Re: [GNC] MySQL

2019-03-05 Thread David Cousens
Keith, See the following links for setup on MacOSX with MySQL https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html https://wiki.gnucash.org/wiki/MacOS_Installation https://lists.gnucash.org/pipermail/gnucash-user/2011-February/038511.html

[GNC] Suggestions for personal use of GnuCash

2019-03-05 Thread rrowan
I ran dual last year with MMEX (using since 2013) and GnuCash for personal finances. Today I tried to set up loans/mortgages that I have lent, not borrowed, but could not select from assets. Please consider those of us who are lenders and not borrowers. Also, personal use does not require

[GNC] A/R, A/P and Balance Sheet Discrepancies

2019-03-05 Thread Tom Balaban
Hello, I am experiencing some strange behavior with my Aged A/R, Aged A/P and Balance Sheet. When I run the three reports using "Today" the amounts showing in the Balance Sheet completely agrees with what appears on the respective aging reports. When I change the date on all 3 to the "End

Re: [GNC] gnucash-user Digest, Vol 192, Issue 7

2019-03-05 Thread varda241--- via gnucash-user
Is there any way to select more than one transaction for deleting or duplicating? I normally start a new checking account each January, but did not do it this year till now, due to moving.Sent from my Verizon ASUS tablet Original Message From:gnucash-user-requ...@gnucash.org

Re: [GNC] IRC access

2019-03-05 Thread David Carlson
That looks like what I need. Could that link and perhaps more for other clients be added to the GnuCash faq for IRC access, probably in section on client setup with a reference by the section about getting a voice. David Carlson On Tue, Mar 5, 2019, 1:56 PM John Ralls wrote: > LMGTFY:

Re: [GNC] Fwd: Relative paths in transaction associations

2019-03-05 Thread Justin Haynes
This all worked very well and was very simple in a text editor. The process was deterministic - there was no text that matched my searches other than what needed to be replaced. I'll summarize for posterity: Problem: The problem was that I wanted to be able to use GNUCash from multiple

[GNC] MySQL

2019-03-05 Thread Keith Bellairs
For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is my xml file exportable to mysql? If so, is there a writeup? I tried a couple of obvious things (save as, make myself a dba, create Gnucash schema in mysql) and made no progress. Keith

Re: [GNC] IRC access

2019-03-05 Thread Derek Atkins
/msg nickserv help register On Tue, March 5, 2019 2:50 pm, David Carlson wrote: > I use Pidgin and I cannot figure out how to register with the nickserv. I > enter > > /server irc.gnome.org > > and nothing happens > > > On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins wrote: > >> Hi, >> >> On

Re: [GNC] Error on Receivable Ageing Report

2019-03-05 Thread John Dablin via gnucash-user
Has anyone any ideas about this? Should I have sent it to a different list? John Dablin On 01/03/2019 12:20, John Dablin wrote: I have a small job in retirement maintaining several websites for the clients of my only customer, and I use Gnucash to keep track of invoices and payments. Something

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > Just edit the transaction and add a split. You can type '.3*123.45' and > '.7*123.45' in the expense debit column, no need to get out your calculator. Sure. But how can I split *all* transactions of an account the same way? The only way, that I know, is

[GNC] shared accounts

2019-03-05 Thread Jeff Abrahamson
I have some assets that I share with my spouse.  Two examples are our home and a shared bank account.  In each case, when I compute my own net worth, I want to consider these joint assets with a pre-determined fraction. I can certainly create liabilities to offset those assets and then enter

Re: [GNC] IRC access

2019-03-05 Thread John Ralls
LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/ Regards, John Ralls > On Mar 5, 2019, at 11:50 AM, David Carlson > wrote: > > I use Pidgin and I cannot figure out how to register with the nickserv. I > enter > > /server irc.gnome.org > > and nothing happens > > > On Tue, Mar 5,

Re: [GNC] Getting security prices - Funnies

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 9:36 AM, Eric Coates wrote: > > I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04. > > In the course of some fairly standard (for me) work I have come across a > couple of "funnies" and I'm wondering whether they are deliberate, "features" > (from

Re: [GNC] IRC access

2019-03-05 Thread David Carlson
I use Pidgin and I cannot figure out how to register with the nickserv. I enter /server irc.gnome.org and nothing happens On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins wrote: > Hi, > > On Tue, March 5, 2019 2:31 pm, David Carlson wrote: > > It seems that the IRC channel has changed and now

Re: [GNC] IRC access

2019-03-05 Thread Derek Atkins
Hi, On Tue, March 5, 2019 2:31 pm, David Carlson wrote: > It seems that the IRC channel has changed and now I need a voice. How do > I > do that? If you read the topic when you join the channel, it specifically says: * Topic for #gnucash is: Free GPL Personal and Small Business Accounting ||

Re: [GNC] apply coefficient to an account

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 10:21 AM, Peter Münster wrote: > >> ou could just create two payroll expense accounts, one chargeable and >> one not-chargeable and split the payroll expense between the two. > > The payroll expenses come from OFX files from the bank. After importing, > how can I split

[GNC] IRC access

2019-03-05 Thread David Carlson
It seems that the IRC channel has changed and now I need a voice. How do I do that? -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Could those accounts be treated similar to stock?  Or another > currency? I guess no. There are just 2 type of accounts: income in EUR and expense in EUR. All is imported from the OFX file of the checking account. Here is the result:

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, Derek Atkins wrote: > I would recommend you run the existing P report, then take the output, > copy it into a spreadsheet, and then add your coefficients there. That would be my last resort. Just to show you, that this would be some work: -

Re: [GNC] Importing buying shares transactions

2019-03-05 Thread One Click To Qif
Hi David: I had version 2.6.14 installed and I installed 3.4. However, it is obvious that this functionality does not work: GnuCash cannot import transactions of shares, not even in the format exported by itself. I will have to manually introduce them. Very disappointing. Thanks for your answer

[GNC] Apologies

2019-03-05 Thread Eric Coates
My apologies. It appears that a messgae I sent with the heading "Getting security prices - Funnies" has appeared, twice!,  under the title "Re: [GNC] Payroll Management with Time Attendance Machine" as well as under its own title I have no idea how this happened. Sorry Eric It's also

[GNC] Getting security prices - Funnies

2019-03-05 Thread Eric Coates
I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04. In the course of some fairly standard (for me) work I have come across a couple of "funnies" and I'm wondering whether they are deliberate, "features" (from Microsoft's vocabulary meaning a bug that won't be fixed), bugs

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Stephen M. Butler
On 3/5/19 7:07 AM, John Ralls wrote: > >> On Mar 5, 2019, at 5:28 AM, Peter Münster wrote: >> >> Hi, >> >> For a special report of type "Profit & Loss" I need to apply some >> coefficients to some accounts. For example 0.7 to the account >> "transport". Is this possible with Gnucash, and if yes:

Re: [GNC] Music Teacher: tracking balances owed from students

2019-03-05 Thread D via gnucash-user
Thanks! On March 5, 2019, at 8:14 PM, Adrien Monteleone wrote: Sure, I’ll be out today for Mardi Gras but I should have it up tomorrow. Regards, Adrien > On Mar 5, 2019, at 12:19 AM, David T. wrote: > > Adrien, > > > Any chance you might add these tips to the Using Gnucash wiki page?

Re: [GNC] Payroll Management with Time Attendance Machine

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 8:16 AM, Adrien Monteleone > wrote: > > Jason, > > I’m not sure what ’Time Management Attendance Machine’ is It's a $10 name for https://en.wikipedia.org/wiki/Time_clock. Regards, John Ralls ___ gnucash-user mailing list

Re: [GNC] apply coefficient to an account

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 7:21 AM, Peter Münster wrote: > > On Tue, Mar 05 2019, John Ralls wrote: > >> Apply the coefficients how and with what intended result? > > It's just a multiplication. If there is for example 1000€ in an account > and 0.7 must be applied, then there must be 700€ instead

Re: [GNC] Payroll Management with Time Attendance Machine

2019-03-05 Thread Adrien Monteleone
Jason, I’m not sure what ’Time Management Attendance Machine’ is, but in general, no, you’d need to keep your time sheets separately. (There are plenty of stand-alone software options for this, as well as spreadsheet templates, or you could roll your own spreadsheet) GnuCash does not have a

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Derek Atkins
I would recommend you run the existing P report, then take the output, copy it into a spreadsheet, and then add your coefficients there. -derek On Tue, March 5, 2019 10:21 am, Peter Münster wrote: > On Tue, Mar 05 2019, John Ralls wrote: > >> Apply the coefficients how and with what intended

[GNC] Payroll Management with Time Attendance Machine

2019-03-05 Thread jason
Hi, I was wondering, does GNUCash support Payroll Management with Time Attendance Machine (e.g An employee has a meal allowance "transferred by the end of the month", however if he/she do not come to work, he/she will not receive the meal allowance by the end of the month) I was also wondering,

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > Apply the coefficients how and with what intended result? It's just a multiplication. If there is for example 1000€ in an account and 0.7 must be applied, then there must be 700€ instead of 1000€ in the report. Our kayak club has a contract with a public

Re: [GNC] apply coefficient to an account

2019-03-05 Thread John Ralls
> On Mar 5, 2019, at 5:28 AM, Peter Münster wrote: > > Hi, > > For a special report of type "Profit & Loss" I need to apply some > coefficients to some accounts. For example 0.7 to the account > "transport". Is this possible with Gnucash, and if yes: how please? > > Thanks in advance for any

Re: [GNC] Error parsing server response

2019-03-05 Thread John Ralls
> On Mar 4, 2019, at 10:16 PM, Billy Chaney wrote: > > I keep getting an Error parsing server response. Any help with this would be > Greatly appreciated. > > > AqBanking v5.7.8.0stable > Sending jobs to the bank(s) > Locking user billchaney64 > Sending request... > Connecting to server...

[GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
Hi, For a special report of type "Profit & Loss" I need to apply some coefficients to some accounts. For example 0.7 to the account "transport". Is this possible with Gnucash, and if yes: how please? Thanks in advance for any hints. Kind regards, -- Peter

Re: [GNC] Adjusting column width

2019-03-05 Thread Colin Law
On Tue, 5 Mar 2019 at 10:35, Terence Wong wrote: > > I am using 3.4-1. For some accounts that have a long numeric figures in the > column, I tried to adjust the width to show the full figures but to no > avail. This also applies to 2.6.21-2. If you double click the column heading it should

[GNC] Adjusting column width

2019-03-05 Thread Terence Wong
I am using 3.4-1. For some accounts that have a long numeric figures in the column, I tried to adjust the width to show the full figures but to no avail. This also applies to 2.6.21-2. Is this a bug or there is a way to get around it? Regards, -- Terence Wong