Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Wed, Mar 06 2019, elvis wrote: > I have a program in python to add a split like that to a qif file. > [...] > if you are interested let me know. Thanks. But for my usage, it won't work: the split must be done later after importing the bank-files. -- Peter _

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Oh, are you using a Sqlite data store?  If so, you might be able to > write a query to pull those accounts and apply the percentages.  You > could load the account names and percentages into a new table and drive > the query from there. Thanks, good

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Liz
On Wed, 6 Mar 2019 17:23:23 +1000 elvis wrote: > 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 imp

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 to

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 chec

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* trans

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 to

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 30%

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: http://pmrb.fre

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > You 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 30% into one account and 70%

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&L 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: - http://pmrb.free.fr/tmp/gnucash-e

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: h

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 o

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Derek Atkins
I would recommend you run the existing P&L 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 re

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 o

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