[GNC] Import importing duplicate trans
Today I tracked down a problem I've had with OFX import from Citi CC (Costco). I did a partial month import a couple weeks ago. Today I imported the entire statement period (so had several transactions already present). The import "lost" a new entry and "duplicated" an entry already imported. The import bypassed the first fourteen (14) IDs in the file. However, the 14th transaction had not been previously loaded. The 15th transaction (which it loaded) was already loaded by the prior import. Starting with the 16th transaction all the remainder loaded correctly. Looking at the FTID numbers, I suspect that Citi assigns them by MMDD where the MMDD is the transaction date and is a sequential number for this file. I've seen transactions for the same date appearing in random order (not the order in which I remember the charges happening). In this particular case, a couple more transactions for the last date previously downloaded (partial statement period) appeared and were assigned numbers earlier in the file than transactions already downloaded. Hence, Citi assigned FTIDs do not stay with the transaction but are assigned at download time. The lesson for me is to not download a partial statement period. The implication is that the FTID from Citi is not trustworthy for match purposes. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Duplicate Transactions
On 6/27/22 13:43, Jesse MacDougall wrote: Hi there, I am doing some bookkeeping and I went to add two new transactions by right clicking a current transaction and selecting duplicate traction. This usually works rather well. I changed the date and added amount but do not see the transactions in the account GL. However, the amounts did get posted as I see the total dollar amount has changed. Question: 1) how do I find the two transactions so I can delete them? Look for a transaction with a really early date (you entered 2 digit year rather than 4 digit year). Or, attempt to reconcile on of the involved accounts and look for an entry with a strange date. 2) Is there a better way to make a new transaction in an account GL instead of duplicating a transaction and changing the data? I usually just start typing an entry and if the system sees one with exact same leading portion it will offer that up as an easy to accept completion. This will generally give me the additional line items (splits) and I just have to change the amounts. This also allows me to then edit the initial description (such as an order #) after I've accepted all the splits. Merci, -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Single Account Expenses For Current Year Only
I can think of three ways: 1. On the Accounts tab use the down arrow on the far right to add the "Total (Period)" column (and any others you want such as "Present"). 2. Run the Profit/Loss statement for the period of time desired and the account values will show for the period. 3. Use the transaction report to pull up just the transactions you want and get the grand total of that report. On 7/27/22 12:58, Gyle McCollam wrote: Jack, That is the advantage of "Tools/Close Book". If you do that each year, the account balances are the YTD totals. If you have grouped all your medical expenses under a parent account that will be the grand total as well. This way you don't even need a report. It's probably to late now, because if you did close your books each year, I guess you wouldn't even be asking this question. Hopefully, someone that uses reports will be able to help you with the current situation. Or you could close your books "as of" 12/31/2021 and you will then have the totals you are looking for. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Jack Frillman via gnucash-user Sent: Wednesday, July 27, 2022 3:15 PM To: gnucash-user@gnucash.org Subject: [GNC] Single Account Expenses For Current Year Only I want add up all my medical expenses from Jan. 1, 2022 up to today. How do I do that? I tried several different reports and all they gave me was the account balance as of today. I just want what was spent so far for this year. And before you ask I set the date range from 1/1/2022 to "today" in the drop down boxes. Thanks! -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Single Account Expenses For Current Year Only
On 7/27/22 12:15, Jack Frillman via gnucash-user wrote: I want add up all my medical expenses from Jan. 1, 2022 up to today. How do I do that? I tried several different reports and all they gave me was the account balance as of today. I just want what was spent so far for this year. And before you ask I set the date range from 1/1/2022 to "today" in the drop down boxes. Thanks! I presume you have an expense account just for the medical expenses? If not, why not? -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Single Account Expenses For Current Year Only
In which case, the transaction report option would be the best way to get what he wants. On 7/27/22 13:21, Gyle McCollam wrote: Stephen, He could have one account, but he could also have accounts for Hospital, Doctors, Dentists, Prescription, Medical Travel, etc. These could all be under a parent account, Medical, but everyone is different and they may not be. Thank You, *Gyle McCollam* Gyle McCollam gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email *From:* gnucash-user on behalf of Stephen M. Butler *Sent:* Wednesday, July 27, 2022 4:10 PM *To:* gnucash-user@gnucash.org *Subject:* Re: [GNC] Single Account Expenses For Current Year Only On 7/27/22 12:15, Jack Frillman via gnucash-user wrote: > > I want add up all my medical expenses from Jan. 1, 2022 up to today. > How do I do that? > I tried several different reports and all they gave me was the account > balance as of today. I just want what was spent so far for this year. > And before you ask I set the date range from 1/1/2022 to "today" in > the drop down boxes. > > Thanks! > I presume you have an expense account just for the medical expenses? If not, why not? -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Stumped on Mortgage Asst - Screenshots
...@fastmail.com> wrote: All, Please help if you can. I think I've documented with the shots required, but if you want to see something else, sing out. Somewhere I am missing a very basic concept. I'm trying to use the assistant to create a scheduled transaction. The file names describe each step. The file and CoA are dummies until I grasp this concept and move on to putting my 401kk of MUFUs into the tool. - I've used my current statement, due 1 July to match up a amortization website to show the P&I due on 1 July. Amounts and start dates in the assistant are configured to match those amounts. Curiously, the website and my statement show a different remaining balance, but that is outside the scope. - I step you through my assistant. - In the end I show you the result of the assistant, which shows the correct P&I. Escrow is wrong, but I'm sure I can fix that in the editor. I'll accumulate escrow each month and then schedule a payment from escrow asset to tax and insurance expenses once all the above works. - I let GnuCash enter the created transaction (ignoring from birth of the loan) and the transaction for 1 July 2022 is actually the P&I for 1 May 2035. TIA -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Build From Source Near Impossible
Last build I did was on 21.10 (for 4.10-65-g7e4fcc7af+(2022-04-29)). Now running 22.04 but haven't built the latest release yet -- may be a bit before I do. Maybe 5.0 will come out first <>. --Steve On 8/9/22 11:37, Adrien Monteleone wrote: Seems reasonable to me. I'd think the only versions with instructions that are useful are those still supported by Canonical, namely, these LTS releases: 14.04 - EOL 4/24 (ESS 4/19) 16.04 - EOL 4/26 (ESS 4/21) 18.04 - EOL 4/28 (ESS 4/23) 20.04 - EOL 4/30 (ESS 4/25) 22.04 - EOL 4/32 (ESS 4/27) Plus: 22.10, 23.04 & 23.10 (and other future non-LTS versions) when they are released and nuances are determined to need special instructions. (with those to be deprecated as they reach EOL) Or maybe just only provide instructions for LTS and make a note that non-LTS versions aren't supported for long enough by Canonical to warrant their own documentation. Note, the above EOL dates are based on Canonical's ESM (Extended Security Maintenance) available for both Enterprise and Personal Use. (free for the latter) See: https://wiki.ubuntu.com/Releases That is 5 years beyond 'standard support'. (indicated as ESS above) If the dev team wants to stick with the standard support window, then of course 14.04 & 16.04 can also be dropped. Though, 16.04 was a breakpoint with respect to support for physical 32-bit systems. At least some derivatives are still based on 16.04 for that reason. (a recent thread from a user described some difficulty getting a 4.x version to work on an older Linux Lite release.) If someone can report their various results & mileage, maybe those older LTS releases can be sent to a sort of 'archive' page along with a note on the last version of GnuCash that could successfully build on them. Of course, the recommendation can also be to advise the user to switch to a current distribution still actively supporting 32-bit hardware. (Debian/Devuan & Q4OS at least come to mind, I'm sure Distrowatch can inform concerning others.) Regards, Adrien On 8/9/22 12:49 PM, david whiting wrote: I think we should remove the instructions from https://wiki.gnucash.org/wiki/Building_On_Ubuntu for 21.10. Anyone have any objections to that? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. . -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Compiling under Ubuntu 18 thru 22
Someone on this list shared the following script with me to load the
build dependencies.
I ran it back around Ubuntu 18.? and now am up on 22.04 with GnuCash 4.x
Come to think, there may have been a module update since then, but that
will become obvious if you compile.
#!/bin/bash
clear
# this script was developed to install a basic development environment
# for GnuCash > V3 on a Linux Mint 19 OS
echo "Script to install development environment for GnuCash ~V3.0"
echo ""
echo "Installing build environment:"
echo " build-essential"
sudo apt install build-essential
echo " cmake"
sudo apt install cmake
echo " ninja-build"
sudo apt install ninja-build
echo ""
echo "Installing GnuCash dependencies and development headers:"
echo " libglib2.0 and dev headers"
sudo apt install libglib2.0 libglib2.0-dev
echo " libxml2 libxml++2.6-dev libxml2-utils"
sudo apt install libxml2 libxml++2.6-dev libxml2-utils
echo " libxslt1.1 libxslt1-dev"
sudo apt install libxslt1.1 libxslt1-dev
echo " libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev"
sudo apt install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev
echo " gtk+3.0 libgtk-3-dev"
sudo apt install gtk+3.0 libgtk-3-dev
echo " zlib1g zlib1g-dev"
sudo apt install zlib1g zlib1g-dev
echo " guile-2.0 guile-2.0-dev"
sudo apt install guile-2.0 guile-2.0-dev
echo " swig 3.0 on LM19 2.0 on Lm18?"
sudo apt install swig
echo " sudo apt-get install libboost-all-dev"
sudo apt-get install libboost-all-dev
echo " libsecret-1-0 libsecret-1-0-dev"
sudo apt-get install libsecret-1-0 libsecret-1-0-dev
echo " AqBanking Tools"
echo " aqbanking-tools libaqbanking-dev"
sudo apt-get install aqbanking-tools libaqbanking-dev
echo " gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev"
sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
echo " ktoblzcheck libktoblzcheck1-dev"
sudo apt-get install ktoblzcheck libktoblzcheck1-dev
echo " OFX support"
echo " libofx libofx-dev"
sudo apt-get install libofx-dev
echo " xsltproc"
sudo apt-get install xsltproc
echo " Database backend support"
echo " libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql libdbd-sqlite3"
sudo apt-get install libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql
libdbd-sqlite3
echo " Python support"
sudo apt-get install python3-pytest
echo " Google Test"
sudo apt install googletest
=
I do compile from a git repository located on my box at
/home/steve/Projects/GnuCash/gnucash
The below script is run from /home/steve/Projects/GnuCash (one level up
from the git repository). I just pulled the latest commits from the
master and ran this script to compile:
#!/bin/bash
#
# build-gnucash
#
# NOte: do a git pull followed by git checkout of version desired
before starting script
cd $HOME/Projects/GnuCash/gnucash
GITVER=$(git describe)
MYVER=${GITVER%-*}
MYRPR=Build-gnucash_${MYVER}
echo $MYVER
cd ..
rm -rf $MYRPR > /dev/null
mkdir $MYRPR
cd $MYRPR
cmake -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash
make
echo ## sudo make install
---
--Steve
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciling subaccounts
For me the parent placeholder account in GnC is the bank account that is being reconciled. The sub-accounts in GnC are just my way of delegating the funds within that account for certain purposes. I'm not sure about the use case of using the placeholder as a grand total for all accounts held at the bank and then reconciling all of them in one step (checking, saving, CD, money market). I suppose if they were all reported on a single statement On 10/7/22 10:41, R Losey wrote: I kind of like it the way it is currently, for what it's worth. On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for 'virtual' sub-accounts that are used for segregating funds in your own books, but not actual multiple real-world accounts with an institution. The parent is the real account in such a case, so that might be why it is the only one marked reconciled with a date. (it is the only one with a statement to reconcile against) In your case, you seem to be trying to reconcile multiple real accounts through a placeholder parent. But GnuCash doesn't know that. (or 'reconciling' non-institution accounts, such as Expenses.) Until it is 'fixed' or changed, I guess your option is to continue to reconcile-finish the sub-accounts to update them, or else just reconcile them all individually rather than together as sub-accounts. Regards, Adrien On 10/3/22 4:56 PM, Uttam Chakravorty wrote: My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No 01: all the subsequent lines starting '01-' are the subaccounts. Reconciling 01 with subaccounts ticked will reconcile all of them, but only update 01's date field. I then step through the subaccounts and as they are all already reconciled I just press 'Finish' to update their date. Line 11 is a single entry with no subaccounts. Line 12 is similar to Line 2, a Placeholder with three subaccounts. I have tried to indicate the above in Column E, however I have made a mistake with Lines 64, 71 and 77. They have no subaccounts, I annotated them in error as all the top level accounts are reconciled. In terms of consistency I failed to annotate Lines 12, 17 and 59. Looking back this is a scrappy piece of work put together in haste. I hope you will be able to extract something useful, or I will happily do it again. Please advise. Line 18 (A/c code 5 (should be 05)) is particularly interesting. This has subaccounts and they have Placeholders which have subaccounts i.e. three levels deep. Reconciling the top level reconciles all the other levels, however once more it only updates the date at the top level. I do not find it too onerous to live with this little extra keyboard activity. I just wondered if I was doing something wrong again. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Import CSV transactions into GC
cash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> 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 >> > To update your subscription preferences or to unsubscribe: >> > 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 >> To update your subscription preferences or to unsubscribe: >> 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. >> > > > -- > David Carlson > > > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. -- _ Richard Losey rlo...@gmail.com Micah 6:8 -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Sub-Accounting (Was: Problem with missing balance in a parent account **FINAL POST**)
is 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Won't Start on Upgraded Ubuntu 22.10
Upgraded Ubuntu overnight to 22.10. GnC won't start this morning. CI attempt shows "error while loading shared libraries: libicuuc.so.70: cannot open shared object file: No such file or directory" Indeed, it appears that libicuuc.so.71 was installed during the upgrade. GnC version 4.11-136 had been locally compiled so suspect it didn't get libraries updated. Did a git pull, found that 4.12.28 was current in maint, compiled and installed. That fixed the issue (plus forced me to upgrade to the latest). Just a notice to anyone else who may be upgrading Ubuntu this week. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] can't find gnucash on my computer
What O/S? Windows, Mac, Linux (flavor)? Which version of O/S? Which version of GnuCash did you download? On 11/20/22 11:29, Sally Abrams via gnucash-user wrote: I downloaded gnucash. Ran the set up, even tried restarting my computer but no icon and when I search my computer only the setup file shows up. Its not showing up in programs. When I ran set up again, it told me program was on my computer and it uninstalled it so it could reinstall it but my computer still can't find it. i'm on windows 7. I'm planning on upgrading my computer but first want to move my data from quicken to gnucash. thanks for any help. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] How can I enter all fixed assets?
On 11/29/22 18:24, Michael or Penny Novack wrote: On 11/29/2022 8:18 PM, Dr. David Kirkby wrote: I want to start using GnuCash for a company I set up several years ago. The company has some assets - mainly electronic test equipment. Let’s hypothetically assume VNA £1000 Signal generator £500 Frequency counter £250 Calibration kit £2000 Total is £3750 Is there a way of entering the individual items into GnuCash? I realise that I can create an account Assets -> Test equipment with an opening balance of £3750, but that doesn’t itemise individual items. It would be a bit tedious to create accounts for every item individually Assets -> Test equipment -> VNA Assets -> Test equipment -> Signal generator Assets -> Test equipment -> Frequency counter and set each to have an appropriate opening balance. Normally under "assets" one might have a number of high level sub-accounts. For example "current assets" (cash and cash equivalents, bank accounts, A/R (could be "factored), negotiable instruments, etc. Then there might be "inventory" if the business bought and sold widgets. But the sub-category you are asking about is "fixed assets". HOW you subdivide further probably best dictated by how you depreciate them and I haven't a clue about "depreciation" rules in the UK. a) If your gnucash books already exist I would create the accounts with zero balance and add the current BOOK VALUE* with a transaction. b) HERE I would need to know the year purchased, original basis, and total depreciated so far. For that reason I probably would have assets:fixed assets:test equipment: (and then each because the depreciation history for each likely different. I will stop here because you aren't so much asking a gnucash question as a "fundamentals of accounting" question and you need to look up "accounting for/depreciating the fixed assets of a business" and "adjustments upon disposal of a fixed asset" in accordance with the rules of your jurisdiction. In other words, THAT would be the same as in the old days of keeping you books by hand pen and ink on paper. Those rules will affect your choices with regard to "keep all together" vs "have each separate", etc. Michael D Novack The short answer implied by previous responders is: There is no Fixed Assets module in GnuCash! Given Michaels comments above, you find it better to keep a spread-sheet for each class of asset (depreciation rate/age) and keep the sub-totals in GnuCash. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] How can I enter all fixed assets?
On 11/30/22 15:39, Dr. David Kirkby wrote: Having given this more consideration I think the following is my best bet. Comments welcome, but I am not expecting to get definitive professional advice. I am considering to lump them all together under Assets -> Fixed Assets, with an opening balance equal to the value at the start of the financial year, taking into account the depreciation. That value is given to me by my accountant. This will mean that I can not work out the depreciation on an individual item, but my accountant does that each year to submit the accounts. I pay a professional to do that. He can tell me at the end of the year how much the sum of all items have depreciated, and I can just enter that sum once per year. He can also give me the exact amount of depreciation on every item, but I will just ignore that, and record the sum. He doesn’t normally give me the individual items - only the sum. He did give them to me this year as I asked for them, but normally he doesn’t give me a detailed breakdown. In previous years my accountant has never expected me to work out the depreciation - he does it once per year. If I was inspected by HMRC, I doubt that they are going to quibble about the fact I don’t know the depreciation of assets on a particular day. If they do, my accountant would be able to supply them. The HMRC website lists what is inspected of directors - I put a copy below. It mentions “Details of assets owned by the company” but does not actually define what details they are. Does changing the total value once/year in GnuCash under Assets -> Fixed assets seem reasonable given that is all my accountant ever gives me? Dave Accounting records Seems reasonable to me. I would ask the CPA/Accountant if that satisfies the below that you referenced. You must keep accounting records that include: - all money received and spent by the company, including grants and payments from coronavirus (COVID-19) support schemes <https://www.gov.uk/guidance/reporting-coronavirus-covid-19-grants-and-support-payments> - details of assets owned by the company - debts the company owes or is owed - stock the company owns at the end of the financial year - the stocktakings you used to work out the stock figure - all goods bought and sold - who you bought and sold them to and from (unless you run a retail business) You must also keep any other financial records, information and calculations you need to prepare and file your annual accounts and Company Tax Return <https://www.gov.uk/prepare-file-annual-accounts-for-limited-company>. This includes records of: - all money spent by the company, for example receipts, petty cash books, orders and delivery notes - all money received by the company, for example invoices, contracts, sales books and till rolls - any other relevant documents, for example bank statements and correspondence -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] New PC
I can help with (b) and (c). On 12/14/22 11:51, Deborah Millington wrote: Hello, I'm looking for a bit of help please. I've used GnuCash for many years on a laptop which is now struggling to keep going. I've got a newer (second hand) laptop and need to do a one off transfer of my GnuCash files to it so I can use it instead in future. I'm familiar with backing up my files, so I know I can locate them on my old laptop. I've also installed GnuCash on my new laptop. Here are the things I need help with: (a) I should be able to copy my data files to my new laptop and open them using GnuCash. However, I'm sure I've seen something saying that there are lots of other settings/config which aren't transferred this way. Can you tell me what these are & how I update them on the new laptop to match what is one the old one please? (b) In doing the installation, I've discovered that I have been using an old version of GnuCash. Is it worth me backing up my current data file on the old version, then installing the new version on the old laptop & updating the data file before transferring it, or if I just put the data in its existing format onto the new computer will it open the old version data in the new version of software OK & allow me to save the data against the new software version? Depends on how old. If you have a v2 series, then you need to upgrade some on the old machine. See how old of a version you can load on your new machine and get updated to that version on the old box first. Then you can do the remainder of the upgrades on the new box. If you tell the list the version you have on the old laptop along with the O/S and that version, then the list can be more specific in the upgrade path. Also give the O/S and version on the new computer. (c) What do I need to do to ensure I get notifications of future updates? Sign up to this mailing list (gnucash-user). If this has too much traffic, then gnucash-announce <https://lists.gnucash.org/mailman/listinfo/gnucash-announce> has much less traffic but does so the announcements (or so I'm told). I have checked the help as much as I can before posting this. I've seen a few related posts, but nothing which has specifically addressed all aspects of my query. All help appreciated. Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Is there a way to find date & time a transaction was entered?
On 12/18/22 17:14, Dr. David Kirkby wrote: I have a transaction that I entered incorrectly. Is there a way to determine the date & time that the transaction was entered? If so, I could just load a backup file created just before I screwed up. It is easier to just correct the original transaction. I know that in formal accounting one should not delete transactions, but apply a reversing transaction. But I think that will just confuse me, and my accountant more. I don’t need to be too formal - previously I have submitted my accounts to my accountant on a spreadsheet, but that’s too error-prone for my liking. If you were doing this for somebody else then that would be the "proper" route. But, if this is just personal or for your own business, then just erase the bad part and make the correction. It's digital and nobody will know you made a mistake (unless the look at all the log files that you failed to delete). If I delete the transaction, would that put things back exactly as they were before the transaction was entered? Yup, by why be that hard on yourself? I spent about 20 minutes last night trying to understand how £14 had disappeared from the company bank account, clearly marked in the bank account that the money went to PayPal, but there was no record of the transaction on the company PayPal account. I eventually found what had happened - it had gone to my personal PayPal account. There’s no way I would have spotted that error using spreadsheets. The double entry accounting does make finding errors easier than using a spreadsheet. Personally, I would just go to that one line and change the account from paypal personal to paypal company. I must admit, I am quite impressed with GnuCash. Dave Me too. And I'm also lazy so I just do the minimum needed to fix my mistakes. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Roth IRA conversion
On 12/19/22 14:53, Michael or Penny Novack wrote: On 12/19/2022 2:49 PM, David T. wrote: Michael, While I fully respect your answer, with over 45 million IRA accounts in the US (according to one source I found online), this is a pretty common circumstance. It should be possible for basic guidance to be given by *someone*, without all 45 million consulting an accountant. I personally don't know the answer. The question was not about basic IRA accounting (or 401k accounting, which was your example) Usually people choose regular IRA or Roth IRA depending on whether they wanted to pay the income tax now (contribution time) or later (distribution time). So it is NOT "all the people with IRAs" but only "those few whose changed circumstances mean they now want Roth rather than regular". << this is one of the few "changed your mind" that the IRS allows >> For example, I might want to do this if I had regular IRAs and a huge loss of some kind that could be used to offset the imputed income of the conversion to Roth. And I am doing the IRA to Roth conversion now that I'm on Social InSecurity and paying no taxes. So it is tiny bytes each year!! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] How to handle inventory assets in GnuCash?
Eric,
As you noted, they are an Asset. Now, I'm not a CPA or even a book
keeper (though my wife did that job for a number of years for an
architect). Here is how I am doing it.
1. Setup an Asset account for Inventory (or whatever you want to name it).
2. Setup an account for Cost of Goods Sold. (Mine is a contra account
in Income -- your CPA might want it as an Expense).
3. Divide your inventory value by the number of items (if only one type
of item or break out a similar Cost/Item for each type of item).
4. When you make a sale, reduce Inventory by the COGS for that item and
increase the appropriate account from step 2.
Note, I didn't use Credit/Debit as I forget which one is supposed to be
closest to the window. I think that changed recently when I switched my
desk around and the other side of the monitor is now nearest the window.
--Steve
On 12/20/22 06:55, Eric Chapman wrote:
I am wondering how, in GnuCash, to account for assets bought to resell
or other assets that will later be expensed as used.
I'm in the USA context. As far as terminology goes, I think UK and
other English speaking locales use the word "stock" to refer to
inventory, but, in my experience, that is not common in the USA
(indeed, the first definition of "stock" from Apple Dictionary: "the
goods or merchandise kept on the premises of a business or warehouse
and available for sale or distribution"; that is basically the
definition of "inventory" at the bottom of the wiki article referred
to below). I will try to use the word "inventory" so I do not confuse
the term I'm talking about with the one meaning ownership securities
of a company ("He owns 100 shares of XYZ Company stock.").
I found something relevant in the wiki:
https://wiki.gnucash.org/wiki/Inventory_Handling. Best I can tell,
GnuCash does not have any dedicated way to handle inventory flows:
purchases, sales, revaluations for market fluctuations, identification
of lots/batches).
If I want to deal with inventory now in GnuCash v. 4.13, any best
practices? I'm not talking about massive amounts of items or quantities.
Thank you!
Eric
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Changing registers in the middle of entering or editing a transaction
On 12/28/22 14:05, Stan Brown wrote: It's a bit irritating to be told that something is preventing save, but not told what that something is. (Reminds me of the story, hopefully apocryphal, of a C compiler that had only one error message, "Syntax Error", with no indication of where.) Saw that multiple times on a Mod 1 MSR COBOL compiler on a Honeywell 115. My wife was doing data entry at the time and saved my butt on a number of occasions (my programs where keyed onto cards from a coding sheet). "Is this supposed to be a period here?" "Nope. Just a defect in the coding sheet paper." "I thought so but Carla punched a period there. I'll fix it." Still love that woman. 48 years tomorrow! PS. Had a student once ask what was "Syntax". Told her it was the tax the government applied for her sins! -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Bank account reconciled, will this change screw things up?
On 12/30/22 12:43, Dr. David Kirkby wrote: I paid for some postage for £12.54, but instead of sticking the expense account as Postage, I put Payroll - well, then do both begin with P. Given I have reconciled the bank account, is it dangerous to change the account this transaction is debited to, from Payroll to Postage? I was thinking of unposting it, changing the expense account, then paying the invoice again. The amount of money is unchanged. I just modify the account on that one line to point to Postage. It doesn't seem to hurt any and is a whole lot simpler than trying to enter the whole transaction all over again. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Bank account reconciled, will this change screw things up?
On 12/30/22 14:48, Adrien Monteleone wrote: How do you do that for a posted bill/invoice? Mine is immutable. (and should be) Regards, Adrien On 12/30/22 4:32 PM, Stephen M. Butler wrote: I just modify the account on that one line to point to Postage. It doesn't seem to hurt any and is a whole lot simpler than trying to enter the whole transaction all over again. OK. Mine are not tied to the business features. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Are accountants happy with CVS exports?
My CPA accepts the Balance Sheet and Profit/Loss Statement along with a multi-page Q&A his office provides. On 1/2/23 13:30, Dr. David Kirkby wrote: I asked my accountant about using GnuCash. He doesn’t know it, but said if can export a CSV file that will be okay. Previously I have used LibraOffice, with multiple tabs for different things. Something like the following - he provided me with this as a suggestion when I first contacted him. 1) PayPal account 2) Bank Account 3) Expenses 4) Assets 5) Stock - just a list of what I have at the end of the financial year. 6) Electricity usage He can export that as a CSV file. It will have a list of expenses something like 2/1/2023, widgets, £12.34 1/1/2023, things, £178.12 All values are positive, and the sum of those is the sum of the expenses. That’s quite different from the CSV export from GnuCash, where each line has either a positive value or negative, and the sum is zero. Do people get any complaints from accountants about the format of the files, or are they happy with them? I could write my own post-processor using Linux command line tools to get data in a format that more resembles what he had before. Normally I get my accounts to my accountant near the end of the month they need to be submitted, which is 6 months after the end of the financial year. Next time I hope to get them to him *much* earlier so if he has any problems with the exported files, I can manipulate them. It would be nice if one could export all the expenses without the dates being in a random order. The only way I can find to get dates in a chronological order is to export every single account separately, so there are no sub accounts. I thought about trying to write some code that would allow all the expenses to be exported in one file in chronological order. That’s not an impossible task, but would take me quite a bit of coding. If I did it, I would just create something that’s command line driven, using as many as the unix tools as possible to cut down the work. It might be possible to just make a fairly complex shell script. Dave -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Are accountants happy with CVS exports?
On 1/3/23 17:43, Dr. David Kirkby wrote: multi-page Q&A his office provides. Do you not provide details of what the individual transactions to your accountant? If you do provide that, do you just use the unedited CSV files exported from GnuCash? Dave I do print off a detailed transaction report by account/date. So far they haven't asked for it. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Merge two pairs -> one 4-way split
On 1/15/23 11:50, Fred Tydeman wrote: I have one transaction moving money from A to B (one pair) I have another transaction moving money from C to D (another pair) I now realize I should have one transaction with 4 splits. Is there an easy way to merge the two pairs into one 4-way split? Or, do I have to manually re-enter 40 transactions? I do not know of a way to easily merge transactions. On a practical note. Why make the change retroactive? My solution is to let the past be and make the change going forward. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Start up cost in GnuCash
This is a discussion you need to have with your CPA. Involved are the following questions: 1. Is this a sole proprietorship? Partnership? LLC? Corporation? 2. If a sole proprietorship, will the accounting be done in your personal books? Or do you need a separate set of books for the business? 3. Will the business refund you or are these your own expenses? Only your CPA can guide you correctly. --Steve Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 1/24/23 11:18, Joel via gnucash-user wrote: Hello Gnucash, We are trying to figure out how to enter into gnucash the initial expenses or startup cost for the business we have been putting on our personal credit card to start this new business. Thank you in advance for your help. Taneshia and Joel ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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 To update your subscription preferences or to unsubscribe: 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: [GNC] How to force y in reconcile field
On 2/2/23 10:14, Xe Roy wrote: I am new user who made a mistake in a previous reconcile. To correct the mistake, I need to change 2 transactions from n to y in the reconcile field. I see that is not possible via the program, so do I have to edit the .gnucash file or is there a better way? When that happens to me (or I do an edit that turns off the reconcile flag), I just include them (check the box) on the next reconciliation cycle (which mostly happens right then since I have online access to the bank's information). ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] Building Gnucash on Fedora 37 - "No package 'glib-2.0' found" error
This is the package for Ubuntu. apt --yes --force-yes install libglib2.0 libglib2.0-dev In fact, here are all the dependencies needed: apt --yes --force-yes install build-essential apt --yes --force-yes install cmake apt --yes --force-yes install ninja-build apt --yes --force-yes install libglib2.0 libglib2.0-dev apt --yes --force-yes install libxml2 libxml++2.6-dev libxml2-utils apt --yes --force-yes install libxslt1.1 libxslt1-dev apt --yes --force-yes install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev apt --yes --force-yes install gtk+3.0 libgtk-3-dev apt --yes --force-yes install zlib1g zlib1g-dev apt --yes --force-yes install guile-2.0 guile-2.0-dev apt --yes --force-yes install swig apt-get install libboost-all-dev apt-get install libsecret-1-0 libsecret-1-0-dev apt-get install aqbanking-tools libaqbanking-dev apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev apt-get install ktoblzcheck libktoblzcheck1-dev apt-get install libofx-dev apt-get install xsltproc apt-get install libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql libdbd-sqlite3 apt-get install python3-pytest apt --yes --force-yes install googletest Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 3/9/23 14:52, Vivek Gani wrote: Hi, I'm trying to build gnucash from source (rather than the rpm package or flatpak for python bindings) on Linux (Fedora 37) and keep running into an issue where on build I get the error: ``` -- Checking for module 'glib-2.0>=2.56.1' -- No package 'glib-2.0' found ``` What I've tried so far: - I've installed glib2.0-devel via `sudo dnf install glib2-devel` - I've checked via `yum provides */glib2.0.pc` which shows it is in the `/usr/lib64/pkgconfig` directory. - I've checked the contents of `echo $PKG_CONFIG_PATH` which shows directories like `/usr/lib64/pkgconfig` are listed. - I've tried building gnucash with various different arguments, but similar to the directions in https://wiki.gnucash.org/wiki/CMake#GnuCash_Configuration_Variables & https://wiki.gnucash.org/wiki/Building_On_Linux#Build_using_CMake_and_Ninja I've tried in my build directory: `cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt -DCMAKE_PREFIX_PATH=$PKG_CONFIG_PATH -DCMAKE_VERBOSE_MAKEFILE=on ../gnucash-4.13` and get the glib error. It happens also without the CMAKE_PREFIX_PATH, just running plain `cmake .` in the gnucash source directory, etc. Any idea what I'm missing to get things to build? Thanks in advance, Vivek ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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 To update your subscription preferences or to unsubscribe: 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: [GNC] Schedule transaction for 2 Wednesday?
Set it on the Frequency tab.
Frequency -- pick Monthly
Every ? months -- (enter 1 into that box)
On the {big drop down list} -- Pick the '2nd Wed' from the list.
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
On 3/9/23 20:53, Adrien Monteleone wrote:
I don't think you can.
The closest method I can find is to set the first instance to the
second Wednesday then set frequency to 28 days, or 4 weeks.
But of course, that will sometimes fall on the first Wednesday.
The workaround there is to set it for remind and review without
auto-creation and adjust as needed.
Regards,
Adrien
On 3/9/23 10:38 PM, ToddAndMargo via gnucash-user wrote:
Hi All,
Fedora 37
gnucash-4.13-1.fc37.x86_64
How do I set up a scheduled transaction to go off
the second Wednesday of the month?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Schedule transaction for 2 Wednesday?
___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
On 6/2/21 11:22 AM, D. via gnucash-user wrote: Why delete an account that's only going to get created again? 1. So you know when something needs attention. 2. Make you more careful to not let the account be created in the first place. --Steve Original Message From: Michael Hendry Sent: Wed Jun 02 12:25:39 EDT 2021 To: Peter West Cc: GnuCash users group Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS On 2 Jun 2021, at 02:44, Peter West wrote: I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts (at top level in my CoA) extremely useful, and I understand why they are there. If I ever see a balance, I know I have to fix something, which is a good reason to have them at the top. I can’t comment on any changes that might have occurred in the behaviour of these accounts recently. However, in respect of the tidiness of the CoA, one possible solution is to create a special case for these accounts, such that they only display in the CoA listing when they have a non-zero balance. Peter Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out the problem and zeroed their contents - they’ll be created automatically if required. Michael ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
On 6/2/21 2:36 PM, David Carlson wrote:
Stephen,
There have been several posts explaining why it can be desirable to
allow postponement of the completion of a balanced transaction because
not all the details are known but the core of the transaction should
not be postponed into oblivion.
I was responding to the question "Why delete an account that's only
going to get created again?". Not commenting on whether or not the
account should be created as needed. Yes, most times being more careful
will eliminate the sudden appearance of the account. Again, note the
"most".
On Wed, Jun 2, 2021 at 4:24 PM Stephen M. Butler
mailto:stephen.m.butle...@gmail.com>>
wrote:
On 6/2/21 11:22 AM, D. via gnucash-user wrote:
> Why delete an account that's only going to get created again?
1. So you know when something needs attention.
2. Make you more careful to not let the account be created in the
first
place.
--Steve
>
>
> Original Message
> From: Michael Hendry mailto:hendry.mich...@gmail.com>>
> Sent: Wed Jun 02 12:25:39 EDT 2021
> To: Peter West mailto:p...@pbw.id.au>>
> Cc: GnuCash users group mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ??
JUST CURIOUS
>
>> On 2 Jun 2021, at 02:44, Peter West mailto:p...@pbw.id.au>> wrote:
>>
>> I’m a fairly naive user, but I find the Imbalance-XXX and
Orphan-XXX accounts (at top level in my CoA) extremely useful, and
I understand why they are there. If I ever see a balance, I know I
have to fix something, which is a good reason to have them at the
top. I can’t comment on any changes that might have occurred in
the behaviour of these accounts recently. However, in respect of
the tidiness of the CoA, one possible solution is to create a
special case for these accounts, such that they only display in
the CoA listing when they have a non-zero balance.
>>
>> Peter
>
> Why not simply delete the Imbalance and Orphan accounts when
you’ve sorted out the problem and zeroed their contents - they’ll
be created automatically if required.
>
> Michael
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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 <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com <mailto:stephen.m.butle...@gmail.com>
kg...@arrl.net <mailto:kg...@arrl.net>
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.
--
David Carlson
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-
Re: [GNC] Accounting for GST in Australia
On 7/7/21 8:33 AM, Michael or Penny Novack wrote: On 7/7/2021 7:41 AM, flywire wrote: GST is only really supported if it's auto-calculated otherwise a user has to enter twice the splits with the associated logic and keying errors. I've only been using the Account Register for data entry. But GST in Australia appears to be a simple problem compared to "sales tax" here. Which not only varies by state (with respect to rate) but on what is or is not subject to the sales tax. Here in Washington of the USA, sales tax is based on your address. I've seen houses sitting next to each other that are in different tax districts with different rates. Most POS systems just go down to the zip code level so I have to pick the "most popular" tax rate for each zip code. <> This may be too much to expect from an ACCOUNTING system like gnucash if we expect automation. Usually this sort of thing is handled by what is called a POS system (point of sales) which builds the invoice of sales receipt << it will have the total sales tax attributed to this sale figured by adding up the sales tax on each item since whether taxable or at what rate depends on the item >> Such systems also need to make provision of "no tax" sales where the buyer has a certificate of exemption on file with the vendor. Typically a POS system is paired with an accounting system. The latter has only to be able to accept the transaction as created by the POS, not figure it out. Yes. Now if I would only take the time to figure out the multi-split import. But not enough sales to force me into making that effort!! So far I just dump a report for the daily deposit showing the half-dozen amounts (splits) that make up the transaction and manually enter them. Usually I can take the last sale and duplicate it for the next one (with minor changes for the local tax and net deposit). Michael D Novack --Steve ___ 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] Adding new income category or new expenses category
On 7/15/21 12:27 PM, Jim DeLaHunt wrote: Hello, Barry: Welcome to GnuCash and welcome to the gnucash-user list. The word "Bellingham" in your signature caught my eye. Bellingham, WA is near where I live. It is known as the "the city of subdued excitement". :-) Is this a West Coast thread? Battle Ground, WA (Near that other Vancouver). ___ 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] Account setup
Roger, I found it easier to leave all the opening balances at zero while setting up the chart of accounts (COA). Then I create one massive opening transaction dated (in your case) 12/31/2019. That way, if I find I forgot one account, I can add it later then go back and adjust the opening transaction to include an entry for that new account (I know the purist will have nightmares and would prefer you add a new transaction). --Steve On 9/22/21 12:43 PM, Rogier F. van Vlissingen wrote: I am struggling to move an existing business into gnucash. Have a closing trial balance @ year end 2019 In the setup screen I don't necessarily have all the accounts, so I imagine I can set them up later, but some accounts that area available do not let me put in an opening balance. E.g. "retained earnings" has a balance, but in the set up screen there is a greyed out "zero" and I cannot set up the opening balance. Can I edit that later? I tried this before, but was never able to figure it out. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Account setupI
On 9/28/21 10:16 AM, Rogier F. van Vlissingen wrote: Thanks to everyone for helping out. What worked for me in the end was 1. to set up the COA first, without attempting any opening balances, and then 2. to create a single transaction to set up the opening balances on 1/1/2020. As it was, I had an ending trial balance on 12/31/2020, but there were a few mistakes floating around, so in my setup, I made those corrections, and settled it against retained earnings, by making that the final line item in my opening transaction. - One thing I was not able to figure out. If I do set up this way, and I made a mistake in my initial g/l transaction is there a way to edit that transaction, or am I doomed to simply start over and do it the right way? - And since I made a false starts, I now have a couple of sets of books that I want to get rid of, but I wasn't sure how to do it, other than just deleting the file in the file system. <> Rogier, (my apology for not spelling it correctly on my last reply) I have been able to edit that transaction even years later as I recently found some additional items that should have been entered -- but weren't. I know the purist will say that you should just create an additional transaction for that date with the adjustments. I am not a purist! This works for me. Yes, I am able to add new lines to the original transaction, change existing amounts, even delete a line that turned out to be a duplicate. You can always edit a transaction. This is a nice thing. This is a bad thing. This will help get you out of trouble. This will get you into trouble. Beware! Your books are only as good as you make them. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Using Gnucash to access file over flaky network
On 11/24/21 07:54, Chris Green wrote: On Wed, Nov 24, 2021 at 11:24:21AM -0400, Chris Mitchell wrote: Hi all, For reasons that are complicated but not especially interesting, I would like to run Gnucash on one machine, with the data file located on a remote machine — with the added challenge that the network access available to the Gnucash "client" machine is a terrible cellular data connection that sometimes drops without warning. I have daily backups, so I don't need strong guarantees against data loss, but if it's possible, I'd like to set things up so there's reasonable resilience against a network dropout corrupting the remote Gnucash data. I'm not the only user with access to the data, so (given that multi-user is still a long way off), I need file locking to work. Having to manually delete an orphaned lock file after a network dropout is acceptable. I assume that any of the database server backends would include this kind of resilience "out of the box", and I'm not entirely unwilling to try my hand at setting that up, but I am by no means a qualified database administrator. If I can get sufficient resilience by easier means, I'd prefer to stay away from the whole database server thing. What about Sqlite over sshfs? I realize Sqlite is not designed for access to a database residing on a different machine, but my inexpert impression is that its "atomic commit" implementation should protect against sudden disconnection between the program and the storage medium just like it protects against sudden power loss. (IE the transaction that's in the midst of being written will be lost, but the database should be fine.) Can anyone confirm whether it's reasonable to expect that Gnucash with Sqlite backend over sshfs would have working locking and decent resilience against data corruption in this scenario? Or point out any obvious "gotcha" I'm missing? I think a better approach might be to simply copy the database to the machine you're working on when you start GnuCash and then copy the database back again afterwards. Go so far as to create a script that would check for your own lock file before making the copy. If lock file not present, then create it and copy the database. Lock file could be as simple as renaming file with an extension of "xxx.IhaveIT". Then the reverse script would remove the lock after copying the updated file back to the original name. That way anybody else trying to update the file would know it was already "checked out". -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] An automated depreciation calculator would be really helpful.
ach time an asset is purchased, one needs to start depreciating it from then. It's not true to say this is just done once per year. Of course, I'm well aware that many people will have suggestions on how to improve the software, and the developer's time is limited. But some automated way of depreciating items would be very useful. As they say, if you don't ask you will not get, so there's no harm in asking! Dave ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Directors loan - do I need an expense account?
On 12/9/21 19:38, Stan Brown wrote: On 2021-12-09 11:04, Gyle McCollam wrote: If the loan is to the company, as stated in your original email, it is a liability of the company. Stan is incorrect, but if the company makes a loan TO the director, then it would be an asset of the company and he would be correct. But the OP said: ... as I thought that was the closest thing to allowing money to be moved out of the company, into my personal bank account. When I tried to pay myself using GnuCash, I was expecting money to go out of the company bank account,into my personal account, and reduce the company's liability. However when I set up a bill, I could see it was only possible to bill this as assets or expenses - *not as a liabilitiy*. Does this mean I need to set up another account for expenses? "money out of the company into my personal bank account" -- that seems pretty clear to me that the company is lending the director money, not the other way round. 1. Lending money. 2. Paying a Dividend. 3. Reimbursement for expense paid by individual. 4. Reduction of equity share (stock buy-back). All of those could be "money out of the company into my personal bank account". -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Coloring the Action field
On 12/16/21 10:05, Michael or Penny Novack wrote: It might perhaps be better to describe WHAT you want to accomplish instead of asking about possibilities for the first HOW that came to your mind. Why? Because there might be other "hows" even simpler. On 12/16/2021 2:25 AM, AC wrote: For example, I have a couple loans that are paid fixed amounts each month but the split of principal and interest varies (of course). I have automatic payments at the bank set up to pay those fixed amounts regularly and I have a matching scheduled transaction in GnuCash that is a placeholder for it so I know how much comes out of my checking account. What I don't know at that moment is the split between principal and interest. I'll reword that -- you don't have access (in advance) to the amortization schedule and even if you did, would not help with an automated transaction (but would if a manual transaction_ When the payment has gone through I will check the loan records wherever the loan is held to see how they distributed the payment and then go back and update the splits to reflect that. I do a similar thing for my paychecks, setting up a scheduled transaction with an estimated amount across splits and then go back to update the splits with the various amounts withheld from the check (I mark these as "Deposit"). Let's stop here for a second to describe your PROCESS. In either case, you first need to be able to have an automatic transaction (unsplit) that you later need to go back to in order to split once you have the information to do that. You think you need a "marker" of some sort to find the transaction later, to mark the ones you have not yet done. But what was the other side of the transaction?. Let's do the loan one first. That was an automatic (scheduled) transaction, credit to your bank account and debit to (there are always tow sides in double entry bookkeeping) what? Let's say for am moment you had an account under Expense with a name like "unallocated loan payments". Every so often you look. Is the balance of this account zero? No, then you have a loan payment you have not yet allocated to principle and interest. Assuming enough time has passed that you have that information, Enter split mode. Change the account "unallocated loan payments" to "interest" and the amount to what that portion is. The remainder will now have an account Imbalance which you change to "loan principle". Now THAT transaction will no longer appear in "unallocated loan payments" << and if there are no other payments still not allocated the balance of the account will be zero >> In other words, the very presence of a transaction in "unallocated loan balance" can serve as your "marker" and is the transaction you want to split. You can do the same for your paychecks, except you would use an account under Income "unallocated paychecks". Michael D Novack Why not point to the loan wizard and how it can setup an automated transaction schedule? Sure, it is off a few pennies every so often but if a person is looking at the loan details a their bank (or get a monthly statement) it is easy to adjust the existing transactions. Once you understand the resulting schedule formula, you can modify for extra monthly payments and won't need the wizard to setup the next loan. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] last reconcilliation
On 12/19/21 10:20, Billie-Internet wrote: Good Evening. I am running gnucash 4.4 on win 10. I have to admit, I have a personal account that I have not reconcilled in months. Please tell me how to find the last reconcile. I have looked at reports and seem lost. Thanks, Billie 706-383-9057 I see others have responded on how to get that date. I'll just mention that I never worry about that date. Could be a month ago or a year ago. I just check that the everything listed on the intervening statements has been checked off in GnC and that the outstanding balance is at $0. For me, online access to the account replaces the multiple statements. Can be a long process if its been awhile, If not zero then I either checked off something as being received that shouldn't have been or I don't have an entry in GnC that should be there. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
On 12/24/21 06:30, david whiting wrote: Hi Jeff, The script below will build version 4.9 on Ubuntu 20.04 LTS. I have verified this on a clean installation of Ubuntu. One thing that tripped me up a few times is remembering to tick "Source Code" in the Software And Updates dialogue. If you don't do this, it will fail. Please note that I have used -y with apt install so it will install and build without asking. I will try to get around to putting this in the wiki to make it easier for people to find. === build.sh === ## Ubuntu 20.04 ## In "Software and Updates": ## Tick "Source code" ## Tick "Community-maintained free and open-source software (Universe)" ## Change this if you want to build it somewhere else. SOURCEDIR="$HOME/Documents/gnucash/source" BUILDDIR="$HOME/Documents/gnucash/build" ## Change this if you want to install it somewhere else. INSTALLDIR=/opt/gnucash sudo apt -y update sudo apt -y upgrade sudo apt -y install git sudo apt -y build-dep gnucash ## To build series 4 of gnucash on Ubuntu 20.04 sudo apt -y install libboost-program-options1.71-dev mkdir -p $SOURCEDIR mkdir -p $BUILDDIR ## Clone gnucash source from git git clone https://github.com/Gnucash/gnucash.git $SOURCEDIR ## Checkout version 4.9 cd $SOURCEDIR git checkout -b 4.9 4.9 cd $BUILDDIR cmake -DCMAKE_INSTALL_PREFIX=$INSTALLDIR $SOURCEDIR make === End of build.sh === Fingers-crossed this will work for you. David I am on Ubuntu 21.10 and have been lagging way behind. So tried this morning. All was well until the libboost portion. *sudo apt -y update ** **sudo apt -y upgrade ** **sudo apt -y install git ** **sudo apt -y build-dep gnucash * Hit:1 http://dl.google.com/linux/chrome/deb stable InRelease Hit:2 http://us.archive.ubuntu.com/ubuntu impish InRelease Get:3 http://us.archive.ubuntu.com/ubuntu impish-updates InRelease [110 kB] Hit:4 http://ppa.launchpad.net/inkscape.dev/stable/ubuntu impish InRelease Hit:5 http://archive.canonical.com/ubuntu impish InRelease Hit:6 http://ppa.launchpad.net/teejee2008/ppa/ubuntu impish InRelease Get:7 http://us.archive.ubuntu.com/ubuntu impish-backports InRelease [101 kB] Get:8 http://us.archive.ubuntu.com/ubuntu impish-security InRelease [110 kB] Hit:9 http://ppa.launchpad.net/ubuntu-mozilla-security/ppa/ubuntu impish InRelease Hit:10 http://ppa.launchpad.net/ubuntuhandbook1/avidemux/ubuntu impish InRelease Fetched 321 kB in 2s (197 kB/s) Reading package lists... Done Building dependency tree... Done Reading state information... Done All packages are up to date. Reading package lists... Done Building dependency tree... Done Reading state information... Done Calculating upgrade... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Done Building dependency tree... Done Reading state information... Done git is already the newest version (1:2.32.0-1ubuntu1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Done Reading package lists... Done Building dependency tree... Done Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. *sudo apt -y install libboost-program-options1.71-dev * Reading package lists... Done Building dependency tree... Done Reading state information... Done Package libboost-program-options1.71-dev is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'libboost-program-options1.71-dev' has no installation candidate -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
On 12/24/21 11:58, davidcousen...@gmail.com wrote: Stephen, Jeff Try $apt-cache search libboost Found these: libboost-program-options-dev - program options library for C++ (default version) libboost-program-options1.74-dev - program options library for C++ libboost-program-options1.74.0 - program options library for C++ This will list the libboost options available to install from apt. If libboost- program-options1.71-dev is not listed it is possible that there will be a generic version libboost-program-options-dev or libboost-program-options1.67- dev or possibly even a more recent version if one exists. AFAIK the libboost- program-options-dev will load the most recent available version of the library. GC will work with v1.67 or 1,71 of libboost. Once you have identified a candidate for libboost to install use $sudo apt -y install libboost-program-options-dev So did: sudo apt -y install libboost-program-options-dev and got: Reading package lists... Done Building dependency tree... Done Reading state information... Done libboost-program-options-dev is already the newest version (1.74.0.3ubuntu6). libboost-program-options-dev set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 21.10 must have the 1.74 version. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Advancing scheduled transactions
Roger,
That would be nice. Need to enter an enhancement request to have that
added during the copious amounts of free time the developers have!
But, to get around that limitation, I do use the "Create in Advance" so
it is in the register early (but for the scheduled date). That way I
can just adjust the date on the transaction that is already waiting.
That's the only way now to move a scheduled transaction earlier. Now, if
you want an extra one, duplicate it from the prior month.
--Steve
On 12/29/21 16:15, rmom...@gmail.com wrote:
Steve,
Just want the option to trigger a post manually, not a permanent
change in the schedule. As you do, I set up my scheduled transactions
to post on the 1^st of the month regardless of the date of the
transaction. I usually wait till the first to pay and post my bills to
accommodate the scheduled transactions limitations. It would be like
skipping a scheduled transaction for one month only the opposite,
activating it early. Pick a scheduled transaction and tell the program
to go ahead and post it today, on the 30^th of month prior to the next
scheduled transaction date. Hope that explains what I’m looking for.
Thanks,
Roger
*From:* Steve Butler
*Sent:* Wednesday, December 29, 2021 10:47 AM
*To:* rmom...@gmail.com
*Subject:* Re: [GNC] Advancing scheduled transactions
Not sure what you are asking. Do you want to permanently change the
date the transaction fires?
Or is this just a random change because it came early that month?
Note: I generally have scheduled transactions automatically post
15-20 days early so I can see their effect in the registers of
interest. If I note that the transaction posted on a date different,
it is easy to change the date in that register.
I haven't tried editing the general/overview panel on a scheduled
transaction to see if the scheduled date could be permanently changed.
On Wed, Dec 29, 2021, 08:24 wrote:
Is there a way to advance a specific scheduled transaction in
Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end
of the
month. I don't see a way to do that. Hasn't been one as far as I
know in
previous versions. Just be a handy feature.
Happy New Year,
Roger
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
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] 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 all is good. Sorry I can't help with the Wizard. --Steve PS. This also let's me adjust the opening transaction later if I messed up and missed an item or later decided to split an account retroactively. On 12/30/21 14:07, Rogier F. van Vlissingen wrote: 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 Equity: Retained Earnings: $D Liabilities: Credit Card: $E Liabilities: Officer Loan 1: $F Liabilities: Officer Loan 2: $G Liabilities: Officer Loan 3: $H --- And it all balanced. That is just exactly how simple it is. in 4.9 I have not been able to recreate anything similar. for when you edit the accounts, you can enter the opening balance, but not for Retained Earnings. On Thu, Dec 30, 2021 at 4:54 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: 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 'opening balance' entry if you didn't start your books at zero. Thus the Opening Balance account would very likely include Retained Earnings. Why do you think it shouldn't? Regards, Adrien On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote: However, now I end up with another problem to which I have yet to receive a satisfactory solution. When setting up the opening balances, the retained earnings is not allowing editing, so it ends up that the Opening Balance account now holds the total of the actual opening balances plus an amount that should be retained earnings. In 3.8 I was able to set this up properly with one opening transaction, but in 4.9 I have not found the way. I posted about it on the list, but so far no usable suggestions. Only another user having the same problem. I used gnucash years ago without a problem for some small project, but at this point , I feel like I am in a total Catch-22. I don't trust 3.8 anymore and so far 4.9 is letting me down. ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Closing Books - Pros & Cons
On 1/3/22 14:23, Adrien Monteleone wrote: The list archive is littered with such questions and answers. I'm not sure if anyone put any definitive Pro-Con write up together. The short answer is, you don't ever *need* to close because you don't *need* to reset your CoA. GnuCash dutifully reports both 'from the beginning' and 'this year/period' just fine without doing so. (there are selectable columns on the CoA tab to do just that) All reports default to 'this year' unless you've saved customized reports otherwise. (the exception being the Balance Sheet, which is always in any software 'since the beginning') This saves you the need to make closing and then reversing entries each year. (and if you use the Business Features, you'll have to manually do your accrual transactions) By not closing, you can run reports that cross annual boundaries with no issues should you ever find the utility in doing so. If you do close, your P&L will be zero afterwards for that prior year. (because the closing entries zero out all expenses and revenue to equity as of the last day of the year.) Not in my experience. The P&L knows about the closing entries and will ignore them (unless you tell it not to). So you'd have to run that report, save a copy, then close, then ideally save a backup of your file, then continue on. By not closing, you just continue on. You can run that report at any time with the same accuracy. If you ever need to re-run that P&L (say after making edits or adjustments) you'd have to do so from within that backup copy, or else delete/reverse the closing entries, and go from there. I've been known to delete the closing entries (just 2 transactions), make a change, and re-close. It is a pain but if your wife is an accountant you mirror paper as much as possible! In short, whatever the reason for having to 'close' in the past due to the limitations of number of pages in a physical book, or for organizational purposes relating to that, computers don't require the same. You can just keep going, and going, and going. Personally, I don't close. I have no compelling reason to add work for myself or complicate my accounting life. Regards, Adrien I do close. Personal preference (so my spouse informs me). YMMV --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Closing Books - Pros & Cons
On 1/3/22 14:50, Jesse MacDougall wrote: Hi Ryan I am pro accountant. Closing books means no one can post for that period anymore. So u close GnC will let you continue to post transactions to prior years even though you may have executed the "Close Books" for that year. books once your have completed your final review and maybe got some entries from an accounting firm like me. You probs dont need an accounting firm though so once all your transactions are in and your cash account agrees to your bank account you now make your year end entries. Then close. You dont create a new set of chart of accounts. They roll forward each year. I think of chart of accounts as the framework of a skyscraper building being built. Chart of accounts are your financial infastructure. On Mon., Jan. 3, 2022, 10:31 Ryan Carver, wrote: Hi All, I am using Gnucash for my small business (a design consultancy) and I have no experience or knowledge of accounting. Could someone please explain the PROs & CONs of using the “Close Books” feature in layman’s terms? The online database states that using the “Close Books” tool will result in some report inaccuracies. Could someone elaborate on which reports would result in inaccurate reports? I ran a few test reports after using the “Close Book” tool and I did not notice any report inaccuracies. Given my limited accounting knowledge it only seems intuitive that one would always want to reset their chart of accounts for each fiscal year so you can quickly see the correct period totals for each account. I don't. Closing the books for me just means I get to create an account in the Equities section that I get to label "Retained Earnings for 2021" (or whichever year I was closing). It's not needed -- just my preference. So, only the Income and Expense accounts and this one Equity account have entries made against them. Otherwise, everything else remains the same. If you don't close the books, the Life-to-Date retained earnings will show up in that portion of the P&L. If you close the books, then there will be no retained earnings on that portion of the P&L (until you have transactions in the non-closed year). This will be because you booked them via the closing transactions to your own retained earnings account. What does everyone else do when starting a new fiscal year? As little as possible. Thanks, Ryan Carver ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] gnucash-user Digest, Vol 226, Issue 60
On 1/21/22 08:01, bonoposo007 wrote: HELP!!! How can I print my profit/loss for 2021…reports only wants to print current year.I have googled and looked at manual, tells me to go to option in reports but there is no such tab in my file. The system says I have 4.8 The Top row should end with the "HELP" menu item. Just below that should be a box labelled STOP. To the right of STOP is OPTIONS. Click on OPTIONS. Note that this is on the second row that ends with PRINT. ___ 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] Advice on restarting use of GnuCash
On 1/21/22 08:45, Derek Atkins wrote: Hi, On Fri, January 21, 2022 11:04 am, Peter Coleman wrote: I used GnuCash for our household finances up until about two years ago. I now want to start using it again with effect from 1.1.22. The version of my software is 2.6.19 (probably about 5 years old). I would like to keep the existing account structure, as I have saved lots of detail there, but I want to enter a whole new set of opening balances. Can anyone advise how I can best achieve this AND how I can install the latest version of the software without losing the data that I want to retain? Thank you in advance for any assistance you might offer. Use File -> Export Accounts Save that as your new data file, and then File -> Open that new file. I will also add that your version is WAY out of date. We're already late in the 4.x series! You really should update. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek I would recommend doing the update just after the export and before importing the account structure. You should be able to jump to the newest version without having to install all the intermediate major updates. As a safety backup plan, print out the Balance Sheet and P&L statements from the old data files before doing the export. That way, if the import fails you at least have a list of the accounts with balances to do a manual setup. That would be a last resort. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Split transaction
Heidi, Also, this sounds like a credit card being used for several purchases throughout the month. In which case it is better to record the individual purchases as they occur. Or, download the individual lines to import. In that case, you will have a Liability:Credit Card:nameofcc account against which all the transactions will post with the other side of the post (the other split) being the relevant expense account. When you pay the credit card off, you record the payment against the checking account on the one side and the Liability account on the other. Otherwise, if you have a lot of purchases throughout the month there would be one humongous transaction with gobs of splits and you would lose the date for each purchase. On 1/21/22 20:59, davidcousen...@gmail.com wrote: heidi, It would appear you don't understand the basis of double entry accounting which is what is used in accounting practice generally and by GnuCash. The Tutorial and Concepts Guide for GnuCash, https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html, has a brief outline of the basis of this in Part I Chapter 2 as well as specific exaamples of typical transactions for checkbooks and credit cards in Part II. Wikipeiad also has entries for double entry accounting. There is also a detailed help manual which explains the interface operations https://www.gnucash.org/docs/v4/C/gnucash-help/help.html. If you could read through the first part of the Tutorial and concepts guide, how to use GnuCash may be a little clearer and make more sense. Just a little bit on nomenclature. A single transaction always affects at least two accounts (sometimes more) and the sum of the debits and the sum of the credits for a single transaction must always be equal. When you buy something using a debit card, to record the purchase you generally reduce ( Withdraw or Credit) the balance of your bank account (an asset account) and increase the balance of an expense account (Deposit or Debit) associated with the type of item you are buying. ( the above heading names are appliacble for an account of type Asset but may be different for Liability,Income Equity and Expense accounts) The names in brackets are the headings of the last two columns in an account register display, the first in each being the informal headings many people use and the second the formal accounting headings used in accounting practice. Which labels you use is a used preference set in the dialogue opened with Edit->Preferences from the menu. You would generally enter such a transaction from the register for your bank account and it will have at least two lines. You can see the two lines for a transaction (normally only a summary line is displayed) by selecting the View- Autosplit Ledger option from the menu while you have the tab for the relvant account register open. Clicking on a transaction to select it will open it as a summary line folowed by each split line. You will see that each line of a simple transaction has an entry in either the or DepositDebit or Credit Column (it is possible for more complex transactions e.g. where tax is involved to have more than two lines) and that the amount in one column equals the amount in the other. Hope this helps make things a little clearer. Come back if you have further questions after reading the tutorial and Concepts introductory material. David Cousens ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 Price Import: Saving Colum Assignments
I used to use the csv file import in version 3.8. That remembered the column assignments, date format, and the main account (a liability account). Sounds like this is a bug. --Steve On 1/25/22 13:40, Thomas wrote: Dear list, I have a fixed format of CSV-files to import prices for securities and I saved the respective preset in the CSV import wizard. Unfortunately, only the assignment for the date is "remembered", while the other column assignments (e.g., namespace, symbol, value) are always set to none when I load the said preset. Is this normal behavior and/or is there a way to also save the other assignments? GnuCash Version: 4.9 Version-ID: 4.9+(2021-12-18) on ArchLinux Thanks a lot in advance! Best, Thomas ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Printing reports
You have to open the "saved configuration" rather than the normal report. When you click on the REPORTS main menu item, scan down and click on "Saved Report Configurations", then pick the one you saved. --Steve On 1/26/22 10:06, One-time queries wrote: Back to using Gnucash after many years absence. It seems to have changed from what I remember. My problem is that I want to set ‘Print to File’ as my default on the Print window. Additionally I want to save the choices for a report so that I can print that report again without having to set in all the variables. I want, for example, all accounts to be selected. I want the default dates to be from the beginning of the previous year to the end of the previous year- I have tried to save these using both Save Config and Save Config As… but when I try to open the report it is back to default, that is no accounts, beginning of this year and end of this year. What am I missing? ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Adding late charges to a vendor bill after posting?
I setup an Asset account as a sub-account to the Bank's Saving account called "Sinking Fund". In a spreadsheet I list all the "one-time" [quarterly, semi-annual, annual] payments that need to be made. Add these up then divide by 12. This is how much you MUST move from checking to savings each month in order to have funds available as needed. You may need to preload an amount to keep from going negative sometime during the year. I then setup an automated monthly transfer at the bank to fire each month to move that amount each month from checking to savings. I also setup a monthly scheduled transaction in GnC to fire on the same day as the automated bank transfer. This transaction is set to load 15 days before the scheduled date so I can watch the checking account register to be sure the funds will be there for the automated transaction. Then as each of these amounts come due, I move the funds from savings back to checking and then write the check to make the payment (in my account I setup the payment on the bank's system for them to draw the funds from checking). Be sure to enter both transactions in GnC: 1. Move the funds from Sinking to Checking. 2. Make the payment on the date the bank says the check will arrive at the payee. On 1/29/22 17:57, Eric H. Bowen via gnucash-user wrote: Property taxes are due. Actually, by the time you read this, they will be past due... I used the "vendor bill" Payables system to track this when I got the tax bill in November and I've made a partial payment, but the funds just are not there to choke down the whole thing. So I'm going to get gigged for a late fee, and possibly even more if I can't settle up by the end of February. What's the proper way to track this? If it gets to the point where I need to make a monthly payment arrangement (basically a 12 month note) I was going to enter the note as a new liability and credit that towards the tax payment due. But if I can get this cleared up by late February or mid-March then I'll just have a month or two of late fees/interest due. Is there a way to associate that with the tax payment after the bill has been posted? How should it properly be handled? Asking for a friend ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Reconciliation conflict while editing split in account/sub-account being reconciled.
I just filed bug 798444 <https://bugs.gnucash.org/show_bug.cgi?id=798444> describing a non-detected conflict between editing a split (setting the cleared flag) and reconciliation on that account (or it's parent) where the reconcile status was cleared after reconciliation finished. I didn't realize that setting flag hadn't been committed before starting reconciliation. This may catch users off guard and be the cause of why some splits "lose" their reconciliation flag. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] mortgage calculator
rom my mortgage and loan statements. Sorry, Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Automatic sales tax
On 2/21/22 07:00, Michael or Penny Novack wrote: On 2/20/2022 7:58 PM, David Carlson wrote: Here in Illinois it varies by county, city, merchandise category, service category, seller category and sometimes by such arcane variables as library district (well, that last one may be a slight exaggeration). And not only is it that complex, but the DATA (what IS the jurisdiction that applies) is typically not available. Almost always the information by the vendor, just the postal address. For example, while my town (township) does indeed have a PO with zip code 01338 that post office delivers no mail (just for PO boxes inside that post office). On the other hand, four different post office with zip codes 01330, 01339, 01340, and 01370 do deliver mail to addresses located in my town. So EVERY street address in my town has some other town in the address << well one of those isn't a "town" but a village on the boundary of two towns (townships) >> There was a period during which when writing a letter to my Congressman I had to make it very clear, "Yes, I AM a constituent living in your district in spite of appearances" (the "town" on my address was outside his district) And I can think of a merchandise category/seller category tax difference in my state. Buy a pair of gloves (clothing, not taxed) in a clothing store/department store vs buy the SAME pair of gloves (protective gear, taxed) in a hardware store. BTW --- usually responsibility for figuring sales tax is in the POS system, not the accounting package being fed by POS (POS would also interact with the Inventory system). The accounting package is just one part of an "integrated business system". Michael D Novack Here in Washington state the state does post an address file to assigns rate codes by address. In at least one case two houses with the same zip+4 are in different location codes. Most web hosts POS systems can only go down to the zip code level. Thankfully I don't have enough sales outside the state to worry about taxes in the other states! --Steve (www.hamflags.com) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Automatic sales tax << slightly off topic (but mail related) >>
On 2/21/22 10:52, Michael or Penny Novack wrote: On 2/21/2022 1:09 PM, Stephen M. Butler wrote: Here in Washington state the state does post an address file to assigns rate codes by address. In at least one case two houses with the same zip+4 are in different location codes. Most web hosts POS systems can only go down to the zip code level. Thankfully I don't have enough sales outside the state to worry about taxes in the other states! --Steve (www.hamflags.com) Do you know how they get the mail to the folks who live on Pt Roberts? For those who don't know this, there are two little bits of the US (lower 48) that though not islands have no land connection to the US and this is one of them. Have to go through Canada. I guess since Puget Sound doesn't freeze they could use boats. Northwest Angle (MN) is the other and during the time Lake of the Woods is neither open nor frozen solid, boats would be out. The only time I ever discussed this with PO "experts" they said they couldn't imagine sent in sealed bags through Canada << I didn't tell then that once upon a time Canada had that sort of arrangement with us for mail to the Yukon -- Before the highway, the only way in was the railroad from Skagway Alaska to Whitehorse and mail came up from Vancouver by ship and then the railroad over the pass back into Canada. So why not reciprocal arrangements >> Michael D Novack According to an Internet search it appears they send mail via boat to/from Seattle. Mail sent from Pt Roberts is post-marked Seattle. I presume incoming mail is sent out from Seattle by boat. You're right, Puget Sound does not freeze -- but there are days that it feels that way! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] (no subject)
On 2/22/22 11:24, Thomas Boerner wrote: Mario, under Linux Gnucash stores its settings using dconf. You can view them with the dconf-editor). Inside dconf you will find your gnucash settings, including the file history, under org/gnucash/GnuCash (Older versions of GNC used org.gnucash). In the filesystem it's in ~/.config/dconf/user, so this is the file you are looking for. Since nearly all applications store their user related settings under ~/.config/, it's worth a thought to backup this folder entirely (including "hidden" files with names starting with a period). But I agree Steve that it's an even better idea to backup your whole home directory on a regular base. Thomas I added these commands to my .profile file so the backup will even get a list of current installed packages: dpkg --get-selections > .BackupInfo/Package.list rm -rf .BackupInfo/etc-apt/* cp -R /etc/apt/* .BackupInfo/etc-apt apt-key exportall > .BackupInfo/Repo.keys 2> /dev/null So those run every time I log into my user account. The nightly backup (deja vu) sends it's output to a NAS sitting on the network. That NAS is backed up regularly to off-line storage in one of my out-buildings. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] reconcile problem?
On 2/23/22 07:23, Paul Kinzelman wrote: The latter is certainly possible, but it's strange that this started with gnucash, didn't happen with Quicken. But if nobody else has noticed this, then maybe it is the latter. :-) And I have NEVER connected it to my account, as you suggested, I ALWAYS enter everything by hand. Oh, and I'm using the Windows latest version. A while ago, I remember seeing a number of transactions which were marked as reconciled become unreconciled as well, and it balanced after I checked them as reconciled again the next month. The real kicker was the one item I noticed that came up reconciled this month as tho I had done it last month. And I couldn't have done it last month or else it would have been unbalanced. And the charge was not on last month's statement. But if nobody else has seen anything like this, maybe it is something I'm doing. But it's strange that I never saw it with Quicken, thus my post. On 2/23/2022 7:51 AM, Derek Atkins wrote: HI, On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote: I always balance my accounts every month. I used to use Quicken before they went to a rental model. Credit cards always balanced every month for me. I've been using GC for several years now, and notice that I sometimes can't get cards to balance, I have to add an imbalance amount. Then this month, I noticed that a charge that was on this month's statement and not last month's statement was already marked as reconciled in GC. Has anybody else noticed anything like this? I don't even know how to track this kind of thing down, whether it's a bug, or I'm just getting older and senile. :-) without being rude, I would suggest the latter. How are you entering your transactions? I always enter them manually (I NEVER import), and when I have a problem balancing I find it's *ALMOST ALWAYS* an error on my part (especially with my wife's card, because I don't get receipts from any online shopping she does). When entering I find I sometimes swap digits, which causes the result to be off. Every once in a while I have to cancel the reconcile and start over and CAREFULLY watch the numbers to find where I entered something incorrectly. If you find you're off, then check again -- most likely something was entered wrong. Either that or you modified an existing, reconciled transaction (from the other side) which caused a break in that starting balance. Ideas? TIA! Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek For my CC purchases I do an OFX download of the transactions for the most recent statement once a month. It automatically marks the transactions as cleared for me (so I don't have to check them off at reconcile time) and almost always balances. This month was one of the rare exceptions and it appears that one of the transactions to which I had to assign an account was duplicated with the following transaction removed. Can't prove it at this time so I'll be watching to see if I can catch it happening again (and this time I'll keep the import file around!) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Scheduled transactions feature or bug?
On 4/12/22 11:59, Glenn Fowler wrote: Thanks Gyle, that saves some steps. However, I do agree with the OP in that you would think the expected behavior would be to pause when disabled, and then when reenabled to not go back to prior to that point. How far back? How far in the future? That's why there are dates there. If you want it to start this month, then change the start date. If next month then enter that date. If last month or two months ago (because you are late restarting) then that date. If all you do is remove the disable flag and you leave the dates as they were then the application is doing as instructed. Many times as a developer I've wished for the DWIM hardware instruction to be active -- Do What I Mean (and not as I said). --Steve On Tue, Apr 12, 2022 at 1:34 PM Gyle McCollam wrote: You don't have to delete and create a new one, just change the start date in the one you have. Sent from Samsung Galaxy smartphone. Original message From: Glenn Fowler Date: 4/12/22 1:03 PM (GMT-05:00) To: Dale Alspach Cc: GnuCash-User Subject: Re: [GNC] Scheduled transactions feature or bug? I'm glad I saw this post as I have a disabled scheduled transaction that I was getting ready to renable myself. I guess the solution would be to delete the recurring and enter a new one. I would have also expected that enabling would start that day time otherwise what would a disable button really be used for if it goes back and enters transactions as if it was never disabled? On Tue, Apr 12, 2022, 10:55 AM Dale Alspach wrote: I had a scheduled transfer to savings that I disabled for a few months. When I re-enabled the scheduled transfer I did not change the start date. I was very surprised to find that when it ran that it entered transactions for all of the months when it was disabled. Automatically altering the past seems extremely dangerous. It seems to me a warning should be given or scheduled transactions should only insert future transactions. Dale ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to manage multiple accounts (as in separate gnucash?? databases)?
On 4/26/22 11:33, Robert Heller wrote: At Tue, 26 Apr 2022 19:21:46 +0100 Chris Green wrote: On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote: Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if that directory is removed or made to be an empty "read-only" directory, you might be able to "enforce" gnucash to have a memory loss... rm ~/.gnucash/books/* chmod -w ~/.gnucash/books Yes, it seems a bit drastic though! :-) It's actually /home/chris/.local/share/gnucash/books (or, strictly, some system variable specifies the directory I believe). Probably depends on the version. I'm still using 2.6.19-1 on my Ubuntu 18.04 system. Even opening GnuCash from a menu or icon (rather than the command line) I'd really prefer that it didn't default to the last set of accounts opened. Yeah, that is unfortunate. And really unfriendly. I happen to really like that it opens the last set of books. Yes, I have three (3) separate sets of books with each in a different folder (directory). And having the list of recent opened files makes it really handy to switch between the three sets as desired. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fails under newest Ubuntu
Just upgraded to Ubuntu 22.04. Gnucash will not load: gnucash: error while loading shared libraries: libicuuc.so.67: cannot open shared object file: No such file or directory I will have to track down what happened with that library. May have to compile again. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fails under newest Ubuntu
Thanks. I saw last night that it was v70. Will compile this afternoon (other higher priority items on my list so far today). --Steve On 4/29/22 03:39, Frank H. Ellenberger wrote: Hi Steve, if this is your self-build GnuCash, you will have to rebuilt it after updating your -devel packages. According https://repology.org/project/icu/versions Ubuntu updated to 70.1 while older versions used 67.1. Regards Frank Am 28.04.22 um 23:06 schrieb Stephen M. Butler: Just upgraded to Ubuntu 22.04. Gnucash will not load: gnucash: error while loading shared libraries: libicuuc.so.67: cannot open shared object file: No such file or directory I will have to track down what happened with that library. May have to compile again. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fails under newest Ubuntu
On 4/30/22 15:40, David H wrote: Steve FYI, Re-compiled and working now although I did have to add the following to my build script.. sudo git config --global --add safe.directory $SOURCEDIR Cheers David H. Cmake was building files in my gnucash git clone directory. I ended up having to destroy and download a whole new clone. That seems to have fixed whatever strange problem cmake was having. Make is currently compiling and I hope that finishes here in the next few minutes. I'll have to pull up the git docs and figure out what your command line does and why it might be needed. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Training the classifier of imported transactions in GnuCash
On 6/15/20 12:30 PM, Cliff Kushler wrote: > Hi Gio, > > Thanks for your quick response! > > Yes, I have been importing transactions for many years. However, it seems > that Gnucash is not getting any better - I have to correct transactions from > the same source over and over again, month after month. There is a window > that appears during the import process (before the transactions are posted in > the actual account registers) that shows all of the transactions to be > imported, with check boxes labelled “A” (accept? not sure…), “U+R” (update & > reconcile?) and “R” (reconcile). However, I do not know of any way to > correct the classification of a transaction while it is still in this window > (which seems like the opportunity to train the classifier). I end up > correcting the transactions after they have posted in the account registers, > and GnuCash does not seem to be learning from this. > > If you (or anyone) knows what I should be doing, please let me know - thanks! In that window, double click on a line that needs an update on the "classification". A window should pop-up that will allow you to select the account to which that line should be assigned. Doing this will "teach" the import how to make the assignments going forward. It might take a few iterations for it to "learn". --Steve > > Cliff > > On Jun 15, 2020, at 3:25 AM, Gio Bacareza wrote: > > Hi Cliff, > > I also want to first say thanks to all the developers. I am a user and a fan. > 2nd, awesome to meet you Cliff. I love your products too. > > I was also looking into an automated way of classifying transactions. I did a > quick automl using google and have achieved 90%+ accuracy. > > However, I wasn't able to use it because I think gnucash does its own and > requires you to classify them upon import. After a few imports it also > "learns." So subsequent imports will have these transfer accounts > autopopulated. > > I hope it helps. > > gio > > > > On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler <mailto:ckush...@gmail.com>> wrote: > Hello - > > I am a long-time user and fan of GnuCash, and start by offering my gratitude > to everyone who has contributed to it. For what it’s worth, I am also a > co-inventor of T9 and Swype, so perhaps I have contributed something to make > your life easier too. > > My question is whether there is a tool, technique or strategy to improve the > accuracy with which GnuCash assigns imported transactions to destination > accounts. I import large quantities of credit card transactions, and while > many of them are assigned to the correct accounts, a very large number of > repeat transactions (i.e. from the same vendor) are either repeatedly > assigned to the same wrong category or simply left as “Imbalance-USD”. I > have not been able to identify a way to correct them while they are still > displayed in the initial import window, although I suspect that would be the > time to correct them. I go through and manually correct them in the register > after importing them, but this does not seem to help future classification > accuracy. > > Any help would be much appreciated! I probably should have asked this years > ago… > > Joy & Blessings, > > Cliff Kushler > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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. > > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Prevent register from auto-duplicating transactions?
Use a slightly different description. (store name + 4) for the 4 line split and (store name + 1) for the single line split. On 7/12/20 12:27 PM, Stan Brown wrote: > Example: In a trip to the supermarket I buy food, wine, flowers, and > cleaning supplies. To record that, I enter a transaction in GC, in the > register for my credit card: > Description = (store name) > Click the Split button. > In each of four splits, Memo = details of what I bought, Account = > (account for that type of expense), Debit = (amount) > In the fifth split, Memo = blank, Account = (credit card), credit = (total) > All of that is fine. (I don't divide that purchase into four > transactions, because I want the credit amount to match what will be > shown on my credit-card statement.) > > But here's the problem. On the next trip to that store, I buy only food. > What I want to do, in the account register for my credit card, is enter > Description = (store name), Transfer = "Groceries", Credit = (amount). > But as soon as I enter the store name in description, GC creates five > splits that duplicate that previous shopping trip. I have to click Split > and manually delete three splits, one at a time. > > Is there some way to tell GC "don't finish this one transaction for me"? > > Or, almost as good, when it does do the auto-complete, is there some way > to tell it "not this time, thank you", and have it delete all of what it > helpfully created for me?? > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Importing Transactions from Bank
On 7/20/20 2:43 PM, Jon Griffith wrote: > Is Gnucash smart enough to recognize transactions that have already been > imported, or do we have to keep tight tabs on the import date range? > OFX keeps track. CSV usually does but sometimes suppresses one that should be loaded. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/26/20 9:25 AM, Michael or Penny Novack wrote: > On 7/26/2020 11:39 AM, John Ralls wrote: > >> Did nobody read the footnote? The book was published in 1985, long >> before electronic payments became widely available. No doubt the 2020 >> edition would say something like "independently documented transfer" >> with a mention somewhere that that used to mean a check but now >> covers a variety of payment methods. >> >> Incidentally, the textbook also says that checks should ideally >> require two signatures. I don't know how to impose that control over >> electronic transfers but the local newspaper reports two or three >> cases of embezzlement a year where it's obvious that a two-person >> control would have prevented the crime. >> > Even today, just because you CAN use "electronic checks" doesn't mean > you would want to. That's going to depend on the average number of > checks per payee since a bank transfer requires knowing/storing the > bank routing number and account of each. To use the organization where > I have FINALLY been relieved as treasurer, perhaps 50+ different > payees but rarely more than two checks to the same payee in a year. > SOME payees, like for governmental filing fees provide a site, might > even require electronic payment. But only a couple of those payments n > a year. Hmm. Better migrate to a credit union then. Mine will send checks to an address and they will even put the stamp on the envelope. There is an option to send to a phone number or email address. > So if an orchard manager sent in a envelope of receipts for > reimbursement, that would have a return address to mail a paper check > to. It's only the less well off that would be sending me receipts like > that, a few at a time. The ones well off might just save up a bunch > and hand them to me at the next board meeting and I write them a check > then and there. > > Best solutions depend on the work flow. The work required to obtain > the bank information for a direct transfer is more than the work of > writing/mailing a check. More than doing it twice. But if you are > going to be doing it ten times (to the same payee) getting the bank > info might be quicker. > > Michael D Novack > > > ___ > 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. > . -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/26/20 2:40 PM, Michael or Penny Novack wrote: > >> Hmm. Better migrate to a credit union then. Mine will send checks to >> an address and they will even put the stamp on the envelope. There is >> an option to send to a phone number or email address. > > > Lovely. If you directed a check to my phone number it's inaccessible. > Do you KNOW that phone number is to a "smart-phone"or similar device, > not a "flip phone", or in my case a "land line" << you can't call HERE > to a cell phone, no cell service -- I do know several spots within a > mile where from some spot on a hilltop can get a connection to call > out >> In other words, more information for you to store. > > Email address -- yes that works if the recipient has an adequate > printer and their bank will accept such checks << yes they are legal, > but my bank has great difficulty scanning them in. Just had to go > through that nonsense. >> > > Having the bank mail a check? When I mail a check, there is always > going to be supporting documentation in the envelope along with it. > Are you receiving checks with no indication what for? What do you do > then? > > > Michael D Novack > Doesn't matter. All POP or Zelle needs is that at some point you responded and directed them to send the funds to your account. I don't know most of the routing numbers/accounts of folks to whom electronic funds are sent. But the recipient at some point tied their phone number (land line, cell phone, satellite) to their account. At that point they don't need to respond any further. Though they may get a notice that the transaction happened. Now, if I don't have that but I do know your address, well, as I said, my CU will slap a stamp on the envelope and mail that check out to them at no cost to me. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/27/20 2:07 AM, Liz Dodd wrote: > On Sun, 26 Jul 2020 17:40:19 -0400 > Michael or Penny Novack wrote: > >> Having the bank mail a check? When I mail a check, there is always >> going to be supporting documentation in the envelope along with it. >> Are you receiving checks with no indication what for? What do you do >> then? >> > There's about 250 characters for that data available on Osko, the > Aussie system. > You mention real problems, but they are already solved in some places. > > https://osko.com.au/faqs > > Liz I am able to send along an account ID or Invoice ID and then there is the entire memo field on the check. I also get an email from the CU (if I request) stating that it has been sent. I can forward that to the recipient with additional notes. Not convenient, but driving an hour to hand over coin is also very inconvenient. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Can you move a Liability Account to a "sub-account" in Liabilities?
On 7/30/20 6:41 AM, Fran_3 via gnucash-user wrote: > 3 items listed under Liabilities... > Liability ALiability BLiability Ceach to a different entity but related based > on certain criteria. > We want to setup another Liability account "Liabilities ABC" and then move > the 3 above under it as "sub-accounts" like ... > Liabilities- Liabilities ABC-- Liability A-- Liability B-- Liability C > That way we can see the total of the 3 or each individual total... > The Question: Is there any way to do this without having to delete A, B, C, > and re-creating them under Liabilities ABC ? > Thanks for any help. > Easy. 1. Create the new Liability ABC using Liabilities as its parent. 2. Edit the other three to change their parent from Liability to Liability ABC. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] non-currency liabilities
On 8/2/20 8:35 AM, dann frazier wrote: > Thanks David - yeah, negative share balances are possible. But it's > seemingly not possible to track shares in a Liability account. You can always treat Liabilities as a negative Asset. > > On Sun, Aug 2, 2020 at 2:41 AM David Carlson > wrote: >> I meant no requirement to have a positive share balance. You should be able >> to have a negative share balance in a security account. >> >> On Sun, Aug 2, 2020 at 3:37 AM David Carlson >> wrote: >>> I believe there is no restriction to have a positive number of shares of a >>> security. After all, it is common to sell stock short (Against the box) or >>> not. >>> >>> David Carlson >>> >>> On Sun, Aug 2, 2020 at 2:48 AM dann frazier wrote: >>>> Hi, >>>> >>>> I'm trying to figure out the right way to represent a non-currency >>>> debt in gnucash. That is, I'd like to be able to record that I *owe* >>>> 20 shares of FooFund. I thought I'd just create a Mutual Fund >>>> Liability account, but apparently Mutual Funds and Liabilities are >>>> mutually exclusive. Is that restriction by design? >>>> >>>> One of the reasons I want to do this is for a college fund. I'd like >>>> to keep track of the fund value in an account, but also "keep it off >>>> the books" in a sense when it comes to Asset vs. Liability >>>> calculations, as I consider it both something I have and something I >>>> owe. I tried doing this by creating an Asset account and a Liability >>>> account that grow together, and cancel each other out, but I couldn't >>>> get that to work since it won't let me make the Liability a security. >>>> Is there a better way to do this? >>>> >>>> -dann >>>> ___ -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Negative numbers
You may also enter an enhancement request in bugzilla. On 9/9/20 1:05 PM, Adrien Monteleone wrote: > Not that I'm aware of, but just tab or shift-tab to the other column. > A negative credit is a positive debit and vice versa. If you try > entering a negative, you'll see GnuCash moves it to the other column > as a positive anyway. > > Regards, > Adrien > > On 9/9/20 12:31 PM, ToddAndMargo via gnucash-user wrote: >> Fedora 32 >> gnucash-4.1-1.fc32.x86_64 >> >> I have a number of program that accept negative numbers >> with the minus sign at the end `123.45-` or inside >> parenthesis `(123.56)`. >> >> Is there a way to tell GnuCash to do this also? I >> keep entering it the other way and having to go back >> and put the minus sign in the front. > > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 file import question
Note that both columns could be tagged as "Deposit" as is the case with Citi CC. The column containing charges to the card are Positive but the payments column is negative. <>. I presume that someone has a case where both should be tagged as "Withdrawl". --Steve On 9/12/20 7:21 AM, Geert Janssens wrote: > Greg, > > The terms "Deposit" and "Withdrawal" in the csv importer can be a bit > confusing unfortunately. > The terms map well for bank statements using two columns to display amounts, > where both > columns list positive numbers. It maps less well for credit card statements > (interpretation would > be inversed) or two-column representations were the withdrawal column lists > negative numbers. > > As a sidenote, a more general labeling could have been "Amount (unchanged)" > and "Amount > (sign reversed)", because that's what the labeling actually makes gnucash do > internally. > However that also requires user interpretation of the data and understanding > of how gnucash > works internally. > > For your bank statements, if your amounts are all in one column the deposits > are presumably > positive numbers and withdrawals presumably negative numbers. In that case > label this single > column "Deposit". > > If you have separate columns for your deposits and withdrawals, the labels to > use depend on > the signs of the numbers in your csv. > > If the deposit column has positive numbers, label the column as "Deposit". If > the deposit column > has negative numbers, label the column as "Withdrawal". > > For the withdrawal column it's exactly the opposite. > > If the withdrawal column has positive numbers, label the column as > "Withdrawal". If the > withdrawal column has negative numbers, label the column as "Deposit". > > Regards, > > Geert > > Op dinsdag 8 september 2020 05:08:05 CEST schreef David Carlson: >> Greg, >> Usually, when your bank or credit card company creates a CSV file for you, >> either deposits are positive and withdrawals are negative, or vice versa. >> Whichever you see, you then call the amounts deposits or withdrawals when >> performing the import, and GnuCash assigns the value to the Debit or credit >> column as appropriate. >> The key is to correctly tag the value column as deposit or withdrawal when >> importing the file. >> >> >> >> On Mon, Sep 7, 2020 at 8:23 PM Greg Carroll >> >> wrote: >>> Hello, >>> >>> I'm new to Gnucash. I have it set up as a checkbook. I imported a csv >>> file, >>> but it put all of the amounts of the deposits and withdrawals only in the >>> deposit column. I can't figure out how get it to recognize deposit amounts >>> separately from withdrawal amounts. I even made separate csv files >>> containing only deposits and one for only withdrawals and upon importing >>> it, gnucash still puts all of the amounts in the deposits column. >>> >>> -- >>> Regards, >>> >>> Greg >>> ___ >>> 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Reconcile strangeness
Oops. I sent from one of my other email accounts! Sorry. --Steve On 9/22/20 8:10 PM, Steve wrote: > Today I noticed an anomaly while reconciling an asset account. > > I am still on 3.8b on Linux (Ubuntu 20.04). I suspect this is one I > compiled myself -- but it has been awhile. > > I haven't had time to compile and check the latest. > > Reconciling an asset account (that was a placeholder with 4 sub-accounts > -- Asset:Bank:MutualFund). I did click to include the sub-accounts > (General, Emergency, Sinking). > > One transaction was to move funds from one sub-account to another > sub-account of the placeholder (General --> Emergency). > > So, this transaction showed up on the Debit and Credit lists. I was > unable to get both sides to have a check-mark. Clicking on the credit > side would remove the check-mark from the debit side. And vice versus. > > Ended up postponing the reconcile, then editing the transaction to > remove the cleared flag from whichever side it had remained. Since this > transaction is balanced (!!) I was able to finish the reconcile to the > bank's value. > > Is this a known bug? Can somebody experiment with the latest release to > see if still present? > > --Steve > > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Loan to family member: How do i setup the account structure
I presume that you currently "expense" the loans. They really are not an "expense" but a change of asset (from your savings account to a receivable. 1. Add a new Asset account called "FaF Loans" (Friends and Family Loans). Mark it as a placeholder. 2. Under FaF add a new account for each person to home a loan is made. For your use case enter the following transactions: A. Transfer £2000 from Savings1 to Checking. B. Transfer £2000 from Checking to FaF:Family1 Note: If both happen at the same time, you could combine them into a multi-split transaction with Checking having two offsetting splits. C. £100 from Faf:Family1 to Checking D. £100 from Checking to Savings2 Note: Doubtful that the above two transactions happen at the same time so shouldn't combine. By looking at the transactions for each of the sub-accounts in FaF you would see the original loan amount plus all the payments. The account balance would be the outstanding balance. Now, if you should charge interest, the interest portion would be income. I presume that you already earn interest on other accounts so would already have that account setup in the Income area of CoA. The payment would then be split with FaF:FamilyX and Interest-Income on one side and Checking as the destination. On 9/23/20 4:27 AM, John Mansfield wrote: > I have lent monies to a family member and now wish to track the balances on > an ongoing basis. I have been looking at the guides etc but just cannot > understand the concept / account hierarchy given my circumstances. > > The software I am using is: > > * Version: Version: 4.1, Build ID: 4.1+(2020-07-25) > * Windows 10 > > My location/currency is: > > * GBP, UK Based > > My Gnu Cash account setup is: > > * I have a cheque account > * I have a savings account 1 > * I have a savings account 2 > * Plus others. > > My use case is: > > * It will be an interest free loan > * My family member has borrowed £2000 > * Loan taken from Savings account 1 into > * Cheque Account then electronically bank transfer > * To family member bank account. > * A repayment is made each month > * The family member transfers a set amount, say £100. This is > electronically deposited into my bank Cheque account > * To date, I have electronically bank transferred monies into Savings > Account 2 and updated gnu cash > * I have no immediate report of monies repaid / outstanding. > > My preferred outcome: > > > 1. To track the Principal amount of £2000 > * To track each payment into my Cheque Account from family member - > normally monthly (once bank transactions have been uploaded into gnu cash) > * To understand how much has been paid - to date > * To understand how much is outstanding > * To transfer each repayment into Gnu cash Savings account 2 and bank > account > * To be able to get reports on the above. > > > Given the above, I would be most grateful if you can advise what account > hierarchy / transaction splits etc I need in Gnu cash to support the above? > > I thank you for your time and support. > > Regards > > John Mansfield -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Checking account withdrawals for cash boxes
Yes, that would be a Cash Box asset account. If you wanted to track each box individually then make a sub-account for each under Cash Box. On 9/29/20 1:16 PM, Roderick A. Anderson wrote: > Good day to all. > > I have a question that may require me contacting an accountant but > this is my first pass. > > First I am the Treasurer for a small US 501c3. Never been an > accountant nor played one on TV. ;-) > > We have an annual fund raiser. I withdraw cash from the > checking/General account for the cash boxes. In the past (and what I > inherited) was to make it an expense entry. Just doesn't seem right > since we still have the money. > > Should I create another Asset account and record it there? > > > TIA, > Rod > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] clip board paste across catagories
On 9/29/20 1:20 PM, ToddAndMargo via gnucash-user wrote: > >>> On Sep 27, 2020, at 12:23 AM, ToddAndMargo via gnucash-user >>> wrote: > >>> Any special character I can throw at it to get it to paste across >>> fields? I can insert anything I want into the string >>> >> > > On 2020-09-29 08:55, John Ralls wrote: >> No. Aside from the special transaction copy-paste that Liz mentioned >> copy-paste is one field at a time. You'll note that you're able to >> select only one field at a time: GnuCash isn't a spreadsheet. >> >> What's the source of the clipboard item? >> >> Regards, >> John Ralls > > > I am the source of the data. I have written a program > that reads new purchase orders from my inventory > database and formats it into an eMail format that my > vendors have started requiring. > > My goal was to take my data and create a format that I > could paste into GnuCash. I frequently forget to enter > orders into GnuCash and THAT make for an INTERESTING > reconciliation with my bank statement. > > Since I am the programmer, I can insert anything in the > clipboard I want, including weird characters. Since you are the developer then you can write a CSV file and have that imported into GnC. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Split Transactions
On 9/30/20 6:53 PM, normanj wrote: > I've been using Gnucash for a few years, but I'm far from being an expert > user. > > One of my accounts is for a savings account which pays a monthly interest > and, subject to some conditions, a "bonus" interest payment. The bank used > to report these as a single monthly payment so entering these into Gnucash > was a straightforward transaction - a assets account for the balance and an > income account for the interest. > > The bank has started reporting the base and bonus interest payments > separately, and my first thought was to use a split transaction - two > payments for the interest and two corresponding entries into the asset > account. However, when I save the transaction it is shown as two split > transactions, each showing the same 4 numbers for both the regular and > "bonus" interest, though the asset account balance is correct. Any change I > make to one transaction, including deletion, is immediately reflected in the > other transaction. I routinely have transactions with multiple splits going to the same account. I only see the one transaction with multiple splits. Therefore, I think it must be an artifact of the type of register view you have. I am using the expanded view that shows all splits in the transaction. I suspect you are using a view that shows only the splits that apply to the account you are viewing. > > To my inexpert eye this seems quite odd. The only way I can see to fix this > is to delete the impacted transactions and re-enter the "ordinary" and > "bonus" payments separately, though as they are directly linked there is an > obvious benefit in having everything in one transaction. > > Can anyone kindly advise if this is normal behaviour and is there a better > way to do this? If it makes a difference I use a mac and upgraded to > Gnucash 3.6 earlier in year (as it happens, about the same time the bank > chnged its reporting format) > > Thank you. Despite this hiccup, I've found Gnucash to be an excellent tool. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Split Transactions
I find it easiest to adjust the preferences (Edit:Preferences:Register Defaults:Default Style) so that Register Style is my default. That means I see all the splits all the time. [Some may not like this.] --Steve On 11/15/20 12:46 PM, David Carlson wrote: Please include gnucash-user@gnucash.org in your reply by using reply all. GnuCash is a very high quality product and once you overcome this hurdle you will find it to work quite well. If you read the sections of manual described in other responses to your original email then follow Derek 's suggestions you should have excellent results. On Sun, Nov 15, 2020, 11:47 AM Nathan Rosenthal wrote: This did not seem to work. I can enter the split accounts and amounts OK but cannot save the entry (Save is greyed out). If I hit the key after entering the last account, the entire transaction disappears. I have worked around this bug by entering three separate transactions totaling the amount of the check. The balance is correct and the expenses are also correct. However when I run an Income and Expense report, the amounts I entered do not show or show in the wrong place. Very disappointed. I know this is a free program but now there are these problems. I don't believe the Windows updates caused them but it is possible. Nathan On 11/14/2020 8:37 PM, David Carlson wrote: Nathan, The first time it can be a little tricky. First select one of the transaction view options that will show the splits, then practice using the tab key to move the curser from box to box. For practice you can enter garbage text because it is easy to delete your practice mistakes. On Sat, Nov 14, 2020 at 7:20 PM Nathan Rosenthal wrote: I am almost sure someone has figured out how to enter what I call a split transaction - writing one check to cover multiple expense accounts. I cannot seem to get this to work properly. ___ 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. -- David Carlson ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] List Replies
On 11/18/20 1:38 AM, Geert Janssens wrote: Op dinsdag 17 november 2020 19:26:58 CET schreef Adrien Monteleone: Yeah, perhaps I'm not understanding something, but if the list server is configured with the list address in the reply-to header, but *does not* hide the individual's personal address (as described by Greg) how hard is it for someone to copy and paste that address in a new compose window in the 'to' field? And to make it even easier, most mail apps have a feature that if you select *any* e-mail address, you can get a context menu to send a new message to that address! So the default behavior would be reply-to-list, and if the *OFF* chance you *might* want to privately reply, you can still do so. (note, private replies to this list are discouraged, so why make it the default?!) You make a very good point here. I agree the list configuration should reflect our default behaviour. And given all mail clients I have seen make it easy to send a mail or reply to any visible header e-mail address (To, CC, From,...), the uncommon case of a private request is still readily available, but it does take explicit action. Making the desired behaviour default is actually good user experience. For the record these are the mail clients I have looked at: - Kmail: provides direct reply to or new message to any visible address. - Thunderbird: provides new message to any visible address - GMail: provides new message to any visible address, though it does take an extra click - K9-Mail (mobile): provides direct sending new mail to "from" address rather than reply-to address. Other visible addresses can't be targeted directly. I'm extrapolating from this that any decent mail client has effectively a way to directly send a message to the address that appears in the from field instead of using the hidden reply-to. So to me the original argument that it would be much harder to send a private reply doesn't hold. In fact as one on the other side of regularly receiving unwarranted private replies on my list posts, I actually prefer to make that process a bit harder (while still not difficult at all). Regards, Geert _ I use Thunderbird as a mail client. For messages from this list it offers me two buttons. Reply and ReplyList. Reply will send the message to the originator (From). ReplyList will send it to the ReplyTo entry. The ReplyList does have a drop down with three options (Reply, ReplyList, ReplyAll). Sometimes I've clicked on the Reply instead of ReplyList. Occasionally I catch that before hitting the Send button. --Steve PS. "If you idiot-proof the software, only idiots will be able to use it" -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to Manually Match transactions
On 11/19/20 10:29 AM, Griff wrote: Here is a very simple question but I can't figure out how to do this. I have searched the documentation and this mailing list. How do I manually match 2 transactions: I have 2 account that have had data imported via qfx. Account 1 (credit card) has a transaction on 2020-01-19 that is a payment for $amount which is the credit card payment from checking account Account 2 (bank account) has a transaction on 2020-01-21 that is a withdrawal for $amount which is the checking account payment to the credit card. The Transfer for the transactions in each account are currently set to Imbalance-USD. When I change the Account 1 transaction Transfer field to Account 2 - a new transaction is created in Account 2 instead of matching to the existing one. _ Manually -- you pick one of those dates and enter a single transaction. I usually have the bank payment entered in by hand and then do an OFX import of the CC file. The match happens automatically during the import. You can't do the match afterwards without manually removing one of them and adjusting the other. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166. --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to Manually Match transactions
On 11/19/20 1:18 PM, Griff wrote: Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. To your suggestion of importing it all at once, that is not possible as one QFX file is from the credit card company download and the other QFX is from the different bank company's download. They will be two files. This is unfortunate as the matcher is only run on QIF import and not OFX/QFX import. I use the OFX import all the time and get matching. Sometimes I have to force it to look for a match (check the R column). And sometimes, it matches too good and thinks it finds a duplicate (a charge that occurs every 2 weeks) so I have to force it to bring it in by checking the import column. Should I be getting the data from the banks in QIF instead, does that work better then OFX/QFX for GnuCash import? Should be just the same. <> -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Wrong starting balance
On 11/20/20 4:49 PM, Liz wrote: On Fri, 20 Nov 2020 16:41:22 -0800 Jim DeLaHunt wrote: Hello, Liz: Are any of the transactions in that account reconciled? Do you have a "starting balance" transaction in that account, perhaps created when you created the account? The reconciliation model for GnuCash assumes that you start by reconciling the earliest transactions, and move forward sequentially in time, reconciling bit by bit. When you start a reconciliation, GnuCash adds up all the reconciled transactions for that account, regardless of date, and that becomes your starting balance. Does this help? Best regards, —Jim DeLaHunt No Jim I know perfectly well how reconcile works. I have not reconciled this account ever. NO transactions are reconciled The starting balance is $1.87 I am mystified about $6,300, so I did a find for that value on the entire account tree and found nothing of that value. Liz _ Try to reconcile another account that has never been reconciled. If that comes up with a non-zero number then create a new account and attempt to reconcile with no entries. If that comes up with a non-zero amount then you have found a bug. What I'm wondering is if there are no entries to add up the module might not be handling the results correctly. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Wrong starting balance
On 11/20/20 6:23 PM, Liz wrote: On Fri, 20 Nov 2020 17:58:38 -0800 "Stephen M. Butler" wrote: Try to reconcile another account that has never been reconciled. If that comes up with a non-zero number then create a new account and attempt to reconcile with no entries. If that comes up with a non-zero amount then you have found a bug. What I'm wondering is if there are no entries to add up the module might not be handling the results correctly. I tested that possibility, and it was negative. Fortunately I found where the problem was, and it is related to the user. I did not expect when I moved transactions from the bank account to a holding account that the reconcile flag for the bank account would remain. It may be a bug. Liz At least the bug I was envisioning isn't there! Yes, I would call that behavior a bug. More urgent than an enhancement request. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Help with Column that Vanished
On 11/30/20 5:24 PM, David Carlson wrote: I suspect that the developers might have a hard time deciding how to select which other columns to use to fill the space that would be freed up if the description column did not fill the remaining space. However, another alternative would be to restore default column widths. This should make every column visible as they appear the first time that the account window is opened on a new computer. It may not be exactly what the user wants, but it would definitely give a good starting point. There are several alternatives that have served well with other software: 1. Don't fill the space. Let it be unused (whatever the default background color). 2. The right hand column expands/shrinks as needed (not ideal in my thinking). 3. ... I have also seen other software implement a minimum column size so you can't "lose" a column. With that they have a drop down list on the far right that allows you to activate/deactivate columns. Perhaps someone wants to enter an enhancement request. On Mon, Nov 30, 2020 at 3:51 PM Rob Britton | AirLearn < rob.brit...@airlearn.net> wrote: Geoff, Many thanks. The 200% display trick did it -- a couple of tries to get the Withdrawal column to appear, and there it was, hooray. I'll make a contribution, for sure. And sure would be great if, as other users have noted, the Description column could be reduced and not auto-adjust to fill the space. Thank you again for your responsiveness. -Original Message- From: Geoff Sent: Monday, November 30, 2020 05:19 To: gnucash-u...@lists.gnucash.org; Rob Britton | AirLearn < rob.brit...@airlearn.net> Cc: adrien.montele...@lusfiber.net Subject: Re: [GNC] Help with Column that Vanished Hi Rob You are not the only one to "lose" a column. If Adrian's instructions below don't work, have a look at this thread: http://gnucash.1415818.n4.nabble.com/GNC-Register-columns-The-balance-column-is-no-longer-visible-tc4721699.html Which includes screenshots for Windows 10. Good luck! Geoff = On 30/11/2020 8:20 pm, Adrien Monteleone wrote: First, the Description column is *not* fixed. (more to follow) Second, when sizing columns, you can only adjust using the right-side header divider. So hover near the right side of where the Withdrawal column should be, click and drag to the right.(you should see either two lines very close to each other, or a single thicker line, which would indicate the collapsed column) Finally, when all other columns are resized to your liking, click and drag the right-hand divider for the Description column far to the left. It will snap back and fill the remainder of the window width. (leaving your other columns sized how you want them) If you want to revert a column to its default size, double-click its header. Regards, Adrien On 11/29/20 4:01 PM, Rob Britton | AirLearn wrote: GnuCash is great, but resizing column widths is head-hurting. Okay, I'm 69 and not a youngster, so I make mistakes. And I understand that the description column width is fixed (that ought to be changed in the next update). So here's my problem: when trying to resize checking account columns just now I accidentally shrunk the withdrawal column and it "disappeared." How do I get it back? -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fwd: Re: Possible Suggestion: Give transactions a default 'Jump to' target account
On 12/8/20 8:36 AM, Stan Brown wrote: Apologies -- I clicked "reply" instead of "reply List". Since you asked for opinions -- Speaking for myself only, I just click Split in the top row of icons, then click on the account I want in the expanded transaction and Jump. I don't think the pop-up would help me in my workflow. I always have the splits showing so this wouldn't help me at all either. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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 to use Reminders?
ly? It's not like the bill is going to change over time, or be ammended. So in the immortal words of "Doctor, it hurts when I do this"... "Don't Do That." Post your bill when you enter it. That's what the reminders are for, to pay the bill that you entered AND POSTED. Problem with missing your boss's birthday is you forgot what date it was. This is not a GnuCash problem; use your calendar for that. There are many options, like Orange and Evolution, which will do a MUCH better job. So, how do you create a general purpose Reminders for various things in GnuCash like..- Post Electric Bill Today (this reminds you to go find the bill online or in the mail or wherever & post it) - Boss's birthday is on April 1st- Valentines Day coming up on February 14th- Leave check under door mat for yard guy None of these reminders belong in GnuCash. I see the calendar view via clicking... Actions > Schedule > Edit Scheduled Transactions And the tabs & fields when I click "New" And most of the fields are obvious except under Template Transaction... I'm clueless about what I'm looking at...Is tat a template for...- a new bill to be posted- a reminder to pay a bill- or what? The Template Transaction is the transaction you have scheduled. The template will be executed and posted into your accounts when the SX fires. The template can be anything (well, any transaction -- you cannot schedule a Business feature object like Invoice or Bill). I, personally, use them to schedule Loan (and Mortgage) payments, because it can approximate interest calculations. And, what about a reminder that is not a financial transaction? Questions: 1 - Is there a way to create General Purpose Reminders in GnuCash? No. 2 - Where can I find instructions on how to navigate to General Purpose Reminders? Read up on Evolution (the program, not the Theory of). 3 - Is there a document that explains the use of the various fields in either... a. the General Purpose Reminder or in b. Scheduled Transactions Reminders? There should be documentation the SX Editor, yes. Check the Help file. Oh, one more thing -- keep in mind that you can post-date a transaction. For example, I tell my bank to go pay my credit card $1234 on the 17th. Even though today is the 9th, I can enter a transaction dated the 17th from Bank -> CC for $1234, so GnuCash records that I set the bank billpay up to do that for me. Hope this helps, You can even have GnC pre-post the scheduled transactions for you. I have most of mine set to 15 days. Sometimes I wish I'd set them to 30 days. Thanks for any help. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek Yes, I am a certified Project Management Professional. You need someone to help organize yourself. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Fwd: Smaller backup files: Time division, Since or Incremental?
t save times, as really old data is off screen in most accounts. > - The algorithm could even take into account keeping deeper time images of low churn accounts so the first page could be populated and the rest installed in the background. > > > -Original Message- > From: Geoff <mailto:cleanoutmys...@gmail.com>> > To: David G. Pickett <mailto:davidgpick...@comcast.net>>; gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Sent: Mon, Dec 21, 2020 4:30 am > Subject: Re: [GNC] Fwd: Smaller backup files: Time division, Since or Incremental? > > Have you considered only backing up the log files then? They are your > incrementals... > > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html <https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html> > > Geoff > = > > On 21/12/2020 1:28 pm, David G. Pickett wrote: >> >> >> >> Forwarded Message >> Subject: Smaller backup files: Time division, Since or Incremental? >> Date: Sat, 19 Dec 2020 14:40:54 -0500 >> From: David G. Pickett <mailto:davidgpick...@comcast.net>> >> To: gnucash-de...@gnucash.org <mailto:gnucash-de...@gnucash.org> >> >> >> >> One thing that complicates my gnucash life is the size and number of >> backup files. >> >> * It'd be nice, since most of the data is very historical, if it the >> data was divided by time into multiple files, more finely in rear >> time. Even if old files occasionally get updated by new work, they >> would mostly be static. >> * Another traditional way to keep backup sizes down is the Since-the >> last-full and the Incremental since the last incremental. >> * Since files are in xml, if they are line divided by transaction or >> entry, text tools like good old sccs can discern differences. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] GnuCash 4.4 Announcement/GnuCash 4.3 Announcement
I also just reconfigured my internal wireless network to use a mesh system. Suffice to say, your email reached me anyway. So, I guess the changes on both ends worked. On 12/30/20 1:39 PM, John Ralls wrote: Following up, Derek reconfigured his network so that code.gnucash.org supports IPv6. This is a first test to see if that changes the way my mail gets routed. If it goes through I'll try resending the 4.4 announcement with the copies. Regards, John Ralls On Dec 30, 2020, at 8:41 AM, John Ralls wrote: On Dec 30, 2020, at 6:24 AM, D. via gnucash-user wrote: Thanks, but the point is that the Gnucash project's standard practice-- that is, to post release announcements on the user and devel lists-- did not occur in this instance. @Frank: I didn't notice that your link was to a message in gnucash-announce. I don't know what the information flow typically is, but would assume that there is some script that repackages the announcement message and sends it along to the other lists as appropriate. Clearly, that didn't happen with these messages. I'd hazard a guess that most users only subscribe to the users list, and won't know about the new release otherwise. David, Nothing that fancy. I write the release notes for the website using the git log and a previous release notes, copy & paste it from a browser window into a blank email, address the email to gnucash-announce cc gnucash-devel and gnucash-user with reply to gnucash-user, and send it. That usually works fine, but this time it went into the bit-bucket somewhere between my ISP's smtp server (which my logs show acknowledging receiving it) and Derek's. No bounce or error messages, just poof. Same with 3 resends on the 4.3 announcement and one on the 4.4, so I sent the referral email to gnucash-user that begins this thread. On a whim I tried resending without the cc's and that went through, though only users who're subscribed to gnucash-announce will have gotten them. That's what Frank linked to. Regards, John Ralls ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Linux build
On 12/31/20 12:05 PM, Jimmy R via gnucash-user wrote: Or is this all that is necessary to build mkdir build-gnucash-4. # create the build directory - Note: Named to identify the source since it is not necessarily within the source directory. cd build-gnucash-4.# change into the build directory cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt ../gnucash-4. # As shown this will install in the opt directory in /home/. make # builds the program and associated libraries make install Jimmy Those are the steps I use in Ubuntu. I still need to move to 4.x myself so it has been awhile since I did that (last on 18.10). --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Thanks for interface improvement - import TXNs
On 1/6/21 12:41 PM, David Carlson wrote: Adrien, I do not currently have the time and motivation to go beyond using PPA's to keep current with my software. I am not ready to use flatpacks until that technology has matured better than what I have seen to date. For now I prefer to stay with solutions that are currently working for me. I would love to see a PPA dedicated to GnuCash that would have at least the stable releases pre-built for the various releases. For awhile I was able to build a .deb package on my box and share. However, I don't have the technical skill set to keep that up. It would be nice if someone with that skill set and time availability would join the development team and take on the maintenance of such a PPA. As a bonus, it would be nice to have the nightly builds also available. --Steve (Ubuntu 20.10) On Wed, Jan 6, 2021, 1:34 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: David, is something holding you back from Flatpak or building? Regards, Adrien On 1/6/21 9:31 AM, David Carlson wrote: Roberts, It is wonderful to hear your comment on the revised import interface. I have been procrastinating about updating to a newer release of GnuCash for a number reasons, but now I have updated to release 3.8, which I was able to find in a PPA for Ubuntu 20.04. I want to move to 4.4 but it appears that it is not yet available in a PPA form for Debian or Ubuntu Linux. For the record, exactly which release did you install in your Arch Linux machine? -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Set up
On 1/15/21 8:23 AM, Michael or Penny Novack wrote: Most people might prefer to put files they create in a "documents" directory. /In other words, you might under documents create a folder with a name like gnucash-data and use THAT as a place to store your gnucash data./ / / /If all the files you create are somewhere in the documents folder, then to back up your data you just need to every so often make a copy of THAT to external storage. Learning how to back up data is important because someday your device WILL fail./ / / /Michael D Novack / As part of a holistic backup strategy for ALL of your data. Not just GnuCash data. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Recent list in file menu
On 1/16/21 9:15 AM, Michael Hendry wrote: On 15 Jan 2021, at 03:30, David Carlson wrote: Maybe I searched for the wrong term. I would never have guessed to search for plist or mru, for example. I’ve found the relevant file here: ~/Library/Preferences/org.gnucash.Gnucash.plist but I can’t locate the Key that defines the maximum number of recently-used files for display (hereinafter called “MRU_MAX"), which defaults to 4 on my iMac Catalina running 4.4. I notice that the Keys org.gnucash.history.file0 to org.gnucash.history.file9 contain fully qualified filenames for the ten books I have opened most recently, which suggests that MRU_MAX up to 10 could be supported if the default of 4 were changed. There seems not to ba a way of adjusting MRU_MAX using GnuCash’s Preferences, so I’m stuck! Regards, Michael Check the recent archives as I remember a discussion that if the key entry doesn't exist, it defaults to 4. You have to create the entry name/value pair in order to change it. They gave the key name in that discussion. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] UK specific: MTD - Making Tax Digital
On 1/17/21 1:28 AM, Liz wrote: On Sun, 17 Jan 2021 02:52:19 -0600 (CST) "chr...@floatdene.com" wrote: As there are only about 6 users interested, it is definitely not worth the effort! While you have only counted 6 who have put up their hand so far, I think that there would be far more interested in a usable system. It doesn't include me, I live elsewhere. Liz _ I used to help out with a non-profit radio station. For every response they figured there were an additional 6-7 folks who where thinking the same thing but didn't respond. Based on marketing studies. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] UK specific: MTD - Making Tax Digital
On 1/18/21 11:22 AM, Michael or Penny Novack wrote: Good points. I have bridge software already working and approved by HMRC for use. My initial thought was to have a report in GnuCash that generated the VAT report for a period. There would then be a menu option to submit VAT. This menu option would generate a csv file containing the VAT values for submission. The bridge software is then invoked independently and submits the VAT return to HMRC. As there are only about 6 users interested, it is definitely not worth the effort! That is actually a good approach. Look at it from my point of view, living over here, 50 states potentially each requiring sales tax filed electronic (actually, not all states impose a sales tax -- but of those that do, neither the tax rates nor on what sorts of things imposed is uniform) That sort of detail is best kept out of the accounting program itself. Then users need only install whatever bridges and filing apps which would be needed for their jurisdiction(s)* Michael D Novack * plural, because a business would need to file to every state it had customers in I have customers in a number of states. But I have "presence" in only one (so far). I need file only in the states where I have "presence". And, yes, keep that out of GnuCash. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Changing multiple transactions
I have not had to do this at a large enough level to warrant the below: 1. Make a backup copy of your file (I presume you are using XML instead of a database back-end). 2. Export all the transactions from the Imbalance Account (getting the other splits also). 3. Delete the entire Imbalance Account and all associated transactions (why you needed to export the other splits). 4. Pull the export from #2 into a spreadsheet or other editing tool and make the assignments. 5. Import the multi-split edited file from #4 into GnC. 6. Do reports and other sanity checks to ensure everything is right. That's the safe and logical way. The other way is not safe and could really mess things up so you still need a backup: 1. Make that backup. 2. Un-Compress the XML file so you can humanly read the contents. 3. Figure out which fields you need to edit on which transactions (note -- I've not used an XML editor so don't know how easy this might be. I'd probably use vi or sed myself and groan inwardly.) 4. Make those edits. 5 Do the reports and other sanity checks to ensure everything is right. 6. Go back to the backup copy and try again since #5 wasn't right. Note: Loop through these steps as many times as needed until #5 looks good. --Steve PS If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes. Again, make that backup first and loop around as needed until GnC looks good. PPS Backups are mandatory. On 1/31/21 11:35 AM, Jeff Rizzo wrote: Hi- I'm currently trying to get my financial house back in order after some years, and have been pleasantly surprised with how much progress GNUCash has made since last I tried to use it (8 or 9 years ago). It seems to fit my need almost perfectly at this point, with one gaping hole - not being able to edit multiple transactions at the same time. :-( (I have read the "Register Tip" that says "There is no direct way to move a large number of transactions from one account to another in GnuCash.") As I'm trying to deal with several years' (two, at this point) worth of data, having to make three clicks to change each transaction is really a drag - and it's quickly sapping my enthusiasm for this project. Is there some workaround that some clever soul out there is using that would speed this up? To clarify, I'm trying to move large numbers of similar transactions from the "Imbalance" account to where they actually belong, so I don't see how I could easily do this by deleting an account. Thanks, +j ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Changing multiple transactions
On 1/31/21 12:26 PM, Jeff Rizzo wrote: On 1/31/21 12:05 PM, Stephen M. Butler wrote: PS If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes. Again, make that backup first and loop around as needed until GnC looks good. Yeah, since I'm using the sqlite back end I'd already thought about this but was hoping there's a better way - I'll see how this goes. Last year at the job I had at the time I had to scold the software designers every time I came across an admin function that required going to the database directly - because we all know how bad an idea it is. :) To err is human. It requires a computer to really foul things up -- especially if you ask the DBA (me in a former life) to fix a few million transactions with "this script"). PPS Backups are mandatory. Yeah, they will be, once I get enough useful data in there that I don't keep starting over from scratch. Since I sent out the original email, I've realized that it's any kind of bulk editing that will require this, and turns out, apparently I really like to change multiple things at once. I'll give it a try and see if it's worth it. Oh. Starting over from scratch? Just train the importer (you will have to do that anyway over time). Don't let them go to the imbalance account in the first place. If importing a CSV file, create an extra column that you call the transfer account (or something like that) and put your own strings in there for the different accounts. During the import GnC will ask you for the real account name for each of those strings. It will ask only once per string rather than each time it encounters that same string (as would be done if matching on something else). -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Multi-column balance sheet report
On the main GnC menu, pick Reports. Then pick Experimental. Look for the ones that have "(Multicolumn)" in their name. On 1/31/21 1:04 PM, Marcus Winston wrote: Hi all, I just found this thread on the web: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/2149519-reporting-multiple-periods Given the date on the post from Geert Janssens, I'm guessing this report or capability isn't included in my GnuCash version 3.6 (from ~1.5 years back). Is there any way I can download this thing and get it working in my GnuCash (on Linux)? I didn't find any download links on the above page. Thanks. -marcus ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Changing multiple transactions
On 2/1/21 4:45 AM, Michael or Penny Novack wrote: On 1/31/2021 5:30 PM, Stephen M. Butler wrote: To err is human. It requires a computer to really foul things up -- especially if you ask the DBA (me in a former life) to fix a few million transactions with "this script"). As somebody who did this sort of thing in my working days, I will second what Stephen just said. Leave it to the pros. It is very easy to get this sort of thing wrong << I'd be the person they'd ask "Mike, can you write something to convert the database instead of having a dozen workers sit at their terminal for a couple weeks re-entering the corrected data?" >> It wasn't the sort of thing even the average programmer in the shop could be trusted to get right. ^ Many times they tried and failed. Then it was, "hey, can you fix this?" Sometimes it could be done. Most times "Sorry, its FUBAR. Need to rollback." and "Why did you get a copy of production put into the test environment to do the final test?" Results --> dear in headlights look. Had one friend who worked for that big kite factory around Seattle. His complaint was their attitude of "Production if good". -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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.
