Re: [GNC] Linux gnucash saves files to home directory.
On Fri, Jun 28, 2024 at 05:01:12PM -0400, Victor Rotenberg wrote: > I want files the gnucash files (v5.6 flatpak install) to save into > /home/documents/gnudata.) . Instead it places the files .log, .lck > ,gnucash, into the home directory above all my other working folders. > Yes, it's an absolite pain isn't it!? I've muttered about this several times in the past but it doesn't seem to trouble most people. I just wish there was a way to tell GnuCash to put its "working" files in some user definable sub-directory instead of in the directory that **I'm** working in. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted
I am the treasurer of a very small parish church council in the UK. We have to present separate accounts for restricted and unrestricted accounts, this is a legal requirement and also required by our diocese. At the moment restricted funds are, basically, building funds and are kept in an interest paying savings account. The unrestricted funds are kept in a bank current account. My problem is that many donations to the restricted account (e.g. donations that the donor has specifically said must be for repairs of the church roof) go into the bank current account and have to be transferred from there to the building society account. For the last couple of years I have separate GnuCash data for the current account and the building society account, this has worked reasonably well. However we are now moving into a period of getting the roof repaired and much more money will have to move via the current account. So, how should I deal with this using GnuCash? I can see that I could separate accounts into two hierarchies (in a single database) - restricted and unrestricted with expenses and income for each, etc. However is it then possible to present separate end of year statements for them? This would simplify incoming donations which are all to a single bank account. Or are there other strategies which work better for this sort of situation? I emphasise that this is a small church, annual income is only of the order of £5000 and we have no full-time or paid employees. So the solution has to be simple and manageable by part-time, non-professional people. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: > On 5/11/24 3:08 PM, Chris Green wrote: > > So, given that I'm going up just one major release I shouls be OK, but > > running "Check & Repair" before doing anything else is a good idea. > Correct. The Check & Repair should run silently automatically upon first > opening your file with 5.5, but it doesn't hurt to do it intentionally. > > The biggest change I recall between 4 & 5 is the new type-ahead search > method for the Description field. I personally prefer the change, but > some folks didn't like it by how they use that field and their unique > list of existing Descriptions. > > There is also an issue for some, but not others with respect to > registers not auto-filling memos from previous session transactions. > (I'm one so affected) Mileage may vary on that one. > > As always - keep a backup. > > And since you are not on the last 4.x release on the old machine, I > wouldn't go back and forth with the same file. Once you migrate, stick > to 5.5 or drop back to 4.8 and stay there until you decide to finally > make the upgrade should you notice any problems. > Thanks Adrien, that's just the sort of information/confirmation I wanted. :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
On Sat, May 11, 2024 at 12:45:11PM -0700, Jim DeLaHunt wrote: > Chris: > > On 2024-05-11 03:21, Chris Green wrote: > > I am changing my Linux desktop computer from one running xubuntu 22.04 > > to one running xubuntu 24.04. As a result of this the GnuCash version > > will move from 4.8 to 5.5. > > > > Are there likely to be any problems or should it 'just work'? I'm > > using GnuCash with a sqlite database. > > > > I'm moving to new hardware so the old system will not disappear. > > This FAQ is probably relevant for you: > > "Can a new GnuCash release still read my old data file?" > <https://wiki.gnucash.org/wiki/FAQ#Q:_Can_a_new_GnuCash_release_still_read_my_old_data_file.3F> > > If that leaves you with questions, feel free to ask this list again. > So, it says (among other things) :- The data format between major release can change. However, the GnuCash developers try very hard to be as compatible as possible. Each major series is normally at least compatible with the previous major series. So, for example, if you have a data file created with 2.0.3, you should be able to open this with 2.2.5. Skipping a major release may cause issues though, and is not recommended. Instead, you are advised to at least open and save your file in the intervening major release first. So, given that I'm going up just one major release I shouls be OK, but running "Check & Repair" before doing anything else is a good idea. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
I am changing my Linux desktop computer from one running xubuntu 22.04 to one running xubuntu 24.04. As a result of this the GnuCash version will move from 4.8 to 5.5. Are there likely to be any problems or should it 'just work'? I'm using GnuCash with a sqlite database. I'm moving to new hardware so the old system will not disappear. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is anyone else getting these malicious e-mails?
On Mon, Apr 15, 2024 at 01:29:55PM +1000, Liz wrote: > On Sun, 14 Apr 2024 22:57:24 -0400 > Michael DeBusk wrote: > > > I've gotten two or three obviously-malicious e-mails pretending to be > > from this mailing list. The From: line lists the sender as "Gnucash > > User" but the address is not this one. I fear a spammer (or worse) has > > subscribed and is harvesting addresses. > > > > Is anyone else seeing this? > > No, and I have checked my spam and trash folders as well. > I cannot stop any particular email address from subscribing to the > list, and as you note then the addresses can be collected. > I use a *lot* ofmailing lists (60 or more) and I filter each into a separate inbox. The filter uses the mail headers to separate the lists and, thus, junk mail gets ignored. I'm sure the filtering on many mail client programs could do the same. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)
Adrien, Thanks for your continuing support with this, see further comments and informaiton below. On Mon, Mar 11, 2024 at 11:52:36AM -0500, Adrien Monteleone wrote: > On 3/11/24 5:30 AM, Chris Green wrote: > > On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote: > >> Chris, > >> > >> Once again, look into Edit > Stylesheets. > >> > >> For the record, I'm using defaults, and the is 12pt > >> bold and the lines are 10pt normal weight. The total lines > >> match the . > >> > > On my GnuCash (version 4.8 on Linux) there isn't a separate setting > > for the , it's the same size as 'Text Cell'. > > Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the > > individual transaction descriptions etc.) as well as the account title. > > > > There are no references to 'transaction' or 'name of account' in my > > stylesheet settings. > > > > Is this something that has been changed since version 4.8? > > > The total cells labels *as well as the account name* were all given a > CSS class: > > .total-label-cell > > for the labels, and > > .total-number-cell > > for the actual figures in the totals. > > By default, the styling for those is: > > td.total-number-cell { font-family: "Avenir", sans-serif; font-size: > 12pt; font-weight: 810; } > td.total-label-cell { font-family: "Avenir", sans-serif; font-size: > 12pt; font-weight: 780; } > > (visible if you open the exported HTML report in a text editor) > I have the exported HTML. It would appear that the section (i.e. account) headings are in a , see:- Lloyds 01/01/23 Lloyds Current The 'Lloyds' is what I would expect to be in a large font but there seems to be no class to apply to it. I have attached the whole exported HTML file, I can see no way to specify a larger size for the headings, it needs the HTML changing to give a class name to the section (account) headings. > You can use the CSS stylesheet for your report, and copy those above > rules to it. It is probably not strictly necessary to address the td > element explicitly like the inline style does, just the class should work. > > Or, with the Default stylesheet, simply adjust those options as desired > on the Fonts tab: "Total Label Cell" and "Total Number Cell". > > I'll file a bug on the Account Name sharing a class that makes it > non-obvious what to change. > > Regards, > Adrien > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Chris Green Transaction Report From 01/01/23 to 31/12/23 Date Num Description Memo/Notes Transfer from/to Debit Credit Lloyds 01/01/23 Lloyds Current [1]�1,934.97 03/01/23 Risdales Regular Giving [2]�20.00 03/01/23 000531 David Cope, remove branch Maintenance [3]�25.00 11/01/23 Electricity, British Gas Utilities [4]�59.35 12/01/23 Scarfe Trust Payments to/from Building Account [5]�750.00 18/01/23 Vicar's expenses, invoice 368 Vicar [6]�32.85 18/01/23 500915 Collection, 18th Dec 2022 Collections [7]�64.90 18/01/23 500915 Collection, 24th Dec 2022 Collections [8]�156.52 18/01/23 500915 Collection, 15th Jan Collections [9]�108.20 18/01/23 500915 Green, rounding up donation Other Donations [10]�2.38 18/01/23 500915 Donation box Offertory Box [11]�8.00 20/01/23 Ronald Arthur Pomr Funeral Fees [12]�224.00 23/01/23 Quota for Diocese Quota for Diocese [13]�300.00 27/01/23 Extra to fulfil 2022 quota Quota for Diocese [14]�285.00 30/01/23 An - unclear Fees [15]�282.00 01/02/23 Gaussen Regular Giving [16]�180.00 02/02/23 Risdales Regular Giving [17]�20.00 06/02/23 Electricity, British Gas Utilities [18]�96.41 09/02/23 Peter Smith funeral Fees [19]�141.00 15/02/23 000530 J. Dundas, gutter cleaning Maintenance [20]�150.00 20/02/23 Donation to Crisis at Christmas Donations [21]�78.00 22/02/23 Quota for Diocese Quota for Diocese [22]�300.00 22/02/23 Stewardship Regular Giving [23]�120.00 02/03/23 Risdales Regular Giving [24]�20.00 03/03/23 Ride and Stride Other Donations [25]�25.00 03/03/23 Electricity, British Gas Utilities [26]�29.27 06/03/23 000532 David Cope, mowing Maintenance [27]�230.00 08/03/23 500916 Carol singing Payments to/from Building Account [28]�35.00 08/03/23 500916 Collection, 19th Feb Collections [29]�
Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)
On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote: > Chris, > > Once again, look into Edit > Stylesheets. > > For the record, I'm using defaults, and the is 12pt > bold and the lines are 10pt normal weight. The total lines > match the . > On my GnuCash (version 4.8 on Linux) there isn't a separate setting for the , it's the same size as 'Text Cell'. Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the individual transaction descriptions etc.) as well as the account title. There are no references to 'transaction' or 'name of account' in my stylesheet settings. Is this something that has been changed since version 4.8? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Setting font sizes in reports (specifically in Transaction Report)
Maybe I have set something somwhere without knowing it but the font sizes for headings in the Transaction Report seem odd to me. Each account is shown as follows:- ... ... Total for The oddity is that the uses the same font size as the list of transactions below it. The 'Total For ' is in a large, bold, typeface which makes sense. The at the top of each account needs to be in at least the same size as the 'Total For ' at the bottom. Have I configured something somewhere that has lost the large size for the heading and/or is there an easy way to change this please. I'd prefer something that will fix things every time I create a new transaction report rather than having to edit every report after creating it. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: > Chris > > Are you "printing to file" or are you doing something else? As Adrien has > pointed out, you have not really given us enough info to help you. > I tried various ways. > > If you provide all info on the OS system & the version of GnuCash you are > using & steps you have taken, you might just find a GnuCash user on this > list who can help you more directly. > It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. However I have spotted my basic problem, opening a PDF file with libreoffice opens it in lodraw and thus it *looks like* I have a PDF with images. I don't seem to be able to force libreoffice to open a PDF in lowriter. I have managed a way round this now, pandoc will convert from HTML directly to an loffice ODT file which gets me to the result I want, a report I can edit reasonably easily in lowriter. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can > pull it off. > Which PDFs? All the ones I have produced are images. What's the 'standard' route from a GnuCash report to PDF (on Linux, so LibreOffice etc. are here by default). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote: > > Additionally, there are pdf editors out there that do a good job (some are > cross-platform) - my pdf's produced from GnuCash are all editable (I use > Linux) - not graphic images - maybe look for another driver/app to achieve > what you need? This is what I'm after. I'm all Linux based but so far whatever route I take to get from GnuCash's HTML to PDF I end up with a PDF file with images rather than text in it. What do you use to convert to PDF? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 02:16:57PM -0600, Adrien Monteleone wrote: > You can also select-all and copy/paste into a spreadsheet while viewing > any report. > You are a glutton for punishment!!! Who on earth would try to make a report 'look nice' (which is what I'm trying to do) using a spreadsheet!?? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 02:16:27PM -0600, Adrien Monteleone wrote: > The standard export/save of reports is an HTML table. > > You can edit that with any decent text editor, and/or open/import it > into a spreadsheet app for further manipulation. > Editing HTML is *NOT* my favourite occupation. Any other format, whether markup of some sort or word-precessor is infinitely better. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to get a report in a format which is easy to edit?
Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I always end up with a PDF file made up of images which is quite useless for editing. I want to be able to change the size and typeface of some of the entries. Surely there's a way to get an edtable report!? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "Make PDF" button just prints
On Tue, Jan 16, 2024 at 12:55:00PM -0600, Adrien Monteleone wrote: > On 1/16/24 8:05 AM, Chris Green wrote: > > I'm running Gnucash 5.3 on xubuntu linux. > > > > The "Make PDF" button on the toolbar just does exactly the same as the > > "Print" button, it calls up the standard printer dialogue. > > > > How can I get a report output as a PDF file? > > > I think that has something to do with the mess of Webkit versions > between Mac, Win, & *nix. If I recall correctly, the button was left for > a future fix, but set to bring up the printer dialog for now which can > then use the system PDF 'printer'. Since all three operating systems now > have this feature, I'd say the button should either invoke it directly, > or the button should be removed. (those on older Windows systems can > still use a 3rd party 'printer' like Bullzip) > Ah, I see, thanks. Yes, I would agree that removing the button would make sense as it's somewhat confusing when it just brings up the print dialogue. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash 5.3 always gives me an dbind error at startup
On Tue, Jan 16, 2024 at 09:10:16AM -0800, john wrote: > > > > On Jan 12, 2024, at 13:09, Chris Green wrote: > > > > I recently upgraded my laptop to xubuntu 23.10 and that also upraded > > gnucash to version 5.3. > > > > Now, every time I start Gnucash I see the following error:- > > > >chris$ gnucash -v > > > >(gnucash:102770): dbind-WARNING **: 17:48:49.556: Couldn't connect > > to accessibility bus: Failed > > to connect to socket /root/.cache/at-spi/bus_0.0: Permission denied > >GnuCash 5.3 > >Build ID: 5.3+(2023-06-26) > > > > So, why is it trying to create/connect to a socket in /root? It's > > bound to get a permission error. > > > > It seems to run OK in spite of this. > > That message is from Gtk and indicates that the packager for Gtk screwed > something up. You can either ignore the problem or raise a bug with Ubuntu. > OK, thanks, I'll ignore it! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Gnucash 5.3 always gives me an dbind error at startup
I recently upgraded my laptop to xubuntu 23.10 and that also upraded gnucash to version 5.3. Now, every time I start Gnucash I see the following error:- chris$ gnucash -v (gnucash:102770): dbind-WARNING **: 17:48:49.556: Couldn't connect to accessibility bus: Failed to connect to socket /root/.cache/at-spi/bus_0.0: Permission denied GnuCash 5.3 Build ID: 5.3+(2023-06-26) So, why is it trying to create/connect to a socket in /root? It's bound to get a permission error. It seems to run OK in spite of this. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] "Make PDF" button just prints
I'm running Gnucash 5.3 on xubuntu linux. The "Make PDF" button on the toolbar just does exactly the same as the "Print" button, it calls up the standard printer dialogue. How can I get a report output as a PDF file? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Idiot 101 question
On Mon, Jan 15, 2024 at 10:27:24PM -0600, David Carlson wrote: > I would recommend taking a few weeks learning how VM's work before doing it > yourself,but for a person knowledgeable about VM's it would be > straightforward if you can install or otherwise attach a physical drive to > your computer then configure a VM to use it as it's primary drive. I > recommend having a knowledgeable friend do it. I have been 'playing' with > VM's for a couple of years now and I have been burned several times while > learning how they work. I still do not do anything serious solely in a VM. > The only good reason I have found for using a VM is to allow me to run old versions of Windows (XP in particular) in a relatively 'safe' environment such that they won't get invaded/corrupted by intruders. In my case now the only remaining thing that runs on my XP virtual machine is some Epson scanner software. Otherwise it's almost always easier to do things on a 'real' machine, the virtual machine environment just introduces another layer of possible issues. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Some questions about the Account Summary Report
I have just started using the Account Summary Report as an easy way to give an overview of the church finances to the PCC members. There's a couple of things I can't quite understand though, especially about the alignment of the columns and the values that appear in them. The following depends on fixed width fonts to show correctly. I see, for example. at the top of the report:- Account CodeAccount title Balance Assets£0.00 Current Assets £0.00 Lloyds £9,999.60 Income£0.00 Collections £1,111.11 Fees £2,222.22 ... .. Why is the amount for 'Lloyds' further left than the other amounts? Is it simply because it's a lower level sub-account? What is the meaning of the £0.00 against Assets, Income, etc. One would have expected that the value against Income would be the total of all the Income sub-accounts. Have I got something wrongly configured? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Today's search....for .lck
On Sun, Aug 06, 2023 at 10:58:55AM -0500, Adrien Monteleone wrote: > On 8/6/23 6:28 AM, Chris Green wrote: > > > At least someone agrees with me! :-) > > > > I've been muttering about this, on and off, for quite a while! There > > should be a way to move the clutter of logs and backup files out of > > the way, away from where the main GnuCash xml or database file is. > > (By 'move' I mean a configuration option that allows one to keep them > > out of the way, I know files can be moved 'by hand') > > > > I can see the benefit to having logs and backup files together with the > data, but I'd prefer if they were in their own sub-directories > automatically. > Yes, exactly! :-) I use GnuCash as treasurer of a PCC (Parochial Church Council). I have a sub-directory on my system called (very originally!) pcc and that has a further sub-directory for each year. So, in the ~/pcc/2023 directory I have the GnuCash database file, and various other items like correspondence, the odd PDF file from the diocese and so on. Having all the GnuCash log files and such cluttering up the directory is a nuisance. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Today's search....for .lck
On Sun, Aug 06, 2023 at 01:23:33PM +0200, Mahon Finbar via gnucash-user wrote: [snip] > > With the greatest of respect, I have always found the plethora of files > that appear around Gnucash locations hard to decipher. I'm sure there is > a reason for that, but. > At least someone agrees with me! :-) I've been muttering about this, on and off, for quite a while! There should be a way to move the clutter of logs and backup files out of the way, away from where the main GnuCash xml or database file is. (By 'move' I mean a configuration option that allows one to keep them out of the way, I know files can be moved 'by hand') -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
On Sat, Jul 29, 2023 at 09:59:37AM -0700, john wrote: > For bug-filing instructions see > https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones. > > > > Chris Green and G R Hewitt, what OS/distro are you running and how did you > install GnuCash? > I'm running [x]ubuntu 22.04 and 23.04 with GnuCash versions 4.13 and 4.8 respectively, the text entry issue feels much the same on both. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
On Sat, Jul 29, 2023 at 09:28:40AM +0100, G R Hewitt wrote: > On Sat, 29 Jul 2023 at 09:03, Chris Green wrote: > > > On Fri, Jul 28, 2023 at 10:48:37PM -0400, AgedLace wrote: > > > Hello, > > > > > > Recently, I've been having a problem entering Descriptions for my > > > transactions. > > > > > > At first, I could only enter 3 characters, then it would lock up. > > > > > > Now I can only enter 1. > > > > > > All other fields seem to be working just fine. The only field I'm > > > having difficulties with is the Description. > > > > > > I'm using Manjaro an Arch Linux based operating system. The version in > > > the official repository is 5.3-1. > > > > > > I have tried uninstalling / reinstalling with no success. > > > > > > I have spent a great deal of time searching for a way to fix this issue, > > > but have not even seen someone else having the same issue. > > > > > There's something a bit odd about how GnuCash handles text entry in > > all fields. I think it's due to the way it auto-fills the field when > > you enter just one or two characters. > > > > On my system most of the issues occur with the Transfer column, it > > sometimes locks up in the same way that you're describing for the > > Description field. > > > I have the same problem, but so far, only when entering 'tes' for 'Tesco', > when it just freezes. > I wait a few seconds then click in the line above, then back to the > original and it > works. > Yes, that's a good description of what happens. One can usually 'retreat' and try again and make it work but it's still rather annoying. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
On Fri, Jul 28, 2023 at 10:48:37PM -0400, AgedLace wrote: > Hello, > > Recently, I've been having a problem entering Descriptions for my > transactions. > > At first, I could only enter 3 characters, then it would lock up. > > Now I can only enter 1. > > All other fields seem to be working just fine. The only field I'm > having difficulties with is the Description. > > I'm using Manjaro an Arch Linux based operating system. The version in > the official repository is 5.3-1. > > I have tried uninstalling / reinstalling with no success. > > I have spent a great deal of time searching for a way to fix this issue, > but have not even seen someone else having the same issue. > There's something a bit odd about how GnuCash handles text entry in all fields. I think it's due to the way it auto-fills the field when you enter just one or two characters. On my system most of the issues occur with the Transfer column, it sometimes locks up in the same way that you're describing for the Description field. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash 'Help' returns "Dcoument not found" but I have gnucash-docs installed
On Wed, Jul 26, 2023 at 12:29:18AM +0200, Frank H. Ellenberger wrote: > > > I seem to recall reading in these lists that it's a matter of Linux putting > > the documents in a different place than where GnuCash is looking... I'm > > assuming that there is a way to fix this with a symbolic link (or links), > > but I don't recall the locations offhand. > > GnuCash is using Gnome's help browser Yelp under Linux. > 1. yelp changed its protocoll from ghelp:DOCUMENT which was stored below > /usr[/local]/share/gnome/help/DOCUMENT/LANG/, > to help:DOCUMENT below /usr[/local]/share/help/LANG/DOCUMENT/ > 2. After we realized that we adjusted gnucash's call of yelp. > 3. Later we renamed gnucash-help to gnucash-manual. > > So search your /usr for a directory gnucash-guide. > You can always call > yelp PARh/TO/DOCUMENT > from a command line, > > To use the abbreviating protocoll you have to check, if the docs are > stored where the protocoll, which your yelp version understands, expects > them. > Thanks Frank, I use xubuntu rather than ubuntu but yelp is in xubuntu even though it's not really Gnome. I should be able to sort things out with your information above. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to split an existing account into two sub-accounts?
On Tue, Jul 25, 2023 at 10:58:37AM -0500, Adrien Monteleone wrote: > On 7/25/23 4:27 AM, Chris Green wrote: > > Is there an easy way to take an existing account and make it into two > > sub-accounts and, at the same time, move transactions in the account > > to one of the sub-accounts. > As for 'moving' some of the transactions in the original to its new > sibling - simply change the transfer account for those transactions. > They will disappear from the working register and appear in the register > for the sibling. > You can of course also use the Cut and Paste actions in the Transaction menu. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to split an existing account into two sub-accounts?
On Tue, Jul 25, 2023 at 10:31:23AM +0100, Paul Feakins wrote: > On 25/07/2023 10:27, Chris Green wrote: > > Is there an easy way to take an existing account and make it into two > > sub-accounts and, at the same time, move transactions in the account > > to one of the sub-accounts. > > You're thinking about it in a very strange way. > > 1. Make an account at the same level. > 2. Make that account the parent of the account you talk about "splitting". How do I do that? I tried drag of the account I want to become a sub-account but that didn't work. OK, I've got it, it's in the 'Edit Account' you can select the parent account. > 3. Make another account at the same level. > Thank you, job done! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to split an existing account into two sub-accounts?
Is there an easy way to take an existing account and make it into two sub-accounts and, at the same time, move transactions in the account to one of the sub-accounts. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Accounts which are both Income and Expense accounts
On Mon, Jul 24, 2023 at 06:08:00PM +0100, Fred Bone wrote: > On 24 July 2023 at 16:53, Chris Green said: > > > Is there a 'right' way to handle an account which gets payments in two > > directions? > > > > E.g. I have good relations with a friend and we often buy things for > > each other and settle up at the end of the month. Sometimes I owe the > > friend some money, other times the friend owes me some money but it's very > > definitely one account and one wants to see all the payments in one place. > > > > I guess one can just say it's an 'Expense' account and make payments > > in either direction as required, is this the only way or is there a > > special name for such an account? > > It's an Asset or Liability (two sides of the same coin, in a sense) at > your choice, depending mainly on which way you expect the balance to be > in the long run. > > I have an account > Assets -> Debtors & creditors > where I record this sort of thing, relating to various different > individuals (typically the odd couple of quid every few weeks). If I had > one particular acquaintance generating a lot of this activity I'd run a > sub-account for that acquaintance. > > The "Expense" is the other side of the transaction recording what the > oney was owed for, and might vary according to whether the expenditure > was a round in the pub or dinner at a local restaurant. > > When (if) you actually settle up, the other side of *that* txn is of > course your bank account, cash in hand, or whatever. > That sounds extremely sensible and easy to implement, thank you! -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Accounts which are both Income and Expense accounts
Is there a 'right' way to handle an account which gets payments in two directions? E.g. I have good relations with a friend and we often buy things for each other and settle up at the end of the month. Sometimes I owe the friend some money, other times the friend owes me some money but it's very definitely one account and one wants to see all the payments in one place. I guess one can just say it's an 'Expense' account and make payments in either direction as required, is this the only way or is there a special name for such an account? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 'Help' returns "Dcoument not found" but I have gnucash-docs installed
I'm running GnuCash 4.8 on [x]Ubuntu 22.04.2, I have gnucash-docs installed as well as the gnucash and gnucash-common packages but when I click on things in the Help menu I just get "Document not found". So, how do I get the help to work? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Another try at "How to record payments for several items paid with a single transaction?"
Thanks both for the 'how to do it' for split transactions. I'm getting there slowly! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Another try at "How to record payments for several items paid with a single transaction?"
On Mon, Jul 24, 2023 at 11:06:26AM +0100, Maf. King wrote: > On Monday, 24 July 2023 10:38:35 BST Chris Green wrote: > > Maybe I should put this a different way, the answers so far don't seem > > to quite address my question, probably because I'm not describing what > > I'm trying to do. > > > > So, very simply, say I am buying sweets in a shop and I select:- > > > > One bar of chocolate0.99 > > Two bags of pear drops 1.50 > > Chewing gum 1.00 > > > > Then I pay the shopkeeper 3.49 > > > > > > I want to record this in GnuCash in a way that shows that it is a > > single transaction debiting 'cash in my pocket' and crediting > > 'shopkeeper' but I want to detail the items making up the transaction. > > > > How do I do this? > > Erm... 4 splits? 3 to Expenses:Sweets and one to CashInPocket. then for > the > register, ensure View as... something not auto-expanding splits. > > Will truthfully say that I have not followed the thread so far. > I've yet to work out how to actually enter a split transaction in a sane way. I just spent several minutes trying to enter a split transaction for something like the above and failed miserably. Can someone run me through how to do this, i.e. enter something like the above where there are three items making up a single transaction from 'cashInPocket' to 'shopkeeper'. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Another try at "How to record payments for several items paid with a single transaction?"
Maybe I should put this a different way, the answers so far don't seem to quite address my question, probably because I'm not describing what I'm trying to do. So, very simply, say I am buying sweets in a shop and I select:- One bar of chocolate0.99 Two bags of pear drops 1.50 Chewing gum 1.00 Then I pay the shopkeeper 3.49 I want to record this in GnuCash in a way that shows that it is a single transaction debiting 'cash in my pocket' and crediting 'shopkeeper' but I want to detail the items making up the transaction. How do I do this? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Sun, Jul 23, 2023 at 11:05:24AM +0100, Michael Hendry wrote: > On 23 Jul 2023, at 10:03, Chris Green wrote: > > > > >> > > > Petty Cash is also used in the UK for this. > > …but is primarily a mechanism used for staff to make small purchases of > office sundries where setting up an account with the vendor is unnecessary > and it’s not appropriate for the member of staff to have a company cheque > book or credit card. > That's what I meant. We use the term Petty Cash in the UK in much the same way as it seems to be used in the USA. > > > > > In reality (as in my reply just now) I only record deposits once a > > month or so. However there is of course nothing at all to prevent me > > putting the actual date of the service where the money was collected > > for the entry in the Assets:Current:Cash account. > > > > However I'm still not quite clear how the various accounts work > > together. At present I have Assets, Equity, Expenses and Income top > > level accounts. Income is split into such things as Collections, > > Offertory Box, Fund Raising, etc. > > > > If I add an Assets:Current Assets:Cash to record the various amounts > > from collections, offertory box, etc. before they are deposited how do > > they then get recorded as Income when the cash is moved from Assets: > > Current Assets:Cash to Assets:Current Assets:Bank ? > > You should record the cash income from the various collections etc to the > Assets:Current Assets:Cash via the appropriate Income: account as you receive > it (or as you count up the cash in the bags), preferably with the date > on which the collection took place. When you eventually come to make the > deposit into your current bank account, this is simply recorded as a transfer > between two asset accounts - it is no longer income, any more than paying > off your credit card bill from your current account needs to be accounted > for as Expenditure (in this case you are transferring money from an asset > account (your bank) to a liability account (your credit card). > So I need two sets of Income sub-accounts then. One records the cash deposits into Assets:Current Assets:Cash and the other ones record donations made direct to Assets:Current Assets:Bank. People don't use cheques any more here (well, very rarely) so there's no parallel Assets:Current Assets:Cheques awaiting deposit. The most important thing from my point of view is the ability to present accounts to the diocese where all donations of a particular type are collected together. The above would seem to make it difficult to show, for example, all money made for a fund raising event where some is cash and some is paid direct by donor to the church bank account. I need a single sub-account where I can see *all* money of a particular type regardless of how it got there. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Sun, Jul 23, 2023 at 12:02:25PM +0100, Fred Bone wrote: > On 23 July 2023 at 9:34, Chris Green said: > > [...] > > I simply want to be able to able to have (conceptually) a multi-line > > entry in the income sub-account called 'Collections at services' which > > records two (or maybe more) amounts of cash paid in at one time. > > But aren't you supposed to record each collection separately for GASDS > purposes? What happens if the two weeks are in different tax years? > This is in the UK, no requirement like the above for us. > AIUI you should be counting each bagged-up collection separately. It's > then a simple matter to record it as a txn from "Collection Income" to > "Money awaiting deposit", plus (I assume) another from "Envelope Income" > (or is it someone else's job to reconcile envelope contents against > people's promises?). > > Then at pay-in-to-the-bank time, you have one txn from "Money awaiting > deposit" to "Bank". > > This ensures that your books record what happened when, which is after > all the whole point. > > If I were doing it, I'd keep separate "Cash awaiting deposit" and > "Cheques awaiting deposit" subaccounts, but that's probably not > essential. It would, however, make it easier to double-check the figures > on the paying-in slip, which I why I adopt that approach in my role as > area treasurer of a small charity. > Yes, but do I as a result have to have separate 'Income' sub-accounts in both the "Money awaiting deposit" and the "Current Account" accounts? If so it makes collecting all the income more messy if nothing else. In reality we get very few cheques nowadays, people either give cash in collections at services (or put in the offertory box) or they pay donations direct into the church's bank account from their bank accounts. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Sat, Jul 22, 2023 at 06:03:33PM -0700, Stan Brown wrote: > > > > On 2023-07-22 13:45, Michael Hendry wrote: > > Record the collections individually as Assets:Current Assets:Cash received > from the appropriate Income: account, one on the 22nd July, the second > on the 29th. > > With this I think we all agree. I do, certainly. > > > When you come to deposit the cash in the current account the cash> moves > from Assets:Current:Cash to Assets:Current:Bank - the original > > sources of the cash aren’t relevant at this point. > > The same applies to Cheques Received - the reason the cheque was > received is recorded as it is received, and a bunch of cheques can be > paid into the current account without having to specify what the cheques > are for. > > Or perhaps both cash and checks could go into a single account, > Assets:Deposits Pending. That would perhaps save confusion with a > different Cash account, Petty Cash (American name for cash on hand > intended for making small purchases). > Petty Cash is also used in the UK for this. In reality (as in my reply just now) I only record deposits once a month or so. However there is of course nothing at all to prevent me putting the actual date of the service where the money was collected for the entry in the Assets:Current:Cash account. However I'm still not quite clear how the various accounts work together. At present I have Assets, Equity, Expenses and Income top level accounts. Income is split into such things as Collections, Offertory Box, Fund Raising, etc. If I add an Assets:Current Assets:Cash to record the various amounts from collections, offertory box, etc. before they are deposited how do they then get recorded as Income when the cash is moved from Assets: Current Assets:Cash to Assets:Current Assets:Bank ? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Sun, Jul 23, 2023 at 10:12:05AM +1000, Liz wrote: > On Sat, 22 Jul 2023 17:56:09 +0100 > Chris Green wrote: > > > But what if one has cash from two collections to go to the same > > account. I.e. a collection on 22nd July and a collection on 29th > > July both paid in at the same time? > > One way of doing this is with an intermediate account. You take the > cash from 22nd July and put it in the intermediate account, which could > be called "undeposited funds" or "cash on hand". You do the > same with the cash from 29th July. On banking day you put the cash from > the cash tin in the bank, and move it in your books from the > intermediate account to the bank account. > > Summary > Physical movement of funds > > collection > count done > cash tin > 2nd collection > count done > cash tin > count done again > > cash tin > bank (and another count) > > Recorded movement of funds > collection > cash on hand > 2nd collection > cash on hand > cash on hand > bank > What sort of account would the 'intermediate' account be? It's not an 'income' because money from it doesn't go straight to the bank account. I guess it could be called an Asset. In fact I suppose an Asset account called 'Cash in Hand' would make some sense. The reality is that I only count up the money every month or so, we only have one service every two weeks, it's a very small community with a dearth of people available to take services. The Church Warden bags up the collections teken at the services and also the contents of the offertory box. Then, at the end of the month, as and when I have time, I unbag the money, add it all together to check the Church Warden's sums (always correct!) and take it to the Post Office or bank to deposit it. What I want is a way to record in the 'Collections' and separate 'Offertory Box' income accounts the amounts for the collections at services and from the offertory box. These all arrive in the bank account as a single transaction. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Sat, Jul 22, 2023 at 05:50:47PM -0400, Michael or Penny Novack wrote: > > > But what if one has cash from two collections to go to the same account. > > I.e. a collection on 22nd July and a collection on 29th July both > > paid in at the same time? > > > First of all, you are perhaps confusing when money/cash/check received > with when deposited. > > Let's say the following events: > > a) 7/14 check $100 for building fund > > b) 7/15 check $50 general donation > > c) 7/16 collection plate$47.45 > > d) 7/17 deposited these checks and cash to the bank account > > The ley thing to keep in mind is that the bank deposit date has nothing > to do with when "cash" was received. There are FOUR separate events > here, three receipts of cash (if normally no "cash box" might call tat > account "undepositied funds") and each of these credited to the > appropriate income account and then a fourth transaction transferring > the undeposaited funds to the bank account. > > Is the source of confusion that you are e=required to list each check > separately on the deposit ticket? THAT has nothing to do with your books > (nor is it reflected in your bank statement. Think of that as just > rechecking your sums. > I suspect you are suggesting that there should be an account called 'cash in hand' or something similar. That doesn't exist and isn't going to exist, for my trivially simple accounting system (which satisfies both the accountant and the Diocese) it just complicates things. I simply want to be able to able to have (conceptually) a multi-line entry in the income sub-account called 'Collections at services' which records two (or maybe more) amounts of cash paid in at one time. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record payments for several items paid with a single transaction?
On Fri, Jul 21, 2023 at 10:17:12AM +0100, Michael Hendry wrote: > Hello again Chris. > Hi! :-) > Comments inserted below: > > On 21 Jul 2023, at 09:09, Chris Green wrote: > > > > > I quite often seem to have cases where several 'items' (see below for > > the type of thing I mean) are paid for with a single payment to/from a > > bank account. What is a good way to record this sort of thing? > > I use separate accounts for recording cash and cheques received > (Assets:Current > Assets:Cash and Assets:Current Assets:Cheques). This allows for several > different items to be recorded in the appropriate income accounts - with > splits if (e.g.) a cheque is received for more than one income account. > But what if one has cash from two collections to go to the same account. I.e. a collection on 22nd July and a collection on 29th July both paid in at the same time? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to record payments for several items paid with a single transaction?
I quite often seem to have cases where several 'items' (see below for the type of thing I mean) are paid for with a single payment to/from a bank account. What is a good way to record this sort of thing? Examples:- I pay in money (cash) from collections and other donations. These need to be recorded as separate items but end up as a single deposit to the bank account. At present I manage these by entering them as separate transactions but with the same deposit slip number in the 'Num' column in GnuCash. Is there a better way? I pay money from (say) a savings account to a current account to cover several payments (to one supplier) from the current account. Similarly the payment from the current account may be a single payment to cover several invoices. How should one record these? I want to be able to see how the single payment is made up from several items but also show that it was a single transaction. There isn't a 'Num' to use in the second case above, this isn't a cheque payment, it's an online transaction so there's no (easy) way to identify it really. Would a split transaction work for this? However I thought split transactions are for joining together payments to 'different' places rather than joining together several payments to and from the same places. Any/all help would be very welcome. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reply convention
On Tue, Jul 18, 2023 at 03:28:34PM -0500, R Losey wrote: > On Mon, Jul 17, 2023 at 3:37 AM Paul Feakins wrote: > > > On 15/07/2023 01:56, R Losey wrote: > > > Is there really a convention for replies? > > > > Indeed there is: > > https://wiki.openstack.org/wiki/MailingListEtiquette#Replies > > > > > Thanks for the link; it isn't specific to GnuCash, but that's okay. > > However, it does seem outdated - limiting a line to 72 characters when most > browsers and email clients are capable of doing line wrap? > Yes, but eyes aren't! Something around 80 characters (i.e. 72 plus a bit) is the best line length for our eyes to read. > And plain text only? > What else are you going to do? Anything more is likely to be differently interpreted by different users' software so the result you intend is likely to be lost on many users. There are standard ways of indicating emphasis and such using just plain text. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Two Instances as opposed to two separate files
On Sat, Jul 15, 2023 at 10:58:27AM +0100, Michael Hendry wrote: > On 14 Jul 2023, at 13:24, Chris Green wrote: > > > > > On Fri, Jul 14, 2023 at 01:06:36PM +0100, Maf. King wrote: > >> On Friday, 14 July 2023 12:34:28 BST Fross, Michael wrote: > >>> I run multiple instances at the same time, but you have to open different > >>> data files. I’d keep them in different directories to be tidy. > >>> > >> > >> I don't do it often, but have had occasion to have GC side-by-side on 2 > >> data > >> files at the same time. > >> > >> What I have done is start a 2nd instance of GC, let it warn me that the > >> data > >> file is in use already, select open read-only then file-> open to the > >> second > >> data file. (I have 6 in regular use). But I'm on Linux, don't know it > >> that > >> would work the same on any WinOs flavour. > >> > >> Agree 100% about keeping each data file in its own sub-directory, and > >> about not > >> changing prefs while 2 instances are running! > >> > > I have quite a lot of separate GnuCash 'instances' where 'instance' > > means a GnuCash data file (Sqlite database in my case). > > Ah, I was thinking that by “instance” you meant a running copy of GNC with > its own GNC file. Unless you are running each instance as a different user, > my understanding is that you’re risking cross-contamination of configuration > settings, as GNC is a one-file-at-a time product. > I occasionally run two copies of GnuCash and there don't appear to be any significant issues when I do this. It's quite a rare occurrence though as, with small (one year only) database files a GnuCash instance starts very quickly so I just start and stop them as required. > > > > I am a PCC (Parochial Church Council) treasurer, this requires me to > > submit audited accounts to the Diocese each year. It also requires > > separate accounts for 'restricted' and 'unrestricted' funds. > > Restricted funds are those donations which have been specifically > > given for the upkeep of our church building as opposed to being used > > for general expenses. > > > > I thus keep separate GnuCash data files for 'restricted' and > > 'unrestricted' in each financial year. With a little bit of simple > > scripting (this is Linux) I can go to any year's dirctory and simply > > enter 'gnc' to see that year's current/unrestricted accounts and 'gnb' > > to see the building/restricted accounts. I never have to mess about > > changing the dates on reports to see different years, I never have to > > explicitly specify which data file to use (because it's in the > > directory for the year I'm looking at). > > I can see disadvantages in this approach (which I couldn’t use on my Mac > anyway!) > > 1. Assuming you create a new data file for each each unrestricted and > restricted > account each year, you lose the prompts for recurrent transactions (e.g. > Payment to The Corner Shop from the current account to the Expenses:Tea, > Milk and Biscuits account). Yes, but it's hardly a big loss. One only has to re-enter a repeated item once a year! > 2. Similarly, you lose the capacity to produce multi-year balance sheet > and income & expenditure reports to compare the most recent year’s > performance > against previous years. We (or the Diocese) have absolutely no need for multi-year reports. Anyway it's hardly more difficult to produce a balance sheet for 2021 and a balance sheet for 2022 and compare them. Plus I never have to change start and end dates for reports, for a particular year they are cast in stone for all reports. > 3. If you start to use the new data files immediately the new year begins, > you have to enter starting balances for the accounts. If you discover you’ve > missed an entry in the previous year, made an incorrect entry, or have > issued a cheque which has not been cashed by the year end, you have to > remember to adjust for all of these (which would certainly be a problem > in my case). With 'cash accounting' it's trivial to ensure the end of year figures are correct, they **must** be the same as the bank statement for 31st December. Similarly uncashed cheques simply don't appear, a cheque payment only appears in the accounts when it is actually debited from the bank account. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Two Instances as opposed to two separate files
On Fri, Jul 14, 2023 at 01:06:36PM +0100, Maf. King wrote: > On Friday, 14 July 2023 12:34:28 BST Fross, Michael wrote: > > I run multiple instances at the same time, but you have to open different > > data files. I’d keep them in different directories to be tidy. > > > > I don't do it often, but have had occasion to have GC side-by-side on 2 data > files at the same time. > > What I have done is start a 2nd instance of GC, let it warn me that the data > file is in use already, select open read-only then file-> open to the second > data file. (I have 6 in regular use). But I'm on Linux, don't know it that > would work the same on any WinOs flavour. > > Agree 100% about keeping each data file in its own sub-directory, and about > not > changing prefs while 2 instances are running! > I have quite a lot of separate GnuCash 'instances' where 'instance' means a GnuCash data file (Sqlite database in my case). I am a PCC (Parochial Church Council) treasurer, this requires me to submit audited accounts to the Diocese each year. It also requires separate accounts for 'restricted' and 'unrestricted' funds. Restricted funds are those donations which have been specifically given for the upkeep of our church building as opposed to being used for general expenses. I thus keep separate GnuCash data files for 'restricted' and 'unrestricted' in each financial year. With a little bit of simple scripting (this is Linux) I can go to any year's dirctory and simply enter 'gnc' to see that year's current/unrestricted accounts and 'gnb' to see the building/restricted accounts. I never have to mess about changing the dates on reports to see different years, I never have to explicitly specify which data file to use (because it's in the directory for the year I'm looking at). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record 'balancing' trnsactions?
On Wed, Jul 12, 2023 at 02:51:39PM -0700, Vincent Dawans wrote: > Leaving aside the why you need 2 sets of books, I'll just focus on the how. > > First you need to decide if the money in and money out really needs to be > classified as income and expenses in your first set if books (the main bank > account) or can more simply be treated fully as pass-through. If fully > pass-through, then the following... > > *For example we might have 'income' into the current account as* > *follows:-* > *Scarfe Trust for roof 750.00* > *Talk and Tea collection 205.00* > *Tea concert 410.00* > *Carol singing35.00* > > Is not recorded as income in your main book but instead as a liability > towards the building fund. So you create a building fund account under > liability and when your receive money for the building fund you debit your > bank account and credit that liability account. Then when you are ready to > write a check for the building fund, you look at the balance in that little > account and write the check for that amount. When the check is cashed it > will come as a credit on your bank account and a debit on the liability > account. That liability account becomes a sort of running ledger you can > provide showing money collected then transferred to the building fund over > time. > > On the building fund side, you can either book the money coming in as > income directly on the date received from the main account, or if you want > the detail of all the original transactions, then create a receivable > account under assets with the same detailed transactions from the other > side booked against income, then that gets zeroed when the check is > deposited. > > The opposite movements then are made for payments from the building fund to > the main accounts of needed. > Thank you Vincent, I think you have outlined an approach that will work for me. I will start trying it out and see how things go. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record 'balancing' trnsactions?
On Wed, Jul 12, 2023 at 04:56:23PM -0400, Michael or Penny Novack wrote: > On 7/12/2023 8:12 AM, Chris Green wrote: > > This is as much an accounting question as a GnuCash one but how one > > does this depends on the sofware's capabilities so it makes sense > > to ask here. > > > > Our church has two main accounts (as in places where money is kept), a > > current account at a bank, and a 'building fund' kept in a building > > society savings account. > > > > I run two separate instances of GnuCash, one for the current account > > and one for the building fund. Both of these are run on a 'cash > > accounting' basis so the balances in GnuCash exactly match the > > statements from the bank and building society. > > Let's assume that there is a good reason to have separate books << I can > think of a number* -- keep in mind that I was treasurer of several > organizations >> In other words, there might be no good reason for this > church but might for another. > > a) Yes, there can be errors going between the books. So you want to > minimize the number of between the books transactions. See if there > could be a transfer only of "net" every so often > > b) You will need to use some thought for the accounts you will want to > contain parts of transactions that pertain to the other entity. > > > Michael D Novack > > > > * For example, a quasi independent org/fund is legally under a parent > 501(3)3. The treasurer of the org/fund has to report certain things to > the treasurer of the 501(c)3 and there may actually also be money > transferred between them (they may be collecting money on each other's > behalf and making payments on each other's behalf. But do you not see > that no matter how many such transactions in a month need only one money > transfer between them and one report per month (assuming getting things > right between these entities once a month) > Thank you, you have described the issue exactly! :-) It's your b) that prompted me to ask the question, do you (or anyone) have any good insights into how to handle this? Whether or not this is done with only one GnuCash instance or with two the difficulty is still there as I see it. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record 'balancing' trnsactions?
On Wed, Jul 12, 2023 at 02:25:33PM +0100, Paul Feakins wrote: > On 12/07/2023 13:55, Chris Green wrote: > > On Wed, Jul 12, 2023 at 01:19:41PM +0100, Paul Feakins wrote: > >> Why would you have 2 separate instances of GnuCash rather than simply 2 > >> Asset accounts? > >> > > Why not? :-) > > > > I see no advantage in having everything in one. > > Because the Church is one entity and it owns both accounts? > That's not an advantage. > Because GnuCash is designed to handle multiple Asset accounts? > That's not an advantage. > Because opening 2 instances is more complicated than opening just one? > That might be regarded as an advantage but I don't see it really. Having separate instances means that I know which transactons go where. If I'm using the current account gnucash then only bank transactions go there. Same for the other. > Because a transfer from one account to the other would be easier in the > same instance? > Why? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record 'balancing' trnsactions?
On Wed, Jul 12, 2023 at 04:41:27PM +0100, Paul Feakins wrote: > On 12/07/2023 16:35, Chris Green wrote: > > On Wed, Jul 12, 2023 at 03:51:53PM +0100, Paul Feakins wrote: > >> On 12/07/2023 15:44, Stan Brown wrote: > >>> On 2023-07-12 05:19, Paul Feakins wrote: > >>>> Why would you have 2 separate instances of GnuCash rather than simply 2 > >>>> Asset accounts? > >>> What he said. > >>> > >>> And I'll just add that when you have two independent sets of books, > >>> sooner or later they're going to fall out of sync through human error, > >>> and then you'll have a bigger mess. > >>> > >>> Stan Brown > >>> Tehachapi, CA, USA > >>> https://BrownMath.com > >> Indeed. Plus the asker didn't copy in the list but replied to me > >> directly asking "Why not?" > >> > >> I replied with: > >> > >> Because the Church is one entity and it owns both accounts? > >> > >> Because GnuCash is designed to handle multiple Asset accounts? > >> > >> Because opening 2 instances is more complicated than opening just one? > >> > >> Because a transfer from one account to the other would be easier in the > >> same instance? > >> > > Because you E-Mailed me directly! > > > > Thanks for all the help everbody! > > Nope, I replied to the list, gnucash-user@gnucash.org, as one should. > Here's the headers:- Date: Wed, 12 Jul 2023 14:25:33 +0100 From mairix@mairix Mon Jan 1 12:34:56 1970 From: Paul Feakins To: Chris Green Subject: Re: How to record 'balancing' trnsactions? X-source-folder: /home/chris/mail/In/inbox/cur/1689168337.M577883P1473824Q1.esprimo:2,S -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record 'balancing' trnsactions?
On Wed, Jul 12, 2023 at 03:51:53PM +0100, Paul Feakins wrote: > On 12/07/2023 15:44, Stan Brown wrote: > > On 2023-07-12 05:19, Paul Feakins wrote: > >> Why would you have 2 separate instances of GnuCash rather than simply 2 > >> Asset accounts? > > What he said. > > > > And I'll just add that when you have two independent sets of books, > > sooner or later they're going to fall out of sync through human error, > > and then you'll have a bigger mess. > > > > Stan Brown > > Tehachapi, CA, USA > > https://BrownMath.com > > Indeed. Plus the asker didn't copy in the list but replied to me > directly asking "Why not?" > > I replied with: > > Because the Church is one entity and it owns both accounts? > > Because GnuCash is designed to handle multiple Asset accounts? > > Because opening 2 instances is more complicated than opening just one? > > Because a transfer from one account to the other would be easier in the > same instance? > Because you E-Mailed me directly! Thanks for all the help everbody! -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to record 'balancing' trnsactions?
This is as much an accounting question as a GnuCash one but how one does this depends on the sofware's capabilities so it makes sense to ask here. Our church has two main accounts (as in places where money is kept), a current account at a bank, and a 'building fund' kept in a building society savings account. I run two separate instances of GnuCash, one for the current account and one for the building fund. Both of these are run on a 'cash accounting' basis so the balances in GnuCash exactly match the statements from the bank and building society. I need to have a way to record payments that go 'through' the current account but which are actually building fund transactions. For example if we have a fund raising event the cash has to go into the current account (can't pay cash direct into the savings account) and similarly in the opposite direction we often pay building maintenance costs with a cheque from the current account and need to transfer money to cover that from the building fund. Thus, every so often (say monthly) I will need to do a sum that works out the amount owed either way and do an on-line transfer one way or the other. What sort of expense/income should this be and how do I record which transactions (already recorded) it balances out? For example we might have 'income' into the current account as follows:- Scarfe Trust for roof 750.00 Talk and Tea collection 205.00 Tea concert 410.00 Carol singing35.00 Then I need to make an 'expenses' payment out of the current account to the building fund of 1400.00 but it needs somehow to reference the above income to show where the amount came from. Has anyone any experience or ideas of how to manage this? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to set dates for all reports?
I have this problem every time I try and get some reports out of GnuCash. How can I set the dates for *all* reports so that they all end up reporting the same period? Or, alternatively, how do I set up the 'Accounting Period'? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Please don't double post
On Thu, Apr 20, 2023 at 02:00:08PM +0100, G R Hewitt wrote: > On Thu, 20 Apr 2023 at 08:49, Chris Green wrote: > > > On Thu, Apr 20, 2023 at 08:28:54AM +0100, G R Hewitt wrote: > > > Maybe a forum might serve better than a mailing list, there are many > > > advantages over a mailing list? > > > > > ... and there are many disadvantages! > > > > 1 - I (like may others here I expect) use a lot of, mostly technical, > > mailing lists. I can read them *all* in my mail program. If I had > > to use forums to do the same I'd have to connect to 60 or more > > different web sites to see all the messages. > > > > 2 - I can use the same, familiar, tools for handling all my messages. > > I don't have to use the message editor that a forum imposes on me. > > > > 3 - Very few forums preserve message threading properly so it becomes > > very difficult to follow messages in sub-threads etc. > > > > 4 - I can easily keep useful/interesting messages (or complete > > threads) to refer to later, locally on my computer. > > > > etc. etc. > > > Well I suppose if you are a techno-person with 60 or more different tech > sites, that would make sense. > But I don't suppose that most users of Gnucash are, and are likely > Accountants, Book-keepers, But it is a 'technical' mailing list in that it is all about how to use, fix bugs, etc. in a big complex piece of software. While many (most) of the lists I use are software related they are also mostly 'user' lists. Having said that there are a few forum software suites that also provide E-Mail access so one can get the best of both worlds. The one I know about is called Discourse, it's used by a couple of the lists I'm on and works well both by E-Mail and as a forum. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Please don't double post
On Thu, Apr 20, 2023 at 08:28:54AM +0100, G R Hewitt wrote: > Maybe a forum might serve better than a mailing list, there are many > advantages over a mailing list? > ... and there are many disadvantages! 1 - I (like may others here I expect) use a lot of, mostly technical, mailing lists. I can read them *all* in my mail program. If I had to use forums to do the same I'd have to connect to 60 or more different web sites to see all the messages. 2 - I can use the same, familiar, tools for handling all my messages. I don't have to use the message editor that a forum imposes on me. 3 - Very few forums preserve message threading properly so it becomes very difficult to follow messages in sub-threads etc. 4 - I can easily keep useful/interesting messages (or complete threads) to refer to later, locally on my computer. etc. etc. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Website from WIki
On Sun, Jan 15, 2023 at 02:19:13PM +0300, David T. via gnucash-user wrote: > Hmm. That is odd. The page identifies itself as the default page when Apache > is installed under Ubuntu, suggesting an error in the GnuCash web server > setup. "www.gnucash.org" works properly; "gnucash.org" does not. > That suggests that someone has got their DNS configuration wrong, or, looking more closely, the virtual hosts configuration on their web server. Both gnacash.org and www.gnucash.org give the same IP:- chris@isbd$ client_loop: send disconnect: Broken pipe chris$ host gnucash.org gnucash.org has address 67.198.37.17 gnucash.org mail is handled by 10 lists.gnucash.org. chris$ host www.gnucash.org www.gnucash.org has address 67.198.37.17 So that's as it should be, so it's probably something in the web server setup that's wrong. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where do I set the "Accounting Period" for reports?
On Fri, Jan 06, 2023 at 12:41:22PM -0800, Stan Brown wrote: > > On 2023-01-06 11:35, Chris Green wrote: > > On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote: > >> Chris, > >> > >> Did you run a report then click on Options / General Tab - the reports I > >> run allow you to set the period for each report? > >> > > That's absolutely the last thing I want to do, I want the same period > > for every report after entering it just once! > > I don't think there's a global setting for time period in reports. It > would be nice if there were -- why not enter an enhancement request? > > I know it's a pain to set up a time period for each individual report, > but you only have to do it once (per report). And if you are smart about > it, you'll use settings like "start of previous month" or "end of > accounting period". > > When you click "Save Report Configuration As", be sure to use some > reasonable naming convention, one that makes sense to you. > I really don't want or need to save reports, it's just one more bit of configuration that I'd need to keep track of. I want things to be configured in as few places as possible. A saved report is of little use the next year (wrong headings often). What I want is to set things up so that whenever I click on (for example) Transaction Report I just get that and not have to jump through several hoops to actually get any meaningful output. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where do I set the "Accounting Period" for reports?
On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote: > Chris, > > Did you run a report then click on Options / General Tab - the reports I > run allow you to set the period for each report? > That's absolutely the last thing I want to do, I want the same period for every report after entering it just once! -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Why can't I set 'selcted' accounts for reports permananently?
Maybe I'm missing a setting somewhere, but every time I want to print a report I have to go through the whole rigmarole of selecting all accounts for the report. Is there a way to get Gnucash to default to selecting *all* accounts rather than no accounts? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where do I set the "Accounting Period" for reports?
On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote: > There is also a setting in preferences somewhere to change the accounting > period. As I don't use the feature, I don't know where it is in either > the general preferences or the file preferences. > Yes, that's where it is. Why isn't it with the other report options? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where do I set the "Accounting Period" for reports?
On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote: > Chris, > > Did you run a report then click on Options / General Tab - the reports I > run allow you to set the period for each report? > ... and then forgets it for the next report as far as I can see. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Where do I set the "Accounting Period" for reports?
Every year when I want to print annual reports I have this problem. I can never find where to set the 'accounting period' for reports. Where is it please? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Configuration dilemma -- How best to share Gnucash between 2 users
On Wed, May 11, 2022 at 08:46:16AM +1000, Liz Dodd wrote: > On Tue, 10 May 2022 14:06:02 -0600 > John Griessen wrote: > > > That sounds great for two people in an office. How would you get > > the benefit of doing bookkeeping on a laptop and then at a desktop > > machine alternating back and forth? > > > > I get a flexibility benefit using unison to sync files. I don't > > share use of bookkeeping files with another person, just me with > > laptop and me with desktop. So far no troubles for a year. This > > method does not expose my bookkeeping to internet server attacks > > either -- it all stays behind a firewall. > > I too alternate between desktop and laptop. > I host my own Nextcloud instance and syncing is automatic after each > save. I have had problems when something went wrong with network > connectivity. At this point I have different files, and the server > keeps a copy of each so you can recover more easily. > I use syncthing to synchronise my GnuCash (and a load of other) files between desktop and laptop. It does 'real time' synchronisation and there's no need for any user interaction once it's set up, the files just stay synchronised automatically. It's available for most OSs, Linux, MS Windows, Macs, even Android! It can work across multiple OSs and works whenever/wherever the computer has web access. I find it briliant for GnuCash because it means I can quite transparently use GnuCash on my desktop or when I'm away from home on my laptop. The standard GnuCash lock files prevent me from doing things in two places at once by mistake. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to copy a GnuCash 'installation'?
On Sat, May 07, 2022 at 07:02:22AM +1000, Liz Dodd wrote: > On Fri, 6 May 2022 18:58:13 +0100 > Chris Green wrote: > > > However there are other files one needs to copy if you want reports > > and screen layout and things like that to be the same. Is this > > documented anywhere? > > Of course. It's in the wiki, and you will find it in the FAQ under > "Backups". > Ah, yes, good point - a backup is similar to what I'm looking for. Thank you. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to copy a GnuCash 'installation'?
If one wants to copy a GnuCash 'installation' from one place to another, in particular from one computer to another what needs to be copied? I'm really only interested in copying from one Linux system to another, both running the same GnuCash version. Obviously one needs to copy:- The GnuCash 'data' file, either XML or sql Any log files (though not strictly necessary I guess) However there are other files one needs to copy if you want reports and screen layout and things like that to be the same. Is this documented anywhere? I'm particularly interested in copying reports across as I run GnuCash on both my desktop machine and my laptop. Just copying the GnuCash data file means that I get the same accounts on both systems but not reports and connected files ('experimental' CSS for reports, that sort of thing). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change layout and font sizes in Transaction Report - how?
On Thu, May 05, 2022 at 07:22:47PM +0100, Chris Green wrote: > On Thu, May 05, 2022 at 01:13:06PM -0500, Adrien Monteleone wrote: > > I just played around with it on the Transaction Report and came up with > > this: > > > > td:first-child { > > font-weight: bold; > > font-size: large; > > } > > > > The Account Name doesn't have a class or id to target, but it just so > > happens to be always the first td child of a new tr element in the entire > > report. (best I can tell, I didn't play with all options) > > > > Give that a go. > > > > I do see prominent Account Totals but I agree, the initial Account Name > > starting each section should be more noticeable. > > > That's clever! I'd looked at the output HTML but I didn't know about > the "first child" modifier. I'll certainly try it, thank you. > Yes, that's a big improvement, it might be worth setting a background colour too, lots of possibilities. Thanks again! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change layout and font sizes in Transaction Report - how?
On Thu, May 05, 2022 at 01:13:06PM -0500, Adrien Monteleone wrote: > I just played around with it on the Transaction Report and came up with > this: > > td:first-child { > font-weight: bold; > font-size: large; > } > > The Account Name doesn't have a class or id to target, but it just so > happens to be always the first td child of a new tr element in the entire > report. (best I can tell, I didn't play with all options) > > Give that a go. > > I do see prominent Account Totals but I agree, the initial Account Name > starting each section should be more noticeable. > That's clever! I'd looked at the output HTML but I didn't know about the "first child" modifier. I'll certainly try it, thank you. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change layout and font sizes in Transaction Report - how?
On Thu, May 05, 2022 at 12:59:55PM -0500, Adrien Monteleone wrote: > > On 5/5/22 3:12 AM, Chris Green wrote: > > Is there any guarantee that the CSS Stylesheet wll allow me to access > > every selector I can see in the HTML output? I guess I can simply > > take a look and try it out. > > > The old built-in 'stylesheets' probably do not. But there is a CSS-based > (experimental) sheet that is just open text. You spec any id or class or > element you want with your chosen rules. > Yes, exactly, that's why I asked the question! :-) I was referring to the 'experimental' CSS style sheet. However on looking at the Transaction Report HTML there's no selector (class or anything) for the sub-account heading so it's not possible (as far as I can see) to do what I want with the CSS Stylesheet. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
On Thu, May 05, 2022 at 10:25:08AM -0400, Michael or Penny Novack wrote: > > So yes, I look at dates in file names as a very good thing. If like me you > had lived through that "hell week" trying to get caught back up you would > too. > I agree to an extent, it's just that the 'date as part of filename' in my case is in the directory structure rather than the file name. It's not just for GnuCash and other similar sorts of things. I have my photo collcetion in a decade/year/month/day directory hierarchy. So photos I took on 24th March this year are in:- /home/chris/pictures/2020s/2022/03/24 ... and I can very easily find pictures I took on my school summer holidays in the 1960s, and everywhere in between. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can one save report option defaults?
On Thu, May 05, 2022 at 01:29:28AM -0500, Adrien Monteleone wrote: > On 5/4/22 9:31 AM, Chris Green wrote: > > I find I nearly always change the same five or six report options > > every time I want a new report. For example I nearly always want to > > select all accounts (at least initially) and I want the secondary sort > > key to be Date. > > > > Is there any way I can set up GnuCash so the report options always > > start with the values I want? > > > No there is not unfortunately. > > I've seen it discussed and there is probably an RFE filed on it. > OK, thanks Adrien, at least I know I haven't missed anything obvious *and* other people have suggested it might be a good idea. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change layout and font sizes in Transaction Report - how?
On Thu, May 05, 2022 at 01:33:51AM -0500, Adrien Monteleone wrote: > On 5/4/22 5:40 AM, Chris Green wrote: > > The Transaction Report probably provides the information that my > > auditor wants by listing each account's transactions in order and > > giving the total amount below each account. > > > > However the formatting and font sizes seem a little odd and I'd like > > to change them if I can. > > > > I have two fairly simple requirements:- > > > > Increase the space below "Total for " before the > > name of the next account appears. > > > > Increase the font size for the account name that appears at the > > top of each account's transactions. As it is at present it's just > > in the default small size used for all the 'body' text and so the > > name doesn't stand out to indicate the start of the next account. > > > > > > I can 'do' CSS but there don't seem to be any obvious selectors for > > the items I want to change. Is there any detailed description of what > > selectors are available in the CSS stylesheet? > > > Export the report. The format is HTML, then you can examine it with a text > editor and/or open it in a browser and use its inspector. > Is there any guarantee that the CSS Stylesheet wll allow me to access every selector I can see in the HTML output? I guess I can simply take a look and try it out. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
On Wed, May 04, 2022 at 07:18:32PM -0400, Michael or Penny Novack wrote: > > > Yes, I noticed too that there a files with a number added to the base > > name, e.g.:- > > > > building.gnucash.gcm > > building.gnucash_2.gcm > > > > ... but I'm not sure that it's a perfect system. > > > > I have reverted to having the year as part of the file name and a > > wrapper script that finds the data file corresponding to the year > > directory I'm in. > > > UH ... just because you as a human consider abcd and abcd_3 to be the same > name misses the point that they ARE different file names as far as the > computer is concerned, as different as you consider Fred and Freda different > names > Yes, I do realise that, I was just pointing out what GnuCash appears to do if you have two different data files (in different directories) with the same name. I've never had a data file called building.gnucash_2.gnucash so (I assume) GnuCash has created that file when it found there was already a building.gnucash.gcm file for *another* data file. > However, including the year in the name when in fact these are :the same > file except for a different year is an EXCELLENT way to go > Yes, except that it does make for rather long filenames. I'd really be happiest if my GnuCash 'building' bank account data file was simply called 'building'. It's in a directory called ~/pcc/2022 which tells me that it's Parochial Parish Council data for 2022. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
On Wed, May 04, 2022 at 09:26:51PM +0200, Geert Janssens wrote: > Op dinsdag 3 mei 2022 18:37:20 CEST schreef Chris Green: > > GnuCash names files in ~/.local/share/gnucash/books according to the > > filename of the GnuCash data file. This is a bit of a problem for me > > because I expect to be able to have multiple GnuCash data files with > > the same name in different places. > > > In theory gnucash should be able to handle this. If the file name already > exists in the books > directory, gnucash will create the new file in there with a number appended > to the name. To > find the proper file in book matching the building.gnucash file you just > opened, it uses a > unique book guid that's stored inside each of the files in the books > directory. I don't know > however how these unique id's are generated or how their uniqueness is > guaranteed. So > depending on how you make new gnucash files for each year, this may or may > not work. > Yes, I noticed too that there a files with a number added to the base name, e.g.:- building.gnucash.gcm building.gnucash_2.gcm ... but I'm not sure that it's a perfect system. I have reverted to having the year as part of the file name and a wrapper script that finds the data file corresponding to the year directory I'm in. I.e. if I'm in directory /home/chris/pcc/2021 and I run the wrapper script 'gnc' it will run gnucash with data file general2021.gnucash. It seems pretty much OK so far and saves a lot of typing of long names. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can one save report option defaults?
On Wed, May 04, 2022 at 09:36:19AM -0500, David Carlson wrote: > On Wed, May 4, 2022 at 9:32 AM Chris Green wrote: > > > I find I nearly always change the same five or six report options > > every time I want a new report. For example I nearly always want to > > select all accounts (at least initially) and I want the secondary sort > > key to be Date. > > > > Is there any way I can set up GnuCash so the report options always > > start with the values I want? > > > At the top of the report there is a button labelled "Save Config/" > Yes, I know that. However it only saves the settings for one report and when you retrieve it you get exactly the report you saved. What I want is to be able to save the more general report settings so that whenever I open a new report I get those settings. There's already a few things that can be configured 'system wide' in Edit->Preferences->Reports, for example you can set the default currency for *every* report there. I'd like to be able to set more things like this so that they apply to every report. Then I won't have to set/unset the same half-dozen or so things I have to change every time I create a new report. The problem is that I sometimes forget some of them! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Can one save report option defaults?
I find I nearly always change the same five or six report options every time I want a new report. For example I nearly always want to select all accounts (at least initially) and I want the secondary sort key to be Date. Is there any way I can set up GnuCash so the report options always start with the values I want? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a report with transactions by date and accounts in columns?
On Wed, May 04, 2022 at 01:27:59PM +, Christopher Lam wrote: > Use the "Income & GST Statement" report. > > [image: image.png] > > [image: image.png] > Yes, thank you, I've finally got there. That provides the information (plus a few unwanted columns). :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Change layout and font sizes in Transaction Report - how?
The Transaction Report probably provides the information that my auditor wants by listing each account's transactions in order and giving the total amount below each account. However the formatting and font sizes seem a little odd and I'd like to change them if I can. I have two fairly simple requirements:- Increase the space below "Total for " before the name of the next account appears. Increase the font size for the account name that appears at the top of each account's transactions. As it is at present it's just in the default small size used for all the 'body' text and so the name doesn't stand out to indicate the start of the next account. I can 'do' CSS but there don't seem to be any obvious selectors for the items I want to change. Is there any detailed description of what selectors are available in the CSS stylesheet? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a report with transactions by date and accounts in columns?
On Wed, May 04, 2022 at 12:07:53AM +0800, Christopher Lam wrote: > On Tue, 3 May 2022, 11:53 pm Chris Green, wrote: > > > My auditor wants a transaction report showing transactions in date > > order one per line with the transaction amounts in columns according > > to account name. > > > > Is there anything in GnuCash that can do this? > > > I guess the report intends to show the inputs and outputs into the company, > you could use the income and GST statement report. Inputs and sales, and > outputs are purchases. You can ignore the tax accounts. Then select > detailed sales and purchase accounts in the display options. > Still no separate columns for accounts, what's wanted is something like (needs fixed width font) :- DonationsInterestMiscExpenses 01/03/21£40.00 03/03/21£25.00 07/04/21 (£23.00) 22/04/21£0.50 02/05/21£10.00 etc. etc. It doesn't have to have income and expense on the same sheet, in fact one sheet for each might well make sense, avoiding the need for a way to show -ve values (or some other debit/credit differentiation). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account in Transfer column - how?
On Wed, May 04, 2022 at 06:55:05AM +1000, davidcousen...@gmail.com wrote: > 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 overlays the transfer debit,credit and balance columns and the column > borders are no longer present and there is a scroll bar to the right which you > can use to scroll through the accounts. > I get the down arrow but no list of accounts, no scroll bar, nothing. Occasionally it works but, just at the moment, not very often. > The arrow to the right will now appear as an up arrow and clicking on it will > close the account selection window without making a selection. > I get the change to the up arrow, but (as I said) there's no list to be closed. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
... and further, reading the following:- https://wiki.gnucash.org/wiki/Configuration_Locations Has shown me several ways to achieve what I want, the man page for GnuCash doesn't mention the many, useful, environment variables that are documented in the above. I think I can stop being so annoying now! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
> > There are further sub-directories to sum of these. It makes it very easy for > me sum = 'some' :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?
On Tue, May 03, 2022 at 12:01:47PM -0500, Adrien Monteleone wrote: > So you've chosen an organization method that creates the problem but then > ask for how to avoid it? The answer seems pretty obvious to me: > It's the organisation that I use for just about everything else and it's the way many other people work. From my point of view GnuCash is a latecomer to an existing set up. > Don't start a new file each year. > Auditors prefer it that way, plus it means that I don't have to change report options when I want 'this year' rather than 'last year'. Yes, I know this (never closing the data file) is the normal way of doing it in GnuCash but it really doesn't fit in well with the rest of my existing system organisation and I was hoping GnuCash would be flexible enough to work the way I'd prefer. > But before that, to your original question, what files exactly in > ~/.local/... are you concerned about? One rarely needs to mess with them. > I'm not messing with them directly. > Concerning the configuration settings, particularly reporting period, that > problem too goes away with a single file rather than one for each year. > No it doesn't! :-) If I set the reporting period to, for example, 01/01/2020 to 31/12/2020 then every report is for that period. If I then want a report for 2021 I have to go and change the reporting period. If I have a data file that is for 2020 only then I never have to change the reporting period. Yes, I could save the reports but then one would end up with a huge number of them after a few years. > > What is an example of what you'd expect/like to see instead? > Keep the information like reporting period in the data file to which it relates. > And is something like 'building20.gnucash' really that clumsy? > > How about 'building_20.gnucash' or 'building-20.gnucash'? > > Are 2 or 3 characters really that much longer? (4 or 5 if whole year is > used) > > How is adding the year to the name 'redundant'—because it is already in a > directory name? How often do you look at directory/file lists anyway? > My organisation depends on directory structure. For example I store documentation in a directory called (surprise!) doc, it has sub-directories:- apexLodge dia family houseHome maxCovidpcc shareCertificates boating diy garden hsbc maxmum photography telecoms car doorsgov labels motorcycle plumbing travel chrisCovid electrical health lettersnationwide postEtc. computerelectronics hmrcmaterials paypal recipes There are further sub-directories to sum of these. It makes it very easy for me find documents such as instruction manuals, copies of passports, bank details, etc. The documents can be in all sorts of formats, text, PDF, word processor, etc. > This isn't a 'GnuCash' problem. You could encounter this with *any* file > type and app. > Tell me *any* other program that stores information about a file in the way that GnuCash does. To store information about a file in a generic directory the way that GnuCash does is very rare. Storing universal settings like this makes sense, it provides defaults for the way one wants an application to work, but settings like the dates applying to a particular file should be stored with (or in) that file. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Is there a way to handle same-named GnuCash files sensibly?
GnuCash names files in ~/.local/share/gnucash/books according to the filename of the GnuCash data file. This is a bit of a problem for me because I expect to be able to have multiple GnuCash data files with the same name in different places. For example I keep church building accounts in a file called 'building.gnucash' with the accounts for each year in a different sub-directory of my church accounts system. I.e. there are:- /home/chris/pcc/2020/building.gnucash /home/chris/pcc/2021/building.gnucash /home/chris/pcc/2022/building.gnucash Is there any way around this problem? As it is various configuration settings get changed as I move round my accounts, in particular the reporting period. Keeping all the church's accounts, and correspondence and other files for one particular year makes sense for me (and the auditor!). I *could* add the year to the GnuCash data file name but that does make it rather long and clumsy, and it makes for redundant information which Mr Codd doesn't like! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Is there a report with transactions by date and accounts in columns?
My auditor wants a transaction report showing transactions in date order one per line with the transaction amounts in columns according to account name. Is there anything in GnuCash that can do this? The closest I can find is the Income Statment (Multicolumn) in the Experimental Reports section. However it's the wrong way round, I want dates down the page and accounts across the page. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account in Transfer column - how?
On Tue, May 03, 2022 at 04:05:26PM +0100, david whiting wrote: > Yes, I seem to recall having an issue like that a while ago with an > older version, and it might have been version 4.4, but it has been > fixed for quite some time now. Chris, could you upgrade to a more > recent version? At the very least you should be able to test this by > installing the flatpak version. See this page > https://wiki.gnucash.org/wiki/Flatpak and go down to the section > called "Regular releases at flathub.org". > I'm not keen on flatpak, a bit like snap it introduces a whole can of worms of its own. I have explicitly *removed* snap from my xubuntu systems even though its part of the default distribution now. However, I could (well I will soon) upgrade to xubuntu 22.04 and that will take me to GnuCash 4.8 so that should show whether I'm seeing a bug in GnuCash (or at least one that has been fixed since 4.4). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account in Transfer column - how?
On Tue, May 03, 2022 at 10:01:16AM -0500, David Carlson wrote: > Sometime in the 4.x series of releases a new method of auto filling the > account name was introduced where you just start typing part of the account > name and when your text matches existing text it is supposed to autofill > the name. I think that was supposed to leave the old drop down list from > typing letters and colons method in place. I do not have a release recent > enough to test that, but there could be a bug, perhaps, if you happen to > use certain special characters or an unusual font or character set. > Ah, I think you have lead me to the fix, or at least a workaround. If I actually delete (or partially delete) the account name in the transfer column then I get offered the nearest match account name(s). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account in Transfer column - how?
On Tue, May 03, 2022 at 02:24:52PM +, Gyle McCollam wrote: >Chris, > >Yes, you can. On my GnuCash, if you click on the "^" (actually it >points down) you get the chart of accounts from which you can choose a >different account. It's worked that way as long as I can remember, but >I will say that I am using windows 11 and GnuCash 4.10. > I thought so, it's a bug that I have reported before (27 Nov 2021). When I click on the arrow-up or arrow-down nothing happens. My original problem (in November 2021) was that I didn't get the list of accounts to select from when entering a new tranaction:- I've probably doing something silly somewhere but I can't spot what it is at the moment. While entering transactions into GnuCash today it sometimes offers no account in the 'Transfer' column so anything I do ends up in an 'Imbalance' account. The up arrow and down arrow do nothing when it's in this state. The issue comes and goes and I can't see any pattern to it, I've never seen this problem before though. I'm running GnuCash version 4.4 on xubuntu Linux version 21.10. What I am seeing now is essentially the same problem, the drop-down list (or up) of accounts doesn't appear. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account in Transfer column - how?
On Tue, May 03, 2022 at 10:25:49AM -0400, Michael or Penny Novack wrote: > On 5/3/2022 9:47 AM, Chris Green wrote: > > Is it possible to change the account in the Transfer column of a > > transaction? If so how should one do it? > > > > If I click on the entry it's highlighted and an up arrow ^ appears in > > the Transfer column but no list of alternative accounts. Should I get > > the list there? I'm sure I sometimes have got the list but there > > seems no rhyme nor reason why it sometimes appears and sometimes > > doesn't. > > > > I'm running GnuCash 4.4 on xubuntu Linux. > > > I will be using the formal terms "debit" and "credit" as the supposedly more > user friendly terms vary with the sort of account and this matter does not > depend on that. > > You cannot change the account associated with a debit or a credit of a > transaction while IN that account. Since there will always be at least two > accounts associated with a transaction it will always be possible to go to > that transaction in another account and you would then have a list to change > THIS account there. Do it that way until > > If you have become familiar with entering "splits" you will have learned to > enter transactions in the "journal view". That's how we all entered > transactions in the old days of pen and ink on paper bookkeeping. We then > had to manually post these entries to the ledger accounts. Gnucash does the > "posting" automatically when you enter transactions this way. If you are > viewing the transaction in "journal view" you CAN change any of the accounts > using the drop down list, even the one you were in when you entered journal > view (split) > The whole problem is that I don't get the drop down list! I get the up-arrow or down-arrow that indicates it's going to appear, but it doesn't appear. As I said it does *sometimes* appear but I can't understand why it does appear sometimes but mostly it doesn't appear. I suspect this is actually a bug, I think I reported it quite a long time ago as an inability to select the Transfer account at all when entering a transaction. This is basically the same problem except that I'm wanting to change the Transfer account. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Change account in Transfer column - how?
Is it possible to change the account in the Transfer column of a transaction? If so how should one do it? If I click on the entry it's highlighted and an up arrow ^ appears in the Transfer column but no list of alternative accounts. Should I get the list there? I'm sure I sometimes have got the list but there seems no rhyme nor reason why it sometimes appears and sometimes doesn't. I'm running GnuCash 4.4 on xubuntu Linux. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Wed, Apr 27, 2022 at 06:35:50AM -0400, David T. wrote: >You could always link those files to transactions in GnuCash, and >they'd be accessible from within gnucash... > They don't necessarily have any connection with a transaction, letters for example may just be about church business and nothing to do with money. I still want to keep them in the same place. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Wed, Apr 27, 2022 at 07:11:58PM +1000, davidcousen...@gmail.com wrote: > 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. > Yes, I do have quite a few 'wrapper' bash scripts (and functions) to handle this sort of thing. I don't want to have a different script for each year's accounts though. I have a prototype script for GnuCash now that I run when I'm in the appropriate directory to open the GnuCash file there. It's still a bit 'messy' with all the log files that GnuCash leaves there, I'm working on that as well! :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help with GnuCash's 'help'
On Wed, Apr 27, 2022 at 08:01:01AM +1000, davidcousen...@gmail.com wrote: > 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. > OK, thanks, so at least I'm not missing anything. :-) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 07:49:02PM -0600, brad wrote: > > On 4/26/22 09:25, Chris Green wrote: > > I have several gnucash accounts files (sqlite databases in my case) > > spread around my system. When I go to a specific directory and run > > GnuCash I just want it to see only the database[s] in that directory. > > > > Is there a way I can tell gnucash to forget about all previous files > > it has opened? As it is I get presented with a 'memory' of other > > accounts which can be very confusing unless I'm very careful with file > > naming. > > > > The --nofile option tells gnucash not to open the last accounts > > database, it helps a little, but I really want it to forget more! > > > I'm not clear on what the problem is (unless you're on a Mac). > On my system (linux), In the file manager, navigate to the folder, find the > file you want to open, and double click it. It only opens that database. > What's confusing? > I don't use GUI file manager (well, very rarely), I tend to 'cd' in a terminal window to the directory where the files I want to use are and then run the various programs I need to do things to those files. The GnuCash file is just one of those files. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 06:10:21PM -0400, Michael or Penny Novack wrote: > On 4/26/2022 11:25 AM, Chris Green wrote: > > The --nofile option tells gnucash not to open the last accounts > > database, it helps a little, but I really want it to forget more! > > > It may be confusing things slightly when you shorten "book of accounts" to > "accounts" instead of "books" << we usually refer to the financial records > of an entity as "its books" --- in days of yore when the records were kept > pen and ink on paper the "journal" and "ledgers" WERE books (bound volumes > of accounting paper) >> > Yes, I never quite know what to call a GnuCash data file. As you say 'account' is confusing because GnuCash has multiple 'accounts' within one file/database. > Why is remembering in what directory the records for an entity are kept > easier than remembering the name of the entity? Because it makes a whole lot more sense (for me anyway) to keep everything to do with one set of books in one place. So, for my church accounts for one particular year I have a directory:- ~/pcc/2022 This is very simple to remember and find. (PCC is Parochial Church Council). I have the GnuCash accounts files there, and copies of letters I have sent, and copies of incoming cheques and records for GiftAid plus anything else relevant. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 03:58:06PM -0600, Bruce Irving wrote: > I have 3 separate gnucash data files. I never open gnucash rather I click > on (or have link/shortcut to the data file. That way, I can have the data > file links where they are easy to get to. > I have lots of other information associated with the GnuCash data which I keep in the same directory. E.g. there are copies of cheques deposited and GiftAid records. So my way of working is to go (in a terminal window) to that directory and then run programs as needed from there. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Linux. Mysql and Gnucash 4.1
On Tue, Apr 26, 2022 at 08:47:04PM -0500, Adrien Monteleone wrote: > On 4/26/22 3:28 AM, Chris Green wrote: > > On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote: > > > So I have rebuilt my laptop, recovered my databases and installed Gnucash > > > 4.1 but I cannot connect to mysql databases. When I click file, open there > > > is no option for mysql. This is under Fedora 35Sent from my Galaxy > > > > I don't believe GnuCash works with mysql (or the equivalent mariadb), > > the only database storage option that I'm aware of is sqlite. > > > > It offers 4 backends: > > XML (default) > SQLite > MySQL/MariaDB > PostgreSQL > > You have to install the desired backend libs in most cases to be offered the > option of using it. > > The default requires no special effort. > > Many Linux distros also come with SQLite support by default, so mileage > varies. > > MySQL/Maria & Postgres almost always require intentional lib installation > and if I'm not mistaken, specific build flags. > > Check the wiki for more specific and up to date info. > Yes, absolutely right, my 'sqlite only' view was simply because, on most Linux distributions sqlite is already there. Thus GnuCash offers both XML and sqlite 'out of the box' as it were. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash? databases)?
On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote: > > Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if > that directory is removed or made to be an empty "read-only" directory, you > might be able to "enforce" gnucash to have a memory loss... > > rm ~/.gnucash/books/* > chmod -w ~/.gnucash/books > Yes, it seems a bit drastic though! :-) It's actually /home/chris/.local/share/gnucash/books (or, strictly, some system variable specifies the directory I believe). Even opening GnuCash from a menu or icon (rather than the command line) I'd really prefer that it didn't default to the last set of accounts opened. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 01:43:00PM -0400, Dan Black wrote: >Using the nofile option means to open Gnucash without any file. If you >specify a filename on the command line without the nofile, it should >open the file specified. Well that isn't what the man page says, it says " Do not load the last file opened". To me that says don't open the last file GnuCash had opened when I exited. As I said I can, of course, write wrapper scripts (or desktop files) to make GnuCash open specific files. However I wish it *didn't* open the last file I was editing by default. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote: >On April 26, 2022 11:25:02 AM EDT, Chris Green wrote: > > I have several gnucash accounts files (sqlite databases in my case) > > spread around my system. When I go to a specific directory and run > > GnuCash I just want it to see only the database[s] in that directory. > > Is there a way I can tell gnucash to forget about all previous files > > it has opened? As it is I get presented with a 'memory' of other > > accounts which can be very confusing unless I'm very careful with file > > naming. > > The --nofile option tells gnucash not to open the last accounts > > database, it helps a little, but I really want it to forget more! > >I'm not certain what has you confused, but if you need each file to >have its own existence, you might have to create separate OS logins for >each. > Seriously?! Do you really mean that I should create a different user for each GnuCash account? That seems a very clumsy way to handle more than one account. What 'has me confused' is the way that GnuCash by default opens the last account I was looking at. In nine cases out of ten that's just what I don't want it to do, why else would I have exited GnuCash and moved to another directory? My ideal would be for GnuCash to look for account files in the current directory, if there is only one then open that one, if there are more then offer me a list to choose from. I can write myself a little wrapper script to do this but I don't find other programs need this. Many other programs do have a 'recently opened' option but they don't automatically open the last opened file. ... and, as I pointed out, using the --nofile option prevents GnuCash from opening any file, you have to select the file after starting GnuCash. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
On Tue, Apr 26, 2022 at 04:25:02PM +0100, Chris Green wrote: > I have several gnucash accounts files (sqlite databases in my case) > spread around my system. When I go to a specific directory and run > GnuCash I just want it to see only the database[s] in that directory. > > Is there a way I can tell gnucash to forget about all previous files > it has opened? As it is I get presented with a 'memory' of other > accounts which can be very confusing unless I'm very careful with file > naming. > > The --nofile option tells gnucash not to open the last accounts > database, it helps a little, but I really want it to forget more! > ... and the --nofile option doesn't appear to do what it says it does. The man page says:- --nofile Do not load the last file opened However with the --nofile option gnucash doesn't even open a file whose name you give it on the command line! -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.