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 problem? &

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

& 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 appropriat

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

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

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

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

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

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

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 <geert.gnuc...@kobaltwit.be> wrote: > Op donderdag

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: > Issue a

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

Re: Lock file issues

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 >

Re: Lock file issues

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-use

Re: Controlling Gnucash from 2 computers

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

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 <c...@bctonline.com> wrote: > Where can I find the file specification for creati

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

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

Re: Bank reconciliation history

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 v

Re: Vendor Bill - Invoice Entries

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

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

Re: Import Invoice problem

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,

Re: Import Invoice causes error

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, > >

Re: Issues with Importing Invoices

> > > 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 &

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