importing splits

[Buddha Buck]

On Fri, Feb 23, 2018 at 10:08 AM Jeff Abrahamson <jeff at p27.eu> 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 1        Alice    membership     rx 50.00
>     cheque 2        Bob      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 +0000, 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 <jeff at p27.eu>
> > Date: 21/2/18 05:00 (GMT+10:00)
> > To: gnucash-user at 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
> > &data=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> >
> &sdata=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D&reserved=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&data=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> > &sdata=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D&reserved=0
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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&data=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> > &sdata=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D&reserved=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&data=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> > &sdata=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D&reserved=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 at 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.
>