Re: [GNC] Can I set an option to stop auto-fill ?

[NoobAlice]

On 2024-06-03 03:44 PM, fromvendor wrote:

Anyway, what I'd like is if the "prior" transaction has splits, then simply 
leave the whole thing un-populated.  If it doesn't have splits, go ahead and put in the 
account.  Leave the cursor in the account field and don't fill in anything else (notes, 
amount, etc).  That would be ideal for me.  Simply turning off the auto-complete is, I 
expect, a simpler option and probably already there I just don't know where to turn it 
off.


I realize this isn't quite what you're asking, but there is a mouse 
right-click option on a transaction to "remove other splits."


When you are typing, using the mouse is not convenient, so you can set 
up a shortcut for it.


Reference: 
https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_Keyboard_Shortcuts


I found the full list of shortcut-able actions in my root folder
/usr/share/gnucash/ui/

So in my local file ~/.local/share/gnucash/accelerator-map (on Linux, 
your path will be different if you are on Windows or Apple), I have 
added these 2 lines:


; Remove other splits from transaction
(gtk_accel_path 
"/GncPluginPageRegisterActions/RemoveTransactionSplitsAction" 
"m")


Now I can hit Ctrl+M to make my other splits disappear.

Note that the example in the wiki is a different splits shortcut, I 
think to turn on multiple split entry.


___
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] Reconciliation Roll Back (Peter Cuthbert)

[NoobAlice]

On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote:

The dates associated with the reconciled/not reconciled flag struck me 
as an easy way to do a roll back without using the backups.  Something 
along the lines of if date = [specified reconciliation date] then 
flag = n (I have no idea what language is used by the developers. 
...
So where am I with my data?  I have corrected the £10k which was 
'swopped' and then gone after the error schrapnel.  Some of that I have 
found and corrected but eventually I had to succumb to a balancing 
'fudge it' figure.  With that in place the rest of the reconciliation 
was correct to the penny.


To you and anyone else facing this issue, you can run a transaction 
report that shows you a history of of the account with reconciled dates 
for every transaction.


Reports > Transaction Report
Options
Accounts: Choose your checking account
Display:
Check Reconciled Date
Check Date Entered (may be useful, so why not)
Amount: Single column
General:
Start: BEFORE YOUR FIRST TRANSACTION EVER - I pick Jan 1 2000
End: Today
Sorting:
Primary key: Reconciled Status, Ascending
Uncheck Primary subtotal
Secondary key: Reconciled Date, Ascending (sort doesn't work)
Secondary subtotal for date: NONE

Now run the report.  It doesn't get the sort by reconciled date quite 
right, but it might be close.


At this point you need to put the report in a spreadsheet program.  I 
copy and paste, but there are many methods people have shared on the list.


See attached  for an example of what I describe below.  It is very 
important that the start date of your report is before the first 
transaction you have in the account.


In the spreadsheet program, paste and unmerge cells, then:
1) Freeze panes so the column labels at the top don't move
2) Set up a filter across all columns.
3) Use the filter dropdowns to sort by reconciled date.  Make sure the 
transactions with no date are at the bottom and that the reconciled 
transactions are with reconciled dates oldest to newest.
4) Make a formula in a column to the right of your data to make your 
spreadsheet program recognize the numbers.
5) Make a formula in a column to the right of your data to do a running 
subtotal.  (Something like =SUM(I$1:I2) and drag it down, with "$" 
making a part of the formula sticky.)


Now you can quickly look at the reconciled balance as of the end of each 
reconciliation and see if it matches your bank statement.  Once you find 
the first one that doesn't work (or the last one that works), you can 
look at your bank statements and see what transactions are missing from 
the reconciled list in GnuCash.  Look for those missing transactions in 
the unreconciled ones at the end of the list.


I would suggest fixing transactions on the spreadsheet report to get 
things working and highlight all my changes in bright yellow.  Once 
everything is making sense in the spreadsheet, you can make the changes 
in GnuCash.


I have this report saved as Transaction Report -> Rec Report Details

GnuCash Sample Reconciliation.xlsx
Description: MS-Excel 2007 spreadsheet
___
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] Separating tax years for payments in next year

[NoobAlice]

I just start my description "2023 Q1 fed estimate" or similar in my tax 
payable account.  If you do that, you can use a filter for reports.


Also, since I use a liability account, I can reconcile it after filing. 
Then you can filter the account itself for unreconciled transactions, 
which will then just show 2024 estimates.


On 2024-03-08 04:54 PM, David G. Pickett via gnucash-user wrote:

I recently created ExpenseAccounts/Taxes/FederalEven and 
ExpenseAccounts/Taxes/FederalOdd to allow me to get a meaningful report on 
estimated tax and various tax withholding.  The payments in Jan 2024 for 2023 
estimated and later for 2-23 tax due do not clutter the reports on 2024 tax 
year, and the 2022 items do not get into the 2023 report.  Is there a better 
way to deal with 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.

Re: [GNC] Minor silliness bugs

[NoobAlice]

On 2024-02-13 11:44 AM, David G. Pickett via gnucash-user wrote:

I run the latest gnucash from flatpak on Ubuntu 22.04 LTS Linux.  When I launch 
gnucash from my taskbar of favorites, it sends a notification to my top central 
bar menu that it is ready, when it is only ready to display a splash, and many 
additional seconds must elapse before all the XML is loaded into VM structures. 
 Maybe it should not bother, or wait until the app window is actually open 
(usually asking if I approve my scheduled transaction creation with a list of 
mostly unchanged folders or subaccounts, also silly, as yes, I approve of it 
not changing unrelated things).


I don't know about Ubuntu or Flatpak peculiarities, but if you go to 
Edit > Preferences > sidebar General > section General, you can uncheck 
the splash screen, "tip of the day", and possibly account list setup if 
that is causing annoyance.  I do have account list setup checked, but it 
does not appear when I open GnuCash to my usual books, so that may be a 
Flatpak oddity.  (I'm using Linux, but not an Ubuntu derivative.)


Also, Edit > Preferences > sidebar Scheduled Transactions lets you turn 
off automatically running these when you open your books.  I can't tell 
from your email if that bothers you or not.  I do like "Review created 
transactions" if you want to check that box while you're in there. :)

___
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] Reports for Personal Finance

[NoobAlice]

On 2023-12-05 10:46 AM, Tom Balazs wrote:

For the case of an individual or a family, what are the most useful reports?



First, make sure to Save Config As for any report you've had to do a lot 
of customizing to generate.


For my own personal use, there are a few reports I use most:


These two:
Assets & Liabilities > Balance Sheet (Multicolumn)
Income & Expense > Income Statement (Multicolumn)
In Options for each:
General
Period duration: pick months, years, etc. your choice!
Start and end dates
Decide "If more than 1 period column, include overall period?"
Display - make your choices :)
Commodities - Check box for "common currency" so any investments show as 
their values, not share counts



Groceries and restaurant spending by half-year monthly average.
Expense Chart
Income & Expense > Expense Chart
In Options:
General
Set report name you want
Start and end dates
Step size: Half Year
Show average: Monthly
Display - Chart type: Line Chart
Accounts - Choose your food accounts

There is a point on the chart every six months, and it is the average 
total of the months that comprise it.  If you're someone who buys, say, 
half a cow a couple of times a year, when looking at what you spend in 
groceries on average in a month, it doesn't make sense to have this 
massive spike in cow-buying months but then have very low meat bills 
other months as you eat down your stash.  This is great to see long-term 
effects on your food budget due to different shopping choices and/or 
inflation.


___
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] Account reconciliation -- Gnucash's beginning balance is incorrect.

[NoobAlice]

On 2023-11-07 12:26 PM, John Reagan wrote:
> ... but the starting balance for that period was $299.46
> which is the reconciled balance at the end of July. Instead, Gnucash is
> showing a starting balance of $ -200.54.
>
>  I tried entering a correction transaction of $200.54, but it didn't
> change anything.

I would think that correction would have to be:
$299.46 - (-$200.54) = $500.00

Instead, maybe there is just a $500 transaction to clear/fix.

On 2023-11-07 01:03 PM, John Reagan wrote:
... When 
I use the */actions/reconcile/ *menu choice to reconcile my account, 
that false beginning balance is factored into the final balance. ...



How is that beginning balance calculated?  If I can check on the numbers 
that are used to calculate the beginning balance, I should be able to 
find the mistake that is generating that error.



John


If the ending balance in the register matches the ending balance on the 
statement, have you tried just checking off all transactions and seeing 
if that works?



Calculating the beginning balance:

For some reason I can't get the reconciliation report (or totaling by 
Reconciliation Date) to work well right now, but try out a Transaction 
Report.


Reports > Transaction Report

Set up thusly:
Accounts
Bank account you're trying to reconcile
Currency
Ignore this tab
Display
CHECK Date
CHECK Reconciled Date
CHECK Number
CHECK Description
Detail Level: One transaction per line
CHECK Other Account Name
Amount: Single Column
CHECK Grand Total
Running Totals: Grand Total Only
Filter
Reconciled Status: Reconciled Only
General
Report Name: Transaction Report QUICK RECONCILIATION
Start date: BEFORE YOUR FIRST TRANSACTION EVER!
End date: Today
Add options summary: Always
Sorting
Primary Key: Reconciled Date
Primary Sort Order: Ascending
Primary Subtotal for Date Key: None
Secondary Key: Register Order
Secondary Sort Order: Ascending
UNCHECK Secondary Subtotal

Run report, SAVE CONFIG AS and name it something like "Transaction 
Report QUICK RECONCILIATION" so you don't have to set this up again if 
it gets closed by mistake.


My options summary looks like this:
Sorting / Primary Subtotal for Date Key : none
Sorting / Primary Key : reconciled-date
General / Add options summary : always
General / Start Date : absolute . 2009-01-01
Filter / Reconciled Status : reconciled
Display / Running Totals : grand
Display / Enable Links : Disabled
Display / Amount : single
Display / Reconciled Date : Enabled
Accounts / Accounts : Checking Account

This report should give you the reconciled balance in the account as of 
each period end date.


If you want a guide for finding the time period of the issue quickly:

Pull out your bank statements.  Check the ending balance for last month 
against the bank statement.  If those don't match, maybe check the 
balance for two months ago.  Then the end of last year.


If that still doesn't match, check the end of three years ago, or five, 
or ten.  Keep checking balances until you narrow down a range of before 
the difference happened.  If you find that the reconciled balance did 
not match at the end of 2022 but did match at the end of 2020, split the 
difference and try the end of 2021.  And then you know which year it 
was, so take June of that year and check that balance.  Then you know if 
it was the first or second half of that year, etc.


Your goal is to quickly narrow down which month the issue appears 
without checking every single month.  Then you can run a separate 
transaction report for that month and check it against your bank statement.


___
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] GC Best Practices for Investment Management

[NoobAlice]

On 2023-11-08 01:16 PM, Jediator wrote:

... I noticed that a major feature in
GC is the stock and investment management function, which I was 
hesitating to get into.  I'd like to hear from fellow GC users on the 
usefulness and best practices for using GC for investment management. 
Especially:


1. GC was developed in the 90's before many brokerage firms offer
    portfolio management and analysis tools.  Is it really useful to
    replicate your investment data in GC from your brokerage account?
    What are the advantages does GC bring in doing this other than
    calculating capital gain taxes/loss?


I find these uses:
* Keep track of multiple brokerages with multiple accounts in each
* Keep track of running balances of taxable and tax-exempt income of 
various types during the year
* See summaries over multiple years of different tax types of income by 
account/investment

* As Richard Losey said, have offline access to quick info about accounts :)

I reconcile my brokerage accounts with GnuCash monthly.


2. What types of direct reporting functions in GC for investment
    management (Info in tool guide and online Wiki seems to be outdated)?


I don't tend to use the built-in reporting tools  for investments except 
for quick looks.  In general, I export multi-column balance sheets and 
income statements to my own spreadsheet to let me:

* check and correct allocations across accounts
* calculate quarterly estimated taxes - earned income information is 
also in GnuCash

* model what different investing moves would do to my tax situation
* get a much better estimate of what portions of dividends will be 
qualified, return of capital, foreign tax, etc. than brokerages are 
willing to give mid-year


Specifically, I don't use the Advanced Portfolio to check my cost basis. 
 It uses average cost basis, and I don't.  Every so often, I will 
"Export the Active Register to CSV" to check that my cost basis in 
GnuCash matches what is on my brokerage statements.  (Except now I'm 
trying it and it looks like I can just use a modified Transaction Report!)


I find the "Trading Accounts" function absolutely vital.

I find it very useful to reflect with my own chart of accounts the 
breakdown of income that the tax return will use.



3. How do you compare GC with other open source products (e.g.,
    Ghostpolio)?


I have never tried another.  I stick to mutual funds and a basic 
allocation, though across several taxable/retirement accounts, so my 
needs are comparatively simple.  I usually end up making just a few 
rebalancing transactions each year.  My use would probably not be 
relevant if you are big into trading.  :)


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

Re: [GNC] Reply convention

[NoobAlice]

On 2023-08-22 06:21 PM, Brad Morrison wrote:


...but does anyone know if
the various email formatting conventions
(https://wiki.openstack.org/wiki/MailingListEtiquette) can be adjusted
by the mailing list user at the email client level?


I don't know about other email clients, but Thunderbird seems to have this 
functionality on a per-account basis.

Edit > Account Settings
Pick the email address you use for mailing lists
yourem...@domain.com > Composition and Addressing
Check the box for "Automatically quote the original message when replying"
Choose drop-down "When quoting... start my reply below the quote."
and set signature options as you choose.

Also, while you're in there, uncheck "Compose messages in HTML format," as I 
think a lot of that doesn't come through for mailing lists.

___
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] Construction Billing By Project

[NoobAlice]

On 7/27/23 3:43 AM, Angela Haggerty wrote:

Firstly, it's past 3 AM and I am arguing with myself on how to enter
construction projects into GNUCash for a bookkeeping LLC client.



Currently people tend to "tag" transactions by putting @job1 in the 
description of any transaction that affects Job 1.  That makes it a term 
that is easy to filter for reports.  Or use #jobB or whatever string 
format will be easy to input consistently and not get mixed up with 
other things.


Currently, to run a report for a single job where you have used this 
tagging system, you would go to:

Reports > Transaction Report > modify options:
Accounts: choose accounts to include (just income/expense for you)
Filter: in Transaction Filter, type @job1
General: pick your dates
And that will give you transactions for each account with totals.

Assuming you tagged everything, this should give you an idea of a single 
job's profitability.  You can also run the transaction report to show 
all transactions that do *not* include those tags; this lets you look 
over a list of overhead expenses and make sure you have no untagged job 
costs there by mistake.


Alternate method:
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107072.html

HOWEVER, Vincent Dawans has been working on reports that might give us 
reports for multiple jobs at a time.  See the following mailing list 
posts, ensuing discussions, and links therein

https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106693.html
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106749.html
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107035.html

You will want to follow the mailing list and pay attention to anything 
that other people are calling classification/category/dimension 
reporting.  For our purposes they are the same.


___
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] Transaction line debit/credit in split view

[NoobAlice]

On 2023-07-23 02:54 PM, john wrote:
https://bugs.gnucash.org/show_bug.cgi?id=799041 coomplains that the 
transaction line in split view shows the amount for the anchor split 
in the register account in the Tot Debit or Tot Credit columns instead 
of the value in the transaction currency as is shown in the 
single-line view. He proposes that the transaction line in split view 
should also show the value in the transaction currency, that is shares 
* price. Does anyone have an opinion about this? 



I sometimes found Steven Bruniges' writing a little difficult to follow, 
so pardon if I've missed something.  I disagree with him; the 
transaction line in the split view shouldn't show the value in the 
transaction currency because the share price isn't being shown.  (Why 
doesn't he have the "Price" column header?)


My preferences would be, referencing the first two screenshots from the 
original bug:


Screenshot https://bugs.gnucash.org/attachment.cgi?id=374842
* Leave all numbers as-is

Screenshot https://bugs.gnucash.org/attachment.cgi?id=374843
* In the "Tot Sell" column remove the top black 3 and leave that cell blank.

In BOTH screenshots
* change heading "Balance" to "Shares Balance" to indicate it is not the 
cash value total but the shares total
* no need for "Tot" in any of the three column headings that use it.  
They are not really totals, which just makes this a little odd.



Surprisingly, this does not appear to be an issue in my single 
other-currency balance sheet account (except for the "Tot" parts of 
column heads), probably because conversion rates are not displayed in 
the register.



___
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] "Comparative" reports?

[NoobAlice]

On 2023-07-19 07:00 PM, Simon Roberts wrote:

They raised a question; Is there a built in mechanism for "comparative"
reporting? For example, showing income from Jan 1 to date, alongside income
over the same months in the previous year?


In GnuCash 5.1 (not sure when feature first showed up, but I think it 
was recent), you can do this for nice divisions such as year, half-year, 
quarter, month, 2-weeks, and week.


Reports > Income & Expense > Income Statement (Multicolumn)
or
Reports > Assets & Liabilities > Balance Sheet (Multicolumn)

In Options > top tab General, choose Period Duration of how you want the 
info split, then choose start and end dates appropriately.


For example, if you choose Half Year with Start Jan 1 2021 and End Dec 
31 2023, it will show you columns for the six months ending on / as of date:

2021 June 30
2021 Dec 31
2022 June 30
2022 Dec 31
2023 June 30
2023 Dec 31 - though this one won't have much activity yet!

It is an excellent pair of reports.

You can of course paste them into a spreadsheet program and remove 
whatever columns you don't find useful :)


If you want some odd period that doesn't line up with your fiscal year 
like February 23 - April 5, then you'll have to run separate reports and 
not use these nice ones.


Enjoy!
NoobAlice
___
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] Can not resize GnuCash Preferences window

[NoobAlice]

Default User hunguponcontent,

This is probably a Wayland windowing system problem, not a GnuCash 
problem.  On Xorg, the window is easily resizable and movable.


What have you tried besides changing the display resolution back and forth?

If you were on Xorg, I would say try these individual solutions on the 
Preferences window:
* dragging the grabbable titlebar of the window down, then using your 
mouse to resize the window shorter, then dragging it up so you can see 
the bottom
* holding down your Alt key and then click-holding your normal (left) 
mouse button and dragging the window with your mouse
* hitting Alt+F7, then using your arrow keys to move the window and 
hitting Enter when you have it where you want it
* hitting Alt+F8, then using your arrow keys to resize the sides of the 
window and hitting Enter when you have it where you want it


And then I would tell you that, if this window is appearing in the wrong 
place all the time, you could install and set up devilspie to fix it 
permanently.  :)


Surely Wayland has some similar way to manipulate windows.  My quick 
search says that shortcuts are handled by the compositor in Wayland [1]. 
 You might get much better answers if you ask in the Gnome support 
channels.


Good luck!  This is a frustrating problem to have. :(

[1] 
https://wiki.archlinux.org/title/Wayland#Input_grabbing_in_games,_remote_desktop_and_VM_windows



On 2023-06-25 03:08 PM, Default User wrote:

Hello!

I am trying to set up GnuCash:

Version: 4.13
Build ID: 4.13+(2022-12-17)
Finance::Quote: 1.54

on Debian 12 (bookworm), 64-bit, using Gnome 43.4, wayland windowing
system (not xorg).

This is a .deb package, "GnuCash Version: 1:4.13-1, Built-Using:
googletest (= 1.12.1-0.2)", from the Debian Stable repositories, NOT a
flatpak, snap, or appimage.

When I do Edit --> Preferences, the Preferences window opens, but the
bottom part is cut off.  No matter what I try, I can am not able to
resize it to fit the screen. Nor can I even move it past the top edge
of the screen.  I even tried reducing the display resolution, to no
avail.

So, is there a solution, or even a viable workaround?




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


___
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] Standard Report - Equity Statement

[NoobAlice]

Hi Ismael,

"Equity Statement" as a report is the net of your total assets and 
liabilities, your personal equity.  You reach it via

Reports > Income and Expense > Equity Statement
The "Investments" are amounts that you add directly to 
personal-equity-type accounts.  So if I have an account named "Opening 
Balance" that on the Accounts page is Type: Equity, changes to that 
account show up on the Equity Statement report.


You probably want to use "Advanced Portfolio" from
Reports > Assets & Labilities > Advanced Portfolio
which will show you the stocks you own in companies and your investments 
in them.  These are Type: Stock on your Accounts page.  These stocks are 
your equity in these companies, but they are just a part of your 
personal equity.
* The total you have invested in each stock through the report date is 
shown in the "Money In" column.

* The total sales are the "Money Out" column.

To make an investment in a stock, money comes out of your checking 
account (an Asset) and goes into the stock (another Asset).  So your 
personal equity does not change at this time, and there is no change to 
the Equity Statement.  But the Advanced Portfolio will show the stock 
investment.


I hope I didn't over-explain anything, but I'm trying to make this clear 
for you and anyone else who has a similar question in the future and 
finds this mailing list post.


NoobAlice

On 2023-06-23 11:08 PM, Ismael via gnucash-user wrote:

Hello
I use V5.1 & Win11

My Standard Report - 'Equity Statement' does not show any amount for 
'Investments for Period'.

I am sure that I have made investments and recorded them in the respective 
Asset account (Stock).

Gnucash HELP is not really helpful for 10.3.5.2. Equity Statement.

Any idea what to do to see 'Investments for Period' in Standard Report - 
'Equity Statement'

Regards
Ismael
___
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.


___
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] Merging Two Accounts

[NoobAlice]

I would say, in addition, make sure that neither your source account nor 
your destination account is marked as "hidden" or "placeholder."  Or, if 
it is, use the little configuration icon (for me it is a wrench and a 
screwdriver crossed) to show hidden and placeholder accounts.


Accounts should be the same type, as David says.
I was not able to delete-merge a type "asset" account into a type "bank" 
account until I changed the "asset" account into a "bank" account.


On 2023-06-18 02:48 PM, David Carlson wrote:

Check the account types of the accounts that you want to merge.  There are
some limitations on account types that will merge.  In release 3.8, IIR, it
is possible to merge liabilities with assets or expense with income, but
not securities with much of anything else.  Perhaps others have additional
suggestions.

On Sun, Jun 18, 2023 at 1:40 PM Matthew Clay  wrote:


Dear Gnucash Community,

I am trying to merge two accounts in gnucash by deleting one account and
moving all of its transactions to the other account. This is explained in a
thread "Merging Two Accounts" dated  Mon May 9 17:15:22 EDT 2011. After
selecting "Delete Account", however, the list of destination accounts in
the "Move to" dropdown menu is severely limited, and even after I manually
type in the full path to the destination account, gnucash does not
recognize it. I have tried renaming the accounts and moving them around in
the Assets tree, but I still cannot select my target destination account.

Has anybody experienced this issue?

I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu system.

Thanks,
Matthew
___
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.






___
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] In Praise of Excellent Features

[NoobAlice]

Hello All!


No questions, just joy!  Thank you to all the devs and to everyone who 
gives advice in the mailing list!


I have been happily using GnuCash for years.  Today I was poking through 
the menus to see if I could find an Expand All/Collapse All option for 
the accounts tree, when I saw other options I had never previously noticed.



New treats:

Edit > Cascade Account Properties
For an account and all its subaccounts, you can change all the colors, 
set placeholder status, and/or set hidden status.


Edit > Renumber Subaccounts
WOW!  This has been the bane of my existence when working with 
QuickBooks-using clients who have never numbered their charts of 
accounts, as the external program we use requires numbered accounts. 
This looks so efficient!  I am accustomed to manually changing account 
numbers one. by. one.


Actions > Rename Page
This looks so convenient.  You can even rename the Accounts page!


And my favorite options that are good friends:

Variables
You can use variables in scheduled transactions.  For example, if you 
are entering a paycheck and you like to split out taxes and deductions, 
you can just fill in the blank for "grosswages" and have GnuCash compute 
all the line items.

Credit Salary   grosswages
Debit Income Taxgrosswages*0.10 ### 10%
Debit Retirementgrosswages*0.05 ### 5%
Debit Local Tax 3.98### assuming fixed amount
Debit Health Insurance  100.00  ### assuming fixed amount
Debit Checking Acct grosswages*(1-0.15)-3.98-100### net of above

Spreadsheets
One can just copy a GnuCash report and paste into a spreadsheet for 
further manipulation, which is great for generating external reports for 
non-coders such as myself.


Custom Shortcuts
Two simple edits to ~/.local/share/gnucash/accelerator-map, and I have 
shortcuts to open the Saved Reports list with Ctrl+A and turn 
double-line view on/off with Ctrl+D!!!

;
; Double-line register on/off
(gtk_accel_path 
"/GncPluginPageRegisterActions/ViewStyleDoubleLineAction" 
"d")

;
; Saved reports configuration list
(gtk_accel_path 
"/gnc-plugin-menu-additions-actions/AdditionsAction/4d3dcdc8890b11df99dd94cddfd72085Action" 
 "a")


___
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] report cutoffs - Trial Balance opening date

[NoobAlice]

Just send him a trial balance AND the income statement and balance 
sheet.  The "closed books" trial balance he wants is going to look 
similar to the balance sheet plus income statement stacked anyway, just 
without totals.
The trial balance will let him see that nothing from the other two 
reports is missing.


Alternatively, you can put the Dec 31 2021 and Dec 31 2022 balance 
sheets next to each other and just take the difference between the 
income statement items as the amounts to display, then reverse the total 
of those to equity, but that is probably more trouble than it's worth.


On 2023-05-19 06:09 AM, Rogier F. van Vlissingen wrote:

Thanks for that.
I gotta have a serious talk with my accountant. He objected to the report
and it sent me wondering.

On Thu, May 18, 2023 at 11:56 PM David T.  wrote:


Per the documentation:


10.3.5.11. Trial Balance


Trial Balance lists the ending balances in all accounts as of a particular
date. It is typically run at the end of an accounting period and is
primarily used to ensure that the total of all debits equals the total of
all credits.


By definition, that means there *isn't* a start date.



___
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] Auto commit with auto save?

[NoobAlice]

A little bit of a topic change, but I find setting Edit > Preferences > 
Scheduled Transactions > check box Review Created Transactions
as an overall preference (as opposed to remembering to check the box on 
the popup scheduled transactions window) really simplifies scheduled 
transaction fixing because then I don't have to hunt it down in a 
specific ledger.


I agree on the unsaved transactions issue.

On 2023-05-19 06:23 AM, ed...@billiau.net wrote:

*snip*

Every three months I have a split transaction with 7 splits. I will
edit that sequentially in 6 or 7 registers. I used to try concurrent
editing, but if it ever worked, it doesn't now.
At present it can only be saved from one register, but its not the one
I opened it in first, it's the one from which I saved it as a scheduled
transaction.
Even finding that register to save a complex transaction is difficult
some days.

Just to let you know that what Stan describes is a difficulty in
Gnucash, not just some awkward users with complex use cases, this is
just doing my tax.

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


___
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] Easy way to delete old transactions

[NoobAlice]

In my opinion, you are opening a can of worms, but if you are set on 
this course...


If you have separate tax returns or other documents that let you know 
the income/loss of each entity each year, you may need those to let you 
determine correct starting equity by entity.  You will need to figure 
out what the balances for each account are for each company before you 
get too far in so that you have something to check against.  Going 
forward after this you will need to make any transactions that affect 
multiple entities in multiple sets of books.


I will refer to the entities as "Companies" throughout this.  I am 
probably missing at least one step here, as I can't see your books or 
how you've set them up.


*
SPLIT OUT EXISTING BOOKS WITH HISTORY:
*
You could (first make a backup, and then):
* start with File 0
* copy to File 1
* copy to File 2
* in File 1, delete checking and other accounts related to Companies 2 & 3
* in File 2, delete checking and other accounts related to Company 1
* copy File 2 to File 3
* in File 2, delete checking and other accounts related to Company 3
* in File 3, delete checking and other accounts related to Company 2

When you delete the accounts, choose to delete the transactions, too.


BUT, if you have ANY transactions between companies, you will need to 
first, before anything else, split those transactions into one 
transaction for each company.


You may be able to prepare lists to find these transactions by, for 
example, running a transaction report for Company 1 checking, savings, 
etc. that is filtered by Company 2 checking, savings, etc.


* Create 6 accounts (3 companies x 2 related companies for each)
* COMPANY 1: Due to/from Company 2
* COMPANY 1: Due to/from Company 3
* COMPANY 2: Due to/from Company 1
* COMPANY 2: Due to/from Company 3
* COMPANY 3: Due to/from Company 1
* COMPANY 3: Due to/from Company 2
(or, instead of Due to/from you could use equity accounts, depending on 
entity structure, or perhaps new due to/from you personally as the 
single account for each company.)


* Split out entries manually as follows:
For sample entry "to move cash from Company 1 to Company 2"
Original:
Dr $100 Company 2 Checking
Cr $100 Company 1 Checking

Becomes two entries:
"Company 1 books: to move cash from Company 1 to Company 2"
Dr $100 COMPANY 1: Due to/from Company 2
Cr $100 Company 1 Checking

"Company 2 books: to move cash from Company 1 to Company 2"
Dr $100 Company 2 Checking
Cr $100 COMPANY 2: Due to/from Company 1

When you are done splitting out these entries, your balances for each 
pair of intercompany accounts (or your total of new due to/from you 
personally accounts) should net to zero.



Then you can start the process of copying the books.

There may be other manual entries that I've missed.  You will want to 
allow yourself many hours for this and to work slowly, ready to go back 
and fix things in File 0 and restart the rest of the process.



*
SPLIT OUT BOOKS WITH FRESH START:
*
Or, start three new books as of the beginning of your year with one 
entry each "To split out from combined file" that splits to the opening 
balances for that company.  Copy the chart of accounts from the original 
into each entity file and delete unneeded accounts as you choose.  You 
will still need to figure out opening balances and intercompany accounts.




On 2023-05-06 07:43 AM, Fred Tydeman wrote:

I have been keeping the books for three separate related entities in the
same file.
I have decided it would be better to have each entity in its own file.
So, one idea is to copy the large file 3 times, to three different names.
Then delete the accounts and transactions of 2 entities, keeping the third.
Do that three times so each file ends up with just the data for one entity.
I have around 1915 accounts, so that might be too much work.

I believe I first tried: Export Transactions to CSV (for a subset of
accounts),
then Import Transactions from CSV
but I got lots of errors about missing items (perhaps securities).
(could be I did that wrong).

I am open to suggestions.



___
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] Tags for classification/category/dimension transaction report

[NoobAlice]

Seconded!  This would be a massive improvement to the excellent GnuCash, 
in my opinion.  Thank you so much, Vincent!  As described, this feature 
would add so much more utility in so many areas of reporting.


Besides flywire's "classification/category/dimension," I would also add 
"jobs/projects" as keywords for anyone hunting down this thread later.


Message: 8 Date: Tue, 2 May 2023 19:26:46 +1000 From: flywire  >  To: Vincent Dawans  Cc: 
Gnucash > Users  Subject: [GNC] Tags for > 
classification/category/dimension transaction report Message-ID: > 
 > 
Content-Type: text/plain; charset="UTF-8" Re: > 
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106749.html > 
Vince you are a champion! > 
https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1530788858 >> 
My personal view is this workaround is the most significant improvement 
> since V2.

___
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] Locking the side bar items

[NoobAlice]

On 2023-04-14 12:00 PM, gnucash-user-requ...@gnucash.org wrote:


Message: 3
Date: Fri, 14 Apr 2023 09:48:31 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Locking the side bar items
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

On 4/13/23 1:00 PM, NoobAlice wrote:

make close-program button
bigger to cover up clickable close-tab space - THE INVISIBLE CLOSE
BUTTON IS STILL CLICKABLE, though this hacky stuff makes the clickable
space smaller... */


There is no "close-program" 'button' save what is on the window title
bar and that is only addressable by the OS itself - not GnuCash or CSS.

What are you referring to?

Regards,
Adrien



I am referring to the menu items close program File > Quit Ctrl+Q and 
close tab File > Close Ctrl+W.  Sorry, they're not actually buttons, but 
it is still a problematically-clickable area.


Attached are two screenshots showing:
Close-fix1.png - the empty space on the toolbar with the Close button gone
Close-fix2.png - the very big Quit line on the file menu with most of 
the Close menu item gone___
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] Locking the side bar items

[NoobAlice]

I can't help with the "pin tab" idea, but for those who want to keep the 
toolbar around, I've come up with an admittedly-hacky way to hide the 
"Close [tab]" toolbar button.  I also have a hide for the File menu 
item, but it still leaves a small, clickable area that will close a tab, 
unfortunately.


Remember that any errors in a .css file for GTK programs will cause the 
entire thing to be ignored.  :(


I've only tested on my own Linux computer.  The 6000 pixels measurements 
are just to be bigger than any monitor so you don't have a close button 
floating off to the side.  :)


If anyone has more elegant CSS for this, please do share!

In Linux, I add the following to my ~/.config/gnucash/gtk-3.0.css file, 
saved it, then restarted GnuCash.  Your file will be (or can be created) 
in the "GNC_USERCONFIG_DIR:" path shown in Help > About GnuCash.


For anyone wanting to play around further and using Linux, 
'GTK_DEBUG=interactive gnucash' entered in the terminal opens a handy 
little GTK Inspector program.



/* Remove close-tab button on toolbar - the hover text will still show 
up, but this seems to make the button unclickable */

#ToolbarClose *
{
margin-left: 6000px;
margin-right: -6000px;
}

/* Remove close-tab button in File menu and make close-program button 
bigger to cover up clickable close-tab space - THE INVISIBLE CLOSE 
BUTTON IS STILL CLICKABLE, though this hacky stuff makes the clickable 
space smaller... */


#FileClose,
#FileClose *
{
margin-left: 6000px;
margin-right: -6000px;
font-size: 0px;
padding: 0px;
}

#FileQuit,
#FileQuit *
{
margin-top: -20px;
margin-bottom: 0px;
}




On 2023-04-12 01:51 PM, gnucash-user-requ...@gnucash.org wrote:

Message: 1
Date: Wed, 12 Apr 2023 16:07:38 +
From: Gyle McCollam 
To: G R Hewitt 
Cc: David T. , "gnucash-u...@lists.gnucash.org"
, Adrien Monteleone

Subject: Re: [GNC] Locking the side bar items
Message-ID:



Content-Type: text/plain; charset="utf-8"

You're very welcome, but as Stan correctly pointed out that doesn't solve the 
"problem" of the toolbar icon closing a tab when a lot of people ass/u/me that 
it will close the program.



Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: G R Hewitt 
Sent: Wednesday, April 12, 2023 11:51 AM
To: Gyle McCollam 
Cc: David T. ; gnucash-u...@lists.gnucash.org 
; Adrien Monteleone 
Subject: Re: [GNC] Locking the side bar items

Gyles, sir, you win the cigar (or prize of preference).
What's annoying is I looked there, but just didn't see it.
Thank you so much.

On Wed, 12 Apr 2023 at 15:40, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
You can remove the "X" on the tabs to prevent accidental closing.  Under 
Edit/Preference/Windows and the section labeled Tabs.  Just click on box to remove the check on 
"Show close on notebook tabs".  Then you shouldn't be able to close accidentally.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email





___
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] User defined currencies in "Expense Accounts"

[NoobAlice]

Date: Sun, 12 Mar 2023 08:45:18 -0700
From: john 
To: Charles Crossan 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] User defined currencies in "Expense Accounts"
Message-ID: <204d86ba-9b99-470c-960d-b15cd7ef0...@ceridwen.us>
Content-Type: text/plain;   charset=us-ascii



On Mar 12, 2023, at 7:51 AM, Charles Crossan  wrote:

While doing my monthly ritual of breaking down my utility bill into
GNUcash, I had the idea of using a user defined currency for electricity
(Kilowatt Hours - kWh) and Water (gallons).  I'd like to be able to chart
my "real usage" as well as rate fluctuations.

I've been using GNUCash for over 10 years, and have created a bunch of
custom currencies for stocks / etc; however, this is the first time I
thought about using it for tracking utility units.

I got as far as creating the kWh currency when I realized that there's no
way to choose a "non ISO 4217" currency for expense accounts.

The GNUCash documentation seems to indicate that Income and Expense
accounts are only able to use "National Currencies" (12.2.1.1. User-Defined
Currencies -
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
).

I'm wondering:

  1. Is there a functional reason for this requirement; or is it an
  arbitrary UI restriction?
  2. Would the application behave erratically if I were to manually edit
  the expense account in SQL to use my own currency?
  3. How is everyone else handling utility tracking?  I realize I'm
  probably a tad crazy for wanting this level of detail.


It's part of GAAP/IFS: Expense and Income are flavors of Equity and that can only be currency; in fact it's supposed to be only in the book currency, but GnuCash doesn't enforce that in part because it doesn't historically recognize a book currency. 


I don't see anything in the engine that will misbehave if you do that, but the 
account edit window might act up if you try to edit the account after making 
the change.

I use a spreadsheet to capture the amount of electricity, natural gas, and 
water we use monthly, but since they installed smart meters a few years ago the 
utility company has provided a nice usage display on their website with hourly, 
daily, and monthly charts, though the daily and hourly data is available for 
only a couple of years back.

Regards,
John Ralls


I am a third vote for "use a spreadsheet instead."  And I've taken a 
currency I don't need and repurposed it to track rewards card points 
(not updated with Finance::Quote of course), so I am sympathetic to your 
goals.


At least in my geographic area, part of the US, utility billing for 
electric and gas has enough moving parts that for tracking you really do 
want an entire spreadsheet, not just a "currency."


Some components to consider:
* meter read dates aren't always monthly - officially, our meter reads 
by the utility happen every other month...except when the meter reader 
is sick... or the meter reader gets the wrong number...or there is a 
worldwide pandemic...  (We send in our own readings recently, which 
helps a bit.)
* meter read dates are irregular - sometimes the utility co has meter 
reads (ours and theirs) 25 days apart, up to 35 days, very inconsistent. 
 Averaging out KWH per time period is better done on a spreadsheet.
* bills can include fixed and variable components - "service to your 
home" for gas and electric may be two flat fees
* time-of-day usage - some utility companies do this, another spanner in 
the works
* price per KWH can have multiple components - here, we have the basic 
price per KWH, but then added on are per-unit prices for delivery 
charges, taxes, and more
* energy supply companies - in some states of the USA, you can choose 
your supplier for gas or electric, which can change the rates you pay 
for power
* spreadsheets are nicer for calculations - you can do a 12-month 
rolling average to account for seasonal increases in use to see whether 
you are really increasing/decreasing usage over time, get a trend in 
part of your costs over time



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