gnucash-user Digest, Vol 129, Issue 29
John Donnee
jdonnee at ec.rr.com
Mon Dec 23 15:46:52 EST 2013
Message 2:
Chris, instead of doing a save as, is it better to do a copy?
John Donnee
Sent from my iPhone
> On Dec 23, 2013, at 12:00 PM, 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: losing data (Chris Bester)
> 2. RE: losing data (Derek Atkins)
> 3. Re: losing data (David Carlson)
> 4. Re: Error retrieving price quotes (David Reiser)
> 5. Re: losing data (Maf. King)
> 6. RE: losing data (Chris Bester)
> 7. invoice date vs bank transaction date (Parker Jones)
> 8. Split Transaction Question (John Donnee)
> 9. Employee Expense Vouchers (John Donnee)
> 10. Re: Employee Expense Vouchers (Maf. King)
> 11. Re: Employee Expense Vouchers (R. Victor Klassen)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 22 Dec 2013 20:58:11 +0200
> From: "Chris Bester" <chrisbester at cybersmart.co.za>
> To: "'Maf. King'" <maf at chilwell.net>, <gnucash-user at gnucash.org>
> Subject: RE: losing data
> Message-ID: <000001ceff47$c5653bf0$502fb3d0$@cybersmart.co.za>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Maf
>
> Cannot give you a screen shot, but this is what the various toolbars look like:
>
> In the top left hand:-
> Ikon- Balance Sheet(equile)Aug2013 gnucash-Members fees-Gnucash- ( This is the bar that I am referring to and which I cannot understand. It appears above the following tool bars and menu bars.) Members fees is the account I am working in.
> File Edit View Transactions Actions Business Reports Tools Windows Help
> Save Close Duplicate Delete Enter Cancel etc. - etc.
> Accounts Assets Checking Accounts Expenses etc. - etc.
>
> Your last sentence do not make sense to me. Maybe my system is different. I do not understand what you mean by, having the wrong data file in use.
>
> Hope you can help.
> Chris
>
>
> -----Original Message-----
> From: Maf. King [mailto:maf at chilwell.net]
> Sent: 22 December 2013 12:07 PM
> To: gnucash-user at gnucash.org
> Cc: Chris Bester
> Subject: Re: losing data
>
>> On Sun 22 December 13 09:17:10 Chris Bester wrote:
>> Hi There
>>
>>
>>
>> I notice now that above my toolbar, on the top left hand, you can
>> hardly see it, a bar appears with a tiny Gnucash icon and next to it ;
>> Balance Sheet equile Aug. 2013 followed by the name of the account or
>> report I am working with. As I jump between reports or accounts, that
>> name appears, but the Balance sheet equile Aug. 2013 remains the same.
>> I have also discovered that when I open Windows in my toolbar, the
>> same appears there. Could this have anything to do with my continuous
>> losing data entered after the end of August? What is bar for in any case?
>>
>>
>
> Hi Chris,
>
> Any chance of a screenshot? I'm not on a windows system, but my GC window layout is something like:
> Window Frame with current filename in it Menu Bar Tool Buttons Tabs for registers & reports Main display of tree/register/report
>
> If windows follows the same general layout, then I'd suggest that the "balance sheet....2013" is the filename of the accounts data file that is presently open. This may suggest that you have the wrong data file in use.
>
> Do you have any entries in File -> {recently opened file list}, which is between File -> properties & File -> close on my version.
>
> HTH,
> Maf.
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 22 Dec 2013 15:59:13 -0500
> From: "Derek Atkins" <derek at ihtfp.com>
> To: "Chris Bester" <chrisbester at cybersmart.co.za>
> Cc: gnucash-user at gnucash.org
> Subject: RE: losing data
> Message-ID:
> <9076e926459c2b299ceae37f52c4d44c.squirrel at mail2.ihtfp.org>
> Content-Type: text/plain;charset=iso-8859-1
>
> Chris,
>
>> On Sun, December 22, 2013 1:58 pm, Chris Bester wrote:
>> Hi Maf
>>
>> Cannot give you a screen shot, but this is what the various toolbars look
>> like:
>>
>> In the top left hand:-
>> Ikon- Balance Sheet(equile)Aug2013 gnucash-Members fees-Gnucash- ( This is
>> the bar that I am referring to and which I cannot understand. It appears
>> above the following tool bars and menu bars.) Members fees is the
>> account I am working in.
>> File Edit View Transactions Actions Business Reports Tools
>> Windows Help
>> Save Close Duplicate Delete Enter Cancel etc. - etc.
>> Accounts Assets Checking Accounts Expenses etc. - etc.
>>
>> Your last sentence do not make sense to me. Maybe my system is different.
>> I do not understand what you mean by, having the wrong data file in use.
>>
>> Hope you can help.
>> Chris
>>
>
> Imagine if you were using Word, and every time you saved your Word
> document it would create a Backup file in the same directory as your main
> Word document, but it changed the name slightly to add a date/time of when
> you clicked save. In other words, imagine if you were editing a file
> "foo"; every time you clicked save it would create a backup of "foo"
> called "foo.20131222154923" (where those strings of numbers are the
> year/month/day/hour/minute/second when the backup was created). Every
> instance of a dated version of the file would be different, because as you
> add more data to your file it changes over time, right?
>
> Now imagine that instead of clicking on "foo" you accidentally clicked on
> a backup file, "foo.20131222154923". This would cause the system to open
> the backup file instead of your main data file, and lo and behold it would
> look like you lost work!
>
> Now imagine that you continue working and add new data! Yikes, now you
> have multiple sets of books with different streams (and now multiple
> layers of backup files).
>
> I think this is what Maf (and others) are suggesting: Instead of opening
> your main data file (foo) you've accidentally clicked on a backup file.
> Either that or you accidentally did a disk restore from a backup.
>
> GnuCash doesn't lose data, provided you save it. It *could* lose data if
> you do not, and then shut the system down without saving (or have a power
> outage). But if you save your data, GnuCash wont lose it. However you
> can get yourself into the situation as I insinuated above.
>
> One thing to note is that GnuCash always opens the last data file it used.
> However if you double-click on a GnuCash data file, on SOME platforms it
> will open the data file you clicked on (and make *that* the new default)
> and on others it will not (e.g. on Mac it will NOT open the file you
> clicked on).
>
> Another thing to keep in mind is that if you do a File -> Save As, then
> the target (where you save the file) will become the new default. This
> could also cause similar situations if, for example, you tried to create a
> backup file via File -> Save As, because now your backup file would become
> the default file and get future changes unless you File -> Open the
> original.
>
> I hope I have not confused you more, but my guess is that you appear to be
> losing data because you are opening the wrong data file (or you opened the
> wrong data file in the past when you were making your changes).
>
> Unfortunately GnuCash does NOT have a "merge multiple data files into one"
> feature. There is a "Log Replay" feature but honestly I would not
> recommend it because it's very limited in functionality and more often
> than not it introduces bad data into your file.
>
> So once you sort out your file issue I would recommend you just hand-enter
> your previous data. And going forward I recommend you don't click on a
> gnucash data file but instead open Gnucash from the Start menu (or the
> program icon).
>
> Good Luck,
>
>> 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 617-623-3745
> derek at ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 22 Dec 2013 15:22:26 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: losing data
> Message-ID: <52B75812.6050309 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
>> On 12/22/2013 12:58 PM, Chris Bester wrote:
>> Hi Maf
>>
>> Cannot give you a screen shot, but this is what the various toolbars look like:
>>
>> In the top left hand:-
>> Ikon- Balance Sheet(equile)Aug2013 gnucash-Members fees-Gnucash- ( This is the bar that I am referring to and which I cannot understand. It appears above the following tool bars and menu bars.) Members fees is the account I am working in.
>> File Edit View Transactions Actions Business Reports Tools Windows Help
>> Save Close Duplicate Delete Enter Cancel etc. - etc.
>> Accounts Assets Checking Accounts Expenses etc. - etc.
>>
>> Your last sentence do not make sense to me. Maybe my system is different. I do not understand what you mean by, having the wrong data file in use.
>>
>> Hope you can help.
>> Chris
>>
>>
>> -----Original Message-----
>> From: Maf. King [mailto:maf at chilwell.net]
>> Sent: 22 December 2013 12:07 PM
>> To: gnucash-user at gnucash.org
>> Cc: Chris Bester
>> Subject: Re: losing data
>>
>>> On Sun 22 December 13 09:17:10 Chris Bester wrote:
>>> Hi There
>>>
>>>
>>>
>>> I notice now that above my toolbar, on the top left hand, you can
>>> hardly see it, a bar appears with a tiny Gnucash icon and next to it ;
>>> Balance Sheet equile Aug. 2013 followed by the name of the account or
>>> report I am working with. As I jump between reports or accounts, that
>>> name appears, but the Balance sheet equile Aug. 2013 remains the same.
>>> I have also discovered that when I open Windows in my toolbar, the
>>> same appears there. Could this have anything to do with my continuous
>>> losing data entered after the end of August? What is bar for in any case?
>>>
>>>
>> Hi Chris,
>>
>> Any chance of a screenshot? I'm not on a windows system, but my GC window layout is something like:
>> Window Frame with current filename in it Menu Bar Tool Buttons Tabs for registers & reports Main display of tree/register/report
>>
>> If windows follows the same general layout, then I'd suggest that the "balance sheet....2013" is the filename of the accounts data file that is presently open. This may suggest that you have the wrong data file in use.
>>
>> Do you have any entries in File -> {recently opened file list}, which is between File -> properties & File -> close on my version.
>>
>> HTH,
>> Maf.
>>
>>
>> _______________________________________________
>> 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.
>>
> Highlight the button in the upper left corner marked File. Right click
> on it. A drop down list appears. The last entry is Quit. That is the
> button that ends the program. Just above that button is Close. That
> button only closes the current window. Just above that is a numbered
> list of recent data filenames. Number 1 on that list is the file that
> you are currently using. Normally that is the same filename that you
> created the first time you used GnuCash with a suffix .gnucash. There
> may be more names if you have been experimenting with creating test
> files to learn how GnuCash works. That is recommended before starting a
> file with 'Real" data. Those files should be in an easy to find place
> such as a sub directory of My Documents or another place easily
> accessible with Windows Explorer.
>
> When you are done with your current session you click on Quit and
> GnuCash may ask you whether to save recent changes if there are any. If
> you do not close the program by either using that Quit button or
> clicking on the red X button in the upper right hand corner of the
> GnuCash window and clicking save at the prompt you will lose data.
>
> David C
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 22 Dec 2013 23:01:46 -0500
> From: David Reiser <dbreiser at icloud.com>
> To: David Lynch <dlynch1319 at googlemail.com>
> Cc: Fred.Bone at dial.pipex.com, "gnucash-user at gnucash.org list"
> <gnucash-user at gnucash.org>
> Subject: Re: Error retrieving price quotes
> Message-ID: <CB3201E6-B827-44B9-BB3D-CC154198870D at icloud.com>
> Content-Type: text/plain; charset=us-ascii
>
>> On Dec 22, 2013, at 3:39 AM, David Lynch <dlynch1319 at googlemail.com> wrote:
>>
>>> On 21/12/2013 22:55, David Reiser wrote:
>>>> On Dec 21, 2013, at 4:05 PM, David Lynch<dlynch1319 at googlemail.com> wrote:
>>>> On 21/12/2013 17:39, Fred Bone wrote:
>>>>
>>>> Many thanks for your reply: comments are interspersed.
>>>>> On 21 December 2013 at 16:29, David Lynch said:
>>>>>
>>>>>> <snip>
>>> That link requires a login, at least when I attempted to follow it. Trustnet requires that I agree to its Cookie policy before they'll let me see the alternate page when I try to follow that link. I don't think any of the finance-quote modules can handle logins.
>>> <snip>
>>> I believe you are running into an intellectual property dispute between data driven consumers and advertising/tracking driven 'suppliers'. The European fund companies were among the first to force Yahoo to delete their quotes from the data-only feeds. But many other sources have followed their lead. Apparently sometime this year, two big exchanges in India pulled all their data out of Yahoo's quotes.csv service.
>>>
>>> http://finance.yahoo.com/q?s=GB0004459359.L&ql=1
>>> the address that displays in a browser if you go to Yahoo Finance and search for GB0004459359 will show you the information you want, but not in the form you'd like it to be in
>>>
>>> http://finance.yahoo.com/d/quotes.csv?&s=GB0004459359.L&f=sl1d1t1c1ohgv&e=.csv
>>> The form of the address as constructed by finance-quote, results in a bunch of N/A values in the returned data stream.
>>>
>>> http://download.finance.yahoo.com/d/quotes.csv?s=IBM&f=sl1d1t1c1ohgv&e=.csv
>>> works fine to retrieve IBM data. So "IBM" (without the quotes, capitalization matters) as the symbol in gnucash should work. I've never used Gnucash Portable, though.
>>>
>>> http://ichart.finance.yahoo.com/table.csv?s=GB0004459359.L&d=11&e=21&f=2013&g=d&a=11&b=20&c=2013&ignore=.csv
>>> shows some promise, but I see no way to have the symbol returned with the data, so you'd be limited to one quote at a time, or a lot of perl programming. You'd also have to know what currency is being used. (Yahoo web page displays pence, but the ichart values are pounds.)
>>>
>>> Because the fund companies don't want you to be able to download data without paying for it with at least the need to parse your data among ads (or allowing them to put a tracking cookie on your machine), it will be difficult to get the data you want from finance-quote.
>>>
>>> You're faced with writing a screen scraping module for finance-quote. And you're probably faced with modifying it multiple times a year when each fund changes the way they display the data among all the ads. There are some screen scraping modules in finance-quote. But I can't remember offhand which ones they are.
>>> --
>>> Dave Reiser
>>> dbreiser at icloud.com
>> Many thanks for your explanation of why things are problematic.
>>
>> I can easily download the prices I need in csv format from Trustnet (note: no symbols in the csv) :
>> "
>> ,,,,,Date,22-Dec-2013 09:14:50
>>
>> Universe : Unit Trusts & OEICs
>> Name,Purchase ,Bid,,Offer,Currency,Quantity,GBP Cost,GBP Value,Profit/loss,Profit/loss(%)
>> Aviva Inv Corporate Bond 1,,,55.6400,,GBX,0.0000,0.00,0.00,0.00,0.00
>> AXA Framlington Health R Inc,,1121.0000,,1184.0000,GBX,0.0000,0.00,0.00,0.00,0.00
>> "
>> This looks ad-free and more stable than the trustnet site. I'm happy writing or modifying Perl to parse this csv file. I'm worried about interfacing to GnuCash in case I corrupt my accounts. Is there guidance on the Finance::Quote GnuCash interface or the api's to use to load prices into GnuCash?
>>
>>
>> David Lynch
>
>
> The gnucash interface to finance-quote is in src/quotes. You might also see if the normal csv import can be expanded to include quotes. The csv import stuff is in src/import-export/csv-imp
>
> IIRC the gnucash API info is all in internal comments in the code.
> --
> Dave Reiser
> dbreiser at icloud.com
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 23 Dec 2013 09:58:24 +0000
> From: "Maf. King" <maf at chilwell.net>
> To: Chris Bester <chrisbester at cybersmart.co.za>
> Cc: gnucash-user at gnucash.org
> Subject: Re: losing data
> Message-ID: <5736703.7XvBXSNtSk at calufrax.standbyevents.co.uk>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Chris.
>
> I'm fairly sure that the line at the top you are talking about is the window
> "title bar"
>
> On my system, this shows ( icon - File name - name of account or report tab -
> Program Name [ie Gnucash] ) - indeed most programs show similar context-
> relevant information in the window title; my imageviewer, for example, shows
> (icon - filename - size - zoom % - prog name)
>
> So, assuming this to be what you are seeing, your currently open data file is
> called "Balance Sheet(eguile)Aug2013.gnucash" which is (in my opinion) an odd
> choice of name for a set of accounts, although perfectly valid.
>
> I suspect that at some point, you did a "Save As" when intending to Export a
> Balance Sheet report and then later (after adding data to the master file)
> somehow managed to open the newer saved file that only ran to August, so it
> appears that your data has vanished. As long as you save the file when
> closing GC (it reminds you if needed), and there isn't some sort of system
> crash or power outage, data loss as you describe is not something that I have
> experienced, nor heard of on the list. Save Early & Save Often, as I've heard
> said before.
>
> Gnucash is similar to programs like word processors or spreadsheets in that
> you can have many different data files for different purposes (think
> letter_toSanta.doc and Resign-letter_to_Boss.doc). Gnucash just helps to hide
> this capability, because it auto-opens the most recently edited file as many
> use cases involve frequently using one main file.
>
> If you open the Gnucash File Menu, it should drop down a set of command
> choices. Near the bottom of that list, I have Properties, then the list of my
> 4 most recently used accounts files, then close and finally quit.
>
> Do you have any data file names listed in that section of your file menu?
>
>
> HTH,
> Maf
>
>> On Sun 22 December 13 20:58:11 Chris Bester wrote:
>> Hi Maf
>>
>> Cannot give you a screen shot, but this is what the various toolbars look
>> like:
>>
>> In the top left hand:-
>> Ikon- Balance Sheet(equile)Aug2013 gnucash-Members fees-Gnucash- ( This is
>> the bar that I am referring to and which I cannot understand. It appears
>> above the following tool bars and menu bars.) Members fees is the
>> account I am working in. File Edit View Transactions Actions Business
>> Reports Tools Windows Help Save Close Duplicate Delete Enter
>> Cancel etc. - etc.
>> Accounts Assets Checking Accounts Expenses etc. - etc.
>>
>> Your last sentence do not make sense to me. Maybe my system is different. I
>> do not understand what you mean by, having the wrong data file in use.
>>
>> Hope you can help.
>> Chris
>>
>>
>> -----Original Message-----
>> From: Maf. King [mailto:maf at chilwell.net]
>> Sent: 22 December 2013 12:07 PM
>> To: gnucash-user at gnucash.org
>> Cc: Chris Bester
>> Subject: Re: losing data
>>
>>> On Sun 22 December 13 09:17:10 Chris Bester wrote:
>>> Hi There
>>>
>>>
>>>
>>> I notice now that above my toolbar, on the top left hand, you can
>>> hardly see it, a bar appears with a tiny Gnucash icon and next to it ;
>>> Balance Sheet equile Aug. 2013 followed by the name of the account or
>>> report I am working with. As I jump between reports or accounts, that
>>> name appears, but the Balance sheet equile Aug. 2013 remains the same.
>>> I have also discovered that when I open Windows in my toolbar, the
>>> same appears there. Could this have anything to do with my continuous
>>> losing data entered after the end of August? What is bar for in any case?
>>
>> Hi Chris,
>>
>> Any chance of a screenshot? I'm not on a windows system, but my GC window
>> layout is something like: Window Frame with current filename in it Menu Bar
>> Tool Buttons Tabs for registers & reports Main display of
>> tree/register/report
>>
>> If windows follows the same general layout, then I'd suggest that the
>> "balance sheet....2013" is the filename of the accounts data file that is
>> presently open. This may suggest that you have the wrong data file in use.
>>
>> Do you have any entries in File -> {recently opened file list}, which is
>> between File -> properties & File -> close on my version.
>>
>> HTH,
>> Maf.
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542
>
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 23 Dec 2013 13:45:17 +0200
> From: "Chris Bester" <chrisbester at cybersmart.co.za>
> To: "'Maf. King'" <maf at chilwell.net>
> Cc: gnucash-user at gnucash.org
> Subject: RE: losing data
> Message-ID: <000001ceffd4$76b95490$642bfdb0$@cybersmart.co.za>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Maf
>
> Looks like I have in sorted out.
>
> Many thanks
>
> Chris
>
> -----Original Message-----
> From: Maf. King [mailto:maf at chilwell.net]
> Sent: 23 December 2013 11:58 AM
> To: Chris Bester
> Cc: gnucash-user at gnucash.org
> Subject: Re: losing data
>
> Hi Chris.
>
> I'm fairly sure that the line at the top you are talking about is the window "title bar"
>
> On my system, this shows ( icon - File name - name of account or report tab - Program Name [ie Gnucash] ) - indeed most programs show similar context- relevant information in the window title; my imageviewer, for example, shows (icon - filename - size - zoom % - prog name)
>
> So, assuming this to be what you are seeing, your currently open data file is called "Balance Sheet(eguile)Aug2013.gnucash" which is (in my opinion) an odd choice of name for a set of accounts, although perfectly valid.
>
> I suspect that at some point, you did a "Save As" when intending to Export a Balance Sheet report and then later (after adding data to the master file) somehow managed to open the newer saved file that only ran to August, so it appears that your data has vanished. As long as you save the file when closing GC (it reminds you if needed), and there isn't some sort of system crash or power outage, data loss as you describe is not something that I have experienced, nor heard of on the list. Save Early & Save Often, as I've heard said before.
>
> Gnucash is similar to programs like word processors or spreadsheets in that you can have many different data files for different purposes (think letter_toSanta.doc and Resign-letter_to_Boss.doc). Gnucash just helps to hide this capability, because it auto-opens the most recently edited file as many use cases involve frequently using one main file.
>
> If you open the Gnucash File Menu, it should drop down a set of command choices. Near the bottom of that list, I have Properties, then the list of my
> 4 most recently used accounts files, then close and finally quit.
>
> Do you have any data file names listed in that section of your file menu?
>
>
> HTH,
> Maf
>
>> On Sun 22 December 13 20:58:11 Chris Bester wrote:
>> Hi Maf
>>
>> Cannot give you a screen shot, but this is what the various toolbars
>> look
>> like:
>>
>> In the top left hand:-
>> Ikon- Balance Sheet(equile)Aug2013 gnucash-Members fees-Gnucash- (
>> This is the bar that I am referring to and which I cannot understand. It appears
>> above the following tool bars and menu bars.) Members fees is the
>> account I am working in. File Edit View Transactions Actions Business
>> Reports Tools Windows Help Save Close Duplicate Delete Enter
>> Cancel etc. - etc.
>> Accounts Assets Checking Accounts Expenses etc. - etc.
>>
>> Your last sentence do not make sense to me. Maybe my system is
>> different. I do not understand what you mean by, having the wrong data file in use.
>>
>> Hope you can help.
>> Chris
>>
>>
>> -----Original Message-----
>> From: Maf. King [mailto:maf at chilwell.net]
>> Sent: 22 December 2013 12:07 PM
>> To: gnucash-user at gnucash.org
>> Cc: Chris Bester
>> Subject: Re: losing data
>>
>>> On Sun 22 December 13 09:17:10 Chris Bester wrote:
>>> Hi There
>>>
>>>
>>>
>>> I notice now that above my toolbar, on the top left hand, you can
>>> hardly see it, a bar appears with a tiny Gnucash icon and next to it
>>> ; Balance Sheet equile Aug. 2013 followed by the name of the account
>>> or report I am working with. As I jump between reports or accounts,
>>> that name appears, but the Balance sheet equile Aug. 2013 remains the same.
>>> I have also discovered that when I open Windows in my toolbar, the
>>> same appears there. Could this have anything to do with my
>>> continuous losing data entered after the end of August? What is bar for in any case?
>>
>> Hi Chris,
>>
>> Any chance of a screenshot? I'm not on a windows system, but my GC
>> window layout is something like: Window Frame with current filename in
>> it Menu Bar Tool Buttons Tabs for registers & reports Main display of
>> tree/register/report
>>
>> If windows follows the same general layout, then I'd suggest that the
>> "balance sheet....2013" is the filename of the accounts data file that
>> is presently open. This may suggest that you have the wrong data file in use.
>>
>> Do you have any entries in File -> {recently opened file list}, which
>> is between File -> properties & File -> close on my version.
>>
>> HTH,
>> Maf.
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542
>
>
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 24 Dec 2013 02:09:34 +1300
> From: Parker Jones <zoubidoo at hotmail.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: invoice date vs bank transaction date
> Message-ID: <COL126-W302BF5DC16EEE42F01E5B6C0C10 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dear list,
>
> This is probably a newbie question but I didn't find an answer in the FAQ.
>
> I am preparing annual accounts by importing transactions from a bank account via qif. A problem that keeps cropping up is that an invoice that falls within the accounting period has a transaction date outside the accounting period. For tax purposes, the important date (tax point) is the invoice date and not the transaction date.
>
> Is there a way of controlling which accounting period a transaction falls in? I'd be interested to hear how others handle this.
>
> With regards,
> P. Jones
>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 23 Dec 2013 10:56:04 -0500
> From: John Donnee <jdonnee at ec.rr.com>
> To: GnuCash Users List <gnucash-user at gnucash.org>
> Cc: GnuCash Users List <gnucash-user at gnucash.org>
> Subject: Split Transaction Question
> Message-ID: <D1F64BEB-43BA-4DB2-B204-D1039EA8BA11 at ec.rr.com>
> Content-Type: text/plain; charset=windows-1252
>
> Employee Expense Reports.
>
> The example in the Users Guide only shows splitting a salary check. I am confused about how to properly enter the split process for an Expense report especially when the expense report has more than one expense category such as Internet Expense and Medical premium.
>
> Here is how I was doing it but getting double amounts in the Expense categories.
>
> 1. I create a New Expense Voucher
> Do I create the new expense voucher and enter just the Total of the expenses and assign it too ?Expenses? even though it has multiple line items with different expense categories?????
>
> I did an expense voucher and Split each of the line items and then when I did the splits in the Check register there were double expenses in each Expense Category-
>
>
> 2. I then go to my Check Register and Select Splits
> a. My first line item is the description and I hit Splits
> b. My second line item is Account-Checking-decrease the total expense report amount
> c. I then enter each expense on each subsequent line
> d The result seems to show up correct in my Checking register
>
> 3. I am not sure how to handle the Expense vouchers with multiple line items on it. I think that I am doing the Check splits correctly.
>
>
> Suggestions-Examples???
>
> Thanks
>
> John Donnee
>
> 910.622.8111
> 8422 Emerald Dunes Rd.
> Wilmington, NC 28411
>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Mon, 23 Dec 2013 11:25:09 -0500
> From: John Donnee <jdonnee at ec.rr.com>
> To: GnuCash Users List <gnucash-user at gnucash.org>
> Cc: GnuCash Users List <gnucash-user at gnucash.org>
> Subject: Employee Expense Vouchers
> Message-ID: <CB38347A-D9B3-4DB4-8ACB-D02C226DB4F1 at ec.rr.com>
> Content-Type: text/plain; charset=windows-1252
>
> I might have solved my problem from my earlier email.
>
> I have NOT been using ?Process Payment?
>
> I have been entering the Splits directly in to the Check Register.
>
> Is this correct:
>
> 1. Create a new Expense Voucher.
>
> 2. Enter each of the line items with each of the Expense Categories and Post
>
> 3. Then go back in to Employee and select ?Process Payment
>
> 4. In the Process Payment select Checking
>
> 5. Enter the total expense amount pif it is different than on the Expense report.
>
> 6. This will then process the split transaction and post the correct line item amounts to the correct expense category.
>
> Or does the each of the expense categories get updated when I created the original expense report.
>
> 7. Then I DO NOT need to go in to the Check register and create the split transaction as I have been doing.
>
> It would really be great if there was an example of processing a multi line Expense report.
>
>
> Thanks
>
>
> John Donnee
>
> 910.622.8111
> 8422 Emerald Dunes Rd.
> Wilmington, NC 28411
>
>
>
>
> ------------------------------
>
> Message: 10
> Date: Mon, 23 Dec 2013 16:35:32 +0000
> From: "Maf. King" <maf at chilwell.net>
> To: gnucash-user at gnucash.org
> Cc: John Donnee <jdonnee at ec.rr.com>
> Subject: Re: Employee Expense Vouchers
> Message-ID: <1732467.Vgx90thxtj at calufrax.standbyevents.co.uk>
> Content-Type: text/plain; charset="utf-8"
>
>> On Mon 23 December 13 11:25:09 John Donnee wrote:
>> I might have solved my problem from my earlier email.
>>
>> I have NOT been using ?Process Payment?
>>
>> I have been entering the Splits directly in to the Check Register.
>>
>> Is this correct:
>>
>> 1. Create a new Expense Voucher.
>>
>> 2. Enter each of the line items with each of the Expense Categories and Post
>>
>> 3. Then go back in to Employee and select ?Process Payment
>>
>> 4. In the Process Payment select Checking
>>
>> 5. Enter the total expense amount pif it is different than on the Expense
>> report.
>>
>> 6. This will then process the split transaction and post the correct line
>> item amounts to the correct expense category.
>>
>> Or does the each of the expense categories get updated when I created the
>> original expense report.
>>
>> 7. Then I DO NOT need to go in to the Check register and create the split
>> transaction as I have been doing.
>>
>> It would really be great if there was an example of processing a multi line
>> Expense report.
>>
>
>
> Hi John,
>
> I haven't used the employee expense voucher bit of GC, but AFAIK, it uses more
> or less identical code to the Vendor Bills / Customer Invoices sections (with
> which I am familiar!)
>
> Your workflow sounds about right - if you look through the docs regarding
> bills & invoices it should be more or less transferable knowledge...
>
> cheers,
> Maf.
>
>
>
>
> ------------------------------
>
> Message: 11
> Date: Mon, 23 Dec 2013 11:40:30 -0500
> From: "R. Victor Klassen" <rvklassen at gmail.com>
> To: John Donnee <jdonnee at ec.rr.com>
> Cc: GnuCash Users List <gnucash-user at gnucash.org>
> Subject: Re: Employee Expense Vouchers
> Message-ID: <05FC7300-F5FE-4A3F-8140-F48FF3C44D73 at gmail.com>
> Content-Type: text/plain; charset=windows-1252
>
> Looks like you?re close. I?ve not used employee expense vouchers, but assume it is analogous to invoices and bills.
>
> Your steps 1-5 look right. When you post in line 2 is when the expense categories get updated. When you process the payment, that only changes accounts payable and the account from which you are paying. So you are right in what you say in 7.
>
>> On Dec 23, 2013, at 11:25 AM, John Donnee <jdonnee at ec.rr.com> wrote:
>>
>> I might have solved my problem from my earlier email.
>>
>> I have NOT been using ?Process Payment?
>>
>> I have been entering the Splits directly in to the Check Register.
>>
>> Is this correct:
>>
>> 1. Create a new Expense Voucher.
>>
>> 2. Enter each of the line items with each of the Expense Categories and Post
>>
>> 3. Then go back in to Employee and select ?Process Payment
>>
>> 4. In the Process Payment select Checking
>>
>> 5. Enter the total expense amount pif it is different than on the Expense report.
>>
>> 6. This will then process the split transaction and post the correct line item amounts to the correct expense category.
>>
>> Or does the each of the expense categories get updated when I created the original expense report.
>>
>> 7. Then I DO NOT need to go in to the Check register and create the split transaction as I have been doing.
>>
>> It would really be great if there was an example of processing a multi line Expense report.
>>
>>
>> Thanks
>>
>>
>> John Donnee
>>
>> 910.622.8111
>> 8422 Emerald Dunes Rd.
>> Wilmington, NC 28411
>>
>>
>> _______________________________________________
>> 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
>
>
> End of gnucash-user Digest, Vol 129, Issue 29
> *********************************************
More information about the gnucash-user
mailing list