Payment Processors
Robert Heller
heller at deepsoft.com
Thu Aug 2 06:55:09 EDT 2012
At Thu, 2 Aug 2012 03:25:00 -0500 Roi Ravid <roirav1 at gmail.com> wrote:
>
> **Hi,
>
> What is the best way to handle Payment Processors (PayPal, Payza,
> SolidTrust Pay, etc.)?
> I created Assets:Current Assets account for each one, Income: Gross Sales
> account for each one, and Expenses: Bank Service Charge sub account for
> each one.
> Is this the right way of doing it? I find it that it takes me 5 times
> longer to enter the split transactions now. Is there an easier way of doing
> it?
They are effectively just a king of bank account (eg like a checking
account), so you would set them up as such . You should not have a
'Income' account for *each* of them -- you would only have one (set of)
'Income' account(s) (eg gross sales, services rendered, etc.) -- these
are just 'transfer accounts' where the income transfers in. Yes, you
would have sub accounts for service charges.
>
>
> Thanks,
>
> Roi
>
> On Wed, Aug 1, 2012 at 11:00 AM, <gnucash-user-request at gnucash.org> wrote:
>
> > Send gnucash-user mailing list submissions to
> > gnucash-user at 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-request at gnucash.org
> >
> > You can reach the person managing the list at
> > gnucash-user-owner at 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: Importing both sides of a transaction (Derek Atkins)
> > 2. Re: Cash Based Reports (Derek Atkins)
> > 3. Re: assistance with database error? (Derek Atkins)
> > 4. Re: OFX file example (Richard Thomas)
> > 5. Re: Importing both sides of a transaction (Ewan Slater)
> > 6. API on Windows (Ewan Slater)
> > 7. Re: Customer refund (scar)
> > 8. Re: Finance::Quote fails to update after Mountain Lion OS/X
> > install (davelist at mac.com)
> > 9. Re: assistance with database error? (John Ralls)
> > 10. Re: API on Windows (John Ralls)
> > 11. Re: Is there a way to turn off quickfill? (oaxaca)
> > 12. Re: importing data (tereque)
> > 13. Re: OFX file example (Derek Atkins)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Tue, 31 Jul 2012 14:13:01 -0400
> > From: Derek Atkins <warlord at MIT.EDU>
> > To: Ewan Slater <ewan.slater at googlemail.com>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: Importing both sides of a transaction
> > Message-ID: <sjmr4rrer4i.fsf at mocana.ihtfp.org>
> > Content-Type: text/plain; charset=us-ascii
> >
> > Hi,
> >
> > Ewan Slater <ewan.slater at googlemail.com> writes:
> >
> > > Hi Derek,
> > >
> > > Thanks.
> > >
> > > Adding the line LExpenses:Car:Petrol adds the other side of the split.
> > >
> > > A little further digging around the QIF specification would suggest that
> > I
> > > should be able to use something like:
> > > SLiabilities:Mastercard
> > > EAccount to be charged
> > > $-50
> > > SExpenses:Car:Petrol
> > > EAccount to be paid
> > > $50
> > >
> > > But a freaky thing happens - the account that gets charged (and indeed
> > > created) is Equities:Retained Earnings
> > >
> > > Bizarre.
> >
> > Not at all. You are saying here that you have a multi-split transaction
> > between the "current" account, L:Mc, and Ex:C:Petrol.. But it's a
> > zero-sum transaction. I don't think this is what you want to do. Just
> > have a QIF file, creditcard.qif:
> >
> > !Type:CCard
> > D1/1/2012
> > PEsso
> > T50
> > LExpenses:Car:Petrol
> >
> > Then just assign QIF Account creditcard to Liabilities:Mastercard. Done.
> >
> > > In any case the L code gets me a long way towards where I want to be.
> >
> > Yep. :)
> >
> > > Thanks again,
> > >
> > > Ewan
> >
> > -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
> > warlord at MIT.EDU PGP key available
> >
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Tue, 31 Jul 2012 14:14:28 -0400
> > From: Derek Atkins <warlord at MIT.EDU>
> > To: Newto Gnucash <newtognucash at gmail.com>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: Cash Based Reports
> > Message-ID: <sjmmx2fer23.fsf at mocana.ihtfp.org>
> > Content-Type: text/plain; charset=us-ascii
> >
> > Hi,
> >
> > Newto Gnucash <newtognucash at gmail.com> writes:
> >
> > > I have just moved from MYOB to GnuCash. My company reports GST on a
> > > cash basis, rather than accrual basis. I understand that GnuCash
> > > works on an accrual basis, but in my trawling through mailing list
> > > archives, etc. I have noticed comments on the need for a report that
> > > will show income and expenditure for a period on a cash basis rather
> > > than accrual. Has there been any progress made on this? Or has
> >
> > The business features (Invoicing, etc) work on an accrual basis. But
> > nothing says you have to use them. If you don't then you can be
> > completely cash. If, however, you DO use the invoice features, then
> > yes, you'll need to manually map outstanding invoices to convert from
> > Accrual to Cash, and no, GnuCash does not yet have that functionality.
> >
> > > anyone made one for themself that they are happy to share? What I'm
> > > after is preferably something similar to the MYOB GST-Detail-Cash
> > > report. That would group the period's income and expenditure
> > > according to tax codes (i.e. tax tables), It would show the total
> > > amount spent/received on each transaction it was reporting, and
> > > separately show how much GST (if any) had been collected or paid on
> > > the transaction.
> > >
> > > If anyone could help with this I would be very grateful.
> > >
> > > GnuCash Australian User
> >
> > > 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
> > warlord at MIT.EDU PGP key available
> >
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Tue, 31 Jul 2012 14:16:08 -0400
> > From: Derek Atkins <warlord at MIT.EDU>
> > To: Josh Quinnell <quin0167 at umn.edu>
> > Cc: Fred.Bone at dial.pipex.com, gnucash-user at gnucash.org
> > Subject: Re: assistance with database error?
> > Message-ID: <sjmipd3eqzb.fsf at mocana.ihtfp.org>
> > Content-Type: text/plain; charset=us-ascii
> >
> > Hi,
> >
> > Josh Quinnell <quin0167 at umn.edu> writes:
> >
> > > I have now manually gone through the date tags and there does not seem to
> > > be any invalid data. All tags are 2009 - 2012. All prior databases saved
> > > under 2.4.10 for windows share this problem. Does anyone have other
> > > suggestions or methods to import an old database into WIN 2.4.10 to
> > > circumvent this problem? Thanks
> > >
> > > Trace:
> > > * 19:59:06 WARN <qof.engine> [guid_init()] only got 1869 bytes.
> > > The identifiers might not be very random.
> > > * 19:59:30 WARN <gnc.app-utils> Could not spawn perl: Failed to execute
> > > child process (No such file or directory)
> > > * 22:30:26 CRIT <qof> qof_strftime: assertion `tm' failed
> > > * 22:30:26 CRIT <gnc.import> [TransactionGetTokens()]
> > TransactionGetTokens:
> > > error, strftime failed
> >
> > Perhaps we need to add more data to these critical messages, like a line
> > number, raw data, or something else that would help lead to the problem.
> >
> > In this case, maybe the problem is in the slots? I'm only guessing, but
> > clearly there is something bad going on here. Can you check in the
> > slots tables for dates before 1970?
> >
> > -derek
> >
> > > On Sat, Jul 28, 2012 at 7:01 PM, Josh Quinnell <quin0167 at umn.edu> wrote:
> > >
> > >> Yes. There appears to be no invalid dates under the tag <ts:date> unless
> > >> they are invalid characters or something.
> > >>
> > >>
> > >> On Sat, Jul 28, 2012 at 6:30 PM, Fred Bone <Fred.Bone at dial.pipex.com
> > >wrote:
> > >>
> > >>> On 28 July 2012 at 14:13, Josh Quinnell said:
> > >>>
> > >>> > I have searched for the strings " date>0" and "date>1" to find for
> > years
> > >>> > below 1970 without any luck. Do you have any suggestions for finding
> > a
> > >>> > date before 1970?
> > >>>
> > >>> The usual bad date (from others' reports: I haven't seen one myself)
> > >>> seems to be 1969-12-31 (i.e. one day before Unix epoch). Have you tried
> > >>> looking for that, specifically?
> > >>>
> > >>>
> > >>
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at 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.
> > >
> > >
> >
> > --
> > 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
> > warlord at MIT.EDU PGP key available
> >
> >
> > ------------------------------
> >
> > Message: 4
> > Date: Tue, 31 Jul 2012 21:09:22 +0100
> > From: Richard Thomas <richdthomas at gmail.com>
> > To: Derek Atkins <warlord at mit.edu>
> > Cc: Users Gnucash <gnucash-user at gnucash.org>
> > Subject: Re: OFX file example
> > Message-ID:
> > <CALO6cPVXPfVzvj=
> > YGRnq1+aAr1uwG50gOq+DjqFcwQyPRjhTNw at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi Derek,
> >
> > My choice of file format to import is down to the way I use Gnucash and my
> > online banking.
> >
> > I hand enter my transactions and then import from my online banking data.
> >
> > I have now written a script to convert my bank's CSV file format to OFX
> > file format.
> >
> > It's producing OFX files that Gnucash is understanding, which I'm really
> > pleased with.
> >
> > Thanks,
> >
> > Richard.
> >
> > On 30 July 2012 23:00, Derek Atkins <warlord at mit.edu> wrote:
> >
> > > Hi,
> > >
> > > Richard Thomas <richdthomas at gmail.com> writes:
> > >
> > > > Hi
> > > >
> > > > Would anybody be able to point me in the direction of a really simple
> > OFX
> > > > file example please.
> > > >
> > > > Below is an example of a QIF file, to show the type of transaction I
> > want
> > > > to import as OFX:
> > > >
> > > > !Type:Bank
> > > > D19/07/2012
> > > > NTST PRICHARD ENTERPRISES
> > > > Cc
> > > > T-12.34
> > > > ^
> > >
> > > There is no such thing as a "really simple OFX file". OFX is a fairly
> > > complicated SGML protocol. Why do you want to convert a nice, simple
> > > QIF transaction to the complicated OFX format? The only benefits of
> > > OFX, IMHO, are the ability to do automated duplicate-import detection
> > > (using the account-unique OFX FITID) and the Bayesian account mapping.
> > > OTOH QIF lets you do mass assignment of transactions with the same Payee
> > > or Memo.
> > >
> > > > Thanks in advance.
> > > >
> > > > Richard.
> > >
> > > > 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
> > > warlord at MIT.EDU PGP key available
> > >
> >
> >
> > ------------------------------
> >
> > Message: 5
> > Date: Tue, 31 Jul 2012 13:17:48 +0100
> > From: Ewan Slater <ewan.slater at googlemail.com>
> > To: Derek Atkins <warlord at mit.edu>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: Importing both sides of a transaction
> > Message-ID:
> > <
> > CAHSJW-B5QvoczdiYHFMD2P5xG-MPdyUwGvZYOZw_X_yOrSH71g at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi Derek,
> >
> > Thanks.
> >
> > Adding the line LExpenses:Car:Petrol adds the other side of the split.
> >
> > A little further digging around the QIF specification would suggest that I
> > should be able to use something like:
> > SLiabilities:Mastercard
> > EAccount to be charged
> > $-50
> > SExpenses:Car:Petrol
> > EAccount to be paid
> > $50
> >
> > But a freaky thing happens - the account that gets charged (and indeed
> > created) is Equities:Retained Earnings
> >
> > Bizarre.
> >
> > In any case the L code gets me a long way towards where I want to be.
> >
> > Thanks again,
> >
> > Ewan
> >
> > On 30 July 2012 23:45, Derek Atkins <warlord at mit.edu> wrote:
> >
> > > Hi,
> > >
> > > Ewan Slater <ewan.slater at googlemail.com> writes:
> > >
> > > > Hi,
> > > >
> > > > I'm trying to automate pulling work expenses into GnuCash.
> > > >
> > > > I can download my bank / credit card information as QIF or OFX.
> > > >
> > > > I can download my work expenses in CSV format.
> > > >
> > > > What I would like to do is to merge the data from the bank with that
> > for
> > > > the expenses application so I can then import one file which contains
> > > both
> > > > sides of the transaction.
> > > >
> > > > Can anyone tell me how to represent both sides of the transaction in
> > QIF
> > > or
> > > > OFX, so that the debit and credit sides of the transaction can be
> > > assigned
> > > > automatically to the correct account please?
> > > >
> > > > If I know how to represent it in either file format I can then write an
> > > app
> > > > to merge the data for import.
> > >
> > > With QIF you need to supply a multi-account QIF file. It's slightly
> > > more complicated, and I don't know of any examples offhand. IIRC you
> > > need to supply some !Account settings for the various QIF accounts, and
> > > then for each account you supply the transactions. Then you can use
> > > L[OtherAccount] to specify that a transaction goes from the current
> > > account to the other account. The importer will then make this happen.
> > >
> > > Note that this only works between Assets and Liabilities.
> > >
> > > If you want to specify an Income/Expense account then you can use
> > > LCategory.
> > >
> > > In both cases LCategory and L[Account] you have the ability to map the
> > > QIF Account and QIF Categories to GnuCash accounts.
> > >
> > > Hope this helps,
> > >
> > > > Cheers,
> > > >
> > > > Ewan
> > >
> > > > 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
> > > warlord at MIT.EDU PGP key available
> > >
> >
> >
> > ------------------------------
> >
> > Message: 6
> > Date: Tue, 31 Jul 2012 13:27:59 +0100
> > From: Ewan Slater <ewan.slater at googlemail.com>
> > To: gnucash-user at gnucash.org
> > Subject: API on Windows
> > Message-ID:
> > <CAHSJW-DPzGj9uh=o=L435MT7=
> > BYtHB3+fkZZ6ro8k_phUixw-A at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi,
> >
> > I am running GnuCash 2.4.10 on Windows 7 (standard executable download).
> >
> > I am interested in using the API (or at least trying to).
> >
> > Do I have to build GnuCash from source to be able to access the API, or are
> > the libraries available pre - compiled for Windows (ideally shipped with
> > the binaries)?
> >
> > Looking here http://wiki.gnucash.org/wiki/C_API seems to imply I need to
> > build from source.
> >
> > I don't want to make any mods to GnuCash itself at this point, I'd just
> > like to be able to call the API from a Windows program written in C++
> > (currently using MS Visual Studio Express 2008 / Visual C++). So if I can
> > avoid building the whole thing from scratch I would prefer not to.
> >
> > Cheers,
> >
> > Ewan
> >
> >
> > ------------------------------
> >
> > Message: 7
> > Date: Tue, 31 Jul 2012 15:08:25 -0700
> > From: scar <scar at drigon.com>
> > To: gnucash-user at lists.gnucash.org
> > Subject: Re: Customer refund
> > Message-ID: <jv9l0q$3a8$1 at dough.gmane.org>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Keith Fetterman @ 07/27/2012 08:29 AM:
> > > I
> > > was able to find the thread of emails on nabble:
> > >
> > >
> > http://gnucash.1415818.n4.nabble.com/Credit-Note-Alternatives-tt4397807.html
> > >
> > > Take a look at Geert's and Bob's responses.
> >
> > thanks but i'm not sure i'm smart enough to figure this out.
> >
> > so i created an invoice with a negative quantity for "Rent" from the
> > Income:Rent income account, and then i add another line and i used
> > Assets:Refunds for the Income Account to cancel out that.
> >
> > then i added a new entry for my physical check that i'm sending to the
> > customer using my Checking Account and the Assets:Refunds account. this
> > zeroes out the Assets:Refunds account but my Customer Report still shows
> > a credit.
> >
> > if i try to process a payment for the credit, instead it just doubles
> > the credit due in the Customer Report
> >
> >
> >
> >
> >
> > ------------------------------
> >
> > Message: 8
> > Date: Tue, 31 Jul 2012 18:10:59 -0400
> > From: davelist at mac.com
> > To: Steve Drach <drach at itsit.org>
> > Cc: Derek Atkins <warlord at MIT.EDU>, "gnucash-user at gnucash.org List"
> > <gnucash-user at gnucash.org>
> > Subject: Re: Finance::Quote fails to update after Mountain Lion OS/X
> > install
> > Message-ID: <764AA28B-5FE9-4CD2-A76E-1ED593112351 at mac.com>
> > Content-Type: text/plain; CHARSET=US-ASCII
> >
> >
> > On Jul 30, 2012, at 10:13 PM, Steve Drach <drach at itsit.org> wrote:
> >
> > >
> > > On Jul 30, 2012, at 3:46 PM, Derek Atkins <warlord at MIT.EDU> wrote:
> > >
> > >>>
> > >>> I looked up OSStatus error 100030, and it 's because it's a read only
> > file system. So I copied F::Q to my home directory and tired again. This
> > time it seemed to go further. The dialog I get says "The variable
> > gnc_fq_update is not defined." It gives me an edit button and an ok
> > button. Ok doesn't do anything obvious. Edit brings up an AppleScript
> > editor with the code required to start F::Q update. That is, this code:
> > >>
> > >> Did you copy GnuCash.App from the DMG to your Applications folder?
> > >
> > > Yes, I had done that. The trick is also moving F::Q update to the
> > Applications folder too.
> >
> > On one of my two Macs, it installed fine and I don't think I copied the
> > F::Q update out of the dmg file. On the other, the installer complained it
> > couldn't find the SSL libraries. I tried entering /usr and /usr/lib but it
> > still didn't work. I finally ended up copying the /Library/Perl/5.12
> > directory (and all its subdirectories) from the machine where it worked to
> > the one where it didn't and then I use the option to get the stock quotes
> > fine. Just posting this in case it helps anyone or if anyone knows why it
> > couldn't find the SSL libraries. Actually, it just hit me. I think I had
> > re-installed Xcode 4.4 but hadn't run its preference option to install the
> > command-line tools yet.
> >
> > Dave
> >
> >
> >
> > ------------------------------
> >
> > Message: 9
> > Date: Tue, 31 Jul 2012 15:29:15 -0700
> > From: John Ralls <jralls at ceridwen.us>
> > To: Josh Quinnell <quin0167 at umn.edu>
> > Cc: Fred.Bone at dial.pipex.com, gnucash-user at gnucash.org
> > Subject: Re: assistance with database error?
> > Message-ID: <2B32FF96-F3D2-4C30-B19A-12B401B40DBD at ceridwen.us>
> > Content-Type: text/plain; charset=us-ascii
> >
> >
> > On Jul 31, 2012, at 3:00 AM, Josh Quinnell <quin0167 at umn.edu> wrote:
> >
> > > I have now manually gone through the date tags and there does not seem to
> > > be any invalid data. All tags are 2009 - 2012. All prior databases saved
> > > under 2.4.10 for windows share this problem. Does anyone have other
> > > suggestions or methods to import an old database into WIN 2.4.10 to
> > > circumvent this problem? Thanks
> > >
> > > Trace:
> > > * 19:59:06 WARN <qof.engine> [guid_init()] only got 1869 bytes.
> > > The identifiers might not be very random.
> > > * 19:59:30 WARN <gnc.app-utils> Could not spawn perl: Failed to execute
> > > child process (No such file or directory)
> > > * 22:30:26 CRIT <qof> qof_strftime: assertion `tm' failed
> > > * 22:30:26 CRIT <gnc.import> [TransactionGetTokens()]
> > TransactionGetTokens:
> > > error, strftime failed
> >
> > Wait a minute, *import*? You don't import gnucash databases, you open them
> > with File>Open. Import is for foreign files like QIF or OFX.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> >
> > ------------------------------
> >
> > Message: 10
> > Date: Tue, 31 Jul 2012 15:35:37 -0700
> > From: John Ralls <jralls at ceridwen.us>
> > To: Ewan Slater <ewan.slater at googlemail.com>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: API on Windows
> > Message-ID: <26F3592A-0D6C-44D9-81AB-D7C4934C4B59 at ceridwen.us>
> > Content-Type: text/plain; charset=us-ascii
> >
> >
> > On Jul 31, 2012, at 5:27 AM, Ewan Slater <ewan.slater at googlemail.com>
> > wrote:
> >
> > > Hi,
> > >
> > > I am running GnuCash 2.4.10 on Windows 7 (standard executable download).
> > >
> > > I am interested in using the API (or at least trying to).
> > >
> > > Do I have to build GnuCash from source to be able to access the API, or
> > are
> > > the libraries available pre - compiled for Windows (ideally shipped with
> > > the binaries)?
> > >
> > > Looking here http://wiki.gnucash.org/wiki/C_API seems to imply I need to
> > > build from source.
> > >
> > > I don't want to make any mods to GnuCash itself at this point, I'd just
> > > like to be able to call the API from a Windows program written in C++
> > > (currently using MS Visual Studio Express 2008 / Visual C++). So if I
> > can
> > > avoid building the whole thing from scratch I would prefer not to.
> > >
> >
> > The libraries are of course in the downloaded package -- it wouldn't work
> > otherwise. They're in the same directory as gnucash itself. What's not
> > there is the headers, so you'll need to get the sources and either use them
> > from there or extract the headers to somewhere convenient.
> >
> > Note, however, that Gnuacsh is built with gcc in a MinGW/MSYS environment.
> > No effort has been made to get them to work with MSVC, so you're on your
> > own for that part. Good Luck.
> >
> > Regards,
> > John Ralls
> >
> >
> > ------------------------------
> >
> > Message: 11
> > Date: Tue, 31 Jul 2012 15:51:48 -0700 (PDT)
> > From: oaxaca <freerain at gmx.at>
> > To: gnucash-user at gnucash.org
> > Subject: Re: Is there a way to turn off quickfill?
> > Message-ID: <1343775108721-4655964.post at n4.nabble.com>
> > Content-Type: text/plain; charset=us-ascii
> >
> >
> > Derek Atkins-3 wrote
> > >
> > > On Mon, January 17, 2011 4:43 pm, edodd@ wrote:
> > >
> > >> the auto fill for me (still 2.2.9) makes a decision after two
> > characters,
> > >> and then the third character i type appears at the end of the name
> > >> say "country energy" and "coles" appear in my transaction list, as well
> > >> as
> > >> "coles express" to which i append a suburb name
> > >> so type 'co' > decision made according to last entry in list.
> > >> i'm still typing away so i get "country energyles" when i'm typing
> > >> "coles"
> > >
> > > I'm pretty sure this bug has long-since been fixed. I remember seeing
> > > this a long time ago but I've not experienced it in a while. Try 2.4.0?
> > >
> >
> > I have this bug with Gnucash 2.4.11 ("This copy was built from r22264M on
> > 2012-07-13")
> > on Fedora 17 KDE 4.8.4 Linux 3.4.6. Should I report a bug or is this a
> > known
> > issue/a new "feature"?
> > I could not find anything newer than this thread.
> >
> > oaxaca
> >
> >
> >
> >
> > --
> > View this message in context:
> > http://gnucash.1415818.n4.nabble.com/Is-there-a-way-to-turn-off-quickfill-tp3220017p4655964.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> >
> >
> > ------------------------------
> >
> > Message: 12
> > Date: Wed, 01 Aug 2012 09:41:02 +0800
> > From: tereque <tereque at gmail.com>
> > To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> > Subject: Re: importing data
> > Message-ID: <5018892E.1030707 at gmail.com>
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> >
> > hi
> >
> > On 31/07/2012 06:17, Derek Atkins wrote:
> > > "David T." <sunfish62 at yahoo.com> writes:
> > >
> > >> Tereque--
> > >>
> > >> You surmise (correctly, I believe) that there is no way to import
> > Gnucash data directly into Gnucash, and your spreadsheet solution is
> > probably as good a way as any to achieve your goals.
> > >
> > > You could try to use GnuCash2QIF to convert an existing GnuCash file
> > > into QIF and then import it, but you would have to clear out the
> > > transactions between each run or you'll have to match duplicates every
> > > time from all previous imports.
> > didn't work on first sight (crashing in the process). Will take a closer
> > look later
> >
> >
> > >> That said, I believe that you are seeking to have Gnucash provide you
> > with more of an enterprise solution than Gnucash was designed to provide.
> > >> Gnucash is primarily meant for single users;requests for it to provide
> > more robust multi-user access (as by allowingmultiple >> file import, or by
> > allowing multiple simultaneous users)
> > have met with little enthusiasm.
> > >
> > > Yeah, GnuCash really was not designed to solve your problem. It was
> > > originally for personal use, and then later added SBHB support, but it
> > > was always designed with "everyone with access to the books has full
> > > access to all data". It's unlikely that will change anytime soon.
> >
> > I totally could understand arguments being 'there are no sufficient
> > capacities to go into that further yet' or 'developers would not want to
> > go into that because ...' but 'it was meant to be for single users only
> > in the first place...' sounds a little bit weird to me.
> >
> > Having the whole 'business' section is a statement for meaning
> > 'business' in my eyes. But what I read through the lines somehow is that
> > people seem to not really recognize that as a fact, but more as if it
> > would have been 'a little playing around' but not meaning it really
> > serious. And I guess there is much more work into the business section
> > then just' playing a little around' so it might be worth to go continue
> > working on that (I mean in a way not to say that it is just not made for
> > business whenever a problem with this is posted). I guess a more
> > confident sounding approach towards the 'business' section would be good.
> >
> > My impressions on that might be not be reflecting the real situation for
> > 100% as I am following this since a very short time only.
> >
> > > Your other option is to look at additional software (like Excel, but
> > > perhaps something better) for transaction entry which can then be
> > > imported via e.g. QIF.
> >
> > can you explain a little how that would work? What would be the 'like
> > Excel but better' software you refer to? How would I get to produce a
> > QIF file out of Excel (or the unnamed 'but better' software)?
> >
> > many thanks
> > Bela
> >
> >
> > ------------------------------
> >
> > Message: 13
> > Date: Wed, 01 Aug 2012 11:25:39 -0400
> > From: Derek Atkins <warlord at MIT.EDU>
> > To: Richard Thomas <richdthomas at gmail.com>
> > Cc: Users Gnucash <gnucash-user at gnucash.org>
> > Subject: Re: OFX file example
> > Message-ID: <sjmboiueirw.fsf at mocana.ihtfp.org>
> > Content-Type: text/plain; charset=utf-8
> >
> > Hi,
> >
> > Richard Thomas <richdthomas at gmail.com> writes:
> >
> > > Hi Derek,
> > >
> > > My choice of file format to import is down to the way I use Gnucash and
> > my
> > > online banking.
> > >
> > > I hand enter my transactions and then import from my online banking data.
> > >
> > > I have now written a script to convert my bank's CSV file format to OFX
> > file
> > > format.
> > >
> > > It's producing OFX files that Gnucash is understanding, which I'm really
> > > pleased with.
> >
> > What is your source of FITID for the OFX?
> >
> > > Thanks,
> > >
> > > Richard.
> >
> > -derek
> >
> > > On 30 July 2012 23:00, Derek Atkins <warlord at mit.edu> wrote:
> > >
> > > Hi,
> > >
> > > Richard Thomas <richdthomas at gmail.com> writes:
> > >
> > > > Hi
> > > >
> > > > Would anybody be able to point me in the direction of a really
> > simple
> > > OFX
> > > > file example please.
> > > >
> > > > Below is an example of a QIF file, to show the type of transaction
> > I
> > > want
> > > > to import as OFX:
> > > >
> > > > !Type:Bank
> > > > D19/07/2012
> > > > NTST PRICHARD ENTERPRISES
> > > > Cc
> > > > T-12.34
> > > > ^
> > >
> > > There is no such thing as a "really simple OFX file". ?OFX is a
> > fairly
> > > complicated SGML protocol. ?Why do you want to convert a nice, simple
> > > QIF transaction to the complicated OFX format? ?The only benefits of
> > > OFX, IMHO, are the ability to do automated duplicate-import detection
> > > (using the account-unique OFX FITID) and the Bayesian account
> > mapping.
> > > OTOH QIF lets you do mass assignment of transactions with the same
> > Payee
> > > or Memo.
> > >
> > > > Thanks in advance.
> > > >
> > > > Richard.
> > >
> > > > 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
> > > ? ? ? ?warlord at MIT.EDU ? ? ? ? ? ? ? ? ? ? ? ?PGP key available
> > >
> >
> > --
> > 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
> > warlord at MIT.EDU PGP key available
> >
> >
> >
> > ------------------------------
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >
> >
> > End of gnucash-user Digest, Vol 113, Issue 1
> > ********************************************
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
--
Robert Heller -- 978-544-6933 / heller at deepsoft.com
Deepwoods Software -- http://www.deepsoft.com/
() ascii ribbon campaign -- against html e-mail
/\ www.asciiribbon.org -- against proprietary attachments
More information about the gnucash-user
mailing list