gnucash-user Digest, Vol 112, Issue 20

Kim Wood kim.wood at bigpond.net.au
Fri Jul 20 04:43:31 EDT 2012



Sent from my iPad

On 19/07/2012, at 2: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 CSV files (Richard Thomas)
>   2. Re: Importing CSV files (David Reiser)
>   3. Re: Importing CSV files (David Reiser)
>   4. Re: differentiate transactions in 'projects' (tereque)
>   5. Re: Invoices/Bills (tereque)
>   6. [newbie] Select lines in SLK file and set to category? (Gilles)
>   7. Re: simple formula problems (Derek Atkins)
>   8. Re: Invoices/Bills (Derek Atkins)
>   9. Re: [newbie] Select lines in SLK file and set to category?
>      (Derek Atkins)
>  10. Re: Expenses Bargraph (Derek Atkins)
>  11. Re: [newbie] Select lines in SLK file and set to category?
>      (Gilles)
> Hi,
> 
> Thanks for that, the N for the number record is working for me.
> 
> Would you be able to help me with the C record please?
> 
> What should the entire C line look like?
> 
> Thanks,
> 
> Richard.
> 
> On 17 July 2012 15:00, Derek Atkins <warlord at mit.edu> wrote:
> 
>> Hi,
>> 
>> Richard Thomas <richdthomas at gmail.com> writes:
>> 
>>> Hi Derek,
>>> 
>>> Thanks for getting back to me.
>>> 
>>> Here's a sample of the QIF file that my bank provides, I've deleted all
>> but
>>> the top transaction:
>>> 
>>> !Type:Bank
>>> D13/07/2012
>>> PSTARBUCKS CARD REL CD ****
>>> T-10.00
>>> ^
>>> 
>>> So, would I need to change the "T-10.00" to "C-10.00" and then add an
>> "N" line
>>> for my "num" field?
>> 
>> No, and Yes.  Yes, add an N line to specify the Num field.  But you also
>> need to add a C line to specify the Cleared Flag.  Do NOT change the T
>> (total) line.
>> 
>>> Thanks,
>>> 
>>> Richard.
>> 
>> -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
>> 
> 
>> From Wikipedia's presentation of the QIF spec:
> 
> C    Cleared status. Values are blank (not cleared), "*" or "c" (cleared) and "X" or "R" (reconciled).
> 
> --
> Dave Reiser
> dbreiser at me.com
> 
> 
> 
> On Jul 17, 2012, at 5:03 PM, Richard Thomas wrote:
> 
>> Hi,
>> 
>> Thanks for that, the N for the number record is working for me.
>> 
>> Would you be able to help me with the C record please?
>> 
>> What should the entire C line look like?
>> 
>> Thanks,
>> 
>> Richard.
>> 
>> On 17 July 2012 15:00, Derek Atkins <warlord at mit.edu> wrote:
>> 
>>> Hi,
>>> 
>>> Richard Thomas <richdthomas at gmail.com> writes:
>>> 
>>>> Hi Derek,
>>>> 
>>>> Thanks for getting back to me.
>>>> 
>>>> Here's a sample of the QIF file that my bank provides, I've deleted all
>>> but
>>>> the top transaction:
>>>> 
>>>> !Type:Bank
>>>> D13/07/2012
>>>> PSTARBUCKS CARD REL CD ****
>>>> T-10.00
>>>> ^
>>>> 
>>>> So, would I need to change the "T-10.00" to "C-10.00" and then add an
>>> "N" line
>>>> for my "num" field?
>>> 
>>> No, and Yes.  Yes, add an N line to specify the Num field.  But you also
>>> need to add a C line to specify the Cleared Flag.  Do NOT change the T
>>> (total) line.
>>> 
>>>> Thanks,
>>>> 
>>>> Richard.
>>> 
>>> -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
>>> 
>> _______________________________________________
>> 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.
> 
> 
> 
> On Jul 17, 2012, at 5:28 PM, David Reiser wrote:
> 
>> From Wikipedia's presentation of the QIF spec:
>> 
>> C    Cleared status. Values are blank (not cleared), "*" or "c" (cleared) and "X" or "R" (reconciled).
> 
> So it appears that the permitted C lines are:
> 
> Cc
> C*
> CR
> CX
> 
>> 
>> --
>> Dave Reiser
>> dbreiser at me.com
>> 
>> 
>> 
>> On Jul 17, 2012, at 5:03 PM, Richard Thomas wrote:
>> 
>>> Hi,
>>> 
>>> Thanks for that, the N for the number record is working for me.
>>> 
>>> Would you be able to help me with the C record please?
>>> 
>>> What should the entire C line look like?
>>> 
>>> Thanks,
>>> 
>>> Richard.
>>> 
>>> On 17 July 2012 15:00, Derek Atkins <warlord at mit.edu> wrote:
>>> 
>>>> Hi,
>>>> 
>>>> Richard Thomas <richdthomas at gmail.com> writes:
>>>> 
>>>>> Hi Derek,
>>>>> 
>>>>> Thanks for getting back to me.
>>>>> 
>>>>> Here's a sample of the QIF file that my bank provides, I've deleted all
>>>> but
>>>>> the top transaction:
>>>>> 
>>>>> !Type:Bank
>>>>> D13/07/2012
>>>>> PSTARBUCKS CARD REL CD ****
>>>>> T-10.00
>>>>> ^
>>>>> 
>>>>> So, would I need to change the "T-10.00" to "C-10.00" and then add an
>>>> "N" line
>>>>> for my "num" field?
>>>> 
>>>> No, and Yes.  Yes, add an N line to specify the Num field.  But you also
>>>> need to add a C line to specify the Cleared Flag.  Do NOT change the T
>>>> (total) line.
>>>> 
>>>>> Thanks,
>>>>> 
>>>>> Richard.
>>>> 
>>>> -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
>>>> 
>>> _______________________________________________
>>> 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.
>> 
>> _______________________________________________
>> 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.
> 
> 
> On 17/07/2012 22:06, Derek Atkins wrote:
>> Hi,
>> 
>> tereque <tereque at gmail.com> writes:
>> 
>>> hi,
>>> 
>>> here is another one....
>>> 
>>> all of my transactions should be linked to a project they are related
>>> to. Meaning we have a production for customer XYZ and the project has
>>> a number (let's say 8170). In the end I would like to have an overview
>>> of which payments had been moved for this project (incoming payments
>>> by customer, expenses, etc).
>>> 
>>> I wonder how I can do this best. I do not really want to set up a tree
>>> of accounts for each project as I still want to keep my general
>>> structure of expense accounts('Express costs', 'manufacturing' for
>>> example). Also I would not know how I could gather 'Income' and
>>> Expense'
>>> 
>>> How would I do that best? first thing that comes to mind is using the
>>> number' column in each account. Then I could make a search of this and
>>> have a report of all related transactions. But Maybe there is a better
>>> way to do this? A 'Job' seems only to gather several Invoices but can
>>> not applied to any transaction right?
>>> Alo I have not found a way to find all transaction matching a 'number'
>>> as it seems not workable to include all account in one search
>>> operation.
>> 
>> Unfortunately there is not a good way to do this.  The best way
>> currently would be to use a text tag in the Transaction Notes or
>> potentially the Action field.  Unfortunately the reports wont easily
>> collate for you.
>> 
>> Ideally GnuCash would have a "Tag" feature.
> 
> hi Derek,
> 
> thanks for the feedback which is not very satisfactory though ... I agree a "tag" feature would be probably a big enhancement to sort stuff as you need.
> 
> I found a workaround though. Actually I detected that the search function works different depending of where you start from. So I can add a project number to the 'Num' column or "Description"
> If you search for that number from within the accounts overview the search covers all accounts so you can at least find anything related in a search result (which is of course not the smoothest way to gather information but ....)
> 
> 
> 
> 
>>>> >>How do I cancel/delete the duplicated invoice, so that it doesn't show up in
>>>> >>the reports.
>> This is in the FAQ:
>> 
>> http://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_delete_an_Invoice.2C_Customer.2C_Vendor.2C_or_Employee.3F
> 
> trying to understand ... why would you not let these items be deletable? what is the idea behind such a restriction?
> 
> As a total beginner and NOT being an accountant at all it would seem to me to be 'normal' behavior of any software the let users add stuff when needed and delete it when not needed (anymore). You might want to be able to not be messed up with INVOICES/BILLS that have no function or an employee who had maybe left (or you just had added for testing functionality).
> Specially as being a beginner who is trying to sort out how to work best you just 'create' such stuff to see what it is. If you can not get rid of it anymore it seems weird somehow and you might think that this is a software error.
> 
> Hello
> 
> I've never used a cash management application before, and I simply would
> like to...
> 1. feed it my bank statements in SLK
> 2. Select all the lines that belong to a given type of expense and set them
> to the right category, eg. Gas or Groceries
> 3. After defining each line accordingly, have GnuCash show me how I spend my
> money, so I can see if I can save some.
> 
> I assume GnuCash can do this, but I'd rather check before spending time
> learning how to use it.
> 
> Thank you.
> 
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/newbie-Select-lines-in-SLK-file-and-set-to-category-tp4655787.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> 
> Brad Hajek <brad.hajek at gmail.com> writes:
> 
>> With or without spaces it doesn't calculate the formula and still gives the
>> imbalanced result. I will go ahead file a bug report as it sounds like this is
>> not expected behavior, at least to some folks including myself.
> 
> Thanks!
> 
>> Thanks.
> 
> -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
> 
> Hi,
> 
> tereque <tereque at gmail.com> writes:
> 
>>>>>>> How do I cancel/delete the duplicated invoice, so that it doesn't show up in
>>>>>>> the reports.
>>> This is in the FAQ:
>>> 
>>> http://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_delete_an_Invoice.2C_Customer.2C_Vendor.2C_or_Employee.3F
>> 
>> trying to understand ... why would you not let these items be
>> deletable? what is the idea behind such a restriction?
>> 
>> As a total beginner and NOT being an accountant at all it would seem
>> to me to be 'normal' behavior of any software the let users add stuff
>> when needed and delete it when not needed (anymore). You might want to
>> be able to not be messed up with INVOICES/BILLS that have no function
>> or an employee who had maybe left (or you just had added for testing
>> functionality).
>> Specially as being a beginner who is trying to sort out how to work
>> best you just 'create' such stuff to see what it is. If you can not
>> get rid of it anymore it seems weird somehow and you might think that
>> this is a software error.
> 
> It's not implemented because the logic to determine that it's safe to do
> is... hard.  There are so many interconnections between Invoices, Bills,
> line-items, Tax Tables, etc that making sure it's safe to delete an
> invoice without leaving dangling references was just ...  a lot of work.
> Work that I personally didn't want to do, and nobody else has come along
> with a way to do it securely.
> 
> Patches are, of course, always welcome.  But be warned, it's not a
> simple task.  Which is why it was never implemented, and why we have the
> "active" flag as a way to remove items from searches.
> 
> I'm sorry you don't like it.  You're welcome to help fix it.
> 
>> 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
> 
> Hi,
> 
> Gilles <codecomplete at free.fr> writes:
> 
>> Hello
>> 
>> I've never used a cash management application before, and I simply would
>> like to...
>> 1. feed it my bank statements in SLK
> 
> I've never heard of the SLK bank format.  Is it something you can
> translate to QIF or OFX?
> 
> Unless you mean the Slovak Koruna, which is SKK..  In which case, yes,
> you can set GnuCash to run in your local currency, and you can tell
> GnuCash in which currency to import transactions.
> 
>> 2. Select all the lines that belong to a given type of expense and set them
>> to the right category, eg. Gas or Groceries
> 
> The importers will allow you to assign each transaction to a particular
> income/expense account.  How this is done differs between the QIF and
> OFX importer.
> 
>> 3. After defining each line accordingly, have GnuCash show me how I spend my
>> money, so I can see if I can save some.
> 
> Yep.  Run an Income Statement (aka Profit and Loss) report to see where
> your money is coming from and going to.
> 
>> I assume GnuCash can do this, but I'd rather check before spending time
>> learning how to use it.
> 
> Of course.
> 
>> Thank you.
> 
>> 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
> 
> Liz,
> 
> Liz <edodd at billiau.net> writes:
> 
>> I'm asking the system to show me a subset of my expenses in a bar graph
>> The accounts are part of those selected automatically.
>> They are not in the main "expense tree" but the accounts are marked as
>> of expense type.
>> When I ask the system for the bar graph it tells me that either there
>> are no transactions or they are zero values.
>> Of course there are non-zero transactions in the period.
> 
> What are the currencies of the accounts in question?  If not your Report
> Currency, what do you have selected for your Quote Source?
> 
> Also, if they are not in your "main expense tree", what IS the parent of
> these accounts?
> 
>> Gnucash 2.4.10
>> Debian testing
>> "This copy was built from r21973 on 2012-03-05."
>> 
>> Anyone else struck this behaviour? any other details needed?
> 
>> 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
> 
> Hi Derek
> 
> 
> Derek Atkins wrote
>> I've never heard of the SLK bank format.  Is it something you can
>> translate to QIF or OFX?
> 
> Sorry about that. It's actually SYLK, the improved CSV format from
> Microsoft, but my bank uses the .SLK extension to be safe:
> http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)
> 
> 
> Derek Atkins wrote
>> The importers will allow you to assign each transaction to a particular
>> income/expense account.
> 
> I'll try to find a simple tutorial to get started with no background in
> personal money management and experiment.
> 
> Thank you.
> 
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/newbie-Select-lines-in-SLK-file-and-set-to-category-tp4655787p4655793.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user



More information about the gnucash-user mailing list