Re: [GNC] Manipulating data extracted from gnucash to Excel

, and the separator (usually a comma). There is also an option to > either add double quotes or not. > > On Sun, May 19, 2024 at 12:41 PM David Long > wrote: > >> When I copy data from Gnucash to Excel it arrives on text format along >> with >> the currency d

[GNC] Manipulating data extracted from gnucash to Excel

When I copy data from Gnucash to Excel it arrives on text format along with the currency denomination, so I cannot then manipulate it in Excel. Is there anyway I can export data to Excel in data format?. Thanks David ___ gnucash-user mailing list

[GNC] Saved Reports accross several PCs

I am running gnucash on more than one PCs. When I create report on one PC I find I have create that report on other PC even though they are both pulling in data from the same file. Is there anything I can do to not have recreate these reports?. Also, I am using Gnucash for 2 different

Re: [GNC] Description input on a transaction difficulty

I want". > Are you saying that typing on your keyboard doesn't add characters to the > description at that point, regardless of what the automatch is doing? > > Possibly the above fix coming in 5.2 will resolve your issue as well. > > Sincerely, > > Vincent Dawans > &

[GNC] Description input on a transaction difficulty

Hi, What happens is that when I enter the description, the autofill tries to find a match, but if it does not I am unable to continue typing the description I want. As Michael D Novack, says , I can end up fighting with GnuCash to get the description I want. Also, when I try to backspace and

[GNC] reporting currency

. What can I do?I am thinking I should reinstall GnuCash. Thanks David Long ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user

[GNC] Is it reasonable to have sub-accounts under under Equity

Hi, If I were you, I would ask your accountant to give you the balance sheet as of 28/2/2022, or better still the detailed trial balance (called Account Summary in GnuCash reports). Those closing balances would then become the opening balances as of 1/3/2022. You will need those numbers if are

Re: [GNC] How to generate Budget V Actual Report for Profit and Loss

Thanks Adrien for your reply. I have also been trying to produce a report showing this year's P compared with previous. I tried the multi column reports, but the descriptions repeat and the rows do not line up. Reporting Actual V Budget and prior years is pretty standard in an accounting system,

[GNC] Revisiting the pre-paid invoice (coupon, credit note ...) issue:

in their receivable account using the invoice payment process which is equivalent to your item 4 below. Ugly though, as on the balance sheet report the current accounts not yet cleared of to A/R appear as a negative asset rather than in the liability section. Regards David Long Your message : Revisiting

Re: [GNC] default local currency (Liz)

USD. I am thinking that GnuCash sets the default currency during the installation process, by detecting the default location, and that therefore I now need to re-install, but will first try closing GnuCash and restarting my laptop. Regards David Long From: David H Sent: May 11

[GNC] default local currency (Liz)

ferences) 2. Specify one from the drop down. OK, if that's case am thinking if 1. Then need to change in OS preferences. Having done that do I need to reinstall? Liz, I have Windows 10. David Long ___ gnucash-user mailing list gnucash-user

Re: [GNC] default local currency

Hi, Actually, I tried a re-install, thinking I had missed a trick in the installation process, but exactly the same. Regards David From: David H Sent: May 10, 2022 11:45 AM To: David Long Cc: Gnucash Users Subject: Re: [GNC] default local currency Ah yeah forget

[GNC] default local currency

I have been using GnuCash on a Desktop, and installed it on my laptop too. It was a messy installation , probably due to a hardware issue, so I did not go through a normal GnuCash routine for setting up a new set of accounts. However, I managed to open GnuCash and upload the GnuCash

[GNC] Double entry directly to Equity

Hi, I just tested David's method of creating a new equity account and crediting the revaluation to that account and debiting the asset account. I did not attach the new Revaluation Reserve account to an existing equity account (parent) but I specified it as a new top level account. Either way

[GNC] gnucash.org ] Account for Seller Credit when purchasing a home

If the reduction of 5000 USD were genuinely for repairs which you expect to spend I would post the 5k as a minus expense in a maintenance account, or create a house repairs account (type expenses). Actually it's a credit. Then when you spend on repairs debit the expense to that account.(CR bank

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

the exchange rate conversion tools of GnuCash. David On Thu, Apr 28, 2022 at 12:19 AM David Long wrote: > > Hi Ken, > Re your reply to Michael below, I can help with the accounting, because > this has to be understood before how to use any financial accounting system > , like GnuCa

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

Hi Ken, Re your reply to Michael below, I can help with the accounting, because this has to be understood before how to use any financial accounting system , like GnuCash, can be used. In any set of financial accounts, including those where the system is based on handwritten ledgers (how I

[GNC] Customizing invoices (Helmut Eller

I have same problem as Helmut who wants to display more than 2 decimal places in the quantity field of an invoice. My case is if I want to charge say 7 months of an annual subscription then my quantity is 7 12ths so 3 decimal places would be better. My only workaround was to add it in the

[GNC] GNC] Question about Assemblies

Best to use system which has inventory accounting as then you won't have to worry about accounting double entry as system will generate it for you automatically. When you enter a purchase invoice it will have a quantity purchase field so item will be put into stock at cost and quantity. Then there

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

riodic 'rent owing' ? (davidcousen...@gmail.com) >3. Re: Subject: Re: Keeping tenant accounts on Gnucash - > periodic 'rent owing' ? (D.) >4. Re: Subject: Re: Keeping tenant accounts on Gnucash - > periodic 'rent owing' ? (arthur brogard) >5. Re: gnucash-user

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

5. Re: Keeping tenant accounts on Gnucash - periodic 'rent I agree with Adrien's comments exactly. For some time I avoided using the business functions of GnuCash as it looked tricky, but a few months ago I did and have saved a lot of time and have some neat reports. Invoices are native in the

[GNC] Changing where my data is held

Hi, sounds ridiculous but cannot find how to change where my data is held. Normally would expect to see that under preferences, but do not see it there. Any advice? I want to put on a shared drive on Dropbox, so another person can use. Thanks David

Re: [GNC] Download GnuCash issue

drive a Tesla on a cow path. Why >> >> try? >> >> On Sat, Feb 12, 2022 at 7:37 AM wrote: >> >>> Hi, I downloaded the latest version of GnuCash (4.9) onto an older >> >>> laptoprunning Windows 8.1 , bu

Re: [GNC] Download GnuCash issue

t; >>> laptoprunning Windows 8.1 , but when I tried to run the setup got a >> >>> message thatit could not run on this machine. Same thing with an >> >>> older version ofGnuCash. I have about 11 GB of disk space remaining >> >>> on this machine.

[GNC] inventory

Hi, Since GNU Cash does not include inventory recording, can anybody recommend an inventory recording system. I do not need all the inventory management capabilities, just record keeping, showing purchases, issues and balances in unit and cost. Thanks David

[GNC] Account report

Hi, how can I select just the last few months for an "Account Report". I am getting the whole history of the account from the first ever transaction? I can use the "Transaction Report", instead and select which account and periods I want, but then I do not see the opening and closing balance.

Re: [GNC] Using GnuCash with Dropbox

Thanks, I thought that would work as a one off manual save only. So from then on GnuCash will automatically save updates and logs there? I was looking for it under Preferences, but if that's all I need to that's good. David On Fri, 20 Nov 2020, 02:00 D., wrote: > I imagine File->Save As might

Re: [GNC] entering bank transactions.

Hi, I found the answer was to uncheck "place holder" David From: David Long Sent: Friday, 13 November, 2020 9:40 AM To: gnucash-user@gnucash.org Subject: entering bank transactions. Hi, When I double click on Checking Account in Accounts it does not open . I need to do this in orde

[GNC] entering bank transactions.

Hi, When I double click on Checking Account in Accounts it does not open . I need to do this in order to enter a transaction. However, it works perfectly for Petty Cash Account or Saving Account, so must be something particular about Checking Account. Maybe there is another cash book entry