Re: [GNC] Exporting reports to spreadsheet - Solved

Very useful hint. Thanks a lot! Am 18.04.23 um 09:00 schrieb flywire: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html That's a great question George which has been annoying me for ages so I flicked it over to the LibreOffice Ask site:

[GNC] Exporting reports to spreadsheet - Solved

https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html That's a great question George which has been annoying me for ages so I flicked it over to the LibreOffice Ask site: https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615 It would make a good tip for our docs.

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

According to https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US IIF is a tab-separated-values format. You can import that with the CSV importer by setting the separator to Tab. Regards, John Ralls >

Re: [GNC] Exporting reports to spreadsheet

ult application and it opens in LibreOffice Writer. > > Opening the exported report in a text editor I see that it's really an > HTML file. And that, in fact, I can specify any windows extension I want > when exporting the report from Gnucash, and it will always write out a > fi

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

for money. IMHO. On 3/30/23 12:00, gnucash-user-requ...@gnucash.org wrote: Message: 4 Date: Thu, 30 Mar 2023 10:47:48 -0400 From: Richard Lindgren To: "gnucash-user@gnucash org" Subject: [GNC] Exporting from QuickBooks / Impor

[GNC] Exporting from QuickBooks / Importing to GnuCash

I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help

Re: [GNC] Exporting reports to spreadsheet

uble-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always

Re: [GNC] Exporting reports to spreadsheet

On Mar 29, 2023, at 3:03 PM, George Riner wrote: Yeah... isn't that curious? Gnucash writes out HTML regardless of any windows filename extension you supply. But if the filename I supply ends with the extension ".xlsx" then surprise! - it opens in LibreOffice Calc with an opening dialog

Re: [GNC] Exporting reports to spreadsheet

> On Mar 29, 2023, at 3:03 PM, George Riner wrote: > > Yeah... isn't that curious? Gnucash writes out HTML regardless of any > windows filename extension you supply. But if the filename I supply ends with > the extension ".xlsx" then surprise! - it opens in LibreOffice Calc with an >

Re: [GNC] Exporting reports to spreadsheet

On Wednesday, 29 March 2023 22:03:56 BST George Riner wrote: > I suspect LO is being way more "clever"! > > :George Yeah. File->Open in LO calc seems the most bullet proof route around any "cleverness" in LO... or the copy-and -paste as David T suggests. Maf.

Re: [GNC] Exporting reports to spreadsheet

e Calc application Saludos Cordiales Murugan From: gnucash-user on behalf of George Riner Sent: Wednesday, March 29, 2023 1:11 PM To: Gnucash Users Subject: [GNC] Exporting reports to spreadsheet The setting: Windows 10 Gnucash 4.13 When I Export a report

Re: [GNC] Exporting reports to spreadsheet

> On Mar 29, 2023, at 4:38 PM, Maf. King wrote: > > I _think_ that LibreOffice is more clever than just looking at the file > extension. ISTR that LO examines the file as it opens, and decides if a > text > editor (writer) would be more appropriate than Calc for the contents of the >

Re: [GNC] Exporting reports to spreadsheet

t; > From: gnucash-user > on behalf of > George Riner Sent: Wednesday, March 29, 2023 1:11 > PM > To: Gnucash Users > Subject: [GNC] Exporting reports to spreadsheet > > The setting: > > Windows 10 > Gnucash 4.13 > > Wh

Re: [GNC] Exporting reports to spreadsheet

s Subject: [GNC] Exporting reports to spreadsheet The setting: Windows 10 Gnucash 4.13 When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my ca

Re: [GNC] Exporting reports to spreadsheet

You could always forego the export aspect altogether. In the report window of GnuCash, select the entire report (Ctrl-A), copy the data (Ctrl-C), switch to LibreOffice (Alt-Tab), and paste your data (Ctrl-V). Finally, save the LibreOffice as a spreadsheet file, which should assign it the proper

Re: [GNC] Exporting reports to spreadsheet

When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default

Re: [GNC] Exporting reports to spreadsheet

George, This is a Windows 'feature,' as Windows has file extension associations. If you do a quick online search, you should be able to find the instructions on how reassign the association of the ".ods" extension to LibreOffice Calc. Alternatively, try right-clicking the icon and selecting

[GNC] Exporting reports to spreadsheet

uble-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always

Re: [GNC] Exporting Reports to CSV

Thanks David, my first try of copy and paste showed me it would be too much work. I found this site: www.myofficetricks.com › how-to-import-data-from How to Import Data from HTML into Excel - My Microsoft Office ...

Re: [GNC] Exporting Reports to CSV

Phyllis , You can copy and paste from the html opened in a browser into Excel or Libre Office. Certainly isn't perfect but most of the alignment is kept but if you are going that route, you are going to reformat it anyway. David Cousens On Mon, 2023-01-23 at 10:35 -0600, Phyllis Bruce wrote: >

Re: [GNC] Exporting Reports to CSV

For completeness, Once you have the report in the spreadsheet app of choice, you can then save/export from there as CSV if that format is otherwise still needed. Regards, Adrien On 1/23/23 11:32 AM, Phyllis Bruce wrote: Oops, never mind. Found good instructions on Chrome.

Re: [GNC] Exporting Reports to CSV

Oops, never mind. Found good instructions on Chrome. On Mon, Jan 23, 2023 at 11:26 AM Phyllis Bruce wrote: > Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with > importing delimited files into excel. > > On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: > >> >> >> On

Re: [GNC] Exporting Reports to CSV

Copy and paste into Excel is also an option. Dan On January 23, 2023 12:26:49 PM Phyllis Bruce wrote: Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with importing delimited files into excel. On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: On Monday, 23 January

Re: [GNC] Exporting Reports to CSV

Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with importing delimited files into excel. On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: > > > On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote: > > I found out how to export transactions, but how can I export my

Re: [GNC] Exporting Reports to CSV

On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote: > I found out how to export transactions, but how can I export my Tax report > as CSV? My only options are HTML or TXF, neither allow me to reformat in > Excel. > LibreOffice calc can work on the HTML export; I imagine that excel

[GNC] Exporting Reports to CSV

I found out how to export transactions, but how can I export my Tax report as CSV? My only options are HTML or TXF, neither allow me to reformat in Excel. Thanks, Pobruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] exporting from gnucash to Excel

Just a thought - can you mangle the VAT spreadsheet to sum the CSV exported box 1 and box 6 (nett) figures to give you a grossed-up number? Maf. On Thursday, 19 January 2023 17:20:31 GMT you wrote: > How could I organise my accounts such that I can pull my total sales > including VAT into

Re: [GNC] exporting from gnucash to Excel

How could I organise my accounts such that I can pull my total sales including VAT into the Box 6 total in the Income and GST Statement? At present my sales go to one account and the VAT charged goes to another. But VAT is paid from this latter account to HMRC so the balance of the account in a

Re: [GNC] exporting from gnucash to Excel

Thanks Maf. That seems like a neat solution. I'm almost there. Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total of sales including VAT but apart from my Accounts Receivable which goes to zero once the invoice is paid I don't see how to get that figure from anywhere. I

Re: [GNC] exporting from gnucash to Excel

On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote: > Thanks Maf. That seems like a neat solution. I'm almost there. > Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total of > sales including VAT but apart from my Accounts Receivable which goes to > zero once the invoice

Re: [GNC] exporting from gnucash to Excel

How can this be enforced except by obliging you to use only software they (inland revenue?) endorse? — Peter West p...@pbw.id.au “Which is easier, to say to the paralytic, ‘Your sins are forgiven,’ or to say, ‘Rise, take up your bed and walk’?” > On 14 Jan 2023, at 6:40 am, Maf. King wrote: >

Re: [GNC] exporting from gnucash to Excel

On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that "pressing a > button" to export to Excel provides exactly the same automated reliability > as CTRL-C/CTRL-V (two buttons, if you will) into

Re: [GNC] exporting from gnucash to Excel

On Thursday, 12 January 2023 14:05:04 GMT Paul W via gnucash-user wrote: > To submit VAT data to HMRC here in the UK I am obliged to use a method which > is automatic. So I need to find a way to trasnfer the balances from a > couple of accounts to an Excel spreadsheet automatically ie not by

Re: [GNC] exporting from gnucash to Excel

Scripts can also make redundant tasks less of a burden through hands-off automation. That's what scripts do well, too. I'm seeing a few posts in this topic verging on berating the OP for wanting to do something and asking if there's a way. Maybe you stop second-guessing the OP's needs and

Re: [GNC] exporting from gnucash to Excel

On Fri, 13 Jan 2023 07:45:20 +0300 "David T. via gnucash-user" wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that > "pressing a button" to export to Excel provides exactly the same > automated reliability as CTRL-C/CTRL-V (two buttons, if you will) > into

Re: [GNC] exporting from gnucash to Excel

Indeed. I don't have to comply with this either, but it seems to me that "pressing a button" to export to Excel provides exactly the same automated reliability as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both cases will have the same reliability. ⁣David T. ​ On Jan

Re: [GNC] exporting from gnucash to Excel

Do a list search on this topic. I'm pretty certain someone has a solution already worked out. I recall several threads over the last 2 years or so about this. Apologies, but I don't use this myself, so I can't comment further. Regards, Adrien On 1/12/23 8:05 AM, Paul W via gnucash-user

[GNC] exporting from gnucash to Excel

To submit VAT data to HMRC here in the UK I am obliged to use a method which is automatic. So I need to find a way to trasnfer the balances from a couple of accounts to an Excel spreadsheet automatically ie not by copying and pasting. I need to press a button and it is done without the

Re: [GNC] Printing/Exporting Invoices to PDF

Hello Waltr Choose Print and then print to a file of type pdf. Hope that helps Alan On 14/9/22 01:27, Waltr via gnucash-user wrote: Dear gnucash users: I have recently upgraded from 3.11 to 4.11. I have also recently been using the 3.11 Invoice "Export" button to export these

[GNC] Printing/Exporting Invoices to PDF

Dear gnucash users: I have recently upgraded from 3.11 to 4.11. I have also recently been using the 3.11 Invoice "Export" button to export these invoices to .pdf files. With the change to 4.11 the program now exports to .html files which cannot be used. How do I re-configure v4.11 to behave

Re: [GNC] exporting search?

Indeed it does. I just did a test before reading this reply. For example, I have a quite detailed CoA, and I enter copious details in my Memo fields. I was curious to see how much I've spent on Fuggle hops for my Homebrewing hobby. I simply selected the appropriate expense category (and

Re: [GNC] exporting search?

Sent: Mon Feb 21 04:04:56 EST 2022 To: Jeff Cc: Gnucash Users Subject: Re: [GNC] exporting search? What's wrong with the transaction report for this - gives you a total at the bottom and you can also export and print the results ? Cheers David H On Mon, 21 Feb 2022 at 17:53, Jeff wrote

Re: [GNC] exporting search?

What's wrong with the transaction report for this - gives you a total at the bottom and you can also export and print the results ? Cheers David H On Mon, 21 Feb 2022 at 17:53, Jeff wrote: > > I have had trouble with this as well. Each medical expense can have 2 > or more related

Re: [GNC] exporting search?

totals for any given period. *From:* Geoff *Sent:* Sat Feb 19 18:32:43 EST 2022 *To:* p...@kinzelman.com, Gnucash Elist *Subject:* Re: [GNC] exporting search? Hi Paul Your original request said you required a list of expenses

Re: [GNC] exporting search?

. *From:* Geoff *Sent:* Sat Feb 19 18:32:43 EST 2022 *To:* p...@kinzelman.com, Gnucash Elist *Subject:* Re: [GNC] exporting search? Hi Paul Your original request said you required a list of expenses. If you only want the totals amount

Re: [GNC] exporting search?

: [GNC] exporting search? Hi Paul Your original request said you required a list of expenses. If you only want the totals amount, there is no need to export at all. Just scroll to the bottom of the Account Report, which shows the the total Debits, Credits, and Balance. As to your other

Re: [GNC] exporting search?

Hi Paul Your original request said you required a list of expenses. If you only want the totals amount, there is no need to export at all. Just scroll to the bottom of the Account Report, which shows the the total Debits, Credits, and Balance. As to your other useful suggestions, please

Re: [GNC] exporting search?

Thank you! I see now how I can do that, but it's not all that convenient to do, seems like it would be something that lots of people would want to do. Copy/paste from HTML seems like not a good way to expect people to do it as well. All I want is a total of the columns of a search, seems like

Re: [GNC] exporting search?

Hi Paul From the Search Results tab, choose Reports / Account Report. This opens a new tab with a variant of the Transaction Report showing just the transactions in your Search Results. The Report Options let you tweak which columns are displayed. From there, you can either File / Export /

[GNC] exporting search?

Is there some way to export search results? I was trying to get a list of medical expenses for the past year and I didn't see any easy way to do this, is there a good way to do it? I tried search but I couldn't export it or total the columns. It seems like I should be able to export this list

Re: [GNC] Exporting Data

Yes, that worked. Thinking back, I believe I did that originally when I did it the first time in v3.8. Now I wonder why it took me so long to figure it out again, but this is the way to go, one single opening split transaction and that makes it work, and if you mess up the difference will show up

Re: [GNC] Exporting Data

I have never used the opening balances from the wizard.  I setup the COA and then enter one multi-split transaction to load all the balances as the first transaction in the file.  Looks like you would only have 8 splits (I have 30-50 in my initial transaction).  Since the transaction balances

Re: [GNC] Exporting Data

in the 3.8 version I had: My Opening balances transaction on 1/1/20 was Debit Credit Assets: Current Assets Checking:$A Assets: Current Assets Advance/Loan:$B Equity: Opening Balances: $C

Re: [GNC] Exporting Data

There is nothing special about opening balances. They are just regular transactions that the fresh start wizard makes for you. You should be able to edit those transactions just like any other. But I don't understand what the problem is. Even the Retained Earnings account would have an

Re: [GNC] Exporting Data

Hi, thanks sofar, I have tried literally everything along those lines, and nothing is doing it, and at this point it is all about ending with everything right, since I need to do 2021 urgently. My good luck is that this is about a business that was more or less dormant for a while, so, I can do

Re: [GNC] Exporting invoices and vendor bills to excel or Quickbooks

Yes. 1.) Find (from the CoA tab) For Invoices: Do a Find where the Account matches AR and Value has Debits ≥ 0.00 For Bills: Do a Find where the Account matches AP and Value has Credits ≥ 0.00 *For Credit Notes for each of AR/AP, change to Value has Debits/Credits ≤ 0.00

[GNC] Exporting invoices and vendor bills to excel or Quickbooks

is there a way to export the list of invoices generated to excel? as well as the vendor bills inputted into the system? Scenario: We are a branch, and our main parent uses Quickbooks. Due to our low volume of transactions, it will be easier to maintain our part of the accounts separate, and

Re: [GNC] Exporting Data

Rogier, Have to agree with Adrien and David Carlson that redoing everything from Dec2020 is the hard way to fix the problem. If you can identify the transaction(s) which were incorrect at that time and then fix then they will be unreconciled but will appear in the reconciliation window panes at

Re: [GNC] Exporting Data

First: File > Export > Export Account Tree in CSV is what you were looking for. Second: if you have a backup as of 12/31/20 then make it your current file and start 2021 over again. I've never had to do this, so not sure if the reconcile column flag is in the transaction CSV, but I suspect

Re: [GNC] Exporting Data

Usually GnuCash will allow any change to previous transactions, although some are more difficult if they reside in accounts marked hidden or placeholder, which may require extra steps or voided transactions also need to be unvoided. Almost the only thing that cannot be undone would ba a

[GNC] Exporting Data

If I want to redo a year, is the only way to redo it to export the data and set it up all over again? Or is there another way of rolling back all my reconciliations. Reason is, I seem to have a corruption in my last December (2020), and there appears to be no way to fix it, so it seems I have to

[GNC] Trouble exporting accounts from an android

Hi, I am struggling to export my account book from my android mobile app (Redmi Note 8T). I have managed to upload the file after some difficulty (in QIF) to G-drive and Dropbox but neither can open or read the export. Up until recently I didn’t have a laptop/desktop so haven’t got the

[GNC] Exporting from GnuCash Android App

- I can export to QIF format fine. - But when I try to export CSV, my GnuCash app crashes. - When I try to export XML, it either crashes or cannot attach the file to the mail. Yes, I e-mail my exports. - Android version 5.1.1. - Phone is Samsung Galaxy S5 new edition -

[GNC] some oddities when exporting transactions to CSV

Hello, I would like to export trasactions of several accounts because I think it would be easier to perform an analysis of transactions with Libreoffice/Excel instead of developing a custom/new report. For example, I am considering to export transactions of a mutual fund account to check the

Re: [GNC] Exporting and Importing CSV Transactions from One Book to Another

it let me > continue to import but wouldn't load or actually continue. I thought maybe > it was just a lot to load so I waited a long time but it didn't work and I > tried multiple times. > > Would you be able to give me a step by step how to for exporting and > importing

[GNC] Exporting and Importing CSV Transactions from One Book to Another

be it was just a lot to load so I waited a long time but it didn't work and I tried multiple times. Would you be able to give me a step by step how to for exporting and importing transactions from one book to another? Thank you in advance for your help, Melissa ___

Exporting customer and vendor data

I checked out the pycash python script for get_customers_from_xml.py as a way of exporting in csv format from the XML file. I believe I've figured out how to make this work. It involves going to <https://github.com/EvansMike/pycash> to download that script. Then, make a copy of your g

Re: exporting

File >> Export >> Export Transactions to CSV allows you to export an account's transactions to a csv file you can open with Excel or any text editor - is this what you are looking for ? Cheers Dave H. On 24 October 2017 at 09:13, David Carlson wrote: > Are you

Re: exporting

Are you having a problem using the Export function or is your problem with reading the output with a spreadsheet program? David C On Mon, Oct 23, 2017 at 3:58 PM, Jonathan Silvey wrote: > Hi, > > I'd like to export a single account to Excel but I can't find Export on

exporting

Hi, I'd like to export a single account to Excel but I can't find Export on the help pages. I have found Export under File but I can't follow the resulting output. Jonathan *Think before you print.* ___ gnucash-user mailing list

Re: Question on multiple layered searches and exporting

try using the new version of the transaction report I posted. It allows you to search based on two criteria. Doug Doughty On Tue, Aug 8, 2017 at 1:32 PM, Jeff wrote: > I have not used internet chat feeds in 30 years so bear with me as I > relearn how. I found

Re: Question on multiple layered searches and exporting

> > So my questions are: > > 1) Is there anyway I can make each search I do output it's results to a > new tab so I do not have to start all over after getting 5 layers deep in a > search if I screw up? > No... usually you would search transactions for quick lookups ("warranty claim... when did

Re: Question on multiple layered searches and exporting

On dinsdag 8 augustus 2017 19:32:01 CEST Jeff wrote: > I have not used internet chat feeds in 30 years so bear with me as I > relearn how. I found partial answers to my questions all over the web > but; nothing that worked for me using the exported reports in other > programs. > > Anyway

Question on multiple layered searches and exporting

I have not used internet chat feeds in 30 years so bear with me as I relearn how. I found partial answers to my questions all over the web but; nothing that worked for me using the exported reports in other programs. Anyway questions at hand. I am using GNUCash 2.16.7 for Windoze 10. I

Re: Exporting custom made reports

Try looking at: https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-migrate-settings.html > On Jul 27, 2017, at 11:11 PM, Martijn Heuts wrote: > > Hello, I just setup GNU cash to a

Exporting custom made reports

Hello, I just setup GNU cash to a different computer, I was able to get everything back on the new computerhowever I don't see my custom created reports.  Can anyone tell me how to export/import them? Thanks and have a great day! Martijn ___