Re: [GNC] Canadian Mortgage

[Edward Doolittle]

I do the calculations outside of gc then import (actually, type by hand, 
because I only do three years at a time).  Having approximate future 
transactions in the file may affect some reports, but reports should be 
regarded as correct only up to the reconciliation date of all the relevant 
accounts anyway. (Personally I estimate everything a year in advance and then 
correct it as time passes, which gives me an alternative to budgeting. But it’s 
a bit of work to set that up.)

No calculation I’ve ever done have completely accurately predicted loan 
payments. Big Canadian banks seem to not calculate interest owed after exactly 
two weeks, but may modify the time based on the presence of weekends (maybe not 
an issue either biweekly payments) and “bank holidays”, which may be impossible 
to predict. (A new Canadian federal holiday has just been added, for example.)

The best anyone can do is predict in advance keeping in mind the arrangement of 
holidays, then correct later, either by receiving a statement of account and 
reconciling, or by keeping tabs on the outstanding loan amount on your bank web 
site.  I would prefer reconciliation but I’ve found it has gotten more and more 
difficult to get a statement of account from my bank. I would switch banks over 
that one complaint, if anyone has any suggestions. :-)

Edward

From: gnucash-user 
 on behalf of Al 
Maloney 
Sent: Sunday, January 30, 2022 1:13:47 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Canadian Mortgage

How can I use gnuCash for a Canadian mortgage?

I need:
1) frequency of payments as bi-weekly (not semi-monthly)
2) a compounding period of 6 months

These are not available in version 4.9-1 Actions->Scheduled
Transactions->Mortgage & Loan Repayment

I am using macOS 10.14.6 or macOS 12.2

Al Maloney
Velox Versutus Vigilans
___
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] OneDrive and GnuCash

[Edward Doolittle]

I tried OneDrive with gc for a while. It worked until it didn’t. I’m still not 
sure what happened, but I think MS unilaterally decided to reorganize my 
OneDrive setup. Gc just did not like what it did and starting one day gc would 
not open the file.  I’m not sure what was wrong, and I couldn’t find out, 
because I don’t get the Windows file system at all (Unix guy here) and I just 
could not figure it out even with Google’s help. My hypothesis was that 
somewhere along the line something like a symlink was being used and gc didn’t 
like it.  But I still don’t have a clue, and I don’t need the aggravation, so I 
just moved my gc files out of OneDrive.

I’ve not (yet) had any problems with Office apps and OneDrive which led me to 
believe the problem is that gc accesses the Windows file system at too low a 
level, but I’m sorry, I just don’t have time these days to help debug this 
problem.

Aside from that, I was always sweating over race conditions.  Once a long time 
ago I lost some work because it wasn’t uploaded by OneDrive and then I force 
opened the file on another computer overriding the lock (bad habit cuz I had to 
do it fairly regularly).  The work was in the cloud somewhere but it was less 
trouble in that case for me to retype it.  So my fault, really, but I really 
really don’t need to expend a chunk of my brain mentally modelling the cloud 
sync and lock behaviour every time I use gc.

Other cloud file services might provide better warnings, and might allow you to 
wrap the call to gc in a test that will pop a warning until the file is 
up-to-date in the cloud.  Heck, OneDrive might provide such a wrapper too but I 
don’t know the system well enough.

One piece of advice for everyone: when transferring data from paper to gc, keep 
the paper with potentially unsynced data in a separate pile until you know it’s 
ok (for whatever sense of ok is relevant to you … cloud synced or hard drive 
synced or backed up to external hd, e.g.).  When you know it is synced or 
otherwise backed up, then file it.  In addition to losing data to the cloud 
issue described above, I’ve also lost data the old fashioned way (power failure 
on a desktop without battery backup), and both times I had more trouble than 
necessary re-running my transactions because I managed all those slips of paper 
poorly.

Edward

From: gnucash-user 
 on behalf of 
David Carlson 
Sent: Tuesday, January 18, 2022 12:52 PM
To: Gnucash Users
Subject: [GNC] OneDrive and GnuCash

Are there any GnuCash users that store their data files in One Drive?

Are there any issues slow response or keeping a few weeks of backup and log
files?
___
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] Transcation Search & Replace

[Edward Doolittle]

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


-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
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] How should I enter values on a budget in gnucash ?

[Edward Doolittle]

gt; these, treating them the same as expenses in the "Total" line (i.e.,
> > subtracting them, currently) is appropriate.
> >
> > I have no idea on a use-case for budgeting changes to equity.
> >
> > As for the names "Total" and "Transfers":
> > As it operates currently, "Total" is a poor name; "Difference" would be
> > more accurate.  However, if you change the sign-reversal treatment you
> may
> > have positive income, negative expenses, and "Total" would be an accurate
> > choice.
> >
> > Transfers--isn't everything in double-entry accounting a transfer?  :-)
> >
> > Just totaling the Income/Expense/etc. would force the budgeter to do the
> > math for each period.  Having some sort of net at the bottom is very
> good.
> > Maybe call it "Net Budgeted Cash Flow"?  After all, I'm describing a
> > planned cash flow.
> >
> > Hope this made sense.
> >
>
> Actually no.
>
> I'm keen to hear feedback with real-world data from real users.
>
> C
> ___
> 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.
>


-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
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] How should I enter values on a budget in gnucash ?

[Edward Doolittle]

That seems reasonable to me.

I thought the other two rows at the bottom represented something like equity.

Get Outlook for iOS


From: gnucash-user 
 on behalf of 
Christopher Lam 
Sent: Tuesday, October 22, 2019 12:18 AM
Cc: Gnucash User
Subject: Re: [GNC] How should I enter values on a budget in gnucash ?

Thanks,
I think a reasonable approach to determine a budget's sign-reversal policy
will be:
- if budgeted expense amounts are mostly negative, conclude "reversal =
income/expense"
- otherwise, if budgeted liability amounts are mostly negative, conclude
"reversal = none"
- otherwise conclude "reversal = credit-accounts"

The next challenge is to try fix the Budget Editor Summary section at the
bottom. While the first 2 rows "Income" "Expense" are self-explanatory,
anyone has any idea the exact definition for "Transfers" and "Total" ?

On Sun, 20 Oct 2019 at 16:25, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> That is what I use. I prefer that negative signs only show up to reflect
> contra balances, which is either good or bad per account as intended.
>
> Regards,
> Adrien
>
> > On Oct 20, 2019 w43d293, at 9:37 AM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> >
> >
> > So the question to everyone using budgets is -- is it safe to assume most
> > of you are using General / Sign Reverses pref = Credit Accounts?
>
>
> ___
> 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.

Re: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use

[Edward Doolittle]

It looks like the driver for the RealTek controller is proprietary, so
you'll have to go through some extra steps to get it working.  For
starters, check out this:
https://unixblogger.com/2016/08/11/how-to-get-your-realtek-rtl8111rtl8168-working-updated-guide/
and the top answer to this:
https://askubuntu.com/questions/933055/ubuntu-16-04-realtek-rtl8111-8168-8411-ethernet-driver-is-not-maintaining-a-pers

A Google search turns up lots of other stuff. You'll have to sift through
it, try a few things, and use your judgment about what to keep.

In the meantime you can get a cheap ethernet card with non-proprietary
driver software to get your networking working.

On 15 March 2018 at 00:17, jeffrey black  wrote:

> I realize this is the wrong forum to ask but; I am finally looking to
> ditch Windoze 10 completely.
>
> I am at my wits end trying to get ubuntu to work with my system. I have
> tried every post I can find on activating the ethernet and wifi, none of
> which work.
>
> I have an iBUYPOWER intel core I5 computer with the Realtek
> RTL8111/8168/8411 PCI Express Gigabit ethernet controller, and usb:o
> realtek generic usb device 802.11ac wlan adapter (usb 2), all built into
> the motherboard.  The motherboard model is H170-pro.  Meaning I have no
> internet, wifi, or networking capability under ubuntu.
>
> I can run ubuntu 14 in a vm window but; it is even slower than Windoze
> 10 pro 64-bit.  And Windoze 10 is painfully slow now. GnuCash takes
> forever to load with all the additional junk micro$oft has added.  Under
> the VM, go to town and eat dinner before GnuCash loads.
>
> Does anyone have a suggestion on what flavor of Unix I should use on
> this computer? Wifi, networking and GnuCash are mandatory
> requirements for me to switch.
>
> --JEffrey Black M.B.A.
>
>
> ___
> 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.




-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
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.

Linux Subsystem for Windows: GnuCash seems to work

[Edward Doolittle]

Hi everyone,

Something that may be of interest to some of you: I just installed the
Linux Subsystem for Windows 10 (LSW) and successfully ran GnuCash. (I just
opened the app and then closed it. I'll try more thorough tests later.) I
don't know who would be interested in this other than developers, but
perhaps someone out there is having trouble getting GnuCash running
properly in Windows and could benefit from an alternative.

Note that X applications are not officially supported under LSW, so there
are occasional bugs (particularly with applications using audio). This is
definitely a try-at-your-own-risk situation. On the other hand, there's
nothing particularly special about an X client: it's just an ordinary
program that communicates with an X server, so I see no problems running an
X client in LSW as long as an X server is running and the two can
communicate.

If you are interested in trying, here are the steps:

1. Install the latest Windows 10 update by running "Windows 10 Update
Assistant". Reboot.
2. Enable Windows Subsystem for Linux by running "Turn Windows Features on
or off". Reboot.
3. Install Ubuntu or another distribution via the Windows Store.
4. Run it. Congratulations, you have a Ubuntu bash shell in Windows.
5. In the bash shell, "sudo apt-get update"
6. In the bash shell, "sudo apt-get install gnucash" (this gets version
2.6.12; other versions can be obtained in other ways)
7. While that is progressing, install an X server in Windows (if you don't
have one already). I got Xming from Sourceforge. Make sure the X server is
running.
8. In the Ubuntu bash shell, run "export DISPLAY=:0" (or whatever you need
to point applications to the correct X server).
9. In the Ubuntu bash shell, run "gnucash".

Windows files are accessible in the bash shell and presumably in GnuCash by
browsing /mnt. I strongly recommend against opening your production GnuCash
file in WSL/Ubuntu/gnucash; instead, copy your production file from (e.g.)
/mnt/c/Users/Username/Documents/file.gnucash to /home/username using the
bash shell and work with the copy instead.

To repeat, I advise caution with this, in particular because X applications
are not supported in LSW. But it does show great promise, I think.

Edward

-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually Post Scheduled Transactions

[Edward Doolittle]

 Is there a source for such instructions?
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Issues with "Assets over time" report

[Edward Doolittle]

My understanding is that Weighted Average is reasonable as a default for an
accounting program, where prices are determined by actual buys and sells.
"Nearest in time" is, as John Ralls has said, mainly for "entertainment
value" ... it is not accounting. On the other hand, most of my saved
reports use Nearest in time ... I appreciate the entertainment, what can I
say.

On 23 May 2017 at 15:42, Adrien Monteleone 
wrote:

>
> > On May 23, 2017, at 3:19 PM, Jose Gómez  wrote:
> >
> > Yes, I meant the the Assets Bar Chart, thanks.
> >
> > Changing the setting as you suggested has fixed the issue. Now stocks
> show
> > the same amount as in the list of accounts. Thanks! :)
> >
> > I don't understand is why the Assets bar chart report has by default the
> > weighted average option selected, whereas the Assets pie chart has as a
> > default nearest in time.
>
> Not sure, but I recall other reports I’ve run the first time I had to
> switch away from Weighted Average. That might be a system default for all
> reports. But I usually am running saved configurations so I don’t usually
> notice this any more.
> -Adrien
>
> >
> > Regards,
> > Jose.
> >
> > I'm guessing you mean the Assets Bar Chart?
> >>
> >> Try the setting Options -> General -> Price Source, set it to "Nearest
> in
> >> Time"
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Issues with "Assets over time" report

[Edward Doolittle]

I'm guessing you mean the Assets Bar Chart?

Try the setting Options -> General -> Price Source, set it to "Nearest in
Time"

On 23 May 2017 at 02:41, Jose Gómez  wrote:

> Hi,
>
> I have just realised that the "assets over time" report is not taking into
> account 2 things:
>
>- Unrealised stock gains. I have some stocks that have changed value. In
>the list of stocks I can see the updated amount, as per the prices set
> in
>the price editor. However, in the report I only see the original value.
>
>
>- Accounts in a different currency. I have a USD account (with 0 amount
>in itself, but parent of a couple of USD stocks), and its parent
> account is
>in EUR (as my main file is). Whereas the total value of the parent EUR
>account, including the current value of the stocks, is correctly
> displayed
>in the accounts list, the report is only showing the EUR part of it.
>
> The "Assets" report does not have the above issues (it shows the right
> amounts in the pie chart). I am not sure about other reports, but can keep
> testing if there is interest.
>
> Regards,
> Jose.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.