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
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
> +44 7920 594 255
>
> 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.
