Chris,
The behaviour of the account selection in the transfer column in GC 4.10 on
Linux Mint is as follows:
When you first click on the split of the transaction a down arrow appears at thr
right of the column.
If you click on the down arrow, the list of transaction is displayed and its
window o
Chris,
You have created a chart of accounts which has more than a single account in it?
One other point. Do you have the View->Autosplit ledger option checked. IF you
do then the first line is the transaction summary line and it remains balnk
until you create the transaction splits. You have to mov
The other possibility if libofx supports the credit card tags would be to give
users the option of having the different card numbers recognized as subaccounts
of the main credit card account . If libofx doesn't support it it is unlikely
much can be done other than raising it as an issue with t
Chris
https://wiki.gnucash.org/wiki/Configuration_Locations
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html
https://wiki.gnucash.org/wiki/User_Configuration_Files
David Cousens
On Fri, 2022-05-06 at 18:58 +0100, Chris Green wrote:
> If one wants to copy a GnuCash 'in
Shaun,
The android GnuCash app is not a part of the GnuCash application which is a
desktop app. I don't know if it is still being supported by its original
developer but it AFAIK was a totally separate development in Java.
The QIF format is defined in the following web pages to the extent it is
Adrien,
There is a bit of recent correspondence on the github site with a possible new
project manager interested. I gather the main problem is in getting Ngewi Fet
the original developer to communicate/cooperate/hand over the reins on the
project to allow that to happen.
David Cousens
On Fri,
Bogdan,
This Investopedia page (
https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
.) might provide some insights into how to setup revaluation reserves. My
reading of this is that the Reserve account
Bogdan
That's easy. In the Accounts Tab, right click on the top level Equity account to
select it and then right click anywhere in the pane and select New Account from
the popup menu or use Actions->New Account from the mainmenu. This should start
the dialogue with Equity as the parent account, e
Richard,
Just installed GnuCash 4.10 on my wife's Windows 11 laptop with no problems at
all using the msi installer from Sourceforge following the download link from
the GnuCash website. Starts, creates a new datafile and opens a copy of my
datafile from my Linux system without any problem.
It ha
I have just setup getting finance quotes for Gnucash for the first time for GC
4.10 on Linux Mint 20.3. I was setting up a shell script to shutdown GnuCash,
update the finance quotes and restart GnuCash after the quotes had been written
to the datafile. The finance quote seems to work ok but when I
John,
I achieve this by keeping my GnuCash files in a Dropbox account accessible from
my desktop at home, my laptop while travelling and my wife's laptop. I backup
to an NAS (full once a month with daily incrementals) which is in turn backed up
to an offsite online cloud storage and a local dire
Arthur,
You appear to be in Australia or somewhere that has a similar tax system.
Short answer - you derive income from the properties you rent out - you are
conducting a business.
If you are in Australia you will be subject to capital gains tax on all the
properties apart from your main residen
Arthur,
While forums may be useful to gain some understanding of financial matters and
accounting for them, you always need to check carefully that any
advice/procedures provided on a website or forum (including anything said in
this forum) is actually applicable to your situation and in your juri
Arthur,
When replying to a question it is legitimate to copy the title of the post you
are replying to "Re: [GNC] Am I in business?" to the subject line of the reply
where the reply is a continuation of that discussion, particularly when
replying to a digest. It normally happens automatically
It will depend on your email client Arthur. I usually filter on gnucash which
picks up gnucash in the list address and seems to work fairly well. It your
email client also has a group by thread option this makes it easier to follow
conversations.
David Cousens
On Wed, 2022-05-18 at 01:18 +, a
Andrea
The mechanism for recording unrealized gains and losses is basically fairly
simple but the devil is as usual in the detail.
You need a sub account of your asset account and a corresponding account in
Equity which you could call a revaluation reserve or something similar. This
account can
Bogdan
AFAIK the import mapping data is stored in the main data file as is the price
database data. I don't know if the log files record changes to the import map
editor or only transaction changes. I suspect if you have deleted something in
the import map editor your only recourse will be to ret
nathan,
This would normally be regarded as a capital gain (or loss) on sale of the item
and whether it is or not depends on the capital gains tax rules as they apply to
this item in your jurisdiction. As such it may be subject to capital gains tax,
in which case you would need to treat it differe
Bogdan,
I have no problem deleting individual match strings in the import map editor in
GC4.10 on Linux mint 20.3. I used to do it occasionally in several of the 3.x
versons as well but I have never deleted all the strings for a given account. It
may be that action which is causing the problem
Aaron,
>From your description it sounds as though you have created sub-accounts of your
checking account to implement a budget process. If this is the case, it is the
opposite of normal accounting proceduress. To account for expenditure in a
specific category the generally accepted procedure is to
Fred,
The price database is stored in your main datafile for the set of books. You can
edit it from the Tools->Price Database in the menu.
David Cousens
On Thu, 2022-06-02 at 21:50 -0700, Fred Tydeman wrote:
> I have made a test file with just two transactions:
> Opening Balance in GBP on 3/13
Fred,
Ctrl + A Select all content in nearly all computer systems.
The multiple selection with a mouse is:
Ctrl + Left click Add the line to the selection;
Shift + Left click Select all between the current line and the line clicked on;
SHift + Up arrow Select one line up from current line;
Sh
If you import from bank 1 with the transfers to a Funds in transit account as
the transfer account rather than bank 2 and then import the records from bank 2
with the transfer account as funds in transit, the dates will be correct in each
of the bank accounts. The funds in transit account will end
Fred
Will a balance sheet report do what you want? That has the balances of all
accounts as of a specified date which can be set in the report options as well
as the account depth required.
David Cousens
On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote:
> On Sun, Jun 5, 2022 at 5:02 PM Davi
Fred
Will a balance sheet report do what you want? That has the balances of all
accounts as of a specified date which can be set in the report options as well
as the account depth required.
David Cousens
On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote:
> On Sun, Jun 5, 2022 at 5:02 PM Davi
Fred,
If you go to the Accounts tab in the main window can you see either an Orphan or
Imbalance account with a non-zero balance. The transaction creation process and
the importer have never allowed you to create a transaction in GnuCash which is
unbalanced. I just tested it and tried to force cre
The difficulty is that the sign convention in a CSV file is normally determined
by the originating bank and there is no guarantee that it is what GnuCash thinks
it should be.
Some banks will use a signed amount column to represent debits and credits,
others will provide a debit column and a credi
Bite
The transaction to record this, if a profit or increase in value of the security
is to debit the security by the amount of the profit and to credit an income
account by the same amount. For a loss in value creidt the security account and
debit the income amount. The profit or loss is the prod
Kevin,
We cannot really tell whether it is correct to remove the transactions to the
Imbalance account or not. You can really only determine that by examining the
register of the account to which you think you should perhaps change the split
to the imbalance account. Before actually changing it c
Eric,
The image you attached did not appear to contain anything. Presumably you raised
an invoice when you billed the client which would have created an entry debiting
Accounts Receivable and crediting the appropriate income account.
To record the bad debt you would create a transaction which cr
Apologies Derek,
I hadn't seen you post before putting up my own reply. I tend to go through my
emails serially. I'll remember to switch the grouping by threads on in my
client.
David
On Tue, 2022-06-21 at 19:41 -0400, Derek Atkins wrote:
> David,
>
> On Tue, June 21, 2022 7:20 pm, davidcouse
Bite,
The overall methodology is the same although the calculation of the unrealized
gain or loss is slightly different from the example - there is no external
valuation just recording a stock price. A new valuation of a painting is
essentially the same as a change in an updated stock price stock
Might be time to upgrade to the latest version. This problem now does not exist
in V4.11 on Linux (Mint 20.3) and or Windows. You can close the app either from
the menu or by using the window close icon in the top RH of the window and the
lock is removed. A system restart with the app still open is
My only experience of this in 4.11 on Linux mint was when I had the Notes field
displayed and had Notes with more than one line associated with an account.
Turning the display of the Note column off left the extra spaces unless I
collapsed and expanded the account tree.
On Sun, 2022-07-03 at 09:0
Christian,
The import data matching information is stored in the individual data file. Not
sure about import configuraion information. See the following for more info.
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html
https://www.gnucash.org/docs/v4/C/gnucash-guide/basic
David,
That was likely my bad. I rewrote the Importer documentation a couple of years
ago after Geert had completed a major rewrite of the CSV importer and importer
code in general. I was working primarily from experimentation with the program
and only a passing acquaintance with some areas of the
I think David Carlson was principally referring to the temrinology using"
category". When I rewrote the importer section last time there was a major
reorganisation of the guide and help in progress and it was suggestsed that it
was more appropriate to the Help manual as it is largely a button by
Phyllis,
The problem with the import is the negative sign on the Debit/Withdrawal column.
GnuCash expects this to be a positive quantity when the debits and credits are
in separate columns, i.e if both columns are specified then both columns are
positive. If the data is in a single column then neg
Tom,
You can make accounts hidden. Edit the account in the Account tab and select the
hidden button in the dialogue. You can always then use the right click in the
Accounts tab, select Find Account and unhide them in future. If you delete an
account you can choose another account for any splits to
David,
I had a look at both Chapter 3 in the Tutorial and GUide on Importing and Ch6 in
the Help Manual. What has happened was the decision was made to move the
importing section into the help manual a couple of years ago when I rewrote the
Ch6 in the Help manual so I created the rewritten section
Phyllis,
This message means that the last time you exited, the data file was not closed
properly which would have happened when the program or your computer crashed.
If you select the Open Anyway option and this will clear the lock file and allow
the data file to be opened.
GC 4.11 on Linux Min
Fred,
Not early in the guide, but in the section dealing with multiple currencies
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html and
discussed on the wiki (https://wiki.gnucash.org/wiki/Trading_Accounts).
I don't think anyone has yet written anything about any applic
Frank
That sounds like a good way to deal with it. I will try and put an appropriate
patch in place in the next week or two.
David
On Wed, 2022-07-27 at 10:12 +0200, Frank H. Ellenberger wrote:
> Hi David,
>
> perhaps you can do it slightly different. I agree to remove all the
> technical deta
James,
I presume you downloaded Linux Mint 20.3. Did you choose the Cinnamon desktop or
one of the pther options?
There are several options on Linux Mint to get GnuCash installed. The version
supplied by the Software Manager is 2.2.9 which is well out of date with the
current version 4.11. If yo
Thanks Adrien,
The Software Manager has an image which had 2.2.9 on it. I didn't scroll down to
the details, just assumed the image was of the installed version - my bad.
apt-cache policy gnucash
also lists it as 3.8 the same package as the Ubuntu archive.
I hadn't realized LM 21 was out. I onl
James,
Please direct replies to the list not to individual list participants. If your
email client has a Reply to List feature please us that or include the mailing
list address Gnucash Users , in the To: box. This
allows all list participants to see and learn from the posts and also to reply
to
Peter
The terms Increase and Decrease in the header only apply to the account whose
register you have open not to the accounts which are the target of the
individual split(entry) of the transaction and not to the account which is
designated in the second split. It would appear that you have the re
Peter
I do agree the Debit and Credit column headers appear to be reversed on the
Transaction Report in your original post . I have just run a Transaction report
(GC 4.11) on one of my bank accounts and it reports my income (payments into
the account) correctly as debits and expenses (payments f
Peter,Yes it is working correctly in Gnucash 4.11 on Linux Mint 20.3 and has
always worked that way in the past. The coding for the transaction reports is
in Scheme and separate from the main GnuCash code so I would not expect a change
in the preferences for the register display to affect the Tra
David
Since the Nabble interface went down I've been using the mail-archive mirrors
https://www.mail-archive.com/gnucash-user@gnucash.org/,
https://www.mail-archive.com/gnucash-devel@gnucash.org/. You can't edit or
submit a postfrom them but I find it helpful when following and replying a
dis
James
You haven't really given us much information to go on to help you. What
operating system are you using and what version of Gnucash did you install. If
you run GnuCash it will tell you the version number in the splash window at
startup or as usual Help ->About will list the information. It w
James,
>From your earlier posts you are using Linux Mint. I didn't connect with your
post in another thread before.
If you have successfully installed GnuCash in Linux Mint it will appear in the
desktop menu which is activated by clicking on or hovering over an icon which
looks like LM in a circ
On Wed, 2022-08-03 at 20:28 -0400, Peter S. Shenkin wrote:
> Adrian,
>
> I do have full account names turned on. I forget where I did that. I have
> no customized sort that affects the order of accounts within a transaction
> in either register view nor in the transaction report. (I prefer to sort
Rob
There were originally breakout pages from the building on Linux for specific
information related to various Linux distributions including one for Ubuntu.
That seems to have now morphed into a general installation page for Ubuntu
https://wiki.gnucash.org/wiki/Ubuntu and the Ubuntu specific bui
Eric,
This is already possible, at least on Linux but I suspect also in Windows too (
this link may provide a way
https://support.microsoft.com/en-us/windows/add-an-app-to-run-automatically-at-startup-in-windows-10-150da165-dcd9-7230-517b-cf3c295d89dd
). On Linux Mint I can create multiple launc
Eric
AFAIK you can do this by making a payment of less than the due amount from one
account and then makea second (or more) payment from another account to the same
invoice - just cant do it in a single step.
David Cousens
On Sun, 2022-08-07 at 19:17 +, Eric Hammond wrote:
> Thanks again t
James,
Have you read the help Manual sections on Accounts and Common Transaction
Operation https://code.gnucash.org/docs/C/gnucash-help/help.html- much more
useful than YouTube videos. Most of the Youtube videos dealing with GnuCash are
AFAIK not produced by any of the documentation team or the de
James,
If you are not seeing the transactions you have already entered and the
accounts in the account tab it is possible that you have not saved the
datafile. To do this use the File-Save As menu item immediately after starting
GnuCash up. It will then automatically open the same file next tim
Tom,
There is another issue with putting up a list of banks known not to supply
OFXQFX or CSV downloads. The banks can up date there procedure and if the
information put up is wrong or becomes wrong, they may take issue with an
independent site posting that information particularly without some dis
James
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html
The info https://wiki.gnucash.org/wiki/Configuration_Locations is also useful
for backing up user preferences and things like customized reports.
To back up to a USB drive on Linux Mint, the drive should appear in the fi
Adrien,
It does indeed Menu->Administration->Backup Tool. I don't usually make use of
it as my NAS initiates and carries out my main backups for me and a couple of
crons do the rest. It looks like it can access network locations too. I have a
mixed Linux/Windows (can't convert the wife) setup whi
Finbar,
This is likely as specific as it gets or can get
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html.
As others have mentioned the exact accounting treatment depends on the tax rules
in your jurisdiction and likely business regulations if you are conducting
investment as a
Jean,
The Linux build instructions are here
https://wiki.gnucash.org/wiki/Building_On_Linux
If you are installing 4.6 there are some new dependencies which will be in the
release notes and the dependency files in the sources. AFAIK the wiki hasn't yet
been updated to deal with any V4.6 issues.
Jeff
The Transaction Report will also do what you want AFAIK.
David Cousens
On Tue, 2021-08-17 at 01:06 -0500, Jeff wrote:
> Is there a way to do a search (ctrl F) and have a dollar total for all
> found transactions? Or a built in report tool that I am overlooking?
>
> running Version: 4.2
>
flywire
The following has some information of the treatment of franking credits in the
hads of an investor.
https://www.insightaccounting.com.au/2017/03/share-dividend-income-franking-credits/
It would appear that generally they form a part of your taxble income but would
need to be recorded in a
Jean
I recently built 4.6 on Linux Mint 20.2 with no problems. The following commands
will list the installed packages. You need to have the development header
packages ".dev" (libaqbanking-dev and libgwenhywfar-core-dev)
installed to build the programs, not just the runtime binaries.
dpkg -l |
Rogier,
Retained Earnings is an equity account so a retained earnings balance is
recorded against equity itself as follows if your past retained earnings were a
net profit (credit or +ve balance in your pevious set of accounts). If a net
loss (debit or -ve balance_ then the debit and credit would
Alton
From your description it would appear you are using the notes field to stor a
link to an external file descriptor. GnuCash has had a facility to associate a
URL for an external file to a transaction (Menu-.Transaction->Manage Document
Links and Transaction->Open Linked Document in V4.6). Thi
Alton
From your description it would appear you are using the notes field to stor a
link to an external file descriptor. GnuCash has had a facility to associate a
URL for an external file to a transaction (Menu-.Transaction->Manage Document
Links and Transaction->Open Linked Document in V4.6). Thi
Alton
From your description it would appear you are using the notes field to stor a
link to an external file descriptor. GnuCash has had a facility to associate a
URL for an external file to a transaction (Menu-.Transaction->Manage Document
Links and Transaction->Open Linked Document in V4.6). Thi
Hi John,
Unfortunately another build problem on Linux MInt 20.2 with 4.8. Cmake ran OK
but ninja failed to build with following error. SHA256sum on the download was
correct
FAILED: share/gnucash/migratable-prefs.xml. The full terminal output is attached
for your info.
Regards
David
On Tue, 2021-
Rogier
The GunCash Help manual
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-edit.html discusses this
very briefly " press the Split button on the Toolbar or select Actions → Split
Transaction". The entry of multisplit transactions is discussed in detail in
the help manual at
https://ww
David,
Are you using the information in the Wiki pages
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect. Towards the bottom of
the page there is a section on enabling OFX logging which may provide you with
more diagnostic info if you are not already using it. Also the pages on
debugging
Hi Geert,
For your info if it will help diagnose problems on other Linux systems. As far
as I cn tell GunCash 4.8 is reading the preferences when they exist on Linux
Mint 20.2. I up graded from 4.6 via a patched version of 4.7 and then to 4.8
with a further patch suggested by John. Both 4.7 and 4.
Foad,
You could likely pay the dividend to yourself out of Retained Earnings annotated
accordingly. Other than that local practice and any tax treatment may need to be
considered. E.g. If you are subject to company tax whether your dividend is paid
out after tax or before tax which could have imp[
Lisa
It may help if you can tell us what the previous version was and which version
you have now upgraded to.
On the reconciliation setup dialog under the Ending Balance entry there is a
checkbox "Include subaccounts" which AFAIK by default is not checked. Try
selecting that when starting the re
Tom there is no need to do this.
Your bank records transactions from its perspective. What is an asset to you is
a Liability to them and vice versa so the column names in your accounts will
always be reversed from the column names in the bank's statement of your account
with them.
David Cousens
Joe,
In the reconciliation window it is possible to click on the debit or credit pane
and then use CTRL-A to select all displayed transactions in either pane and
either set them as reconciled or unreconciled.
There is not any other mechanim to unreconcile transactions other than one at a
time in
Nodje
Have you seen the wiki https://wiki.gnucash.org/wiki/GB/HMRC
David Cousens
On Tue, 2021-10-19 at 15:54 +0200, coolnodje wrote:
> Hi,
>
> I've been looking into the available reports to find a way to get an
> account summary of the VAT collected and spent for a given month.
>
> I have
Hi Bruce
It is a formal requirement in double entry accounting theory that the sum of the
debit entries/splits for a transaction should equal the sum of the credit
entries or splits.
Most transactions only have two splits but in the entry of transactions with
more than two splits if you enter a
Mattia,
When you purchase tax stamps in advance, they become a temporary asset of your
business which you would expense at the time you attach then to an invoice.when
you purchase the stamps you would credit your bank account by the amount of the
purchase and debit an appropriate asset account (e.
Hi Mattia,
I think you summay has captured the essentials. Whether you use a Liability or
an Asset Acciunt to record the value of the stamps will not matter in practice
but an asset account more correctly reflects the actual situation.
My description is appropriate when your business is using a
Mattia
A reconciliation deals with all the splits to a specifc account for a specified
date range from any transactions to any other account. There is not a single
entity transaction or split to associate a document with. At present AFAIK there
is no way of associating the external statement docum
The best chance of locating the source of an import error in a file exported
from Android is to compare its file format with what is known of the QIF format
and look for some deviations from this. Unfortunately QIF is a proprietary
format although Intuit did make some information publicly available
Parag,
The QIF importer component of GnuCash has been in place for a long time (well
over 10 years to my knowledge and there have been few changes to the code base
for it in that time). It has been used to import data from Quicken over that
time so it is less likely for there to be a problem i
Mike,
I have justed tested that on GnuCash 4.8 and it works exactly as described. I
you left click/select the File menu item, then hover the mouse pointer over
Export in the dropdownlist that appears that will bring up another drop down
list to the right of the Export entryover Export then l. Left
Mike
you might want to look at this recent thread re upgrading from GnuCashV2 to V4
https://lists.gnucash.org/pipermail/gnucash-user/2021-May/096480.html
David Cousens
On Tue, 2021-11-02 at 19:32 +, Mike Stillingfleet wrote:
> Ah OK. It would appear that I might be a little out of date. If
Upgrade 2.6 to 3.5
https://www.mail-archive.com/gnucash-user@gnucash.org/msg13291.html
I think Geert's post which was the in thread (scroll down)I posted earlier is a
bit more complete as it discusses reports and preferences as well as changes to
the data file.
Possibly worth putting a summary i
Thanks John,
I'll try and get a bit of spare time and trawl through the archives to update
the wiki then. Will likely need a bit of proofing afterwards.
Cheers
David
On Wed, 2021-11-03 at 11:20 -0700, john wrote:
> There's already some of that at
> https://wiki.gnucash.org/wiki/FAQ#Using_Differe
Mike,
There are three major issues associated with upgrading:
Upgrading the data file format;
Relocation of user preference data/config data (changes of storage location and
methodology;
Preserving any saved reports/config changes;
The first two generally take place, if at all at the major versi
David
That should not be a problem at all. I used 3.7 and 3.8 before up grading to 4.8
and imported OFX files regularly without any problem and have recently been
importing them in 4.8 without any problems. Usually as long as the second
transfer account has been specified for all the transactions
David,
Whether you choose to build from source or use a flatpack will depend on your
experience and confidence with building software on Linux. The process is
described fairly completely in the wiki https://wiki.gnucash.org/wiki/Building,
https://wiki.gnucash.org/wiki/Building_On_Linux and the
Ken,
Sure all those things are good to have but it is also important to record your
problem and the solution you found if it is a general problem. Someone can come
along and tidy it up and put it into context later and add technical details if
necessary but the chances are they won't unless there
>
> Any chance of a multi-select / group move in GnuCash?
>
I remember looking briefly at this possibility about the time I put the multiple
selection feature in he import matching window. If I remember correctly, the
account register is not a simple GTK TreeView structure which was what made th
Gyle,
If anything other than the A column is checked GnuCash is not going to import
the transaction. The U+C column checked indicates that it has been matched to an
existing transaction and thta existing transaction will be updated with
information from the transaction in the OFX file. If the R o
Chris,
The account to import the records to will be the account in GnuCash which
records the transactions for your business bank account. If you have the
register for that account open when you initiate the import process it will be
used as the default account to import to unless that is explicitl
Your problem is in assigning the whole $100 to your expense account. Also
recording the amount reimbursable by the second organization as income is not
optimum. You are not adding value (which would be income) simply being
reimbursed for your outlay on behalf of the other organisation. You might li
Jean,
I am not sure whether your Paypal statement is exactly the same as mine but my
statement has three columns with an amount in them labelled "Gross", 'Fee",
"Net". I assign either the Deposit or Withdrawal header to the "Gross" column
when I import the CSV. I can't remember which I use but I
Brian
What operating Sytem are you using and how are you installing it (flatpack msi ,
build from source etc)?
David Cousens
On Mon, 2021-11-22 at 22:52 +0800, BrianHsu wrote:
> Hi,
>
> I've encountered the issue that after install GnuCash 4.8, it won't
> read or store my preferences, as descr
Leo,
You can always manually override GnuCash's matching in the Import Matcher window
by checking the "C" ("R" in older GnuCash versions) column if Gnucash has
selected the "A" column to import the transaction and you do know it matches a
transaction you have imported to another account. This will
1 - 100 of 208 matches
Mail list logo
