Re: [GNC] Upgrade 2.6.18 to 3.5

I am currently using version 2.6.16 so should I upgrade to 2.6.21 before 3.5 or is another intermediate step recommended? Kind regards,Alan -- Date: Tue, 9 Apr 2019 14:21:15 -0500 From: Adrien Monteleone To: GnuCash Subject: Re: [GNC] Upgrade 2.6.18 to 3.5 Me

Re: [GNC] Upgrade 2.6.18 to 3.5

> On 10 Apr 2019, at 08:21, aeg via gnucash-user > wrote: > > I am currently using version 2.6.16 so should I upgrade to 2.6.21 before 3.5 > or is another intermediate step recommended? > Kind regards,Alan For what it’s worth, I can report no file incompatibility problems in making the trans

Re: [GNC] Posting a bad debt

On Tuesday, 9 April 2019 19:21:16 BST rmom...@gmail.com wrote: > If you create an invoice that later becomes uncollectible, there is no way > to charge it off to a bad debt expense account from within the invoice. > Suggestions? > Hi, haven't had to do this for a while (thnakfully!), but ISTR th

[GNC] Support for .IIF and .QFX formats for Data import

Hi, My Bank supports .IIF and .QFX formats for Data Import. Your documentations do not show support of these (yet). I have tried the ASCII CSV and I get errors during import. Any plans for these .IIF or .QFX format support ? Syed -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User

Re: [GNC] Posting a bad debt

I think you have to pay it from an expense account like Expenses:BadDebt or wherever you want to record that expense. Sent from my iPhone > On Apr 9, 2019, at 1:21 PM, wrote: > > If you create an invoice that later becomes uncollectible, there is no way > to charge it off to a bad debt expens

Re: [GNC] help lost data file

I have a general suggestion to the problem for Windows users. The must frequently-used, helpful, can't-do-without utility I have on my system is called Everything. In the blink of an eye it displays every file matching your specified filename search criterion. Type <*.gnucash> in the search box (

Re: [GNC] Posting a bad debt

That’s an interesting idea and it keeps the money moving within the billing and accounts receivable side as Roger had requested. Now that Roger mentions it, I remember now not seeing expense accounts to pay with. Roger is this the roundabout way you are doing it now?: https://www.gnucash.org

Re: [GNC] Upgrade 2.6.18 to 3.5

I've just upgraded from 2.6.21 to 3.5.1 for Windows 10. The upgrade performed seamlessly with only one problem so far, it seems to have lost my Saved Report Configurations from the previous version. Not too big a deal as it's easily created again, or maybe someone has an idea if I'm looking in the

Re: [GNC] Support for .IIF and .QFX formats for Data import

We do support QFX. It is part of the OFX importer. We do not support IIF or QXF.. Those are proprietary formats and we have no immediate plans to attempt to reverse engineer them. -derek Sent using my mobile device. Please excuse any typos. On April 10, 2019 5:42:39 AM syed huq via gnucash-us

Re: [GNC] Upgrade 2.6.18 to 3.5

The storage locations for some items moved between versions. I think saved reports are affected. Take a look at the wiki. You likely just need to copy them to the new location. Regards, Adrien > On Apr 10, 2019, at 4:57 AM, Tony Vanson wrote: > > I've just upgraded from 2.6.21 to 3.5.1 for Wi

Re: [GNC] Upgrade 2.6.18 to 3.5

It would greatly help my few remaining brain cells if specific location advice is available. Waded through a lot of the Wiki but unfortunately made no sense to me. Cheers On Wed, Apr 10, 2019 at 6:20 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The storage locations for some it

Re: [GNC] Posting a bad debt

Revenue is money you have collected. I don't think an invoiced amount is revenue until it has been collected. When a payment cannot be collected, that uncollected payment is not an expense. An expense is revenue spent in exchange for a good or service. Kind regards, Greg Feneis (Galaxy S7) On

Re: [GNC] Posting a bad debt

Adrian, This option makes the most sense to me in terms of accounting principles. Only one problem, I set that account up as a sub of accounts receivable (in Spanish for: Activo Diferido) but it does not show up in the list of accounts in the receive payment window. You have to have an accounts

Re: [GNC] Upgrade 2.6.18 to 3.5

On 4/10/19 11:15 AM, gnucash-user-requ...@gnucash.org wrote: Date: Tue, 9 Apr 2019 14:21:15 -0500 From: Adrien Monteleone To: GnuCash Subject: Re: [GNC] Upgrade 2.6.18 to 3.5 Message-ID: <1fee796e-cc28-49a2-b975-8faf5425f...@lusfiber.net> Content-Type: text/plain;??? charset=us-ascii I think i

Re: [GNC] Downgrading to 2.6.21

Well, I upgraded to "Rebuild of the GnuCash 3.5 Windows Bundle", but GnuCash still gives me the strange error when I try to save to the usual location where I've saved in the past successfully with 2.6.x. Kind regards, Greg Feneis On Tue, Apr 9, 2019 at 12:42 PM Greg Feneis wrote: > So far,

Re: [GNC] Posting a bad debt

Greg, You’re not hijacking the thread. Good question. Whether a bad debt is a simple loss of income or an expense depends on your method of accounting, cash or accrual. If the latter, the sale is counted as income the day you create the invoice. By the former, it isn’t income until it is pai

[GNC] Please unsubcribe me

-- Teresa Slack Senior Client Manager *_Coba Enterprise Management, LLC_* 3620 Pelham Road, PMB 107 Greenville, SC 29615 Office: 864.343.8017 x 5 Cell:    864.525.3633 ter...@coba-em.com Coba-EM.com /NOTICE TO RECIPIENTS: The information

Re: [GNC] Please unsubcribe me

HI, On Wed, April 10, 2019 12:30 pm, Teresa wrote: [snip] If you look at the bottom of EVERY MESSAGE FROM THIS LIST: > 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

Re: [GNC] Support for .IIF and .QFX formats for Data import

On 4/10/19 6:11 AM, Derek Atkins wrote: We do support QFX.  It is part of the OFX importer. We do not support IIF or QXF.. Those are proprietary formats and we have no immediate plans to attempt to reverse engineer them. -derek Dazed and confused here. One line says QFX is supported, the ot

Re: [GNC] Posting a bad debt

David, Excellent explanation of the standard accounting practice for handling bad debts. I saved it. As you note, the problem is the limits of the invoice module in GnuCash. I did create an income contra account for bad debts with the idea of paying the invoice from that account and later enter

Re: [GNC] Support for .IIF and .QFX formats for Data import

Hi, On Wed, April 10, 2019 12:42 pm, Ken Schneider wrote: > On 4/10/19 6:11 AM, Derek Atkins wrote: >> We do support QFX.  It is part of the OFX importer. >> >> We do not support IIF or QXF.. Those are proprietary formats and we have >> no immediate plans to attempt to reverse engineer them. >> >>

Re: [GNC] Upgrade 2.6.18 to 3.5

Mileage varies when encountering bugs. If you want to see those known to affect to 2.6.12 you can search the Bugzilla db for that series, and/or time period. (not all bugs were specific to a particular release) *Many* improvements and fixes have been implemented since then. If you only run what

Re: [GNC] Posting a bad debt

Roger, Be certain to set that sub-account as *type* `asset` not as *type* `accounts receivable`. There can be only one account with the type `accounts receivable`, and that one already exists. (and has the same name) I made the same error myself when I set up my sub-accounts. You can have regu

Re: [GNC] Posting a bad debt

Adrien, I take it the context of your comments is how to allow for payment of invoices with services in kind. I think I follow you. It is ideal to create a sub account of accounts receivable so the roll up number give a more realistic idea of what you can expect to get paid. Paying for the s

Re: [GNC] Support for .IIF and .QFX formats for Data import

Gets me every time. 😁 Ken Schneider > On Apr 10, 2019, at 12:53 PM, Derek Atkins wrote: > > Hi, > >> On Wed, April 10, 2019 12:42 pm, Ken Schneider wrote: >>> On 4/10/19 6:11 AM, Derek Atkins wrote: >>> We do support QFX. It is part of the OFX importer. >>> >>> We do not support IIF or QXF.

Re: [GNC] Posting a bad debt

Roger, You just missed my recent reply on account types. The asset version needs to be of *type* `asset` not *type* `accounts receivable` but you can certainly place regular asset accounts as sub-accounts of that special Accounts Receivable account. I have this very setup and it works fine. C

Re: [GNC] Upgrade 2.6.18 to 3.5

https://wiki.gnucash.org/wiki/Configuration_Locations Read the section about where to find USER_DATA_HOME on your OS. Find the saved reports in the location listed to be used in version 2.6 and then move them to the new location now used in 3.x and rename the file accordingly. (I seem to recall

Re: [GNC] Posting a bad debt

At this point I’ll simply suggest referencing an Accounting textbook and/or speaking to a CPA. I’m not getting into a debate about definitions of revenue vs. income and how to treat bad debts in *your* books. As I noted, I’m not dispensing accounting advice. I’m trying to help, best I can, with

Re: [GNC] Posting a bad debt

Roger, That is correct and likely the source of the discrepancy in understanding how to treat bad debts and the meaning of ‘revenue'. Under accrual accounting, revenue is booked when it is earned, collection is a separate event. The business features of GnuCash were designed for accrual based

Re: [GNC] Posting a bad debt

Justin, That's the point, you can't receive a payment for an invoice from an expense account. GnuCash won't let you do it. Thanks, Roger -Original Message- From: Justin Haynes Sent: Tuesday, April 9, 2019 1:40 PM To: rmom...@gmail.com Cc: GnuCash Subject: Re: [GNC] Posting a bad debt

Re: [GNC] Upgrade 2.6.18 to 3.5

Thank you for your input; I've just downloaded 3.5.1 and I'll prepare to take the plunge! Alan From: Tony Vanson To: Michael Hendry Cc: aeg ; "gnucash-user@gnucash.org" Sent: Wednesday, 10 April 2019, 10:58 Subject: Re: [GNC] Upgrade 2.6.18 to 3.5 I've just upgraded from 2.6.21

Re: [GNC] Posting a bad debt

Adrian, I did not know you could assign a different type account to a sub-account. Tried that and it still does not show up in the receive payment window, even after closing and reopening the program. When I added the bad debts account as a sub of accounts receivable, GnuCash automatically assi

Re: [GNC] Posting a bad debt

Roger, My apologies for any time wasted. I use my sub-account with manual entries. I see now the business features will not expose them in that payment drop down, regardless of type. (but you can use those asset (not A/R) accounts from the business features in line-items in bills/invoices as th

[GNC] Wiki about where custom reports are stored

Adrien, I lost the link to the wiki about where the custom reports are stored. Would you please send it again? Thanks, Roger ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

Re: [GNC] Wiki about where custom reports are stored

Roger, https://wiki.gnucash.org/wiki/Configuration_Locations It’s part of the thread labeled: Upgrade 2.6.18 to 3.5 Regards, Adrien > On Apr 10, 2019, at 4:27 PM, wrote: > > Adrien, > > I lost the link to the wiki about where the custom reports are stored. Would > you please send it again

Re: [GNC] Upgrade 2.6.18 to 3.5

On 4/10/19 10:57 AM, Adrien Monteleone wrote: > Mileage varies when encountering bugs. If you want to see those known to > affect to 2.6.12 you can search the Bugzilla db for that series, and/or time > period. (not all bugs were specific to a particular release) *Many* > improvements and fixes h

Re: [GNC] CSV import lags and burns CPU; can't report bug

It was super super slow... until it wasn't. I tried the import over again with the descriptions modified with an "x" so they don't stomp on autocomplete for previously filed transactions. It imported 160 transactions in about 2 seconds today. So I don't know what was up. Evil gnomes? Mark O

Re: [GNC] Downgrading to 2.6.21

Installed 2.6.21 over the 3.5.1, and it was able to save as in the usual location, that 3.5 and 3.5.1 have trouble Kind regards, Greg Feneis (Galaxy S7) On Wed, Apr 10, 2019, 09:04 Greg Feneis wrote: > Well, I upgraded to "Rebuild of the GnuCash 3.5 Windows Bundle", but > GnuCash still gives m

Re: [GNC] Upgrade 2.6.18 to 3.5

Stephen M. Butler wrote > Or, if your distro is Ubuntu based, you can download the *.deb files > from:  > https://drive.google.com/open?id=11gjnSIw9E8B8kOJ01DHQuEA83xidbw8E  for > the 3.5 version. Downloaded! Now, if I click on the deb and install with the gdebi installer, will it automagically t

Re: [GNC] Upgrade 2.6.18 to 3.5

On 4/10/19 6:06 PM, Elmarts wrote: > Stephen M. Butler wrote >> Or, if your distro is Ubuntu based, you can download the *.deb files >> from:  >> https://drive.google.com/open?id=11gjnSIw9E8B8kOJ01DHQuEA83xidbw8E  for >> the 3.5 version. > Downloaded! Now, if I click on the deb and install with th

Re: [GNC] UK VAT and "Making Tax Digital"

3.5 is out and I promised to offer CSV output. Has anyone confirmed the exact CSV (or JSON) format desired by their *bridging* software? Please be aware that direct communication to HMRC is best done by bridging software outside gnucash. It'll be a nice project for anyone to do in python or simil

[GNC] US Bans Free tax Software

Just noticed this post. https://news.yahoo.com/free-irs-software-filing-taxes-191746938.html?fbclid=IwAR3-GIPM3S6SazRqcyKb1Lywu4wMhtWB9Je8YU_cK_usuW4FLf13y07ATJs. Impact on the use of GnuCash for Tax preparation in the US could be profound. Looks like the US government is trying to head the same

[GNC] credit card opening balance

Hi All, On a credit Card account, they owe me $18.00 (I over paid). What do I enter for opening balance? $18 or -$18? And do I put in Payment or Charge? When I enter a charge, why does "Transfer auto enter "Orphan-USD"? What is "Orphan-USD" anyway? How do I tell the "transfer" column to bugg

[GNC] n and c?

Hi All, On a credit card account, in the "R" column, what is "blank", "n", and "c" stand for? And does "R" stand for "reconcile"? Many thanks, -T ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to u

[GNC] two lines for every entry

Hi All, On a credit card account, when ever I enter a charge and press enter, I get a second line with the charge amount entered into the payments column. If I delete the payment line, it deletes the charge line too. A What the h***. ("Heck", what did you think I meant?)

Re: [GNC] US Bans Free tax Software

While it may be lamentable that the US government is headed down this path, if is not necessarily the same disaster... Since Gnucash is not tax software, and I am not a professional tax expert, I use Gnucash for tracking my finances (including using tax options extensively), and Turbotax to subm

Re: [GNC] US Bans Free tax Software

On 4/10/19 10:33 PM, David Cousens wrote: Just noticed this post. https://news.yahoo.com/free-irs-software-filing-taxes-191746938.html?fbclid=IwAR3-GIPM3S6SazRqcyKb1Lywu4wMhtWB9Je8YU_cK_usuW4FLf13y07ATJs. Impact on the use of GnuCash for Tax preparation in the US could be profound. Looks like the

Re: [GNC] Upgrade 2.6.18 to 3.5

Sorry, totally at sea on this one. Have created new reports. Thanks for your time and effort. Cheers On Thu, Apr 11, 2019 at 4:01 AM aeg wrote: > Thank you for your input; I've just downloaded 3.5.1 and I'll prepare to > take the plunge! > > Alan > > > -- > *From:* To

Re: [GNC] two lines for every entry

Todd, I strongly suggest you read the Guide-- especially the chapters that cover double entry accounting and other basics.  David On Thu, Apr 11, 2019 at 10:45, ToddAndMargo via gnucash-user wrote: Hi All, On a credit card account, when ever I enter a charge and press enter, I get a s

Re: [GNC] two lines for every entry

David On Thu, Apr 11, 2019 at 10:45, ToddAndMargo via gnucash-user wrote: Hi All, On a credit card account, when ever I enter a charge and press enter, I get a second line with the charge amount entered into the payments column. If I delete the payment line, it deletes

Re: [GNC] credit card opening balance

If you enter negative numbers, it will flip to the other column. All numbers should be entered as positive. You choose to either enter them as payments or charges. (debits and credits respectively in formal terminology) Payments (debits, left column) decrease the amount owed for a liability. Cha

Re: [GNC] n and c?

Yes, The ‘R’ column is a reconcile flag. You can click between ’n’ - "not reconciled", and ‘c’ - “cleared". When you reconcile against your statement, the ‘c’ items will be pre-checked for you. When you finalize the reconciliation, all checked items will change their flag to ‘y’ - “yes, reconc

Re: [GNC] credit card opening balance

>> On Apr 10, 2019, at 11:58 PM, ToddAndMargo via gnucash-user wrote: >> >> Hi All, >> >> On a credit Card account, they owe me $18.00 (I over paid). >> What do I enter for opening balance? $18 or -$18? >> >> And do I put in Payment or Charge? >> >> When I enter a charge, why does "Transfer aut

Re: [GNC] US Bans Free tax Software

For those who use gnucash for personal finances, I don't see this being important (to that goal).  As Stuart notes, gnucash provides a way to understand your finances and prepare to file your taxes, but it doesn't purport to know anything about tax law. Probably the bigger issue in the U.S. is the

Re: [GNC] US Bans Free tax Software

I’m not a fan of the corporate protectionism in the bill, but it doesn’t change anything practical-wise for anyone. It enshrines the status quo. The IRS currently does not have free tax filing software made available to taxpayers. This law prohibits the IRS from ever developing it. (a protection

Re: [GNC] n and c?

>> On Apr 11, 2019, at 12:01 AM, ToddAndMargo via gnucash-user wrote: >> >> Hi All, >> >> On a credit card account, in the "R" column, what is "blank", "n", and "c" stand for? >> >> And does "R" stand for "reconcile"? >> >> Many thanks, >> -T On 4/10/19 11:06 PM, Adrien Monteleone wrote: Yes

Re: [GNC] two lines for every entry

Read my other replies. Every transaction has entries in two accounts (hence ‘double entry accounting’) The first few chapters of the guide won’t take long and will alleviate much potential frustration that would ensue if you try to wing it. GnuCash is not so complicated to use that you need to

Re: [GNC] US Bans Free tax Software

One does have to account for the media's tendency to overdramatize things. We do have a web form based submission system for indiviuals in Australia or you have the option of submitting through a tax agent. The business reporting currently has also a similar web portal, but I did see a plan in

Re: [GNC] n and c?

The ‘c’ flag is usually set when you are confirming the charge/payment is in fact real. Some people download transactions instead of entering them by hand, or they periodically check their account online to see if something went through. This is where you’d mark it ‘cleared’. It is not reconcil

Re: [GNC] n and c?

On Apr 11, 2019, at 1:15 AM, ToddAndMargo via gnucash-user wrote: On Apr 11, 2019, at 12:01 AM, ToddAndMargo via gnucash-user wrote: Hi All, On a credit card account, in the "R" column, what is "blank", "n", and "c" stand for? And does "R" stand for "reconcile"? Many thanks, -T O

Re: [GNC] US Bans Free tax Software

"Impact on the use of GnuCash for Tax preparation in the US could be profound." With all due respect, that's a ridiculous conclusion, given what GnuCash is, how it's used, and what it's used for... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html __

Re: [GNC] two lines for every entry

Todd, The conceptual bit behind double entry bookkeeping is that when you charge something to your credit card you: 1. Increase the balance of your credit card (a credit entry); and at the same time 2. Increase the balance of an expense account ( a debit entry). Similarly when you pay your cred

Re: [GNC] two lines for every entry

On 4/10/19 11:18 PM, Adrien Monteleone wrote: Read my other replies. Every transaction has entries in two accounts (hence ‘double entry accounting’) The first few chapters of the guide won’t take long and will alleviate much potential frustration that would ensue if you try to wing it. GnuCas

Re: [GNC] n and c?

You’re welcome. When reading the Guide, for starters, get all the way through Chapter 7. (since you are tracking credit cards) You can read the rest as needed. For the Help manual, get through Chapter 6. I don’t recommend skipping around, at least not the first time through each one. Also, don