Re: [GNC] QIF File Format

[Charles Peter Avery]

Thanks Dave,

I tried the CTRL + SHIFT + Z but unfortunately this does not work for Reckon
Accounts Premier Edition 2017.

Charlie

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf Of
David Cousens
Sent: Thursday, 12 September 2019 5:50 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] QIF File Format

Charlie 

Have you tried to export as a QIF file as suggested in this link
https://community.reckon.com/reckon/topics/is-there-a-way-to-convert-data-to
-a-generic-known-format

as follows:

"When in Reckon Personal, if you click on CTRL + SHIFT + Z you will then
have a new menu in FILE > EXPORT where you can export a QIF file.

Regards, Robyn Kelly"


David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] QIF File Format

[Charles Peter Avery]

Hello Peter,
 
Thank you for your response. I have pasted in below the first few lines in the 
CSV file (I changed the amounts and details to protect the data) that was 
created by Reckon (Quicken).
 

Charles
 
From: Peter West [mailto:p...@pbw.id.au] 
Sent: Thursday, 12 September 2019 4:35 PM
To: CharlieRyde 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] QIF File Format
 
Hi Charlie,
 
The format of QIF files is discussed at this link:
https://en.wikipedia.org/wiki/Quicken_Interchange_Format
 
Does your CSV file have a header line or lines?  If so, can you post them?
 
There seems to be a “Hide header” option when exporting from Reckon to CSV.  
Make sure that is not set when you export.
 
Peter
--
Peter West
p...@pbw.id.au  
“Woe to you, when all people speak well of you, for so their fathers did to the 
false prophets.”



On 12 Sep 2019, at 3:20 pm, CharlieRyde mailto:cav...@bigpond.net.au> > wrote:
 
I would appreciate your help and advice.
I am using Windows 10.  I have been using Reckon Accounts Premier Edition
2017 for the past 7 years. I have created a CSV file of all the general
ledger transactions through this time and I have purchased the CSV to QIF
software conversion tool.
I would like to convert the CSV general ledger transaction to a QIF file and
import this into GnuCash. I do not know what the column layout in the CSV
file should be nor do I know what the QIF file format should be and I am
finding it very difficult to find decent documentation or tutorials for the
column layout of the CSV file and the record formats in the QIF file.
Would you be able to assist me please?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Upgrade Process

[Charles Peter Avery]

Hello,
 
I am using Ver 3.5 and looking to upgrade to Ver 3.7.  Would you be able to
point me to the documentation for the upgrade process please?
 
Regards
Charles Avery
___
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] Include Account Numbers on Trial Balance Message-ID:

[Charles Peter Avery]

Thank you Stan.

I entered the account name as all text and I have entered an account number in 
a separate field. I am using Version 3.5 on Windows 10.


-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf Of 
Stan Brown
Sent: Tuesday, 23 July 2019 4:12 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Include Account Numbers on Trial Balance Message-ID:

By the way, you can enter the account number in lieu of the account
name, even if the account number isn't part of the name. (This is true
in 2.6.19; I assume it's still possible in 3.x.)


On 2019-07-22 11:36, Bruce Irving via gnucash-user wrote:
> I learned bookkeeping BC (before computer).  As a result, I do most of my 
> work in the General Journal.  When I set up the accounts in GC the account 
> number was part of the name, ie:  101 Cash on Hand.  This is one way of 
> getting the account numbers on the reports.  I use GC for both personal 
> accounts and a non-profit organization.  It is much better than the old excel 
> spreadsheets that I had been using.Bruce 


-- 

Regards,

Stan Brown

Tompkins County, New York, USA

http://BrownMath.com

http://OakRoadSystems.com

___
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] Include Account Numbers on Trial Balance

[Charles Peter Avery]

Stephen,

My accountant uses the file I provide him to import my GL transactions
directly into his ledger. I have been doing this for 12 years.



-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf Of
Stephen C. Camidge
Sent: Tuesday, 23 July 2019 3:04 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Include Account Numbers on Trial Balance

Your accountant does not need account numbers. He will have his own software
to generate his workpapers. He can work without them.

He may find it a convenience to have numbers to make sure that any adjusting
entries later given to you go to the right place, but that is optional.


On Mon, Jul 22, 2019, at 6:28 AM, Charles Peter Avery wrote:
> Thank you. I have raised an enhancement.
> I do not know how to respond to Liz as there is no email address? My reply
> to her is that it is a requirement from my accountant.
> 
> Charles Avery
> 
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf
Of
> Liz
> Sent: Monday, 22 July 2019 7:43 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Include Account Numbers on Trial Balance
> 
> On Mon, 22 Jul 2019 08:00:00 +
> Christopher Lam  wrote:
> 
> > This is not currently possible in the Trial Balance. Please file an
> > enhancement on https://bugs.gnucash.org/
> > 
> > 
> > On Sun, 21 Jul 2019 at 09:33, Charles Peter Avery
> >  wrote:
> > 
> > > Hello,
> > >
> > > I am a new user to GNUcash and I need to include account numbers on
> > > my trial
> > > balance report for my accountant and I cannot figure out how to do
> > > this. Would you be able to provide some advice please? I have
> > > established the accounting tree with account numbers. I am not a
> > > programmer and have no knowledge of programming languages.
> > >
> > > Regards
> > > Charles Avery
> > > _
> 
> Workaround
> Export to a file which you open in a spreadsheet
> Add in the account numbers...
> 
> It's slightly better than printing and writing them in.
> 
> Is this a requirement of your jurisdiction or of your accountant?
> 
> Liz
> ___
> 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.

___
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] Include Account Numbers on Trial Balance

[Charles Peter Avery]

Thank you. I have raised an enhancement.
I do not know how to respond to Liz as there is no email address?  My reply
to her is that it is a requirement from my accountant.

Charles Avery

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+cavery=bigpond.net...@gnucash.org] On Behalf Of
Liz
Sent: Monday, 22 July 2019 7:43 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Include Account Numbers on Trial Balance

On Mon, 22 Jul 2019 08:00:00 +
Christopher Lam  wrote:

> This is not currently possible in the Trial Balance. Please file an
> enhancement on https://bugs.gnucash.org/
> 
> 
> On Sun, 21 Jul 2019 at 09:33, Charles Peter Avery
>  wrote:
> 
> > Hello,
> >
> > I am a new user to GNUcash and I need to include account numbers on
> > my trial
> > balance report for my accountant and I cannot figure out how to do
> > this. Would you be able to provide some advice please? I have
> > established the accounting tree with account numbers.  I am not a
> > programmer and have no knowledge of programming languages.
> >
> > Regards
> > Charles Avery
> > _

Workaround
Export to a file which you open in a spreadsheet
Add in the account numbers...

It's slightly better than printing and writing them in.

Is this a requirement of your jurisdiction or of your accountant?

Liz
___
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] Include Account Numbers on Trial Balance

[Charles Peter Avery]

Hello,
 
I am a new user to GNUcash and I need to include account numbers on my trial
balance report for my accountant and I cannot figure out how to do this.
Would you be able to provide some advice please? I have established the
accounting tree with account numbers.  I am not a programmer and have no
knowledge of programming languages.
 
Regards
Charles Avery
___
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] Export Company file to Accountant

[Charles Peter Avery]

Hello,
 
I am currently using QuickBooks desktop and I want to convert to GnuCash
however at the end of each financial year I need to provide my accountant
with a company file that can be imported into Sage HandiSoft.  Is this
possible with GnuCash?
 
Regards
Charles Avery
___
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.