Re: [GNC] Reports not displaying.

[Eric Koski]

John, I also have this issue... was just prepping taxes so I needed the 
reports.


The "WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash" 
works as described.  Just wanted to provide you with my system details 
for your investigation:


System:
  Kernel: 5.15.0-97-generic x86_64 bits: 64 compiler: gcc v: 11.4.0
    Desktop: Cinnamon 6.0.4 Distro: Linux Mint 21.3 Virginia
    base: Ubuntu 22.04 jammy
Graphics:
  Device-1: NVIDIA TU116 [GeForce GTX 1660] vendor: ZOTAC driver: nvidia
    v: 470.239.06 bus-ID: 0a:00.0
  OpenGL: renderer: NVIDIA GeForce GTX 1660/PCIe/SSE2
    v: 4.6.0 NVIDIA 470.239.06 direct render: Yes


WebKitGtk v2.42-5-0ubuntu0.22.04.2
___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[David Carlson]

Neal,

By chance are you using the enter key during your editing?

That triggers the full transactiion calculatkions.  Use arrow keys, ta b
key or mouse buttons until you are ready to see the transaction calculation.

I think calculztions within individual amount fields happen as soon as you
move out of that field unless you are creating a scheduled transaaction.

On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I'm not certain what you are describing, but I'll hazard a guess that
> you are seeing GnuCash auto-balance the transaction. That is normal.
> Every transaction has to be balanced. (Debits *must* equal Credits)
>
> You are free to enter the transaction however you like, as long as that
> holds true. If your self-entered amounts do not result in equal Debits &
> Credits, GnuCash will create a split initially not assigned to any
> account, but when you commit the transaction and that split remains, it
> will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a
> currency code) for the difference.
>
> Please read the GnuCash Help Manual and the Tutorial & Concepts Guide
> available in the Help Menu, or online, as you are learning the software.
> Then if you get stuck, come back and ask for help here.
>
> Regards,
> Adrien
>
> On 3/9/24 8:18 PM, W. Neal Lewis wrote:
> > When I do the View > Transaction and put in individual numbers for each
> item in the Withdrawal column, it starts to mess with my figures. It puts
> in a number at the very top. It adds deposits to other entries. What I end
> up with is a mish-mash of costs that the program seems to think that I need
> for some mythical number it has come up with.
> >
> > That's exactly what happened previously. I don't want it adding numbers,
> or changing numbers. I just want to put in the correct values for each
> line, including tax, hit return and have the final value show up on the
> first line of the transaction.
> >
> > I obviously don't know what I am doing.
> >
> > Help!
> > Neal
>
>
> ___
> 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] Importing Reports into LO Calc

[Adrien Monteleone]

You can certainly set that as a style in Calc.

Regards,
Adrien

On 3/9/24 9:01 PM, Robert Heller wrote:

I think the OP's issue is the fact that Calc does not preserve the red
coloring of the negative numbers.  The red coloring of the negative numbers is
something *GnuCash* is doing as a "good accounting practice", but the Calc is
not doing.


___
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] Importing Reports into LO Calc

[David H]

Hi Robert,

If I copy and paste a Gnucash report directly into LibreOffice Calc
(version 7.6.4.1 on Win10)  everything is black as expected except for the
negative numbers that are red which is what I also expected to happen ?
Not sure what's happening with OP's calc.

Cheers David H.


On Sun, 10 Mar 2024 at 13:02, Robert Heller  wrote:

> I think the OP's issue is the fact that Calc does not preserve the red
> coloring of the negative numbers.  The red coloring of the negative
> numbers is
> something *GnuCash* is doing as a "good accounting practice", but the Calc
> is
> not doing.
>
> At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote:
>
> >
> > 1. Export Report
> > 2. Open Calc
> > 3. Open the report file in Calc. Result is the report imported into
> > cells based on the html table.
> >
> > or
> >
> > 1. Export Report
> > 2. Open Calc
> > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the
> > exported report file. Answer the dialogs, result is same as above.
> >
> > or
> >
> > 1. Run Report in GnuCash
> > 2. Select All
> > 3. Copy
> > 4. Open Calc
> > 5. Paste, result is same as above
> >
> > In none of these cases is a web browser involved. (save for the Webkit
> > rendering within GnuCash, if you want to be pedantic about browser
> engines)
> >
> > I just tried all three, and in each case, there is no change in font or
> > alignments.
> >
> > Perhaps your issues involve whatever intermediary (browser) you are
> > involving that is unnecessary.
> >
> > Regards,
> > Adrien
> >
> > On 3/9/24 10:41 AM, Abe Sternberg wrote:
> > > I guess I am a bit dense - old age will do that to you.  Let me try
> and
> > > be a bit more specific on my actions and the errors I get. Below is a
> > > screenshot of a budget performance report in GnuCash.
> > >
> > >
> > >
> > > Next, I export it to the folder I want it in and open it in Calc. The
> > > file opens in a browser tab, and I cut and paste the data into Calc.
> > > Notice the different colors used.
> > >
> > >
> > >
> > > I wonder why the colors are there in the first place instead of the
> > > expected black.  The negative numbers being in red is good
> accounting
> > > practice.  Look at what happens when I copy them into Calc.ÂÂ
> Once again
> > > I get a shift in colors and the negative numbers are not in red and
> > > cannot be changed using cell format.  Is the problem in GnuCash or
> in Calc?
> >
> > ___
> > 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.
> >
> >
>
> --
> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
>
> ___
> 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] Importing Reports into LO Calc

[Robert Heller]

I think the OP's issue is the fact that Calc does not preserve the red
coloring of the negative numbers.  The red coloring of the negative numbers is
something *GnuCash* is doing as a "good accounting practice", but the Calc is
not doing.

At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote:

>
> 1. Export Report
> 2. Open Calc
> 3. Open the report file in Calc. Result is the report imported into
> cells based on the html table.
>
> or
>
> 1. Export Report
> 2. Open Calc
> 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the
> exported report file. Answer the dialogs, result is same as above.
>
> or
>
> 1. Run Report in GnuCash
> 2. Select All
> 3. Copy
> 4. Open Calc
> 5. Paste, result is same as above
>
> In none of these cases is a web browser involved. (save for the Webkit
> rendering within GnuCash, if you want to be pedantic about browser engines)
>
> I just tried all three, and in each case, there is no change in font or
> alignments.
>
> Perhaps your issues involve whatever intermediary (browser) you are
> involving that is unnecessary.
>
> Regards,
> Adrien
>
> On 3/9/24 10:41 AM, Abe Sternberg wrote:
> > I guess I am a bit dense - old age will do that to you.  Let me try and
> > be a bit more specific on my actions and the errors I get. Below is a
> > screenshot of a budget performance report in GnuCash.
> >
> >
> >
> > Next, I export it to the folder I want it in and open it in Calc. The
> > file opens in a browser tab, and I cut and paste the data into Calc.
> > Notice the different colors used.
> >
> >
> >
> > I wonder why the colors are there in the first place instead of the
> > expected black.  The negative numbers being in red is good accounting
> > practice.  Look at what happens when I copy them into Calc.  Once 
> > again
> > I get a shift in colors and the negative numbers are not in red and
> > cannot be changed using cell format.  Is the problem in GnuCash or in 
> > Calc?
>
> ___
> 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.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[Adrien Monteleone]

I'm not certain what you are describing, but I'll hazard a guess that 
you are seeing GnuCash auto-balance the transaction. That is normal. 
Every transaction has to be balanced. (Debits *must* equal Credits)


You are free to enter the transaction however you like, as long as that 
holds true. If your self-entered amounts do not result in equal Debits & 
Credits, GnuCash will create a split initially not assigned to any 
account, but when you commit the transaction and that split remains, it 
will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a 
currency code) for the difference.


Please read the GnuCash Help Manual and the Tutorial & Concepts Guide 
available in the Help Menu, or online, as you are learning the software. 
Then if you get stuck, come back and ask for help here.


Regards,
Adrien

On 3/9/24 8:18 PM, W. Neal Lewis wrote:

When I do the View > Transaction and put in individual numbers for each item in 
the Withdrawal column, it starts to mess with my figures. It puts in a number at 
the very top. It adds deposits to other entries. What I end up with is a mish-mash 
of costs that the program seems to think that I need for some mythical number it 
has come up with.

That's exactly what happened previously. I don't want it adding numbers, or 
changing numbers. I just want to put in the correct values for each line, 
including tax, hit return and have the final value show up on the first line of 
the transaction.

I obviously don't know what I am doing.

Help!
Neal



___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[Adrien Monteleone]

Neal,

You are welcome.

But please remember to hit 'reply-all' or 'reply-list' rather than just 
'reply' so everyone on the list benefits and can participate in this 
discussion.


Individual users may not always be able to help fully with any issue or 
question, others may have better answers or interesting suggestions.


Regards,
Adrien

On 3/9/24 7:10 PM, W. Neal Lewis wrote:

Thank you Adrien,

I will see what I can do with your suggestions.

And yes, I do need a high level of detail.

Thank you again for your reply.

Best regards,
Neal



___
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] trying to use good gnucash billing in personal books

[David Cousens]

Tim

It is usually good practice to keep your personal accounts and business
accounts separate and that usually involves having a separate bank
account for business transactions. There is sometimes a grey area when
you are setting up a business.

Where you pay bills, which are bills of the business, from your peronal
account it would be a normal practice to record these in your business
accounts as contributions by the owner to the equity of the business 
and preferrable to transfer the money to the business account before
paying the bill, which could be recorded as follows:

Asset:Business Bank AccountDr
Equity:Owner's Contributions   Cr

and you could record them in your personal accounts as

Asset:Personal Bank account   Cr
Expense:Contributions to Business Dr

The bill payemnt would then be recorded in the business accounts
as

Asset:Business Bank Account   Cr 
Expense:BusExpenseAccount Dr 

This leaves a clear trail in your personal and business accounts of the
nature of the transactions and is more likely to keep the tax man
happier should he ever decide to audit your business.

If you are in the position of using your personal account for business
purpose using the above pattern of transactions with your Personal Bank
account substituted for the Business bank account in the above should
provide a clearer paper trail should the tax man ever examine your
books.

Details will of course be highly dependent on the taxation and business
legislation in your jurisdiction and the above should not be considered
as accounting advice relevant to your particular situation, but just as
a general methodology for the treatment. Consult an accountant in your
jurisdiction for relevant advice

David Cousens
 

On Sat, 2024-03-09 at 15:10 -0800, Tim via gnucash-user wrote:
> I started down the path of setting up accounts payable to hold the
> bills that my sole proprietorship sends to me which I then pay. I
> created a first bill, assigning the line items to various expense
> accounts in my personal books, which is where I want those line items
> to be allocated. I'm apparently running into a problem where GNU cash
> insists on having the complete business system set up before you can
> use any part of it. And then it seems to be set up assuming that the
> business accounts are all for the business and are completely
> separate from my personal accounts. I tried to put liabilities and
> accounts payable under my personal equity account and then tried to
> post my first bill to accounts payable but the gnucash wouldn't let
> me do that. It wouldn't let me choose any existing account it wanted
> me to create a new one. When I created a new account under accounts
> payable then the account type field was unavailable. I was not able
> to select any account type for the accounts payable subaccount. So
> I'm apparently trying to pervert the design that was intended by the
> authors of good gnucash.
> 
>  
> 
> My first dumb question as if I set up a separate set of books for my
> business to hold the accounts receivable for the business which will
> consist of its bills to me, that I don't see how I can assign the
> line items in that bill to accounts in my personal books which was
> the whole point of the exercise from my point of view.
> 
>  
> 
> I was hoping there was a way I could set up accounts payable that
> would hold bills inside my personal books with line items that
> referred to expense accounts in my personal books. Is there a way to
> do that and I'm I just not seeing it?
> 
>  
> 
> Tim
> 
>  
> 
> From: timothyscu...@yahoo.com  
> Sent: Tuesday, March 5, 2024 6:52 AM
> To: 'Alan Johnson' ; 'David Carlson'
> 
> Cc: 'gnucash-user' 
> Subject: RE: [GNC] split transaction description field length limit
> 
>  
> 
> Yes that's why I set up a sole proprietorship with employer ID so I
> can pay all the payroll taxes, deduct income tax and pay it to the
> government, pay unemployment, Worker's Comp. insurance etc. I agree
> with you that it's very important to do those things properly.
> 
>  
> 
> I'm using gnucash mostly for my personal books as opposed to the sole
> proprietorship books which are so simple that we’re doing them in a
> spreadsheet right now with the exception of the payroll software we
> use to try to make sure we get all the deductions right.
> 
>  
> 
> My sole proprietorship invoices me for the fully burdened cost of
> each month’s payroll and I reimburse it fully from my personal bank
> account into the sole proprietorship bank account. It sounds as
> though my solution will be to set up AR for my sole proprietorship
> and enter all of the line items into an invoice to myself personally.
> Up until now I'd been using a simple paper invoice.
> 
>  
> 
> Thank you so much for the suggestion.
> 
>  
> 
> Tim
> 
>  
> 
> From: Alan Johnson mailto:a...@argentwolf.org>
> > 
> Sent: Monday, March 4, 2024 11:01 AM
> To: 

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[Adrien Monteleone]

You can certainly do so. The exact work flow can vary depending on your 
precise needs.


I don't often have very long transactions (30 or more items) but it does 
happen a few times a year. I frequently have transactions with at least 
5 or so 'splits'.


I'd recommend experimenting with either View > Transaction Journal (my 
preference) or View > Auto Split. That way, if most of your transactions 
need to show individual line item info, you can see it when you enter 
the transaction (Auto Split) or always see that level of detail for all 
transactions. (Transaction Journal) The default view will be least 
helpful to you.


You will not likely be able to easily auto-add tax per line, but can 
certainly put in tax lines manually. (such as one line for food, one for 
medicine, etc.) GnuCash can help with the math here. I put the rate and 
amount in the memo section and then type in the formula in the debit 
column. (e.g., $15.99 * .0845) GnuCash will replace your formula with 
the result showing what the calculated tax amounts to.


Another (but a bit more complicated) option is to put all such 
transactions into 'Vendor Bills' which can do taxes per line, exclusive 
or inclusive of price. But this requires much more careful setup and may 
or may not work for your particular situation.


Most importantly, if you need reporting at all on this detail, it has to 
be entered somehow into GnuCash. Do not just aggregate and enter the 
result. (don't consolidate line items. Enter each one separately as its 
own split, but do enter them in the same transaction if that is how they 
occurred.)


Regards,
Adrien

On 3/9/24 5:40 PM, W. Neal Lewis wrote:
I would like to use Gnucash to keep track of the costs and information 
of each of the things that I buy from a merchant, such as Kroger, Home 
Depot, etc.


There can be 30 to more items on one transaction.

The items can be for different uses, such as food, lumber, computers, etc.

There can be multiple tax rates, depending on the separate tax rates for 
food, prescriptions, hardware, etc.


This information is needed for use at tax time, since I have a small 
business and need to break things out accordingly.


Is Gnucash the right program to use for these needs?


___
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

[Adrien Monteleone]

Why not create a transaction for the appropriate year between tax 
expense and tax payable?


Dr. Expenses:FederalTax
  Cr. Liabilities:FederalTaxPayable

Then when you actually pay,

Dr. Liabilities:FederalTaxPayable
  Cr. Checking (or whatever source account)

That way, the expense shows up for the year of the first transaction, 
the payment for the year of the second. Both are correct and in their 
respective accounting periods.


Regards,
Adrien

On 3/8/24 3: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] trying to use good gnucash billing in personal books

[Adrien Monteleone]

Liabilities and Accounts Payable are not Equity type accounts so they 
don't belong there. They both are of type 'Liability' generally and 
belong in that part of the tree, but specifically, the Accounts Payable 
account is the special type 'Accounts Payable' in the GnuCash Edit 
Account dialog.


Fix that, try again, and then get back to us if you still have issues.

If your business passes through taxes to you personally, then you most 
likely only need one set of books (one book file in GnuCash) but that 
answer really depends on the requirements of your local jurisdiction. 
You'd need official professional advice on that point, and this is not 
it, and neither is this the forum for it. But we can help with 'how to 
do it' once you know what it is you are required/allowed to do.


Regards,
Adrien

On 3/9/24 5:10 PM, Tim via gnucash-user wrote:

I started down the path of setting up accounts payable to hold the bills that 
my sole proprietorship sends to me which I then pay. I created a first bill, 
assigning the line items to various expense accounts in my personal books, 
which is where I want those line items to be allocated. I'm apparently running 
into a problem where GNU cash insists on having the complete business system 
set up before you can use any part of it. And then it seems to be set up 
assuming that the business accounts are all for the business and are completely 
separate from my personal accounts. I tried to put liabilities and accounts 
payable under my personal equity account and then tried to post my first bill 
to accounts payable but the gnucash wouldn't let me do that. It wouldn't let me 
choose any existing account it wanted me to create a new one. When I created a 
new account under accounts payable then the account type field was unavailable. 
I was not able to select any account type for the accounts payab
le subaccount. So I'm apparently trying to pervert the design that was intended by the authors of good gnucash.   


My first dumb question as if I set up a separate set of books for my business 
to hold the accounts receivable for the business which will consist of its 
bills to me, that I don't see how I can assign the line items in that bill to 
accounts in my personal books which was the whole point of the exercise from my 
point of view.

I was hoping there was a way I could set up accounts payable that would hold 
bills inside my personal books with line items that referred to expense 
accounts in my personal books. Is there a way to do that and I'm I just not 
seeing 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[Adrien Monteleone]

1. Export Report
2. Open Calc
3. Open the report file in Calc. Result is the report imported into 
cells based on the html table.


or

1. Export Report
2. Open Calc
3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the 
exported report file. Answer the dialogs, result is same as above.


or

1. Run Report in GnuCash
2. Select All
3. Copy
4. Open Calc
5. Paste, result is same as above

In none of these cases is a web browser involved. (save for the Webkit 
rendering within GnuCash, if you want to be pedantic about browser engines)


I just tried all three, and in each case, there is no change in font or 
alignments.


Perhaps your issues involve whatever intermediary (browser) you are 
involving that is unnecessary.


Regards,
Adrien

On 3/9/24 10:41 AM, Abe Sternberg wrote:
I guess I am a bit dense - old age will do that to you.  Let me try and 
be a bit more specific on my actions and the errors I get. Below is a 
screenshot of a budget performance report in GnuCash.




Next, I export it to the folder I want it in and open it in Calc. The 
file opens in a browser tab, and I cut and paste the data into Calc. 
Notice the different colors used.




I wonder why the colors are there in the first place instead of the 
expected black.  The negative numbers being in red is good accounting 
practice.  Look at what happens when I copy them into Calc.  Once again 
I get a shift in colors and the negative numbers are not in red and 
cannot be changed using cell format.  Is the problem in GnuCash or in Calc?


___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[W. Neal Lewis]

I would like to use Gnucash to keep track of the costs and information 
of each of the things that I buy from a merchant, such as Kroger, Home 
Depot, etc.


There can be 30 to more items on one transaction.

The items can be for different uses, such as food, lumber, computers, etc.

There can be multiple tax rates, depending on the separate tax rates for 
food, prescriptions, hardware, etc.


This information is needed for use at tax time, since I have a small 
business and need to break things out accordingly.


Is Gnucash the right program to use for these needs?

Thanks.
wnlewis
___
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] trying to use good gnucash billing in personal books

[Tim via gnucash-user]

I started down the path of setting up accounts payable to hold the bills that 
my sole proprietorship sends to me which I then pay. I created a first bill, 
assigning the line items to various expense accounts in my personal books, 
which is where I want those line items to be allocated. I'm apparently running 
into a problem where GNU cash insists on having the complete business system 
set up before you can use any part of it. And then it seems to be set up 
assuming that the business accounts are all for the business and are completely 
separate from my personal accounts. I tried to put liabilities and accounts 
payable under my personal equity account and then tried to post my first bill 
to accounts payable but the gnucash wouldn't let me do that. It wouldn't let me 
choose any existing account it wanted me to create a new one. When I created a 
new account under accounts payable then the account type field was unavailable. 
I was not able to select any account type for the accounts payable subaccount. 
So I'm apparently trying to pervert the design that was intended by the authors 
of good gnucash.

 

My first dumb question as if I set up a separate set of books for my business 
to hold the accounts receivable for the business which will consist of its 
bills to me, that I don't see how I can assign the line items in that bill to 
accounts in my personal books which was the whole point of the exercise from my 
point of view.

 

I was hoping there was a way I could set up accounts payable that would hold 
bills inside my personal books with line items that referred to expense 
accounts in my personal books. Is there a way to do that and I'm I just not 
seeing it?

 

Tim

 

From: timothyscu...@yahoo.com  
Sent: Tuesday, March 5, 2024 6:52 AM
To: 'Alan Johnson' ; 'David Carlson' 

Cc: 'gnucash-user' 
Subject: RE: [GNC] split transaction description field length limit

 

Yes that's why I set up a sole proprietorship with employer ID so I can pay all 
the payroll taxes, deduct income tax and pay it to the government, pay 
unemployment, Worker's Comp. insurance etc. I agree with you that it's very 
important to do those things properly.

 

I'm using gnucash mostly for my personal books as opposed to the sole 
proprietorship books which are so simple that we’re doing them in a spreadsheet 
right now with the exception of the payroll software we use to try to make sure 
we get all the deductions right.

 

My sole proprietorship invoices me for the fully burdened cost of each month’s 
payroll and I reimburse it fully from my personal bank account into the sole 
proprietorship bank account. It sounds as though my solution will be to set up 
AR for my sole proprietorship and enter all of the line items into an invoice 
to myself personally. Up until now I'd been using a simple paper invoice.

 

Thank you so much for the suggestion.

 

Tim

 

From: Alan Johnson mailto:a...@argentwolf.org> > 
Sent: Monday, March 4, 2024 11:01 AM
To: timothyscu...@yahoo.com  ; 'David Carlson' 
mailto:david.carlson@gmail.com> >
Cc: 'gnucash-user' mailto:gnucash-u...@lists.gnucash.org> >
Subject: Re: [GNC] split transaction description field length limit

 

I use GNUCash for tracking rental properties as well. You can create as many 
expense accounts to track to whatever level of detail is needed.

 

For example, I have my structure set up as:

Expenses:

Overall R

-Property 1 R

--Property 1 HVAC

--Property1 General

--Property 1 Electrical

--etc

 

-Property 2 R

--Property 2 HVAC

--Property 2 General

--Property 2 Electrical

--etc

 

When you run a P at the end of the year, it will break out how much was in 
each expense category, as well as a total for each property. 

 

Not a CPA or legal advice, but I understand that if you are paying payroll to 
employees, you still need to pay payroll tax unless they are their own 
business/1099, in which they should be paying their taxes accordingly.  

 

You can assign as many line items and expense accounts/line items to the 
invoices as you need. That's their intended function.  You can also pay line 
items into an asset or liability account (such as witheld taxes).  

 

Your handyman should provide you with a bill (or a work order).  

 

- Fixed property 1's toilet. 1 hr@ $x

 

You create a vendor in the vendor system (Handyman LLC)

Create an invoice 

Line item - Toilet repair $x Account: Expenses:Property1 R:Property1 Plumbing

Line Item - Outlet repair $y Account: Expenses:Property1 R:Property1 
Electrical

Line Item - Door knob repair $z Account: Expenses: Property2 R: 
Property2:General

Total $A

- Post invoice

 

Vendors -> Process Payment

 

Pay Handyman LLC $A from Assets:RentalCheckingAccount with check 1234 

 

 

On Mon, 2024-03-04 at 09:46 -0800, timothyscu...@yahoo.com 
  wrote:

I greatly appreciate your suggestions.

 

I don't think I framed the problem completely. I have 

Re: [GNC] Importing Reports into LO Calc

[Abe Sternberg]

Thanks.  It may be best if I start this thread again.  I sincerely 
appreciate your taking the time to get me knowledgeable.


Abe

On 3/9/2024 15:35, David H wrote:

Abe,

You can't include/paste pictures inline on the Gnucash mailing list so 
they didn't show up :-(  You have to either save each pic as a file 
and attach them to your email or I've found that you can get away with 
pasting 1 pic as the very last thing in your email and it makes it.


Cheers David H.


On Sun, 10 Mar 2024 at 02:42, Abe Sternberg 
 wrote:


I guess I am a bit dense - old age will do that to you.  Let me
try and
be a bit more specific on my actions and the errors I get. Below is a
screenshot of a budget performance report in GnuCash.



Next, I export it to the folder I want it in and open it in Calc. The
file opens in a browser tab, and I cut and paste the data into Calc.
Notice the different colors used.



I wonder why the colors are there in the first place instead of the
expected black.  The negative numbers being in red is good accounting
practice.  Look at what happens when I copy them into Calc. Once
again
I get a shift in colors and the negative numbers are not in red and
cannot be changed using cell format.  Is the problem in GnuCash or
in Calc?



Thanks for your help.

Abe



On 3/8/2024 21:47, Adrien Monteleone wrote:
> Abe, next time, please start a new thread by sending a new
message to
> the list rather than replying to someone else's.
>
> As for how to get reports into Calc, I usually copy/paste, but
you can
> also just 'open' the exported report, or you can 'insert sheet from
> file' into an existing workbook. (again, choosing the exported
report)
> When exporting, it probably wouldn't hurt to use an .html filename
> extension.
>
> I have in a few reports seen some alignment issues, but that was
due
> to special padding used by that particular report rather than a
> cleaner HTML. I think I filed a bug on it.
>
> Otherwise, I've had no issues bringing them into Calc.
>
> Regards,
> Adrien
>
> On 3/8/24 1:45 PM, Abe Sternberg wrote:
>> After a long hiatus from GnuCash and preparing reports, I find
that I
>> am back in that business.  The good news is that I am good to
go on
>> getting my reports structured the way I want. The bad news is that
>> now I can't figure out how to import the HTML report into Calc.  I
>> have tried everything I can think of, including cutting and
pasting.
>>
>> The error is that some fields are imported in a different colored
>> font, this seems to be limited to numeric fields.  I have another
>> situation where totals in a table do not cross-foot - they are not
>> equal when adding row totals across and column totals going down.
>>
>> I had this correct, but have forgotten what to do.
>
> ___
> 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.


___
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] Bill total does not match real total

[Carl Linkletter via gnucash-user]

Thanks for all that Michael.  So the summary is, why would I think that one 
system could possibly handle all the regulations that incompetent and 
narcissistic bureaucrats could come up with?What was I thinking??? :-)




Peter Carl Linkletter
VMware Consultant and VMware Certified Instructor

Pair-a-Links Consulting Inc.
Swift Current, Saskatchewan, Canada
Email: pairali...@protonmail.com
Phone: 306-315-3926
Linked-in: https://www.linkedin.com/in/plinkletter/

Sent with Proton Mail secure email.

On Saturday, March 9th, 2024 at 2:58 PM, Michael or Penny Novack 
 wrote:

> On 3/9/2024 1:34 PM, R Losey wrote:
> 
> > Regarding below, perhaps Amazon does it that way because some states
> > (locations) exempt certain items from sales tax: Wisconsin, for example,
> > used to not tax food. In Texas also, food is not taxed.
> 
> And Massachusetts does not tax food or clothing. The necessary
> assumption is that every taxing authority is different. Nor do they
> handle "rounding" the same way (in some states always "rounding" UP
> fractions of a cent). This sort of thing is NOT normally handled by the
> "general ledger" system. That's what a POS (point of sales) system is
> for, although that system would also normally feed inventory as well as
> "general ledger".
> 
> You are asking way too much of gnucash. It's more than a sales tax rate
> for each state (and city or other jurisdiction that charges a sales
> tax). It is for each how rounding is to be performed, what the sales tax
> does or does not apply to, etc.
> 
> To go back to my own state of MA and clothing. That is NOT all clothing.
> Articles of clothing costing less than a certain amount are exempt from
> sales tax (*I think that's $175). But "clothing" considered for athletic
> use is not exempt, nor is protective clothing. That means WHERE BOUGHT
> can matter. Buy sneakers at the department store, exempt, but at the
> sports shop, taxed. Buy gloves at the department store, exempt, but at
> the hardware store, taxed.
> 
> You expect gnucash to be ale to handle that sort of detail.
> 
> Michael D Novack
> 
> * Understand? Buy two pairs of X shoes costing $100 each and the line
> would be "X shoes $200 no tax charged but buy one pair of Y shoes
> costing $200, the line would be "Y shoes $200 sales tax $13.50
> 
> 
> ___
> 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] Importing Reports into LO Calc

[David Cousens]

Abe,

The default colors which come up in Calc are going to depend upon its
preference settings and any formatting already set in Calc before
importing. GnuCash has no control over that.

Cal's cell "currency" setting has the option of negative numbers
appearing in red. If you format all cells containing numerical currency
data to "Currency" this will work. ALl that is imported into Calc is
the data , not any formatting

The benefit of importing to Calc is that youthen have complete control
over how it is formatted within the constraints of Calc's formatting
capabilities but that comes at the cost of having to manually set that
formatting.

AFAIK it should be possible to create a formatted template in Calc so
that you can import the data into the template and have it appear as
you desire.

On Sat, 2024-03-09 at 11:41 -0500, Abe Sternberg wrote:
> I guess I am a bit dense - old age will do that to you.  Let me try
> and 
> be a bit more specific on my actions and the errors I get. Below is a
> screenshot of a budget performance report in GnuCash.
> 
> 
> 
> Next, I export it to the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc. 
> Notice the different colors used.
> 
> 
> 
> I wonder why the colors are there in the first place instead of the 
> expected black.  The negative numbers being in red is good accounting
> practice.  Look at what happens when I copy them into Calc.  Once
> again 
> I get a shift in colors and the negative numbers are not in red and 
> cannot be changed using cell format.  Is the problem in GnuCash or in
> Calc?
> 
> 
> 
> Thanks for your help.
> 
> Abe
> 
> 
> 
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > Abe, next time, please start a new thread by sending a new message
> > to 
> > the list rather than replying to someone else's.
> > 
> > As for how to get reports into Calc, I usually copy/paste, but you
> > can 
> > also just 'open' the exported report, or you can 'insert sheet from
> > file' into an existing workbook. (again, choosing the exported
> > report) 
> > When exporting, it probably wouldn't hurt to use an .html filename 
> > extension.
> > 
> > I have in a few reports seen some alignment issues, but that was
> > due 
> > to special padding used by that particular report rather than a 
> > cleaner HTML. I think I filed a bug on it.
> > 
> > Otherwise, I've had no issues bringing them into Calc.
> > 
> > Regards,
> > Adrien
> > 
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> > > After a long hiatus from GnuCash and preparing reports, I find
> > > that I 
> > > am back in that business.  The good news is that I am good to go
> > > on 
> > > getting my reports structured the way I want. The bad news is
> > > that 
> > > now I can't figure out how to import the HTML report into Calc. 
> > > I 
> > > have tried everything I can think of, including cutting and
> > > pasting.
> > > 
> > > The error is that some fields are imported in a different colored
> > > font, this seems to be limited to numeric fields.  I have another
> > > situation where totals in a table do not cross-foot - they are
> > > not 
> > > equal when adding row totals across and column totals going down.
> > > 
> > > I had this correct, but have forgotten what to do.
> > 
> > ___
> > 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.

___
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] Bill total does not match real total

[Michael or Penny Novack]

On 3/9/2024 1:34 PM, R Losey wrote:

Regarding below, perhaps Amazon does it that way because some states
(locations) exempt certain items from sales tax: Wisconsin, for example,
used to not tax food. In Texas also, food is not taxed.

And Massachusetts does not tax food or clothing. The necessary 
assumption is that every taxing authority is different. Nor do they 
handle "rounding" the same way (in some states always "rounding" UP 
fractions of a cent). This sort of thing is NOT normally handled by the 
"general ledger" system. That's what a POS (point of sales) system is 
for, although that system would also normally feed inventory as well as 
"general ledger".


You are asking way too much of gnucash. It's more than a sales tax rate 
for each state (and city or other jurisdiction that charges a sales 
tax). It is for each how rounding is to be performed, what the sales tax 
does or does not apply to, etc.


To go back to my own state of MA and clothing. That is NOT all clothing. 
Articles of clothing costing less than a certain amount are exempt from 
sales tax (*I think that's $175). But "clothing" considered for athletic 
use is not exempt, nor is protective clothing. That means WHERE BOUGHT 
can matter. Buy sneakers at the department store, exempt, but at the 
sports shop, taxed. Buy gloves at the department store, exempt, but at 
the hardware store, taxed.


You expect gnucash to be ale to handle that sort of detail.

Michael D Novack

* Understand? Buy two pairs of  X shoes costing $100 each and the line 
would be "X shoes  $200   no tax charged but buy one pair of Y shoes 
costing $200, the line would be "Y shoes  $200  sales tax $13.50



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

Re: [GNC] gnucash-user Digest, Vol 252, Issue 21

[David H]

Cool, glad you got it sorted.

Cheers David H.


On Sun, 10 Mar 2024 at 03:09, Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> David/john:
>
> Thanks for the helpful replies. After you mentioned it, I remembered the
> auto-history version save of my NAS-based cloud drive. Upon checking in
> there, I found two versions which had saved within two seconds of each
> other at the time I attempted to switch books. The second one, which
> Windows saw, was the corrupted file but the two-seconds-earlier version
> was uncorrupted and loaded properly. I flushed the corrupted version and
> now I'm back in business. Thanks againEric.
>
> On 3/9/2024 9:25 AM, gnucash-user-requ...@gnucash.org wrote:
> > Send gnucash-user mailing list submissions to
> >   gnucash-user@gnucash.org
> >
> >
> > --
> >
> > Message: 1
> > Date: Sat, 9 Mar 2024 07:43:24 +1000
> > From: David H 
> > To: "Eric H. Bowen" 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
> >   (Bug 645216)
> > Message-ID:
> >   <
> ca+5xqdq5tyik_yhk-b3qpgdrxzk-woclq9mvj-s9p5qgyvk...@mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Eric,
> >
> > Are you sure you haven't got a more recent backup?  I have multiple
> backups
> > (currently 77 - e.g. .gnucash.20240208183810.gnucash)
> in
> > the folder where my usual gnucash data file lives from the last time I
> > opened it - you should be able to open the one with the most recent date
> > and time stamp in the name and then save as you LLC file proper. .  It
> > seems you are opening this file directly in the cloud - I've never been a
> > fan of that ? I always copy my file to my local pc (1 of about 5 running
> > Win10/11, Ubuntu, MacOS) using FreeFileSync before I open it and then
> copy
> > it back when I'm done which works well for me.  Hope you can get it
> sorted.
> >
> > Cheers David H.
> >
> >
> > On Fri, 8 Mar 2024 at 23:59, Eric H. Bowen via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> >> I use two separate GnuCash books, one for my personal funds and another
> >> for my LLC. These files are saved on a cloud drive and I access them
> >> from a few different computers. Some of the computers run Windows 10,
> >> while some run Ubuntu Studio 22.04 LTS. The computer on which this first
> >> happened was running Windows 10 and GnuCash 5.4+ with sqlite backend,
> >> but all computers are now responding the same way.
> >>
> >> The day before yesterday I was updating and making some entries in the
> >> book for my LLC; GnuCash was working normally. Then, with the work
> >> completed, I attempted to switch from the LLC book to my personal book.
> >> However, apparently the file was still open on a remote computer because
> >> I received the error message that the .lock file could not be received.
> >> I elected to close the file and exit GnuCash. Well and good. When I got
> >> home that evening I closed the open instance of GnuCash running the
> >> personal book. Well and good.
> >>
> >> This morning I reopened the personal book and it opened and operated
> >> normally. Okay so far. Then, I closed it and attempted to open the book
> >> for the LLC. It would not open; I got a pop-up error message reading,
> >> "GnuCash could not complete a critical test for the presence of a bug in
> >> the "libdi" library. This may be caused by a permissions
> >> misconfiguration of your SQL database. Please see
> >> https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information."
> >>
> >> I went to the bug tracker website, found the entry, and attempted to
> >> follow the procedure which others said worked for them, of making a copy
> >> of the GnuCash file and opening/closing it. However, the copied file(s)
> >> were also corrupt and would not open. I do have a backup, but it's a few
> >> weeks old and I'd have to reconstruct the invoices and bills since then.
> >> Not a major undertaking, but if possible I'd like to recover this file.
> >> The personal book, by the way, continues to work perfectly. Thanks for
> >> any assistanceEric.
> >>
> >>
> >> ___
> >> 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.
> >>
> >
> > --
> >
> > Message: 9
> > Date: Sat, 9 Mar 2024 16:17:45 +0100
> > From: john 
> > To: David H 
> > Cc: "Eric H. Bowen" , gnucash-user@gnucash.org
> > Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
> >   (Bug 645216)
> > Message-ID: 
> > Content-Type: text/plain; charset=us-ascii
> >
> > Are you using the SQLite3 backend? If so and it's really corrupted see
> 

Re: [GNC] Importing Reports into LO Calc

[David H]

Abe,

You can't include/paste pictures inline on the Gnucash mailing list so they
didn't show up :-(  You have to either save each pic as a file and attach
them to your email or I've found that you can get away with pasting 1 pic
as the very last thing in your email and it makes it.

Cheers David H.


On Sun, 10 Mar 2024 at 02:42, Abe Sternberg 
wrote:

> I guess I am a bit dense - old age will do that to you.  Let me try and
> be a bit more specific on my actions and the errors I get. Below is a
> screenshot of a budget performance report in GnuCash.
>
>
>
> Next, I export it to the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc.
> Notice the different colors used.
>
>
>
> I wonder why the colors are there in the first place instead of the
> expected black.  The negative numbers being in red is good accounting
> practice.  Look at what happens when I copy them into Calc.  Once again
> I get a shift in colors and the negative numbers are not in red and
> cannot be changed using cell format.  Is the problem in GnuCash or in Calc?
>
>
>
> Thanks for your help.
>
> Abe
>
>
>
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > Abe, next time, please start a new thread by sending a new message to
> > the list rather than replying to someone else's.
> >
> > As for how to get reports into Calc, I usually copy/paste, but you can
> > also just 'open' the exported report, or you can 'insert sheet from
> > file' into an existing workbook. (again, choosing the exported report)
> > When exporting, it probably wouldn't hurt to use an .html filename
> > extension.
> >
> > I have in a few reports seen some alignment issues, but that was due
> > to special padding used by that particular report rather than a
> > cleaner HTML. I think I filed a bug on it.
> >
> > Otherwise, I've had no issues bringing them into Calc.
> >
> > Regards,
> > Adrien
> >
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> >> After a long hiatus from GnuCash and preparing reports, I find that I
> >> am back in that business.  The good news is that I am good to go on
> >> getting my reports structured the way I want. The bad news is that
> >> now I can't figure out how to import the HTML report into Calc.  I
> >> have tried everything I can think of, including cutting and pasting.
> >>
> >> The error is that some fields are imported in a different colored
> >> font, this seems to be limited to numeric fields.  I have another
> >> situation where totals in a table do not cross-foot - they are not
> >> equal when adding row totals across and column totals going down.
> >>
> >> I had this correct, but have forgotten what to do.
> >
> > ___
> > 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.
>
___
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] Maddening!!!!!!!!

[Jack Slater]

Thanks John!

On Sat, Mar 9, 2024 at 9:25 AM john  wrote:

> No, that's a re-bundling of GnuCash 5.5 for Windows with a rebuilt
> WebKitGtk so that it doesn't crash when you try to run a business or chart
> report. There are no changes to GnuCash itself.
>
> The fix for the left-over splits from editing an auto-completed
> transaction will be in GnuCash 5.6. Flatpak and Windows users can get it
> from a nightly build, otherwise you have to wait a few weeks.
>
> But we now know that it's caused by a dangling pointer in the account's
> split list from a second run of autocomplete. You can safely ignore
> it--meaning don't check it when reconciling--and it will go away when you
> end the session.
>
> Regards,
> John Ralls
>
> > On Mar 9, 2024, at 02:00, Jack Slater  wrote:
> >
> > Oh ok. Happy to. I guess I was expecting a 5.51 or something to
> > differentiate the releases.
> >
> > On Fri, Mar 8, 2024 at 4:09 PM David H  wrote:
> >
> >> Jack,
> >>
> >> John Ralls released an updated version of 5.5 on 21 Feb -
> >>
> https://lists.gnucash.org/pipermail/gnucash-user/2024-February/110886.html
> >> - I assume if you re-download the Windows version at Gncash.org you will
> >> pick it up ?
> >>
> >> Cheers David H.
> >>
> >> On Sat, 9 Mar 2024 at 04:57, Jack Slater 
> wrote:
> >>
> >>> Revisiting the bug log (after another rogue transaction and crash
> today)
> >>> and I see John's notes about fixing but I'm guessing it's not in 5.5?
> >>> That's what I'm running and all I see on the web site.
> >>>
> >>> On Thu, Feb 8, 2024 at 11:12 AM Patrick James <
> patrickjame...@comcast.net
> 
> >>> wrote:
> >>>
>  Save, Exit, and Reload will clear the rouge transactions.
> 
> 
> > On 02/08/2024 8:54 AM PST Jack Slater 
> wrote:
> >
> >
> > Anything coming soon to fix this?
> >
> > On Thu, Jan 25, 2024 at 12:26 PM Patrick James <
>  patrickjame...@comcast.net mailto:patrickjame...@comcast.net> wrote:
> >
> >> This is bug 799093, and John Ralls has not asked additional
> >>> questions
>  after I was able to reliably reproduce (part of) the issue, so,
> >>> hopefully,
>  there is sufficient information to find the bug.
> >>
> >> https://bugs.gnucash.org/show_bug.cgi?id=799093
> >>
> >> s 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.
> 
> >>> ___
> >>> 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.
>
>
___
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

[David G. Pickett via gnucash-user]

 Subfolders is a good alternative, better for reports over multiple years but 
more maintenance creating and destroying folders.

If GNUCash wanted, they might make a magic subcategory /Prior to qualify the 
date's year to year - 1, but that seems very tricky to code into every date 
filter.

Automatic subfolder creation (and when empty deletion?) by year as an attribute 
of the parent folder might work better, and support many such categories.
On Saturday, March 9, 2024 at 01:43:41 PM EST, R Losey  
wrote:  
 
 I like the idea -- I usually just "remember" that the Jan payment is for the 
previous year. But if you're going to make sub-accounts under taxes, why not 
use actual years? Taxes/Federal/2023 and Taxes/Federal/2024. Once a year is 
done with, you can easily hide the account so that it doesn't show up in your 
list of accounts.

On Fri, Mar 8, 2024 at 3:55 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.



-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8  
___
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

[R Losey]

I like the idea -- I usually just "remember" that the Jan payment is for
the previous year. But if you're going to make sub-accounts under taxes,
why not use actual years? Taxes/Federal/2023 and Taxes/Federal/2024. Once a
year is done with, you can easily hide the account so that it doesn't show
up in your list of accounts.


On Fri, Mar 8, 2024 at 3:55 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Bill total does not match real total

[R Losey]

Regarding below, perhaps Amazon does it that way because some states
(locations) exempt certain items from sales tax: Wisconsin, for example,
used to not tax food. In Texas also, food is not taxed.


On Fri, Mar 8, 2024 at 11:56 AM Stan Brown (using GC 4.14) <
stan...@fastmail.fm> wrote:

>
>
> On 2024-03-08 08:27, Alan Johnson wrote:
>
> I've no idea why Amazon chose the individual item method when its
> invoice shows only a total tax amount, but it looks like that's what
> happened. In this case, it actually saved you a penny. In any case, it
> looks like Amazon is within the law of your state.
>
> _
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Error Retrieving Gold Price for Price Database

[Fred Bone]

On 09 March 2024 at 16:35, john said:

> XAU is a currency because ISO 4217 says it is, along with XBA (silver),

Precious metals are coded as X followed by the relevant chemical symbol, 
so silver is XAG


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

Re: [GNC] gnucash-user Digest, Vol 252, Issue 21

[Eric H. Bowen via gnucash-user]

David/john:

Thanks for the helpful replies. After you mentioned it, I remembered the 
auto-history version save of my NAS-based cloud drive. Upon checking in 
there, I found two versions which had saved within two seconds of each 
other at the time I attempted to switch books. The second one, which 
Windows saw, was the corrupted file but the two-seconds-earlier version 
was uncorrupted and loaded properly. I flushed the corrupted version and 
now I'm back in business. Thanks againEric.


On 3/9/2024 9:25 AM, gnucash-user-requ...@gnucash.org wrote:

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org


--

Message: 1
Date: Sat, 9 Mar 2024 07:43:24 +1000
From: David H 
To: "Eric H. Bowen" 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
(Bug 645216)
Message-ID:

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

Eric,

Are you sure you haven't got a more recent backup?  I have multiple backups
(currently 77 - e.g. .gnucash.20240208183810.gnucash) in
the folder where my usual gnucash data file lives from the last time I
opened it - you should be able to open the one with the most recent date
and time stamp in the name and then save as you LLC file proper. .  It
seems you are opening this file directly in the cloud - I've never been a
fan of that ? I always copy my file to my local pc (1 of about 5 running
Win10/11, Ubuntu, MacOS) using FreeFileSync before I open it and then copy
it back when I'm done which works well for me.  Hope you can get it sorted.

Cheers David H.


On Fri, 8 Mar 2024 at 23:59, Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:


I use two separate GnuCash books, one for my personal funds and another
for my LLC. These files are saved on a cloud drive and I access them
from a few different computers. Some of the computers run Windows 10,
while some run Ubuntu Studio 22.04 LTS. The computer on which this first
happened was running Windows 10 and GnuCash 5.4+ with sqlite backend,
but all computers are now responding the same way.

The day before yesterday I was updating and making some entries in the
book for my LLC; GnuCash was working normally. Then, with the work
completed, I attempted to switch from the LLC book to my personal book.
However, apparently the file was still open on a remote computer because
I received the error message that the .lock file could not be received.
I elected to close the file and exit GnuCash. Well and good. When I got
home that evening I closed the open instance of GnuCash running the
personal book. Well and good.

This morning I reopened the personal book and it opened and operated
normally. Okay so far. Then, I closed it and attempted to open the book
for the LLC. It would not open; I got a pop-up error message reading,
"GnuCash could not complete a critical test for the presence of a bug in
the "libdi" library. This may be caused by a permissions
misconfiguration of your SQL database. Please see
https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information."

I went to the bug tracker website, found the entry, and attempted to
follow the procedure which others said worked for them, of making a copy
of the GnuCash file and opening/closing it. However, the copied file(s)
were also corrupt and would not open. I do have a backup, but it's a few
weeks old and I'd have to reconstruct the invoices and bills since then.
Not a major undertaking, but if possible I'd like to recover this file.
The personal book, by the way, continues to work perfectly. Thanks for
any assistanceEric.


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



--

Message: 9
Date: Sat, 9 Mar 2024 16:17:45 +0100
From: john 
To: David H 
Cc: "Eric H. Bowen" , gnucash-user@gnucash.org
Subject: Re: [GNC] GnuCash Will Not Open Book After Changing Books
(Bug 645216)
Message-ID: 
Content-Type: text/plain;   charset=us-ascii

Are you using the SQLite3 backend? If so and it's really corrupted see 
https://www.sqlite.org/recovery.html. Good luck.

Regards,
John Ralls




On Mar 8, 2024, at 22:43, David H  wrote:

Eric,

Are you sure you haven't got a more recent backup?  I have multiple backups
(currently 77 - e.g. .gnucash.20240208183810.gnucash) in
the folder where my usual gnucash data file lives from the last time I
opened it - you should be able to open the one with the most recent date
and time stamp in the name and then save as you LLC file proper. .  It
seems you are opening this file directly in the cloud - I've never been a
fan of that ? I always copy my file to my local pc (1 of about 5 running

Re: [GNC] Importing Reports into LO Calc

[Robert Heller]

At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg  
wrote:

>
> I guess I am a bit dense - old age will do that to you.  Let me try and
> be a bit more specific on my actions and the errors I get. Below is a
> screenshot of a budget performance report in GnuCash.
>
>
>
> Next, I export it to the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc. 
> Notice the different colors used.
>
>
>
> I wonder why the colors are there in the first place instead of the
> expected black. The negative numbers being in red is good accounting
> practice. Look at what happens when I copy them into Calc. Once again
> I get a shift in colors and the negative numbers are not in red and
> cannot be changed using cell format. Is the problem in GnuCash or in Calc?

It is the spreadsheet program (calc).  Spreadsheet programs are not accounting
programs and don't know anything about "good accounting practice".  GnuCash is
an accounting program and does know all about "good accounting practice".

*I* don't know how to fix this.  What are you trying to do with the
spreadsheet program?

>
>
>
> Thanks for your help.
>
> Abe
>
>
>
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > Abe, next time, please start a new thread by sending a new message to
> > the list rather than replying to someone else's.
> >
> > As for how to get reports into Calc, I usually copy/paste, but you can
> > also just 'open' the exported report, or you can 'insert sheet from
> > file' into an existing workbook. (again, choosing the exported report)
> > When exporting, it probably wouldn't hurt to use an .html filename
> > extension.
> >
> > I have in a few reports seen some alignment issues, but that was due
> > to special padding used by that particular report rather than a
> > cleaner HTML. I think I filed a bug on it.
> >
> > Otherwise, I've had no issues bringing them into Calc.
> >
> > Regards,
> > Adrien
> >
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> >> After a long hiatus from GnuCash and preparing reports, I find that I
> >> am back in that business.  The good news is that I am good to go on
> >> getting my reports structured the way I want. The bad news is that
> >> now I can't figure out how to import the HTML report into Calc.  I
> >> have tried everything I can think of, including cutting and pasting.
> >>
> >> The error is that some fields are imported in a different colored
> >> font, this seems to be limited to numeric fields.  I have another
> >> situation where totals in a table do not cross-foot - they are not
> >> equal when adding row totals across and column totals going down.
> >>
> >> I had this correct, but have forgotten what to do.
> >
> > ___
> > 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.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
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] Importing Reports into LO Calc

[Abe Sternberg]

I guess I am a bit dense - old age will do that to you.  Let me try and 
be a bit more specific on my actions and the errors I get. Below is a 
screenshot of a budget performance report in GnuCash.




Next, I export it to the folder I want it in and open it in Calc. The 
file opens in a browser tab, and I cut and paste the data into Calc.  
Notice the different colors used.




I wonder why the colors are there in the first place instead of the 
expected black.  The negative numbers being in red is good accounting 
practice.  Look at what happens when I copy them into Calc.  Once again 
I get a shift in colors and the negative numbers are not in red and 
cannot be changed using cell format.  Is the problem in GnuCash or in Calc?




Thanks for your help.

Abe



On 3/8/2024 21:47, Adrien Monteleone wrote:
Abe, next time, please start a new thread by sending a new message to 
the list rather than replying to someone else's.


As for how to get reports into Calc, I usually copy/paste, but you can 
also just 'open' the exported report, or you can 'insert sheet from 
file' into an existing workbook. (again, choosing the exported report) 
When exporting, it probably wouldn't hurt to use an .html filename 
extension.


I have in a few reports seen some alignment issues, but that was due 
to special padding used by that particular report rather than a 
cleaner HTML. I think I filed a bug on it.


Otherwise, I've had no issues bringing them into Calc.

Regards,
Adrien

On 3/8/24 1:45 PM, Abe Sternberg wrote:
After a long hiatus from GnuCash and preparing reports, I find that I 
am back in that business.  The good news is that I am good to go on 
getting my reports structured the way I want. The bad news is that 
now I can't figure out how to import the HTML report into Calc.  I 
have tried everything I can think of, including cutting and pasting.


The error is that some fields are imported in a different colored 
font, this seems to be limited to numeric fields.  I have another 
situation where totals in a table do not cross-foot - they are not 
equal when adding row totals across and column totals going down.


I had this correct, but have forgotten what to do.


___
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] Error Retrieving Gold Price for Price Database

[john]

XAU is a currency because ISO 4217 says it is, along with XBA (silver), XPT 
(platinum), and XPD (Palladium). They're supposed to represent a troy ounce of 
the respective metal. Keep in mind that ISO-4217 is a banking industry 
specification and doesn't necessarily apply to anything you as an individual 
investor might be doing, nor does the fact that GnuCash recognizes the symbol 
mean that Alphavantage or any other quote aggregator will necessarily use it 
for reporting.

Regards,
John Ralls


> On Mar 9, 2024, at 15:42, Kalpesh Patel  wrote:
> 
> Most likely the case ... I am not sure how XAU was determined to be a 
> currency when in fact it is an Index. I suspect it is historical carried 
> forward ...
> 
> Anyways, '^XAU' and 'GC=F' (or 'SI=F') will need to be added manually as 
> attributes in the Currency namespace are not modifiable (at least I couldn't 
> do so on Windows platform one) in the Security Editor.
> 
> 
> 
> -Original Message-
> From: Adrien Monteleone  
> Sent: Friday, March 08, 2024 12:53 PM
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Error Retrieving Gold Price for Price Database
> 
> But XAU no longer works with Alphavantage at least. GC=F (SI=F for
> silver) works fine.
> 
> Regards,
> Adrien
> 
> On 3/7/24 10:50 AM, Kalpesh Patel wrote:
>> Oh!
>> 
>> XAU symbol is indeed named Gold in Currencies name space which seems 
>>  ...
> 
> 
> 
> ___
> 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] Maddening!!!!!!!!

[john]

No, that's a re-bundling of GnuCash 5.5 for Windows with a rebuilt WebKitGtk so 
that it doesn't crash when you try to run a business or chart report. There are 
no changes to GnuCash itself.

The fix for the left-over splits from editing an auto-completed transaction 
will be in GnuCash 5.6. Flatpak and Windows users can get it from a nightly 
build, otherwise you have to wait a few weeks.

But we now know that it's caused by a dangling pointer in the account's split 
list from a second run of autocomplete. You can safely ignore it--meaning don't 
check it when reconciling--and it will go away when you end the session.

Regards,
John Ralls

> On Mar 9, 2024, at 02:00, Jack Slater  wrote:
> 
> Oh ok. Happy to. I guess I was expecting a 5.51 or something to
> differentiate the releases.
> 
> On Fri, Mar 8, 2024 at 4:09 PM David H  wrote:
> 
>> Jack,
>> 
>> John Ralls released an updated version of 5.5 on 21 Feb -
>> https://lists.gnucash.org/pipermail/gnucash-user/2024-February/110886.html
>> - I assume if you re-download the Windows version at Gncash.org you will
>> pick it up ?
>> 
>> Cheers David H.
>> 
>> On Sat, 9 Mar 2024 at 04:57, Jack Slater  wrote:
>> 
>>> Revisiting the bug log (after another rogue transaction and crash today)
>>> and I see John's notes about fixing but I'm guessing it's not in 5.5?
>>> That's what I'm running and all I see on the web site.
>>> 
>>> On Thu, Feb 8, 2024 at 11:12 AM Patrick James >>> 
>>> wrote:
>>> 
 Save, Exit, and Reload will clear the rouge transactions.
 
 
> On 02/08/2024 8:54 AM PST Jack Slater  wrote:
> 
> 
> Anything coming soon to fix this?
> 
> On Thu, Jan 25, 2024 at 12:26 PM Patrick James <
 patrickjame...@comcast.net mailto:patrickjame...@comcast.net> wrote:
> 
>> This is bug 799093, and John Ralls has not asked additional
>>> questions
 after I was able to reliably reproduce (part of) the issue, so,
>>> hopefully,
 there is sufficient information to find the bug.
>> 
>> https://bugs.gnucash.org/show_bug.cgi?id=799093
>> 
>> s 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.
 
>>> ___
>>> 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.

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

Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)

[john]

Are you using the SQLite3 backend? If so and it's really corrupted see 
https://www.sqlite.org/recovery.html. Good luck.

Regards,
John Ralls



> On Mar 8, 2024, at 22:43, David H  wrote:
> 
> Eric,
> 
> Are you sure you haven't got a more recent backup?  I have multiple backups
> (currently 77 - e.g. .gnucash.20240208183810.gnucash) in
> the folder where my usual gnucash data file lives from the last time I
> opened it - you should be able to open the one with the most recent date
> and time stamp in the name and then save as you LLC file proper. .  It
> seems you are opening this file directly in the cloud - I've never been a
> fan of that ? I always copy my file to my local pc (1 of about 5 running
> Win10/11, Ubuntu, MacOS) using FreeFileSync before I open it and then copy
> it back when I'm done which works well for me.  Hope you can get it sorted.
> 
> Cheers David H.
> 
> 
> On Fri, 8 Mar 2024 at 23:59, Eric H. Bowen via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> I use two separate GnuCash books, one for my personal funds and another
>> for my LLC. These files are saved on a cloud drive and I access them
>> from a few different computers. Some of the computers run Windows 10,
>> while some run Ubuntu Studio 22.04 LTS. The computer on which this first
>> happened was running Windows 10 and GnuCash 5.4+ with sqlite backend,
>> but all computers are now responding the same way.
>> 
>> The day before yesterday I was updating and making some entries in the
>> book for my LLC; GnuCash was working normally. Then, with the work
>> completed, I attempted to switch from the LLC book to my personal book.
>> However, apparently the file was still open on a remote computer because
>> I received the error message that the .lock file could not be received.
>> I elected to close the file and exit GnuCash. Well and good. When I got
>> home that evening I closed the open instance of GnuCash running the
>> personal book. Well and good.
>> 
>> This morning I reopened the personal book and it opened and operated
>> normally. Okay so far. Then, I closed it and attempted to open the book
>> for the LLC. It would not open; I got a pop-up error message reading,
>> "GnuCash could not complete a critical test for the presence of a bug in
>> the "libdi" library. This may be caused by a permissions
>> misconfiguration of your SQL database. Please see
>> https://bugs.gnucash.org/show_bug.cgi?id=645216 for more information."
>> 
>> I went to the bug tracker website, found the entry, and attempted to
>> follow the procedure which others said worked for them, of making a copy
>> of the GnuCash file and opening/closing it. However, the copied file(s)
>> were also corrupt and would not open. I do have a backup, but it's a few
>> weeks old and I'd have to reconstruct the invoices and bills since then.
>> Not a major undertaking, but if possible I'd like to recover this file.
>> The personal book, by the way, continues to work perfectly. Thanks for
>> any assistanceEric.
>> 
>> 
>> ___
>> 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.

___
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] 5.5-1 crashing on macOS 14.3

[john]

Good that you've gotten it working. Maybe open an issue at 
https://github.com/finance-quote/finance-quote/issues about YahooWeb.pm not 
setting the right error code when it fails to get a quote.

And please, in the future, start a new thread or at least change the subject 
when you digress like that. This one was supposed to be about a hard crash of 
GnuCash itself.

Regards,
John Ralls


> On Mar 8, 2024, at 23:30, Tom Teixeira  wrote:
> 
> I did end up making time to investigate today, and the problem ended up being 
> just one fund that no longer works with YahooWeb. This particular fund is a 
> "stable value" fund so checking the value is somewhat superfluous. As it 
> turns out, it does with with AlphaVantage.
> 
> Again, thanks to David Reiser for the information to explicitly specify 
> x86_64 architecture when running on Apple silicon.
> 
> On 3/8/24 3:25 PM, Tom Teixeira wrote:
>> Thanks for the suggestion. I won't have time today to investigate, but will 
>> do some targeted debugging, either by removing stocks from my list to 
>> update, or by creating a new Gnucash file with only one stock.
>> 
>> 
>> On 3/8/24 2:51 PM, David Reiser wrote:
>>> We are now into my mental weeds as far as real knowledge goes, but I have 
>>> had some success at thrashing around to fix self-induced perl challenges.
>>> 
>>> Since the error happens on both architectures, that suggests something is 
>>> missing. I think YahooWeb is relatively recent in the F::Q realm. And F::Q 
>>> hasn’t managed dependency declarations as well as I’d like.
>>> 
>>> The error complains about a ‘row method’. YahooWeb uses HTML::TableExtract 
>>> which might be the source of the row information. Try installing the 
>>> appropriate arch version of HTML::TableExtract on each machine and see if 
>>> that works.
>>> -- 
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
>>> 
 On Mar 8, 2024, at 1:03 PM, Tom Teixeira  wrote:
 
 I spoke too soon: while getting an individual quote with gnucash-cli works:
 
 /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes dump 
 yahooweb MSFT
 
 Application Path /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli
 Finance::Quote fields GnuCash uses:
 symbol: MSFT<=== required
   date: 03/08/2024  <=== recommended
   currency: USD <=== required
   last: 407.16  <=\
nav: <=== one of these
  price: <=/
 
 trying to "Get Quotes" in my "Price Database" does not. I get a dialog box 
 with
 
 Price retrieval failed: Unrecognized Finance::Quote Error: Can't call 
 method "rows" on an undefined value at 
 /Library/Perl/5.34/Finance/Quote/YahooWeb.pm line 101.
 
 I have another, Intel-based Mac. After upgrading this to Sonoma 14.4 
 release version, and re-installing Finance::Quote, it gets the same error.
 
>> ___
>> 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.

___
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] Error Retrieving Gold Price for Price Database

[Kalpesh Patel]

Most likely the case ... I am not sure how XAU was determined to be a currency 
when in fact it is an Index. I suspect it is historical carried forward ...

Anyways, '^XAU' and 'GC=F' (or 'SI=F') will need to be added manually as 
attributes in the Currency namespace are not modifiable (at least I couldn't do 
so on Windows platform one) in the Security Editor.



-Original Message-
From: Adrien Monteleone  
Sent: Friday, March 08, 2024 12:53 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error Retrieving Gold Price for Price Database

But XAU no longer works with Alphavantage at least. GC=F (SI=F for
silver) works fine.

Regards,
Adrien

On 3/7/24 10:50 AM, Kalpesh Patel wrote:
> Oh!
> 
> XAU symbol is indeed named Gold in Currencies name space which seems 
>  ...



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