[GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Hi, Someone on the #gnucash IRC channel suggested I write this message as I have quite a complex issue. Basically I've made a few purchases the last few months, most of which I paid without VAT. Here's a concrete example to help you better understand. I bought a laptop. This laptop cost € 2016, VAT included. However, as i have a VAT number, I paid only € 1694,12. A few prerequisites: - My accountant wants me to include foreign VAT as an asset and also include Belgian VAT as an asset. He calls that a "null operation" but it's necessary, he says. - Looking at my transaction report, we noticed the balance for each month isn't correct. It should be equal to zero. - This purchase has to be used as an investment (asset account) which can then be depreciated each year. I thought I was able to solve the problem by creating a bill linked to the vendor (Business\Vendor\New Bill), then posting the bill and processing the payment - amount without VAT linked to checking account/VAT in the separate VAT account. Below are screenshots of that: [Purchase minus German VAT] [Purchase minus Belgian VAT] But the Liabilities:VAT Sales:Belgium looks totally messed up. To be honest, I don't think I know what I'm doing anymore. I've tried many things already but to no avail... Thank you in advance for the feedback. Jeremy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Second screenshot didn't appear to be visible: [Purchase minus Belgian VAT] 2018-07-12 22:34 GMT+02:00 Jeremy D : > Hi, > > Someone on the #gnucash IRC channel suggested I write this message as I > have quite a complex issue. > > Basically I've made a few purchases the last few months, most of which I > paid without VAT. > > Here's a concrete example to help you better understand. > > I bought a laptop. This laptop cost € 2016, VAT included. However, as i > have a VAT number, I paid only € 1694,12. > > A few prerequisites: > > >- My accountant wants me to include foreign VAT as an asset and also >include Belgian VAT as an asset. He calls that a "null operation" but it's >necessary, he says. >- Looking at my transaction report, we noticed the balance for each >month isn't correct. It should be equal to zero. >- This purchase has to be used as an investment (asset account) which >can then be depreciated each year. > > > I thought I was able to solve the problem by creating a bill linked to the > vendor (Business\Vendor\New Bill), then posting the bill and processing the > payment - amount without VAT linked to checking account/VAT in the separate > VAT account. Below are screenshots of that: > > [Purchase minus German VAT] > > > > [Purchase minus Belgian VAT] > > > > But the Liabilities:VAT Sales:Belgium looks totally messed up. To be > honest, I don't think I know what I'm doing anymore. I've tried many things > already but to no avail... > > Thank you in advance for the feedback. > > Jeremy > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
Thanks, Stan, for sharing your work with all. But it only makes me feel sorry - I am a non-programmer user of GnuCash :-( I still hope there will be - some time in the not too distant future - a program which can be used also by a non-programmer to move a well working GnuCash system from one Widows 10 computer to a new Windows 10 computer. Still not giving up hope. Norbert On 13.7.2018 5:29, Stan Brown wrote: Dick, here is a batch file I use to save and restore my GnuCash settings and reports, for transferring them between machines. You'd need to change my file names and paths to yours, but still it could save you some time. If you don't want to be elaborate as I am -- my batch files tend to be a bit over-engineered -- just look for the "reg" lines. Those are the ones that save or restore the settings and reports. @set MYECHO=echo off @%MYECHO set RZIPNAME=_stanReports.zip set GFILNAME=_stanSettings.reg setlocal set MYNAME=%@name[%0] if "%1" ne "/?" .and. "%1" ne "-?" .and. "%1" ne "" goto 000_Start echo off echo. echo %MYNAME: Save or restore GnuCash settings echo. echo options: echo /q Quiet echo /v Verbose echo /purge Delete saved log files (used with "save" or "apply") echo save Save settings echo apply Apply saved settings echo purge Delete saved log files. echo Just one of 'save', 'apply', 'purge' is required. echo. echo Settings are saved in %GFILNAME and %RZIPNAME, in the same echo folder as the GnuCash accounting file. quit 2018-02-25 new program 2018-03-21 Add the purge option. 2018-03-31 With 'purge', suppress error message if there are no files ... 2018-04-01 ... and also delete GnuCash files in %TEMP%. 2018-04-18 Add /purge as an option, used with "save" or "apply". 2018-05-05 Program didn't abort after an an unknown option. Copyright 2018 Stan Brown, Oak Road Systems http://oakroadsystems.com/ :000_Start :: Scan the options. set ACTION=none set PURGING=0 set VERBOSE=1 do while "%1" ne "" iff %1 == save .or. %1 == apply .or. %1 == purge then iff %ACTION ne none then echo %MYNAME: Only one of 'save', 'apply', purge is allowed. cancel endiff set ACTION=%@lower[%1] elseiff %1 == /q then set VERBOSE=0 elseiff %1 == /v then set VERBOSE=2 elseiff %1 == /purge then set PURGING=1 else echo %MYNAME: Unknown option '%1'. cancel 2 endiff shift enddo iff %ACTION == none then echo %MYNAME: You need one of 'save', 'apply', or 'purge'. cancel elseiff %VERBOSE == 2 then echo %MYNAME: Plaanning to %ACTION the %@if[%ACTION == purge,files,settings]. echo. endiff :: Check existence of files and folders. set GDIR=e:\sb\$\GnuCash iff not isdir "%GDIR" then echo %MYNAME: Financials folder '%GDIR' not found. cancel elseiff not exist "%GDIR\Stan.gnucash" then echo %MYNAME: File Stan.gnucash not found in '%GDIR'. cancel endiff set RDIR=%USERPROFILE\.gnucash set RZIP=%GDIR\%RZIPNAME set GKEY=HKCU\Software\GSettings\org\gnucash set GFIL=%GDIR\%GFILNAME iff %VERBOSE == 2 then echo %MYNAME: Financial database is in folder '%GDIR'. echo %MYNAME: GnuCash reports are in folder '%RDIR'. echo %MYNAME: GnuCash reports are zipped in file '%RZIP'. echo %MYNAME: GnuCash settings are in '%GKEY'. echo %MYNAME: GnuCash settings are exported to file '%GFIL'. echo. endiff iff %ACTION == save then if %PURGING == 1 gosub PurgeAction iff not isdir "%RDIR" then echo %MYNAME: Reports folder '%RDIR' not found. cancel endiff pushd "%RDIR" set ZIPOPT= set OPTS=-r -T -o if %VERBOSE lt 2 set OPTS=%OPTS -q @if %VERBOSE ge 1 echo on zip %OPTS "%RZIP" * @%MYECHO @echo. popd @if %VERBOSE ge 1 echo on reg export %GKEY "%GFIL" /y @%MYECHO elseiff %ACTION == apply then if %PURGING == 1 gosub PurgeAction iff not exist "%GFIL" then echo %MYNAME: Registy export file '%GFIL' not found. cancel endiff iff not exist "%RZIP" then echo %MYNAME: Reports ZIP file '%RZIP' not found. cancel endiff iff not isdir "%RDIR" then echo %MYNAME: Reports folder '%RDIR' not found. input /c /k"yYnN" /l1 Create it?^ %%X echo. if %X == N cancel md "%RDIR" endiff set OPTS=-uo if %VERBOSE == 0 set OPTS=%OPTS -q @if %VERBOSE ge 1 echo on unzip %OPTS "%RZIP" -d "%RDIR" @%MYECHO @echo. @if %VERBOSE ge 1 echo on reg delete %GKEY /f @echo. reg import "%GFIL" @%MYECHO elseiff %ACTION == purge then gosub PurgeAction else echo %MYNAME: Internal error: %%ACTION = '%ACTION' cancel
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
Norbert. Don't over think this. Which word processor do you use? How did you move all your wordprocessor documents, template & settings from old to new? GC really isn't very different. you have one or more accounts data files (ie.documents) saved somewhere (there are also some auto-backup copies of these in the same folders, but it is not required to copy these backups - GC will make more in due course) and possibly some customised reports in another folder - which you have been told about. you need to move the data file(s) and ~/.gnucash folder as outlined in the FAQ links you have been given. Some display settings/preferences may not make it over because they are stored in the windows registry - but a quick once- through of the preferences dialog box should let you put things back as you like. No programming needed. HTH, Maf. On Friday, 13 July 2018 09:59:04 BST Norbert Klein wrote: > Thanks, Stan, > > for sharing your work with all. > > But it only makes me feel sorry - I am a non-programmer user of GnuCash :-( > > I still hope there will be - some time in the not too distant future - a > program which can be used also by a non-programmer to move a well > working GnuCash system from one Widows 10 computer to a new Windows 10 > computer. > > Still not giving up hope. > > Norbert > > On 13.7.2018 5:29, Stan Brown wrote: > > Dick, here is a batch file I use to save and restore my GnuCash settings > > and reports, for transferring them between machines. You'd need to > > change my file names and paths to yours, but still it could save you > > some time. > > > > If you don't want to be elaborate as I am -- my batch files tend to be a > > bit over-engineered -- just look for the "reg" lines. Those are the ones > > that save or restore the settings and reports. > > > >> @set MYECHO=echo off > >> @%MYECHO > >> set RZIPNAME=_stanReports.zip > >> set GFILNAME=_stanSettings.reg > >> setlocal > >> set MYNAME=%@name[%0] > >> if "%1" ne "/?" .and. "%1" ne "-?" .and. "%1" ne "" goto 000_Start > >> echo off > >> echo. > >> echo %MYNAME: Save or restore GnuCash settings > >> echo. > >> echo options: > >> echo /q Quiet > >> echo /v Verbose > >> echo /purge Delete saved log files (used with "save" or "apply") > >> echo save Save settings > >> echo apply Apply saved settings > >> echo purge Delete saved log files. > >> echo Just one of 'save', 'apply', 'purge' is required. > >> echo. > >> echo Settings are saved in %GFILNAME and %RZIPNAME, in the same > >> echo folder as the GnuCash accounting file. > >> quit > >> * > >> *** 2018-02-25 new program > >> 2018-03-21 Add the purge option. > >> 2018-03-31 With 'purge', suppress error message if there are no files > >> ... > >> 2018-04-01 ... and also delete GnuCash files in %TEMP%. > >> 2018-04-18 Add /purge as an option, used with "save" or "apply". > >> 2018-05-05 Program didn't abort after an an unknown option. > >> > >> Copyright 2018 Stan Brown, Oak Road Systems > >> http://oakroadsystems.com/ > >> > >> * > >> ***>> > >> :000_Start > >> : > >> :: Scan the options. > >> > >> set ACTION=none > >> set PURGING=0 > >> set VERBOSE=1 > >> do while "%1" ne "" > >> > >> iff %1 == save .or. %1 == apply .or. %1 == purge then > >> > >> iff %ACTION ne none then > >> > >> echo %MYNAME: Only one of 'save', 'apply', purge is allowed. > >> cancel > >> > >> endiff > >> set ACTION=%@lower[%1] > >> > >> elseiff %1 == /q then > >> > >> set VERBOSE=0 > >> > >> elseiff %1 == /v then > >> > >> set VERBOSE=2 > >> > >> elseiff %1 == /purge then > >> > >> set PURGING=1 > >> > >> else > >> > >> echo %MYNAME: Unknown option '%1'. > >> cancel 2 > >> > >> endiff > >> shift > >> > >> enddo > >> iff %ACTION == none then > >> > >> echo %MYNAME: You need one of 'save', 'apply', or 'purge'. > >> cancel > >> > >> elseiff %VERBOSE == 2 then > >> > >> echo %MYNAME: Plaanning to %ACTION the %@if[%ACTION == > >> purge,files,settings]. echo. > >> > >> endiff > >> > >> :: Check existence of files and folders. > >> :: > >> set GDIR=e:\sb\$\GnuCash > >> > >> iff not isdir "%GDIR" then > >> > >> echo %MYNAME: Financials folder '%GDIR' not found. > >> cancel > >> > >> elseiff not exist "%GDIR\Stan.gnucash" then > >> > >> echo %MYNAME: File Stan.gnucash not found in '%GDIR'. > >> cancel > >> > >> endiff > >> set RDIR=%USERPROFILE\.gnucash > >> set RZIP=%GDIR\%RZIPNAME > >> set GKEY=HKCU\Software\GSettings\org\gnucash > >> set GFIL=%GDIR\%GFILNAME > >> iff %VERBOSE == 2 then > >> > >> echo %MYNAME: Financial databa
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
On 7/13/2018 4:59 AM, Norbert Klein wrote: Thanks, Stan, for sharing your work with all. But it only makes me feel sorry - I am a non-programmer user of GnuCash :-( I still hope there will be - some time in the not too distant future - a program which can be used also by a non-programmer to move a well working GnuCash system from one Widows 10 computer to a new Windows 10 computer. Still not giving up hope. Norbert This is not really a "program which can be used by a non-programmer" issue. It is more a issue about "computer used by a non-programmer" issue (a special case of a more general problem). Computer users who do not have a "support person" have to learn how to do SOME basic tasks for themselves. How do you move ANY data between devices, between computers or from computer to backup device and how to restore from backup? Do you see why your question "how do I move gnucash data?" is just a special case of this more general problem << how do I move data from my old computer to a back-up device, USB stick or external drive or network place, and how do I "restore" this data to my computer, in this case the new one. If you don't know how to make backups of your data and restore from backup and you don't have a "support person" to do tasks like this for you, then you as a computer user have to learn how to do this basic (absolutely necessary) thing for yourself. If you do not have back-ups, it is not a question of whether you will lose your data but when you will lose your data. Not just your gnucash data but ALL of your data. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
On Fri, Jul 13, 2018, at 4:59 AM, Norbert Klein wrote: > Thanks, Stan, for sharing your work with all. ... > I still hope there will be - some time in the not too distant future - a > program which can be used also by a non-programmer to move a well > working GnuCash system from one Widows 10 computer to a new Windows 10 > computer. I think there's a mechanism for entering that as a request for the product, and I think it would be a great idea. Programs in general ought to make it easier not just to move their settings but to back them up. P.S. I'm not really a programmer any more, but I still keep my hand in with various forms of scripting, mainly AWK and batch files. One day I'll learn Windows PowerShell, maybe. -- Stan Brown the_stan_br...@fastmail.fm http://BrownMath.com http://OakRoadSystems.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
On 7/13/2018 8:20 AM, Stan Brown wrote: I think there's a mechanism for entering that as a request for the product, and I think it would be a great idea. Programs in general ought to make it easier not just to move their settings but to back them up. P.S. I'm not really a programmer any more, but I still keep my hand in with various forms of scripting, mainly AWK and batch files. One day I'll learn Windows PowerShell, maybe. Absolutely not. Not on a program by program, application by application basis. Look, if on computer there is a data area ... users/user-name/. and if THIS (entire directory) is copied to back-up then ALL of that user's data has been backed up in one operation. SPACE (cheap these days) is the only good reason to do incremental back-ups. But if this method is used, should be neither the responsibility of programs nor manual actions by the user, but an automated back-up system designed for the purpose << say runs every night and makes a (new) back-up of every file that has changed since the day before >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
I agree with Michael here. I can’t imagine the nightmare of trying to restore an entire system or migrate it to another physical machine and have to contend with dozens of different restore procedures, one for each application based on what those developers thought best. I’d much rather handle this with a single method for the entire system. Backup, restoration and migration is not a proper function to handle on a per-app basis. This is always something that should be done by the user according to their own needs and preferences. There are many applications dedicated to this very task, some come with operating systems as ’sane defaults’ and others are available if a user finds those ’sane defaults’ to not meet their needs. In a worst case, one can always just copy/move files manually. (again, there are multiple methods available here, depending on need and preference) Such a request (to have the particular app handle this) strikes me as coming from the perspective that the user thinks the data and settings are contained within the app itself somehow. I’m not sure where this idea originates, but I’ve come across it so many times. (My parents used to think their documents were actually, literally, stored IN ‘MS Word’. It took me many months to get them to comprehend otherwise.) The short answer to the original post is simply - make a backup (using the backup procedure included in Win10) of the original system, then restore that backup on the new system. If you just want to move GnuCash, that backup/restore tool allows you to choose what you want to include so only include the GnuCash relevant files. Windows has had a backup and migration assistant included for at least a decade now. The desired tool already exists. (I used it a few months ago to copy a user profile to 5 different machines - data, preferences and all) Regards, Adrien > On Jul 13, 2018, at 7:46 AM, Mike or Penny Novack > wrote: > > On 7/13/2018 8:20 AM, Stan Brown wrote: >> I think there's a mechanism for entering that as a request for the product, >> and I think it would be a great idea. Programs in general ought to make it >> easier not just to move their settings but to back them up. >> >> P.S. I'm not really a programmer any more, but I still keep my hand in with >> various forms of scripting, mainly AWK and batch files. One day I'll learn >> Windows PowerShell, maybe. >> > Absolutely not. Not on a program by program, application by application basis. > > Look, if on computer there is a data area ... users/user-name/. and if > THIS (entire directory) is copied to back-up then ALL of that user's data has > been backed up in one operation. > > SPACE (cheap these days) is the only good reason to do incremental back-ups. > But if this method is used, should be neither the responsibility of programs > nor manual actions by the user, but an automated back-up system designed for > the purpose << say runs every night and makes a (new) back-up of every file > that has changed since the day before >> > > Michael D Novack > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
I don't have access to a gnucash installation currently so I can't verify my suggestion. But this is how I would handle it. - create two vat asset accounts. One for the Belgian vat and one for the foreign vat. - create a tax table (which is all about vat) for your intra-European purchases. This tax table should have 2 entries 1. Belgian vat (typically 21%), assigned to the Belgian vat account 2. Foreign vat, which should be the negative percentage of the Belgian vat (so typically -21%), assigned to the foreign vat account. - now you can set tge default vat for your German vendor to this tax table. When you enter you vendor bill on each line you enter the values without vat and double check the tax table is still the one for intra-European purchaes. - note the purchase of a laptop should also go to an asset account (investment) so that's what you should enter as account in the entry (an entry is one line on your bill) - after posting this bill I believe it should create the correct transaction for you, including two vat entries in your assets and the net amount of the lap3in an investment account that can be used for depreciation. - in addition the bill will be posted for the net amount such you can apply the correct payment. The only small detail I don't remember is whether I have changed the gnucash code already to allow negative percentages in tax tables. I think I have though. Geert Jeremy D schreef op 12 juli 2018 22:34:43 CEST: >Hi, > >Someone on the #gnucash IRC channel suggested I write this message as I >have quite a complex issue. > >Basically I've made a few purchases the last few months, most of which >I >paid without VAT. > >Here's a concrete example to help you better understand. > >I bought a laptop. This laptop cost € 2016, VAT included. However, as i >have a VAT number, I paid only € 1694,12. > >A few prerequisites: > > > - My accountant wants me to include foreign VAT as an asset and also >include Belgian VAT as an asset. He calls that a "null operation" but >it's > necessary, he says. > - Looking at my transaction report, we noticed the balance for each > month isn't correct. It should be equal to zero. > - This purchase has to be used as an investment (asset account) which > can then be depreciated each year. > > >I thought I was able to solve the problem by creating a bill linked to >the >vendor (Business\Vendor\New Bill), then posting the bill and processing >the >payment - amount without VAT linked to checking account/VAT in the >separate >VAT account. Below are screenshots of that: > >[Purchase minus German VAT] > > > >[Purchase minus Belgian VAT] > > > >But the Liabilities:VAT Sales:Belgium looks totally messed up. To be >honest, I don't think I know what I'm doing anymore. I've tried many >things >already but to no avail... > >Thank you in advance for the feedback. > >Jeremy Sent from my smartphone. Please excuse my brevity. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?
Stan, thanks. With my small account it wasn't much of a problem to do it all manually (once I knew where and what needed to be done!), but I'm sure your batch file is a great tool for higher volume situations. I do agree with everyone that help for 'just-a user' folks like me is important. I know enough to be dangerous, but fortunately (at least I think) I know it. For me, instructions that clearly explain how *and why* give me the most confidence to go DIY. I think before I would be comfortable using somebody's (black-box to me) tool I'd want to have an imprimatur from, like, GNUcash and more documentation. Adrien's answer of using an established tool like Windows BU sounds easy and reliable, but you have to tell me exactly what *are* the "relevant file(s)"? -- I didn't think one 218kb file could possibly be big enough to hold 7 years of transactions, customers, vendors, etc. and I was sure I *had* to regedit the Preferences (I *knew* that was dangerous for me) -- that is until Dave explained it plain and simple and gave me the confidence. Thanks again everybody. Dick On Thu, Jul 12, 2018 at 6:29 PM Stan Brown wrote: > Dick, here is a batch file I use to save and restore my GnuCash settings > and reports, for transferring them between machines. You'd need to > change my file names and paths to yours, but still it could save you > some time. > > If you don't want to be elaborate as I am -- my batch files tend to be a > bit over-engineered -- just look for the "reg" lines. Those are the ones > that save or restore the settings and reports. > > > @set MYECHO=echo off > > @%MYECHO > > set RZIPNAME=_stanReports.zip > > set GFILNAME=_stanSettings.reg > > setlocal > > set MYNAME=%@name[%0] > > if "%1" ne "/?" .and. "%1" ne "-?" .and. "%1" ne "" goto 000_Start > > echo off > > echo. > > echo %MYNAME: Save or restore GnuCash settings > > echo. > > echo options: > > echo /q Quiet > > echo /v Verbose > > echo /purge Delete saved log files (used with "save" or "apply") > > echo save Save settings > > echo apply Apply saved settings > > echo purge Delete saved log files. > > echo Just one of 'save', 'apply', 'purge' is required. > > echo. > > echo Settings are saved in %GFILNAME and %RZIPNAME, in the same > > echo folder as the GnuCash accounting file. > > quit > > > > > 2018-02-25 new program > > 2018-03-21 Add the purge option. > > 2018-03-31 With 'purge', suppress error message if there are no files > ... > > 2018-04-01 ... and also delete GnuCash files in %TEMP%. > > 2018-04-18 Add /purge as an option, used with "save" or "apply". > > 2018-05-05 Program didn't abort after an an unknown option. > > > > Copyright 2018 Stan Brown, Oak Road Systems > http://oakroadsystems.com/ > > > > > :000_Start > > > > :: Scan the options. > > set ACTION=none > > set PURGING=0 > > set VERBOSE=1 > > do while "%1" ne "" > > iff %1 == save .or. %1 == apply .or. %1 == purge then > > iff %ACTION ne none then > > echo %MYNAME: Only one of 'save', 'apply', purge is allowed. > > cancel > > endiff > > set ACTION=%@lower[%1] > > elseiff %1 == /q then > > set VERBOSE=0 > > elseiff %1 == /v then > > set VERBOSE=2 > > elseiff %1 == /purge then > > set PURGING=1 > > else > > echo %MYNAME: Unknown option '%1'. > > cancel 2 > > endiff > > shift > > enddo > > iff %ACTION == none then > > echo %MYNAME: You need one of 'save', 'apply', or 'purge'. > > cancel > > elseiff %VERBOSE == 2 then > > echo %MYNAME: Plaanning to %ACTION the %@if[%ACTION == > purge,files,settings]. > > echo. > > endiff > > > > :: Check existence of files and folders. > > set GDIR=e:\sb\$\GnuCash > > iff not isdir "%GDIR" then > > echo %MYNAME: Financials folder '%GDIR' not found. > > cancel > > elseiff not exist "%GDIR\Stan.gnucash" then > > echo %MYNAME: File Stan.gnucash not found in '%GDIR'. > > cancel > > endiff > > set RDIR=%USERPROFILE\.gnucash > > set RZIP=%GDIR\%RZIPNAME > > set GKEY=HKCU\Software\GSettings\org\gnucash > > set GFIL=%GDIR\%GFILNAME > > iff %VERBOSE == 2 then > > echo %MYNAME: Financial database is in folder '%GDIR'. > > echo %MYNAME: GnuCash reports are in folder '%RDIR'. > > echo %MYNAME: GnuCash reports are zipped in file '%RZIP'. > > echo %MYNAME: GnuCash settings are in '%GKEY'. > > echo %MYNAME: GnuCash settings are exported to file '%GFIL'. > > echo. > > endiff > > > > iff %ACTION == save then > > if %PURGING == 1 gosub PurgeAction > > iff not isdir "%RDIR" then > > echo %MYNAME: Reports folder '%RDIR' not found. > > cancel > > endiff > > pushd "%RDIR" > > set ZIPOPT= > > set OPTS=-r -T -o > > if %VERBOSE lt 2 set O
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Hi, Am 13.07.2018 um 17:42 schrieb Geert Janssens: > I don't have access to a gnucash installation currently so I can't verify my > suggestion. But this is how I would handle it. > > - create two vat asset accounts. One for the Belgian vat and one for the > foreign vat. > - create a tax table (which is all about vat) for your intra-European > purchases. This tax table should have 2 entries > 1. Belgian vat (typically 21%), assigned to the Belgian vat account > 2. Foreign vat, which should be the negative percentage of the Belgian vat > (so typically -21%), assigned to the foreign vat account. While most you are writing seems pretty simular to the situation in DE. I would not use negative rates. Instead I would use the folowing setup: assets: VAT reimbursable Buys @ full rate: 21% : liabilities: VAT Sales: 21% Import with VAT ID: 21% : For an optimal grouping of different rates, other cases of imports etc. compare your setup with your tax forms and discuss it with your CPA. With the rest, I aggree: > - now you can set tge default vat for your German vendor to this tax table. > When you enter you vendor bill on each line you enter the values without vat > and double check the tax table is still the one for intra-European purchaes. > - note the purchase of a laptop should also go to an asset account > (investment) so that's what you should enter as account in the entry (an > entry is one line on your bill) > > - after posting this bill I believe it should create the correct transaction > for you, including two vat entries in your assets and the net amount of the > lap3in an investment account that can be used for depreciation. > - in addition the bill will be posted for the net amount such you can apply > the correct payment. > > The only small detail I don't remember is whether I have changed the gnucash > code already to allow negative percentages in tax tables. I think I have > though. I hope, you did not, because negative amounts are reserved for stornos. > Geert > > Jeremy D schreef op 12 juli 2018 22:34:43 CEST: >> Hi, >> >> Someone on the #gnucash IRC channel suggested I write this message as I >> have quite a complex issue. >> >> Basically I've made a few purchases the last few months, most of which >> I >> paid without VAT. >> >> Here's a concrete example to help you better understand. >> >> I bought a laptop. This laptop cost € 2016, VAT included. However, as i >> have a VAT number, I paid only € 1694,12. >> >> A few prerequisites: >> >> >> - My accountant wants me to include foreign VAT as an asset and also >> include Belgian VAT as an asset. He calls that a "null operation" but >> it's >> necessary, he says. >> - Looking at my transaction report, we noticed the balance for each >> month isn't correct. It should be equal to zero. >> - This purchase has to be used as an investment (asset account) which >> can then be depreciated each year. >> >> >> I thought I was able to solve the problem by creating a bill linked to >> the >> vendor (Business\Vendor\New Bill), then posting the bill and processing >> the >> payment - amount without VAT linked to checking account/VAT in the >> separate >> VAT account. Below are screenshots of that: >> >> [Purchase minus German VAT] >> >> >> >> [Purchase minus Belgian VAT] >> >> >> >> But the Liabilities:VAT Sales:Belgium looks totally messed up. To be >> honest, I don't think I know what I'm doing anymore. I've tried many >> things >> already but to no avail... >> >> Thank you in advance for the feedback. >> >> Jeremy Regards Frank pEpkey.asc Description: application/pgp-keys ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] compile stops at core-utils.go
Generating ../../lib/gnucash/scm/ccache/2.0/gnucash/core-utils.go Backtrace: In srfi/srfi-1.scm: 616: 19 [for-each # #] In scripts/compile.scm: 190: 18 [# "/mosource/gnucash-3.2/libgnucash/core-utils/core-utils.scm"] In system/base/target.scm: 59: 17 [with-target "x86_64-pc-linux-gnu" ...] In system/base/compile.scm: 152: 16 [compile-file "/mosource/gnucash-3.2/libgnucash/core-utils/core-utils.scm" ...] 43: 15 [call-once #] In ice-9/boot-9.scm: 174: 14 [with-throw-handler #t ...] In system/base/compile.scm: 59: 13 [#] 155: 12 [# #] 218: 11 [read-and-compile # #:from ...] 234: 10 [lp (# # # # ...) # #] 182: 9 [lp # # # ...] In ice-9/boot-9.scm: 2404: 8 [save-module-excursion #] In language/scheme/compile-tree-il.scm: 31: 7 [#] In ice-9/psyntax.scm: 1106: 6 [expand-top-sequence ((re-export gnc-build-userdata-path)) () ...] 989: 5 [scan ((re-export gnc-build-userdata-path)) () ...] 279: 4 [scan ((# #)) () (()) ...] In ice-9/boot-9.scm: 2097: 3 [call-with-deferred-observers #] 771: 2 [for-each # #] In unknown file: ?: 1 [scm-error misc-error #f ...] In ice-9/boot-9.scm: 109: 0 [# misc-error ...] ice-9/boot-9.scm:109:20: In procedure #: ice-9/boot-9.scm:109:20: Undefined variable: gnc-build-userdata-path libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/build.make:61: recipe for target 'lib/gnucash/scm/ccache/2.0/gnucash/core-utils.go' failed make[2]: *** [lib/gnucash/scm/ccache/2.0/gnucash/core-utils.go] Error 1 CMakeFiles/Makefile2:3861: recipe for target 'libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/all' failed make[1]: *** [libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/all] Error 2 Makefile:162: recipe for target 'all' failed make: *** [all] Error 2 -- John Griessen industromatic.com Austin TX building lab gear for biologists ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash on debian problem
On 07/10/2018 01:13 AM, Colin Law wrote: In what way does it fail? Colin Attempt to start gnucash: gnucash: symbol lookup error: /usr/lib/x86_64-linux-gnu/gnucash/gnucash/libgncmod-app-utils.so: undefined symbol: gnc_build_userdata_path ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] alphavantage quotes doesn't work
Hello, I'm trying to fix my automatic quotes import in GnuCash. I switched all my securities to get quotes with alphavantage. I put my key in Preferences->Online Quotes and as an env variable (ALPHAVANTAGE_API_KEY). When I push the "Get Quotes" button, gnucash processes things and gives me a dialog box saying 8< "Unable to retrieve quotes for these items: ETF Canada:VGRO.TO ETF US:QQQ [...] Continue using only the good quotes?" >8 I tried gnc-fq-dump and it works well: 8< nicolas@sylvestre:~$ gnc-fq-dump alphavantage VGRO.TO Finance::Quote fields Gnucash uses: symbol: VGRO.TO <=== required date: 07/13/2018 <=== recommended currency: CAD <=== required last: 25.3100 <=\ nav: <=== one of these price: <=/ timezone: <=== optional nicolas@sylvestre:~$ gnc-fq-dump alphavantage QQQ Finance::Quote fields Gnucash uses: symbol: QQQ <=== required date: 07/13/2018 <=== recommended currency: USD <=== required last: 179.6100 <=\ nav: <=== one of these price: <=/ timezone: <=== optional >8 I tried to run gnucash with -debug and -extra but gnucash or Finance::Quotes are pretty quiet. So I don't know how to investigate further. Could somebody help me? I'm running Gnucash 3.2+ (2018-06-24) with Finance::Quote: 1.47 under Debian Sid. Thanks -- Nicolas ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Forgot to attach the file. :-) 2018-07-13 23:02 GMT+02:00 Jeremy D : > Hi Geert, Frank, > > First of all, I really appreciate the feedback. > > > > > > > > > *assets: VAT reimbursable Buys @ full rate: 21% > : liabilities: VAT Sales: 21% > Import with VAT ID: 21%* > > This resembles more or less what my accountant told me to do. Also he > strongly advised against the use of foreign VAT accounts for any of my > purchases (as a matter of fact I still have only two accounts - VAT > Receivable/VAT Payable -, and both are in use for Belgium). That's why > there's no tax table in the example sent, I just added and subtracted the > VAT manually. However, this solution creates a problem in that the > Liabilities placeholder account now has increased so much and I don't know > what the next step is. > > My accountant and I created the example in my first message together but, > as he isn't familiar with Gnucash (he found it very difficult to use), I'm > afraid it might contain errors. > > I'm not an accountant by any means but I at least want to be able to > understand what I'm doing with regards to Gnucash. > > If it's not too much trouble, would you perhaps be so kind as to send me > one finished example of the former? Just to make sure I'm understanding > this correctly. I'm providing an early copy of my own Gnucash file in > attachment (I deleted all transactions first but all accounts necessary are > still there). > > *I hope, you did not, because negative amounts are reserved for stornos.* > > You mean, like in the case of a reimbursed expense? > > Thanks for the support! > > Jeremy > > 2018-07-13 21:35 GMT+02:00 Frank H. Ellenberger < > frank.h.ellenber...@gmail.com>: > >> Hi, >> >> Am 13.07.2018 um 17:42 schrieb Geert Janssens: >> > I don't have access to a gnucash installation currently so I can't >> verify my suggestion. But this is how I would handle it. >> > >> > - create two vat asset accounts. One for the Belgian vat and one for >> the foreign vat. >> > - create a tax table (which is all about vat) for your intra-European >> purchases. This tax table should have 2 entries >> > 1. Belgian vat (typically 21%), assigned to the Belgian vat account >> > 2. Foreign vat, which should be the negative percentage of the Belgian >> vat (so typically -21%), assigned to the foreign vat account. >> >> While most you are writing seems pretty simular to the situation in DE. >> I would not use negative rates. Instead I would use the folowing setup: >> assets: >> VAT reimbursable >> Buys @ full rate: 21% >> : >> liabilities: >> VAT >> Sales: 21% >> Import with VAT ID: 21% >> : >> For an optimal grouping of different rates, other cases of imports etc. >> compare your setup with your tax forms and discuss it with your CPA. >> >> With the rest, I aggree: >> >> > - now you can set tge default vat for your German vendor to this tax >> table. >> > When you enter you vendor bill on each line you enter the values >> without vat and double check the tax table is still the one for >> intra-European purchaes. >> > - note the purchase of a laptop should also go to an asset account >> (investment) so that's what you should enter as account in the entry (an >> entry is one line on your bill) >> > >> > - after posting this bill I believe it should create the correct >> transaction for you, including two vat entries in your assets and the net >> amount of the lap3in an investment account that can be used for >> depreciation. >> > - in addition the bill will be posted for the net amount such you can >> apply the correct payment. >> > >> > The only small detail I don't remember is whether I have changed the >> gnucash code already to allow negative percentages in tax tables. I think I >> have though. >> >> I hope, you did not, because negative amounts are reserved for stornos. >> >> > Geert >> > >> > Jeremy D schreef op 12 juli 2018 22:34:43 >> CEST: >> >> Hi, >> >> >> >> Someone on the #gnucash IRC channel suggested I write this message as I >> >> have quite a complex issue. >> >> >> >> Basically I've made a few purchases the last few months, most of which >> >> I >> >> paid without VAT. >> >> >> >> Here's a concrete example to help you better understand. >> >> >> >> I bought a laptop. This laptop cost € 2016, VAT included. However, as i >> >> have a VAT number, I paid only € 1694,12. >> >> >> >> A few prerequisites: >> >> >> >> >> >> - My accountant wants me to include foreign VAT as an asset and also >> >> include Belgian VAT as an asset. He calls that a "null operation" but >> >> it's >> >> necessary, he says. >> >> - Looking at my transaction report, we noticed the balance for each >> >> month isn't correct. It should be equal to zero. >> >> - This purchase has to be used as an investment (asset account) which >> >> can then be depreciated each year. >>
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Hi Geert, Frank, First of all, I really appreciate the feedback. *assets: VAT reimbursable Buys @ full rate: 21% : liabilities: VAT Sales: 21% Import with VAT ID: 21%* This resembles more or less what my accountant told me to do. Also he strongly advised against the use of foreign VAT accounts for any of my purchases (as a matter of fact I still have only two accounts - VAT Receivable/VAT Payable -, and both are in use for Belgium). That's why there's no tax table in the example sent, I just added and subtracted the VAT manually. However, this solution creates a problem in that the Liabilities placeholder account now has increased so much and I don't know what the next step is. My accountant and I created the example in my first message together but, as he isn't familiar with Gnucash (he found it very difficult to use), I'm afraid it might contain errors. I'm not an accountant by any means but I at least want to be able to understand what I'm doing with regards to Gnucash. If it's not too much trouble, would you perhaps be so kind as to send me one finished example of the former? Just to make sure I'm understanding this correctly. I'm providing an early copy of my own Gnucash file in attachment (I deleted all transactions first but all accounts necessary are still there). *I hope, you did not, because negative amounts are reserved for stornos.* You mean, like in the case of a reimbursed expense? Thanks for the support! Jeremy 2018-07-13 21:35 GMT+02:00 Frank H. Ellenberger < frank.h.ellenber...@gmail.com>: > Hi, > > Am 13.07.2018 um 17:42 schrieb Geert Janssens: > > I don't have access to a gnucash installation currently so I can't > verify my suggestion. But this is how I would handle it. > > > > - create two vat asset accounts. One for the Belgian vat and one for the > foreign vat. > > - create a tax table (which is all about vat) for your intra-European > purchases. This tax table should have 2 entries > > 1. Belgian vat (typically 21%), assigned to the Belgian vat account > > 2. Foreign vat, which should be the negative percentage of the Belgian > vat (so typically -21%), assigned to the foreign vat account. > > While most you are writing seems pretty simular to the situation in DE. > I would not use negative rates. Instead I would use the folowing setup: > assets: > VAT reimbursable > Buys @ full rate: 21% > : > liabilities: > VAT > Sales: 21% > Import with VAT ID: 21% > : > For an optimal grouping of different rates, other cases of imports etc. > compare your setup with your tax forms and discuss it with your CPA. > > With the rest, I aggree: > > > - now you can set tge default vat for your German vendor to this tax > table. > > When you enter you vendor bill on each line you enter the values without > vat and double check the tax table is still the one for intra-European > purchaes. > > - note the purchase of a laptop should also go to an asset account > (investment) so that's what you should enter as account in the entry (an > entry is one line on your bill) > > > > - after posting this bill I believe it should create the correct > transaction for you, including two vat entries in your assets and the net > amount of the lap3in an investment account that can be used for > depreciation. > > - in addition the bill will be posted for the net amount such you can > apply the correct payment. > > > > The only small detail I don't remember is whether I have changed the > gnucash code already to allow negative percentages in tax tables. I think I > have though. > > I hope, you did not, because negative amounts are reserved for stornos. > > > Geert > > > > Jeremy D schreef op 12 juli 2018 22:34:43 > CEST: > >> Hi, > >> > >> Someone on the #gnucash IRC channel suggested I write this message as I > >> have quite a complex issue. > >> > >> Basically I've made a few purchases the last few months, most of which > >> I > >> paid without VAT. > >> > >> Here's a concrete example to help you better understand. > >> > >> I bought a laptop. This laptop cost € 2016, VAT included. However, as i > >> have a VAT number, I paid only € 1694,12. > >> > >> A few prerequisites: > >> > >> > >> - My accountant wants me to include foreign VAT as an asset and also > >> include Belgian VAT as an asset. He calls that a "null operation" but > >> it's > >> necessary, he says. > >> - Looking at my transaction report, we noticed the balance for each > >> month isn't correct. It should be equal to zero. > >> - This purchase has to be used as an investment (asset account) which > >> can then be depreciated each year. > >> > >> > >> I thought I was able to solve the problem by creating a bill linked to > >> the > >> vendor (Business\Vendor\New Bill), then posting the bill and processing > >> the > >> payment - amount without VAT linked to checking a
Re: [GNC] gnucash on debian problem
On Sat, 14 Jul 2018, 03:15 John Griessen, wrote: > On 07/10/2018 01:13 AM, Colin Law wrote: > > In what way does it fail? > > > > Colin > > Attempt to start gnucash: > > gnucash: symbol lookup error: > /usr/lib/x86_64-linux-gnu/gnucash/gnucash/libgncmod-app-utils.so: undefined > symbol: > gnc_build_userdata_path > Oh, you said the attempted upgrade failed. So after upgrading you get that error. How did you upgrade and what is shown by apt-cache policy gnucash Also what is shown by which gnucash Colin > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
