Re: [GNC] How should I enter values on a budget in gnucash ?

2019-11-03 Thread Christopher Lam
On Sat, 2 Nov 2019 at 11:33, Jim Passmore wrote: > TL;DR--Summary lines are good, but poorly named. keep them. > > Regarding the summary lines, as already said Income and Expense totals are > self-explanatory. I'll try to explain a use-case for the other lines. > > First of all, let's ignore th

[GNC] Export values to Excel

2019-11-03 Thread Bumbling Amateur via gnucash-user
In order to submit my VAT return to HMRC I need to populate an Excel spreadsheet with some values (maximum of 9) from various accounts in gnucash. The spreadsheet then submits the values to HMRC. For example one value I need to place in to an Excel spreadsheet can be found in the gnucash account

Re: [GNC] Export values to Excel

2019-11-03 Thread Maf. King
On Sunday, 3 November 2019 12:00:02 GMT Bumbling Amateur via gnucash-user wrote: > In order to submit my VAT return to HMRC I need to populate an Excel > spreadsheet with some values (maximum of 9) from various accounts in > gnucash. The spreadsheet then submits the values to HMRC. > > For exampl

Re: [GNC] Export values to Excel

2019-11-03 Thread Christopher Lam
Maf, you were privileged to have a bespoke report. I believe the latest version is at https://raw.githubusercontent.com/christopherlam/gnucash/maint-csv-export/gnucash/report/standard-reports/uk-vat-report.scm The current plans will be to augment the income-gst-statement.scm to allow presets for d

Re: [GNC] Rental property - How to account for delinquent rents?

2019-11-03 Thread replicon
Thank you David! Yes, our partnership is in CASH accounting (not accrual). That's why I was hesitant to track "accounts receivable" (cash I should be getting but haven't received yet) as "income"... I don't want to have to worry about the Profit/Loss being inaccurate at tax time if the time betwee

Re: [GNC] Rental property - How to account for delinquent rents?

2019-11-03 Thread David Cousens
When you are on a cash basis then you only really record in your accounts the income received and expenses incurred at the time of handing over of the cash so there is really no alternative to maintaining a separate record of occupancy and arrears etc to keep the taxman off your back. Main trick

Re: [GNC] Rental property - How to account for delinquent rents?

2019-11-03 Thread Michael or Penny Novack
On 11/3/2019 6:22 PM, David Cousens wrote: When you are on a cash basis then you only really record in your accounts the income received and expenses incurred at the time of handing over of the cash so there is really no alternative to maintaining a separate record of occupancy and arrears etc

[GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread Dean Bradley
Hello!, I am a long-time (25+ years)_ trying to finish my conversion to Linux. I am setting up GnuCash 3.7 on Manjaro KDE 18.1.2. I am not importing my Quicken history, and am starting with a new file. The task at hand is setting up my brokerage account and its holdings. There are 30 securities

Re: [GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread David Cousens
Dean, It should be possible to use either the Import QIF, Import OFX/QFX, Import Transactions from CSV options depending on the format you have exported them in. I haven't used the QIF import for stock information so I can't really comment on it. The CSV importer was largely rewritten going to V3

Re: [GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread Joseph G. Keithley, III via gnucash-user
Speaking from painful experience I exported my brokerage register in quicken to a qif and then imported it into GnuCash. Once you get past all the questions from the import not-so-wizard, it took a very long time to import the file. I tried to break the file up by exporting/importing one y

Re: [GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread Dean Bradley
Hello Joseph, Thanks for the reply. Yeah, I was getting the sense this was going to be a chore, no matter how I sliced it. It seems to me that it is no more trouble to set up all the accounts, securities and opening balances manually, than it is to make multiple passes at incremental imports a

Re: [GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread Dean Bradley
Thanks for your reply. I get the impression that even if I get the import process sorted out, that this will be a tedious process and probably no easier in the long run that just entering all the data manually. You state the importer is ahead of the documentation, but my evaluation was based on

Re: [GNC] How should I enter values on a budget in gnucash ?

2019-11-03 Thread Edward Doolittle
I can't help much with this any more ... I stopped using the budget features some time ago. I found the very concept of it incompatible with the way I use double entry accounting. I won't bore everyone with all the details, some of which I wrote to this list a few years ago, but I can give a summar

Re: [GNC] Setting up existing investments in new GnuCash file

2019-11-03 Thread Joseph G. Keithley, III via gnucash-user
I don't think Quicken is in imminent danger of takeover by GnuCash. However, just like any software there is a learning curve that you have to come to terms with for GnuCash. For right now, I keep two sets of books, one in Quicken and one in GnuCash. I assume that at some point I won't be abl