[GNC] Consistent way to hang Gnucash

[Michael Hendry]

Further to my recent crash report:

Start to reconcile a bank account.

Edit a pension payment during reconciliation because the regular payment has 
gone up

Open the Scheduled Transaction editor and adjust for new payment.

Go on with the reconciliation until the next pension increase prompts the 
editing of a payment

Try to open the Scheduled Transaction editor.

Work-around: Make a note of adjustments needed to Scheduled Transactions, and 
deal with them after the reconciliation is complete.

Michael

Version Numbers here:

Process:   Gnucash [48185]
Path:  /Applications/Gnucash 2.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   5.5-1 (5.5-1)
Code Type: X86-64 (Native)
Parent Process:launchd [1]
User ID:   501

Date/Time: 2024-06-23 08:10:26.9458 +0100
OS Version:macOS 14.5 (23F79)
Report Version:12
Bridge OS Version: 8.5 (21P5077)
Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5
___
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] Crash Report

[Michael Hendry]

PS Since submitting this report, I restarted GC and picked up the 
reconciliation I’d been working on after getting rid of the lock file message.

I then went through a reconciliation of a different account without trouble, 
correcting a couple of pension payments which had increased since the beginning 
of April.

I then went on to the next month, and coming to the same corrections resulting 
from the annual pension increase, I went in to Scheduled Tramsactions to update 
it. This worked fine for the first transaction, but when I went to go through  
through the same procedure for the next transaction the screen froze with the 
Actions menu visible, but no response to the mouse.

I find I can get to the Reconcile Window, but get no response to the mouse 
there either.

Activity Monitor tells me there are two instances of Gnucash running, PID 52897 
which has used 5:09.72 CPU time and PID 55260 with 2.43, along with PID 59349 
ThemeWidgetControlViewService (Gnucash) with 0.20. The last time my .gnucash 
file was modified is 12:19 (it’s now 13:05) and there’s a log last modified at 
12:24.

I suspect I’ll just have to kill the relevant processes or use Force Quit, but 
there are plenty of other things I can find to do in the meantime on this fine 
sunny day in Scotland.

Michael

> On 23 Jun 2024, at 08:19, Michael Hendry  wrote:
> 
> Here are the first few lines of a crash report that came up this morning as I 
> was reconciling a credit card account. I’m not sure exactly what I was doing 
> at the time, but I think I was deleting a duplicate transaction.
> 
> GC and macOS version numbers are in the report.
> 
> Happy to forward the full report if that would be useful.
> 
> Regards,
> 
> Michael Hendry
> 
> 
> 
> Process:   Gnucash [48185]
> Path:  /Applications/Gnucash 2.app/Contents/MacOS/Gnucash
> Identifier:org.gnucash.Gnucash
> Version:   5.5-1 (5.5-1)
> Code Type: X86-64 (Native)
> Parent Process:launchd [1]
> User ID:   501
> 
> Date/Time: 2024-06-23 08:10:26.9458 +0100
> OS Version:macOS 14.5 (23F79)
> Report Version:12
> Bridge OS Version: 8.5 (21P5077)
> Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5
> 
> Sleep/Wake UUID:   51968429-1B89-49D0-80DC-070E27B2088A
> 
> Time Awake Since Boot: 35 seconds
> Time Since Wake:   1674 seconds
> 
> System Integrity Protection: enabled
> 
> Crashed Thread:0  Dispatch queue: com.apple.main-thread
> 
> Exception Type:EXC_BAD_ACCESS (SIGSEGV)
> Exception Codes:   UNKNOWN_0xD at 0x
> Exception Codes:   0x000d, 0x
> 
> Termination Reason:Namespace SIGNAL, Code 11 Segmentation fault: 11
> Terminating Process:   exc handler [48185]
> 
> VM Region Info: 0 is not in any region.  Bytes before following region: 
> 4314624000
>  REGION TYPESTART - END [ VSIZE] PRT/MAX 
> SHRMOD  REGION DETAIL
>  UNUSED SPACE AT START
> --->  
>  __TEXT  1012bf000-10131f000[  384K] r-x/r-x 
> SM=COW  /Applications/Gnucash 2.app/Contents/MacOS/Gnucash
> 
> Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
> 0   libsystem_platform.dylib  0x7ff819077b32 _platform_strlen + 18
> 1   libglib-2.0.0.dylib  0x103a56067 g_strdup + 23
> 2   libgnc-gnome-utils.dylib 0x1020365f2 
> gnc_query_view_refresh + 914
> 3   libgnc-gnome.dylib   0x101e4f9ea 
> gnc_reconcile_view_refresh + 106
> 4   libgnc-gnome.dylib   0x101e53932 refresh_handler + 162
> 5   libgnc-gnome-utils.dylib 0x10200900e 
> gnc_gui_refresh_internal + 222
> 6   libgnc-gnome.dylib   0x101e54e6c 
> gnc_ui_reconcile_window_delete_cb + 572
> 7   libgobject-2.0.0.dylib   0x1022395aa g_closure_invoke + 
> 298
> 8   libgobject-2.0.0.dylib   0x102250ac7 
> signal_emit_unlocked_R + 1607
> 9   libgobject-2.0.0.dylib   0x102251b4f g_signal_emit_valist 
> + 2767
> 10  libgobject-2.0.0.dylib   0x102252042 g_signal_emit + 130
> 11  libgio-2.0.0.dylib   0x103405a94 
> g_simple_action_activate + 148
> 12  libgtk-3.0.dylib 0x102bab82e 
> gtk_menu_tracker_item_activated + 158
> 13  libgobject-2.0.0.dylib   0x1022395aa g_closure_invoke + 
> 298
> 14  libgobject-2.0.0.dylib   0x102250ac7 
> signal_emit_unlocked_R + 1607
> 15  libgobject-2.0.0.dylib   0x102251b4f g_signal_emit_valist 
> + 2767
> 16  libgobject-2.0.0.dyli

[GNC] Crash Report

[Michael Hendry]

Here are the first few lines of a crash report that came up this morning as I 
was reconciling a credit card account. I’m not sure exactly what I was doing at 
the time, but I think I was deleting a duplicate transaction.

GC and macOS version numbers are in the report.

Happy to forward the full report if that would be useful.

Regards,

Michael Hendry



Process:   Gnucash [48185]
Path:  /Applications/Gnucash 2.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   5.5-1 (5.5-1)
Code Type: X86-64 (Native)
Parent Process:launchd [1]
User ID:   501

Date/Time: 2024-06-23 08:10:26.9458 +0100
OS Version:macOS 14.5 (23F79)
Report Version:12
Bridge OS Version: 8.5 (21P5077)
Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5

Sleep/Wake UUID:   51968429-1B89-49D0-80DC-070E27B2088A

Time Awake Since Boot: 35 seconds
Time Since Wake:   1674 seconds

System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   UNKNOWN_0xD at 0x
Exception Codes:   0x000d, 0x

Termination Reason:Namespace SIGNAL, Code 11 Segmentation fault: 11
Terminating Process:   exc handler [48185]

VM Region Info: 0 is not in any region.  Bytes before following region: 
4314624000
  REGION TYPESTART - END [ VSIZE] PRT/MAX 
SHRMOD  REGION DETAIL
  UNUSED SPACE AT START
--->  
  __TEXT  1012bf000-10131f000[  384K] r-x/r-x 
SM=COW  /Applications/Gnucash 2.app/Contents/MacOS/Gnucash

Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libsystem_platform.dylib0x7ff819077b32 _platform_strlen + 18
1   libglib-2.0.0.dylib0x103a56067 g_strdup + 23
2   libgnc-gnome-utils.dylib   0x1020365f2 
gnc_query_view_refresh + 914
3   libgnc-gnome.dylib 0x101e4f9ea 
gnc_reconcile_view_refresh + 106
4   libgnc-gnome.dylib 0x101e53932 refresh_handler + 162
5   libgnc-gnome-utils.dylib   0x10200900e 
gnc_gui_refresh_internal + 222
6   libgnc-gnome.dylib 0x101e54e6c 
gnc_ui_reconcile_window_delete_cb + 572
7   libgobject-2.0.0.dylib 0x1022395aa g_closure_invoke + 
298
8   libgobject-2.0.0.dylib 0x102250ac7 
signal_emit_unlocked_R + 1607
9   libgobject-2.0.0.dylib 0x102251b4f g_signal_emit_valist 
+ 2767
10  libgobject-2.0.0.dylib 0x102252042 g_signal_emit + 130
11  libgio-2.0.0.dylib 0x103405a94 
g_simple_action_activate + 148
12  libgtk-3.0.dylib   0x102bab82e 
gtk_menu_tracker_item_activated + 158
13  libgobject-2.0.0.dylib 0x1022395aa g_closure_invoke + 
298
14  libgobject-2.0.0.dylib 0x102250ac7 
signal_emit_unlocked_R + 1607
15  libgobject-2.0.0.dylib 0x102251b4f g_signal_emit_valist 
+ 2767
16  libgobject-2.0.0.dylib 0x102252042 g_signal_emit + 130
17  libgtk-3.0.dylib   0x102cee5c7 gtk_widget_activate 
+ 71
18  libgtk-3.0.dylib   0x102ba78b8 
gtk_menu_shell_activate_item + 312
19  libgtk-3.0.dylib   0x102ba923c 
gtk_menu_shell_button_release + 428
20  libgtk-3.0.dylib   0x102a1e50a 
_gtk_marshal_BOOLEAN__BOXEDv + 170
21  libgobject-2.0.0.dylib 0x102239849 _g_closure_invoke_va 
+ 329
22  libgobject-2.0.0.dylib 0x102251550 g_signal_emit_valist 
+ 1232
23  libgobject-2.0.0.dylib 0x102252042 g_signal_emit + 130
24  libgtk-3.0.dylib   0x102cedc68 
gtk_widget_event_internal + 248
25  libgtk-3.0.dylib   0x102b934ef gtk_propagate_event 
+ 255
26  libgtk-3.0.dylib   0x102b92f17 gtk_main_do_event + 
1303
27  libgdk-3.0.dylib   0x1020ef821 _gdk_event_emit + 49
28  libgdk-3.0.dylib   0x10211b1a2 gdk_event_dispatch + 
50
29  libglib-2.0.0.dylib0x103a33a9e 
g_main_context_dispatch + 414
___
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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

[Michael Hendry]

Hi, Michael,

We’ve corresponded about this in the past.

I was keen to keep track of restricted funds within GC in a way which would 
make unspent restricted income persist as restricted funds beyond the year end, 
and you suggested the use of a Liability account for this purpose,

Unfortunately, the accountant who examines our accounts before submission to 
OSCR (the Scottish Charities Regulator) advised that this isn’t an acceptable 
way to handle restricted funds in the UK.

The problem with using the income accounts (as below) for the various types of 
Income, is that the money not spent (in our case on bursaries for musicians who 
wouldn’t otherwise be able to attend our courses) doesn’t persist in the that 
account after the year end the way a liability would. A collection at the 
final-day concert which is advertised as being destined for use as bursaries 
won’t be spent until the next year’s course.

On the other hand, if income received for restricted donations is accounted for 
in this way, and funds paid out as bursaries are also accounted for in a 
separate expense account it should be easy enough to keep a year-on-year tally 
of the remaining restricted funds. In practice, we probably spend more than we 
receive on bursaries each year, but a church roof might be a longer-term job.

Michael

> On 25 May 2024, at 23:08, Michael or Penny Novack 
>  wrote:
> 
> You did NOT have to have separate books!
> 
> In ONE set of books you can have as many "bank accounts" in the ledger ans 
> you have bank accounts. Just give them different names so that you can tell 
> them apart. We may have some difficulties with cross pond differences in 
> language. Thus your "current account" means what I would call a "checking 
> account" and you must not confuse "current account" with the asset category 
> "current assets" << all accounts containing immediately available funds >>
> 
> Thus:
> Assets
>  Current assets
>Current account
>Savings account << where you are keeping restricted funds >>
> 
> OK, now your donations are all being deposited into the checking account even 
> though some of those donations are restricted. You are asking how to deal 
> with that? Under income you could have:
> Income
>   unrestricted donations
>   untransferred restricted donations
>   restricted donations
> 
> When you make a deposit into the checking account of a bunch of donations (of 
> both sorts) you use the top two. Hint: easiest to have an asset under current 
> assets "undeposited cash" and as donations come in they go there credited to 
> either unrestricted donations or untransferred. Now your actual bank deposit 
> is an easy transaction, just undeposited to checking. Later, when you 
> transfer from the "checking account" to the "savings account"  you 
> would ALSO be transferring between "untransferred restricted donations" to 
> "restricted donations". NOTE -- your reference to "building society" manes a 
> different bank? Still that way your side of the pond?
> 
> As for your question about statements, almost all gnucash reports allow you 
> to SELECT which accounts are to be included. You'd be able to produce 
> statements for just the unrestricted funds, just the restricted, both 
> together, etc.
> 
> Do note that while you can't use restricted funds for other than their 
> intended purpose THE REVERSE IS NOT TRUE < organizational bylaws but would be most unusual >> That's why you would want 
> to use restricted funds for their intended purpose first (before using any 
> non-restricted funds for that purpose). You want to clear the restriction.
> 
> Michael D Novack
> 
> PS --- The usual caveat, I'm not "licensed" to give accounting help. For what 
> it's worth, I've been Treasurer for a number of non-profits.
> 
> PPS -- if you are following this, but your organization does not have that 
> second bank account, you could track the restriction using a liability.
> 
> 
> 
> 
> 
> 
> On 5/25/2024 4:13 PM, Chris Green wrote:
>> 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
>> 

Re: [GNC] What account name do you use to record the apartment/house expenses related to the building?

[Michael Hendry]

On 15 Apr 2024, at 01:45, Oleander via gnucash-user  
wrote:

> 
> Hello,
> is "Housing" a proper account name if I want to include only my apartment 
> expenses like Rent/Mortgage and Repairs? I'd like to record my 
> Utilities expenses separately within another account so that my "Housing" 
> account adds up only the expenses related to the building.

Yes, Expenses:Housing would be fine.

Remember that you can set up “Child” accounts, for example...

Expenses:Housing:Utilities
Expenses:Housing:Rent
Expenses:Housing:Repairs

…which would allow you to generate separate reports from each Child separately 
or in any combination - it all depends on how granular you want your reports.

You could also split the Utilities into Expenses:Housing:Utilities:Gas, 
Expenses:Housing:Utiliities:Electrity etc if you want to go that far.

When you’re setting this up, it’s probably better to overdo the granularity, 
because it’s less trouble to merge two children than to separate the (say) Gas 
and Electricity transactions, if you change your mind later.

HTH

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Extract from Crash Report

[Michael Hendry]

I had entered a few transactions in one of my Gnucash files (File “A”) around 
12:30 (GMT), and left the computer for a few hours. I came back to it around 
16:15, and after watching a Youtube video and checking my email, I went back to 
Gnucash and (assuming the autosave would have cleared the way) I used the File 
menu to open a different Gnucash file (File “B”).

I was asked if I wanted to save the current file, and said yes, I was prompted 
again and I believe I’d accepted the offer to save before the crash.

As expected after the crash, the next time I ran Gnucash I was warned about the 
lock on file “B”. I opted to open it anyway, and it appears at first glance to 
be undamaged. 

This time, I’ve saved the whole crash report, but I’m only including a small 
portion of it for expert advice on whether ithe full report would be useful.

If so, where should I send it?

Regards,

Michael Hendry

-
Translated Report (Full Report Below)
-

Process:   Gnucash [90913]
Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   5.1-1 (5.1-1)
Code Type: X86-64 (Native)
Parent Process:launchd [1]
User ID:   501

Date/Time: 2023-12-07 16:29:29.9593 +
OS Version:macOS 14.1.2 (23B92)
Report Version:12
Bridge OS Version: 8.1 (21P1069)
Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5

Sleep/Wake UUID:   2FEB2384-9837-4B6E-8B7F-0CE42DCB28C9

Time Awake Since Boot: 13 seconds
Time Since Wake:   588 seconds

System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   KERN_INVALID_ADDRESS at 0x000c
Exception Codes:   0x0001, 0x000c

Termination Reason:Namespace SIGNAL, Code 11 Segmentation fault: 11
Terminating Process:   exc handler [90913]

VM Region Info: 0xc is not in any region.  Bytes before following region: 
140737487409140
  REGION TYPESTART - END [ VSIZE] PRT/MAX 
SHRMOD  REGION DETAIL
  UNUSED SPACE AT START
--->  
  shared memory7ff19000-7ff1a000 [4K] r-x/r-x 
SM=SHM  

Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libgnc-gnome.dylib 0x100f2cea9 
gnc_plugin_page_register_ui_update + 89
1   libgnc-gnome.dylib 0x100f2cbb6 
gnc_plugin_page_register_focus_widget + 358
2   libglib-2.0.0.dylib0x1031a0a7e 
g_main_context_dispatch + 414
3   libglib-2.0.0.dylib0x1031a0da2 
g_main_context_iterate + 450
4   libglib-2.0.0.dylib0x1031a0e38 
g_main_context_iteration + 104
5   libgtk-3.0.dylib   0x101c8acec gtk_main_iteration + 
28
6   libgnc-gnome-utils.dylib   0x1010df4ee gnc_ui_set_cursor + 
94
7   libgnc-gnome-utils.dylib   0x1010df477 gnc_set_busy_cursor 
+ 183
8   libgnc-gnome-utils.dylib   0x10111258f 
gnc_main_window_restore_all_windows + 223
9   libgnc-gnome.dylib 0x100f40db2 
gnc_restore_all_state + 306
10  libgnc-engine.dylib0x102cd14c2 call_hook + 114
11  libglib-2.0.0.dylib0x10318febb g_hook_list_marshal 
+ 107
12  libgnc-engine.dylib0x102cd13d2 gnc_hook_run + 146
13  libgnc-gnome-utils.dylib   0x101109e8b gnc_post_file_open + 
1835
14  libgnc-gnome-utils.dylib   0x101123943 
gnc_plugin_file_history_cmd_open_file + 243
15  libgobject-2.0.0.dylib 0x1013a25aa g_closure_invoke + 
298
16  libgobject-2.0.0.dylib 0x1013b9ac7 
signal_emit_unlocked_R + 1607
17  libgobject-2.0.0.dylib 0x1013bab4f g_signal_emit_valist 
+ 2767
18  libgobject-2.0.0.dylib 0x1013bb042 g_signal_emit + 130
19  libgio-2.0.0.dylib 0x1024fdbc4 
g_simple_action_activate + 148
20  libgtk-3.0.dylib   0x101ca3b9e 
gtk_menu_tracker_item_activated + 158
21  libgobject-2.0.0.dylib 0x1013a25aa g_closure_invoke + 
298
22  libgobject-2.0.0.dylib 0x1013b9ac7 
signal_emit_unlocked_R + 1607
23  libgobject-2.0.0.dylib 0x1013bab4f g_signal_emit_valist 
+ 2767
24  libgobject-2.0.0.dylib 0x1013bb042 g_signal_emit + 130
25  libgobject-2.0.0.dylib 0x1013a25aa g_closure_invoke + 
298
26  libgtkmacintegration-gtk3.4.dylib  0x1010ad5ff idle_call_activate + 
79
27  libgdk-3.0.dylib   0x1011dab62 gdk_threads_dispatch 
+ 50
28  libglib-2.0.0.dylib0x1031a0a7e 
g_main_context_dispatch + 414

Re: [GNC] Crash report

[Michael Hendry]

On 2 Nov 2023, at 03:16, john  wrote:

> 
> Michael,
> 
> That's enough of the crash report to figure out what's going on: It needs a 
> NULL check before the GTK_IS_WIDGET at  
> https://github.com/Gnucash/gnucash/blob/d617129db83b37cc12b3c2434c55e73efb4d98d6/gnucash/gnome/gnc-plugin-page-report.cpp#L337.
> 
> I've pushed that fix. Thanks for the report.
> 
> Regards,
> John Ralls

Glad to be able to help in my small way.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] DOS Payroll, Inventory, A/R, A/P, and G/L program

[Michael Hendry]

On 1 Nov 2023, at 14:47, Bruce McCoy via gnucash-user 
 wrote:

> 
> Hi Everyone,
> 
> 

> On Tue, Oct 31 at 6:40 AM Michael Hendry wrote: 
> >I have some accounts in TAS Books which 
> >I created and maintained on Windows XP 
> 
> Me too. I’ve used version 1e. What about you?
> 
> >I’ve had to maintain a copy of Windows XP Pro
> 
> Had I done that, your life would be simpler.
> 
> >legacy files inherited from my late father
> 
> I’m sorry for his demise. I am sure you miss him. I do miss both my parents. 
> I hope your dad was as nice as mine. 
> 
> >I haven’t been able to find TAS.ZIP 
> >in your Dropbox folders. 
> 
> Michael, that's because I did not send you the links. Here they are:
> 
> BKS.EDT.zip
> https://www.dropbox.com/scl/fi/uijxiym22r707k4cgfais/TAS.zip.txt?rlkey=qs6z1j7zrz5de2y8pjbyghppi=0
> 
> BKS.EDT.zip.txt
> https://www.dropbox.com/scl/fi/qpihxsi392bk47wi86hsb/TAS.zip?rlkey=n60xy601m9r2yvxshi20h9l2m=0
> 
> TAS.zip
> https://www.dropbox.com/scl/fi/kg3yw34naznmk9myvbhuk/BKS.EDT.zip.txt?rlkey=2q9zbkg9ko8g16euzgm6you6y=0
> 
> TAS.zip.txt
> https://www.dropbox.com/scl/fi/e8ohz1g2qnfa55qq4e0i7/BKS.EDT.zip?rlkey=68tlmfi88day9ph7bshncfnes=0

Ah - this is an entirely different TAS.

Sorry to have wasted your time.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Crash report

[Michael Hendry]

iMac,  Sonoma 14, GnuCash Version: 5.1
Build ID: 5.1+(2023-04-30)

I had last edited my personal file several days ago, and this file was still 
open when I used the File->Open command to change the file to one I haven’t 
opened for several weeks.

Finding a number of unwanted open tabs, I was in the process of closing these 
when the crash occurred.

I opted to reopen GnuCash and got the “file already open” message. When I opted 
for “Open Anyway” the file opened without further incident, and I was able to 
close the unwanted tabs.

The extract from the crash report below points to GnuCash as being involved,

Is this of any use to the development team? 

I could obviously send the whole report as an attachment if that would help.

Regards,

Michael Hendry

-
Translated Report (Full Report Below)
-

Process:   Gnucash [23738]
Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   5.1-1 (5.1-1)
Code Type: X86-64 (Native)
Parent Process:launchd [1]
User ID:   501

Date/Time: 2023-11-01 10:52:58.8689 +
OS Version:macOS 14.0 (23A344)
Report Version:12
Bridge OS Version: 8.0 (21P365)
Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5

Sleep/Wake UUID:   970E83D4-CC21-4B8F-8697-68F9DBCF52B0

Time Awake Since Boot: 20 seconds
Time Since Wake:   293 seconds

System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   UNKNOWN_0xD at 0x
Exception Codes:   0x000d, 0x

Termination Reason:Namespace SIGNAL, Code 11 Segmentation fault: 11
Terminating Process:   exc handler [23738]

VM Region Info: 0 is not in any region.  Bytes before following region: 
4537495552
  REGION TYPESTART - END [ VSIZE] PRT/MAX 
SHRMOD  REGION DETAIL
  UNUSED SPACE AT START
--->  
  __TEXT  10e74b000-10e7ab000[  384K] r-x/r-x 
SM=COW  ...MacOS/Gnucash

Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libgnc-gnome.dylib 0x10f23730e 
gnc_plugin_page_report_focus_widget(GncPluginPage*) + 1374
1   libglib-2.0.0.dylib0x1114c8a7e 
g_main_context_dispatch + 414
2   libglib-2.0.0.dylib0x1114c8da2 
g_main_context_iterate + 450
3   libglib-2.0.0.dylib0x1114c90ca g_main_loop_run + 266
4   libgtk-3.0.dylib   0x10ffb2bfb gtk_main + 75
5   libgnc-gnome-utils.dylib   0x10f43644c 
gnc_ui_start_event_loop + 76
6   Gnucash0x10e75ee89 
scm_run_gnucash(void*, int, char**) + 1417
7   libguile-2.2.1.dylib   0x10f0a42b2 invoke_main_func + 34
8   libguile-2.2.1.dylib   0x10f08326f c_body + 15
9   libguile-2.2.1.dylib   0x10f11101b vm_regular_engine + 
1531
10  libguile-2.2.1.dylib   0x10f10fb75 scm_call_n + 773
11  libguile-2.2.1.dylib   0x10f10c5a5 catch + 501
12  libguile-2.2.1.dylib   0x10f08323c 
scm_c_with_continuation_barrier + 140
13  libguile-2.2.1.dylib   0x10f10c10f with_guile + 63
14  libgc.1.dylib  0x10ed9ced6 
GC_call_with_stack_base + 22
15  libguile-2.2.1.dylib   0x10f10a11b scm_with_guile + 43
16  libguile-2.2.1.dylib   0x10f0a4275 scm_boot_guile + 69
17  Gnucash0x10e75f2f9 main + 601
18  dyld0x7ff803b313a6 start + 1942

Thread 1:
0   libsystem_kernel.dylib  0x7ff803e7d5d6 __psynch_cvwait + 10
1   libsystem_pthread.dylib 0x7ff803eba76b _pthread_cond_wait + 
1211
2   libgc.1.dylib  0x10ed9f929 GC_mark_thread + 265
3   libsystem_pthread.dylib 0x7ff803eba202 _pthread_start + 99
4   libsystem_pthread.dylib 0x7ff803eb5bab thread_start + 15

Thread 2:
0   libsystem_kernel.dylib  0x7ff803e7d5d6 __psynch_cvwait + 10
1   libsystem_pthread.dylib 0x7ff803eba76b _pthread_cond_wait + 
1211
2   libgc.1.dylib  0x10ed9f929 GC_mark_thread + 265
3   libsystem_pthread.dylib 0x7ff803eba202 _pthread_start + 99
4   libsystem_pthread.dylib 0x7ff803eb5bab thread_start + 15


___
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 

Re: [GNC] keyboard shortcut - how to implement for open/close splits?

[Michael Hendry]

On 12 Sep 2023, at 18:17, George Riner  wrote:

> 
> I really wish there was a keyboard shortcut to open/close the Splits on the 
> transaction I'm in.
> 
> Is there some edit I can make to a file somewhere in gnucash that would make 
> this effect?
> 
> :George
> 
> GnuCash Version: 4.13
> Build ID: 4.13+(2022-12-17)
> Windows 10 22H2 (build 19045.3324)

Hi, George.

Have a look here:

https://wiki.gnucash.org/wiki/Keyboard_Shortcuts

I use a Mac, so the file I’ve edited is 
~/Library/Application Settings/Gnucash/acclerator-map;

and the necessary lines are:

(gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleRadioAction/0" 
"1")
(gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleRadioAction/1" 
"2")
(gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleRadioAction/2" 
"3")

which opens the Basic Ledger view with Cmd-1, AutoSplit Ledger with Cmd-2 and 
Transaction Journal with Cmd-3.

I think this should be enough to get you started.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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

[Michael Hendry]

On 7 Aug 2023, at 10:46, Mahon Finbar via gnucash-user 
 wrote:

> 
> OK, lets try to get to the bottom of this.
> 
> When I say I have had issues, I am unaware that I should not take the 
> suggestion of 'open anyway' unless
> 
> I have tried several times to get an answer to why I have had this issue, and 
> what  to do about it.
> 
> I think I said in the OP that the message I have been getting about not 
> having rights was not the first 'save' but I think I may have had finger 
> problems, around then, as I said in the OP.
> 
> I will try, again, to send the list of files, I thought I had created a 
> jpg.
> 
> For information, the file  that opens today when I start Gnucash is -
> 
> GNU FEB 12 2019.gnucash.20230730134528 If that is the date and time for the 
> file I had open it coincides with my recollection of the date and time I was 
> working when the message 'could not write to file, etc., arose.

That is a backup file (identifiable from the time-stamp at the end. It looks as 
though the file you should have opened is:

GNU FEB 12 2019.gnucash

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?"

[Michael Hendry]

On 24 Jul 2023, at 12:05, Chris Green  wrote:
> 
> 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

Here’s a real example from my Rotary Club. 

A Member had given me a cheque for £125 - the usual annual subscription - 
forgetting that we’d reduced it this year because of underspending during Covid.

When this was pointed out, he asked for the £15 excess to be transferred to the 
charity account.



Above is how I handled this transaction, viewed using View—>Transaction Journal.

Current Assets:Cheques Received is Debited the full £125, but the Income is 
split between Income:Members’ Subcriptions (£110) and Income:Miscellaneous.

I subsequently scanned the cheque into the Club’s account and recorded it as 
Assets:Current Assets:Cheques Received —> Assets: Current Assets:Club Current, 
and transferred the £15 from the Club’s Current Bank Account to the Charity’s 
Current Bank account.

(the screenshot can be viewed here: 
https://www.dropbox.com/scl/fi/llp6xr0ppbrbuosf93ewi/Screenshot-2023-07-24-at-12.22.47.png?rlkey=vkehv9vsn5612079ux5sjkw1j=0
 if it doesn’t  come through as an attachment).

If I’d needed to split the donation three ways, I’d have tabbed across from 
Income:Miscellaneous to enter £5, and continued tabbing to start another split, 
recorded a further £5 in Income:President’s Discretionary Fund (or whatever) 
and again with the final £5 to Income:Something Else.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?

[Michael Hendry]

> On 23 Jul 2023, at 12:02, Fred Bone  wrote:
> 
> But aren't you supposed to record each collection separately for GASDS 
> purposes? What happens if the two weeks are in different tax years?

Ah, I hadn’t thought about that aspect, but Chris had mentioned earlier that as 
his church is not a registered charity, and didn’t have to report to the 
charity authorities, just to the church and to the diocese. If he is claiming 
Gift Aid he would need to keep a record of all donations made by individuals 
who are eligible for Gift Aid and separate records for collections etc. where 
multiple small cash sums (under £30) are collected for a claim under the Gift 
Aid Small Donations Scheme. As the maximum income on which a GASDS claim can be 
made is 10 times a GA claim for the same period, up to a maximum of £8000, it’s 
important to get a minimum of £800 in Gift-Aid-Claimable donations.

The recording of these transactions is essentially the same, Cash and Cheques 
received should be recorded in the appropriate asset accounts as before, but 
with child accounts to separate the different GA/GASDS income when the time 
comes to get some cash out of HMRC (the taxman, for non-UK readers).

As Rotary Club Treasurer I have Income Accounts for (among others):

Income:Donations:GA:General (for general donations to the charity account)
Income:Donations:GA:Whisky Tasting (for donations made at a Whisky Tasting event
etc, and

Income:Donations:GASDS:Santa (for cash collections during our Santa’s Sleigh 
collections
Income:Donations:GASDS:WIshing Well (for cash retrieved from a wishing well 
we’ve installed at a local attraction).

and I follow the general instructions given by Stan Brown:

Upon receiving the money:
Debit to Cash
Credit to the appropriate Income account

Upon depositing the held checks and cash:
Debit to Banks
Credit to Cash

The advantage of doing all this spade-work as the money comes in is that I can 
quickly generate the information for the Gift Aid and GASDS claims when the 
time comes, using GnuCash reports.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?

[Michael Hendry]

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.

In my past incarnation as an NHS family doctor, we also used Petty Cash to 
receive small cash payments for non-NHS reports, certificates etc, with the 
approval of our accountant. This generally meant that the total in the Petty 
Cash box gradually increased until the next visit to the bank to deposit 
cheques was made, and the surplus cash was deposited at the same time.

> 
> 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).

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?

[Michael Hendry]

On 22 Jul 2023, at 17:58, c...@isbd.net 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?
> 

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.

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.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?

[Michael Hendry]

Hello again Chris.

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.

Deposits are recorded as transfers from the …Cash and/or …Cheques account to 
the Current or Savings Account under a single paying-in slip number (a split 
transaction if both cash and cheques are paid in at the same time).

> 
> 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.

I record transfers between the Savings and Current Accounts as simple 
transactions (i.e. two splits). If you need to specify the separate invoices 
and (possibly) separate expense accounts associated with them, you can do this 
with additional splits attached to the record of the online payment. I use the 
“share receipt” feature at the end of the transaction to get a printout which I 
can clip to invoices or statements or annotate by hand for audit purposes.

> 
> 
> 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.

Happy to share some real-life examples (off-list), if you like.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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

[Michael Hendry]

On 15 Jul 2023, at 11:28, Chris Green  wrote:

> 
>> 
> 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 seem not to be able to run two copies of GnuCash on my Mac, so I can’t test 
this (I haven’t looked at invoking it via the command-line).

I’ve been using GnuCash since 2010 using single files for each of several 
different organisations, and file opening is still effectively instantaneous.

>> 
>> 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!

I have a number of multi-split transactions, and my memory isn’t good enough to 
keep their construction consistent from year to year.

As another example, in the case of the Rotary Club, annual subscriptions fall 
due at the beginning of the Rotary Year (1st July). I duplicate all the 
subscription payments from the previous year, setting the date of payment to 
1st July and the amount to zero after making adjustments for members who have 
left or joined during the year. As subscriptions come in, I edit the relevant 
transactions to correct the date and value paid. This way I can print off a 
report before meetings and jog the memories of tardy payers without having to 
keep track of payments on paper or in a separate app. 

> 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.

I didn’t think there was any value in this until I experimented with the 
multi-report feature. Insights were gained, especially over the Covid years.

> 
> 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.

I see that Michael Novack has answered this from the US legal point of view. 
From a practical point of view, I think it wise always to record the issue of a 
cheque in the books to reduce the risk of an inadvertent overdraft. As cheques 
disappear from use, this likely to disappear as a problem, but I try to ensure 
that bank transfers are made several days before 30th June to ensure that 
they’ve been completed before the year-end.

Clearly, we have both developed ways of dealing with our own circumstances, and 
will probably continue to differ!

A big “hurray” to the GnuCash team for supporting our idiosyncrasies and to 
this list for providing a forum for discussion.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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

[Michael Hendry]

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 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).
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.
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).

(Probably best to start a new thread or take off-list  if you want to continue 
this discussion)

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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?

[Michael Hendry]

On 13 Jul 2023, at 08:01, Chris Green  wrote:

> 
> 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

Morning, Chris,

Have you considered setting up a current account for the Buildings account?

This would allow you to separate the Church and Buildings accounts completely, 
the only extra work being to transfer funds between the current and savings 
accounts as the need arises, with a small balance kept in the (Buildings) 
current account to deal with (eg) small repairs and renewals,

The Rotary Club for which I’m treasurer has two such account pairs for the 
running expenses of the Club itself,  and for the associated Charity. The 
charity is, of course required to have its own bank account because of its 
charitable status.

Regards

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dealing with discounts when not using Business Features

[Michael Hendry]

Thanks, Michael.

IIRC, we exchanged some posts on the list some years ago, when I created 
Liability accounts for donations that were earmarked by the donors for 
particular purposes and later had to backtrack, following the advice of the 
accountant who examines our books. Indeed, I think you may have suggested this 
method.

See interpolations below.

Regards,

Michael
> On 1 Jun 2023, at 15:14, Michael or Penny Novack  
> wrote:
> 
> 
>> As I said, I haven’t been using the Business Features because they’re an 
>> added complication, and because our accounts are kept on a cash basis.
>> 
>> A Bursary is a grant made to assist a talented student who might otherwise 
>> be unable to afford a course. It’s doesn’t usually involve competition (like 
>> a scholarship), and is intended to encourage a talented individual to take 
>> up a course s/he couldn’t otherwise afford.
> 
> 
> I knew what a "bursary" was --- but this more a difference in the  usage of 
> the term "scholarship" across the pond. American English not always the same 
> as yours. Long ago we ceased distinguishing "scholarship" that way, taking 
> the meaning to be just "grant for the purpose of study".
> 
> How to treat this (with reference to accounting, not really a gnucash 
> question) depends on:
> 
> a) Do you want to inflate income/expense of not? Same net done either way.

Neither. The student pays the net course fee, usually with a deposit and one or 
more additional tranches, before attending the course. What I wanted was to be 
able to report the net course fees as an income account, but be able to report 
the gross amount by student including the net course fee along with any 
discounts and bursaries so that we can easily detect over- or under-payments 
and take appropriate action. Sometimes a student will pay the full amount and 
subsequently qualify for a discount because another member of the family has 
signed up, for example.At present, there isn’t a simple way of determining how 
much we’re “spending” on discounts and bursaries from the books.

> 
> b) How independent (in a legal sense) is the source of these bursary funds? 
> In a moral sense? << thus here, a quasi independent fund might be legally 
> under the umbrella of a 501(c)3 << not its own 501(c)3 >> . Thus I am on the 
> boards of a pair like that, the quasi independent fund << used to be legally 
> under a different 501(3)3 >> and the 501(c)3 it is now under (moved there 
> when that organization became 501(c)3. The purpose of the quasi-independent 
> fund being to subsidize the attendance of children at events put on by the 
> now parent organization at a site that does not have lower rates for children.

We haven’t had donations for bursaries recently, and applications are rare in 
any case. In essence, we forgo the income that would have come from the student 
with a bursary, in the same way as we forgo income when granting discounts.

> 
> So very much like your "bursary" fund. But because the special purpose org 
> was once legally independent (and de facto still is) this is handled by 
> negotiated settlement between the boards, one agreeing to subsidize X amount 
> of the children's rate and the organization just sends out registration forms 
> with the resulting lower rate per child. I am giving this particular example 
> because IN ADDITION parents who still could not afford that could apply for 
> "scholarship" help << US usage* >>
> 
> Michael D Novack
> 
> * The split in usage goes back a ways. In the very beginning "scholarships" 
> meant the same both sides of the pond. But then over here we began getting 
> things like benefactors setting up funds with special terms (eg: descendants 
> of so and so: needy students form the town of X, etc.) and in some cases the 
> legislators had funds in their "gift and favor". Institutions might offer 
> "scholarships" to applicants with athletic prowess. Or just need**. So we now 
> no longer associate "scholarship" as being won by competitive academic exam.
> 
> ** In some cases this is closer to the UK sense in that there are some top 
> academic unis that are well endowed and consider "you made the cut to get in" 
> as winning the exam and will then offer aid toward the tuition of students 
> who need it.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dealing with discounts when not using Business Features

[Michael Hendry]

On 1 Jun 2023, at 02:50, Murugan Muruganandam  
wrote:

> 
> michael
> 
> for Bursary accounting purposes you can use the liability option
> 
> Bursary account funding from the donor
> Cr Liability: Bursary:Donor 1 : $1000
> Dr Assets: Bank : $ 1000
> Payment to student invoice
> Dr Assets: Bank : $125 (student pays)
> Cr Income: Fees: $375
> Dr Liability: Bursary: Donor 1: $250 (bursary pays)
> 
> 
> 
> Saludos Cordiales
> 
> Murugan

Thanks, Murugan.

Some years ago I set up a Liability Account for cash received specifically for 
bursaries but was advised by the accountant who examines our books prior to 
their submission to the Office of the Scottish Charity Regulator (“OSCR”) that 
this wasn’t acceptable under Scottish charity accounting rules - we should keep 
track of this cash separately from our books.

We don’t have any such restricted funds now, and meet the cost of bursaries 
along with general expenditure.

Our accountant does the examination of our books for a nominal sum, but I may 
have to impose this query on him to be sure of avoiding wasting his time when I 
submit our records for his approval.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dealing with discounts when not using Business Features

[Michael Hendry]

On 31 May 2023, at 20:46, Vincent Dawans  wrote:

> 
> Personally I would create your Discounts and Bursary accounts as income 
> accounts, possibly even as subaccounts of your main income account for that 
> product/service. Yes they will only have rebates (debits) in them, but they 
> are not an expense, they are a form of reduced income (by choice). The 
> distinction is important in terms of "true accounting representation". Think 
> of it with an extreme case. If I said I charge $1 million for this email 
> advice, but then give you a $999,999.99 discount, as a financial analyst, 
> would you want to see a P with a $1 million income and a  $999,999.99 
> expense or just a $0.01 income and zero expenses? Because you control each 
> side here (the price charged and the rebate), they are one and the same, so 
> it would be the second scenario.
> 
> By it's OK to put it as a "debit" income account, you still have the info in 
> the details of the accounts and can get it out in a report to show how much 
> income you forfeited, but a high-level P will give you the correct income 
> (with the rebate) instead of the extra expense.
> 
> Sincerely,
> 
> Vincent Dawans

Thanks, Vincent, Murugan and Stan.

As I said, I haven’t been using the Business Features because they’re an added 
complication, and because our accounts are kept on a cash basis.

A Bursary is a grant made to assist a talented student who might otherwise be 
unable to afford a course. It’s doesn’t usually involve competition (like a 
scholarship), and is intended to encourage a talented individual to take up a 
course s/he couldn’t otherwise afford.

I’ll look further into Vincent’s and Stan’s suggestions, as I don’t think my 
method of receiving the students’ payments into the Income: Course Fees account 
and then topping them up from Expense: Discount and Expense:Bursary to reach 
the fee that would actually be due will work.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Dealing with discounts when not using Business Features

[Michael Hendry]

More of a bookkeeping query than a GnuCash problem, but here goes…

I am a trustee of a local jazz education charity, the main event being a jazz 
summer school with residential and non-residential options.

We offer discounts of 5% for two or more family members attending, 10% for 
group bookings, and also offer bursaries, but none of is these recorded 
explicitly in the books at the moment.

I plan to introduce two new accounts - Expenses:Discounts and Expenses:Bursary 
- and use these to “top-up” any individual’s payments to Income:Course Fees to 
the appropriate level. This way, each player will be represented in 
Income:Course fees as having paid either the full residential fee or the full 
non-residential fee, and under- or over-payments will be easer to pick up using 
a saved report, which can also itemise the discounts and bursaries using the 
Memo fields to identify the player (as opposed to the person paying, recorded 
in the Description) and the type of discount or bursary.

Does anyone spot any elephant traps that I’m missing?

Regards, and thanks,

Michael




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Lost Keyboard Accelerator feature

[Michael Hendry]

Thanks all,

I eventually found this line in the accelerator-map file

; (gtk_accel_path 
"/GncPluginPageRegisterActions/JumpLinkedInvoiceAction" “”)

and edited it so that it now reads

(gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction" 
"j”)

If I remember correctly, the accelerator-map file distributed with earlier 
versions of GNC included suggested key combinations for all the possible 
actions, so all that was necessary was to remove the leading colon.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Lost Keyboard Accelerator feature

[Michael Hendry]

On 5 May 2023, at 03:10, Murugan Muruganandam  
wrote:

> 
> added note this was installed as per 4.9 release notes.
> 
> ---
> Change the handling of accelerator maps. Gtk no longer supports changing 
> these from the menus and the save no longer writes out the accelerators that 
> have their default values, so to assist users editing them we have generated 
> default ones that we include with GnuCash and have disabled saving when 
> quitting GnuCash. At startup GnuCash will check for the presence of the file 
> accelerator-map in 
> GNC_CONFIG_HOME
>  and if it's not found will copy in the default one.
> --

Thanks, Murugan.

I’d already found this in the release notes, but after I’d deleted the file and 
restarted I couldn’t find the Cmd-1 etc key definitions in the commented-out 
section of the newly-created accelerator-map file. Once I’d copied them in from 
your earlier email, these are now working.

I’m still looking for Cmd-j, and for an idiot’s guide to the construction of 
new entries in accelerator-map.

Regards,

Michael


> 
> 
> 
> So if you delete your existing accelerator-map file and restart Gnucash, it 
> will copy the default one which you can modify
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Murugan Muruganandam 
> Sent: Thursday, May 4, 2023 9:46 PM
> To: jbonn...@internode.on.net ; 
> gnucash-user@gnucash.org 
> Subject: Re: [GNC] Lost Keyboard Accelerator feature
> 
> please use the attached accelerator map file.  some of the tags have changed, 
> i tried it in windows the following keys and it works fine
> 
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/0" "1")
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/1" "2")
> (gtk_accel_path 
> "/GncPluginPageRegisterActions/ViewStyleRadioAction/2" "3")
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan

___
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] Lost Keyboard Accelerator feature

[Michael Hendry]

On 4 May 2023, at 17:54, Adrien Monteleone  
wrote:

> 
> There were some changes made (I thought for 4.14) that alter how these are 
> handled on MacOS. Check the release notes for that and 5.x.
> 
> *note, those don't work for me either in 5.0. As well, they don't show up in 
> the View menu. I never used them to recall if they were visible at one time 
> or when they stopped working.

Thanks, Adrian.

I went straight from 4.1 to 5.1 (NOT 5.1.1, as I said earlier).

I’ve since found that "e” works - opening an Account for editing - 
even though that key combination is commented out in the accelerator map file.

I’ll have a look at the release notes.

Regards,

Michael

> 
> Regards,
> Adrien
> 
> On 5/4/23 9:12 AM, Michael Hendry wrote:
>> On Tuesday (2nd May) I upgraded to version 5.1.1 on my iMac (Ventura 
>> 13.3.1), and have lost the use of Cmd-1, Cmd-2 and Cmd-3 as keyboard 
>> accelerators to change between Basic Ledger, Autosplit Ledger and 
>> Transaction Journal views.
>> Cmd-j switches between accounts, as before.
>> The accelerator-map file(date-stamped 2nd May) includes the following 
>> (uncommented) lines:
>> (gtk_accel_path 
>> "/GncPluginPageRegisterActions/JumpTransactionAction" "j")
>> (gtk_accel_path 
>> "/GncPluginPageRegisterActions/ViewStyleBasicAction" "1")
>> (gtk_accel_path 
>> "/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" 
>> "2")
>> (gtk_accel_path 
>> "/GncPluginPageRegisterActions/ViewStyleJournalAction" "3")
>> If I remember correctly, the first one (Cmd-j) was already set up by default 
>> in earlier versions of GNC, but I had to uncomment the last three to enable 
>> the Journal View accelerators.
>> Anyone else affected by this?
> 


___
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] Lost Keyboard Accelerator feature

[Michael Hendry]

On Tuesday (2nd May) I upgraded to version 5.1.1 on my iMac (Ventura 13.3.1), 
and have lost the use of Cmd-1, Cmd-2 and Cmd-3 as keyboard accelerators to 
change between Basic Ledger, Autosplit Ledger and Transaction Journal views.

Cmd-j switches between accounts, as before.

The accelerator-map file(date-stamped 2nd May) includes the following 
(uncommented) lines:

(gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction" 
"j")

(gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleBasicAction" 
"1")
(gtk_accel_path 
"/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" "2")
(gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleJournalAction" 
"3")

If I remember correctly, the first one (Cmd-j) was already set up by default in 
earlier versions of GNC, but I had to uncomment the last three to enable the 
Journal View accelerators.

Anyone else affected by this?

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Site certificate expiry warning

[Michael Hendry]

I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve just 
been informed that www.gnucash.org is being flagged up as dangerous because its 
site certificate expired recently.

I can get through by overriding the warnings, but I don’t think I should be 
advising others to do so.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved Report Configurations

[Michael Hendry]

On 13 Feb 2023, at 16:39, Adrien Monteleone  
wrote:

> 
> I do the same. I have general configurations saved, but anything particular 
> to that solitary instance of the report, I do not save as part of the 
> configuration. Those will be one-offs so no need to save them as a config, 
> just run and if I want, save as a PDF.
> 
> Regards,
> Adrien

I find it helpful to run some year-end reports part-way through the year in 
question, to answer any  how-are-we-doing-so-far enquiries, so I do save (e.g.) 
a report named “Charity Gift Aid Report for 2022-2023”, but have retained its 
2021-2022 predecessor for comparison. Once the Gift Aid Claim has been 
completed, I’ll edit the report  and Save As “Charity Gift Aid Report for 
2023-2024”. Sometimes a new account becomes necessary and can be added to the 
selection reported on in 2023-2024 leaving the earlier versions intact.

The report name is constructed in three parts, to identify:

1. The Gnucash file it applies to
2. The subject of the report
3. The financial year of the report

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entry of unknown transaction

[Michael Hendry]

On 4 Feb 2023, at 11:58, Jeff  wrote:

> 
> I have discovered several transactions that show up in one account but do not 
> show up in any other existing account. Regardless of what the bank image 
> shows of where the check was deposited.
> 
> I.E.  I have a deposit slip that shows it went to our checking account but 
> never showed up there  (OFX or printed mailed statement).  I can not 
> reconcile it so how do  handle it?
> 
> In other words, I have half of a double entry transaction.  More than one, 
> unfortunately.
> 
> -- 
> --JEffrey Black M.B.A.

Not entirely sure what you mean, Jeffrey.

Are the transactions you refer to recorded in GNUCash as money paid into your 
account but without a recorded source account? This should have a corresponding 
entry in the Imbalance account, automatically created when you put in an 
unbalanced transaction.

Did you receive a check which you deposited in your checking account and for 
which your received a receipt from the bank in the form of a date-stamp on the 
deposit slip, but for which there is no record in the bank statement (paper or 
electronic)?

If yes, then you need to take that up with the bank - was the check bounced?

When you’re reconciling, you’re matching up the bank’s view of the world with 
your own, and can only mark as reconciled the transactions which appear in both.

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Zero balances in report

[Michael Hendry]

On 13 Aug 2022, at 14:08, Fred Tydeman  wrote:
> 
> I am running Linux and GnuCash 4.11
> I do an Account Summary report.
> I have set the options to not show zero balances.
> Yet, the report shows many zero balances.
> The attached screen shot shows part of the report
> along with the options.
>  09-01-37.png>___
> 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.

I’ve just tried this, and when I untick “Include accounts with zero total 
balances” and tick “Omit zero balance figures” I get the desired output.

Did you remember to hit the “Apply” button after changing these tick-boxes?

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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)?

[Michael Hendry]

On 28 Apr 2022, at 11:00, David H  wrote:
> 
> https://lists.gnucash.org/search/?idxinfo=gnucash-user 
> 

Thanks, David,

Here’s a link into the thread I was looking for:

https://lists.gnucash.org/pipermail/gnucash-user/2021-January/094869.html

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Michael Hendry]

In the process of examining a bug in the MRU a couple of years ago, I asked 
about adjusting the maximum number of files in the MRU, and was told (by John 
Ralls?) how to do this on my iMac - I now have 6.

Unfortunately, I can’t trace the correspondence now, and no doubt the 
configuration of “maxfiles” varies depending on the operating system, but it 
occurs to me that setting maxfiles to zero might force GC to open without a 
data file, and help resolve Chris Green’s problem. It would, of course, be 
necessary to use File=>Open to choose the relevant file.

Regards,

Michael

PS Is there a way to search the list for past threads now that Nabble isn’t 
working for GC any more?
___
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 default behavior of ctrl-PgDn

[Michael Hendry]

As an alternative way to enter several transactions earlier than the current 
date and leave the cursor at the bottom, you could try filtering the current 
view of an account in the register so that only the most recent transactions 
are visible. That way, when you complete the historic transaction, it will be 
filtered out and the cursor will stay on a blank transaction at the bottom of 
the screen.

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] change default behavior of ctrl-PgDn

[Michael Hendry]

On 25 Mar 2022, at 01:45, Adrien Monteleone  
wrote:

> 
> I don't think the date itself is relevant. What you want is to get to a new 
> blank transaction, correct?
> 
> I have the same problem using 4.9 on MacOS BigSur. I'm not sure when this 
> started. As far as I know, there is no preference.
> 
> There is a preference for using the 'Enter' key for this function, but that 
> might not be desirable.
> 
> I guess try playing with that and see if it works to your liking.
> 
> But I'd say it is a bug.
> 
> Regards,
> Adrien

Having not investigated a quick way of getting to a new blank transaction 
before, Ive done some experimenting on my iMac (GNC 4.9 + Big Sur).

fn-uptriangle   Top of current register screen
fn-downtriangle Bottom of current register screen
Shift-fn-uptriangle Earliest transaction in register
Shift-fn-downtriangle   Bottom of current register, blank transaction

If I use the extra cluster of nine keys on the wide keyboard:

Shift-uparrow   Earliest transaction in register
Shift-downarrow Bottom of current register, blank transaction

All I have to do now is remember these the next time I need them!

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Managing multiple vehicles

[Michael Hendry]

I do the bookkeeping for my Rotary Club, and have to keep track of individual 
donations from members in order to claim Gift Aid on these donations.

I’m constrained in that I need to keep the donors’ names confidential in 
reports to the club but need to identify the donors for the claim to HMRC.

I worked around this by using the Memo field to identify the member concerned, 
and disabling the Memo field in routine reports to the club. When the time 
comes to make the Gift Aid claim (annually) I use a Transaction Report on the 
Income:Gift Aid account sorted with “Memo” as the Primary Key.

This gives me a subtotal table listing the members and their contributions in 
alphabetical order, with a total, followed by full reports of the donations 
from each individual.

I think this would work for Fernando, with a single Expenses:Vehicles account 
separated into expenses for each vehicle using the Memo field.

If you want Expenses:Vehicles:Fuel, Expenses:Vebicles:Repairs etc, just select 
all of the relevant accounts in the Accounts tab when setting up the 
Transaction Report.

If you forget to fill the Memo field of any transaction, or are inconsistent in 
spelling it will become obvious in the report, allocating a separate section 
for Tractor-1, Tractor_1 and Tractor1 etc.

Michael


> On 8 Feb 2022, at 22:16, Adrien Monteleone  
> wrote:
> 
> Play with your tags and the Transaction Report, particularly the Regex filter 
> option.
> 
> This won't get you a single report with all vehicles, but you can isolate 
> transactions by vehicle that way. (and maybe get something useful out of the 
> Multi-Column Report for more than one vehicle, if not all of them)
> 
> Note, not all fields are filterable, so be sure to check that Report option's 
> tooltip for specifics. (if Notes is an option, turn on Double-Line mode and 
> use that field, it is well suited for it)
> 
> You may not end up with exactly the format you want, but you should be able 
> to get the data.
> 
> Another option would be to do a Find and filter on your tags, then run an 
> Account Report on the result. Unfortunately, there is no current facility to 
> save Find criteria for repetition like there is for customized Reports, so 
> you'd have to do those Finds every time for every vehicle, which might be too 
> much work for 10 vehicles.
> 
> Regards,
> Adrien
> 
> On 2/3/22 1:41 PM, Fernando Castro wrote:
>> Hello everyone,
>> I'm having a rather intense discussion with a friend on a topic that might
>> be common knowledge to most people with accounting experience, and since we
>> are both newbies on accounting and GnuCash, I decided to ask around.
>> We are working on a GnuCash file to keep up with expenses and incomes of a
>> farm. This farm has over 10 vehicles that we'd like to keep track of gas,
>> maintenance and tax expenses. From my point of view creating accounts and
>> subaccounts for this (no matter the hierarchy you chose) would be
>> unmanageable and full of redundancy. This also represents only a small
>> fraction of the farm's finance, but it is important being able to produce a
>> chart with gas expenses for each vehicle.
>> I've read that using other softwares one can benefit from "category" to
>> better filter the information you want and create reports, I've tried using
>> the description field for that using a simple structure like Expenses:Gas
>> and placing the vehicle details as description but it just doesn't work, or
>> maybe I'm doing something wrong?
>> I've also considered making accounts for the vehicles as assets, but
>> honestly I have no idea if this would be a viable solution and even correct
>> from an accounting point of view...
>> Does anyone have any tips on how to go about it?
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Repeatable segmentation fault

[Michael Hendry]

PS I’ve saved before-and-after copies of the relevant gnucash files as 
BookA.gnucash and BookB.gnucash.

BookA performs without crashing with the adjusted date-range, BookB causes a 
corrupt report, including many irrelevant transactions.

The difference between BookA (before) and BookB (after) the changes I made 
today is in a 10-split transaction.

The Club (not the Charity) was to have had a Christmas Meal last week, and ten 
members had paid for it in advance. In the event, Covid caused this to be 
cancelled, and 10 members opted not to have a refund, but to transfer the price 
of the meal to the Charity account. I made a transfer for ten meals from the 
Club’s bank account to the Charity’s, and recorded this as a single transaction 
with a split to account for each member’s contribution, identifying each donor 
in the memo field of the split.

As a workaround, I expect I can split the single deposit from the Club’s bank 
account into the Charity’s as ten individual transactions, and experiment with 
various combined deposits into BookA.

Michael

> On 19 Dec 2021, at 08:06, Michael Hendry  wrote:
> 
> Here is the most recent crash report following a change to the date range of 
> a saved report:
> 
> Process:   Gnucash [13484]
> Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
> Identifier:org.gnucash.Gnucash
> Version:   4.4-1 (4.4-1)
> Code Type: X86-64 (Native)
> Parent Process:??? [1]
> Responsible:   Gnucash [13484]
> User ID:   501
> 
> Date/Time: 2021-12-19 07:45:03.169 +
> OS Version:macOS 11.6.1 (20G224)
> Report Version:12
> Bridge OS Version: 6.0 (19P549)
> Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5
> 
> Sleep/Wake UUID:   3581F509-93A8-4ECD-B111-010BC4BF36B3
> 
> Time Awake Since Boot: 27000 seconds
> Time Since Wake:   2500 seconds
> 
> System Integrity Protection: enabled
> 
> Crashed Thread:0  Dispatch queue: com.apple.main-thread
> 
> Exception Type:EXC_BAD_ACCESS (SIGSEGV)
> Exception Codes:   EXC_I386_GPFLT
> Exception Note:EXC_CORPSE_NOTIFY
> 
> Termination Signal:Segmentation fault: 11
> Termination Reason:Namespace SIGNAL, Code 0xb
> Terminating Process:   exc handler [13484]
> 
> Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
> 0   libgnc-gnome-utils.dylib  0x00010eda7bdf gnc_set_busy_cursor 
> + 111
> 1   libgnc-gnome-utils.dylib  0x00010ee40f1a 
> _wrap_gnc_set_busy_cursor + 58
> 2   libguile-2.2.1.dylib  0x00010e82d53d vm_regular_engine + 
> 1501
> 3   libguile-2.2.1.dylib  0x00010e82c0b3 scm_call_n + 723
> 4   libguile-2.2.1.dylib  0x00010e7a6090 scm_call_3 + 48
> 5   libguile-2.2.1.dylib  0x00010e82d53d vm_regular_engine + 
> 1501
> 6   libguile-2.2.1.dylib  0x00010e82c0b3 scm_call_n + 723
> 7   libguile-2.2.1.dylib  0x00010e7a600a scm_call_1 + 26
> …
> 
> 
> I keep records of donations made to my Rotary Club’s charitable trust by 
> individual members so that I can claim Gift Aid on these gifts, and this 
> worked perfectly at the time the last claim fell due at the beginning of 
> April this year (the Club’s accounts run from July to June).
> 
> I’ve recorded a batch of recent relevant transactions, and ran the report for 
> April 2020 to March 2021 before changing the date range to 1 Apr 2021 to 31 
> Mar 2022 and the Report Name to “Gift Aid Report for 2021-2022” and clicking 
> “Apply”.
> 
> Usually this results in a crash, but sometimes a faulty report is produced, 
> including some accounts which are not in the selection made and missing some 
> which should be included.
> 
> I’d appreciate advice on the best way to investigate and report further on 
> this issue.
> 
> Regards,
> 
> Michael
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Repeatable segmentation fault

[Michael Hendry]

Here is the most recent crash report following a change to the date range of a 
saved report:

Process:   Gnucash [13484]
Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   4.4-1 (4.4-1)
Code Type: X86-64 (Native)
Parent Process:??? [1]
Responsible:   Gnucash [13484]
User ID:   501

Date/Time: 2021-12-19 07:45:03.169 +
OS Version:macOS 11.6.1 (20G224)
Report Version:12
Bridge OS Version: 6.0 (19P549)
Anonymous UUID:F889FA2B-0F71-CD50-6275-EA85633D47E5

Sleep/Wake UUID:   3581F509-93A8-4ECD-B111-010BC4BF36B3

Time Awake Since Boot: 27000 seconds
Time Since Wake:   2500 seconds

System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   EXC_I386_GPFLT
Exception Note:EXC_CORPSE_NOTIFY

Termination Signal:Segmentation fault: 11
Termination Reason:Namespace SIGNAL, Code 0xb
Terminating Process:   exc handler [13484]

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   libgnc-gnome-utils.dylib0x00010eda7bdf gnc_set_busy_cursor 
+ 111
1   libgnc-gnome-utils.dylib0x00010ee40f1a 
_wrap_gnc_set_busy_cursor + 58
2   libguile-2.2.1.dylib0x00010e82d53d vm_regular_engine + 
1501
3   libguile-2.2.1.dylib0x00010e82c0b3 scm_call_n + 723
4   libguile-2.2.1.dylib0x00010e7a6090 scm_call_3 + 48
5   libguile-2.2.1.dylib0x00010e82d53d vm_regular_engine + 
1501
6   libguile-2.2.1.dylib0x00010e82c0b3 scm_call_n + 723
7   libguile-2.2.1.dylib0x00010e7a600a scm_call_1 + 26
…


I keep records of donations made to my Rotary Club’s charitable trust by 
individual members so that I can claim Gift Aid on these gifts, and this worked 
perfectly at the time the last claim fell due at the beginning of April this 
year (the Club’s accounts run from July to June).

I’ve recorded a batch of recent relevant transactions, and ran the report for 
April 2020 to March 2021 before changing the date range to 1 Apr 2021 to 31 Mar 
2022 and the Report Name to “Gift Aid Report for 2021-2022” and clicking 
“Apply”.

Usually this results in a crash, but sometimes a faulty report is produced, 
including some accounts which are not in the selection made and missing some 
which should be included.

I’d appreciate advice on the best way to investigate and report further on this 
issue.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where would enter revenue that could be paid to shareholders?

[Michael Hendry]

On 5 Dec 2021, at 11:39, Dr. David Kirkby  
wrote:

> 
> If a company can potentially pay out X pounds, but has not paid out any at
> all, where would that be entered in GnuCash? I assume its a liability, but
> should it be entered into liabilities, or perhaps retained earnings?

I’m not an accountant.

I keep the books for a couple of charities, one of which receives donations 
which the donor has ear-marked for a particular purpose which might not come up 
in the same financial year.

I thought it would be a good idea to record this as a liability, which would 
survive the year-end and remind the trustees that there was a sum which  could 
only be spent for that purpose, but I was hauled up by the accountant who 
examines our records for the charities register, and had to abandon that 
method. 

I don’t know if this restriction applies to a company’s books, but if it does 
you might consider creating a budget, which would include run-of-the-mill 
income and expenditure but could also include predicted dividend payments 
without interfering with the books.

You should probably get professional advice…

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report printing of annual transactions

[Michael Hendry]

On 7 Nov 2021, at 17:37, sydnorbill...@bellsouth.net wrote:

> 
> I had posted previously in trying to print a volume of year/y transactions
> for a reference compilation in black and white of all entries in account
> number order for any given year, I couldn't get the amounts to be included,
> and what had worked previously I can't find a way back to as the amounts do
> not appear in the line item results.  What I had gotten previously was a
> report with columns of:  Date, Description, Account, Transfer from/to, debit
> [amount], credit, [amount] Running balance [amount].  It listed pages of the
> many line item entries ending in totals by account with a bold line of text
> stating Total for [account number, account name]  TOTAL.   Trying to set up
> under General Ledger, General Journal, Transaction Report doesn't come close
> and I make my Options selections and put in the date range desired, and
> Select all in the Accounts and have program preferences set to the proper
> accounting range. 
> 
> 
> 
> So how do I print a report that has every transaction for the yearly
> accounting period January 01 through December 31 of any given year by
> account number?

Here’s how I produce a General Journal ordered by Account NAME.

Open the Transaction Report.

Click on Options

Click the “General” tab.

Choose the start and end dates.

Click the “Sorting” tab.

Choose Account Name as your Primary Key


This doesn’t quite deliver for you, as want to order by account NUMBER, but it 
should give you a start.

Hope that helps,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question from newbie

[Michael Hendry]

On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
> 
>   Hello there,
>   'I'm having trouble on how to record buying groceries on Jan. 1  with a
>   head check for Feb. 1
>   What I understood from the manual that this is not an expense but a
>   liablity but I don't understand if I should make two accounts one
>   expense: grocery and one "liability: grocery" or some easier way to
>   record this.
>   Thank you very much for the help
>   Shevach
>   gif

I’m assuming a “head check” is what we in the UK would call a post-dated cheque 
- a cheque which can’t be cashed until a stated date; for what it’s worth, I 
understand that banks in the UK will often make the payment if the cheque is 
presented early.

I would suggest recording the expense on the date of the purchase as a 
transaction between your checking account and the grocery store. If you wish, 
you could add a note to indicate that the check can’t be presented until 1st 
Feb to avoid confusion when reconciling the bank account.

It’s a similar situation to making a postal payment by check - you know that 
the payee won’t receive it for several days and may not take it to the bank for 
several days after that, but you’re recording your commitment to the payee 
rather than the date on which the bank transfers the money to his account.

I am not an accountant, but there are those on the list who will no doubt 
correct me if there are problems with the way I view this!

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

[Michael Hendry]

> On 5 Nov 2021, at 16:43, Frank H. Ellenberger  
> wrote:
> 
> Hi Michael,
> 
> there is no hack.Every body can create a bugzilla account and write
> nonsense there. Because the treshold is low - no captchas  etc. -
> recently some "Search engine optimizers (SEOs)" found it a cheap way to
> propagate their client's URLs.
> 
> It is not only GnuCash affected, it is a wave rolling through the net.
> 
> It is usually fixed after short time, see
> https://wiki.gnucash.org/wiki/Bugzilla_Administration#Pending_Tasks
> 
> In my feeling SEOs are thieves stealing developer time!
> 
> Am 05.11.21 um 11:22 schrieb Michael Hendry:
>> I’ve received several emails like this recently, all ostensibly related to 
>> bugs I had reported, but the text is not relevant to the bug, and has 
>> numerous suspicious URLs which I haven’t followed.
>> 
>> The text doesn’t appear in the comments section relating to the bugs.
>> 
>> Michael Hendry
>> 
>>> On 4 Nov 2021, at 14:04, bugs-ad...@bugs.gnucash.org wrote:
>>> 
>>> https://bugs.gnucash.org/show_bug.cgi?id=797953
>>> 
>>> Ahmed Sayeed  changed:
> CENSORED
> 
> Never forward Spam to any Mailing-List! Now the links are in the archive.
> 
> Warlord, can you fix that?
> 
> Regards
> Frank

Dear John and Frank,

Thanks for the reassurance from both and the telling-off from Frank!

I take it there’s no way I can delete the post I sent which includes all those 
unwanted URLs?

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

[Michael Hendry]

I’ve received several emails like this recently, all ostensibly related to bugs 
I had reported, but the text is not relevant to the bug, and has numerous 
suspicious URLs which I haven’t followed.

The text doesn’t appear in the comments section relating to the bugs.

Michael Hendry

> On 4 Nov 2021, at 14:04, bugs-ad...@bugs.gnucash.org wrote:
> 
> https://bugs.gnucash.org/show_bug.cgi?id=797953
> 
> Ahmed Sayeed  changed:
> 
>   What|Removed |Added
> 
> CC||ahmedsayeed1...@yahoo.com
> 
> --- Comment #3 from Ahmed Sayeed  ---
> [gdb/symtab] Handle DW_TAG_type_unit in process_psymtab_comp_unit 
> 
>When running test-case gdb.cp/cpexprs-debug-types.exp with target board
>unix/gdb:debug_flags=-gdwarf-5, I run into:
>...
>(gdb) file cpexprs-debug-types^M
>Reading symbols from cpexprs-debug-types...^M
>ERROR: Couldn't load cpexprs-debug-types into GDB (eof).
>ERROR: Couldn't send delete breakpoints to GDB.
>ERROR: GDB process no longer exists
>GDB process exited with wait status 23054 exp9 0 0 CHILDKILLED SIGABRT
> SIGABRT
>... https://www.webb-dev.co.uk/crypto/crypto-for-investing/
> 
>We're running into this abort in process_psymtab_comp_unit:
>...
>  switch (reader.comp_unit_die->tag) 
>{
>case DW_TAG_compile_unit:
>  this_cu->unit_type = DW_UT_compile;
> http://www.compilatori.com/tech/nvidia-and-samsung/
>  break;
>case DW_TAG_partial_unit:
>  this_cu->unit_type = DW_UT_partial;
> http://www.acpirateradio.co.uk/tech/nvidia-and-samsung/
>  break;
>default:
>  abort (); http://www.logoarts.co.uk/tech/nvidia-and-samsung/ 
>}
>...
>because reader.comp_unit_die->tag == DW_TAG_type_unit.
> http://www.slipstone.co.uk/tech/nvidia-and-samsung/
>Fix this by adding a DW_TAG_type_unit case.
> 
>Tested on x86_64-linux.
> 
>gdb/ChangeLog: http://embermanchester.uk/tech/nvidia-and-samsung/
> [gdb/symtab] Handle DW_TAG_type_unit in process_psymtab_comp_unit
> 
>When running test-case gdb.cp/cpexprs-debug-types.exp with target board
>unix/gdb:debug_flags=-gdwarf-5, I run into:
> http://connstr.net/tech/nvidia-and-samsung/
>...
>(gdb) file cpexprs-debug-types^M
>Reading symbols from cpexprs-debug-types...^M
> http://joerg.li/tech/nvidia-and-samsung/
>ERROR: Couldn't load cpexprs-debug-types into GDB (eof).
>ERROR: Couldn't send delete breakpoints to GDB.
>ERROR: GDB process no longer exists
> http://www.jopspeech.com/tech/nvidia-and-samsung/
>GDB process exited with wait status 23054 exp9 0 0 CHILDKILLED SIGABRT
> SIGABRT
>...
> 
>We're running into this abort in process_psymtab_comp_unit:
> http://www.wearelondonmade.com/tech/nvidia-and-samsung/
>...
>  switch (reader.comp_unit_die->tag)
>{
>case DW_TAG_compile_unit:
> https://waytowhatsnext.com/technology/korean-technology/
>  this_cu->unit_type = DW_UT_compile;
>  break;
>case DW_TAG_partial_unit:
> http://www.iu-bloomington.com/technology/miui13/
>  this_cu->unit_type = DW_UT_partial;
>  break;
>default:
>  abort (); https://komiya-dental.com/technology/miui-13/
>}
>...
>because reader.comp_unit_die->tag == DW_TAG_type_unit.
>http://www-look-4.com/tech/nvidia-and-samsung/
>Fix this by adding a DW_TAG_type_unit case.
> 
>Tested on x86_64-linux.
>https://www.webb-dev.co.uk/technology/grt-r910/
>gdb/ChangeLog:
> 
> -- 
> You are receiving this mail because:
> You reported the bug.

___
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] Export Current Search

[Michael Hendry]

On 2 Nov 2021, at 07:31, Mike Stillingfleet  
wrote:
> 
> Dear GNUCash Forum,
> 
> Firstly I how that I have posted this correctly.
> 
> I have read in the GNU Cash help that if I have focus on the current search I 
> should see 4 export options and one of those will be File->Export->Export 
> Active Register to CSV.
> 
> I do not have that option.
> 
> Is this something that has been removed?
> 
> How else could I export the current search?
> 
> TIA

After you have run the search, you will have a “Search Results” tab open.

From the “Reports” menu, choose “Account Report”.

Click the “Export” button, and save the file to HTML.

Before the Export stage, you can adjust the contents of the report using the 
“Options” button.

I’m using LibreOffice for the next stage, but presumably other office suites 
will do the same.

Open the HTML file in LibreOffice.

Select All, and Copy to clipboard.

Open a new Spreadsheet file.

Paste.

Save As CSV.


This is a very roundabout route, but if this is a one-off job probably 
worthwhile,

Michael

PS Curses! As I was about to send this, David Cousens beat me to it with a 
proper solution! The feature that misled me (and presumably Mike) is that the 
Export button that appears once the Register tab is selected implies that this 
is the only way to export from a register, and blinded me to that alternative 
route.
___
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] Lost my top level aka Master account

[Michael Hendry]

On 6 Sep 2021, at 15:49, Mom  wrote:
> 
> Dear All:
> 
> I have been keeping my checkbook register on a Mac Powerbook computer via 
> GnuCash since at least 2014. I recently migrated to a new-to-me Mac and when 
> I open my GnuCash files, I no longer seem to have the top level account 
> (master) file to my checkbook register! All of the income/expense detail 
> accounts are there but without the master checking account file, I don’t have 
> a running balance and I don’t see my transactions in calendar order.
> 
> Does anyone know how I can recover my master account? Any insight as to what 
> has happened to my backup files?
> 
> Your help is much appreciated. I am hoping not to need to recreate my 
> register for at least this calendar year.
> 
> Anne Giordani

Morning, Anne.

First, assuming you’re using the XML version (not the version that saves files 
in the sqlite format), have you got backups of the all the .gnucash files from 
your old computer in a safe place?

Second, did you use the Apple Migration Assistant to move the files across from 
your Powerbook to your new Mac?

Third, can you explain what you mea by “the master checking account file”?

Each .gnucash file has its own chart of accounts, accessed via the Accounts 
tab. The usual place for a checking account would be:

Assets:Current Assets:Checking

and if you have multiple .gnucash files relating to this bank account, each 
should have its own Assets:Current Assets:Checking account.

The only suggestion I have at this stage is that you may accidentally have 
“Hidden” your checking account. Assuming you still have Assets visible in the 
Accounts tab, right-click and choose Edit Account, making sure “Hidden” isn’t 
checked, and working down the Assets:Current Assets:Checking tree until you 
find the missing account. I’m afraid it’s unlikely to be as simple as that, and 
you may have to go back to your old Powerbook (or the backup you took before 
starting the transfer?) to recover your books.

Good Luck,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account report with transactions

[Michael Hendry]

> On 29 Aug 2021, at 13:47, Manfred Usselmann  wrote:
> 
> Thanks, this was very helpful.
> 
> The Running Balance option on the display tab was not visible, I had to 
> scroll down. The window is too small to show all options at once and I didn't 
> notice it.
> 
> The only issue I still have is that accounts without movements in the period 
> are not displayed.
> 
> Regards,
> Manfred
> 
> 

You could try putting in a dummy transaction with zero in the debit and credit 
columns dated (for example) at the beginning or end of the accounting period. 
You could even preload all relevant accounts with such a dummy, and overwrite 
them when the time comes to put in genuine transactions.

Or even create a set of dummy transactions for each of the relevant accounts 
which are scheduled to take place at the beginning of each accounting period - 
but maybe that’s going a bit too far!

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account report with transactions

[Michael Hendry]

On 29 Aug 2021, at 12:05, Manfred Usselmann  wrote:
> 
> Hi,
> 
> I'm looking for an account report with transactions for a certain time period 
> with intial and final account value.
> 
> E.g. account value at the beginning of the year, all transactions during the 
> year and the total value at the end of the year.
> 
> What would be the best way to create this?
> 
> Thanks,
> Manfred
> ___

I suggest you try Reports-> Transaction Report.


Choose the account you’re interested in on the Accounts tab, set the Start Date 
and End Date on the General Tab, and select Running Balance on the Display Tab.

You may need to tweak some of the other options to get what you want (I’m not 
sure if the default settings in my setup are the GNC defaults).

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Changing the order of splits

[Michael Hendry]

On 29 Jul 2021, at 11:53, David Sumbler  wrote:
> 
> I have a set of accounts in which some transactions have a considerable
> number of splits, each one relating to an individual person.  All of
> these splits have the same amount in the debit column, but the number
> of splits in each of these transactions varies.
> 
> When I need to add a new transaction of this type, I duplicate an
> earlier one.  I then edit the new one, editing and adding/removing
> splits as needed.
> 
> The trouble with this is that the order of the Account names in the
> splits ends up rather confused.  However, I can't find any way of re-
> ordering them, which seems strange.  After all, some people might want
> the Accounts to be in, say, alphabetical order.  That is not my
> requirement, but I would like some particular Accounts to appear
> vertically adjacent to each other.
> 
> My question is, is there any way at all of moving splits up or down
> within the list?
> 
> David

As treasurer of my Rotary Club I have a couple of similar problems to resolve.

1. Annual Subscriptions fall due on 1st July.

2. Members (and non-members) make donations during the year - mostly via 
various events the club runs - and I have to keep a track of these for Gift Aid 
purposes. The nominated destinations of these funds have to be recorded and 
reported on too.

1. Is relatively straightforward to manage, and has the bonus of keeping track 
of who hasn’t yet paid within Gnucash.

On the first of July I created a payment of £0 from each member into our 
current bank account from our Members’ Subscriptions Income Account, with a 
member’s name in the Description field in Surname, Forename format.

I then set up a Transaction Report for the Members’ Subscriptions Account, with 
a date range 1st June 2021 to 30th June 2022 (because there’s always someone 
who makes an early payment by online banking) sorted by date (primary key) and 
name (secondary key).

As the subs were paid, I edited each member’s transaction to correct the date 
and amount paid. Reloading the transaction report now brings up a list 
highlighting those who haven’t yet paid in the 1st July slot


2. Is more complex because I have to keep track of various categories of 
income. Income:Donations:GA (for Gift Aid) is the parent, with various children 
(Whisky Tasting, Foundation, Quiz, Water Account). I also chose to use the Memo 
field to record the donor’s name, with the source event in the Description 
field. This facilitates anonymous reporting to the club as opposed to the claim 
to HMRC for Gift Aid, which obviously requires the donors’ details.

In this case the primary key is the Memo field and the secondary is by register 
order.


I don’t think I’ve got any transactions with additional splits, but I believe 
these should be reported correctly by the above Transaction Report method.

I’m not sure how your payments arise - if you’re receiving a fixed sum each 
month from a variable (but finite) number of individuals, it might be worth 
setting up a Scheduled transaction for all and deleting the unnecessary ones.

Hope this helps, and happy to correspond off-list if that helps

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Considering upgrade from late-2012 iMac 27inch to current iMac 27inch

[Michael Hendry]

On 19 Jun 2021, at 17:49, Michael Hendry  wrote:
> 
> I’m planning to replace my current iMac with its current equivalent, which 
> will presumably run Big Sur.
> 
> Although the 24 inch models use the Apple M1 chip, the 27 inch iMac has an 
> Intel Core i9 processor, so I’m hopeful that any software I’m currently using 
> (with Mac OS Catalina) will run OK on the replacement.
> 
> Can anyone comment on this as it applies to GnuCash?
> 
> Regards,
> 
> Michael

I’m happy to report that once I’d cloned my old iMac (end 2012) to my new one 
(mid 2020) I was able to run GnuCash 4.4 without any issues. The new computer 
has an Intel processor, not an M1.

In due course, I’ll upgrade to 4.6, but my needs are simple, and I’ll leave it 
until I’ve checked over all my other non-Apple applications.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur

[Michael Hendry]

> On 29 Jun 2021, at 07:52, Anita Graves  wrote:
> 
> Please see the attached screenshot:
> 
> I don’t know what to do but I refuse to delete the file I need to work with, 
> or any of the other files in the history list.  This all happened to me when 
> I installed GC 4.6.  Before I was using 4.1.  Now, when I try to import a log 
> file it gives the same screen.   Then GC crashes!
> 
> I am afraid to wipe all my history and all my work!
> 
> Thanks for your help and suggestions.
> 
> Anita

That’s disappointing, to say the least!

I’m shortly going to be forced to use Big Sur when I upgrade my elderly iMac, 
and have confirmed through a friend who has a more recent iMac version with Big 
Sur, that he can install and run 4.6 without difficulty - but of course this 
was a clean installation with no data files, history, etc.

Unfortunately, your screenshot didn’t survive the journey to my inbox, so I 
can’t see the warning you received.

IIUC, the history list is there for convenience only, and if you allow it to be 
deleted you can still open your accounts by using File=>Open and then choosing 
the book you want - you have to do this anyway, if you are managing more than 
the maximum number of books the history list can handle (4 by default, max 6).

I hope you have all your important files backed up - easy to do if you use Time 
Machine on your Mac, but you might also want to copy everything you need into a 
local directory.

I don’t think I’ve ever imported a log file, except perhaps as a 
what-does-this-do? experiment. Did something go wrong before you did this? 


Best of luck!

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Frustration

[Michael Hendry]

> On 7 Jun 2021, at 17:30, John Ralls  wrote:
> 
> 
> 
>> On Jun 6, 2021, at 11:22 PM, Michael Hendry  wrote:
>> 
>>> On 7 Jun 2021, at 06:57, flywire  wrote:
>>> 
>>> What you want is very simple, just not in GnuCash which is possibly the only
>>> package without it. The workaround changing accounts is just not worth the
>>> grief.
>>> 
>>> Other software allows a category or class[ification] field on each
>>> transaction. Normally the field is even auto-populated based on say a
>>> payment by a tenant. One field is still not ideal because you might want
>>> multiple classifications on one transaction like bigger accounting packages
>>> offer (location, manager, supplier, owner, enterprise etc). The feature's
>>> been requested fairly frequently for ages:
>>> https://bugs.gnucash.org/show_bug.cgi?id=113772
>>> 
>>> Best thing you can do is change to different software. I use an old
>>> quickbooks version for my business to get that feature but you miss out on
>>> the open access to the database and potential reporting that brings. Say
>>> rental statements, performance per unit or property manager.
>>> 
>>> Maybe look at https://kmymoney.org/
>> 
>> 
>> I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my 
>> Most-Recently-Used (MRU) list.
>> 
>> Some time ago I reported a bug in the updating of the MRU which was fixed in 
>> the next release, and it was about this time that the 6-item MRU became 
>> available on my system.
>> 
>> I can’t find a Preferences setting for the number of files in the MRU, but 
>> I’m sure John Ralls could point a finger in the right direction.
> 
> Not sure what MRU has to do with categories.

This has been a long thread, and earlier on there was a complaint about not 
being able to have > 4 files in the MRU list.

You had shared the magic “defaults write…” incantation with me, but I used it 
once (all that was necessary) and promptly forgot how I’d done it. 

Apologies for the noise!

Michael

> 
> The MRU list size preference isn't exposed in the GnuCash UI. Linux users can 
> get to it with dconf-editor and macOS users via defaults, e.g.
>  defaults write -app Gnucash /org/gnucash/history/maxfiles '6'
> Microsoft Windows users can get to it via regedit, it will be somewhere under 
> IIRC HKCU\Software\Gnucash.
> 
> Regards,
> John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Frustration

[Michael Hendry]

> On 7 Jun 2021, at 17:30, John Ralls  wrote:
> 
> 
> 
>> On Jun 6, 2021, at 11:22 PM, Michael Hendry  wrote:
>> 
>>> On 7 Jun 2021, at 06:57, flywire  wrote:
>>> 
>>> What you want is very simple, just not in GnuCash which is possibly the only
>>> package without it. The workaround changing accounts is just not worth the
>>> grief.
>>> 
>>> Other software allows a category or class[ification] field on each
>>> transaction. Normally the field is even auto-populated based on say a
>>> payment by a tenant. One field is still not ideal because you might want
>>> multiple classifications on one transaction like bigger accounting packages
>>> offer (location, manager, supplier, owner, enterprise etc). The feature's
>>> been requested fairly frequently for ages:
>>> https://bugs.gnucash.org/show_bug.cgi?id=113772
>>> 
>>> Best thing you can do is change to different software. I use an old
>>> quickbooks version for my business to get that feature but you miss out on
>>> the open access to the database and potential reporting that brings. Say
>>> rental statements, performance per unit or property manager.
>>> 
>>> Maybe look at https://kmymoney.org/
>> 
>> 
>> I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my 
>> Most-Recently-Used (MRU) list.
>> 
>> Some time ago I reported a bug in the updating of the MRU which was fixed in 
>> the next release, and it was about this time that the 6-item MRU became 
>> available on my system.
>> 
>> I can’t find a Preferences setting for the number of files in the MRU, but 
>> I’m sure John Ralls could point a finger in the right direction.
> 
> Not sure what MRU has to do with categories.

This has been a long thread, and earlier on there was a complaint about not 
being able to have > 4 files in the MRU list.

You had shared the magic “defaults write…” incantation with me, but I used it 
once (all that was necessary) and promptly forgot how I’d done it. 

Apologies for the noise!

Michael

> 
> The MRU list size preference isn't exposed in the GnuCash UI. Linux users can 
> get to it with dconf-editor and macOS users via defaults, e.g.
>  defaults write -app Gnucash /org/gnucash/history/maxfiles '6'
> Microsoft Windows users can get to it via regedit, it will be somewhere under 
> IIRC HKCU\Software\Gnucash.
> 
> Regards,
> John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Frustration

[Michael Hendry]

> On 7 Jun 2021, at 06:57, flywire  wrote:
> 
> What you want is very simple, just not in GnuCash which is possibly the only
> package without it. The workaround changing accounts is just not worth the
> grief.
> 
> Other software allows a category or class[ification] field on each
> transaction. Normally the field is even auto-populated based on say a
> payment by a tenant. One field is still not ideal because you might want
> multiple classifications on one transaction like bigger accounting packages
> offer (location, manager, supplier, owner, enterprise etc). The feature's
> been requested fairly frequently for ages:
> https://bugs.gnucash.org/show_bug.cgi?id=113772
> 
> Best thing you can do is change to different software. I use an old
> quickbooks version for my business to get that feature but you miss out on
> the open access to the database and potential reporting that brings. Say
> rental statements, performance per unit or property manager.
> 
> Maybe look at https://kmymoney.org/


I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my 
Most-Recently-Used (MRU) list.

Some time ago I reported a bug in the updating of the MRU which was fixed in 
the next release, and it was about this time that the 6-item MRU became 
available on my system.

I can’t find a Preferences setting for the number of files in the MRU, but I’m 
sure John Ralls could point a finger in the right direction.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[Michael Hendry]

> On 2 Jun 2021, at 02:44, Peter West  wrote:
> 
> I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts 
> (at top level in my CoA) extremely useful, and I understand why they are 
> there. If I ever see a balance, I know I have to fix something, which is a 
> good reason to have them at the top. I can’t comment on any changes that 
> might have occurred in the behaviour of these accounts recently. However, in 
> respect of the tidiness of the CoA, one possible solution is to create a 
> special case for these accounts, such that they only display in the CoA 
> listing when they have a non-zero balance.
> 
> Peter


Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out 
the problem and zeroed their contents - they’ll be created automatically if 
required.

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Michael Hendry]

> On 31 May 2021, at 15:10, Howard M. Fried  wrote:
> 
> I have several invoices that were issued in 2020 but paid in 2021. These 
> funds are not included in a P report for 2021, apparently because the 
> report is based on date of invoice issue, or have I missed something.
> 
> Is it possible to get the 2020 Sales that were paid in 2021 into the report 
> for 2021?  Simply extending the Report date range backward is not a solution 
> because many invoices that were issued and paid in 2020 will be included.  Or 
> am I to include unrealized assets for 2020 as profit, like the P report 
> does (I have no accounting, financial, or legal experience in such matters).
> 
> Thank you for considering,
> Howard Fried

Not an accountant either, Howard, but I believe the approach varies according 
to whether your books are kept on a cash or an accrual basis.

If cash, then reports are based on the date when you received income, or the 
date you made a payment for expenses.

I don’t use the business features, but I think that you will be working on an 
accrual basis, and have reports on Accounts Receivable and Accounts Payable 
which carry over the end of the financial year.

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "No suitable backend" message trying to open an alias to a gnucash file

[Michael Hendry]

> On 27 Apr 2021, at 22:12, Michael Hendry  wrote:
> 
>> On 27 Apr 2021, at 19:07, John Ralls  wrote:
>> 
>> 
>> 
>>> On Apr 26, 2021, at 11:41 PM, Michael Hendry  
>>> wrote:
>>> 
>>>> On 27 Apr 2021, at 00:57, John Ralls  wrote:
>>>> 
>>>> 
>>>> 
>>>>> On Apr 26, 2021, at 2:00 PM, Michael Hendry  
>>>>> wrote:
>>>>>  the source file in the destination directory, but subsequent changes in 
>>>>> the source file aren’t reflected in the destination. Can you confirm that 
>>>>> this has been fixed in 11.3?
>>> 
>> Michael,
>> 
>> That's the expected behavior because with the XML backend when GnuCash saves 
>> it first renames the original file--the one you hard-linked--to become the 
>> backup file. If you switch to the SQLite3 backend it will work the way you 
>> want.
>> 
>> Regards,
>> John Ralls
> 
> Of course!
> 
> Thank you.
> 
> Michael

PS Just to report that I’ve abandoned the linked file approach and set up a 
cron job to copy the relevant files to ~/Dropbox on a daily basis. This 
provides an offsite backup of these files, and will allow my deputy to download 
the most recent copies in my absence. I’m not expecting the deputy to edit the 
accounts, just to be able to check the current state of the accounts and deal 
with any urgent matters.

It took longer than expected to set up the task because cron wasn’t allowed 
access to the files - MacOS Catalina requires specific permission. 

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "No suitable backend" message trying to open an alias to a gnucash file

[Michael Hendry]

> On 27 Apr 2021, at 19:07, John Ralls  wrote:
> 
> 
> 
>> On Apr 26, 2021, at 11:41 PM, Michael Hendry  
>> wrote:
>> 
>>> On 27 Apr 2021, at 00:57, John Ralls  wrote:
>>> 
>>> 
>>> 
>>>> On Apr 26, 2021, at 2:00 PM, Michael Hendry  
>>>> wrote:
>>>> 
>>>> I’m using GC 4.4 on iMac, running OS X Catalina.
>>>> 
>>>> I want to place a book (say “BookA.gnucash”) in a Dropbox folder so that a 
>>>> deputy can take over in the event of my not being available at short 
>>>> notice.
>>>> 
>>>> Dropbox now requires original files, not aliases, in the Dropbox 
>>>> directory, so I can’t keep my books in ~/Documents/Accounts and provide 
>>>> links.
>>>> 
>>>> In any case, Apple seems to have broken the command-line tool “ln”, so I 
>>>> can’t use that mechanism.
>>>> 
>>>> Finder offers a means of creating an alias via right-clicking on a 
>>>> filename, so I tried putting BookA.gnucash in ~/Dropbox, and placing an 
>>>> alias called BookA.gnucash in ~/Documents/Accounts, but when I try to open 
>>>> BookA via the alias I get the “No suitable backend” message.
>>>> 
>>>> I’ve found this technique works OK for a simple text file, edited with 
>>>> MacVim.
>>>> 
>>>> A cron job that copied the current version of BookA.gnucash to Dropbox on 
>>>> a regular basis and as part of the shutdown sequence should work, but I 
>>>> haven’t tried it yet.
>>>> 
>>>> Any other suggestions?
>>> 
>>> Michael,
>>> 
>>> Both `ln` to make a hard link and `ln -s` to make a symlink work for me 
>>> (macOS 11.3 Beta (20E5217a)) and GnuCash 4.5 is able to open either of them.
>> 
>> On my late-2012 iMac 27 inch, “ln” appears to work at first, making an 
>> up-to-date copy of the source file in the destination directory, but 
>> subsequent changes in the source file aren’t reflected in the destination. 
>> Can you confirm that this has been fixed in 11.3?
>> 
> Michael,
> 
> That's the expected behavior because with the XML backend when GnuCash saves 
> it first renames the original file--the one you hard-linked--to become the 
> backup file. If you switch to the SQLite3 backend it will work the way you 
> want.
> 
> Regards,
> John Ralls

Of course!

Thank you.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] "No suitable backend" message trying to open an alias to a gnucash file

[Michael Hendry]

> On 27 Apr 2021, at 00:57, John Ralls  wrote:
> 
> 
> 
>> On Apr 26, 2021, at 2:00 PM, Michael Hendry  wrote:
>> 
>> I’m using GC 4.4 on iMac, running OS X Catalina.
>> 
>> I want to place a book (say “BookA.gnucash”) in a Dropbox folder so that a 
>> deputy can take over in the event of my not being available at short notice.
>> 
>> Dropbox now requires original files, not aliases, in the Dropbox directory, 
>> so I can’t keep my books in ~/Documents/Accounts and provide links.
>> 
>> In any case, Apple seems to have broken the command-line tool “ln”, so I 
>> can’t use that mechanism.
>> 
>> Finder offers a means of creating an alias via right-clicking on a filename, 
>> so I tried putting BookA.gnucash in ~/Dropbox, and placing an alias called 
>> BookA.gnucash in ~/Documents/Accounts, but when I try to open BookA via the 
>> alias I get the “No suitable backend” message.
>> 
>> I’ve found this technique works OK for a simple text file, edited with 
>> MacVim.
>> 
>> A cron job that copied the current version of BookA.gnucash to Dropbox on a 
>> regular basis and as part of the shutdown sequence should work, but I 
>> haven’t tried it yet.
>> 
>> Any other suggestions?
> 
> Michael,
> 
> Both `ln` to make a hard link and `ln -s` to make a symlink work for me 
> (macOS 11.3 Beta (20E5217a)) and GnuCash 4.5 is able to open either of them.

On my late-2012 iMac 27 inch, “ln” appears to work at first, making an 
up-to-date copy of the source file in the destination directory, but subsequent 
changes in the source file aren’t reflected in the destination. Can you confirm 
that this has been fixed in 11.3?

If so, it looks like time for me to upgrade to Big Sur - have you had any 
issues with the Beta version?

> 
> You're right that GnuCash doesn't know what to do with a Finder alias file.
> 
> You could of course use your GnuCash file directly from ~/Dropbox.

I was hoping to avoid having all the backup and log files in ~/Dropbox.

Thanks,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] "No suitable backend" message trying to open an alias to a gnucash file

[Michael Hendry]

I’m using GC 4.4 on iMac, running OS X Catalina.

I want to place a book (say “BookA.gnucash”) in a Dropbox folder so that a 
deputy can take over in the event of my not being available at short notice.

Dropbox now requires original files, not aliases, in the Dropbox directory, so 
I can’t keep my books in ~/Documents/Accounts and provide links.

In any case, Apple seems to have broken the command-line tool “ln”, so I can’t 
use that mechanism.

Finder offers a means of creating an alias via right-clicking on a filename, so 
I tried putting BookA.gnucash in ~/Dropbox, and placing an alias called 
BookA.gnucash in ~/Documents/Accounts, but when I try to open BookA via the 
alias I get the “No suitable backend” message.

I’ve found this technique works OK for a simple text file, edited with MacVim.

A cron job that copied the current version of BookA.gnucash to Dropbox on a 
regular basis and as part of the shutdown sequence should work, but I haven’t 
tried it yet.

Any other suggestions?

Regards,

Michael




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trying to download Gnucash data Files

[Michael Hendry]

> On 11 Apr 2021, at 17:33, Jose A. Lorido III  wrote:
> 
> To whomever may be able to help,
> 
> I have been using Gnucash for my business as well as my personal accounting
> on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
> unfortunately,

I feel your pain, Jose!

> I had not backed up any of my data for the previous 3 years.
> 
> I sent my damaged HDD to SalvageData and they were able to recover a number
> of files, some of these belonging to the Gnucash program.
> 
> The question would be to anyone that may be able to help me is:
> 
> 1) Which files/folders contain my data files (what would be the extensions
> I should look for)?

The folder you want is the folder you chose to use when you first installed 
Gnucash.

By default, this will be your Documents folder, but you may have chosen to put 
your files elsewhere.

The most important files are .gnucash and .gnucash - 
whatever you have called the books you’re working on.

Gnucash also makes back-ups in files like 
.gnucash.20210407161740.gnucash and maintains logs in files like 
.gnucash.20210407160520.log, which include the date and time in 
their filenames.

If you can recover the current files (.gnucash, and similar) then 
you’re in luck!

> 
> and
> 
> 2) How would I go about downloading them into my new SSD drive on my
> laptop, or I could also download them to my desktop which also contains the
> Gnucash program?

I suggest you put any recovered files in Documents/Accounts (Documents\Accounts 
if you’re a Windows user), make backups!, and then open them with Gnucash in 
the normal way.

Good luck!

Michael Hendry

PS If you have created Custom Reports and saved them, they’ll be in a file 
called “saved-reports-2.8”, stored in a folder which depends on your operating 
system
___
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] Hand-over on Succession or Short Term Absence

[Michael Hendry]

I think I’ve developed a reasonable hand-over method, thanks to members of the 
Gnucash Users.

I’m sending this partly as a record for me of what I’ve done, and partly in 
case anyone else has a similar succession problem.

Let’s say I have two books - BookA.gnucash and BookB.gnucash. I did the 
following:


1. Tidy up the existing saved reports, prefixing the report names with BookA or 
BookB as appropriate.

2, Close gnucash and make a backup copy of saved-reports-2.8 - say 
saved-reports-2.8_allbooks.

3. Open BookA in gnucash, and delete all saved reports whose names don’t start 
with BookA. Quit gnucash.

4. Click on saved-reports-2.8 and rename it saved-reports-2.8_BookA.

5. Make a copy of saved-reports-2.8_allbooks, and rename it saved-reports-2.8

6. Repeat 3, 4 and 5 for BookB.

7. Copy BookA.gnucash and saved-reports-2.8_BookA to Book A’s new keeper.

8. Repeat 7 for Book B.


9. BookA’s new keeper should copy BookA.gnucash to ~/Documents/gnucash (or 
wherever) and copy saved-reports-2.8_BookA to the appropriate directory for his 
OS. If it’s a new installation, he can just rename it saved-reports-2.8, 
otherwise he should copy and paste the contents of saved-reports-2.8_BookA on 
to the end of the existing saved-reports-2.8 file after backing up the latter 
by copying it to (e.g.) saved-reports-2.8_local so that he can revert easily 
later.

10. BookB’s new keeper likewise.


You’ll note that I decided to use GNC to delete the reports I didn’t want 
rather than using my original idea of creating a new saved-reports file by 
copying-and-pasting code from the old one.

I’ve tested this procedure using my wife’s Windows 10 laptop and all appears 
well. I await a report back from a prospective new keeper who has a Mac laptop.


Regards,

Michael





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 9 Apr 2021, at 14:27, Michael or Penny Novack  
> wrote:
> 
> On 4/9/2021 8:34 AM, D. via gnucash-user wrote:
>> I'll jump in just to say
> 
> Computers do not know who owns them.
> 
> That means that what you need to do to transfer to another person's computer 
> is in no way different from transferring to another computer that you 
> yourself own.  So this is NOT a different question than "how do I transfer my 
> gnucash to my new computer?" which comes up here frequently.

Not entirely true, because 
1. a new computer will have the default set of reports and my stand-in might 
(indeed preferably should) be an experience GNC user, with GNC installed and in 
use already.
2. I’d prefer to transfer only BookA-specific reports to the temporary keeper 
of BookA.gnucash, and so on.

> 
> How do I transfer gnucash temporarily to somebody else's computer? (so they 
> can do the work while you are out of commission) and then back again 
> afterwards is just  "transfer to a new/different computer" twice in 
> succession.

Again, not entirely true, because

BookA’s temporary book-keeper might write his own new reports during his spell 
of duty, as might BookB’s and BookC’s, and these would need to be amalgamated 
into a single file on my recovery, perhaps all at the same time, or perhaps 
separately (eg if BookA’s year-end was coming up, and its bookkeeper was going 
to finish off the year before returning control to me).

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 9 Apr 2021, at 13:34, D.  wrote:
> 
> I'll jump in just to say that it is perfectly fine to copy and paste saved 
> report configurations into and out of saved-reports-2.8. For a while, I had a 
> strange problem where my reports file kept being truncated, and I had to copy 
> in my reports numerous times. I've also heard of a user who scripted the 
> startup process to include copying a book-specific set of report 
> configurations into the proper location, so that the reports listed in a 
> given file only applied to that file.
> 
> The only warning is to be sure of what you cut and paste; the contents of the 
> file are pretty opaque, and it's easy for my eyes to glaze over and copy too 
> little or too much...
> 
> David T.


A clear example of the carpenter’s motto "Measure twice, cut once”.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> 
> Hi Michael,
>  
> Yes, the base template id's shouldn't change in future gnucash versions. Once 
> a report template gets an id (assigned by the developer that creates this 
> report template) it will be fixed. This is not dependent on your installation 
> or your accounting data. The only thing that could possibly happen is when a 
> report template is removed from gnucash. That's equivalent to the report no 
> longer being accessible via the reports menu.

That’s good news...

>  
> For completeness, if you have written your own reports in guile code, they 
> will have their own  unique ID. It would be up to you to ensure these 
> handwritten reports get copied to the respective gnucash installations that 
> need them in order for these report template id's to be available.
>  
> Regards,
>  
> Geert

... and I haven’t dipped my toes into guile, so that constraint won’t affect me.

Thanks,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 9 Apr 2021, at 09:57, David Cousens  wrote:
> 
> Michael
> I have to confess I don't know if you can edit the saved-reports-2.8 file.
> As it is a text file, it should be OK. I would keep a copy of the original
> just in case.  It may be worth taking a good look at the first and last
> entries so you can establish the formatting.  That looks like it would work
> from a look at my copy of it
> David


Thanks, David.

My plan is to make a virgin installation of Gnucash on my wife’s Windows 10 
laptop (which will never actually be used for GNC work) copy BookA.gnucash 
across, and then edit saved-reports-2.8 to include one of the BookA-specific 
custom reports.

If I get away with that, I’ll copy all my BookA-specific custom reports, and 
check them out.

Thinking about my 11-year learning-curve for GNC, I also have to think about 
the possibility of exporting GNC books in a form that could be imported by one 
of the commercial bookkeeping programs so that my successor would hit the 
ground running with familiar software. (Shocking disloyalty, I realise, but we 
have to be pragmatic about such things!).

Regards

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 9 Apr 2021, at 08:15, Geert Janssens  wrote:
> 
> Hi Michael,
>  
> That should  work.
>  
> There is one pitfall with the way saved report configurations are handled in  
> gnucash, but that is in general and not specific to your situation: saved 
> rerport configurations are shared by all your books even though their 
> configuration details may only make sense for one book.
> To detail if you have multiple books those books may have different accounts 
> (and hence also different account id-numbers internally). If you now save a 
> report configuration in book A, with a selection of accounts from book A, the 
> report will not  work properly when opened on book B, as not all accounts 
> from book A would match the accounts from book B.
>  
> Regards,
>  
> Geert

Thanks for your prompt response, Geert.

One concern I have is whether the references such as 'based on template 
“c4173ac99b2b448289bf4d11c731af13”’ would always have the base template to 
refer to in later versions of GNC, or if this is necessary.

I guess I’ll have to suck it and see!

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 8 Apr 2021, at 21:28, David Cousens  wrote:
> 
> Michael,
> 
> The location of the saved reports files is OS dependent. Full infor on the
> location sis given at https://wiki.gnucash.org/wiki/Configuration_Locations
> although it takes a bit of sorting through  but I think the saved reports
> are in USER_DATA_HOME.They are on LInux Mint 20. See also
> https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html#:~:text=Migrating%20financial%20data,desired%20path%20from%20within%20GnuCash%20.
> 
> David Cousens


That’s very helpful, David, thanks.

On my Mac, I found the saved reports here:

~/Library/Application Support/Gnucash/saved-reports-2.8

and I’ve produced an alphabetic list of all the reports using gnucash-cli, as 
recommended by Chris Lam.

Next, I'll clean up duplicate and redundant reports and tidy up inconsistent 
naming.

Am I right in thinking that I could copy and paste a report's definition from 
my saved-reports-2.8 file to my successor’s?
START COPY FROM HERE:
;;;
;; Options for saved report "ESJE Transaction Report to 31/10/2019", based on 
template “2fe3b9833af044abb929a88d5a59620f”
…

)
FINISH COPY HERE
;;;
;; Options for saved report "RChBalance Sheet", based on template 
“c4173ac99b2b448289bf4d11c731af13"

If this is a workable method, I could copy all the report definitions for 
BookA, BookB and BookC into individual files, ready for copying into 
SuccessorA, SuccessorB and SuccessorC’s respective saved-reports-2.8 files.

Of course, there could be a fatal flaw in my plan which I am too ignorant to 
spot…

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

> On 8 Apr 2021, at 10:36, Christopher Lam  wrote:
> 
> Michael
> First, good luck and hope all goes well.
> Second, you can 'describe' a custom report by the following process. This 
> uses the gnucash-cli tool.
> 
> $gnucash-cli -R list
> 
> This will list all built-in and saved reports, the latter denoted by a 'C'. 
> e.g.
> 
> *   Account Summary
> *   Advanced Portfolio
> * C Annual Report for Accountant Chris AU
> *   Assets
> *   Assets Over Time
> *   Australian Tax Invoice
> 
> $gnucash-cli -R show --name "Annual Report for Account Chris AU"
> 
> This describes the report and the options used. e.g.
> 
> * name: Annual Report for Accountant Chris AU
>   guid: 49b7979123564c5e944586db82a123e8
>   parent-template: Transaction Report
> Display / Num: Disabled
> Display / Memo: Disabled
> Sorting / Show Full Account Name: Enabled
> Sorting / Secondary Subtotal for Date Key: none
> Sorting / Show Account Description: Enabled
> Sorting / Secondary Key: date
> Sorting / Primary Key: account-code
> Accounts / Accounts: null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null, null, null, null, null, null, null, null, null, null, null, null, 
> null, null
> Filter / Account Name Filter: ^1
> 
> The reason the accounts are null is because the datafile isn't loaded.
> 
> HTH

Thanks, Christopher,

That’s an excellent starting point - I’ve been accumulating a lot of custom 
reports, several of which are duplicates or near duplicates, and this will help 
me to cull the redundant ones.

I think if I rename the reports so that they start with" Book-A”, "Book-B” etc 
it’ll be clear to whoever is filling in for me which reports relate to his/her 
organisation, so the one file could be shared by all.

Is it possible to merge a set of custom reports into an existing Gnucash 
installation? What I’m thinking is that I would copy BookX.gnucash along with 
my .gnucash directory and its contents into ~/Dropbox/BookX and send a Dropbox 
link to the nominated BookX bookkeeper.

This bookkeeper would have to have the appropriate version of Gnucash installed 
for his/her operating system, and be given appropriate instructions on how to 
deal with the Dropbox files. 

Does this sound feasible? 

Incidentally, gnucash-cli isn’t in my PATH, so I had to run it from:

/Applications/Gnucash.app/Contents/MacOS

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Hand-over on Succession or Short Term Absence

[Michael Hendry]

I’m shortly to undergo surgery, and although I expect to be home in three or 
four days, it’ll be several weeks before I’m fully up and running again. As a 
retired doctor, I’m well aware that bad stuff can happen during or after 
surgery.

As well as managing my personal accounts, I’m treasurer of a club and two small 
charities, and I’d like to be able to prepare a hand-over bundle for a 
temporary (or permanent) successor.

This process should ideally be reversible, so that I can take over again after 
my recovery.

Sharing the .gnucash files is an obvious first step, but I’d need to share the 
reports I’ve refined over the years which apply only to one set of books, along 
with any other necessary settings.

There’s some overlap with a 2013 topic “sequential use of Gnucash on multiple 
computers”, but I haven’t found any recent references to this.

Before I reinvent the wheel, does anyone have a ready-to-use solution?

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entering A Scheduled Transaction Early

[Michael Hendry]

> On 4 Apr 2021, at 15:30, Jack Frillman via gnucash-user 
>  wrote:
> 
> That's not what I was trying to do.

Is this scheduled transaction (Sx) the first of a series (A), or is it part of 
an existing series which is to be paid earlier than normal? (B)

If (A): create the Sx with the early start date, and adjust the Sx after that 
date has past.

If (B): duplicate last month’s (already created) transaction, and put in the 
desired date. Adjust the Sx so that its first payment will be next month.

If neither (A) nor (B) please explain what you are trying to do.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Items not appearing in P report

[Michael Hendry]

> On 30 Mar 2021, at 10:07, Mahon Finbar  wrote:
> 
> Hi,
> 
> I get reimbursed  a certain amount of electricity costs each month, as a 
> separate transaction in to my bank a/c. I enter them as income:reimbursement 
> in the gnucash transaction.
> 
> However, nothing appears in my P report under 'reimbursement' but if I 
> click on the headline in the report they all appear on the list of 
> reimbursements as assets:BoIBarry as entries under 'transfer'  (where BoI 
> Barry is my bank a/c)
> 
> Why?
> 
> Thanks, Barry

Open your P report, click on the “Options” button, and make sure your 
income:reimbursement account has been selected.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled transaction frequency?

[Michael Hendry]

> On 16 Mar 2021, at 17:13, Derek Atkins  wrote:
> 
> I don't think you can do that with the current implementation.
> 
> -derek
> 

As a workaround, could you simply set up a monthly transaction for the last day 
of the month, or for the 3rd day of the month?

If it’s an expense you would use the former (to get early warning of money 
going out), and for income the latter (so you definitely don’t spend it too 
soon!).

You can always adjust the date later, if you really must have the dates aligned 
with the actual payments.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Lost Files update

[Michael Hendry]

> On 20 Feb 2021, at 16:10, Mahon Finbar  wrote:
> 
> Hello again,
> 
> No reaction to my previous post.
> 
> The list of files under gnucash are all dated 5 Feb 2018 should there be 
> something more recent?
> 
> TIA for any reply

Adrien responded yesterday at 19:33 (GMT), looking for more information.

Michael



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Filtering reports on contents of Memo field

[Michael Hendry]

> On 11 Feb 2021, at 00:36, Adrien Monteleone  
> wrote:
> 
> Transaction Report, not Account Report.
> 
> Regards,
> Adrien

Thanks, Adrian.

D’oh!

I don’t know why I’ve never used the Transaction Report before, it provides all 
the sorting and totalling I need (by intended destination for reports to the 
club, and by member’s name for Gift Aid).

It has also revealed that I didn’t need to use the “M: name” in the memo field, 
as “name" on its own is quite enough. And if I’m inconsistent in the spelling 
or format of the name, or leave the name out altogether, this will be revealed 
by the Transaction Report when sorted in Memo order.

Marvellous! What a boon this list is.

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Filtering reports on contents of Memo field

[Michael Hendry]

> On 10 Feb 2021, at 18:47, Stephen M. Butler  
> wrote:
> 
> On 2/10/21 12:38 AM, Michael Hendry wrote:
>>> On 8 Feb 2021, at 15:40, Michael Hendry  wrote:
>>> 
>>>> On 7 Feb 2021, at 18:22, Stephen M. Butler  
>>>> wrote:
>>>> 
>>>> On 2/7/21 10:10 AM, Adrien Monteleone wrote:
>>>>> If you are treating members as 'customers' then you may have other 
>>>>> options. Otherwise, you'd have to go through the equally tedious task of 
>>>>> setting up sub-accounts for each member, or creating a saved report 
>>>>> configuration for each member.
>>>>> 
>>>>> The Transaction Report does offer filtering capabilities that you can use 
>>>>> on a Memo field for that last option.
>>>>> 
>>>>> Another alternative for a consolidated report might work:
>>>>> 
>>>>> The Transaction Report also lets you sort by the Memo field, so if you 
>>>>> choose only the Gift Aid account, and the Memo starts with/contains only 
>>>>> the Member names, you might be able to get subtotals for each member. (if 
>>>>> that is what you are looking for)
>>>>> 
>>>>> In either case, no need to filter date range for the account view first, 
>>>>> you'll do that in the report options.
>> Date Range isn’t available when adjusting report options, as far as I can 
>> see.
> 
> Should be under the General Tab in Options.

Thanks, Steve, but this screenshot says “no”.

https://www.dropbox.com/s/ul04nrhddesniy8/Screenshot%202021-02-10%20at%2022.52.20.png?dl=0

I got there by opening the account in question and using Reports->Account 
Report to produce the report and then clicking the “Options” button. Am I 
missing an alternative route?

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Filtering reports on contents of Memo field

[Michael Hendry]

> On 8 Feb 2021, at 15:40, Michael Hendry  wrote:
> 
>> On 7 Feb 2021, at 18:22, Stephen M. Butler  
>> wrote:
>> 
>> On 2/7/21 10:10 AM, Adrien Monteleone wrote:
>>> If you are treating members as 'customers' then you may have other options. 
>>> Otherwise, you'd have to go through the equally tedious task of setting up 
>>> sub-accounts for each member, or creating a saved report configuration for 
>>> each member.
>>> 
>>> The Transaction Report does offer filtering capabilities that you can use 
>>> on a Memo field for that last option.
>>> 
>>> Another alternative for a consolidated report might work:
>>> 
>>> The Transaction Report also lets you sort by the Memo field, so if you 
>>> choose only the Gift Aid account, and the Memo starts with/contains only 
>>> the Member names, you might be able to get subtotals for each member. (if 
>>> that is what you are looking for)
>>> 
>>> In either case, no need to filter date range for the account view first, 
>>> you'll do that in the report options.

Date Range isn’t available when adjusting report options, as far as I can see.

>>> 
>>> If you want individualized reports per member, then you can still use that 
>>> last option, but you'll need to save each as a Report Configuration and 
>>> just name it for each Member. Then run them one at a time as needed.
>> 
>> What if the Memo field contains "Member:  member last, first name" so that 
>> the filter was on the leading "Member: " portion but you still sorted by the 
>> Memo field.  Wouldn't each break based on the remainder of that field 
>> trigger a total line?  In that way this would be just one report without 
>> having to know if new members were added or removed.
>> 
>> --Steve
> 
> Thanks, Steve.
> 
> I’ve tried just putting “M: “ in front of a few of the names in the memo 
> filed, sorting by memo field and then using Cmd-F to search for “M: “ 
> contained in the memo field, and that looks promising.
> 
> The transaction report derived from this won’t produce sub-totals by member, 
> but the Gift Aid claim has to be itemised by date so that’s not a huge 
> problem.
> 
> I’ll polish it and report back.
> 
> Michael

Confirming that this procedure allows me to produce a single report that covers 
my needs, with each member’s Gift-Aid-claimable donations listed in 
alphabetical order, and takes account of the fact that the Income:GA account is 
the parent of several accounts which specify the nominated destination for the 
donations, such as Income:GA:Foundation, Income:GA:PolioPlus.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Frustration

[Michael Hendry]

> On 8 Feb 2021, at 04:56, Andrew Ralph via gnucash-user 
>  wrote:
> 
> Hi team
> I am trying to achieve what I think should be a simple process, to complete 
> yearly accounts for tax purposes for 4 seperate rental properties 
> All I want to do is be able to save the previous years accounts and reproduce 
> a blank account hierarchy for the next financial year. 
> 
> With going trough the intro doc and on line forums haven’t come up with a 
> workable solution. 
> 
> I have tried all the export options to reproduce a new blank or otherwise 
> account hierarchy but am unable
> 
> Not sure if the close book option would be appropriate 
> 
> I also can only see the last 4 accounts from the file drop down can I access 
> a more detailed record of previous accounts and historical interactions 
> 
> 
> 
> Any suggestions would be appreciated 
> 
> Andrew

To keep it simple, let’s say you only have one rental property, and receive 
rent for it at intervals throughout the year, recording this income in 
Income:Rent.

Open the Income:Rent account, and right-click on any of the transactions in 
that account.

Choose the “Filter By…” option.

Select an appropriate date range.

Job done!

If you set a future date range, no transactions will be visible - as if you’d 
set up a completely new set of books. If you choose the start and end dates of 
a previous financial year, you’ll see the transactions for that year.

There is no need to Close Books in GnuCash when moving into a new financial 
year, and there is no need to set up a new GnuCash file for each financial 
year, the way you would have done when keeping pen-and-ink records.

If you feel you need to start a new year but carry forward the chart of 
accounts without the old year’s transactions, I think you can do this with File 
=> New File - I’m not sure of the details, and have never tried this.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Filtering reports on contents of Memo field

[Michael Hendry]

> On 7 Feb 2021, at 18:22, Stephen M. Butler  
> wrote:
> 
> On 2/7/21 10:10 AM, Adrien Monteleone wrote:
>> If you are treating members as 'customers' then you may have other options. 
>> Otherwise, you'd have to go through the equally tedious task of setting up 
>> sub-accounts for each member, or creating a saved report configuration for 
>> each member.
>> 
>> The Transaction Report does offer filtering capabilities that you can use on 
>> a Memo field for that last option.
>> 
>> Another alternative for a consolidated report might work:
>> 
>> The Transaction Report also lets you sort by the Memo field, so if you 
>> choose only the Gift Aid account, and the Memo starts with/contains only the 
>> Member names, you might be able to get subtotals for each member. (if that 
>> is what you are looking for)
>> 
>> In either case, no need to filter date range for the account view first, 
>> you'll do that in the report options.
>> 
>> If you want individualized reports per member, then you can still use that 
>> last option, but you'll need to save each as a Report Configuration and just 
>> name it for each Member. Then run them one at a time as needed.
> 
> What if the Memo field contains "Member:  member last, first name" so that 
> the filter was on the leading "Member: " portion but you still sorted by the 
> Memo field.  Wouldn't each break based on the remainder of that field trigger 
> a total line?  In that way this would be just one report without having to 
> know if new members were added or removed.
> 
> --Steve

Thanks, Steve.

I’ve tried just putting “M: “ in front of a few of the names in the memo filed, 
sorting by memo field and then using Cmd-F to search for “M: “ contained in the 
memo field, and that looks promising.

The transaction report derived from this won’t produce sub-totals by member, 
but the Gift Aid claim has to be itemised by date so that’s not a huge problem.

I’ll polish it and report back.

Michael



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Filtering reports on contents of Memo field

[Michael Hendry]

Our Rotary Club hasn’t been able to meet in the flesh since the beginning of 
Covid, and we haven’t been able to run any fundraisers.

One of our members suggested that each of us might consider donating the cost 
of the meal (and the associated glass or two of wine|) to the club’s charity 
account as a way of keeping some money coming in. As this is entirely voluntary 
and comparisons would be invidious if issued in reports, I’ve recorded the 
chosen a chosen destination in the description field of each transaction, and 
recorded the donor's name in the Memo. This way I can simply exclude Memo from 
reports.

I’m now looking at making a Gift Aid claim for all these donations at the end 
of March, and I’ve found that the Spreadsheet I created to keep track of the 
Gift Aid side of the accounts has got out of step with the Gnucash record.

I’ve managed to reconcile these by opening the account which receives these 
donations, filtering by date, using Find to pick up one member at a time in 
this account in the Memo and Reporting the findings (which provides a total in 
addition to the individual donations).

This is a tedious and error-prone procedure which I would like to be able to 
automate.

As far as I can see, there isn’t a way of setting up multiple such reports in 
advance and running it at the end of the tax year (or indeed as an ad-hoc 
report during the year) to get it all done in one go, and I’d have to export 
the account to CSV and sort by Memo to separate the donations by member, and 
then extract the total-contributions-by-member to generate the Gift Aid Claim.

That’s unless one of you wise ones can suggest another route…

Perhaps more in hope than expectation,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 18 Jan 2021, at 16:32, Chris Graves  wrote:
> 
> If you open the plist file with Xcode or bbedit or ... you may see that the 
> maxfiles key is of type string, instead of integer.  It may look like:
>   /org/gnucash/history/maxfiles
>   6
> 
> Instead of
>   /org/gnucash/history/maxfiles
>   6
> 
> You can manually change string to integer or do this:
> defaults delete -app Gnucash "/org/gnucash/history/maxfiles"
> defaults write -app Gnucash "/org/gnucash/history/maxfiles" -int 6

Problem solved, thank you!

I opened the plist file with Xcode, and changed the Type of 
/org/gnucash/history/maxfiles from String to Number, but those without Xcode 
could no doubt use the command lines you have given.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 17 Jan 2021, at 20:11, David H  wrote:
> 
> You can easily check the mru details by doing the following...
> 
> defaults read -app Gnucash
> 
> or
> 
> defaults read -app Gnucash | grep history
> 
> Cheers David H

Yes, I discovered how to read and write the relevant plist using “defaults”, 
via the man page, and have also inspected it with Xcode.

Here is the output from the command you suggested:

=> defaults read -app Gnucash | grep history
"/org/gnucash/history/file0" = 
"/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash";
"/org/gnucash/history/file1" = 
"/Users/michaelhendry/Documents/Accounts/ESJE.gnucash";
"/org/gnucash/history/file2" = 
"/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash";
"/org/gnucash/history/file3" = 
"/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash";
"/org/gnucash/history/file4" = 
"/Users/michaelhendry/Documents/Accounts/MDH.gnucash";
"/org/gnucash/history/file5" = 
"/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash";
"/org/gnucash/history/file6" = 
"/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash";
"/org/gnucash/history/file7" = 
"/Users/michaelhendry/Documents/Accounts/ESJE.gnucash.20200316161155.gnucash";
"/org/gnucash/history/file8" = 
"/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash.20200108210937 
copy.gnucash";
"/org/gnucash/history/file9" = 
"/Users/michaelhendry/Documents/Accounts/Test_2019-10-26.gnucash";
"/org/gnucash/history/maxfiles" = 6;

I recently created “TestMRU.gnucash”, the following 4 files are those I 
regularly use, and the final 5 are not currently in use.

I still get only the 4 most recently opened files in the File menu, so if I 
want to open MDH.gnucash, I have to use File->Open.

After opening this file, your command yields the following:

 => defaults read -app Gnucash | grep history
"/org/gnucash/history/file0" = 
"/Users/michaelhendry/Documents/Accounts/MDH.gnucash";
"/org/gnucash/history/file1" = 
"/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash";
"/org/gnucash/history/file2" = 
"/Users/michaelhendry/Documents/Accounts/ESJE.gnucash";
"/org/gnucash/history/file3" = 
"/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash";
"/org/gnucash/history/file4" = 
"/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash";
"/org/gnucash/history/file5" = 
"/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash";
"/org/gnucash/history/file6" = 
"/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash";
"/org/gnucash/history/file7" = 
"/Users/michaelhendry/Documents/Accounts/ESJE.gnucash.20200316161155.gnucash";
"/org/gnucash/history/file8" = 
"/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash.20200108210937 
copy.gnucash";
"/org/gnucash/history/file9" = 
"/Users/michaelhendry/Documents/Accounts/Test_2019-10-26.gnucash";
"/org/gnucash/history/maxfiles" = 6;

…which is as expected.

If there’s another Mac user with more than four files in use, perhaps s/he 
could report on what after the command:

defaults write -app Gnucash "/org/gnucash/history/maxfiles” 6

(preferably with a before-and-after run of the "defaults read…” command).

Regards,

Michael

PS I noticed that the values associated with the various keys are enclosed in 
double-quotes, and tried 

defaults write -app Gnucash "/org/gnucash/history/maxfiles” “6”

but the double-quotes don’t appear in the plist.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 17 Jan 2021, at 18:03, Michael Hendry  wrote:
> 
>> On 17 Jan 2021, at 16:07, Chris Graves  wrote:
>> 
>> defaults write -app Gnucash "/org/gnucash/history/maxfiles” 6
> 
> Well spotted!
> 
> I think I tried every other possible combination I could find in the man page 
> for “defaults”.
> 
> Thanks,
> 
> Michael
> 

PS Just one problem - although this creates a new key 
"/org/gnucash/history/maxfiles" and sets its value to 6, I still get only the 
default of 4 recently-used files in my MRU list when I start Gnucash.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 17 Jan 2021, at 16:07, Chris Graves  wrote:
> 
> defaults write -app Gnucash "/org/gnucash/history/maxfiles” 6

Well spotted!

I think I tried every other possible combination I could find in the man page 
for “defaults”.

Thanks,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 16 Jan 2021, at 21:50, David Carlson  wrote:
> 
> Searching the archives of this list I found a thread a year ago.  This
> suggestion was part way through the thread: <
> https://lists.gnucash.org/pipermail/gnucash-user/2020-January/089080.html>
> It seems to be only for Mac computers so there is no info that I could find
> for Linux or Windoze.  For either it might be an OS or workspace setting.

Unfortunately, the recommended command-line:

defaults write --app Gnucash "/org/gnucash/history/maxfiles” 6

results in this error message

2021-01-17 10:53:30.036 defaults[27141:944194] Unexpected argument 6; leaving 
defaults unchanged.

Michael


> On Sat, Jan 16, 2021 at 12:51 PM Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
> 
>> On 1/16/21 9:15 AM, Michael Hendry wrote:
>>>> On 15 Jan 2021, at 03:30, David Carlson 
>> wrote:
>>>> 
>>>> Maybe I searched for the wrong term.  I would never have guessed to
>> search
>>>> for plist or mru, for example.
>>> I’ve found the relevant file here:
>>> 
>>> ~/Library/Preferences/org.gnucash.Gnucash.plist
>>> 
>>> but I can’t locate the Key that defines the maximum number of
>> recently-used files for display (hereinafter called “MRU_MAX"), which
>> defaults to 4 on my iMac Catalina running 4.4.
>>> 
>>> I notice that the Keys org.gnucash.history.file0 to
>> org.gnucash.history.file9 contain fully qualified filenames for the ten
>> books I have opened most recently, which suggests that MRU_MAX up to 10
>> could be supported if the default of 4 were changed.
>>> 
>>> There seems not to ba a way of adjusting MRU_MAX using GnuCash’s
>> Preferences, so I’m stuck!
>>> 
>>> Regards,
>>> 
>>> Michael
>> Check the recent archives as I remember a discussion that if the key
>> entry doesn't exist, it defaults to 4.  You have to create the entry
>> name/value pair in order to change it.  They gave the key name in that
>> discussion.
>> 
>> 
>> --
>> Stephen M Butler, PMP, PSM
>> stephen.m.butle...@gmail.com
>> kg...@arrl.net
>> 253-350-0166
>> ---
>> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recent list in file menu

[Michael Hendry]

> On 15 Jan 2021, at 03:30, David Carlson  wrote:
> 
> Maybe I searched for the wrong term.  I would never have guessed to search
> for plist or mru, for example.

I’ve found the relevant file here:

~/Library/Preferences/org.gnucash.Gnucash.plist

but I can’t locate the Key that defines the maximum number of recently-used 
files for display (hereinafter called “MRU_MAX"), which defaults to 4 on my 
iMac Catalina running 4.4.

I notice that the Keys org.gnucash.history.file0 to org.gnucash.history.file9 
contain fully qualified filenames for the ten books I have opened most 
recently, which suggests that MRU_MAX up to 10 could be supported if the 
default of 4 were changed.

There seems not to ba a way of adjusting MRU_MAX using GnuCash’s Preferences, 
so I’m stuck!

Regards,

Michael




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Changing end date on a saved report config option

[Michael Hendry]

> On 14 Jan 2021, at 15:45, Mahon Finbar  wrote:
> 
> Sorry for the bother, the usual end of year issue
> 
> I have an income report in the saved report configuration with an end date of 
> 1.09.2020.
> 
> I need to change the end date to 31.12.2020.
> 
> I thought I only needed to change the option, but it doesn't seem to be 
> working.
> 
> What am I doing wrong?
> 
> TIA, Barry

Open your saved report.

Click “Options” button.

Click “General” button in the window this brings up.

Adjust Start Date and End Date to your requirements.

Click “Apply”.

If you want to use the adjusted report, using “Save Config”.

HTH

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't get GNUCASH to work on OSX

[Michael Hendry]

> On 29 Dec 2020, at 20:58, David H  wrote:
> 
> Ralph,
> 
> Go to system prefs under Security and Policy and see if there's  a prompt to 
> allow Gnucash to run - working from memory here so I think that's where it 
> used to show up for me.
> 
> Michael,
> 
> Check your system prefs under Security and Policy - I have "Allow apps 
> downloaded from:" set to "App Store and identified developers" and don't get 
> prompted to allow a new version to run.

Thanks, David.

I have mine set to “Anywhere”, which I would imagine is a superset of “App 
Store and identified developers”, but I still get the prompt.

>  All I ever do is mount and open the dmg, CTRL-A to select all files and in 
> Applications CTRL-V to paste and select copy over if I already have Gnucash 
> installed.

I mount and open the DMG, then drag the App into the Applications folder, 
opting to overwrite the existing copy. As far as I can tell, there’s no need to 
“select all” and copy.

(Presumably you use -a and -v on your Mac, not the CTRL-A etc?)

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't get GNUCASH to work on OSX

[Michael Hendry]

> On 29 Dec 2020, at 12:08, Ralph Musto via gnucash-user 
>  wrote:
> 
> HI all,
> I have been trying to install GNUCASH on OSX 10.14.6 but with no success. New 
> set-up, fresh install.
> 
> After download and moving the app to Applications. When I run it the Icon 
> bounces in the dock for a second or two and then just disappears. No error 
> messages, nothing.
> 
> Anybody know how I can find out and fix what is wrong?
> 
> Thanks,
> Ralph

Just try running it again - this appears to be a “feature” of MacOS. 

I downloaded, installed and ran “Check and Repair” on all my books this 
morning, but I did have to run the new version twice.

Michael



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ANNOUNCE: GnuCash 4.4 Released

[Michael Hendry]

> On 29 Dec 2020, at 09:27, Alan A Holmes  wrote:
> 
> Problems with the links for downloading the Windows version. The GitHub link 
> is incorrect, and the Sourceforge link is still making 4.3 available for 
> download.
> 
> The GitHub link should be :-
>   
> https://github.com/Gnucash/gnucash/releases/download/4.4/gnucash-4.4.setup.exe
>  (the first 4.4 was 4.3 in the original)
> which does allow me to download 4.4.
> 
> It's possible that Apple macOS links will have the same problems, as they 
> appear similar.
> 
> 
> Fully understandable, it looks like you had a bit of traumatic day John. Hope 
> you've had a good night's rest, after having your tipple of choice.
> 
> Happy New Year
> 
> 
> Alan A Holmes

I’ve tried both options for the Mac included in Alan’s email, but neither works:

Apple macOS:
https://github.com/Gnucash/gnucash/releases/download/4.3/Gnucash-Intel-4.4-1.dmg
 
https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/Gnucash-Intel-4.4-1.dmg

The former results in a 404 error, the later gives me an error message about 
4.4.1 and offers me 4.3.1 instead

No rush to fix, but thought I should flag this up.

Hoping 2021 turns out better than its predecessor for all in the GC community,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Possible Jump Enhancement

[Michael Hendry]

> On 8 Dec 2020, at 23:26, David Carlson  wrote:
> 
> I have not looked at customization,  I wanted to stay with pre-defined
> shortcuts and wondering why they disappeared in recent GnuCash releases.  I
> now see that they just got harder to find.  Having first cut my teeth in
> CPM, then dos, I have grown tired of the constant retraining now required
> for every incremental release of every program in every OS ad nauseum.
> 
> I too prefer using the keyboard over the mouse, but since we all have
> different preferences,  it is good to try to make the program efficient for
> as many users as possible.
> 

On my Mac, 2 brings up the whole multi-split transaction, then I use the 
down-arrow to the split of interest, and hit J.

Now I come to think of it, perhaps I customised  to mean “Basic Ledger”, 
 for “Auto-Split Ledger” and  for “Transaction Journal” some time 
in the past. This would almost certainly have been the result of a hint on this 
list.

Is there something else that the OP wanted to achieve?

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Managing UK Gift-Aid

[Michael Hendry]

> On 29 Oct 2020, at 14:29, Edward Bainton  wrote:
> 
> I'm also a charity treasurer in the UK (tho I think officially I'm called the 
> secretary...). I'm on this list because I'd love to be able to use GC for the 
> charity finances, but the Gift Aid thing is a significant hurdle to clear. 
> 
> First, the church collections: it sounds as if you could possibly simplify by 
> using the Small Donations Scheme, designed for exactly that situation. 
> Assuming no one puts in more than GBP30 in the plate unenveloped, you can get 
> GA on all donations in the plate, even if the donor is unknown (as they will 
> be) or some are known not to pay tax. You only need an enveloped, personally 
> identifiable donation if a parishioner wants to donate more than GBP30 cash 
> into the plate. I don't know where your parish is, but I'm guessing unless 
> it's Mayfair the modal donation amount is well under 30 quid? Larger donors 
> can be encouraged to use a s/o (and will probably want to put a token amount 
> of cash in the plate, too).

But remember that you can’t just use the Gift Aid Small Donations Scheme 
(GASDS) in isolation - see 
https://www.gov.uk/claim-gift-aid/small-donations-scheme

Relevant extract:


Who can claim
Your charity or CASC must have claimed Gift Aid:

• in the same tax year as you want to claim GASDS
• without getting a penalty in the last 2 tax years
• in at least 2 of the last 4 tax years (without a 2-year gap between 
claims) if you’re claiming on donations made before 6 April 2017
What you can claim
Your GASDS claim cannot be more than 10 times your Gift Aid claim. For example, 
you can claim on £1,000 worth of donations through GASDS if you’ve received 
£100 of Gift Aid donations in the same tax year.

You can claim on donations that are eligible for Gift Aid, but not membership 
fees.



> 
> Second, Rotary dinners: this is another case where, if it's applicable, the 
> Small Donations Scheme may make things easier. But if it's _not_ applicable 
> (and the money may be seen as a waiver rather than a donation, which is not 
> eligible for GA), I worry that even if you have GA declarations from every 
> member 
> present at the dinner, you may not be able to claim GA - because it won't be 
> clear how much each member has donated.

The club pays the venue a fixed price per diner and this figure is rounded up 
in the charge collected at the door from each member.

> Unless you can rely on every diner owing the same, every diner having signed 
> a GA declaration, and every diner contributing the same amount more than 
> their dues when it comes to settling the bill?

So yes, everyone pays the same, and all club members (who are eligible to do 
so) have signed a form saying all donations from date X are eligible for Gift 
Aid.

> 
> The extra headaches I'd love people's thoughts on are these:
> 
> How do you deal with a GA declaration 3 years (say) after the donation, which 
> says "I want the charity to treat all my donations in the past 4 years as 
> Gift Aid"?

It hasn’t happened in my period as treasurer, but I suspect the “from date X” 
declaration was put in to ensure that there was cover from the date the trust 
came into existence.

> 
> And once you introduce that level of complexity, how can you be absolutely 
> sure you're claiming every GA donation once, and once only?

Well, you have to keep records...

> 
> The only way I can manage is with a spreadsheet, which details the date of 
> declaration and the effective date (by default, date of signature minus 4 
> years). Excel's hopeless at dates, but you can just about bludgeon it into 
> filtering out all donations by J. Bloggs that are GA-able, versus his 
> donations that are not. I haven't got this far, but I assume another field 
> against the donation for 'GA claimed no / GA claimed dd mm yy' would prevent 
> double-counting?

I keep a spreadsheet for every claim year, with dates associated with the 
contributions, and make the claims based on the relevant spreadsheet. If the 
contribution isn’t in the spreadsheets, it won’t have been claimed, but how 
would a relevant donation be made yet slip past the reconciliation of the books 
with the spreadsheet?

> 
> By the by, I suspect this is why there are so many proprietary donation 
> gateways that will take care of this for you - though how well they do that, 
> I don't know. (I just know PayPal is a nightmare.) And of course they can't 
> do the cash. 

Indeed!

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Managing UK Gift-Aid

[Michael Hendry]

> On 29 Oct 2020, at 11:37, Chris Green  wrote:
> 
>> 
> It's not that easy!  
> 
> For us it's mostly collections in church that are affected (at least
> they're the ones that I'm dealing with), each member of the
> congregation who wants ( and can) get their donation gift aided `puts
> their collection in an envelope and fills out the details (name,
> address, signature, etc.) on the envelope.  Thus after the service
> there are two piles, one "Gift-Aided" and the other not.  That's fine,
> I can record two 'income' items.
> 
> The trouble is that HMRC needs a lot more detail, or at least it has
> to be available, you need each donation with name, address, amount and
> date.  These need to go onto an on-line "spreadsheet".
> 
> It *may* be that all I need to do is either keep (or scan) all the
> envelopes and then, at the end of the year, feed all the data into the
> HMRC "spreadsheet" form to make the claim.
> 
> I was just wondering how others do it.

Hi, Chris.

I am treasurer of our local Rotary Club’s Charitable Trust and have to deal 
with Gift Aid.

At our weekly meetings (ah yes, I remember them!) we routinely collect a 
rounded-up cash amount for dinner and donate the balance to the Charitable 
Trust as a painless way of topping it up.

We keep Gift Aid Declarations for all of our members, which specify “all 
donations made since dd mmm 2004” as one of the options, along with an 
undertaking to notify the treasurer of change of gift aid tax status and 
address.

When I took over as Treasurer I inherited a set of spreadsheets for the 
accounts from my predecessor, including a separate one for Gift Aid.

I’m not keen on spreadsheets for bookkeeping, and set up a parallel set of 
books in GnuCash.

At first I thought I could deal with Gift Aid within GC, but it turned out to 
be very awkward and I reverted to using the original spreadsheet.

The columns of this are for meeting dates (presumably 52 Sundays for you), and 
the rows are for Gift-Aid eligible members. I use the column totals to check 
that the Gift Aid spreadsheet matches the total cash recorded for the day in 
GC, and that the grand total matches the eventual Gift Aid claim,

Some tweaking will be required if a member stops being eligible for Gift Aid 
(e.g. an additional row for "Joe Bloggs - no gift aid”), and for ad-hoc 
donations.

This means that the GC book takes no account of Gift Aid, apart from the 
receipt of the payment from HMRC.

If a scan of the Gift Aid declaration would be helpful, I can let you have one. 
It was drawn up a member of the club who was involved as a lawyer in the 
setting up of the trust in the first place, but this would be under Scots Law, 
which may not apply to you.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 8.1.1. Find Transaction

[Michael Hendry]

> On 3 Oct 2020, at 11:46, Chris Green  wrote:
> 
> On Sat, Oct 03, 2020 at 08:28:43PM +1000, Liz Dodd wrote:
>> On Fri, 02 Oct 2020 23:02:05 -0400
>> Derek Atkins  wrote:
>> 
>>> You must be in your 60s or 70s (or older) if you think you were
>>> around before the term regex was created.
>> 
>> Ok, we're outed.
>> 
> Quite a lot older I think, I'm in my 70s and have known about REs all
> of my professional life (software engineer) and I suspect they were
> around before I came across them.  :-)


The concept of a regular expression was ntroduced in the 1950s - see 
https://en.wikipedia.org/wiki/Regular_expression

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Checking account withdrawals for cash boxes

[Michael Hendry]

> On 29 Sep 2020, at 21:16, Roderick A. Anderson  wrote:
> 
> Good day to all.
> 
> I have a question that may require me contacting an accountant but this is my 
> first pass.
> 
> First I am the Treasurer for a small US 501c3.  Never been an accountant nor 
> played one on TV. ;-)
> 
> We have an annual fund raiser.  I withdraw cash from the checking/General 
> account for the cash boxes. In the past (and what I inherited) was to make it 
> an expense entry.  Just doesn't seem right since we still have the money.
> 
> Should I create another Asset account and record it there?

Yes - something like:

Assets:Current Assets:CashBox

You transfer cash into it from a bank account, you might record cash coming out 
of it for expenses on-the-day, record cash received on the day and finally 
deposit the remainder (or part of it, if you’ve got another event coming up) in 
the bank.

You’d need professional guidance on the details of the handling and recording 
of the cash.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Viewing Hidden Accounts

[Michael Hendry]

My bank recently cancelled my Visa Credit Card and replaced it with a 
Mastercard, which prompted me to hide the redundant Liabilities:Visa account.

Realising that I might want to examine that account in future, and noticing the 
pop-up help that advised me to use “Filter By” to bring it back into view, I 
found I couldn’t access this option using the right-mouse-click in the Accounts 
tab that I regularly use to access “Filter By” in other tabs.

Casting around for an alternative route, I found it in the View menu.

Is there a reason for not providing it in response to a right-mouse-click?

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?

[Michael Hendry]

> On 13 Sep 2020, at 08:54, Doug  wrote:
> 
> Chris,
> I am no Gnucash or accounting x-pert, but how I perform a similar task is to 
> just do a total import, to ´Unspecified´.
> Then I duplicate another transaction with similar splits, to the same date 
> (so in you case, the previous weeks transaction). 
> Then I manually do the split in that transaction, finishing with deleting the 
> original import (which was only there as a ´memory prompt´ anyway).
> 
> In my case, I use this for importing my wife´s salary, where the variations 
> are usually relatively minor.
> 
> Would love to know if someone does a similar task in a more efficient way.
> 
> Keep safe! (from Covid)
> regards, Doug (Australia)

Hi, Doug.

I’m not sure what you mean by a “total import”.

I use Scheduled Transactions to handle (e.g.) pension income, where there is a 
regular monthly payment. The value of these deposits varies slightly, I suspect 
because tax is deducted at source, and minor tweaks are necessary for the 
annual figure to match the real world.

In my case, there are only two splits (Income:Pension —> Assets:Current 
Assets:Bank Account), but if you want to track gross income and various 
deductions which result in the net income it saves a lot of time to have the 
framework of the transaction already there when you come to reconcile the 
figures.

Also, if you set the Scheduled Transactions to be processed in advance, there’s 
the advantage that you get early warning of income arriving in your account 
(or, perhaps more important, of automated payments going out), and the minor 
fluctuations in the exact amounts are not significant.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Be careful with `petty cash'

[Michael Hendry]

> On 10 Sep 2020, at 22:29, Adrien Monteleone  
> wrote:
> 
> I'm not sure what you are referencing by 'paying-in slip'.
> 
> I always try to model the real world events with my transactions, so receipts 
> of cash would be recorded for the date they actually happened:
> 
> Dr. Undeposited Funds
> Cr. Income:whatever (collection, offertory box, etc.)
> 
> Then when the deposit is made as likely an aggregate of several revenue 
> sources and even days, I'd record:
> 
> Dr. Bank
> Cr. Undeposited Funds
> 
> If by 'paying-in slip' you mean 'deposit slip' or transaction # from the 
> bank, you'd use that on the actual deposit transaction.
> 
> If you issue some sort of receipt or the money is collected with some sort of 
> document number, use that number for recording the actual collection 
> transaction.
> 
> It is also possible, we may be talking past each other about the same thing.
> 
> 
> Regards,
> Adrien

Hi, Adrien.

This appears to be a response to my last comment but I think it was intended 
for Chris Green, as you and I appear to be in agreement in wanting to mirror 
what actually happened.

UK banks supply “Bank Giro Credit” books, sometimes free-standing, sometimes 
forming a section at the back of a cheque book. There is a tear-off slip for 
the details of the deposit and a counterfoil - both identically serial-numbered 
- and the bank tears of the clip then stamps and returns the counterfoil as a 
receipt.

For paying-in slip read Bank Giro Credit slip - or deposit slip as you describe 
it.


Michael

> 
> On 9/10/20 4:34 AM, Michael Hendry wrote:
>>> On 10 Sep 2020, at 09:52, Chris Green  wrote:
>>> 
>>> I think the best approach is either:-
>>> 
>>>1 - Record the amounts in their different categories as required,
>>>e.g. 'collection' or 'offertory box' and simply record the same
>>>paying-in slip number against both transactions.
>>> 
>>>2 - Have, as you suggest, an intermediate "Undeposited Funds asset
>>>account" where cash is recorded as it's collected and then another
>>>transaction records when it's paid into the bank.
>>> 
>>> Given the very small PCC I'm managing I think 1 above will be fine.  I
>>> record the date of the collection in the Description and the
>>> transaction date is the date that the cash gets credited to the bank
>>> account.
>> I prefer 2 because the act of paying-in is a transaction distinct from the 
>> receipt of the cash, and may include cash received on several different 
>> dates. As well as being an accurate representation of what happened, it 
>> eases trouble-shooting when (e.g.) you can’t reconcile the bank account.
> 
> ___
> 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.



___
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] Be careful with `petty cash'

[Michael Hendry]

> On 10 Sep 2020, at 09:52, Chris Green  wrote:
> 
> On Wed, Sep 09, 2020 at 05:42:05PM +0100, Michael Hendry wrote:
>> 
>> This probably won’t be an issue for Chris Green, who would be better served 
>> by an Undeposited Funds asset account. 
>> 
> Yes, I think you're right. We don't have any 'petty cash' in any of
> the normal senses.  We do have quite a bit of cash of course as that's
> what comprises most of our collections.  However we never pay expenses
> in cash, it's always by cheque even for quite small amounts.
> 
> I think the best approach is either:-
> 
>1 - Record the amounts in their different categories as required,
>e.g. 'collection' or 'offertory box' and simply record the same
>paying-in slip number against both transactions.
> 
>2 - Have, as you suggest, an intermediate "Undeposited Funds asset
>account" where cash is recorded as it's collected and then another
>transaction records when it's paid into the bank.
> 
> Given the very small PCC I'm managing I think 1 above will be fine.  I
> record the date of the collection in the Description and the
> transaction date is the date that the cash gets credited to the bank
> account.


I prefer 2 because the act of paying-in is a transaction distinct from the 
receipt of the cash, and may include cash received on several different dates. 
As well as being an accurate representation of what happened, it eases 
trouble-shooting when (e.g.) you can’t reconcile the bank account.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Be careful with `petty cash'

[Michael Hendry]

> On 9 Sep 2020, at 15:25, Michael or Penny Novack  
> wrote:
> 
> On 9/8/2020 11:32 PM, Adrien Monteleone wrote:
>> I've seen suggestions in accounting texts (and use myself) an account called 
>> 'Undeposited Funds' as a Current Asset. Checks and currency destined to the 
>> bank (but not there yet) are recorded here when received.
>> 
>> Regards,
>> Adrien
> 
> Yes, the term "petty cash" has traditionally had a different meaning. In a 
> very small business, might actually be currency but in a large one likely its 
> own bank account. And a subsidiary set of books. The idea was to reduce the 
> load on the treasurer/chief accountant and not clutter the main books with 
> trivial detail.
> 
> In the petty cash books would be each transaction, each box of pencils, box 
> of reams of paper, flowers for the boss's reception room, etc. Then say once 
> a month the petty cash account would be "refreshed" with the total spent and 
> each category of expense closed to the main books. Thus the parent "office 
> supplies", "postage", etc.  and not each box of pencils or roll of stamps.
> 
> Michael D Novack

In my past life as an NHS GP, most of our income came from our NHS contracts, 
but we received some income directly from patients for non-NHS work such as 
foreign travel immunisation, certificates and employment-related examinations 
(e.g. for heavy goods vehicle drivers). We recorded this in a petty-cash book 
and a cheques-received book. Drawings from petty cash for sundries and 
refreshments seldom exceeded the contents of the cash box, which was being 
topped up by cash income with the excess being periodically paid into the bank 
along with incoming cheques.

Our accountant never complained about this way of working, so I assumed it was 
acceptable.

In the context of a small Rotary Club, cash income is received at community 
events and there rarely a need for cash expenditure on the day. Occasionally, 
though, someone has to nip out for supplies part of the way through an event, 
and it’s convenient to be able to deal with that in cash on the day.

This probably won’t be an issue for Chris Green, who would be better served by 
an Undeposited Funds asset account.

Regards,

Michael Hendry
___
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 an 'easy' way to have a transaction with 'sub-transactions' as it were?

[Michael Hendry]

> On 8 Sep 2020, at 16:42, Chris Green  wrote:
> 
> On Wed, Sep 09, 2020 at 01:15:00AM +1000, John Angelico wrote:
>> Chris, I would also recommend asking why the amounts are separated, because
>> there may be a reason for reporting the income lines separately. Then if
>> the reason no longer applies you may ask what reporting is now required.
>> 
>> Some items need to be shown or accessible for statistics, for grant
>> applications or for statutory reporting. There could be any number of
>> reasons behind "we've always done it that way" :-).
> 
> Yes, I will be asking at the next PCC meeting and will keep the
> separation until then at least.

I would suggest you create an account for cash in hand, such as Assets:Current 
Assets:Petty Cash.

You can then log the two different cash receipts as transfers from 
Income:Offertory —> Petty Cash and Income:Collection —> Petty Cash.

These will be dated for the Sunday the cash was received.

At some future date, you’ll transfer the whole (or part) of the Petty Cash into 
the bank account with a single pay-in slip:

Asssets:Current Assets:Petty Cash —> Assets:Current Assets:Your Bank.

It’s becoming increasingly awkward to pay coin in to banks as branches close, 
and I’d be inclined to accumulate a larger sum before paying it in.

Even if you don’t see the point of recording the sources of the cash 
separately, remember that it’ll be a lot easier to merge the two accounts when 
you find one will do than to split them up when you’ve been recording them as a 
single source.

You may not discover until the end-of-year that no-one at the PCC knew what was 
actually needed!

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.