Re: [GNC] Import invoices ~ tax table

[Nelson Handcock]

Glad you got it sorted!

On Sat., 6 Mar. 2021, 00:50 R. Victor Klassen,  wrote:

> Bingo.
>
> This has been hanging around for a long time since 99% of our sales are
> zero-rated. Automatically catching the other 1% will reduce the opportunity
> for errors and speed up the process.
>
> Sent from my iPhone
>
> On Mar 5, 2021, at 7:13 AM, R. Victor Klassen  wrote:
>
> I’m wondering whether I left out the “Tax Included” column, and whether
> there are no important columns after that so it just (almost) works.
>
> I’ll have another chance to try it out 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 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,
>>
>> Ahh yes - I mis-read your original email!
>>
>> Here's a snapshot of my recent loadfile:
>> 
>>
>> And here's a snapshot of my tax tables:
>> 
>>
>> The loaded invoice looks fine in GN - the GST amount is correct and is
>> showing in the liabilities account as defined.
>>
>>
>> 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 appropriate column of the csv file being imported -
>>> else I wouldn’t get the x in the “Taxable?” column.
>>>
>>>
>>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock 
>>> wrote:
>>>
>>> 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 the three letters “HST” or the phrase “Harmonized Sales
>>>> Tax”, both of which name sales tax tables, in that column, it is ignored.
>>>>
>>>> The x in the “Taxable?” Column is correctly showing which items are
>>>> taxable.
>>>>
>>>> Is there a trick I am missing?
>>>>
>>>>
>>>> Gnucash v 3.11 MacOS 10.13.6 if it matters.
>>>>
>>>> Sent from my iPhone
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>
>>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import invoices ~ tax table

[Nelson Handcock]

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,
>
> Ahh yes - I mis-read your original email!
>
> Here's a snapshot of my recent loadfile:
> [image: image.png]
>
> And here's a snapshot of my tax tables:
> [image: image.png]
>
> The loaded invoice looks fine in GN - the GST amount is correct and is
> showing in the liabilities account as defined.
>
>
> 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 appropriate column of the csv file being imported -
>> else I wouldn’t get the x in the “Taxable?” column.
>>
>>
>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock 
>> wrote:
>>
>> 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 the three letters “HST” or the phrase “Harmonized Sales Tax”,
>>> both of which name sales tax tables, in that column, it is ignored.
>>>
>>> The x in the “Taxable?” Column is correctly showing which items are
>>> taxable.
>>>
>>> Is there a trick I am missing?
>>>
>>>
>>> Gnucash v 3.11 MacOS 10.13.6 if it matters.
>>>
>>> Sent from my iPhone
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import invoices ~ tax table

[Nelson Handcock]

Hello,

Ahh yes - I mis-read your original email!

Here's a snapshot of my recent loadfile:
[image: image.png]

And here's a snapshot of my tax tables:
[image: image.png]

The loaded invoice looks fine in GN - the GST amount is correct and is
showing in the liabilities account as defined.


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 appropriate column of the csv file being imported -
> else I wouldn’t get the x in the “Taxable?” column.
>
>
> On Mar 2, 2021, at 2:50 PM, Nelson Handcock 
> wrote:
>
> 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 the three letters “HST” or the phrase “Harmonized Sales Tax”,
>> both of which name sales tax tables, in that column, it is ignored.
>>
>> The x in the “Taxable?” Column is correctly showing which items are
>> taxable.
>>
>> Is there a trick I am missing?
>>
>>
>> Gnucash v 3.11 MacOS 10.13.6 if it matters.
>>
>> Sent from my iPhone
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import invoices ~ tax table

[Nelson Handcock]

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 the three letters “HST” or the phrase “Harmonized Sales Tax”,
> both of which name sales tax tables, in that column, it is ignored.
>
> The x in the “Taxable?” Column is correctly showing which items are
> taxable.
>
> Is there a trick I am missing?
>
>
> Gnucash v 3.11 MacOS 10.13.6 if it matters.
>
> Sent from my iPhone
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNU Cash on a Central Computer

[Nelson Handcock]

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 error saying that a lock can't be established.

Regards, etc

On Fri., 4 Dec. 2020, 06:59 Terry Simon,  wrote:

> I currently use QuickBooks for business accounting software. Never liked
> it and am in the process of replacing our server. We have a 5 year old
> version that is no longer supported so if there’s a problem migrating the
> program we’re out of luck. I would like a simpler program. QuickBooks is
> too much and too little. The question about GNU Cash is can it be installed
> on workstations that work from a central file. We only have 3 users that
> all do different tasks so conflicting data entry won’t be an issue.
>
> Thanks,
>
> Terry L Simon
> inLOOP - Designed and manufactured in the US
> 6653 Grand Haven Road
> Norton Shores, MI   49456   USA
> (231) 798-2399
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Nelson Handcock]

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 comply with the rules that are applicable
for where your association is going to be set up. These rules will vary
from country to country and maybe even from state to state.

For the association I help manage, we are registered with the state
government body as a not-for-profit incorporated association. We can
therefore declare ourselves as exempt from paying tax on our net company
profit. We are 100% run by volunteers, so we don't have to pay salaries and
collect or pay tax on behalf of any employees. We pay rent, utilities,
operating expenses and insurances just the same as any other business.

In our case, we usually have a turn-over that exceeds a certain limit, so
we have to collect GST on sales, and we submit a quarterly Business
Activity Statement to declare how much GST we pay on purchases and expenses
and we either get a net refund or we pay the net shortfall. To calculate
GST on our activity we use the Gnucash Tax Tables and set up GST liability
accounts so it's not difficult to figure out the required information to
submit.

We use Gnucash to reconcile our bank accounts and generate financial
reports annually, and we submit to an annual audit performed by a certified
practising accountant. We receive a report which we have to submit annually
to the state government body we are registered with.

Hope this helps!



On Fri, Aug 9, 2019 at 11:36 AM Mike or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 8/8/2019 12:24 PM, Larry Wagner wrote:
> > I would like some comments about how one would set up gnucash for a
> > non-profit.
> >
> > Here are some of the specifics:
>
> What kind of non-profit are you? What do you have to file with what
> jurisdictions?
>
> << There are non-profits that do not pay taxes, but are not tax
> deductible organizations. The rules are different with what gets filed
> with whom >>
>
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Nelson Handcock]

Hello All,

This is not reported as a bug (yet) but will do so if initial responses
suggest it's warranted.

I'm running Gnucash Version 3.1


I prepared a csv file to import a number of invoices - about 900 or so. The
spreadsheet file contained about 1300 rows. Some invoices are multi-item -
I've found GN imports multiple items into a single invoice if they are
numbered identically and grouped together in the import file.


With earlier versions it always worked fine. It always took a few minutes
and sometime I wondered if it would finish, but it always seemed to.

Also with earlier versions, the imported invoices were "unsaved" which was
great, because if I realised I had a problem and I wanted to discard the
import, then I could close the file without saving changes.


With version 3.1, I have experienced GN failing to import the full file. The
application is viewed by Windows 10 as "unresponsive", and if you aren't
doing anything, then your PC may time out/go to sleep, and I think from
that point the whole import process dies.

I eventually got my import completed by chopping my initial file up into 3
smaller ones.

I have also noticed that in Version 3.1 that the gnucash file saves itself
on completion of the import... you no longer have the opportunity to "Exit
without saving". This can be resolved by making sure you keep a copy of the
file before you run the import so you have a back-up, so it's not the end
of 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/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Sending data to my accountant

[Nelson Handcock]

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

On Fri, Apr 6, 2018 at 9:51 AM, Rich Shepard <rshep...@appl-ecosys.com>
wrote:

> On Fri, 6 Apr 2018, Nelson Handcock wrote:
>
> Most accountants that are familiar with computer-based accounting systems
>> should have little trouble figuring out how to get the information they
>> need from a copy of your file
>>
>
>   It all depends on where you live. Here in Oregon accountants must use
> proprietary tax preparation software (all requiring Microsoft, of course).
>
>   I send my accountant the balance sheet and income statement as PDF
> attachments to an e-mail message for business taxes. For personal I add the
> trial balance report so she can extract deductible expenses more easily.
> We've been doing this for years.
>
> Rich
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Sending data to my accountant

[Nelson Handcock]

The gnucash platform is free to download and install, so when my accountant
had the same issue I suggested he installed gnucash, and then I just sent
him a copy of my gnucash file.

Most accountants that are familiar with computer-based accounting systems
should have little trouble figuring out 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 <geert.gnuc...@kobaltwit.be>
wrote:

> Op donderdag 5 april 2018 11:29:09 CEST schreef Roache Ian:
> > What is the best way to get my gnucash data to my accountant for him to
> > check and prepare my tax return? Is there a way I can do this if he
> doesn’t
> > have the gnucash platform?
>
> The best way is probably to generate the reports your accountant requires
> and
> save/print them for your accountant.
>
> The option are to Export as pdf, or copy the report (which is in html) to
> excel or libreoffice calc where you can post-process the data before
> sending
> it to your accountant.
>
> Geert
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Processing a refund

[Nelson Handcock]

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:

> Issue a Credit Memo for the item. If the refunded item is marked taxable,
> sales tax will also be included in the credit.
>
> If you are actually handing over funds, you can then ‘pay’ the credit memo
> with a check or other entry. Otherwise, you can apply the credit memo to a
> future invoice as a payment.
>
> Regards,
> Adrien
>
> > On Mar 15, 2018, at 3:52 PM, Martijn Heuts 
> wrote:
> >
> > Hello, I am running GNU cash for my business.I created and posted an
> invoice, which was paid in full.However a day later the client returns the
> item.THe client also paid sales tax on this invoice.
> > What is the proper way to process this refund in GNU?I tried via the
> REFUND field which doesn't seem to process correctly.Also I need to make
> sure the sales tax is taken care of.
> > Please help. Thanks and I appreciate it!
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Save File to Dropbox

[Nelson Handcock]

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 Windows PC and check all the settings,
etc...

I usually open my GN file by just double-clicking on the Gnucash app - it
automatically opens the last file (which is my case is the one on the
dropbox folder). Occasionally I've had to open an archive file - and I just
double-click on the file in Windows Explorer.


HTH...

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

Re: Lock file issues

[Nelson Handcock]

No prob. Please remember to "reply-all", for the benefit of others who have
received your original email - that way everyone can see what's going on.

The LCK file can simply be deleted from the directory if the main Gnucash
file is not in use - assuming you aren't using a shared directory that
others can access.


Cheers for now



On Sun, Feb 18, 2018 at 10:00 AM, Christine <cmalon...@talktalk.net> wrote:

> Its ok it has worked now, thanks
>
>
>
> *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com]
> *Sent:* 17 February 2018 23:28
> *To:* Christine
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: Lock file issues
>
>
>
> Hi,
>
>
>
> The lock file is only there when the file is opened, and when you save and
> close (assuming this is done correctly and completely), then the lock file
> should be deleted.
>
>
>
> So if the LCK file is there while the Gnucash file is not being used, then
> this tells you the Gnucash application wasn't closed properly - perhaps
> your PC suffered a sudden loss of power or something similar?
>
>
>
> Anyway - you should be able to choose the option to "open anyway", and
> continue on with your work.
>
>
>
> Just make sure you check the file, because it's possible the last set of
> changes you made 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 <
> gnucash-user@gnucash.org> wrote:
>
> When I tried to open my accounts on gnucash it stated that the lock file
> could not be opened. The lock file is still in the folder. What can I do?
>
> GnuCash could not obtain the lock for
> file://C:\Users\Polly\Desktop\hubb_main\HUBB_MAIN_ACCOUNTS.gnucash.
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
> <#m_9121902285614457695_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Lock file issues

[Nelson Handcock]

Hi,

The lock file is only there when the file is opened, and when you save and
close (assuming this is done correctly and completely), then the lock file
should be deleted.

So if the LCK file is there while the Gnucash file is not being used, then
this tells you the Gnucash application wasn't closed properly - perhaps
your PC suffered a sudden loss of power or something similar?

Anyway - you should be able to choose the option to "open anyway", and
continue on with your work.

Just make sure you check the file, because it's possible the last set of
changes you made 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 <
gnucash-user@gnucash.org> wrote:

> When I tried to open my accounts on gnucash it stated that the lock file
> could not be opened. The lock file is still in the folder. What can I do?
>
> GnuCash could not obtain the lock for
> file://C:\Users\Polly\Desktop\hubb_main\HUBB_MAIN_ACCOUNTS.gnucash.
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Controlling Gnucash from 2 computers

[Nelson Handcock]

I have been using Gnucash by putting the file on a dropbox folder, and then
using the dropbox app for Windows 10 on each of the computers to access and
synch the dropbox folder and its contents. The LCK file that Gnucash
creates is saved to the dropbox account, and so other users on other
computers will be alerted.

Most of the time it works fine. I sometime keep a local copy of the file
just in case.

You do need to be a bit patient each time you want to use it by making sure
the dropbox app has completely synched the account before you start
editing. I usually make sure the other user is aware of the date/time last
saved of the main file - that way they can see if they are opening the most
recent one on their computer.

There have been a couple of times things have gotten out of synch - I put
it down to user error - loss of network connectivity, etc - causing the
dropbox account to 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, 2018 at 3:22 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> Martijn,
>
> It is not a good idea to have two people editing the data file at the same
> time. At some point in the future, this will be possible, but it is not
> safe right now.
>
> Two people can use the software from two different machines (with the file
> access over a network) but only one should have the file open at a time.
>
> Also, please be sure to not click ‘reply’ when you want to start a new
> topic and be sure to create a meaningful subject line so your discussion
> will thread properly.
>
>
> Regards,
> Adrien
>
> > On Feb 9, 2018, at 4:38 PM, Martijn <usadutch...@bellsouth.net> wrote:
> >
> > Hello,
> >
> > Can GNU Cash be controlled by 2 computers?
> > I have an XP computer and a Windows 10 computer and it would be great if
> somehow I can make the XP computer see the Windows 10 computer GNU file.
> This way 2 people could create invoices at the same time, maybe?
> >
> > Sent from cell phone
> > On Feb 9, 2018 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> >>
> >> Send gnucash-user mailing list submissions to
> >> gnucash-user@gnucash.org
> >>
> >> To subscribe or unsubscribe via the World Wide Web, visit
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> or, via email, send a message with subject or body 'help' to
> >> gnucash-user-requ...@gnucash.org
> >>
> >> You can reach the person managing the list at
> >> gnucash-user-ow...@gnucash.org
> >>
> >> When replying, please edit your Subject line so it is more specific
> >> than "Re: Contents of gnucash-user digest..."
> >>
> >>
> >> Today's Topics:
> >>
> >>1. Re: p2x modelling in gnc, help me think, please (Wm)
> >>2. Re: How to Manually Track a Collection of Stocks & Stuff
> >>   Combined into a Single Share (Wm)
> >>3. Latest version for Windows? (cicko)
> >>4. Re: Price Retrieval Failure, Part 2 (John Ralls)
> >>5. Re: Latest version for Windows? (John Ralls)
> >>
> >>
> >> --
> >>
> >> Message: 1
> >> Date: Thu, 8 Feb 2018 20:50:40 +
> >> From: Wm <wm_o_...@yahoo.co.uk>
> >> To: gnucash-u...@lists.gnucash.org
> >> Subject: Re: p2x modelling in gnc, help me think, please
> >> Message-ID: <p5id33$agn$1...@blaine.gmane.org>
> >> Content-Type: text/plain; charset=utf-8; format=flowed
> >>
> >> On 07/02/2018 18:17, Adrien Monteleone wrote:
> >>
> >>> Go to Preferences > General > Numbers. You can increase your decimal
> precision. Did that solve the small fraction issue?
> >>
> >> That isn't a good way to go if your base currency is a 2 decimal one.
> >> Creating a commodity with the appropriate number of decimals and using
> >> that is better.
> >>
> >> By chance there is another more recent but simpler thread
> >>
> >> ===
> >> Subject: How to Manually Track a Collection of Stocks & Stuff Combined
> >> into a Single Share
> >> ===
> >>
> >> it is the same basic problem.  "put the other leg in equity" doesn't
> >> work for me and the variance is actually the value not the price which
> >> is what makes them different to traded invest

Re: GnuCash: Import CSV File Format

[Nelson Handcock]

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 <c...@bctonline.com> wrote:

> Where can I find the file specification for creating a csv file to
> import transactions?
> --
> -chaz
> Charles Sliger
> "No matter where you go... There you are... Buckaroo Banzai"
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: GnuCash question

[Nelson Handcock]

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 does not
> mean a decimal fraction part thereof. It is more representative of say an
> outline level, such as what Microsoft Word would produce if one had
> subheadings numbered 1 through 18 - the ones numbered 1 through 9 would not
> have a zero and I think most people would readily understand that 3 is less
> than 18.
>
> 2.6.18 means the 18th revision of the 6th version of release 2.
>
> If the future versions of gnucash proceed up to "2.10", I don't think the
> developers should expected to go back and renumber 2.1 to 2.01; 2.2 to
> 2.02; etc.; Nor should they have been expected to start that numbering at
> the outset not knowing if they would even get to a 2.10 before getting to
> release 3.0
>
> : George
> -- -- --
> Sent by Droid.
>
> On November 21, 2017 5:59:54 PM PST, Alan Whiteman 
> wrote:
> >I think the confusion is that .3 is generally accepted (here in the
> >U.S., anyway) as "0.30".
> >
> >so .3 = .30
> >
> >Perhaps the number method should be 2.6.03 instead of 2.6.3... For the
> >future, of course.
> >
> >On 11/21/2017 11:14 AM, davel...@mac.com wrote:
> >> Please keep replies on the list as it may help others.
> >>
> >> Yes, 2.6.18 is newer. Each number between the periods is a separate
> >number and 18 is greater than 3.
> >>
> >> In general, do not download the 2.7.x versions as those are beta
> >releases for the next version unless you are testing those with other
> >data (i.e., don't run a 2.7 with the only copy of your actual data
> >file).
> >>
> >> Dave
> >>
> >>> On Nov 21, 2017, at 12:34 PM, Sean Perlmutter
> > wrote:
> >>>
> >>> Hi Dave,
> >>>
> >>> Just requested access to the list. But looking for an answer
> >quickly. Saw your reply re the issue below and thought I’d contact you
> >directly. Hope that’s ok.
> >>>
> >>> I’ve got the same issue: Just updated to High Sierra, now GnuCash
> >won’t open. And I can’t find Gnucash.app/contents/Resources/lib.
> >>>
> >>> I see your workaround is to just update to the newest version of
> >GnuCash. Which I’m happy to do. But something is odd.
> >>>
> >>> I have version 2.6.3, installed March 2014. And the GnuCash homepage
> >shows the most recent version as 2.6.18. The version number is lower!
> >Am I missing something? Is that more recent than 2.6.3?
> >>>
> >>> Thanks in advance for your help.
> >>> Sean
> >>>
> >>>
> >>>
>  On Nov 16, 2017, at 10:36 AM, Peter Schoonmaker  >at gmail.com
>  wrote:
> >>>
> >>>
> >>>   Hello,
> >>>
> >>>
> >>>
> >>>   I’ve used Gnucash for several years and I love it. But, I’m a
> >complete novice about the technical side of Gnucash and I need very
> >basic help. I understand that the following is a fix or work around my
> >recent problem:
> >>>
> >>>
> >>>
> >>>   copy /usr/lib/libz.1.dylib to Gnucash.app/Contents/Resources/lib
> >>>
> >>>
> >>>
> >>>   However, I don’t know what the above line means nor how to
> >implement it. In other words, how do I copy /usr/lib/libz.1.dylib to
> >Gnucash.app/Contents/Resources/lib?
> >>>
> >>>
> >>>
> >>>   I’m embarrassed to admit my lack of knowledge, but I would need a
> >step by step description in order to fix this problem on my MacBook
> >Pro.
> >>>
> >>>
> >>>
> >>>   I don’t even know the version of Gnucash that I’m running. I don’t
> >want to lose my data from the last few years. Is it safe to try to
> >reinstall Gnucash with the latest version?
> >>>
> >>>
> >>>
> >>>   I’ve thought about moving my Gnucash data from my current computer
> >to another Mac that’s running an older operating system than High
> >Sierra, but I don’t even know how to begin to do that.
> >>>
> >>>
> >>>
> >>>   Thanks, in advance, for any assistance you can give me. I’ve
> >copied this message to my regular email address so I won’t miss any
> >replies. Thanks again.
> >>>
> >>>
> >>>
> >>>   Peter
> >>>
> >>>
> >>>
> >>> That fix is only needed if you're running an old version. The easier
> >solution is to download the latest gnucash for Mac which no longer
> >requires that fix.
> >>>
> >>> Copying it to another computer requires knowledge of where the data
> >file you are using is stored. If your only goal is to get gnucash
> >running again, just install the latest version on the High Sierra
> >computer. If you still want to move it to another computer, we'll need
> >to figure out where your data file is installed. I'm not at a computer
> >with gnucash installed right now so I can't check how to tell that.
> >>>
> >>> HTH,
> >>> Dave
> >>>
> >>>
> >>>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> 

Re: I applied payment to wrong customer

[Nelson Handcock]

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:

> Hi.
>
> I looked but did not see (or recognize) this same question asked.
>
> Using 2.6.18 I incorrectly processed a payment to the wrong customer.
>
> Can I easily recover from this?
>
> In my mind, I need to “unapply” the payment from the wrong customer and
> apply it to the correct customer.
>
> Any help, or pointers to this same question posed a different way, would
> be welcomed.
>
> Thanks.
>
> - Tim
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Bank reconciliation history

[Nelson Handcock]

If you open the GNucash account that you use to record your bank
transactions, there is a "Reconciled" indicator. By default it is set to
'N'. If you click this it will change to "C", and when you complete the
reconciliation this indicator is changed to "Y".

When I reconcile my GN account, I click on this indicator as I check items
off on my bank statement, and when I get to the end of the period I click
"Reconcile" and confirm everything in the display is checked. Any
discrepancy is easily seen and can be investigated further.

Not sure 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 <warl...@mit.edu> wrote:

> Hi,
>
> Mark Roworth via gnucash-user <gnucash-user@gnucash.org> writes:
>
> > Hi all,
> > Is there anyway I can see a list of bank statements and which
> > transactions were reconciled to which statements? For the life of me I
> > can't find it?
> > Thanks for any help received,
>
> Even though the reconcile date is stored, there is currently no report
> that will show/access that data.
>
> > Mark
> > Mark roworthrowor...@yahoo.co.uk
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Vendor Bill - Invoice Entries

[Nelson Handcock]

I think about the only way you could do it using Gnucash would be to add a
series of sub-accounts that are specific to each service that you provide,
and then post each bill for a service to the appropriate account.

Then you could use the existing reporting available in Gnucash to show the
breakdown of each service via the account structure.

I'm in a similar situation as you - using Gnucash to maintain the books for
a not-for-profit association. But in my case we have a wide variety of
products we sell and they change seasonally, so there's simply not enough
time in the day to keep up.

We use a Point-of-Sale system to record all our sales to our members called
Lettuceshare - (www.lettuceshare.org) - all sales are entered at our
"checkout" and then I summarise the data and import invoices into Gnucash
once a quarter. So can use this system for sales analysis rather 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
> the bulk. This is a function I am currently looking into for a non-profit.
> Basically, we receive invoices for services which I’ve been inputing as
> bills into the AP register. The invoices of course could contain any number
> of services, many of which are common. What we’d like to be able to do is
> to create reports that might say, these are the top 5 services that were
> preformed in 2016 and how many of each there were. I’d prefer to only have
> to enter this data once, so I was hoping that GC would have the
> functionality but I am finding out that this might be outside the scope of
> any accounting type of software.
>
> Would you be able to suggest an approach, a tool, that might compliment
> GC? Or is this just going to have to be something totally different?
>
> Thanks.
>
>
>
> > On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack <
> stepbystepf...@dialup4less.com> wrote:
> >
> > On 10/15/2017 10:08 PM, DaveC49 wrote:
> >> Hi,
> >>
> >> The facilities you are requesting are likely to require an inventory
> >> management system. At present Gnucash is an accounting package and
> currently
> >> does not incorporate any features for inventory management. As far as i
> know
> >> there are no plans to incorporate such features in the near future. To
> do so
> >> would reuire a developer(s) interested in developing these features.
> >> Similarly while it can handle the accounting specific side of payroll
> >> management it does not handle the calculation of payrolls, deductions,
> taxes
> >> etc. You may need to took at ERP software if you require these
> facilities.
> >>
> >> David Cousens
> >
> > I am going to point something out. Gnucash is an accounting package. A
> business might need a number of OTHER packages that would interact with the
> accounting package, but normally are separate parts. Why separate? Because
> which of these other parts a business might want/need depend on the
> business. A unified business application (including ALL the different
> possible pieces) would be unnecessarily bulky, with a given business never
> using many of those pieces.
> >
> > inventory -- only if the business HAS inventory that it sells
> > payroll -- only if the business has employees (employees in the
> legal sense of that word)
> > billed time -- only of a business deals in "billable hours"
> > POS --- only if a business does this kind of retail << point of sales
> not only interacts with accounting but also inventory >>
> > etc. etc. etc.
> >
> > Since I do accounting just for non-profits, I am aware of OTHER "pieces"
> that would apply to this specialty. Just because I may be using gnucash to
> provide these pieces does NOT mean "part of gnucash" << I am simply ALSO
> using gnucash to implement "virtual  books" for those specific pieces >>
> >
> > Michael D Novack
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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
> 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
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: How to enter split transactions

[Nelson Handcock]

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-user <
gnucash-user@gnucash.org> wrote:

>  Hi,
> Can someone explain how to split transactions between accounts without
> creating an imbalance?
> Regards,
> Janet
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Import Invoice problem

[Nelson Handcock]

Hi,

comparing your file to mine, I think you also have some information missing
that should be there...

I think there should be a date_opened value (column 2). I guess it may be
set to the current system date if not provided, but I've never tried not
having it in my import files.
I'm 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:20 AM, Mike Evans <mi...@saxicola.co.uk> wrote:

> Please file a bug report too. I just read the guide and the fact it should
> be a string isn't mentioned there either.
>
> Mike E
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Import Invoice causes error

[Nelson Handcock]

Hi John,

Well for a start you are 11 full versions of Gnucash out of date - the
current release is 2.6.16.

I recommend you getting the most recent version of the software for a start!

I have attached a sample that works for me - feel free to use it as a
template.
If you leave the header row in 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 <johnbrowngreybe...@gmail.com>
wrote:

> Hello,
>
> GnuCash is a very good program and the open source support community is
> wonderful!
>
> I am using GnuCash 2.6.5 in Windows 7. The error happens when I click File
> -> Import -> Import Bills & Invoices. I choose Invoice000500.csv, invoice,
> comma separated. When I get this information entered the Preview window
> displays the actual information that is in the file. When I click OK I get
> an error telling me "ROW 1 DELETED, CUSTOMER_DOES_NOT_EXIST; id=1234". The
> "id=1234" it is referring to is the first field which is listed as id and I
> understand this field is invoice number, not customer ID. I experimented a
> little and actually put in a valid customer ID in the first field rather
> than the invoice number which is supposed to be there. The same error
> message shows up saying that the valid customer ID does not exist.
>
> Then GnuCash.exe crashes and I get the error message "gnucash.exe has
> stopped working". When I restart gnucash the lock file prevents the data
> file from opening and I have to instruct it to "open anyway".
>
> I have utilized Invoice import feature successfully in the past so I have
> confidence that the format is correct. I have carefully compared my format
> to that described in Help -> GnuCash Tutorial and Concepts Guide ->
> Importing Business Data -> Import Bills or Invoices.
>
> BTW I think there might be a confusing language in the Guide about
> importing. It mentions "data must be in a fixed field length, comma
> separated line format". My opinion is that the format shown is comma
> separated. The format is specifically not fixed field length. The guide
> also instructs the menu selections to get to this import feature is
> Business -> Invoice & Bill Import when the correct menu selections are
>  File -> Import -> Import Bills & Invoices.
>
> Kind Regards, John A Brown
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>
id,date_opened,owner_id,billing_id,notes,date,description,action,account,quantity,price, disc_type, disc_how, discount, taxable, taxincluded, tax_table,date_posted,due_date, account_posted,memo_posted,accu_splits
2016-1755,10/01/2017,memberid1,,,10/01/2017,GST Free Stock Purchases,,Income:Membership Fees,1,50Y,Y,GST Inclusive Sales,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1756,10/01/2017,memberid2,,,10/01/2017,GST Free Stock Purchases,,Income:Sales,1,11.8,,,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Applicable Stock Purchases,,Income:Sales,1,7.19Y,Y,GST Inclusive Sales,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,121.02,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1758,17/01/2017,memberid4,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,70.64,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1759,17/01/2017,memberid5,,,17/01/2017,GST Applicable Stock Purchases,,Income:Sales,1,10.25Y,Y,GST Inclusive Sales,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1759,17/01/2017,memberid5,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,31.07,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1760,17/01/2017,memberid6,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,30.85,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1762,17/01/2017,memberid7,,,17/01/2017,GST Applicable Stock Purchases,,Income:Sales,1,7.19Y,Y,GST Inclusive Sales,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1762,17/01/2017,memberid7,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,74.87,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Issues with Importing Invoices

[Nelson Handcock]

Hi Bruce,

In no particular order

Please check your version of gnucash - most recent version is 2.6.16. It's
best to keep up to date.

Tou can't delete an invoice - but if it's left as not posted then it won't
show in any of the accounts. It's a bit annoying but it's always been that
way AFAIK.


I suggest you firstly complete the remaining columns out to 'V', and then
try again If GST is not relevant for you then leave columns O, P and Q
blank. You might want to change your invoice numbers to something else
first - to ensure Gnucash doesn't get confused with existing invoices.

Due Date can be set to the same as Date Posted - I add 7 days to mine but
you don't have to if you don't want to.

Yes - if you keep the first column blank then that could well fix your
auto-generate invoice numbers. Another way is to open the 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,

Nelson

On Fri, May 26, 2017 at 10:37 AM, Bruce Danielson <daniels...@logroom.com>
wrote:

> Hey Nelson – I totally get all that, and I should have thought to attach a
> copy of my short import file for you to take a look.  Plz see attached.
>
> One thing that did not occur to me is to keep the header row, which I
> should have realized would get ignored during import.  Thx for that tip.
>
>
>
> In my file, both lines are virtually the same except for the Customer ID –
> which are in order (not sure why that should make a difference).
>
> I end up with two invoices, as one would expect, BUT - both are for Cust
> ID C033 (with that person’s name, etc), just as if I’d used C033 for both
> lines.
>
>
>
> The first couple of times I tried this, I had all the posting info
> included (columns R and up) – but then I had to keep unposting them, so I
> got rid of that.  I figured if I could get this to work, I could manually
> post later (just 2 invoices).
>
>
>
> Also – so you know, I’ve tried this on more than one PC – first at work,
> then at home.  Both use Win-7 & Office-10.  Same result.
>
>
>
> My import file was made with MS Excel and saved in CSV (Comma delimited)
> (*.csv) file type.  MS Excel is not perfect at CSV files as if I don’t put
> in invoice numbers, Excel deletes the first column (which is blank) when it
> saves the file.  HEY - Light bulb coming on – maybe if I keep the header
> row, Excel won’t delete the first column, and GnuCash might generate the
> invoice numbers.  I gotta give that a try.  Thx.
>
>
>
> One related thing – is there a way to DELETE the bad invoices I’ve created
> by trying to import?  I could not see how to delete unposted invoices that
> I would like to get rid of.
>
>
>
> Thanks Nelson – I appreciate your help.  Please check out my import file
> and see if you spot anything amiss.
>
> Bruce
>
>
>
> *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com]
> *Sent:* Wednesday, May 24, 2017 12:54 PM
> *To:* Bruce Danielson
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: Issues with Importing Invoices
>
>
>
> Bruce,
>
>
>
> I've attached a sample of an invoice import file that I recently prepared
> and successfully loaded up.
>
> If you change the "memberidn" to match your customer ID's and also change
> the account names then it should work for you.
>
>
>
> The key thing for me is sorting my source data by Member ID and then by
> Date, before setting the ID column with the invoice number. Note how you
> can have two lines with the same ID number one after the other - this
> results in a multi-line invoice being imported.
>
>
>
> I usually leave the header row in my source data - gnucash just spits it
> out anyway. It only ever rejects data for me if the memberID does not match
> an existing customer.
>
>
>
> I'm pretty sure I've imported data like this without setting the ID column
> at all, and Gnucash sets the ID number based on the number range set up in
> the settings - Menu path File - Properties - Counters.
>
>
>
>
>
> Hope this helps,..
>
>
>
>
> Thanks & Regards,
>
>
> Nelson
>
>
>
> On Wed, May 24, 2017 at 12:58 PM, Bruce Danielson <daniels...@logroom.com>
> 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 water - since our employer won't spring for the water -
> pardon the pun).  I have it setup as a business type of accounting.  I'm
> trying this on the smaller &a

Re: Issues with Importing Invoices

[Nelson Handcock]

Bruce,

I've attached a sample of an invoice import file that I recently prepared
and successfully loaded up.
If you change the "memberidn" to match your customer ID's and also change
the account names then it should work for you.

The key thing for me is sorting my source data by Member ID and then by
Date, before setting the ID column with the invoice number. Note how you
can have two lines with the same ID number one after the other - this
results in a multi-line invoice being imported.

I usually leave the header row in my source data - gnucash just spits it
out anyway. It only ever rejects data for me if the memberID does not match
an existing customer.

I'm pretty sure I've imported data like this without setting the ID column
at all, and Gnucash sets the ID number based on the number range set up in
the settings - Menu path File - Properties - 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 water - since our employer won't spring for the water -
> pardon the pun).  I have it setup as a business type of accounting.  I'm
> trying this on the smaller & newer of the clubs I manage.  Weird I know,
> but
> I want to make this work.  I am also treasurer of a non-profit, I wish I'd
> known about GnuCash before I went & bought QB.  But OK, for the water club
> -
>
>
>
> I was able to import a bunch of customers (club members) via a csv file I
> made from an Excel roster.  So far, so good.  I have an asset account
> called
> Cash On Hand which monthly dues will pay into, and water bills will be paid
> out of.  And I have only one Vendor (Sparkletts) and one applicable expense
> account (bottled water).
>
>
>
> Since I don't really want to produce 36 separate invoices each month for
> member dues, one at a time, I am hoping to find a way to sort of batch
> generate invoices.  I have tried numerous times making a small 2 line csv
> file from an excel table to import, and have run into several issues.  It
> is
> only 2 lines now because I have 2 customers that are late paying for May,
> so
> I thought I'd try this out on them.
>
>
>
> One issue is that if I leave the ID field blank, "import" does not self
> generate invoice ID's - but instead just ignores the lines.  OK - no
> worries, I can plug in invoice numbers in the excel table, that's not too
> much work.  The more serious issue is this, although the specific customers
> are C033 and C034 - when I import, both invoices generated are applied to
> one of the customers only (C033) and none to the other customer (C034).  I
> generate 2 invoices, but both for the same customer (C033).
>
>
>
> Import Invoices is not reading the customer (Owner ID) in the table and
> applying to the correct customer.  This I do not know how to work around.
> I'm looking for ideas or anything I may be doing wrong.  I have upgraded to
> the latest version 2.6.16 (rev 509ce16+) BTW.
>
>
>
> Really, if I cannot batch-make invoices, I can't make use of GnuCash.
> Trying to generate 36 (or so) individual invoices on the 1st of each month
> is not going to work for me.
>
>
>
> I know this is probably a better application for just using Excel, but I
> wanted to give this a try.  Actually if I could figure a way to batch email
> my batch prepared invoices, this would be totally awesome.
>
>
>
> Any feedback is appreciated.  I will be away from this email address for a
> couple of days, so no big emergency.
>
> Thanks,
>
>
>
> Buster
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>
id,date_opened,owner_id,billing_id,notes,date,description,action,account,quantity,price, disc_type, disc_how, discount, taxable, taxincluded, tax_table,date_posted,due_date, account_posted,memo_posted,accu_splits
2016-1755,10/01/2017,memberid1,,,10/01/2017,GST Free Stock Purchases,,Income:Membership Fees,1,50Y,Y,GST Inclusive Sales,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1756,10/01/2017,memberid2,,,10/01/2017,GST Free Stock Purchases,,Income:Sales,1,11.8,,,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Applicable Stock Purchases,,Income:Sales,1,7.19Y,Y,GST Inclusive Sales,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,121.02,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1758,17/01/2017,memberid4,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,70.64,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y