subject:"Re\: importing splits"

Re: importing splits

2018-02-26 Thread elvis




On 27/02/18 01:59, David Carlson wrote:
I believe the OP does not want to use a csv to qif converter. Perhaps 
whichever one he tried was difficult to use.


Or maybe he wishes that his bank would do the split for him
David C





I got a python script written to put the Australia gst split into 
downloaded bank (qif) files. Otherwise there doesn't seem to be any way 
of accounting for it short of putting every purchase through the 
invoicing system. And that just isn't reasonable or practical for a 
large volume of transactions.


I've never used a commercial product, I've always wondered how they 
handle it.


Lawrence


On Feb 26, 2018 5:39 AM, "elvis" > wrote:




On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is
that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

     deposit cheque           bank dx 100.00
     cheque 1        Alice    membership     rx 50.00
     cheque 2        Bob      membership     rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking
to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0
(which we are
preparing for release, hopefully next month).

I've been importing multi split transactions for years using the
qif importer. Am I missing something here?

Cheers
Lawrence
___
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: importing splits

2018-02-26 Thread David Carlson

I believe the OP does not want to use a csv to qif converter. Perhaps
whichever one he tried was difficult to use.

Or maybe he wishes that his bank would do the split for him.

David C



On Feb 26, 2018 5:39 AM, "elvis"  wrote:

>
>
> On 24/02/18 03:39, Geert Janssens wrote:
>
>> Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:
>>
>>> Thanks.  I see my question wasn't clear.  My problem is that I want to
>>> import the splits and it seems I can only import transactions.
>>>
>>> I.e. (super simplified):
>>>
>>>  deposit cheque   bank  dx 100.00
>>>  cheque 1Alicemembership rx 50.00
>>>  cheque 2Bob  membership rx 50.00
>>>
>>> Jeff
>>>
>> Assuming this is one transaction, you are essentially asking to import
>> multi-
>> split transactions.
>>
>> This is not possible in gnucash 2.6, but it will be in 3.0 (which we are
>> preparing for release, hopefully next month).
>>
> I've been importing multi split transactions for years using the qif
> importer. Am I missing something here?
>
> Cheers
> Lawrence
> ___
> 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: importing splits

2018-02-26 Thread elvis




On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

 deposit cheque   bank  dx 100.00
 cheque 1Alicemembership rx 50.00
 cheque 2Bob  membership rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0 (which we are
preparing for release, hopefully next month).
I've been importing multi split transactions for years using the qif 
importer. Am I missing something here?


Cheers
Lawrence
___
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: importing splits

2018-02-23 Thread Buddha Buck

On Fri, Feb 23, 2018 at 10:08 AM Jeff Abrahamson  wrote:

> Thanks.  I see my question wasn't clear.  My problem is that I want to
> import the splits and it seems I can only import transactions.
>

Splits do not exist independently of transactions. Transactions have a
collection of splits. The collection of splits within a transaction must
balance. You cannot import splits alone, as they would then lack a
transaction context.

 What do you mean by only being able to import transactions when you want
to import splits?


>
> I.e. (super simplified):
>
> deposit cheque   bank  dx 100.00
> cheque 1Alicemembership rx 50.00
> cheque 2Bob  membership rx 50.00
>

This is overly simplified. I can't tell, for instance, the date of the
cheque deposit, if this is referring to 1 check or 3, what is debited or
credited, etc. It *looks* like it might be a single transaction in which
one check was used to pay for both Alice and Bob's memberships, but it's
lacking basic information about the transaction like the date.

And it should be "E.g. (super simplified)" not "I.e. (super simplified)".
The abbreviation "i.e." is short for "id est",Latin for "that is". It's
used to give an alternative definition or description of something (like
"in other words"). In contrast, "e.g." means "exempli gratia", Latin for
"for example", used to provide an example.



>
> Jeff
>
>
> On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote:
> > The easiest way would be saving  the spreadsheet to .csv format and
> importing
> > that to Gnucash.
> >
> > Id recommend:
> > - first removing any other text and stuff you have so that the
> spreadsheet is
> > just the headings you want and the data you want in columns
> > - doing the import on a new test gnucash file first if you have a lot of
> data
> > already in your gnucash book. Just in case.
> >
> > Good luck!
> >
> > Thanks and regards,
> > Matt
> >
> >
> >  Original message 
> > From: Jeff Abrahamson 
> > Date: 21/2/18 05:00 (GMT+10:00)
> > To: gnucash-user@gnucash.org
> > Subject: importing splits
> >
> > I'm processing check deposits.  I have a spreadsheet with lovely columns
> > like name, check number, amount, and the account to debit.  It seems a
> > shame to retype it all.
> >
> > I see some old discussion on the list that, essentially, says this is
> > not well supported if supported at all.
> >
> > https://nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Flists.gnucash.org
> %2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html
> > =
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> >
> =uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0
> >
> > Is there anything since that might help?  I'm not sure converting
> > spreadsheets to QIF to then import into gnucash is better than retyping.
> >
> > --
> >
> > Jeff Abrahamson
> > +33 6 24 40 01 57 <+33%206%2024%2040%2001%2057>
> > +44 7920 594 255 <+44%207920%20594255>
> >
> > https://nam04.safelinks.protection.outlook.com/?url=
> > http%3A%2F%2Fp27.eu%2Fjeff%2F=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Flists.gnucash.org
> %2Fmailman%2Flistinfo%2Fgnucash-user=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
> > If you are using Nabble or Gmane, please see https://
> > nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: importing splits

2018-02-23 Thread Jeff Abrahamson

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

deposit cheque   bank  dx 100.00
cheque 1Alicemembership rx 50.00
cheque 2Bob  membership rx 50.00

Jeff


On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote:
> The easiest way would be saving  the spreadsheet to .csv format and importing
> that to Gnucash.
> 
> Id recommend:
> - first removing any other text and stuff you have so that the spreadsheet is
> just the headings you want and the data you want in columns
> - doing the import on a new test gnucash file first if you have a lot of data
> already in your gnucash book. Just in case.
> 
> Good luck!
> 
> Thanks and regards,
> Matt
> 
> 
>  Original message 
> From: Jeff Abrahamson 
> Date: 21/2/18 05:00 (GMT+10:00)
> To: gnucash-user@gnucash.org
> Subject: importing splits
> 
> I'm processing check deposits.  I have a spreadsheet with lovely columns
> like name, check number, amount, and the account to debit.  It seems a
> shame to retype it all.
> 
> I see some old discussion on the list that, essentially, says this is
> not well supported if supported at all.
> 
> https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html
> =
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0
> 
> Is there anything since that might help?  I'm not sure converting
> spreadsheets to QIF to then import into gnucash is better than retyping.
> 
> --
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> https://nam04.safelinks.protection.outlook.com/?url=
> http%3A%2F%2Fp27.eu%2Fjeff%2F=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
> If you are using Nabble or Gmane, please see https://
> nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0 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: importing splits

2018-02-20 Thread Matt Graham

The easiest way would be saving  the spreadsheet to .csv format and importing 
that to Gnucash.

Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is 
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file first if you have a lot of data 
already in your gnucash book. Just in case.

Good luck!

Thanks and regards,
Matt


 Original message 
From: Jeff Abrahamson 
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: importing splits

I'm processing check deposits.  I have a spreadsheet with lovely columns
like name, check number, amount, and the account to debit.  It seems a
shame to retype it all.

I see some old discussion on the list that, essentially, says this is
not well supported if supported at all.


https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0

Is there anything since that might help?  I'm not sure converting
spreadsheets to QIF to then import into gnucash is better than retyping.

--

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fp27.eu%2Fjeff%2F=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0
 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: importing splits

Re: importing splits

Re: importing splits

Re: importing splits

Re: importing splits

Re: importing splits

6 matches

Site Navigation

Mail list logo

Footer information