On Fri, Feb 23, 2018 at 10:08 AM Jeff Abrahamson <j...@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 <j...@p27.eu> > > 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 > > &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@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@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.