Re: [GNC] Chase ofx support?

2023-08-16 Thread GWB
I make an effort when I have to call Chase, Schwab, etc., for other topics (mystery charges, etc.) to also request that they make an .ofx download available. Schwab is a hard no on that, and they got rid of direct connect years ago. Chase last week indicated that .ofx was gone since 2021, but

Re: [GNC] Discretionary taxes

2021-05-10 Thread GWB
There was indeed a US federal level medical device excise tax, but it was placed in moratorium in 2015 and repealed in 2019: https://www.irs.gov/newsroom/medical-device-excise-tax This must be a county tax. Well, I'm stumped. It probably should be tracked and calculated, but I'm not sure how.

Re: [GNC] Discretionary taxes

2021-05-10 Thread GWB
Interesting. What is the taxing jurisdiction? Is it a tax on sales or a tax on total revenue? In some jurisdictions the discretionary tax is on total revenues, somewhat like a surcharge on existing VAT. In Florida and some other US states discretionary tax is an additional sales tax levied by

Re: [GNC] What does OFX Direct Connect do?

2020-05-18 Thread GWB
OFX as a format does several things CSV does not. It can give a unique transaction ID, which the software can then "remember" if there are a number of repeated transactions of the same amount and similar dates. With OFX, you know they are unique transactions because of the unique identifier.

Re: [GNC] XML vs SQL data integrity question

2020-05-11 Thread GWB
. Gordon On Sat, May 9, 2020 at 1:15 AM Jeff wrote: > > On 5/8/2020 2:03 AM, GWB wrote: > > Have you tried sqlite? I don't know how it works on Windows but it might just > save it as a file without setting up a salute back end. Maybe try that when > you have time. > > Gordon

Re: [GNC] XML vs SQL data integrity question

2020-05-08 Thread GWB
Have you tried sqlite? I don't know how it works on Windows but it might just save it as a file without setting up a salute back end. Maybe try that when you have time. Gordon On Fri, May 8, 2020, 1:27 AM Jeff wrote: > On 5/7/2020 8:28 PM, GWB wrote: > > The idea about the images

Re: [GNC] XML vs SQL data integrity question

2020-05-07 Thread GWB
The idea about the images is a very good one. Invoices, receipts, etc., would do fine in digital format. No question that databases are capable of much greater depth, granularity and ability to search and change. However, in defense of the humble xml text file, I give you this: cat

Re: [GNC] XML vs SQL data integrity question

2020-05-07 Thread GWB
Have used sqlite3, postgresql, and xml on various machines (Windows 7, Ubuntu, FreeBSD). Windows 7 (with extended service for malware) does fine with xml, but I have not had a problem with the sql backends. sqlite was easier to set up as a backend than postgres, but postgres (from other uses as a

Re: [GNC] Working with dates in Postgresql DB

2020-05-02 Thread GWB
Hmm, not able to get to the .sql files yet, but the xml has things like: 2019-02-14 00:00:00 -0600 ... 2014-08-05 ... 2019-04-11 21:30:12 -0500 Still digging. It would be hard to get rid of timestamps altogether, I think, and

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread GWB
actions change. > > The right solution is to change the date representation to not use time so it > doesn't care about time zone, but that's a major change and so far nobody's > had the appetite to take it on. > > Regards, > John Ralls > > > > On Apr 30, 2020, at 1:06

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread GWB
Curious about this. So is the goal to show all times in UTC on invoices along with local time? I tend to default most things to UTC (including local time on computers) and just display in some local time if necessary. If GMT is available as a time zone, I use that (GMT is a timezone; UTC is

Re: [GNC] since Catalina, unable to open gnucash

2020-01-26 Thread GWB
, 2020 at 5:53 PM GWB wrote: > > Apple OS X combined two types of kernels, bsd and mach, but is > (according to some FreeBSD kernel developers) progressively removing > the mach kernel components. This may be due to their possible shift > to ARM processors for computers (same famil

Re: [GNC] since Catalina, unable to open gnucash

2020-01-26 Thread GWB
Apple OS X combined two types of kernels, bsd and mach, but is (according to some FreeBSD kernel developers) progressively removing the mach kernel components. This may be due to their possible shift to ARM processors for computers (same family of processors as their other devices). But Apple

Re: [GNC] Gnucash on MacOs Catalina

2019-10-11 Thread GWB
Chronosync is another app that needed some work to integrate smoothly with Catalina. This excerpt from their email to users explains: << The Catalina Split Catalina introduces a new APFS feature called ‘Volume Groups’. Under Catalina, Apple takes advantage of this ability and splits the boot

Re: [GNC] Gnucash on MacOs Catalina

2019-10-09 Thread GWB
I'm not a dev, but I do know that Catalina (OS X 10.15) is having compatibility problems with a number of apps that worked on OS X 10.14. Webroot just discovered their app won't work on Catalina. Assuming all the 32 bit libraries are now 64 bit in Gnucash 3.7 this may be a false alarm from the

Re: [GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-17 Thread GWB
user base. Gordon On Tue, Sep 17, 2019 at 5:01 PM GWB wrote: > > OK; Outstanding, this works like a charm. On Windows 7 Pro (64 bit) > the GnuCash installation created: > > C:\Users\$USER\.gnucash > > There is also: > > C:\Users\$USER\.AppData\Local... \LocalLow ...\R

Re: [GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-17 Thread GWB
OK; Outstanding, this works like a charm. On Windows 7 Pro (64 bit) the GnuCash installation created: C:\Users\$USER\.gnucash There is also: C:\Users\$USER\.AppData\Local... \LocalLow ...\Roaming When I copy the files from the linux installation at: $user/.gnucash to C:\Users\$USER\.gnucash,

Re: [GNC] Are insurance proceeds income?

2019-09-16 Thread GWB
Again, no tax advice here, but I tend to look for a reporting form that goes to some kind of governmental unit, and then I check the tax software (I use CCH) for some checkbox or other items for "loss payouts", "insurance loss payments", etc. It might be something for form 4868. But that's not

Re: [GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-15 Thread GWB
nd out how to migrate from linux to Windows 7, I'll send another email to the list. Thanks, Gordon On Sat, Sep 14, 2019 at 6:46 PM GWB wrote: > > Great, thank you, that helps. This is probably also a problem with > gnucash 2.6.12 on ubuntu 16. When I now launch gnucash --nofile &

Re: [GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-14 Thread GWB
in the > shortcut. > > Regards, > John Ralls > > > > On Sep 13, 2019, at 8:11 PM, GWB wrote: > > > > OK, will do. This is interesting. I moved the file to a Windows 7 > > machine, and opened it with GnuCash 2.6.21. It did read the sqlite3 > > fil

Re: [GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-13 Thread GWB
an correct errors in an account file? I should give that a whirl and see what it finds. Thanks again, you guys rock, Gordon On Fri, Sep 13, 2019 at 9:59 PM John Ralls wrote: > > > > > On Sep 13, 2019, at 11:53 AM, GWB wrote: > > > > Hello, GnuCash Users, > >

[GNC] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"

2019-09-13 Thread GWB
Hello, GnuCash Users, Gnucash will begin to start, then abort (crash) when launched, using normal startup or gnucash --nofile --debug. Output from terminal is: $ gnucash --nofile --debug Found Finance::Quote version 1.38 **

Re: [GNC] UK VAT and "Making Tax Digital"

2019-05-01 Thread GWB
How would HRMC know if you cut and pasted the data or not? I haven't looked at this in some time, but if a CSV file works for the report, how would they know that a submission isn't just a .csv or .xml file that was copied and pasted manually from another program? I vaguely remembered the

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-06 Thread GWB
Haven't tested this with the SQLite GnuCash backend, but it is sometimes possible with PostgreSQL to "roll back" to an earlier state before the last transactions, or for that matter, any arbitrary number of transactions before the last one. I haven't used the PostgreSQL backend with GnuCash for

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-05 Thread GWB
David, Michael, Yes to both of you, but see the other thread on this. Mac's give you modified, created and last opened in the finder window. That can help troubleshooting. That's also why older unix systems used some version of .lck .lnk files and core dumps; all three can be diagnostic. And

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread GWB
lnk files are created by gnucash to prevent > users accidentally opening the data file on multiple machines. They are zero > bytes in size and there is no point in trying to open them up. There is no > there there. > > On Mon, Nov 5, 2018 at 7:08, GWB > wrote: > H

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread GWB
Hello, Anita, GnuCash User list, The attachment smime.p7s might be a file format (.p7s) that is unique to microsoft outlook, so I'm not having any luck opening it. I use Macs, but not for gnucash, so perhaps you might try: 1. Using the spotlight feature in Mac to search for all files ending in

Re: [GNC] Chromebooks

2018-10-06 Thread GWB
Wow; that's excellent. The Crouton page also mentions Crostini: https://chromium.googlesource.com/chromiumos/docs/+/master/containers_and_vms.md Which does not require running with dev enabled. Pixelbooks work with Crostini. Here's the hardware list by motherboard:

Re: [GNC] Chromebooks

2018-10-06 Thread GWB
You might be able to gun gnucash on a chromebook using Google Play Store. Here's a list of ChromeOS Hardware Google says will work with Google Play: https://sites.google.com/a/chromium.org/dev/chromium-os/chrome-os-systems-supporting-android-apps I know it can work because I'm looking at

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

2018-08-22 Thread GWB
t; fine. (problems arise if you have dependency conflicts with other software) > > Regards, > Adrien > >> On Aug 21, 2018, at 4:55 PM, GWB wrote: >> >> I'm not sure how the version history works in Ubuntu or Debian, but I >> installed GnuCash 2.6.7 from getdeb.org qui

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

2018-08-21 Thread GWB
Yes, thank you, I may try building from source. Has there ever been a standalone .deb package for GnuCash? I don't know what the flatpack is, but it occurs to me that for linux, debian, etc., a 3.x .deb might be worthwhile. But I don't think I have seen a .deb package on the download links at

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

2018-08-21 Thread GWB
other nasty things to occur when you're using gnucash. They won't be caused by gnucash, but they will affect what you're trying to do. If you can navigate that and work around the instability, give it a try. I'm OK with 2.6.whatever until Ubuntu 18 gets 3. Gordon On Tue, Aug 21, 2018 at 4:55 PM

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

2018-08-21 Thread GWB
I'm not sure how the version history works in Ubuntu or Debian, but I installed GnuCash 2.6.7 from getdeb.org quite a while ago, and "pinned" it (so that apt-get upgrade would not go to the version up) to that version hoping that gnucash in Ubuntu 14 would catch up with 2.6.7. Ubuntu 14 ("Trusty

Re: [GNC] pros/cons of storage formats

2018-05-17 Thread GWB
I have used xml, postgresql, and sqlite (which must default to sqlite3 on Ubuntu) with gnucash. sqlite3, as mentioned already, is a good compromise between a database backend and simplicity of set up. PostgreSQL is, probably, technically the best of the database backend options for being robust,

Re: MacOS 32-bit support

2018-02-04 Thread GWB
PPC machines and > GnuCash passes Debian's tests on their PPC buildbot, so that's the way to go > if you're still running an old PPC mac. > > Regards, > John Ralls > > >> On Jan 26, 2018, at 12:41 PM, GWB <g...@2realms.com> wrote: >> >> I have not yet tried th

Re: Please remove me from the mailing list

2018-01-31 Thread GWB
It also appears an "unsubscribe" button would not work with mailman (or most mail lists), because most of them send in text only, and few allow html or scripts (for good reason). So forget about the MailChimp type of button. It would also have no effect on nabble, etc. Gordon On Tue, Jan 30,

Re: Please remove me from the mailing list

2018-01-30 Thread GWB
My favourite was a mailing list some years back which, when receiving "list-unsubscribe" in the body of the email, would literally subscribe the email address to a "list-unsubscribe" mailing list, which would send the messages of those attempting to unsubscribe to each other. But not to the list

Re: MacOS 32-bit support

2018-01-26 Thread GWB
I have not yet tried this yet with GnuCash on the G4 and G5 PPC Macs we still have, but it is possible to install FreeBSD 64 bit on the G5 Macs, which does have some virtualisation (weird, but impressive). That would be a "corner case" scenario for what I'm guessing are a very few GnuCash users.

Re: Receipt scanners, recommendations?

2017-12-21 Thread GWB
I can say that VueScan softer does work with the older Fujitsu ScanSnap (s500, I think) on Ubuntu 14. But VueScan is not free, and I have not tried Fujitsu's linux version for the ScanSnap. I don't use OCR when I scan, but instead batch scan, and then later run the files (usually .tiff) through

Re: Linux Subsystem for Windows: GnuCash seems to work

2017-12-03 Thread GWB
Thank you, that sounds worth trying. To be clear, at the step: "Turn Windows Features on or off" Turn Windows Features on, correct? Or is there a specific way to activate Windows Subsystem for Linux within Windows Features? I'm not at Windows 10 yet, but we do keep some Windows machines

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-02 Thread GWB
it's worth it, and necessary. Check around. Anywhere from Cambridge to Dedham should be any number of telecomm trunk leasing outfits. Gordon On Mon, Oct 2, 2017 at 6:57 PM, Derek Atkins <de...@ihtfp.com> wrote: > [removed -announce] > > On Mon, October 2, 2017 6:09 pm, GWB wrote: >

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-02 Thread GWB
Derek, Sorry to hear that, and its frustrating. Perhaps AT could, in the meantime, install a different modem temporarily to see if that solves the problem? I've been through this with various T line providers, and their default response is often "Something you did", even when the internal set

Re: For UK users: Will gnucash get ready for Making Tax, Digital ?

2017-07-31 Thread GWB
This reminds me of an earlier question from a user in Sweden. Apparently governments (Sweden in that case, the UK in this one) are getting into the habit of specifying not only acceptable tax software but also accounting software. The UK has not yet required businesses of a certain size to use

Re: Accounting for contractors using GnuCash?

2017-07-28 Thread GWB
to give you the number of miles. So maybe Christopher's way is better. Gordon On Fri, Jul 28, 2017 at 10:29 PM, GWB <g...@2realms.com> wrote: > Here's what I do, but it might not work for you. > > I use two pieces of software for accounting, bookkeeping, and > compliance: gnucash an

Re: Accounting for contractors using GnuCash?

2017-07-28 Thread GWB
Here's what I do, but it might not work for you. I use two pieces of software for accounting, bookkeeping, and compliance: gnucash and prosystemfx from CCH (Wolters Kluwer). gnucash is excellent for tracking expenses, but for income amounts I rely on 1099's, DIV's, etc. Similarly, I sometimes