Payment Processors
Roi Ravid
roirav1 at gmail.com
Thu Aug 2 04:25:00 EDT 2012
**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?
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
> ********************************************
>
More information about the gnucash-user
mailing list