Re: [GNC] Share Values recording

2022-08-11 Thread davidcousens49
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

Re: [GNC] gnucash-user Digest, Vol 233, Issue 34

2022-08-11 Thread davidcousens49
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

Re: [GNC] gnucash-user Digest, Vol 233, Issue 34

2022-08-10 Thread davidcousens49
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

Re: [GNC] Banks with OFX or CSV account data downloads

2022-08-09 Thread davidcousens49
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

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread davidcousens49
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

Re: [GNC] transfe money from one account to another

2022-08-07 Thread davidcousens49
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

Re: [GNC] Request for two new features in GnuCash

2022-08-07 Thread davidcousens49
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

Re: [GNC] Request for two new features in GnuCash

2022-08-06 Thread davidcousens49
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

Re: [GNC] Build From Source Near Impossible

2022-08-06 Thread davidcousens49
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

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-04 Thread davidcousens49
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

Re: [GNC] gnucash-user Digest, Vol 233, Issue 9

2022-08-03 Thread davidcousens49
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

Re: [GNC] Gnucash

2022-08-02 Thread davidcousens49
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

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread davidcousens49
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

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-01 Thread davidcousens49
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

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-01 Thread davidcousens49
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

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-01 Thread davidcousens49
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: [GNC] Gnucash

2022-08-01 Thread davidcousens49
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

Re: [GNC] computer with Linux

2022-07-31 Thread davidcousens49
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

Re: [GNC] computer with Linux

2022-07-31 Thread davidcousens49
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

Re: [GNC] Online Help manual CSV import section is out of date

2022-07-27 Thread davidcousens49
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

Re: [GNC] Trading accounts

2022-07-26 Thread davidcousens49
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

Re: [GNC] Another crash

2022-07-23 Thread davidcousens49
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

Re: [GNC] Online Help manual CSV import section is out of date

2022-07-21 Thread davidcousens49
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

Re: [GNC] Revising an old Gnucash file

2022-07-19 Thread davidcousens49
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

Re: [GNC] New User Oh boy I need an accountant

2022-07-18 Thread davidcousens49
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

Re: [GNC] Online Help manual CSV import section is out of date

2022-07-18 Thread davidcousens49
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

Re: [GNC] Online Help manual CSV import section is out of date

2022-07-17 Thread davidcousens49
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

Re: [GNC] Transaction imports

2022-07-05 Thread davidcousens49
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

Re: [GNC] Uneven line spacing in Accounts list since 4.11

2022-07-03 Thread davidcousens49
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

Re: [GNC] Could Not Obtain Lock

2022-06-27 Thread davidcousens49
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

Re: [GNC] Combining Method in Chapter 11 and Standalone Security

2022-06-23 Thread davidcousens49
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

Re: [GNC] Help

2022-06-21 Thread davidcousens49
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,

Re: [GNC] Help

2022-06-21 Thread davidcousens49
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

Re: [GNC] rookie question Imbalance-USD

2022-06-20 Thread davidcousens49
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

Re: [GNC] Direct Adjustment of Security's Price

2022-06-19 Thread davidcousens49
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

Re: [GNC] importing csv and negative numbers

2022-06-12 Thread davidcousens49
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

Re: [GNC] Missing 2nd entry

2022-06-09 Thread davidcousens49
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

Re: [GNC] Export as text or CSV

2022-06-07 Thread davidcousens49
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

Re: [GNC] Export as text or CSV

2022-06-07 Thread davidcousens49
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

Re: [GNC] Transfer Dates

2022-06-05 Thread davidcousens49
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

Re: [GNC] Mass Reconcile

2022-06-03 Thread davidcousens49
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;

Re: [GNC] Balance Sheet mismatch

2022-06-02 Thread davidcousens49
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

Re: [GNC] Import is finding no matching transactions

2022-05-31 Thread davidcousens49
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

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-20 Thread davidcousens49
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

Re: [GNC] How to convert between currency and assets and record change of value

2022-05-19 Thread davidcousens49
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

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-18 Thread davidcousens49
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

Re: [GNC] unrealized gain / losses for mutual funds

2022-05-18 Thread davidcousens49
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

Re: [GNC] Am I in business?

2022-05-18 Thread davidcousens49
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 +,

Re: [GNC] Am I in business?

2022-05-17 Thread davidcousens49
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

Re: [GNC] Am I in business?

2022-05-14 Thread davidcousens49
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

Re: [GNC] Am I in business?

2022-05-13 Thread davidcousens49
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

Re: [GNC] Configuration dilemma -- How best to share Gnucash between 2 users

2022-05-10 Thread davidcousens49
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

[GNC] Errors after restarting GnuCash 4.10 from terminal or bash script

2022-05-09 Thread davidcousens49
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

Re: [GNC] GnuCash 4.10

2022-05-08 Thread davidcousens49
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

Re: [GNC] Fwd: Double entry directly to Equity

2022-05-08 Thread davidcousens49
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,

Re: [GNC] Fwd: Double entry directly to Equity

2022-05-07 Thread davidcousens49
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

Re: [GNC] QIF import error

2022-05-06 Thread davidcousens49
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,

Re: [GNC] QIF import error

2022-05-06 Thread davidcousens49
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

Re: [GNC] How to copy a GnuCash 'installation'?

2022-05-06 Thread davidcousens49
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

Re: [GNC] QFX file for Bank of American business account not

2022-05-04 Thread davidcousens49
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

Re: [GNC] Change account in Transfer column - how?

2022-05-04 Thread davidcousens49
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

Re: [GNC] Change account in Transfer column - how?

2022-05-03 Thread davidcousens49
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

Re: [GNC] GNC Fails to load Data File

2022-04-30 Thread davidcousens49
David, Bruce The type Spreadsheet is the same independent of whether the data file is stored in sqlite3 or xml format on Linux. I can't test the other database formats at this point. David Cousens On Sun, 2022-05-01 at 06:42 +1000, David H wrote: > Bruce, > > To me the screenshot of your file

Re: [GNC] GNC Fails to load Data File

2022-04-29 Thread davidcousens49
Bruce use your file explorer to locate your data file then use File Open from the menu inside GnuCash to navigate to that position, select the data file. The newly installed version has no memory of where Flatpak kne the file was located us the config/user preference information where the last

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread davidcousens49
Chris, If you start multiple programs from the directory a set of bash scripts which change to the appropriate directory and run the set of programs for each set of books you work on might be useful. You could launch the scipts from either the Ubuntu menu or from desktop launchers. David

Re: [GNC] Help with GnuCash's 'help'

2022-04-26 Thread davidcousens49
Chris The online version of Help and the Tutorial and Concepts Guide are not really searchable in any meaningful sense from within the HTML page. Other versions may be I have more luck using Google directly to find specific topics and info. The section you are likely looking for comes under

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread davidcousens49
Unfortunately GnuCash doesn't work that way AFAIK. Depending on your OS you may be able to create separate launchers in the Desktop menufor each specific file and name them accordingly. I know this will work on Linux Mint and likely Ubuntu variants but not sure on other OS. The command issued by

Re: [GNC] Reinstall GnuCash after Ubuntu upgrade to 22.04

2022-04-24 Thread davidcousens49
David Tommy etal As Ubuntu and Linux Mint are ultimately Debian based it should be possible to install using dpkg or the Gdebi installer (you may need to install this on Ubuntu -in terminal - "sudo apt install gdebi - but it is the default installer in Linux Mint) from

Re: [GNC] Whole life insurance

2022-04-23 Thread davidcousens49
Fred, You will need a statement from the insurance company which details what component of the premium credited to your bank account when you pay it) is a contribution/increase to the capital value of the asset which is the insurance policy (debited to the account representing the policy and

Re: [GNC] Why does an Equity account have to be of Currency type?

2022-04-23 Thread davidcousens49
Ken All accounts have a currency associated with them. When you hold an asset, you hold it at a value in a particular currency, not as an item of indeterminate value. You would require an inventory (which GnuCash does not have to hold the items and in inventory accounting each item still has a

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread davidcousens49
Chris, In around 12 years of using GnuCash on Linux, I could probably count on one hand the number of times I have had to type in the full filename and extension or even search for the location of GnuCash data files. At least with the ".gnucash" extension there is little chance of a clash with

Re: [GNC] Unusual book need

2022-04-16 Thread davidcousens49
Jeff Someonelse suggested using the find transaction search if there is some common string you can search for. David On Sat, 2022-04-16 at 00:32 -0500, Jeff wrote: > David, I like your approach the best. Even though the transactions are > in a joint account between my son and father, I am

Re: [GNC] Unusual book need

2022-04-15 Thread davidcousens49
Jeff Another approach you could try would be to create a temporary account in your dad's books and move the transactions that should have gone into your account into it. Should work if all of the transactions have at least one account in common , e.g. an Asset; bank account or similar. if not

Re: [GNC] Can't find the file sometimes

2022-04-12 Thread davidcousens49
Heide, The recommended procedure when updating GnuCash from an old version to a newer version is to first update to the last minor version of the major series number , e.g. for 2.6 this is I think either 2.6.19 or 2.6.21 before up grading to the 3.x series. If you are up grading to version 4.xyou

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread davidcousens49
Rich, One possible cause for this is a transaction (or more) accidentally entered since the time you were last getting correct reconciliations at a date sometime in the past. This has occurred for me sometimes when I have mistyped a date entry, particularly the year, on entry. e.g date went in as

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread davidcousens49
Rich Have been using GnuCash for a similar period of time and have not noticed any reconciliation problems (other than those reported as bugs on the list - any that are are generally fixed pretty quickly) up to v4.9, particulaarly in recent versions. Haven't yet done a reconciliation with 4.10.

Re: [GNC] how to put loan downpayments in budgets

2022-03-29 Thread davidcousens49
Karin It is not an expense but a liability. When you open the Budget you can expand the liability accounts and enter budget amounts against the liability account for the loan/mortgage at the period the payments are due. If necessary you can change the budget interval to suit. A reduction in the

Re: [GNC] Fw: Re: Upgrade problem

2022-03-29 Thread davidcousens49
On Tue, 2022-03-29 at 09:40 +, avigr...@juno.com wrote: > What is the filename that GnuCash uses to store the data? I need to know what > filename I am looking for when I do my search for it. Whatever name you gave it when you created it. It will have the file extension ".gnucash" so look

Re: [GNC] How To Account For Mortgages With Redraw Amounts?

2022-03-27 Thread davidcousens49
Arthur, The properties themselves will be recorded as asset account and the mortgages as liability accounts in GnuCash and as they are generally long term assets would not be recorded as current assets (unless you trade in properties). An account of the form Asset:Non-current:Properties:property1

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

2022-03-25 Thread davidcousens49
Jeff, Follow David Whitings suggestion creating multiple desktop entries in the file, one for each separate datafile you need to open, changing the name in the Name entry and the filepath in the Exec entry as appropriate. You can locate/put the desktop file in your home directory at

Re: [GNC] new subaccounts and updating saved reports

2022-03-22 Thread davidcousens49
George Have you tried changing the number of sub-account levels in the report options? (Edit->Report Options with the report open). It may be possible that changing from the default level of 3 and/or changing the option to flatten the account structure (you can always change it back again if the

Re: [GNC] gnucash-user Digest, Vol 228, Issue 33

2022-03-17 Thread davidcousens49
Frederick GnuCash also does not have support for full cost management accounting as well as not having inventory accounting which is just one component of cost management accounting. It requires a different form of jobs from that implemented in the business features. It can be done manually with

Re: [GNC] How To Put Opening Balance in Acc Rev Account?

2022-03-14 Thread davidcousens49
Arthur, The Accounts Receivable account is an asset account which means it is debited to increase its balance and credited to decrease its balance. You want to it to have a negative balance by the amount your tenant is in credit. Manually nter a transaction at the date you opened the books

Re: [GNC] MySQL

2022-03-13 Thread davidcousens49
Henrik, I doubt if the reliability problem you are experiencing is intrinsically in GnuCash itself although it may be associated with the library used to connect to MMySQL. GnuCash is not designed for multiple access in particular, i.e. multiple users cannot simultaneously access the same data

Re: [GNC] Is the directory .gnucash still used by v4.9?

2022-03-09 Thread davidcousens49
AFAIK it has not been used since V2.6. https://wiki.gnucash.org/wiki/Configuration_Locations David Cousens On Wed, 2022-03-09 at 13:04 -0800, Dean Gibson wrote: > Is the directory .gnucash still used by v4.9? > ___ > gnucash-user mailing list >

Re: [GNC] Subject: Re: Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread davidcousens49
Arthur, The option of using cash or accrual accounting is not necessarily totally a choice on your part. It will likely depend upon the taxation legislation in your jurisdiction. Many jurisdictions have a threshold on either turnover or income below which the individual business has the option of

Re: [GNC] reports

2022-03-05 Thread davidcousens49
On Sat, 2022-03-05 at 19:29 -0700, Charles Simcox wrote: > What report & how do I use reports o generate a report by selecting > specific accounts & some of their daughters not necessarily he whole > account? By first opening the report by selecting the required report from the Reports menu then

Re: [GNC] don't know..

2022-03-05 Thread davidcousens49
On Sat, 2022-03-05 at 20:26 +, arthur brogard via gnucash-user wrote: > Not sure if I'm doing this right. Hitting 'reply' on the email address of a > poster that I want to respond to and putting a 'cc' in for > gnucash-user@gnucash.org Arthur If you put gnucash-user@gnucash.org in the To:

Re: [GNC] accounts receivable for rent..

2022-03-04 Thread davidcousens49
Arthur, If you have the Accounts tab showing in the GnuCash interface, the menu item Actions->New Account Heirarchy will run a dialogue which allows you to choose specific account options. The first step selects the currency for the accounts you are going to add which will be your local

Re: [GNC] Eliminate Manual Download of Transaction

2022-03-01 Thread davidcousens49
Jesse, That is exactly what the Aqbanking interface does. It depends upon your bank allowing OFXDirectConnect. Some banks in some countries do not allow this. There is a lot of dscussion about setting up the aqbanking For setting this up see

Re: [GNC] Close books or start over?

2022-03-01 Thread davidcousens49
Leo Just export your account tree (File_>Export_>Export Account Tree to CSV) and reimport it into your new set of books. David cousens On Tue, 2022-03-01 at 22:14 +, Leo Bolta via gnucash-user wrote: > Hello, I moved from my home country about 4 months ago and did keep track of > expenses

Re: [GNC] reconcile problem?

2022-02-27 Thread davidcousens49
When importing your checking account, if the item has already been imported as a transaction to your credit card, then if GnuCash recognizes it the "A" column will be unchecked and the record will not be imported and either the "U" column will be checked if the record being imported has

Re: [GNC] Report question

2022-02-26 Thread davidcousens49
Paul You can copy the report to a spreadsheet by selecting the report tab, selecting all the content using Ctrl-A, copy it with Ctrl-C and paste it into your favourite spreadsheet. Works into LibreOffice Calc and should work equally with Excel. You can then save it either as CSV or in the

Re: [GNC] (no subject)

2022-02-22 Thread davidcousens49
On Tue, 2022-02-22 at 10:49 -0700, Mario Nigrovic wrote: > Many years ago, I had used gnucash, and was pretty happy with it. I was > very careful to make regular backups of my data, and so, when my disk > inevitably crashed, I was not too worried. However, I was mortified to > discover that,

Re: [GNC] Directly posting payments

2022-02-21 Thread davidcousens49
Jim, You only need to create an invoice where you are extending credit to a vendor - i.e. time to pay. if the item is a cash purchase you could simply open a transaction from the appropriate asset account register and credit the amount of the purchase to the appropriate asset bank account and

Re: [GNC] Accounting Working with multiple currencies

2022-02-20 Thread davidcousens49
There are a number of issues with your bookkeeping. The first major one is that when a book is sold you are debiting a Revenue account and crediting an A/R (accounts receivable) account. This is incorrect When you sell a book you are increasing the balance of the revenue/income account and

Re: [GNC] Can't play log files

2022-02-20 Thread davidcousens49
Don There sould be no need to play the logfiles on simply moving to a new system. All that should really be necessary is to copy the data file from one system to the other. If you were using any save reports, these can also be copied. the data file has the format .gnucash. if you copy that to a

Re: [GNC] Automatic sales tax

2022-02-20 Thread davidcousens49
The thing is Don all those other software packages charge you an arm and a leg in most cases for their software. This allows them have paid development teams who customize their products for each specific jurisdictions in which they operate. GNuCash does not. GnuCash is used internationally in

Re: [GNC] reconciling specific credit cards in an account

2022-02-16 Thread davidcousens49
The only way GnuCash can possibly know which of multiple cards a transaction is from is if that information is somehow contained in the data fields of the record that is being imported, usually something in the description field. GnuCash tokenizes the information in a number of fields including

Re: [GNC] report of accounts receivable

2022-02-13 Thread davidcousens49
David Does Reports->Business->Customer Summary from the menu (GC4.9) not meet your requirements or is it specificaly a listing of the customer contact information you need. Unfortunately that is not currently available. David Cousens On Sun, 2022-02-13 at 13:08 +,

  1   2   3   >