Re: [GNC] Import invoices ~ tax table

t this morning, as we have an > importable invoice twice a week. Something to try. > > On Mar 4, 2021, at 8:10 PM, Nelson Handcock > wrote: > > In your original email you say your GST Tax table is in column P - mine is > in column Q. So perhaps that's the probl

Re: [GNC] Import invoices ~ tax table

In your original email you say your GST Tax table is in column P - mine is in column Q. So perhaps that's the problem? Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock wrote: > Hello,

Re: [GNC] Import invoices ~ tax table

. Thanks & Regards, Nelson Handcock On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen wrote: > When I said the x in the “Taxable?” column is correctly showing which > items are taxable, I was referring to the column in the invoice after > import. > > I do have a Y in the

Re: [GNC] Import invoices ~ tax table

Hello, Try using "Y" in the Taxable column instead of "X" Regards, etc On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, wrote: > The documentation I’ve read has me specify the tax table in column 15 > (counting from 0) aka column P when the csv file is opened as a > spreadsheet. > > When I put t

Re: [GNC] GNU Cash on a Central Computer

I have my gnucash file saved in a Dropbox account. Multiple people can access the file so long as they have the Dropbox account credentials. Gnucash generates a LCK file when the main file is opened, so another person trying to open the file at the same time as someone else will see a warning erro

Re: [GNC] Importing qif from Moneydance

I removed the CX from the gif and I am now able to import the gif files. Thank you Derek! Reed On Wednesday, October 28, 2020, 11:44:45 AM CDT, Derek Atkins wrote: Hi, On Wed, October 28, 2020 12:16 pm, Reed Nelson via gnucash-user wrote: > I tried to import a test bank account

[GNC] Importing qif from Moneydance

I tried to import a test bank account qif from Moneydance version 2020.1(1928) into GnuCash version 4.2 (Ubuntu 20.04.1 LTS).   I installed GnuCash with the software install app  (Software 3.36.1) Below is the error message and qif file contents.    I could not find the log file to get more inf

[GNC] Net Worth Linechart report error

Environment: Version: 3.10 Build ID: 3.10+(2020-04-11) Finance::Quote: 1.49 Windows 10 How do I troubleshoot this? TIA. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.

[GNC] AqBanking for Canadian banks

Hello everyone. Just wondering if anyone was successful in setting up any Canadian banks for online banking in GnuCash. Thanks for sharing. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list g

Re: [GNC] Wrong currency when recording a stock purchase

Thank you Adrien. The currency of the stock account is indeed the currency of the parent. The account hierarchy you are recommending is mandatory when holding muti-currency stocks with the same broker. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

[GNC] Wrong currency when recording a stock purchase

3.8 on Windows. So, I have a VOO stock type account. The account is years old and is getting online quotes without any problems. Today I try to register a new purchase (VOO 200 at 252.25) and I realized that the reporting is no longer working - the purchase price seems to be corrupted. After a b

[GNC] account's currency same as file's currency

GnuCash Version: 3.8 The behavior seems to be different on this release compared to older ones. All account numbers (balance, present, total, etc.) on the Accounts tab are expressed in file's currency, same for all accounts, instead of being in account's currency. I believe on previous releases,

[GNC] Tracking currency future contracts in GnuCash

Wondering if anyone uses GnuCash to track a portfolio of currency future contracts, or any other future contracts. https://en.wikipedia.org/wiki/Currency_future & https://www.cmegroup.com/trading/fx/ The EOD price is available for download. Unlike stocks, future contracts are cash settled at the

Re: [GNC] freezing in any file dialog

None of your suggestions are applicable as the operation system and all other apps run just fine and plenty of memory / cpu / disk is available. Absolutely nothing is logged in the log files. What kind of "more details" are you looking for? TIA. -- Sent from: http://gnucash.1415818.n4.nabble.co

[GNC] freezing in any file dialog

Environment: Windows 10, GnuCash 3.7, 3.6 & 3.7-2019-11-29-git-3.7-255-g7853f5a24+ For about 3 days, I cannot use GnuCash anymore. Almost any operations which would open a file dialog (File -> Save As, Import - OFX / CVS etc.) freezes with the spinning wheel, zero cpu utilization. When not kill

Re: [GNC] Questions on how best to setup a non-profit account in gnucash

Hi, I use Gnucash to manage the accounts of a not-for-profit association based in Australia. At the end of the day, it's treated like any other business, but may be exempt from certain taxes. You'd first need to familiarise yourself with the requirements for a not-for-profit association and comp

[GNC] Gnucash unresponsive when importing large Bills & Invoices file

the world I guess. Thoughts/Comments anyone? Thanks & Regards, Nelson Handcock ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnuca

Re: Sending data to my accountant

Fair enough. It's just that in my experience the reports that GNucash generate are normally saved a PDF files, so you can't easily cut and paste information from them to use in a spreadsheet. Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhan

Re: Sending data to my accountant

how to get the information they need from a copy of your file Hope this helps. Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Fri, Apr 6, 2018 at 5:27 AM, Geert Janssens wrote: > Op donderdag 5 april 2018 11:29:09 CEST schreef

Re: Processing a refund

Seeing as the items were returned the very next day, you could also just delete the payment and unpost the invoice. Everything will then be as if the transaction never occurred. Regards, Nelson On Fri, Mar 16, 2018 at 6:57 AM, Adrien Monteleone < adrien.montele...@gmail.com> wrote: >

Re: Save File to Dropbox

I use Dropbox for my GN file and I've had no trouble. I installed the dropbox app for Windows 10, set up the account and specified which dropbox folders to synch, and I could see the dropbox folder in Windows Explorer and also the GN file - no problems at all. Perhaps open the dropbox app on your

Re: Why I'm trying GnuCash

don't think you'll be disappointed with GN at all. Thanks & Regards, Nelson Handcock On Tue, Feb 20, 2018 at 2:18 AM, Stan Brown wrote: > Being brand new to the list, I don't know whether it's customary to > introduce oneself. But how I got here is perhaps a

Re: Lock file issues

hared directory that others can access. Cheers for now On Sun, Feb 18, 2018 at 10:00 AM, Christine wrote: > Its ok it has worked now, thanks > > > > *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com] > *Sent:* 17 February 2018 23:28 > *To:* Christine > *C

Re: Lock file issues

might not have been saved. It's always a good idea to deliberately save any changes, and then close the application as a separate activity. The LCK file should not be there once you have exited. Hope this helps Nelson Handcock On Sun, Feb 18, 2018 at 9:14 AM, Christine via gnucash-user &

Re: Controlling Gnucash from 2 computers

be out of synch with the local instance. Fortunately I've been able to re-build from one of the older stable archive versions without too much drama. Hope this helps... Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Thu, Feb 15, 201

Re: GnuCash: Import CSV File Format

The online help/tutorials has all the information! Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Fri, Dec 8, 2017 at 7:58 AM, Charles Sliger wrote: > Where can I find the file specification for creating a csv file to &

Re: GnuCash question

Well put George! That's exactly how I see it too http://www.linkedin.com/in/nelsonhandcockaustralia On Wed, Nov 22, 2017 at 12:56 PM, George Riner wrote: > Interesting interpretation of what the period (or 'dot') symbol means as > punctuation between the levels of revisions in the releases. It

Re: I applied payment to wrong customer

I think there's a couple of ways... 1) Delete the payment from the account and re-enter it or 2) Find the payment in the account - then choose "Assign as payment" from the context menu and select the correct customer. Hope this helps! On Sat, Nov 18, 2017 at 10:40 AM, Tim Quinn wrote: > H

Re: Bank reconciliation history

e if you might be able to include this column in a transaction report though. Hope this helps! Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Tue, Oct 31, 2017 at 2:08 AM, Derek Atkins wrote: > Hi, > > Mark Roworth via gnucash-user

Re: Vendor Bill - Invoice Entries

her than Gnucash. It could potentially work for you too.... Cheers - Nelson On Tue, Oct 17, 2017 at 8:04 AM, wrote: > Michael: > > Thanks for the reply. I have to say, I was thinking this would be a > natural function of business accounting software but I see your point about >

Re: command line QIF import

You're getting very defensive here David and your posts are not contributing to this discussion at all. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://list

Re: command line QIF import

There are multiple classes of failures and most of them seems to be transfers related. There are the ones a which show up more often: - missing transactions - duplicate transactions - voided transactions (transaction exist but flagged as "void" and has zero amount) - transactions in wrong account

Re: command line QIF import

Thank you for your answer David. I am aware that QIF is a text file and I can open it in text editor. I have a 235000 lines QIF file created by quicken. Most of the transactions are being imported properly but there are thousands failing as well. I have no way to identify those failed transactio

command line QIF import

Hi everyone, I am trying to import about 20 years of Quicken transactions into GnuCash going trough a Quicken QIF export. As many people reported, this is a very painful process and requires endless manual corrections. I was wondering if it would be possible to maybe to do the import from comman

Re: What's the best way to model an electronic funds transfer pull with hold

Hi John, What I am doing today is exactly you are saying. I have a "pending" account and I would record two transfers: - $1 bank-a -> pending - $1 pending -> bank-b postdated by 5 business days. What bothers me with this approach is that when I go online on bank-a I see a different balan

Re: What's the best way to model an electronic funds transfer pull with hold

David, I am well aware that the problem I am raising is not a very common one and want to thank you for your answer. The thing is that I have to work with tens of accounts and each transitory state is extremely important. Imagine that when I have a number of pulls pending on an account becomes qu

What's the best way to model an electronic funds transfer pull with hold

Let's assume that we have two accounts, bank-a and bank-b. - bank-a has a $11,000.00 balance - bank-b initiates a $10,000.00 electronic funds transfer pull. - money shows up in bank-b immediately but there is a 5 business days hold so money is not available. - for at least 2 business days, until

Re: How to enter split transactions

The following tutorial is available https://www.gnucash.org/docs/v2.6/C/gnucash-guide/txns-registers-txntypes.html Google "gnucash split transaction tutorial" also has a youtube video that you might find helpful... Hope this helps! On Wed, Aug 23, 2017 at 4:47 PM, Janet Saxby via gnucash

Re: Import Invoice problem

intrigued by the date format you use - in my load files I use "DD/MM/" - but again maybe that is dependent on your own GN settings too Hope this helps... Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Thu, Jun 22, 2017 at 8:

Re: Import Invoice causes error

the file when you import it, it will be rejected by the importer, but it will help ensure you have all the correct columns defined in your file. Thanks & Regards, Nelson Handcock On Sat, Jun 10, 2017 at 2:22 AM, John A Brown wrote: > Hello, > > GnuCash is a very good program

RE: Issues with Importing Invoices

Thanks for the update. Good to see another happy gnucash camper! On 27 May 2017 10:04 a.m., "Bruce Danielson" wrote: > Nelson – on a whim, today at work I decided to import my 34 June 1 > invoices, opening date today but invoice date and due date June 1, with > posting fields

Re: Issues with Importing Invoices

27;s all done for you when you run the import. Cheers, Nelson On Fri, May 26, 2017 at 12:47 PM, Bruce Danielson wrote: > Nelson – OK, I just copied your exact header row and tried importing but > with no ID’s (Invoice Number blank) – I got errors that No ID Set (or > something lik

Re: Issues with Importing Invoices

csv file using Wordpad, and adding a comma in the first character position to each line (if you don't want to add the header row) It's very strange that you are getting the second invoice with the C033 customer - that has not been my experience. Hope this helps Thanks & Regards, Nel

Re: Issues with Importing Invoices

- Counters. Hope this helps,.. Thanks & Regards, Nelson On Wed, May 24, 2017 at 12:58 PM, Bruce Danielson wrote: > Greetings - I am a new user, and I am trying out GnuCash on a rather odd > application - I manage a couple of employee water clubs at work (for > Sparkletts bottled wate