Hi Martijn,
Gnucash is capable of supporting both cash and accrual accounting. The
business features (accounts receivable and accounts payable) are explicitly
accrual accounting based however as they record the income at the time the
invoice is created normally on the date the service is
Hi,
The most direct transaction to record this is:
Debit
Credit
Liability:DirectorsBusiness Expenses
Asset:LoansToDirector .
The most important thing is to
Hi Michael,
This one takes accounting back to 7000BC and traces the major historical
developments from there forward to the GFC in 2010. It would appear that
writing may have developed from ancient accountants methods of keeping
counts of goods traded. The first cheques were written by Arab
This is a bit off topic but for anyone with a historical interest in
accounting "Double Entry" by Jane Gleeson-White (Allen & Unwin 2011) is an
interesting read.
David Cousens
-
David Cousens
--
View this message in context:
Hi
To my knowledge Gnucash does not have the ability to generate splits between
accounts for sharing expenses automatically. When you enter a transaction it
is usually in the register for the account you are drawing from. A default
account for the other split of the transaction is generally
Macho,
>From an accounting perspective, the interest charge is not incurred until
the original invoice is overdue past the agreed date and should be recorded
as such at that time, while the original sale is recorded at the date at
which it occurred.
On this basis, I think it would be most
Hi Marc,
Don has answered your first question fairly completely. Whether you treat
payments you have made on behalf of the company as a loan or a contribution
to equity really depends on your intention to pay back the amounts and the
timescale on which you intend to do it.
If it ASAP (e.g. you
Hi Morris,
On Linux Mint 18.2 the help files are located in
/usr/share/docs/gnucash-docs. The display of the tutorial guide and manual
by Gnucash uses the gnome Yelp help browser. It may be this is not installed
in the raspberryPi Linux version.
The gift card is clearly an asset. When you receive it it is income. In most
jurisdictions one would expect gift income to be not taxable however this
may not always be the case.
I generally have income streams that are both taxable and non-taxable so I
already have placeholder subaccounts of
Hi Adrein,
I apologise if my comment appeared a bit flippant. The intention of my
comment about choosing any name was really that the actual name is less
important than the structural aspect of it being an asset account. The
general expectation would be that an investment in a business would
Anita
The Wiki has a secion discussing it at
https://wiki.gnucash.org/wiki/Closing_Books
and the documentation tells you how to use the built in routine for it at
https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-close-book.html
David Cousens
--
View this message in context:
To be useful the logfiles should be being written as each transaction is
recorded rather than only at the end of a session. In the latter case if a
crash/programming fault causes Gnucash to exit abnormally the log file would
contain no useful information. Autosave should only be working on the
Hi Buster,
Customer jobs are not meant to be the same as Vendor jobs at least according
to
the Gnucash Help manual entries which seem to indicate that they are
separate
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-jobs1.html and
Ananda,
The last post in this archive from Whirlpool forums mentions having created
a PHP script to download OFX files . I doubt he was using the HBCI interface
but was simply using the standard Netbank interface and supplying the data
needed to get the banks website to download the OFX files.
Hi Eneko,
The full accounting equation is
Assets = Liabilities +Equity+(Income -Expenses) where Income and Expense
accounts are temporary Equity accounts which record the changes in equity
during the current accounting period (usually a financial year).
You can rewrite this as Equity = Assets -
Keith,
The use of debit and credit is usually a little bit confusing until you get
a handle on the basic mathematics behind double entry accounting. The actual
meaning of a debit (or credit) depends upon the type of account it is acting
upon. The whole basis of double entry accounting is based on
Hi Colin,
i agree with both you and Bram there. It is not a reliable backup of the
database but really only useful for sharing a database across several
machines and worked well for the use case where my laptop was generally
connected to my LAN and I worked away from home occasionally. haven't
Hi,
The facilities you are requesting are likely to require an inventory
management system. At present Gnucash is an accounting package and currently
does not incorporate any features for inventory management. As far as i know
there are no plans to incorporate such features in the near future. To
Hi Michael,
Point taken. I was really commenting specifically on the in package
capability of Gnucash to meet fellow_travellers's needs. It might be useful
to have a list of external software that does provide additional capability
to extend Gnucash somewhere on the wiki page.
One of the
Congratulations to John and the rest of the team.
Builds and installs and runs nicely on Linux Mint 18.2 and installs and runs
on Windows 10 on a TabProS.
-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
I am not sure how the cash flow report deals with credit cards/liabilities.
Even then a cash flow statement can only deal with already recorded
transactions as you have indicated with your phantom transactions. Where a
cash flow report is really useful is in looking at seasonal variations from
Hi Colin and John_Mike,
"Gnucash has no relationship with Nabble". This is not quite correct. As
well as replying to the mailing list emails from gnucash direct to your
email, the posts by email are also displayed in a Nabble version of the
Forum at
Hi Derek,
Thanks for the clarification re Nabble. I am very grateful to Nabble for
taking the mailing list on as I find it much easier to follow threads on
Nabble. My reference to "relationship" was really only about the ability to
access the mailing list from Nabble and not with respect to its
This thread gives some info on syncing data.
https://gnucash.uservoice.com/knowledgebase/articles/1120894-how-to-sync-data-from-gnucash-android-to-desktop
David Cousens
-
David Cousens
--
View this message in context:
Greg, Mike,
I have no problem accessing the gnucash export files in Dropbox from my
Android phone as I indicated in an earlier post.
Dropbox has a daemon which you have to download and install on Linux to sync
with the server. There is usually a version available via the Software
manager on
Hi George,
How you record these items will depend a great deal on the exact nature of
the item and the nature of the future benefit you receive from them.
In the case of a pension the future value may be different from simply the
paid in value of the contributions. Depending on the nature of
Robert,
Would the Credit Note facility not suit to record what essentially becomes a
reversal of part of an Invoice which would be included in the Customer
report? The discussion of the implementation is not all that clear in the
manual
Christine,
Gnucash is a double entry accounting system. What this means is that any
transaction affects at least two accounts. For example when you purchase
something your bank account is credited by the amount of the purchase any
purchase is also an expense so an expense account has to be
Christine,
I don't think the program itself is your problem. You will require some
fundamental knowledge of accounting procedures and theory no matter which
program you use. It is also a process of learning the jargonused in a
particular program's interface. I know of no accounting program which
Hi Adrien,
I am assuming here you mean when you are pre-billed by a supplier of a good
or service. What follows is not necessarily restricted to insurance or even
to prepayment but just uses these to illustrate the principle. If you mean
that you are pre-billing a client, my apologies and please
Kevin,
If you are entering an existing asset rather than a new paurchase the credit
entry should be to an Equity Account:Opening Balances rather than to a Cash
or bank account and the debit entry to thr Fixed asset account.
David Cousens
-
David Cousens
--
Sent from:
Hi Maf,
Just a slight clarification on what accrual accounting means.
The GAAP contains certain principles about when income is considered to be
earned and when expenses are considered to be incurred and when they are to
be recognized/recorded in the accounts. These are not necessarily
My bad John,
I replied to the wrong post.
David
-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
John,
That is exactly what the Opening Balance dialog actually does in Gnucash (it
creates those entries) and once the entries have been created they are
easily edited either from the Opening Balances register or from the register
for the account for which you set the opening balance, just as
Hi Adrien,
Add ressing this point:
"Pre-paid expenses are a special case, but I should think it possible to
address it with the business features somehow. I’ve thought of using special
clearing accounts but I can’t seem to figure where they might go. Posting a
bill for a pre-paid expense (but not
The bank considers its loan to you as an asset, the fees and interest charges
to the loan account are income to the bank, so the offset account for the
bank for these transactions is an income account. These transactionsto the
asset :loan account of the bank will increase the value of their asset,
Dennis,
You are missing the third part of the cmake command when you type
cmake -DCMAKE_INSTALL_PREFIX=/home/dennis/.local
which is why you are getting the cmake error.
You need to append either
../gnucash-3.1
or
/home/dennis/Applications/gnucash-3.1
on to the end of the cmake command
Dennis,
The obvious place to put the build-cmake directory is in the Applications
directory. I personally would not name it build-cmake but build-gnucash-3.1.
The reason for that is, to uninstall Gnucash there is no need to retain the
gnucash-3.1 source directory which can be deleted, but you
Hi Dennis,
I updated the BuildUbuntu16.04 page after having similar problems while
building Gnucash3.0. My apologies for any errors and lack of clarity in a
few areas and thanks for reporting the problems. I will edit the page to try
and make some issues clearer as I or other users uncover my
Hi Dennis,
I recently updated the Ubuntu 16.04 build instructions so I am glad to get
your feedback on issues which may be unclear and any errors I may have
incorporated. I will try to modify the instructions to make it clearer and
eliminate errors. If you find any issues that are specific to
I think you are overcomplicating the issue by recording the appllication for
the refund from the MRA account. No money chnages hands at this point so you
could record paying the Doctors bill as
Asset:Check Credit $100
Expense:Medical Debit $100
When you receive the
The best place to start is the Tutorial and Concepts guide.
http://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-setup1.html is the
link for V2.6 documentation. There will be a similar section in the V3 docs
if you are using that version. While that is mainly aimed at stocks and
mutual funds,
Dennis
It is probbaly a good idea to uninstall the previous build of 2.6.x before
upgrading. With the changes between 2.6 and 3.1 there may have been changes
in the libraries/library names such that some older libraries may not
necessarilybe overwritten.
How to remove it will depend upon how you
Dennis,
The instructions for v3.1 should work. The only problem I had when i
compiled 2.6.21 after upgrading to 3.1 was that I had installed guile 2.2.3
and v 2.6.21 looks for guile-1.8 or guile-2.0. It is possible to have
several versions of the guile libraries and headers installed as they
Hi Dennis,
Almost there but not quite. In which directory in your home directory
/home/dennis have you extracted the gnucash-3.1 directory from the tarball
gnucash-3.1.tar.bz2 which you downloaded. Can you tell me the full path to
that directory and the full path to the build-cmake directory you
Bill,
This is not the case for GnuCash v3.1 on Linux Mint 18.3. You can readily
check and uncheck the boxes. The only hassle I have had is that by default
the credit and debit entries are not ordered by date but by reconcile status
and when you check a box, it is automatically placed at the end
Robin,
I'm also using 3.1 on Mint 18.3. I have tried to duplicate your problem
without being able to. I am able to edit the fields in the template
transaction without any diffculty and I don't receive that error message at
all. I can create 2 scheduled transactions and edit them both at the same
Hi Geert,
I think one of the reasons people are not finding the Build#Ubuntu
instructions and main build instructions in the wiki is that the main page
is identified as Build Instructions for Developers rather than a general
GnuCash Build Instructions page which gets listed in the top level
Hi Frank & David T ,
Thanks for the info re the main page. I will try and hook into the Wiki
Installation page as you suggest and have a go at making the build
instructions friendlier for general users and split off a more specific page
for developer builds. i will then link that back to the
Varda,
I travel with a laptop and use a desktop at home. If you have internet
access while travelling I have had no problem with putting the GnuCash files
in a Dropbox account synced to both the desktop and laptop. You can work
without internet access and it syncs next time access is available.
Christian
V3.1 compiled on Linux Mint using the XML backend works fine with associated
files/locations setting them, retrievingthem after closing and reopening the
program and opening the locations without any problems so it is possibly
associated with the sqllite backend or perhaps the DB
What version of Gnucash are you using and what platform is it running on.
When you look at an individual charge transaction, the balance after the
transaction should be larger than the balance before the transaction with
the reverse for a payment. Whether that balance is shown as a negative or
Francis,
If you look in the folder which contains your gnucash file there should be a
set of backup files. Gnucash creates a backup file. I am assuming you are
using the XML format files and not a database. The file will have a name of
the form
.gnucash
and the backups will have the form
Rich,
How are you creating the payment of the Bill?
If you open the Bill and then use the payment icon in the Toolbar (no need
to search for the bill to pay) or alternatively use the
Business->Vendor->Process Payment and search for the Bill by Vendor and
select the Bill the transactions for the
Martijn,
I can't really comment on the Cash Flow reportas implemented in GnuCash and
it's options but the doubling of accounts in the selected list when the show
subaccounts is selected does appear to be strange and may be a bug. My
understanding of a Cash Flow Report is that it includes:
cash
Adrien,
I think with the default account selection, the Cash Flow report seems to do
the right thing. The double selection of accounts seems a bit strange, I
haven't really got a proper set of business accounts to check it out on
anymore and the dummy set I have put together have been for testing
Stephen,
It is generally a good idea to remove the previous version before installing
a new one. Gnucash will generally overwrite any existing files of the same
name, but you may be left with unnecessary files in some cases. Going from
3.1 to 3.2 should be OK as there are unlikey to be major
John,
I'm using CMake v 3.5.1. Presumably the same or similar could be used to
create an uninstall target for Ninja. Their argument for providing a default
uninstall target seems a bit weak to me as you are not going to be issuing
the command in a build directory unless you really intend to
Geert,
The default theme is Mint-X. There is a Mint-X Dark GTK-3 theme available
as well and GnuCash comes up nicely in it. It is installable from the
Menu->Preferences->Themes dialog in the Cinnamon desktop. I would say on
Mint all you have to do is select a dark theme at the system level.
John,
Just some further information. I rebuilt GnuCash with the -G Ninja option.
The build.ninja seems to contain a build uninstall target but it has no
commands. If I run
sudo ninja install
it installs GnuCash (in/usr/local the prefix I set with cmake) and creates
install_manifest.txt.
If i
Stephen,
There is no need to install the libofx7specifically. If you install
libofx-dev that should install the the appropriate version of the library
for your ubuntu version (i.e. libofx4 on 14.04(Trusty), libofx6 on 16.04
(Xenial) and libofx7 on 18.04 (Bionic)
David Cousens
-
David
Stephen,
You can possibly force the case of sum of the children account totals being
the parent account total by making the parent a placeholder account. Then
it cannot have any transactions into it, only the child accounts.
David Cousens
-
David Cousens
--
Sent from:
John,
I agree with you that making the accounts with child accounts have no
transactions is being unnecessarily restrictive and may not meet all
possible use cases but perhaps having the option of being able to restrict
it to that case if it suits an individual's purpose is a suitable
compromise.
Hi Stephen,
I agree with your wife about not including the Income Statement inside a
Balance Sheet. These serve different functions and it just makes a Balance
Sheet more complicated than necessary. From an accounting perspective you
should be able to evaluate a balance sheet fairly quickly and
Christopher,
" except that Placeholder accounts
can also contain transactions therefore must not necessarily accumulate
their children account amounts. "
I have to disagree with the above from an accounting perspective.
If accounts are setup as Placeholders initially (i.e. the checkbox set in
Geert,
I tried this on Linux Mint 18.3 but had no changes from the default theme.
David
-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To
John,
Just to clarify. While I have accounting qualifications, I am not a
practising accountant and my judgement is primarily an opinion based on my
formal studies and my accounting experience in a small business in my
particular country. We all need to keep in mind that accounting, while
John,
The GnuCash wiki Installation instructions now link to the build
instructions for Ubuntu (and derivative distrubutions like Linux Mint)
https://wiki.gnucash.org/wiki/Building which in turn has a link specifically
for building V3 on on Ubuntu16.04, 18.04 and derivatives which now hopefully
Stephen John, Geert
In accounting terms there are really only 3 basic account types:
Asset
Liability
Equity
These all *must *satisfy the basic accounting equation Assets=Liabilities
+Equity.
The two sides of this equation are what the German /European system defines
as Activa and
Hi John,
If GnuCash is not built with Ninja, there is a cmake_uninstall.cmake file in
the top level of the build directory which seems to read the
install_manifest.txt file. The Makefile in the same level produced by CMake
has an uninstall target - not sure how it executes the commands in the
Hi Carlos,
I had the same original problem during Make while building Gnucash 3.0 that
you did. Aboout half way down the following thread there is a recipe of what
worked for me in getting a successful build. It may not address your second
problem, but I hope it helps.
Cheers
David
-
John,
For your info OFX import is working fine on Linux Mint/Ubuntu 16.04. The
only problem I had was that the previous automatic matching to accounts
seemed to have had the data cleared in the swap over to the V3 user
preferences files. After one import it had reestablished most of the
matching
I think the accounting for bitcoin production would be similar to any other
manufacturing cost accounting although identifying the component costs may
be interesting. If you are running your own hardware to do it then that is
one cost, (depreciation, running costs etc) which will more than likely
Cam,
I have been giving a bit of thought to the way one might account properly
for Retirement funds. I am not sure how your CRA asks for information about
income from your RRIFs. In Australia, I have specific questions in the tax
return dialog at which I have to record the income from such funds
Hi Les,
The Linux Mint Software manager version is usually 1-2 releases behind the
latest release of Gnucash. getDeb is sometimes a bit more up to date.
Unless there are specific features/fixes in the latest release that you need
then 2.6.17 which is the current LM version should be OK.
If
I use the flatbed scanner on a Samsung SCX3405FW combined with the XSANE
Image Scanning Program to scan receipts with output as jpg without any major
difficulties on Linux. As others have noted at present there is no way to
link these into Gnucash at the moment. Main reason is to store receipts
The short answer is yes. but the following articles may give you some
insights into how unrealized gains and losses are usually recorded and
reported. These article provides some info about treatment of unrealized
gains and losses on trading securities under the GAAP in the US
Mike,
1. it is unlikely but it is possible to unset the reconciliation status but
a warning with an opt out of the change is issued before it is changed and
it is possible to edit a reconciled split of a transaction but you will
normally get a warning even if the split you are editing is not into
It should be no problem at all. Just record the original transactions you
already have recorded against something like a miscellaneous expenses
account. Add notes to the description that they were direct debits in error.
The refunds should also appear in your OFX records so just load then and use
If its any help the reconcile dialog should allow you to change both the date
and the ending balance. The observed behaviour on Gnucash 2.6.18 ( and it
hasn't changed for me since changing from 2.6.16 or from previous versions
over the last 2-3 years) on Linux Mint 18.3 (Ubuntu 16.04) is that if
Hi David,
Agreed that the process of importing of transactions to an account is a
separate and distinct process from that of reconciliation with an external
statement.
Given that however, the import process, if it matches an existing
transaction in your accounts will classify a transaction as
Elmar,
If you have narrowed the date range in which the error has occurred then it
is down to old fashioned accounting practices for finding errors. Some of
these articles may help:
http://www.reallifeaccounting.com/pubs/Article_Theme_Detecting_Accounting_Errors.pdf
Any matching procedure on an import is not going to be perfect. Make the
criteria too tight and almost nothing is matched. Too loose and everything
is matched, so it is always a compromise.
I have found the order in which I process the OFX imports from my various
accounts can have some impact on
Larry
If your withdrawals from the RRSP are taxable on withdrawal then I think
your approach of using two files recording transfers to your bank account
from the RRSP as Expenses in the RRSP account and Income in your main
accounts should work fine as it will satisfy the accounting equation in
Larry,
I'm not familiar with the details of RRSP accounts in Canada so any comments
here are general in nature and not taken as accounting advice per se.
If it is a retirement savings account you would treat it as an Asset.
Depending upon the conditions associated with withdrawal of funds from
Steve,
One possibility is to use synchronized data bases using master-slave
replication. I know this works with MySQL and it is a bit of a pain to set
up but once it is going it is generally pretty good. Also a bit of a pain to
restart if the replication gets out of sync. I have been meaning to
Adrien,
>From what little I know of the automatic gains/loss calculations by default
the gain or loss on a transaction is created in an Orphan-Gains-CCC account
by default and the user has to reassign the gain or loss to an appropriate
income account.
See
Adrien, David,
The same issue occurs in Linux Mint 19(Tara) which is Ubuntu 18.04 based.
Nemo (file explorer) can see the mounted USB stick and access it directly
or via the /media// mount point for the device but the Gnucash file
open dialog neither sees the USB stick or /media// mount point
John
I had considered writing a payroll plugin a few years ago but found that
finding my way around the Gnucash code made it difficult so I have great
respect for the business features that Derek has created so far. I started
to think more in terms of a separate payroll program which maintained
Adrien,
I do use Nabble and also get the user list posts by email but as I am in
Australia I sometiimes notice there is a long delay associated with being in
this timezone. I'm not sure where the moderators are located but, I tend to
post usually in the morning AEST (UTC -10:00) and my posts
Adrien,
The main function of the trial balance is to ensure the accounts are
numerically correct before any adjustments to the accounts are made before
producing the final financial statements. It should be just a straight
listing of the balance (credit or debit) of all accounts in the chart of
Hi Amish'
I can also confirm that the credit note has a bug for GnuCash 3.2 running on
Linux Mint 19 from the flat pack. I have created an Invoice for $100 for a
dummy company in a test file and then a credit note for the same dummy
company for $50. I have not used a tax table. After the two
As well as the internal funds transfer from Euro to USD in your Asset:bank
account are you also converting the corresponding income account in Euro to
an Income account in USD at the same exchange rate? If not this is a
possible spurce of any imbalance in the accounting equation.
David Cousens
Joe,
I've been using GnuCash on Linux Mint for approx 5 years with no problems.
The Software manager version is sometimes a little behind the current
GnuCash version but at present it has a flatpak GnuCash V3.2 available that
worked fine under LM18.3 and is working fine on LM19. I'm currently
Johnnie
Use File ->Open from the menu and navigate to the location where you saved
the file. Hopefully you did not save the file to a read only CD. You should
have received a warning that the device could not be written to if you had
attempted to do that.
Open the file .gnucash where filename is
Stephen, Colin
Just a correction to my last post. There is no problem with the icon
installation on Linux Mint 18.3. It seems to possibly be a problem with
Nemo (Linux Mint file explorer) rather than the installation. All of the
icon files are actually there but there is something with the
Stephen, Colin
I think there is a problem with the cmake creation of the scripts that do
the install, that is not installing the icons correctly. I just did an
uninstall of v3.2 on Ubuntu, deleted any gnucash files left in my install
location (/usr/local) relating to gnucash so that all
Geert,
I had realised the same thing about needing to uninstall before building and
shifted the section on uninstalling to before the section on Building on the
Wiki page and specifically mentioned using the previous version's build
directory. I might make the note clearer about retaining the
Stan,
The previous discussion on uninstalling related to Linux (the Ubuntu
distribution in particular) where users have built GnuCash from the source
code.
On Linux, if you use the particular Linux distribution's (Ubuntu, Debian,
Redhat, Centos etc.) supported version of Gnucash, it normally has
Colin,
A correction. The latest LM 18.3 Software Manager now installs Gnucash 3.2
as a flatpack in /usr/bin. There are no identiable gnucash directories apart
from the user configuration.
David
-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
1 - 100 of 143 matches
Mail list logo