Re: [GNC] GnuCash preferred OS - Windows or Linux

[Ben Kamen]

On 7/25/23 9:31 PM, R Losey wrote:

Ben, welcome!


Thanks!



I have macOS, Linux (Ubuntu 22.04LTS), and Windows 10.  I love the fact that 
GnuCash runs on all these platforms; I have my data stored on a mirrored 
external drive, so all computers can see it.

As an OS, I like Linux the best.

However, unless one is willing to do one's own builds, you're rather stuck with 
the distribution's version, which falls behind over time. I think Ubuntu 
22.04LTS comes with GnuCash 4.8, and it's up to 5.3. I'm always a little 
worried about file compatibility between major versions, so I tend to avoid 
running on Linux. One can use flatpack (flatpak?) to get the latest version on 
Linux or, as I wrote, you can build GnuCash. I ran into trouble doing this 
under a previous version of Ubuntu, and it left GnuCash in in unusable state.


I'm not afraid of compiling stuff (I design FPGAs and regularly have to write 
the Linux Kernel drivers for my FPGA device designs and then the userland 
software to drive it. Oy!)

but I do like to run my financial stuff in a dedicated thin install of windows 
in a VM on my main Linux server which I can get to from everywhere via VPN 
tunnel back to my server with VNC. So there is that.



Thus, I rarely run GnuCash on Linux - it's usually WIndows or macOS.


Gotcha. And I can live with that.



If you can get GnuCash running on Linux, it's nice that Linux already has perl, 
so one doesn't have to install a perl environment (should you care about online 
quotes).

I started tinkering with it on my laptop which is Mint (with a Windows VM via 
VBox) -- but really dug in deep with the install on the aforementioned windows 
VM on my network's central Linux Server.



I gave up trying to get GnuCash to talk to various financial institutions; I 
enter everything manually and routinely balance my accounts. It works for me.


OK - that's good to know. A major reason I'm ticked at QB/Intuit is their mucking 
with the sync stuff (when they don't have to) and the choice there is, "If I'm 
going to manually enter transactions, then is moving to something else even worth 
it. The whole point is to avoid the double entry errors if possible.)

Thanks for the info though... I'm gonna keep tinkering for now.

Cheers,

 -Ben


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Ben Kamen]

On 7/25/23 10:03 PM, Adrien Monteleone wrote:

In addition to what R Losey mentioned, I'll add that while GnuCash can use 
MySQL, Postgres, or SQLite as an optional backend, it is not yet a true db 
application. For now, that is just a storage mechanism. Everything is loaded 
into RAM and edited from there.

The advantage to the SQL backends (other than outside queries if you so desire) 
is instant saves, where the default XML backend either needs to be saved 
manually, or at set intervals. (the default)

One other caveat - writing to the db store is not currently supported. It isn't 
that you can't at all, but you are warned and on your own if you corrupt your 
data. Some folks may report success here, but don't just jump in and start 
editing data via SQL willy-nilly. (reading is fine)



Yea. Still playing. And did read the parts about the DB connections being full 
of important warnings/caveats/Stuff-I-Should-Know.


You can check out the Roadmap on the wiki to see the progress done on the code 
transformation that will enable a proper db-based app.


Will do.



As for the banking connection - sorry I can't help, but plenty of folks on this 
list do, so they can hopefully jump in and offer some guidance. (if I 
understand it correctly, you will not be able to 'initiate' a transaction 
directly from GnuCash to your bank, you will only be able to download 
transactions, and there are other options than a direct connection.)


Yea - that's all I ever did with QB anyway - except initiating transfers which 
I can do manually via bank's web login anyway.

I saw the notes about unidirection transaction download only -- and I'm ok with 
that.




As for OS, I use Mac daily, but occasionally test on Linux. (Ubuntu) I used to 
do that via builds if needed, and I've had a few hiccups, but those were mostly 
resolved. I've since resorted to testing flatpak builds (on Mint) without any 
major issues. Your mileage may vary.


Also a Mint user on my laptop. (two thumbs up)

Thanks,

 -Ben
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Ben Kamen]

On 7/26/23 7:37 AM, Kalpesh Patel wrote:

Welcome to GNC.

I am on Windows 11 platform where I seem to find it that I get into less of 
troubles when it comes to getting it installed and, up and running. I have been 
versed in all three platforms (Windows, Linux and Mac) but I find it easier to 
work with it in Windows. There are some manual one time install intervention 
needed (installing Perl for example; figuring out Linux equivalent paths for 
customization and backups) but it is not that earth shattering as I believe 
lots of kinks has been worked out, documented here and there, there is user 
contributed work around if need to resort to it and this user group which is 
active.

At the end of the day, don't let GNC dictate which platform you want as more of 
let your utility of the platform dictate what platform to run it on. All three 
platforms are supported so you are in IMHO good hands, albeit different 
platform may exhibit different bugs or un-published features per release. I do 
now and then flip the platform between Linux and Windows as a convenience but 
stay mostly on Windows.


Got it.


I use XML as the backend for storage which works well even considering that it is medium 
to large size book. It provides easiest ways to recover, share, fix and rollback (take a 
checkpoint or copy before "experimenting") should there be a problem.

That's good to know too. Thanks!


I am covert from Quicken so I have learned great deal of lessons from 
conversion especially getting to learn double entry system - start with zero 
and end with zero 😊.

As a convert, I did lose a lot of automated download via direct connect or 
Quicken Web Express but since most financial institution allows download of 
transactions in OFX/QFX or CSV format, I simply just download it in OFX/QFX 
format and import to bring transactions up to date or I'll put together 
something crude in shell script to convert CSV to QIF format and import it as 
QIF format.

That's a good item as well. My bank allows CSV, QFX and QBO formats while my 
credit cards allow CSV and QFX.

If I have to do the downloads manually (as long as I avoid double entry of 
every transaction), that would work out fine too.

Thanks for the info,

 -Ben

  



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Ben Kamen]

On 7/26/23 7:55 AM, Mark at Lorimark wrote:

I am a staunch Linux user, and came from the Quickbooks world as well. I am 
running a very small database, but have it in the sqlite, since that (for me) 
is very easy to work inside of if i need to poke around in the database (which 
I do).



Which version of Linux? And are you compiling or running flatpak or distro 
supplied versions?




I much prefer the 'double entry' approach to things rather than the bubble 
wrapped QB environment


I always worry about missing something somewhere.



and yes QB is getting expensive!


It's irritating as the pricing jump is so obviously designed to push users to 
their web product and it's just gobsmacking that anyone at a financial software 
company would think it's a good idea to put one's financial life onto cloud 
services. (whether personal or company/business)

And then there's Intuit. Go figure.

Insane.


I can't imagine any functional difference between any of the platforms as it pertains to GnuCash. 


Yea, I just have to keep plugging at it to figure out how to make everything 
work for me.

Thanks,

 -Ben

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Construction Billing By Project

[Angela Haggerty]

Firstly, it's past 3 AM and I am arguing with myself on how to enter
construction projects into GNUCash for a bookkeeping LLC client. This may
have been asked before but I did not find it in the search of terms I used.
This may not be the proper place to post feature ideas but again it's 3 AM
and I want this out of my head before I fall asleep and forget. :)

Secondly, the stunning idea that hit me tonight! Currently, GNUCash can
link invoices, payments, and customer-billed liabilities to one another in
lots, but it does not link expenses in this process. I have to go in and
build lots for each job in the cash account they are paid from. If there
was a way to link expenses to the invoices or build on the lot system to
add a column to the register to enter a lot ID or other mechanism to link
expenses to invoices and payments as they are entered it would make billing
for my construction client a LOT easier and more streamlined.

At this time, the client sends job sheets after the project's completion
unless we are close to year-end. And sorting through the job sheet while
switching between expense windows and invoice windows is tedious,
time-consuming, and an accounting disaster waiting to happen. It is also
more difficult to advise the client which tickets and jobs are profitable
if they are not connected in some way in the accounting system. This wasn't
such an issue before but I have noticed growing numbers of clients picking
up side hustles and gig work in this economy so there is more need now for
a project system in GNUCash in my opinion.

Thank You For Reading
A.Haggerty
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Cannot write to file

[Mahon Finbar via gnucash-user]

The problem is I don't know): I suspect that I may have placed something 
on the keyboard, as you do when one is dealing with accounts);


I think from the look at what happens when I click the link, a folder 
opens with the gnu set of files in it, headed (delete), that I opened 
some sort of gnu file?


How can I eliminate it??.

Sorry.

Barry

On 26/07/2023 20:54, Adrien Monteleone wrote:

Do you have enough disk space as the message suggests?

The 'file' is a report? What *exactly* were you trying to do when you 
got the message?


Regards,
Adrien

On 7/26/23 5:29 AM, Mahon Finbar via gnucash-user wrote:

I have a message -

"Could not write to file C: xxx check that you have permission to 
write to this file and there is sufficient space to create it"


The file is a report of annual P&L that I have open , but I am not 
working on it


What is the problem??


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Doug]

On Thu, 27 Jul 2023 03:14:07 -0500
my 2c worth: I have been running Gnucash on PCLinuxOS forever (or so it seems).
They are usually up to date with releases. Currently Build ID: 
5.3+(2023-06-26). 
Loaded weeks ago.

 Love both Gnucash, & PCLinuxOS: they both just work!
 Only thing I could have used was GST support(a VAT type tax used in Australia) 
when I was running a 
business, but now I am retired, who cares! (the go-go years, the slo-go years,
then the no-go years! Currently towards end of go-go...

Thanks to the Developers for the support over the years.

regards, Doug


Ben Kamen  wrote:

> On 7/26/23 7:55 AM, Mark at Lorimark wrote:
> > I am a staunch Linux user, and came from the Quickbooks world as well. I am 
> > running a very small database, but have it in the sqlite, since that (for 
> > me) is very easy to work inside of if i need to poke around in the database 
> > (which I do).  
> 
> 
> Which version of Linux? And are you compiling or running flatpak or distro 
> supplied versions?
> 
> 
> >
> > I much prefer the 'double entry' approach to things rather than the bubble 
> > wrapped QB environment  
> 
> I always worry about missing something somewhere.
> 
> >
> > and yes QB is getting expensive!  
> 
> It's irritating as the pricing jump is so obviously designed to push users to 
> their web product and it's just gobsmacking that anyone at a financial 
> software company would think it's a good idea to put one's financial life 
> onto cloud services. (whether personal or company/business)
> 
> And then there's Intuit. Go figure.
> 
> Insane.
> 
> 
> > I can't imagine any functional difference between any of the platforms as 
> > it pertains to GnuCash.   
> 
> Yea, I just have to keep plugging at it to figure out how to make everything 
> work for me.
> 
> Thanks,
> 
>   -Ben
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Issue with Finance::Quote

[bern...@deprez.biz]

Thanks for that suggestion - did that on 2 different Windows systems, 
both still fail the same way...


C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ
* 10:21:02 ERROR  [parse_quotesource_error()] 
Unrecognized Finance::Quote Error Can't use an undefined value as a HASH 
reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm 
line 234.
Finance::Quote retrieval failed with error Unrecognized Finance::Quote 
Error: Can't use an undefined value as a HASH reference at 
C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.


I've even tried a new Alphavantage API key (with different email) - same 
issue


Is Alphavantage the only solution? I see multiple other sources but not 
googleweb for example...


Thx,
B.


On 26/07/2023 23:57, john wrote:


It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry 
Perl cpan shell and telling it `force install Finance::Quote` to reinstall it.

Regards,
John Ralls


On Jul 26, 2023, at 04:48, bern...@deprez.biz wrote:

Hi Ken,

I tried googleweb and get a response

C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump googleweb QQQ
Finance::Quote fields GnuCash uses:
 symbol: QQQ <=== required
   date: 07/25/2023  <=== recommended
   currency: USD <=== required
   last: 378.78  <=\
nav: <=== one of these
  price: <=/

That is indeed the last price available

So I guess it's an issue only with alphavantage? I triplechecked my API key (which 
is set both as an environment variable & in GnuCash) and it is the correct one.

Any other suggestions that could help me?

Thanks,
Bernard


On 25/07/2023 22:01, Ken Farley wrote:

Are you able to get quotes for that particular security using any of the other 
sources in F::Q, like googleweb, yahooweb, yahoo_json? I get prices from any 
one of those.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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@gnucash.org
To update your subscription preferences or to unsubscribe:
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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Cannot write to file

[Fred Bone]

On 26 July 2023 at 12:29, Mahon Finbar said:

> I have a message -
> 
> "Could not write to file C: xxx check that you have permission to
> write to this file and there is sufficient space to create it"
> 
> The file is a report of annual P&L that I have open , but I am not 
> working on it
> 
> What is the problem??

The problem is that you have it open in another application, so it cannot 
be overwritten.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] strange lack of exchange rates in a new currency cash account

[john]

Scott,

Aha! Yes, I recall some bug fixes around pricing and VND in particular in the 
last couple of years.

Ubuntu updates application versions only at releases, so if you want to keep up 
with GnuCash that way you have to upgrade every April and October. You could 
switch to Debian Testing, which is what Ubuntu's releases are pulled from. That 
operates as a rolling release so no upgrades are needed. The updates in testing 
have been vetted for a few weeks to months in Debian Unstable, so they're a bit 
less bleeding-edge than other rolling-release distros like Arch or Fedora 
Rawhide.

Or you can keep right up to date with flatpak.

Regards,
John Ralls

> On Jul 26, 2023, at 21:41, Scott Ellsworth  wrote:
> 
> Hi John,
> 
> It turns out that I had the latest version of GnuCash that's supported by my 
> version of Ubuntu (v3.8b). I installed Flatpak and used it to install GnuCash 
> v5.3. I entered a grocery-store purchase for today, and entered the exchange 
> rate manually as "1/23600." After I completed the transaction, the Account 
> Summary then displayed a normal dollar value for my dong cash. I tried 
> entering a couple test transactions (an ATM withdrawal and a gift-store 
> purchase), and everything still seemed to work normally. So far it always 
> shows a dollar equivalent that looks normal on the Account Summary.
> 
> So I think this must have been a bug that has been fixed in the past few 
> years. Thank you for your help. 
> 
> I also like the new selection feature for auto-completion of new register 
> entries.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: Scott Ellsworth mailto:sc...@fastmail.us>>
> To: john mailto:jra...@ceridwen.us>>
> Cc: GnuCash user forum  >
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Wednesday, July 26, 2023 11:18
> 
> Hi John,
> 
> I just tried a test transaction, an ATM withdrawal in Malaysian ringgits, and 
> it worked flawlessly like usual, using the previous exchange rate by default, 
> and showing a correct dollar value for the Malaysian cash afterwards in the 
> Account Summary. T\S the glitch appears to only affect Vietnamese dong, 
> perhaps because the currency unit is so tiny. As mentioned, I tried creating 
> a new dong cash account and the same glitches started happening in it as well.
> 
> I have the box unchecked for Force Decimals. I looked at my GnuCash version, 
> and it's v3.8, running on Ubuntu Linux 20.04.6 LTS. I run updates every 
> Sunday, but come to think of it now, I haven't seen Gnucash update in a 
> really long time. I last reinstalled my computer in the fall of 2021. Perhaps 
> the Gnucash installation process in the Ubuntu Software GUI doesn't currently 
> include setting up the repository for updates. I need to move along to other 
> things right now, but maybe tomorrow I'll try reinstalling to the latest 
> version of GnuCash that my OS version will allow.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: john mailto:jra...@ceridwen.us>>
> To: Scott Ellsworth mailto:sc...@fastmail.us>>
> Cc: GnuCash user forum  >
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Tuesday, July 25, 2023 22:44
> 
> Scott,
> 
> I don't know what's going on and I can't replicate it. I created a VND 
> account in a test book and created the following transactions (This is a 
> Transaction report with one line per split set on the Display tab. I've also 
> turned off Force prices to decimal in Preferences>Numbers, Date, Time.):
> 
> Date Account Shares Price  Debit Credit
> 
> 01/01/2023 VND Cash 2,000,000.00 $0.425 ₫2,000,000
> Checking Account -85.00 $1.  $85.00
> 07/23/2023 VND Cash -49,530.00  ₫1.00 ₫49,530
> Books 2.09 ₫23,698 + 118/209 $2.09
> 07/25/2023 VND Cash -136,000.00  ₫1.00  ₫136,000
> Groceries 5.68  ₫23,943 + 47/71 $5.68
> 
> I entered the price three different ways: For the first I started in the 
> USD-denominated Checking Account register, entered 85.00 in the register's 
> Credit field and 200 in the Debit Amount field of the transfer dialog. 
> The other two I started in the VND Cash register and put values in the price 
> field; as a rational number for the first and a decimal number (editing the 
> one the Transfer dialog presented; that was before I changed the Force prices 
> to decimal preference. The book does not have Trading accounts enabled. 
> GnuCash is v5.3.
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Jul 25, 2023, at 00:57, Scott Ellsworth  wrote:
>> 
>> Hi John,
>> 
>> Another update about the strange behavior: Just now I came back from 
>> shopping and recorded three transactions. When inputting the first 
>> transaction, the exchange rate was still in place from yesterday. For the 
>> second and third transactions, 

Re: [GNC] Upgrading to 5.3 from 2.6.15

[Adrien Monteleone]

Note, I did some testing this morning and it seems there might be a bug 
in how the 'include collapsed periods after selected' works.


Follow along here or subscribe to the bug: 
https://bugs.gnucash.org/show_bug.cgi?id=799046


If this can be resolved, you should be able to get close, but not quite 
to Phil's report.


The first set of columns would be the period of interest. You would 
*not* want to use 'accumulated amounts' here if you want to see how that 
period's actuals faired against that period's budgeted amounts.


The second set of columns (the subsequent collapsed periods) *should* by 
necessity of being collapsed, show what is left, as YTD numbers.


The third set of columns would be Totals, which is for the entire budget 
period.


Note, if the second set isn't quite what you are looking for, I'm not 
sure you can duplicate that old report in one shot. In that case, you 
would then simply only report on one period (and the Totals) and choose 
either 'accumulated amounts' or not based on if you wanted numbers for 
just that period *or* YTD as of that period. In which case, you can't 
get both at the same time.


Regards,
Adrien

On 7/27/23 1:48 AM, larry johnston wrote:

Thanks, I will see what I can make of it.

Larry


On Wed, Jul 26, 2023, 9:48 p.m. Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


You should be able to get close.

You can see monthly periods, you can 'use accumulated totals' for each
month as they progress. (YTD) You can show a yearly 'Totals' column set.

For each set (period & total) you can see Budget, Actual, and Variance
columns.

I don't think it is exactly just 1 month, YTD, Total though.

But you might try playing with the Range & Consolidated options on the
General tab. So maybe set the range to 'current period' for a start,
'last period' for end, and then consolidate the periods after the
current one which should then show up as a single set of YTD type
numbers if using Accumulated Amounts. And then display a Totals column
and of course include Budget, Actual & Variance options.

Note too, you can customize the budget time frame itself. It doesn't
have to be an entire year. Maybe a combination of all of the above will
imitate Phil's report.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Construction Billing By Project

[Adrien Monteleone]

That sounds outside of GnuCash's scope, but I could be mistaken. You 
might fare better with less stress finding a solution with a different 
software package for billing, and then import the resulting invoices in 
GnuCash for accounting and AR management.


*note, 'Jobs' in GnuCash are really misnamed. They are more of a 
Purchase Order. And note that a Job for a Vendor, even if it has the 
same name, is *not* the same as a Job for a Customer. They do not link.


There is also (not yet) a relatively painless way of reporting say a P&L 
for a single Job. (but if the P&L report ever adds the filter/tag 
options that the Transaction Report has, that would be gravy) It isn't 
that it can't currently be done, but it isn't obvious how to achieve it, 
and it will still take some manipulating of reports in a spreadsheet 
outside of GnuCash at some point.


Regards,
Adrien

On 7/27/23 3:43 AM, Angela Haggerty wrote:

Firstly, it's past 3 AM and I am arguing with myself on how to enter
construction projects into GNUCash for a bookkeeping LLC client. This may
have been asked before but I did not find it in the search of terms I used.
This may not be the proper place to post feature ideas but again it's 3 AM
and I want this out of my head before I fall asleep and forget. :)

Secondly, the stunning idea that hit me tonight! Currently, GNUCash can
link invoices, payments, and customer-billed liabilities to one another in
lots, but it does not link expenses in this process. I have to go in and
build lots for each job in the cash account they are paid from. If there
was a way to link expenses to the invoices or build on the lot system to
add a column to the register to enter a lot ID or other mechanism to link
expenses to invoices and payments as they are entered it would make billing
for my construction client a LOT easier and more streamlined.

At this time, the client sends job sheets after the project's completion
unless we are close to year-end. And sorting through the job sheet while
switching between expense windows and invoice windows is tedious,
time-consuming, and an accounting disaster waiting to happen. It is also
more difficult to advise the client which tickets and jobs are profitable
if they are not connected in some way in the accounting system. This wasn't
such an issue before but I have noticed growing numbers of clients picking
up side hustles and gig work in this economy so there is more need now for
a project system in GNUCash in my opinion.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Adrien Monteleone]

GnuCash won't let you make 'double entry errors'.

It helpfully forces all transactions to balance.

It does this by automatically creating a split assigned to either the 
Imbalance or Orphan accounts if you fail to balance the transaction 
properly and commit it anyway. (I don't recall the rules as to which one 
it uses when, but that is likely documented in Help)


If you ever see a balance in those accounts, you can bet you made a 
mistake, and then you can look it over to fix it. (they should be quite 
limited in number unless you import transactions by the hundreds and 
then don't review them in the process properly)


For some transactions, I don't enter them in a timely fashion, so if I'm 
unsure of some part of it, I'll assign a split to one of those accounts 
just as a 'tagging' method so I don't lose track of them with a note to 
investigate further.


Of course, there is plenty of room for other types of mistakes, but that 
is true of any software, or pen and paper.


Regards,
Adrien

On 7/27/23 2:59 AM, Ben Kamen wrote:
The whole point is to avoid the 
double entry errors if possible.)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Upgrading to 5.3 from 2.6.15

[larry johnston]

Thanks. I have to put this project onhold for a while. Fortunately 'use
accumulated totals' gives me the basics that I need and the rest is gravy
if I can get it.


Larry

On Thu, Jul 27, 2023 at 9:43 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Note, I did some testing this morning and it seems there might be a bug
> in how the 'include collapsed periods after selected' works.
>
> Follow along here or subscribe to the bug:
> https://bugs.gnucash.org/show_bug.cgi?id=799046
>
> If this can be resolved, you should be able to get close, but not quite
> to Phil's report.
>
> The first set of columns would be the period of interest. You would
> *not* want to use 'accumulated amounts' here if you want to see how that
> period's actuals faired against that period's budgeted amounts.
>
> The second set of columns (the subsequent collapsed periods) *should* by
> necessity of being collapsed, show what is left, as YTD numbers.
>
> The third set of columns would be Totals, which is for the entire budget
> period.
>
> Note, if the second set isn't quite what you are looking for, I'm not
> sure you can duplicate that old report in one shot. In that case, you
> would then simply only report on one period (and the Totals) and choose
> either 'accumulated amounts' or not based on if you wanted numbers for
> just that period *or* YTD as of that period. In which case, you can't
> get both at the same time.
>
> Regards,
> Adrien
>
> On 7/27/23 1:48 AM, larry johnston wrote:
> > Thanks, I will see what I can make of it.
> >
> > Larry
> >
> >
> > On Wed, Jul 26, 2023, 9:48 p.m. Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> You should be able to get close.
> >>
> >> You can see monthly periods, you can 'use accumulated totals' for each
> >> month as they progress. (YTD) You can show a yearly 'Totals' column set.
> >>
> >> For each set (period & total) you can see Budget, Actual, and Variance
> >> columns.
> >>
> >> I don't think it is exactly just 1 month, YTD, Total though.
> >>
> >> But you might try playing with the Range & Consolidated options on the
> >> General tab. So maybe set the range to 'current period' for a start,
> >> 'last period' for end, and then consolidate the periods after the
> >> current one which should then show up as a single set of YTD type
> >> numbers if using Accumulated Amounts. And then display a Totals column
> >> and of course include Budget, Actual & Variance options.
> >>
> >> Note too, you can customize the budget time frame itself. It doesn't
> >> have to be an entire year. Maybe a combination of all of the above will
> >> imitate Phil's report.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Windows 11 GnuCash 4.14 vs 5.3

[larry johnston]

We have just upgraded from 2.6.15 to 4.14. We are trying to decide if we
should go to 5.3. We use GnuCash only for basic home finances. An important
feature that we want to use is the  'use accumulated totals' in our
budget reports. This feature is available in 4.14 so we have stopped there.
What advantages or disadvantages are there to continuing on to 5.3?

TIA,

Larry
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Issue with Finance::Quote

[Bruce Schuck]

On 7/27/23 10:37:17 -0400, Bernard wrote:


Thanks for that suggestion - did that on 2 different Windows systems,
both still fail the same way...



C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ
* 10:21:02 ERROR  [parse_quotesource_error()]
Unrecognized Finance::Quote Error Can't use an undefined value as a HASH
reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm
line 234.
Finance::Quote retrieval failed with error Unrecognized Finance::Quote
Error: Can't use an undefined value as a HASH reference at
C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.


Please verify the version of Finance::Quote. On Linux:

$ perl -MFinance::Quote -e 'print "$Finance::Quote::VERSION\n"'
1.57

On Windows:

C:\Users\bschuck>perl -MFinance::Quote -e "print 
qq{{$Finance::Quote::VERSION\n}}"

{1.57
}

C:\Users\bschuck>gnucash-cli -Q dump alphavantage QQQ
Finance::Quote fields GnuCash uses:
symbol: QQQ <=== required
  date: 07/26/2023  <=== recommended
  currency: USD <=== required
  last: 377.5200<=\
   nav: <=== one of these
 price: <=/

You should also be able to execute the example perl script that comes 
with the Finance::Quote module package.


Since you are on Windows and recently installed Finance::Quote:

> cd C:\Strawberry\cpan\build\Finance-Quote-1.57-0

C:\Strawberry\cpan\build\Finance-Quote-1.57-0>perl Examples\stockdump.pl 
alphavantage QQQ


$VAR1 = {
  'QQQ∟net' => '-1.2600',
  'QQQ∟symbol' => 'QQQ',
  'QQQ∟success' => 1,
  'QQQ∟currency' => 'USD',
  'QQQ∟currency_set_by_fq' => 1,
  'QQQ∟date' => '07/26/2023',
  'QQQ∟volume' => '47075710',
  'QQQ∟method' => 'alphavantage',
  'QQQ∟open' => '377.7200',
  'QQQ∟p_change' => '-0.3326',
  'QQQ∟close' => '378.7800',
  'QQQ∟last' => '377.5200',
  'QQQ∟low' => '375.1800',
  'QQQ∟isodate' => '2023-07-26',
  'QQQ∟high' => '379.2400'
};
C:\Strawberry\cpan\build\Finance-Quote-1.57-0>

Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[Kalpesh Patel]

GNC uses single matcher engine for all imports which I must say is very, very 
good. Once it is trained up, it should suggest to put things into right buckets 
as the contra side of the transaction. There also ability to add, update, 
ignore and reconcile for each transaction imported via ofx/qfx or csv engines.

If you are going to perform pure imports without inputting transactions ahead 
of time then issue of double entry does not arise.  

-Original Message-
From: Ben Kamen  
Sent: Thursday, July 27, 2023 4:10 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash preferred OS - Windows or Linux

On 7/26/23 7:37 AM, Kalpesh Patel wrote:
> Welcome to GNC.
>
> I am on Windows 11 platform where I seem to find it that I get into less of 
> troubles when it comes to getting it installed and, up and running. I have 
> been versed in all three platforms (Windows, Linux and Mac) but I find it 
> easier to work with it in Windows. There are some manual one time install 
> intervention needed (installing Perl for example; figuring out Linux 
> equivalent paths for customization and backups) but it is not that earth 
> shattering as I believe lots of kinks has been worked out, documented here 
> and there, there is user contributed work around if need to resort to it and 
> this user group which is active.
>
> At the end of the day, don't let GNC dictate which platform you want as more 
> of let your utility of the platform dictate what platform to run it on. All 
> three platforms are supported so you are in IMHO good hands, albeit different 
> platform may exhibit different bugs or un-published features per release. I 
> do now and then flip the platform between Linux and Windows as a convenience 
> but stay mostly on Windows.

Got it.

> I use XML as the backend for storage which works well even considering that 
> it is medium to large size book. It provides easiest ways to recover, share, 
> fix and rollback (take a checkpoint or copy before "experimenting") should 
> there be a problem.
That's good to know too. Thanks!

> I am covert from Quicken so I have learned great deal of lessons from 
> conversion especially getting to learn double entry system - start with zero 
> and end with zero 😊.
>
> As a convert, I did lose a lot of automated download via direct connect or 
> Quicken Web Express but since most financial institution allows download of 
> transactions in OFX/QFX or CSV format, I simply just download it in OFX/QFX 
> format and import to bring transactions up to date or I'll put together 
> something crude in shell script to convert CSV to QIF format and import it as 
> QIF format.
That's a good item as well. My bank allows CSV, QFX and QBO formats while my 
credit cards allow CSV and QFX.

If I have to do the downloads manually (as long as I avoid double entry of 
every transaction), that would work out fine too.

Thanks for the info,

  -Ben

   




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Account Tabs

[R Losey]

On Wed, Jul 26, 2023 at 7:42 PM Gyle McCollam  wrote:

> If my accounts page view does not show zero balance accounts, but I want
> to open a zero-balance account is there a way to do this without changing
> the view, opening, and the changing the view back?
>


I don't know any easy way... I just show zero-balance accounts. Accounts
that are inactive I "hide".

_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash preferred OS - Windows or Linux

[R Losey]

On Thu, Jul 27, 2023 at 2:59 AM Ben Kamen  wrote:

> On 7/25/23 9:31 PM, R Losey wrote:
>
>
>
> I'm not afraid of compiling stuff (I design FPGAs and regularly have to
> write the Linux Kernel drivers for my FPGA device designs and then the
> userland software to drive it. Oy!)
>
> but I do like to run my financial stuff in a dedicated thin install of
> windows in a VM on my main Linux server which I can get to from everywhere
> via VPN tunnel back to my server with VNC. So there is that.
>

Noted. While I have built some apps under Linux, I attempted to build
GnuCash once upon a time (before I knew about this list), and it failed...
it failed badly enough that it corrupted my existing Linux install, and I
could not run GnuCash at all. With this list available, I may try again
sometime to do the build... I will need to set aside the time.



> If you can get GnuCash running on Linux, it's nice that Linux already has
> perl, so one doesn't have to install a perl environment (should you care
> about online quotes).
>
> I started tinkering with it on my laptop which is Mint (with a Windows VM
> via VBox) -- but really dug in deep with the install on the aforementioned
> windows VM on my network's central Linux Server.
>


I don't know if you'll use the stock quotes, but on Windows, you have to
install a Windows-based perl environment (Strawberry Perl, I think). Even
then, it didn't seem to work well for me. I may have just given up too
easily.  But if you don't need this feature, windows will work great.  For
the last several years of using Quicken, I ran it on a Virtualbox VM
running Windows.



I gave up trying to get GnuCash to talk to various financial institutions;
> I enter everything manually and routinely balance my accounts. It works for
> me.
>
>
> OK - that's good to know. A major reason I'm ticked at QB/Intuit is their
> mucking with the sync stuff (when they don't have to) and the choice there
> is, "If I'm going to manually enter transactions, then is moving to
> something else even worth it. The whole point is to avoid the double entry
> errors if possible.)
>

I used sync under Quicken, but only to check that I hadn't missed anything.
From what I've read, it can be a bit of an issue in GnuCash, so I'm fine
with entering things manually and reconciling accounts on a regular basis.




> Thanks for the info though... I'm gonna keep tinkering for now.
>

You're welcome... Enjoy tinkering!!

_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Issue with Finance::Quote

[John Ralls]

Try this: Open a Strawberry Perl shell, and run

C:\Windows>set ALPHAVANTAGE_API_KEY=A1B2C3D4E5
C:\Windows>c:\Strawberry\cpan\build\Finance-Quote-1.57-0\Examples\stockdump.pl 
alphavantage QQQ

If you still get the "Can't get an undefined value" error you have good reason 
to open an issue at https://github.com/finance-quote/finance-quote/issues.

If not there's more to investigate here.

Regards,
John Ralls



> On Jul 27, 2023, at 7:37 AM, bern...@deprez.biz wrote:
> 
> Thanks for that suggestion - did that on 2 different Windows systems, both 
> still fail the same way...
> 
> C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ
> * 10:21:02 ERROR  [parse_quotesource_error()] Unrecognized 
> Finance::Quote Error Can't use an undefined value as a HASH reference at 
> C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.
> Finance::Quote retrieval failed with error Unrecognized Finance::Quote Error: 
> Can't use an undefined value as a HASH reference at 
> C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.
> 
> I've even tried a new Alphavantage API key (with different email) - same issue
> 
> Is Alphavantage the only solution? I see multiple other sources but not 
> googleweb for example...
> 
> Thx,
> B.
> 
> 
> On 26/07/2023 23:57, john wrote:
> 
>> It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry 
>> Perl cpan shell and telling it `force install Finance::Quote` to reinstall 
>> it.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Jul 26, 2023, at 04:48, bern...@deprez.biz wrote:
>>> 
>>> Hi Ken,
>>> 
>>> I tried googleweb and get a response
>>> 
>>> C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump googleweb QQQ
>>> Finance::Quote fields GnuCash uses:
>>> symbol: QQQ <=== required
>>>   date: 07/25/2023  <=== recommended
>>>   currency: USD <=== required
>>>   last: 378.78  <=\
>>>nav: <=== one of these
>>>  price: <=/
>>> 
>>> That is indeed the last price available
>>> 
>>> So I guess it's an issue only with alphavantage? I triplechecked my API key 
>>> (which is set both as an environment variable & in GnuCash) and it is the 
>>> correct one.
>>> 
>>> Any other suggestions that could help me?
>>> 
>>> Thanks,
>>> Bernard
>>> 
>>> 
>>> On 25/07/2023 22:01, Ken Farley wrote:
 Are you able to get quotes for that particular security using any of the 
 other sources in F::Q, like googleweb, yahooweb, yahoo_json? I get prices 
 from any one of those.
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 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@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Windows 11 GnuCash 4.14 vs 5.3

[R Losey]

On Thu, Jul 27, 2023 at 12:05 PM larry johnston 
wrote:

> We have just upgraded from 2.6.15 to 4.14. We are trying to decide if we
> should go to 5.3. We use GnuCash only for basic home finances. An important
> feature that we want to use is the  'use accumulated totals' in our
> budget reports. This feature is available in 4.14 so we have stopped there.
> What advantages or disadvantages are there to continuing on to 5.3?
>
> TIA,
>
> Larry
>

Larry, AFAIK, the biggest change in 5.x is the new auto-complete feature,
which some like and some don't like so much. (Personally, I like it better
than what there was in 4.x).

I'm running 5.3, and it looks like the auto-matching in the Notes field
isn't fully working (that's been the subject of another thread in this
list).

I don't use the "use accumulated totals" in budget reports, so I cannot say
how well this work... I would suggest making a backup of your GnuCash file,
upgrading to the current version, and then trying out your report with the
new version... you may decided to continue with it. If you don't, you can
erase the new version, re-install the old version, and restore your copy of
the GnuCash data file.


_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Issue with Finance::Quote

[Bruce Schuck]

On 7/27/23 10:46 AM, bern...@deprez.biz wrote:


Just gave that a shot:


C:\Strawberry\cpan\build\Finance-Quote-1.57-0>perl Examples\stockdump.pl 
alphavantage QQQ
Can't use an undefined value as a HASH reference at 
C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.


You left out the command that shows the version.

C:\Users\bschuck>perl -MFinance::Quote -e "print 
qq{{$Finance::Quote::VERSION\n}}"


{1.57
}

It could also be helpful to send the output of "perl -V" (upper case V 
to be sure). It's only the last 5 to 10 lines that I am interested in at 
the moment, but the entire output would be okay.


If you don't mind, please also try to set PERL5LIB before running the 
example script.


C:\Strawberry\cpan\build\Finance-Quote-1.57-0>set 
PERL5LIB=C:\Strawberry\cpan\build\Finance-Quote-1.57-0\lib


Followed again by:

C:\Strawberry\cpan\build\Finance-Quote-1.57-0>perl Examples\stockdump.pl 
alphavantage QQQ

$VAR1 = {
  'QQQ∟close' => '377.5200',
  'QQQ∟last' => '376.6200',
  'QQQ∟currency' => 'USD',
  'QQQ∟net' => '-0.9000',
  'QQQ∟date' => '07/27/2023',
  'QQQ∟low' => '375.3100',
  'QQQ∟volume' => '63506417',
  'QQQ∟p_change' => '-0.2384',
  'QQQ∟method' => 'alphavantage',
  'QQQ∟symbol' => 'QQQ',
  'QQQ∟success' => 1,
  'QQQ∟currency_set_by_fq' => 1,
  'QQQ∟open' => '382.9700',
  'QQQ∟isodate' => '2023-07-27',
  'QQQ∟high' => '384.7100'
};

Bruce S.

P.S. - did you forget to Cc the list, or did you mean to reply just to me?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Account Tabs

[David Carlson]

I didn't realize that it is so easy to click View > Filter By > then do all
sorts of things to hide or show as limited a selection of accounts as my
heart desires, then wash, rinse and repeat...

On Thu, Jul 27, 2023 at 2:01 PM R Losey  wrote:

> On Wed, Jul 26, 2023 at 7:42 PM Gyle McCollam  wrote:
>
> > If my accounts page view does not show zero balance accounts, but I want
> > to open a zero-balance account is there a way to do this without changing
> > the view, opening, and the changing the view back?
> >
>
>
> I don't know any easy way... I just show zero-balance accounts. Accounts
> that are inactive I "hide".
>
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Question about billing

[Angela Haggerty via gnucash-user]

I think I understand your question. I work with several CPA's and 
lawyers in my area primarily in taxes as an Enrolled agent. However I do 
a lot of bookkeeping and corporate maintenance as well. Please forgive 
me if I break this down too much, or cover steps you already know, I 
just want to be complete in my explanation.


I would suggest going to the chart of accounts and adding a new account 
to your liabilities for the credit card in question if you don't already 
have one. If you already have an account double check that in the 
account properties under parent account the drop down menu for account 
type reads "credit card".


When your statements come in enter each individual charge here with an 
offset in correct expense category using the date cleared on the 
statement. EX: 01/15/23 Valero $32.53 would Debit (DB) Fuel Expense and 
Credit (CR) the credit card account on 15 Jan. Doing this for each 
individual charge is tedious at times but it ensures that all the 
charges are listed in the appropriate expense account AND the correct 
accounting period as accrued.


You will also still have a balance in your liabilities to pay through 
the bill system from your bank account. Enter the bill in your system 
for the amount you paid the day the payment cleared your credit card and 
pay it as normal from your bank/cash account. You can then reconcile the 
credit card liability account as you would a bank account.


Tedious but still easier in GNUCash over QB any day... I HATE QB with a 
passion!


A. Haggerty CB EA MTax

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Construction Billing By Project

[NoobAlice]

On 7/27/23 3:43 AM, Angela Haggerty wrote:

Firstly, it's past 3 AM and I am arguing with myself on how to enter
construction projects into GNUCash for a bookkeeping LLC client.



Currently people tend to "tag" transactions by putting @job1 in the 
description of any transaction that affects Job 1.  That makes it a term 
that is easy to filter for reports.  Or use #jobB or whatever string 
format will be easy to input consistently and not get mixed up with 
other things.


Currently, to run a report for a single job where you have used this 
tagging system, you would go to:

Reports > Transaction Report > modify options:
Accounts: choose accounts to include (just income/expense for you)
Filter: in Transaction Filter, type @job1
General: pick your dates
And that will give you transactions for each account with totals.

Assuming you tagged everything, this should give you an idea of a single 
job's profitability.  You can also run the transaction report to show 
all transactions that do *not* include those tags; this lets you look 
over a list of overhead expenses and make sure you have no untagged job 
costs there by mistake.


Alternate method:
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107072.html

HOWEVER, Vincent Dawans has been working on reports that might give us 
reports for multiple jobs at a time.  See the following mailing list 
posts, ensuing discussions, and links therein

https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106693.html
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106749.html
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107035.html

You will want to follow the mailing list and pay attention to anything 
that other people are calling classification/category/dimension 
reporting.  For our purposes they are the same.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] strange lack of exchange rates in a new currency cash account

[Scott Ellsworth]

Hi John,

Okay, thanks again.

Be Well,
 
Scott
 Scott Ellsworth || +1 (775) 386-2519 

- Original message -
From: john 
To: Scott Ellsworth 
Cc: GnuCash user forum 
Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account
Date: Thursday, July 27, 2023 23:09

Scott,

Aha! Yes, I recall some bug fixes around pricing and VND in particular in the 
last couple of years.

Ubuntu updates application versions only at releases, so if you want to keep up 
with GnuCash that way you have to upgrade every April and October. You could 
switch to Debian Testing, which is what Ubuntu's releases are pulled from. That 
operates as a rolling release so no upgrades are needed. The updates in testing 
have been vetted for a few weeks to months in Debian Unstable, so they're a bit 
less bleeding-edge than other rolling-release distros like Arch or Fedora 
Rawhide.

Or you can keep right up to date with flatpak.

Regards,
John Ralls

> On Jul 26, 2023, at 21:41, Scott Ellsworth  wrote:
> 
> Hi John,
> 
> It turns out that I had the latest version of GnuCash that's supported by my 
> version of Ubuntu (v3.8b). I installed Flatpak and used it to install GnuCash 
> v5.3. I entered a grocery-store purchase for today, and entered the exchange 
> rate manually as "1/23600." After I completed the transaction, the Account 
> Summary then displayed a normal dollar value for my dong cash. I tried 
> entering a couple test transactions (an ATM withdrawal and a gift-store 
> purchase), and everything still seemed to work normally. So far it always 
> shows a dollar equivalent that looks normal on the Account Summary.
> 
> So I think this must have been a bug that has been fixed in the past few 
> years. Thank you for your help. 
> 
> I also like the new selection feature for auto-completion of new register 
> entries.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: Scott Ellsworth 
> To: john 
> Cc: GnuCash user forum 
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Wednesday, July 26, 2023 11:18
> 
> Hi John,
> 
> I just tried a test transaction, an ATM withdrawal in Malaysian ringgits, and 
> it worked flawlessly like usual, using the previous exchange rate by default, 
> and showing a correct dollar value for the Malaysian cash afterwards in the 
> Account Summary. T\S the glitch appears to only affect Vietnamese dong, 
> perhaps because the currency unit is so tiny. As mentioned, I tried creating 
> a new dong cash account and the same glitches started happening in it as well.
> 
> I have the box unchecked for Force Decimals. I looked at my GnuCash version, 
> and it's v3.8, running on Ubuntu Linux 20.04.6 LTS. I run updates every 
> Sunday, but come to think of it now, I haven't seen Gnucash update in a 
> really long time. I last reinstalled my computer in the fall of 2021. Perhaps 
> the Gnucash installation process in the Ubuntu Software GUI doesn't currently 
> include setting up the repository for updates. I need to move along to other 
> things right now, but maybe tomorrow I'll try reinstalling to the latest 
> version of GnuCash that my OS version will allow.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: john 
> To: Scott Ellsworth 
> Cc: GnuCash user forum 
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Tuesday, July 25, 2023 22:44
> 
> Scott,
> 
> I don't know what's going on and I can't replicate it. I created a VND 
> account in a test book and created the following transactions (This is a 
> Transaction report with one line per split set on the Display tab. I've also 
> turned off Force prices to decimal in Preferences>Numbers, Date, Time.):
> 
> Date Account Shares Price Debit Credit
> 
> 01/01/2023 VND Cash 2,000,000.00 $0.425 ₫2,000,000
> Checking Account -85.00 $1. $85.00
> 07/23/2023 VND Cash -49,530.00 ₫1.00 ₫49,530
> Books 2.09 ₫23,698 + 118/209 $2.09
> 07/25/2023 VND Cash -136,000.00 ₫1.00 ₫136,000
> Groceries 5.68 ₫23,943 + 47/71 $5.68
> 
> I entered the price three different ways: For the first I started in the 
> USD-denominated Checking Account register, entered 85.00 in the register's 
> Credit field and 200 in the Debit Amount field of the transfer dialog. 
> The other two I started in the VND Cash register and put values in the price 
> field; as a rational number for the first and a decimal number (editing the 
> one the Transfer dialog presented; that was before I changed the Force prices 
> to decimal preference. The book does not have Trading accounts enabled. 
> GnuCash is v5.3.
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Jul 25, 2023, at 00:57, Scott Ellsworth  wrote:
>> 
>> Hi John,
>> 
>> Another update about the strange behavior: Just now I came back from 
>> shopping and recorded three transactions. When inputting the f

[GNC] Follow Up: Split Payments, was Re: gnucash-user Digest, Vol 244, Issue 64

[Eric H Bowen via gnucash-user]

I tried to follow your suggestions below, first entering a reversing 
transaction to clear my earlier entry. Then I applied the payment to 
invoice B, which left a "payment imbalance." I couldn't figure out a way 
to apply that to Invoice A directly. Of course, it may be there and I'm 
just missing it.


What I ended up doing was processing a "Refund" of the overpayment of 
Invoice B, and applying that to a new asset account I named, "Vendor 
Credits." Then, I turned around and entered a payment of that credit 
amount to apply to the first 25% payment on Invoice A. Kind of clumsy, 
but at least you should be able to follow it at tax time.


Thanks for trying to helpEric.

On 7/26/23 21:54, gnucash-user-requ...@gnucash.org wrote:

Send gnucash-user mailing list submissions to
gnucash-user@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-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

  2.  Split Payments? (Eric H. Bowen)
   
6. Re:  Split Payments? (Adrien Monteleone)
  
--


Message: 6
Date: Wed, 26 Jul 2023 18:15:30 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Split Payments?
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

It is possible dating may play a role if A is indeed earlier than B, but
I'm not certain.

If that is the case, then you'll have to make a payment for the full
amount as planned (1/4*A+B) but only choose Invoice B to apply it to.
This will leave an unlinked over/pre-payment attached to that Vendor for
the difference.

Then Process another payment, this time, selecting the remainder not
applied originally, to Invoice A.

I think it should remain as a single transaction in the register, but
please do report back how it turns out.

Regards,
Adrien

On 7/26/23 3:16 PM, Eric H. Bowen via gnucash-user wrote:

I'm fairly new to using the Accounts Payable function. I have a vendor
which is owed two invoices, one larger one which she has agreed to
accept four monthly payments on plus one smaller invoice which I wanted
to pay up front right now. I made a payment for 1/4*A + B, but when I
attempted to "assign as payment" it only applied it to a portion of the
larger invoice A. What's the proper technique for dealing with this kind
of situation going forward?





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Budgeting glitch after upgrading to 4.14

[larry johnston]

We just finished upgrading from 2.6.15 to 4.14 in Windows 10. Our budget
has a glitch. In the bottom rows the Income, Expenses, Transfer and
Remaining to Budget rows all read zeros. In 2.6.15 they totalled Income and
Expenses and showed if there was something over or under budgeted in the
Total row (now Remaining to Budget). I can't see any way to get these
totals into the bottom rows. When we enter new numbers into the budget
nothing happens in these rows either. The Income and Expense totals in the
upper rows of the budget are equal so we know the budget is balanced but it
would be nice to have this confirmed in the bottom rows.

Was something lost in the upgrade? We did run Check and Repair. Or is there
something else we should be doing?

TIA,

Larry
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Budgeting glitch after upgrading to 4.14

[Christopher Lam]

Please upgrade to 5.3 which should have fixed most of these budget issues

On Fri, 28 July 2023, 12:24 pm larry johnston, 
wrote:

> We just finished upgrading from 2.6.15 to 4.14 in Windows 10. Our budget
> has a glitch. In the bottom rows the Income, Expenses, Transfer and
> Remaining to Budget rows all read zeros. In 2.6.15 they totalled Income and
> Expenses and showed if there was something over or under budgeted in the
> Total row (now Remaining to Budget). I can't see any way to get these
> totals into the bottom rows. When we enter new numbers into the budget
> nothing happens in these rows either. The Income and Expense totals in the
> upper rows of the budget are equal so we know the budget is balanced but it
> would be nice to have this confirmed in the bottom rows.
>
> Was something lost in the upgrade? We did run Check and Repair. Or is there
> something else we should be doing?
>
> TIA,
>
> Larry
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.