[GNC] Make PDF from reports

[Derek Zehr]

Hello,

 

I just created my first-ever report in GnuCash, to report some finances with
a forum I'm involved with. This is the window I get when I hit Make PDF, and
specify a valid file name in my documents folder. GnuCash Version: 4.1 Build
ID: 4.1+(2020-07-25) on Windows 7.

 

Hope it something simple. Not sure what to do to resolve something like
this.

 

Thanks,

 

Derek Zehr

 



 

 

___
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: [GNC] CSV import of Credit Card Transaction Data

[David Cousens]

Paul,

The headings should include a columns for  Deposit  and Withdrawal. If you
have a single column of signed data one of these should work. You may have
to experiment to get the right header for your bank's data. From memory I
used the Deposit header on a bank account CSV import. 

The importer has different headers to cope with banks proclivity not to
stick with any particular standard way of presenting CSV data. Some have
separate columns for deposits and Withdrawals, some use a single unsigned
column with another column which has Debit/Credit entries. GnuCash has to be
able to cope with all of these variations.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: [GNC] Start up with security prices updated during launch

[D. via gnucash-user]

Further to your last statement, the syntax should I believe be: 

gnucash-cli.exe --add-price-quotes=

But I haven't used this feature in a long time, myself. 


 Original Message 
From: "D. via gnucash-user" 
Sent: Mon Oct 19 16:44:05 EDT 2020
To: Kalpesh Patel 
Cc: Fran_3 via gnucash-user 
Subject: Re: [GNC] Start up with security prices updated during launch

Not really. See 
https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html for a 
recent discussion, and https://bugs.gnucash.org/show_bug.cgi?id=628734 for an 
older one.

You can get behavior like this by writing a simple batch file that updates 
process before opening your data file in the GUI. 

David T 


 Original Message 
From: Kalpesh Patel 
Sent: Mon Oct 19 14:10:56 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Start up with security prices updated during launch

Hi GNUCash User group -

 

Is there a way to launch GNUCash in Windows 10 such that it also updated
security prices from online sources for securities that are configured
before displaying the scheduled transactions? I am using version 4.2 on
Windows at the moment.

 

I don't believe it's:

 

gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash

 

 

Thanks.

 

 

 

___
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.

___
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.

[GNC] CSV import of Credit Card Transaction Data

[Paul Konnersman]

MacOS Version Catalina 10.15.7 (19H2) and   GnuCash Version: 4.2 Build ID:
4.2+(2020-09-26)


I’m attempting to import a CSV Credit Card transaction file. In the import
Preview window I have the following fields mapped to the import data:
“Date,” Num,” “Description,” “Memo,” but there seems to be *no appropriate
mapping for the fields that I might call “Debit/Credit,” and “Amount.”*


I don’t see a need for Debit/Credit since that can be handled with the
minus sign on amount. But certainly, I need “Amount.” But I can’t find any
reference to it in the docs. What have I missed?


Paul

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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: [GNC] Start up with security prices updated during launch

[D. via gnucash-user]

Not really. See 
https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html for a 
recent discussion, and https://bugs.gnucash.org/show_bug.cgi?id=628734 for an 
older one.

You can get behavior like this by writing a simple batch file that updates 
process before opening your data file in the GUI. 

David T 


 Original Message 
From: Kalpesh Patel 
Sent: Mon Oct 19 14:10:56 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Start up with security prices updated during launch

Hi GNUCash User group -

 

Is there a way to launch GNUCash in Windows 10 such that it also updated
security prices from online sources for securities that are configured
before displaying the scheduled transactions? I am using version 4.2 on
Windows at the moment.

 

I don't believe it's:

 

gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash

 

 

Thanks.

 

 

 

___
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.

[GNC] Start up with security prices updated during launch

[Kalpesh Patel]

Hi GNUCash User group -

 

Is there a way to launch GNUCash in Windows 10 such that it also updated
security prices from online sources for securities that are configured
before displaying the scheduled transactions? I am using version 4.2 on
Windows at the moment.

 

I don't believe it's:

 

gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash

 

 

Thanks.

 

 

 

___
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: [GNC] Windows is AQBanking OFXDirect fixed? - Re: GnuCash Nieghtlies: aqbanking-6.2.5, gwenhywfar-5.4.1, libofx-0.9.15; gnome.Platform-3.36

[Chris Graves]

Jeff,

I tested last nights Windows nightly with the following results.

Setup wizard was able to successfully create the user account and download the 
account list, but it didn’t  populate them in the list of accounts.

Creating an account manually resulted in the following error, but it did create 
the account.
Error - unable to update account spec

Downloading transactions worked just fine.

Chris

> On Oct 18, 2020, at 6:44 PM, Jeff Albrecht  wrote:
> 
> Hello list,
> 
> I'm wondering if anyone and/or any developer has tested the maint .exe to see 
> if the AQBanking OFX direct deposit account setup wizard works correctly now, 
> and if OFX Direct downloads are working.
> https://code.gnucash.org/builds/win32/maint/?C=M;O=D
> 
> Are maint builds safe for production? Or should we wait for 4.3 on 
> 2020-12-27? https://wiki.gnucash.org/wiki/Release_Schedule
> 
> 
> gnucash-4.2-2020-10-18-git-4.2-57-g190d5f1a6+.setup.exe 
> 
>  2020-10-18 04:04149M
> 
> 
>  - Jeff
> 
> 
> On 10/18/2020 5:24 PM, Frank H. Ellenberger wrote:
>> Hi,
>> 
>> since yesterday contain the nightlies gwenhywfar-5.4.1 and since
>> 10-09 libofx-0.9.15,
>> 10-07 aqbanking-6.2.5.
>> 
>> Since 10-08 the Flatpaks are based on gnome-3.36. That means
>> org.gnome.Platform* 3.34 can be deleted, if not required by other Flatpaks.
>> 
>> https://code.gnucash.org/builds/flatpak/maint/?C=M;O=D
>> https://code.gnucash.org/builds/win32/maint/?C=M;O=D
>> 
>> Regards
>> Frank
>> 
>> 
>> ___
>> 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.
> 
> -- 
> Jeff Albrecht KF7CRU @jhalbrecht /
> 
> When you are dead, you don't know you are dead. It's pain only for others.
> 
> It's the same thing when you are stupid.
> 
> /
> ___
> 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: [GNC] Best way to Auto Sync GC Checking Transactions with the Bank?

[Greg Feneis]

Regarding loose cannon with debit card, convert them to using a credit
card?  Essentially free credit so long as you pay it off every month. Then
you only have to deal with it once every month.

The GnuCash matcher isn't perfect, but it works well.

Kind regards, Greg Feneis
(Pixel 3)


On Sun, Oct 18, 2020, 12:35 Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> On 10/18/20 12:51 PM, Fran_3 via gnucash-user wrote:
> >   David, thanks for the comments.
> > I'm going to experiment more with the import matcher.
> > I have discovered this time saving tip... we can...
> >
> > - Log on to our bank, drag the mouse over the transactions, and copy
> into the paste buffer
> > - Then paste them directly into a Google Sheet...- Thus avoiding the
> downloading and importing a CSV file.
>
> Why *not* download the CSV? That saves many, many clicks and drags. You
> just open it in Google Sheets and the data is all there.
>
> > Ditto for GnuCash Checking if we bring it up in a Transaction Report
> > And, as I mentioned to Adrien, I have created an App Script to help me
> compare the Bank Transactions to the GnuCash TransactionsThe process...-
> Sort the Bank Transactions by Amount and then by date- Ditto for the
> GnuCash Transactions
> > - Put both Bank & GnuCash transactions on the same sheet- Drag the
> Amount Columns of each so they are side by side- Insert a column between
> the two Amount Columns- Create a spreadsheet formula to put an "X" in the
> column if the amounts don't match- Copy that formula all the way down to
> the last row- Now you can see where inconsistencies occurIt gets tricky now
> however so this is where I wrote an App Script to copy either the Bank
> Transactions or the GC Transactions starting with the inconsistency... and
> move them down a row... and then re-run the matching formula.
> > Normally, too much work... but in one case where I just rechecked the
> reconciliation of 3-years worth of transactions... it was helpful.
> > There are other, maybe easier ways to do this I'm sure.
>
> You *could* script a comparison with the transactions exported from GC.
> I think there is now also a command-line interface that might be able to
> grab the data. Look into something called PieCash. (not sure of
> spelling) It was created as a Python interface to the GnuCash data file.
> (for reading only, always 'edit' or 'create' transactions using GnuCash
> itself)
>
> Also look into OFX from your bank. You can set up GnuCash to connect to
> the bank and grab the transactions directly. (But I'd stand by my
> recommendation to improve purchasing procedures and if at all possible
> get receipts for everything so you can enter them and then the bank
> procedure will be for clearing only)
>
> Regards,
> Adrien
>
> ___
> 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: [GNC] Run gnucash-cli commands with Flaptak install?

[Colin]

Hi Frank,

This is brilliant! I had actually tried a similar syntax, but had put
'org.gnucash.GnuCash' in the wrong location.

Updating the wiki now ;)

Best,
Colin

On Sun, Oct 18, 2020 at 8:53 PM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi Colin,
>
> Am 18.10.20 um 16:22 schrieb Colin Arndt:
> :
> > I used to run:
> > gnucash-cli --quotes get /path/to/GnuCashfile
> >
> > From the docs I can see I need to enter the following to enter the
> GnuCash command line environment:
> > flatpak run --command=sh org.gnucash.GnuCash
> >
> > Can these be combined into a single command on the host system?
>
> I just tried:
> flatpak run --command=gnucash-cli  org.gnucash.GnuCash --version
> GnuCash 4.2 development version
> Build ID: git 190d5f1+(2020-10-15)
>
> Watch the order of the options!
>
> > Feel free to let me know if this is more of a Flatpak question than a
> GnuCash one, though I figured others may have experience with this.
>
> see:
> flatpak --help
> flatpak --help run
>
> That command should give you more infos than you need.
>
> > If nothing else, getting the solution in the list here gets it into the
> archives if others want to replicate it.
>
> But it would be better, if you would add it to the wiki page. ;-)
>
> > Thanks,
> > Colin
>
> Regards
> Frank
>
___
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.