Re: [GNC] Unique entry date and transaction date availability?
Am 01.05.2019 um 22:55 schrieb Jeff Albrecht: > Is there a transaction creation date available and if so how may I > display it. > > I did find an email thread from September 2013... > > "Starting with releases in the 2.5 series (which is still in alpha or > beta, depending on your opinion), the date entered will be visible if > you have your preferences set to show it." > https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html > > Searched through preferences a couple times. I'm not seeing it. > I don’t know which OS you’re using but on Linux with the experimental features compile option I can start gnucash with the --extra option and can enable this view in the Extensions/Register 2 General Journal Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] UK VAT and "Making Tax Digital"
Hello All, since the General GST/VAT report is discussed I just wanted to add that in the German VAT forms normal purchases aren’t filled in, only the deductible input VAT thereof. For acconting of it for tax purposes an asset account is used for cash based accounting. The only time purchases are listed is for reverse charge. Also can the new report round the tax base for output VAT down to full monetary units? The next big thing would be cash-based VAT even if submitting a balance sheet. (Ist-Versteuerung). Kind regards Christian Kluge. Am 30.04.2019 um 17:08 schrieb Christopher Lam: > Hi Maf > > I agree your asset purchases are not going to be accounted for in the > current iteration. This was not thought of during the design. > > A short workable answer is to record this asset purchase as an expense, and > immediately create an expense->asset transaction which will satisfy your > VAT requirements and still use the report as it stands. I'm sorry this is > clunky, and the next para explains why > > The longer answer was that every VAT/GST related transaction ie. > sales/purchases, record VAT, and periodic submission would need a > transaction of at least 3 splits... moreover we'd need to determine, as > simply as possible, whether it is a purchase or a sale. Hence the decision > made to consider Income split as sales and Expense split as purchases, and > determine vat/gst-split as asset/liability as well. This allowed a complex > 5-split transaction involving both > sales/purchase/vat-collected-on-sales/vat-paid-on-purchases as illustrated > in https://wiki.gnucash.org/wiki/Alternate_Australian_GST_setup and > https://www.gnucash.org/docs/v3/C/gnucash-guide/rpt_standardrpts.html#rpt_gst_statement > . > > An alternate strategy *could* be used to determine sales vs purchases, vat > collected vs paid; e.g. use Business Features (which would then force the > user to use invoices/bills for *all* vat/gst purchases, IMHO undesirable!). > The difficult part is to determine a consistent strategy which is > acceptable to users worldwide, and does not inconvenience too much. > > Sorry for long answer, hope is informative. If you have a better strategy > to offer, to account for your Asset:Bank -> Asset:CapitalAssets + > VAT:Paid-on-Purchases use cases, I'm all ears! Meanwhile the short > workaround above *may* be an acceptable solution for the current reports... > > (w.r.t. CSV output: the following replacement .scm files can produce > something similar) > https://raw > .githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/transaction.scm > https://raw > .githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/income-gst-statement.scm > > On Tue, 30 Apr 2019 at 13:37, Maf. King wrote: > >> Hi Christopher. >> >> Finally got round to completing my final quarter VAT return with the >> manual >> error-prone process of typing 7 numbers into boxes on the HMRC website. >> >> I'm now trying to make the Income & GST report give me sensible numbers >> that >> match my existing saved transaction reports and struggling with one thing. >> >> It may well be how I've got my tree set up that's causing my problem. The >> GST >> report doesn't allow to include transactions to asset accounts. >> >> Under UK tax law, if I buy something of lasting value, eg some machine, >> for >> example, it is not an expense but a transfer to Asset:CapitalEquipment. >> But >> the VAT is claimable straight away and so the transaction (for the VAT >> return) >> should be included in the Net Purchases & Tax on Purchases column. >> >> any advice? >> >> is your CSV output intending to be made from the GST report codebase in >> some >> way? >> >> The bridging spreadsheet I have will be quite happy to read from >> ~/somewhere/somefile.csv >> >> my test file is just : >> Box1,1234.56 >> Box2, 0.00 >> (box 3 is calculated from box1+box2 so not included) >> Box4, 321.98 >> etc to include box 6,7,8,9 >> >> and the spreadsheet will read that and populate new data into the fields >> each >> time it is run. >> >> the only other thing that might be nice to include in the CSV output is >> the >> date period, but I haven't tested that for format etc yet. >> >> >> I'm not signed up for the -devel list, can do so if you'd prefer to keep >> this >> off -user for now. >> >> thanks & best regards, >> Maf. >> >> >> >> On Thursday, 11 April 2019 11:08:27 BST Maf. King wrote: >>> O
Re: [GNC] Don't understand why I have what I have
Am 14.04.2019 um 02:14 schrieb David Cousens: > Whether to debit or credit an account in a transaction in an accounting > program may also not be what you expect from the everday experience with > bank statements etc. > I just wanted to add the reason for this. A bank statement is an extract from their accounting showing their point of view. So each debit for you is a credit for them and vice versa. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Split transaction: more than two off-setting accounts
Am 13.04.2019 um 21:10 schrieb Rich Shepard: > On Sat, 13 Apr 2019, Christian Kluge wrote: > >> Just change the values in the debit and credit columns. >> As long as the sums of debit and credit don’t match you can add further >> entries. > > That works as long as there are available rows. Two are the default so when > I want to add two more rows closing and re-opening the transaction presents > an imbalance row and another one. This provides the needed space. I've not > found a way to add more rows when that transaction is on the bottom of the > gnucash window. > > When the transaction is saved and a new pair of rows is displayed, clicking > on the split transaction does display a new, blank row. > You can change Imbalance to any account to any account you like. If you don’t exit the transaction beforehand this account also won’t be set up in your CoA. The other solution could be to switch to full transaction view for every transaction. There you always have a final empty line. Kind regards Christian KLuge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Split transaction: more than two off-setting accounts
Am 13.04.2019 um 20:37 schrieb Rich Shepard: > Is there a way to open the split with more than two data entry rows? If not > I'll just continue doing what I have been, but would like to avoid > closing/re-opening the transaction if there is a way to do so. Just change the values in the debit and credit columns. As long as the sums of debit and credit don’t match you can add further entries. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] AR Asset differen t GL codes
If you can’t beat them, join them with the TOFU … There’s one thing where seperate customer accounts might shine: If you’ve got a customer or vendor with non-typical balance e. g. overpayments or refunds it will get put on the other side of the balance sheet. Kind regards Christian Kluge Am 05.04.2019 um 18:38 schrieb Adrien Monteleone: > From using other A/R software, the only purpose I can see to separate > customer accounts is for informational purposes. Since GnuCash was setup to > provide this information via reports using a consolidated A/R, the purpose is > served just as well and there are less accounts to deal with. You don’t need > to hide or otherwise archive old customer accounts when no longer needed. If > you want an at-a-glance per customer, you can just leave a Receivable Aging > report tab open. I have to deal with an outside A/R package for a client and > their separate account structure is much more maintenance and messy compared > to GnuCash’s approach. (might also be an issue with the quality of the code > between the two packages, admittedly) > > Regards, > Adrien > >> On Apr 4, 2019, at 8:56 PM, David Cousens wrote: >> >> Christian, >> >> It is clearly a design choice. I had wanted to setup separate A/R accounts >> for customers but Derek advised me that this was not the way the business >> features in GnuCash worked. Derek opted for a single A/R account and the >> ability to filter to provide specific customer information. I didn't >> particularly find that a problem when I was using Gnucash for a business >> though. >> >> David >> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Confused by report "Price Source" when recording bills in a foreign currency
Hi,
Am 26.03.2019 um 17:36 schrieb James Walker:
> * Created a USD expenses account for the company ("Expenses:US Company
> USD")
This is totally unnecessary. You should only make a conversion on the
expense side once and this is to GBP. Any rate fluctuation occuring with
the payment should be solved with correcting income and expense account.
I’ve said time and time again, that in my view only assets and
liabilities should be in foreign currencies.
Using your example with the spot rates of the 25th to 27th provided by
the Bank of England and assuming payment on the same day and leaving out
the trading accounts I would proceed as follows:
Invoice 1:
By Expenses:US Company £10.91
to Liabilities:Current Liabilities:Trade Creditors USD $14.40
Invoice 2:
By Expenses:US Company £10.89
to Liabilities:Current Liabilities:Trade Creditors USD $14.40
Invoice 3:
By Expenses:US Company £10.92
to Liabilities:Current Liabilities:Trade Creditors USD $14.40
Payment 1:
By Liabilities:Current Liabilities:Trade Creditors USD $14.40
to Assets:Current Assets:Bank £10.61
to Income:Foreign Exchange Fluctuation £0.30
Payment 2:
By Liabilities:Current Liabilities:Trade Creditors USD $14.40
to Assets:Current Assets:Bank £10.87
to Income:Foreign Exchange Fluctuation £0.02
Payment 3:
By Liabilities:Current Liabilities:Trade Creditors USD $14.40
by Expense:Foreign Exchange Fluctuation £0.10
to Assets:Current Assets:Bank £11.02
Kind regards
Christian Kluge
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
Am 21.03.2019 um 21:00 schrieb Derek Atkins: > >> At least for me in Germany I can’t think of someone accounting for more >> than one year and also only on certain circumstances accounting for >> another period than 01.01. to 31.12. > > Here in the US, organizations are free to set up any financial year they > wish. Many still choose a calendar year, but certainly may are on a > skewed calendar. Many choose June 30 for the end of the year. I worked > one place that was Jan 31. > But still it’s just one year. The certain circumstances I mentioned are mainly income tax related: The financial for farmers ends at 30.06. and for forestry it can be 28.02. A merchant according to German commercial law can choose a financial year than the calendar year with approval from the tax office. However if it’s just a small cash accounting business the financial year is always the calendar year. And all I’ve said about different financial years doesn’t apply for VAT which is always reported for the calendar year, which complicates things even further. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year rollover
Am 21.03.2019 um 15:14 schrieb Derek Atkins: > Hi, > > Philip Burg writes: > >> I would like to close my books at the end of my financial year but >> have access to the previous years files, my thoughts were to archive >> the file at the end of the year by backing up to a cd/dvd then start >> afresh with the new financial year. would this be possible. I am using >> windows 10 and Gnucash Version 3.4 Build I.D. 3.4+(2018-12-30) > > Archiving old books is always a good idea. > > Restarting at the begining of the year, however, is not necessarily is > good idea. Specifically, there is a Close Books feature that zero's out > your Income & Expense accounts into Equity, but it doesn't actually > DELETE any data. > > Your other option is to Export the account tree which will create an > empty file and then re-open it. The downside is that you will have to > reset all your opening balances, and if you use any business features > you will need to manually re-enter all that metadata too (customers, > vendors, tax tables, etc). I highly ANTI-recommend this approach. > I don’t know how to say it, but I think GnuCash might be better off with a balance carry over method into the next year. At least for me in Germany I can’t think of someone accounting for more than one year and also only on certain circumstances accounting for another period than 01.01. to 31.12. I don’t know whether it would be possible to have an option the gnucash file for the previous year which would be used comparisson reports. Is there a way to ex- and import the business related things? If there were the scenario you’ve described would a bit cumbersome but still doable. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Splitting a multi-year file
Hi Andrea, Am 03.03.2019 um 19:19 schrieb Andrea Borgia: > Hi. > > For the past decade, I've had only a few gnucash files, not one per year: > basically, I'd create a new one when the file would be large enough at the > end of the year to notice that startup time. > > If I wanted to retroactively split them by single year as I started doing > now, how could I do that? Is there a smarter way to do it other than > treating it as just another XML file and editing it manually? > > Of course, I am aware that I would have to create a few transactions for > end of year closing and new year opening. > > Regards, > Andrea. I’d suggest making balance sheets for each year to exported. Afterwards I would use File\Export\Transactions to CSV. There I would select the appropriate time range. I also would export the account structure to CSV. In the one-year-only file I would import the account structure and make entries for the opening balances. Lastly I would import the transactions from the CSV files. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report
Hello, Am 25.02.2019 um 01:02 schrieb Chary Chary: > Say at the beginning of the year I have produced a Balance Sheet report. > This report shows how much assets I have, which liabilities and delta > between them. Suppose at begging of the year I had checking accounts in USD > and Euro and some stock. > Throughout the year I was getting salary, paying expenses, at the same time > exchange rate was changing, stock price was changing etc. My be I sold some > stock, moved money between USD and Euro accounts > > Now at the end of the year I have produced a new balance sheet. > > So, I want to be able to explain a delta between a balance sheet at the > beginning of the ear and at the end. > > E.g.: > > I got so much salary > I paid so much costs > > But also: > Lost so much due to exchange rate change > Gained to much due to stock price increase etc. > My advice would be to enable trading accounts and updating the price database regularly. Also always record income and expenses in one currency across all accounts. You’ll have to book the expenses/income from exchange rate fluctuations manually when money moves between accounts of different currencies. Then in the end the trading accounts should yield the gain/loss due to stock prize changes when selecting nearest in time. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Changing account numbers?
Am 20.02.2019 um 23:05 schrieb David Cousens: > Dan > > In the Account tree view, right click on the account and select Edit > Account.. You can then change the account number in the dialog which comes > up > > David Cousens > If you’ve selected the account number column to be displayed you can even double click on it and change it there. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem with Splits
Hello, I just want to apologize, somehow the subject of this thread escaped my mind maybe because the OP’s post I bit not understandable. I obviously know what split transactions are and yes, if one account remains unsplit I would go from there. Kind regards Christian Kluge Am 12.02.2019 um 21:40 schrieb Michael or Penny Novack: > On 2/12/2019 2:49 PM, Christian Kluge wrote: > > Sorry, I made the assumption that since talking about "splits" you > already knew about entering "split transactions. Your example below, > showing it as multiple transactions, indicates otherwise. So taking your > example (a $100 expense paid for by $50 cash and a $50 loan .. > > As I said, start with the UNSPLIT side. So I would enter from the > expense account, date, description, amount, and then instead of entering > the account of the other side (can't, more than one, that's what "split" > means) I would click on "split" above. > > That brings up a different view for THAT transaction. There would be a > line for the debit (the expense account) with $100 and below that a line > also with $100 but "Imbalance" since account not yet specified. I would > change the amount on that line to $50 and enter cash for the account and > hit enter. That brings up a new line below with the new balance still > unspecified, still $50 and Imbalance. I specify the account "loan" and > hit enter, now no balance remaining, and enter again restores the view > << you no longer see the split details in that view >> > > Advice --- do not shortcut and hit that last enter twice quickly. You > want to see/confirm that there was no balance for Imbalance remaining. > > THAT describes a "one sided split" transaction. Do not attempt a > transaction split on both sides until/unless you are very experienced > entering splits << entering two sided often can mean first "lying" about > an amount and correcting that only after the other side of the > transaction has been done >> > > Michael D Novack > > >> Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack: >>> On 2/11/2019 2:40 PM, Christian Kluge wrote: >>>> Hi, >>>> >>>> my general rule of thumb is to always entering from an asset or >>>> liability account. >>>> >>> The proper "general rule" for a (one side) split transaction is to >>> enter it from the side (debit or credit) that is NOT being split. That >>> this is most often either and asset or a liability account just the >>> consequence of that most often the side of the transaction not being >>> split. >>> >>> Starting with an account on the side of the transaction being split will >>> make entry almost as difficult as entering a transaction that is split >>> on both sides. >>> >>> You need an example? Say you are paying for your share of an expense X >>> and the person you are sharing with allows you to pay part in cash and >>> owe the rest. You would begin this split from the expense account (the >>> credit side being split between cash (asset) and loan (liability) >>> >> This I would enter as either three transactions: >> >> By expense to liabilities $100 >> By liabities to cash $50 >> By liabilities to loan $50 >> >> or if I assume that the loan exists even before I pay in cash: >> >> By expense to loan $100 >> By loan to cash $50 >> >> Also who wants to change accounts all the time. >> >> If I recording cash transactions I don’t go into revenue or expense >> accounts but stick with cash. >> >> I my examples above several expense/liability transactions would occur >> before I even would post the cash transaction. >> >> Kind regards >> >> Christian Kluge >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem with Splits
Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack: > On 2/11/2019 2:40 PM, Christian Kluge wrote: >> Hi, >> >> my general rule of thumb is to always entering from an asset or >> liability account. >> > The proper "general rule" for a (one side) split transaction is to > enter it from the side (debit or credit) that is NOT being split. That > this is most often either and asset or a liability account just the > consequence of that most often the side of the transaction not being split. > > Starting with an account on the side of the transaction being split will > make entry almost as difficult as entering a transaction that is split > on both sides. > > You need an example? Say you are paying for your share of an expense X > and the person you are sharing with allows you to pay part in cash and > owe the rest. You would begin this split from the expense account (the > credit side being split between cash (asset) and loan (liability) > This I would enter as either three transactions: By expense to liabilities $100 By liabities to cash $50 By liabilities to loan $50 or if I assume that the loan exists even before I pay in cash: By expense to loan $100 By loan to cash $50 Also who wants to change accounts all the time. If I recording cash transactions I don’t go into revenue or expense accounts but stick with cash. I my examples above several expense/liability transactions would occur before I even would post the cash transaction. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem with Splits
Hi, my general rule of thumb is to always entering from an asset or liability account. (Which might have something to do with the fact that in the software I use at work one account is autofilled from the last transaction). This way its also easier to keep track of bank accounts balance and you don’t to switch account windows that often. Kind regards Christian Kluge Am 11.02.2019 um 20:07 schrieb Adrien Monteleone: > Gareth, > > Not sure exactly what you mean with respect to "a different heading." > > As a general rule, I’d enter all transactions in the account the money is > coming from. > > So if you are entering an expense, open your cash or checking account that > you are using to pay the expense, and enter it there. > > If you are entering receipt of money, open the relevant income account and > enter the transaction showing where the money went. > (cash/checking/undeposited funds, etc.) > > You can enter a transaction into any account, but by sticking to this > workflow you can eliminate lots of confusion. You can also use the General > Journal but that too can introduce confusion if you aren’t careful. > > I’d also highly recommend turning on Double Line mode and Transaction Journal > under the View Menu. This will show all information for the transaction at > all times and will help you to learn what GnuCash is doing as well as get a > handle on double-entry accounting. (it will also help if you use Formal > Accounting labels, which will make all accounts show the debit/credit columns > rather than various labels which depend on account type) > > Regards, > Adrien > >> On Feb 11, 2019, at 11:13 AM, Gareth Davies via gnucash-user >> wrote: >> >> >> Windows 10, GC v 3.2. >> >> >> >> Help. >> >> >> >> Hi, I am having a problem trying to get an Account in Assets to >> automatically decrease or increase when I update and income or expense under >> a different heading. >> >> >> >> I have tried setting it up, but it doesn't seem to work. >> >> >> >> Gareth > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Account Question
Am 24.01.2019 um 01:32 schrieb Michael or Penny Novack: > On 1/23/2019 10:25 AM, Adrien Monteleone wrote: >> Yep, I’m one of those. I track every expense, entered from *where* I >> spent the funds. So if the money was the green folding kind (or coin) >> out of my wallet or pocket, I have an account for that. If I move >> money to/from my wallet, I track that too. And I routinely reconcile >> the amount. (no report of course to use, just a verification of the >> amount on hand when I do it.) But I do all of that because I’m part of >> the ‘un-banked’. >> >> Regards, >> Adrien > > Even people who ARE "banked" might have to do this. For example, were > they in an environment where lots of their transactions had to be in > cash. Not just a matter if THEY are "banked" but if the other people > they are interacting with are. > I personally also track every transaction with every payment method and also transactions of money between them. It might also have something to do, that I also do this at my job, where the requirements of tracking cash transactions are very strict due to rules set by the financial authorities. If you don’t track your cash right, they can estimate your sales. I can’t understand why you wouldn’t track your cash payments. Either track everything or nothing at all. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple Currency transaction with bank fee
PS: It might also I have something to do with getting the quotes via Finance-Quote for 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple Currency transaction with bank fee
Am 19.11.2018 um 17:28 schrieb David T. via gnucash-user: > > >> On Nov 19, 2018, at 2:09 AM, Christian Kluge wrote: >> >> Am 18.11.2018 um 17:50 schrieb David T. via gnucash-user: >>> Hello, >>> >>> I am a longtime user (GC3.3, Mac OSX) trying to do something new in >>> GnuCash, and I ran into a situation that I found rather confusing, and I’d >>> like to share that with the group to see whether I have understood the >>> situation correctly. >>> >>> Basically, I am transferring funds from a US dollar account to an Indian >>> Rupee account. I have the USD account already, and created the INR account >>> as an asset account: Assets:Current Assets:Checking Accounts:INR Checking. >>> The account is denominated in INR, while the parent accounts are USD. I >>> created the opening balance transaction using funds from my USD-denominated >>> cash account. After tinkering around with the exchange rate dialog (God, >>> the terminology used there is not understandable!), I got the numbers to be >>> sane and based on the actual amounts involved. >>> >>> Then, I attempted to document a subsequent transfer I initiated using Xoom, >>> and this is where things get messy. Xoom is an online funds transfer >>> service that allows me to transfer this money to this INR account for a >>> small fee. >>> >>> So, I opened the INR account and created the transfer for the base amount, >>> and got a second sensible multicurrency transaction (again, after some >>> tinkering. Did I mention that the terminology used in the dialog is >>> confusing?). >>> >>> Then I remembered that Xoom charged me another $4.99, and I went to the >>> Cash account and opened up the transaction in split mode. There, I changed >>> the total amount charged to my origination account to $504.99, fully >>> expecting to assign the extra $4.99 to Expenses:Bank Fees. Imagine my >>> surprise when I received the Exchange Rate dialog again, which GnuCash >>> would not let me dismiss. I could only adjust the numbers, and everything I >>> did messed things up further. >>> >>> Knowing that many others are using GC for just this sort of use case, I >>> deleted the transaction, and then read a bit in the Guide, but didn’t find >>> anything to explain the odd situation I found myself in. I *did* notice >>> that the example in the Guide started in the originating account and added >>> splits as: Total Cost, Fee Charged, Net Transferred. When I tried THAT >>> sequence, it all worked out. >>> >>> Here's, my question: Is this the *only* sequence a user should follow? It >>> seems rather limiting for GC not to allow a user to add a new split to a >>> multicurrency transaction, but I am unable to see any way to subsequently >>> add a fee*. It’s not a big deal, but we should perhaps make it clear to >>> users that they must follow this split sequence to enter such transactions. >>> >>> It occurs to me that part of the problem likely has to do with where the >>> tranasction was originally entered. I entered this transaction in the INR >>> account, and then attempted to change the USD figure from the USD account. >>> Maybe this is why the exchange rate dialog triggers when I try to change >>> that split. I surmise this because in further tests, I note that I could >>> change the INR split without trouble. I would assume that the dialog would >>> trigger based on the account in which the tranaction was edited (rather >>> than whether the split is considered the “foreign” currency split), but >>> that seems to be wrong. >>> >>> David >>> >>> * - I recognize that I could roll the fee into the exchange rate itself >>> (similar to how some recommend rolling investment fees into the stock share >>> prices), but I am glutton for punishment, and I like to see how much it is >>> costing me to shift money around. >> >> What’s so confusing about the currency exchange rate window? I >> understand it perfectly fine. > > I’m sure you don’t intend for your comment to be dismissive, but it really > comes across that way. > To be honest, I do a little, because I don’t understand why somebody can get so worked up about simple number representation. > For what it’s worth, I specifically find the Exchange rate portion extremely > counterintuitive; most rates I see are described using whole number (or close > to whole number) rat
Re: [GNC] Multiple Currency transaction with bank fee
Am 18.11.2018 um 17:50 schrieb David T. via gnucash-user: > Hello, > > I am a longtime user (GC3.3, Mac OSX) trying to do something new in GnuCash, > and I ran into a situation that I found rather confusing, and I’d like to > share that with the group to see whether I have understood the situation > correctly. > > Basically, I am transferring funds from a US dollar account to an Indian > Rupee account. I have the USD account already, and created the INR account as > an asset account: Assets:Current Assets:Checking Accounts:INR Checking. The > account is denominated in INR, while the parent accounts are USD. I created > the opening balance transaction using funds from my USD-denominated cash > account. After tinkering around with the exchange rate dialog (God, the > terminology used there is not understandable!), I got the numbers to be sane > and based on the actual amounts involved. > > Then, I attempted to document a subsequent transfer I initiated using Xoom, > and this is where things get messy. Xoom is an online funds transfer service > that allows me to transfer this money to this INR account for a small fee. > > So, I opened the INR account and created the transfer for the base amount, > and got a second sensible multicurrency transaction (again, after some > tinkering. Did I mention that the terminology used in the dialog is > confusing?). > > Then I remembered that Xoom charged me another $4.99, and I went to the Cash > account and opened up the transaction in split mode. There, I changed the > total amount charged to my origination account to $504.99, fully expecting to > assign the extra $4.99 to Expenses:Bank Fees. Imagine my surprise when I > received the Exchange Rate dialog again, which GnuCash would not let me > dismiss. I could only adjust the numbers, and everything I did messed things > up further. > > Knowing that many others are using GC for just this sort of use case, I > deleted the transaction, and then read a bit in the Guide, but didn’t find > anything to explain the odd situation I found myself in. I *did* notice that > the example in the Guide started in the originating account and added splits > as: Total Cost, Fee Charged, Net Transferred. When I tried THAT sequence, it > all worked out. > > Here's, my question: Is this the *only* sequence a user should follow? It > seems rather limiting for GC not to allow a user to add a new split to a > multicurrency transaction, but I am unable to see any way to subsequently add > a fee*. It’s not a big deal, but we should perhaps make it clear to users > that they must follow this split sequence to enter such transactions. > > It occurs to me that part of the problem likely has to do with where the > tranasction was originally entered. I entered this transaction in the INR > account, and then attempted to change the USD figure from the USD account. > Maybe this is why the exchange rate dialog triggers when I try to change that > split. I surmise this because in further tests, I note that I could change > the INR split without trouble. I would assume that the dialog would trigger > based on the account in which the tranaction was edited (rather than whether > the split is considered the “foreign” currency split), but that seems to be > wrong. > > David > > * - I recognize that I could roll the fee into the exchange rate itself > (similar to how some recommend rolling investment fees into the stock share > prices), but I am glutton for punishment, and I like to see how much it is > costing me to shift money around. What’s so confusing about the currency exchange rate window? I understand it perfectly fine. But yes, I’ve also noticed that the dialog is triggered depending on were the transaction was entered. When following the sequence described, you can always change the amounts and add fees. I don’t if has something to with the usage of trading accounts. But I could add a fee in this scenario just fine. Standard account currency EUR, foreign currency USD, exchanging EUR to USD. Starting with a blank transaction in the EUR account, I selected the USD account and entered the amount in USD, got prompted for the exchange rate and remembered the converted EUR amount and completed the transaction with this amount and the EUR account and left the transaction. Afterwards I changed the amount for the EUR account and could just assign the new remaining amount to an EUR exchange rate expenses account. What would be your use case. You could also write the final EUR amount first and change the imbalance EUR account to the right one afterwards. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription
Re: [GNC] [GNC-dev] Automatically split transactions with sales tax
Hi, Am 10.11.2018 um 22:09 schrieb CHRISTOPHER PEARCE: > Hello all, > > I would like Gnucash to automatically create a split transaction for sales > tax when a taxable product is bought/sold. I deal with a lot of > transactions, and its a pain to manually enter the sales tax for each one. > I'd rather just work within the general ledger and have Gnucash do it > automatically. This feature has been wanted for a long time: https://bugs.gnucash.org/show_bug.cgi?id=371581 > For example, I buy a widget for $100 + 5% GST = $105. I want Gnucash to > automatically create the split, and allocate $5.00 to the GST liability > account. > The only way to do this in a fully automatic fashion is by using the business features with the tax tables and writing invoices. Although this system only really works for accrual accounting, because the VAT/GST will posted to VAT due, unless you route it through some temporary accounts. For entering it in the General Journal directly: I guess you already know the built-in calculator features of gnucash, so that you could write 1*105 to get the $105 paired with the use of account numbers for making the entry easier. But for what it’s worth I also would like to have a way to have a column for the tax-table to use in the transaction register. However for I seem to have understood it’s very deeply ingrained in the business features, that it would be a lot of work to do so. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple currencies and business functions
Am 07.11.2018 um 01:32 schrieb Matthew Pounsett: > On Tue, 6 Nov 2018 at 15:30, Christian Kluge wrote: > >>> The currency logic is pretty simple: every amount you see in the invoice >>> entries is assumed to be in the customer's default currency. They income >>> account for each entry can be in a currency different from the invoice >>> account. In that case a currency conversion will be applied when posting >> this >>> amount to the income account. But as amounts for billable items come >> from the >>> entries, they are assumed to be in the customer's currency. >> >> >> That’s why my solution would be never to income and expense accounts in >> foreign currencies, but only assets and liability accounts in addition >> to the trading accounts. >> > > Expense accounts mostly get smoothed into one currency by the effects of > having banks convert on deposit or charge in bank accounts and credit > cards. Although I still have to deal with foreign currency service charges > on international wire transfers. > > I don't think it's reasonable to expect to have only one income currency > with international clients. It’s not resonable to use different currencies for income and expense accounts and the expense accounts are no going to be smoothed out by paying them with your standard bank account because of the fluctuating exchange rates. I’m not saying that you can’t bill your clients in other currencies or that they can’t pay you in their home currency. Although some might prefer to pay in your currency, because of the DCC issues. If you’re using foreign currency expense accounts and have some transactions throughout the year, open up a profit and loss report with only one currency and play a bit with the conversion settings. Since your liabilities are fully paid, there shouldn’t be any fluctuation in the values anymore, but with your method there will be. If you’re just recording those transactions through asset and liability accounts and leave the income and expense accounts in the default currency, the only time you have to account for the realized currency exchange gain/loss when you’re paying your liability. I can’t tell which exchange rate you’ll have to use when setting up the balance sheet, since I don’t know the specifics of your jurisdiction. Better check with an CPA there. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple currencies and business functions
Hi, just a minor addition. Am 06.11.2018 um 21:29 schrieb Christian Kluge: > Hi, > > Am 06.11.2018 um 18:22 schrieb Geert Janssens: >> Op dinsdag 6 november 2018 17:16:16 CET schreef Matthew Pounsett: >>> I have cases with both billable employee expenses (vouchers) and billable >>> purchases (vendor bills) which need to go on customer invoices. This is >>> fairly straight forward... the problem I'm having is how to deal with these >>> when the currency I'm entering the voucher or bill in is not the same as >>> the customer's invoice currency. >>> >>> To use a concrete example, say I've got a $100 employee expense in CAD that >>> gets marked as billable. If I have a client whose default currency is USD, >>> when the item is added it appears with the CAD value ($100) but is added up >>> in the total at the bottom as if it's USD. >>> >>> Is there a step I'm missing somewhere to get it to show up as a USD value >>> in the invoice? >> >> I believe you have just pushed the boundaries of what to do with invoices >> further than anyone ever could have imagined :) >> >> I don't think anyone so far ever considered the case of having billable >> expenses in a different currency from the invoice currency. And from what >> you >> tell I gather it's currently not supported. >> >> The currency logic is pretty simple: every amount you see in the invoice >> entries is assumed to be in the customer's default currency. They income >> account for each entry can be in a currency different from the invoice >> account. In that case a currency conversion will be applied when posting >> this >> amount to the income account. But as amounts for billable items come from >> the >> entries, they are assumed to be in the customer's currency. > > > That’s why my solution would be never to income and expense accounts in > foreign currencies, but only assets and liability accounts in addition > to the trading accounts. > >> >> This is a bug either way: or gnucash should prevent an entry from appearing >> as >> billable if it's original bill is not in the same currency as the invoice, >> or >> gnucash should support this and properly handle currency conversions. >> The first solution will be far more easy to implement than the second though. >> >> Can I ask you to file this as a bug report in bugzilla ? Refer to http:// >> wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker. > > > For the actual problem my solution would be as follows. > > Firstly I would grab the current conversion rate via Finance-Quote or > get it from somewhere else. > > That next thing would be to setup an temporary assset account in CAD so > that you can record your income later on. > > After this I would write the invoice and use the account previously set > up as the Income Account. > > Beware when writing the invoice you’d have to write the converted amount > in USD in the unit collumn. Luckily gnucash has rudimentary calculator > functions so that you can just write 100.00 press ÷ or × depending which > way the quote is given and paste the rate and you should get the > converted amount. u> > I would mention the CAD amount in the description and maybe also add the > conversion rate there or after the total invoice amount. > > Then go on and add your other billable lines. > > If you’re going to post the invoice, you’ll get asked for the conversion > rates. > > If everything plays out you should get the same amount in CAD, else just > change it, there sometimes are little rounding errors. > The other solution would be to cancel the posting and change the unit price. > The last operation would be to add a transaction from the temporary CAD > asset account to your normal USD income account. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple currencies and business functions
Hi, Am 06.11.2018 um 18:22 schrieb Geert Janssens: > Op dinsdag 6 november 2018 17:16:16 CET schreef Matthew Pounsett: >> I have cases with both billable employee expenses (vouchers) and billable >> purchases (vendor bills) which need to go on customer invoices. This is >> fairly straight forward... the problem I'm having is how to deal with these >> when the currency I'm entering the voucher or bill in is not the same as >> the customer's invoice currency. >> >> To use a concrete example, say I've got a $100 employee expense in CAD that >> gets marked as billable. If I have a client whose default currency is USD, >> when the item is added it appears with the CAD value ($100) but is added up >> in the total at the bottom as if it's USD. >> >> Is there a step I'm missing somewhere to get it to show up as a USD value >> in the invoice? > > I believe you have just pushed the boundaries of what to do with invoices > further than anyone ever could have imagined :) > > I don't think anyone so far ever considered the case of having billable > expenses in a different currency from the invoice currency. And from what you > tell I gather it's currently not supported. > > The currency logic is pretty simple: every amount you see in the invoice > entries is assumed to be in the customer's default currency. They income > account for each entry can be in a currency different from the invoice > account. In that case a currency conversion will be applied when posting this > amount to the income account. But as amounts for billable items come from the > entries, they are assumed to be in the customer's currency. That’s why my solution would be never to income and expense accounts in foreign currencies, but only assets and liability accounts in addition to the trading accounts. > > This is a bug either way: or gnucash should prevent an entry from appearing > as > billable if it's original bill is not in the same currency as the invoice, or > gnucash should support this and properly handle currency conversions. > The first solution will be far more easy to implement than the second though. > > Can I ask you to file this as a bug report in bugzilla ? Refer to http:// > wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker. For the actual problem my solution would be as follows. Firstly I would grab the current conversion rate via Finance-Quote or get it from somewhere else. That next thing would be to setup an temporary assset account in CAD so that you can record your income later on. After this I would write the invoice and use the account previously set up as the Income Account. Beware when writing the invoice you’d have to write the converted amount in USD in the unit collumn. Luckily gnucash has rudimentary calculator functions so that you can just write 100.00 press ÷ or × depending which way the quote is given and paste the rate and you should get the converted amount. I would mention the CAD amount in the description and maybe also add the conversion rate there or after the total invoice amount. Then go on and add your other billable lines. If you’re going to post the invoice, you’ll get asked for the conversion rates. If everything plays out you should get the same amount in CAD, else just change it, there sometimes are little rounding errors. The last operation would be to add a transaction from the temporary CAD asset account to your normal USD income account. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR
Am 02.11.2018 um 17:42 schrieb Wm via gnucash-user: > > I am known for saying that gnc should not be used for trading as it > isn't suitable. For starters it records a price per day, think about the > significance of that for an intra day trader. Duh! > I don’t use GNC for trading either and since the prices are recorded for the day only, I’d like to have an option to get the reference rate from central banks via Finance-Quote instead of dynamic price source that can change all the time. You can’t really get consistent results, if you update your quotes from AlphaVantage at a slightly different time. The reference rates are fixed once per day, no chance of getting them wrong. Currency trading and keeping accounting records should kept separate and not done with one price source. One’s time unit is seconds and fractions of them the other is done in days. So I’d really like to see the ECB reference rates[1] for the eurozone getting added to finance-quote, which should be doable, since they give some information on how to retrieve with a bit of scripting. Unfortunately I’m not that fond in programming in Perl. Kind regards Christian Kluge [1] https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Capital losses in Advanced Portfolio Report
A well defined error is still an error. Am 22.10.2018 um 00:22 schrieb Christopher Lam: > It's hard wired because that's what the report writer wrote, and was > merged into gnucash, as a voluntary contribution. > > It's rather difficult to modify these reports and maintain full > compatibility with everyone who has used them previously and expect the > report output to be predictable. Often the report behaviours are only > discovered by users reporting unusual behavior. > > As discovered here this report expects transfers from STOCK/FUND > accounts to > > * ASSET/LIABILITY for stock/fund purchases/sales > * INCOME for capital gains/losses > * EXPENSE for transactional costs eg brokerage fees > > > This is now well-defined (albeit not well documented yet), works well > within the Gnucash engine. IMHO the report shouldn't be modified. > > On 22/10/18 2:39 am, Christian Kluge wrote: >> Hi, >> >> isn’t this hard wiring and expecting bad style? Could you make in a way, >> to select the both account types for the report? >> >> I’d feel confortable making a debit entry to an income account if it >> isn’t either a contra-income account like rebates or cash discounts or >> as a correction entry on a normal standard income account. >> >> Kind regards >> >> Christian Kluge >> >> Am 21.10.2018 um 16:35 schrieb John Ralls: >>> That’s because the Advanced Portfolio Report is hard-wired to expect >>> capital gains and losses to be posted to an income report with gains >>> as credits and losses as debits. >>> >>> Regards, >>> John Ralls >>> >>> >>>> On Oct 21, 2018, at 3:18 AM, José A. Fernández Troncoso >>>> wrote: >>>> >>>> Yes, when I create a sale transaction on the stock, a capital loss is >>>> calculated automatically by the report and shown as a negative >>>> amount in >>>> the Realized Gain column. That's fine by me. >>>> >>>> The problem is that when I add a split to record the loss manually on >>>> the Expenses:Capital Loss acount, the amount recorded on the stock >>>> acount split (in the Total Sell column) is then added to the Income >>>> column of the report, as if it were a dividend. >>>> >>>> Regards, >>>> Jose >>>> >>>> On Saturday, October 20, 2018 at 10:14:59 PM CEST Richard Ullger wrote: >>>>> On 20/10/2018 17:19, José Antonio Fernández Troncoso wrote: >>>>>> Hello, >>>>>> >>>>>> In my advanced porfolio report, capital losses linked to a stock >>>>>> account are added to the Income column as if they were dividends. >>>>>> >>>>>> Could anyone using this report provide some feedback as to whether >>>>>> this also happens to them? Is there a bug in the report or am I >>>>>> doing something wrong? >>>>>> >>>>>> I'm using GnuCash Version: 3.2. Build ID: 3.2+ (2018-06-24). >>>>> I've been using this report for some time and have never seen this >>>>> behaviour. I'm currently using Build ID: git 3.3+ (2018-09-29) >>>>> >>>>> The income column reflects the income that I have recorded against the >>>>> stock. >>>>> >>>>> A capital loss is shown as a negative amount in the Realised Gain >>>>> column. However there appears to be a bug in the amount of Realised >>>>> Gain. The report seems to try to calculate the gain/loss rather than >>>>> report on any gain/loss recorded against the stock. >>>>> >>>>> A loss in the valuation is shown as a negative amount in the >>>>> Unrealised Gain column. >>>>> >>>>> Regards, >>>>> >>>>> Richard. >>>>> >>>>> ___ >>>>> gnucash-user mailing list >>>>> gnucash-user@gnucash.org >>>>> To update your subscription preferences or to unsubscribe: >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>> If you are using Nabble or Gmane, please see >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>> - >>>>> Please remember to CC this list on all your replies. >>>>> You can do this by using Reply-To-List or Reply-All. >>>> >>>> >>>> __
Re: [GNC] Capital losses in Advanced Portfolio Report
Hi, isn’t this hard wiring and expecting bad style? Could you make in a way, to select the both account types for the report? I’d feel confortable making a debit entry to an income account if it isn’t either a contra-income account like rebates or cash discounts or as a correction entry on a normal standard income account. Kind regards Christian Kluge Am 21.10.2018 um 16:35 schrieb John Ralls: > That’s because the Advanced Portfolio Report is hard-wired to expect capital > gains and losses to be posted to an income report with gains as credits and > losses as debits. > > Regards, > John Ralls > > >> On Oct 21, 2018, at 3:18 AM, José A. Fernández Troncoso >> wrote: >> >> Yes, when I create a sale transaction on the stock, a capital loss is >> calculated automatically by the report and shown as a negative amount in >> the Realized Gain column. That's fine by me. >> >> The problem is that when I add a split to record the loss manually on >> the Expenses:Capital Loss acount, the amount recorded on the stock >> acount split (in the Total Sell column) is then added to the Income >> column of the report, as if it were a dividend. >> >> Regards, >> Jose >> >> On Saturday, October 20, 2018 at 10:14:59 PM CEST Richard Ullger wrote: >>> On 20/10/2018 17:19, José Antonio Fernández Troncoso wrote: >>>> Hello, >>>> >>>> In my advanced porfolio report, capital losses linked to a stock >>>> account are added to the Income column as if they were dividends. >>>> >>>> Could anyone using this report provide some feedback as to whether >>>> this also happens to them? Is there a bug in the report or am I >>>> doing something wrong? >>>> >>>> I'm using GnuCash Version: 3.2. Build ID: 3.2+ (2018-06-24). >>> >>> I've been using this report for some time and have never seen this >>> behaviour. I'm currently using Build ID: git 3.3+ (2018-09-29) >>> >>> The income column reflects the income that I have recorded against the >>> stock. >>> >>> A capital loss is shown as a negative amount in the Realised Gain >>> column. However there appears to be a bug in the amount of Realised >>> Gain. The report seems to try to calculate the gain/loss rather than >>> report on any gain/loss recorded against the stock. >>> >>> A loss in the valuation is shown as a negative amount in the >>> Unrealised Gain column. >>> >>> Regards, >>> >>> Richard. >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] bank2qif - a gnucash companion tool
Am 02.10.2018 um 22:07 schrieb Łukasz Piątkowski: > Hi everyone! > I'm new here, but I'm using gnucash for about 10 years now. A few > years back I created a small helper tool, that allows you to get a > bank statement from a bank, convert it to QIF format and then import > to gnucash. I know there were tools like that already, but mine can > also convert transactions in the statement according to user-defined > rules and thus automatically assign them to gnucash account. I'm using > it for years as well, but recently I cleaned it a little bit, added > some docs and published on github. If you're interested,check the > project here: https://github.com/piontec/bank2qif > > It is designed to be easily extensible, so it should be easy to add > new bank statements formats or transaction conversion options. If you > find it useful, please link in the docs for others to find. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > You might want to check out the new CSV-Importer in GnuCash 3 and the Bayesian Matcher or maybe you can even directly import the transactions from the bank without an extra file. For which I don’t know why to convert it to QIF, if wasn’t provided by the bank that way firstly, since as I said, gnucash 3 can import CSV-files just fine. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] GnuCash 3.3 Released
Hi, Am 30.09.2018 um 22:42 schrieb John Ralls: > • Bug 796665 - Backspace Key Inoperable After Ctrl+V. This seems to be fixed, however I’ve encountered a new one. Under certain circumstances I can’t select-all on autofilled transactions with Crtl+A, if I’ve clicked into a text input field, instead a random portion of the line gets selected right when I press Ctrl, the “a“ has no effect afterwards. Is this already known or should I file a report? Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [OT] Why is Debit abbreviated Dr?
Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user: > David > > I would love to agree with you but….. > > In standard journal notation cr is a debt and dr an asset. This is because > it is nothing to do with credit (+ve) and debit (-ve) in any sense (or tense) > but to do with a creditor (to whom we owe) and a debtor (who owes us). Hence > dr and cr relate to debtor and creditor and not to any form of debit or > credit. > > For example, if I take cash from the cash box and deposit it at the bank I > enter a cr to the cashbook and a dr to the bank account. Actually you should a transit account for the period in between taking and out of the cash box and that journal entry and the day the bank actually books this deposit on your banking statement. > Totally counterintuitive which is why accountancy is a black art and should > be banned. Every form of accounting assumes that the debit side will give its value back one day as the original Italian formulations «deve dare» “shall give“ and «deve avere» “shall have”, everyone knows that’s never going to happen but still, nothing counterintuitive there. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [OT] Why is Debit abbreviated Dr?
Hi Am 05.09.2018 um 16:58 schrieb David Cousens: > Derek > > […] the first documented use of the accounting equation used the terms debere > (to owe) and credere (to entrust) to describe > the two sides of the basic accounting equation but there is also evidence > that Pacciola used Per (from) and A (to) in > journal entries. He just used “Per” and “A” in journal entries. Apparently a similiar form of journal entry was also used in English just with words “By” and “To” which sounds nicer than saying credit and debit all the time. https://archive.org/stream/studiesinhistory00litt#page/223 > I don't know if any originals of Pacciola's original treatise have survived > […] > Another translator Geejsbeek in > 1914 suggested Dr comes from "in dare" (give) and "in havere" (receive). His translation, with facsimilies of Pacioli’s original can be read here: https://archive.org/details/ancientdoubleent00geijuoft Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Summarizing cash flow report w.r.t. entries and exits (discounts)
Hi, under certain circumstances VAT can be treated as expense/income, e. g. in Germany when one’s only required to do cash based accounting. In that case payable output tax and refunds would be treated as income and input tax and vat payments are treated as expense. Kind regards Christian Kluge Am 09.08.2018 um 17:57 schrieb Adrien Monteleone: > By all means, talk to a local CPA, but usually a pass through is treated as a > liability. > > So you’d have this account: > > Liabilities:VAT payable > > The invoice transaction would look like this: > > Dr. Cash/Checking/etc. > Cr. Income > Cr. Liabilities:VAT payable > > The debit would be for the full amount received. > > The credit to income is just for your services/products. > > The VAT is strictly a liability. Those funds don’t belong to you and you > didn’t earn them so they are not income. > > If you pay estimated VAT in advance and then get refunds, that should simply > reduce your actual liability. So when paying the estimated amount, you’d > enter a debit to that Liability account, and then each invoice will reduce > that pre-payment as they are posted. If you receive a refund for excess > pre-payment you’d enter something like this: > > Dr. Cash/Checking/etc. > Cr. Liabilities:VAT payable > > Income shouldn’t enter the picture here. Had you estimated exactly, there > would have been no refund. > > If you receive ‘vendor compensation’ for collecting and remitting the tax for > the state, that is probably income, but get a professional opinion. (Usually > a small percentage of the tax due and subtracted when filing.) It’s usually > not actually paid-back to you, you just get to keep it, though your > jurisdiction may do otherwise. > > Regards, > Adrien > > >> On Aug 9, 2018, at 8:54 AM, brainwash wrote: >> >> I don't know how it should be set up as I'm using this only for personal >> bookkeeping. >> To answer the question: the VAT is a liability(?) in that I receive it from >> the customers and have to give it back to the state. >> There's is also some VAT on expenses but it would be too tedious too track >> that for each small purchase. >> >> With regard to that, the VAT is self-reported and predicted, so I sometimes >> end up receiving discounts (kickbacks?) from the state. This shows up as >> income under the "Cash flow", but I guess in that case it makes sense. >> >> Regards >> >> >> >> -- >> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Forcing a single payment to split across invoices with the older one not being paid in full
Hi, Am 06.08.2018 um 22:05 schrieb Adrien Monteleone: > I have a customer that has several invoices open. The oldest one is rather > large so they are paying in installments. But when they pay these > installments they are also paying newer smaller invoices. > > But when I enter a payment GnuCash won’t let me split the payment between the > two. It forces the entire payment to the older invoice. (yes, I selected both > in the Process Payment window) This leaves the newer smaller invoice as > ‘unpaid’ and the older invoice as having more payment applied to it than > should be. > > I can’t fix this in lots (as far as I can tell) since there is only the one > split. > > If I try to adjust the payment transaction (from my cash account - not A/R), > that is, I’ve tried changing the amount posted to A/R to reflect the larger > payment on the older invoice, and then manually add a split to cover the new > invoice, and then ‘Edit Payment’ but GnuCash complains that one of the splits > is in a business account that isn’t a business transaction and tells me it’s > going to be ignored. > > So what I have is something like this: > > Dr. Cash $500 > Cr. A/R $500 > > But what I need is this: > > Dr. Cash $500 > Cr. A/R $450 > Cr. A/R $ 50 > > If the older invoice was being paid in full, this would work just fine, but > there is still a balance. GnuCash won’t let me split this payment and retain > everything in a single transaction. I suppose I could create two separate > payment transactions, but then this breaks up the actual customer payment > amount and makes it look like two payments instead of one. > > Any ideas? My suggestion would be to create a temporary clearing account to which all total payments are posted before they’re split to the appropriate invoices, if there’s no solution with the business module. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Operating Checking Account in Overdraft
Am 02.08.2018 um 16:41 schrieb Mike or Penny Novack: > On 8/2/2018 9:21 AM, Adrien Monteleone wrote: > >> I have sent an email to the Australian and New Zealand Chartered >> Accountants asking them the question. >> >> I will let you know what they say. >> >> Kind Regards, >> >> Murray > > This is something we here in the US can't help much on because we do not > have "two way checking accounts". We might have checking accounts with > "overdraft protection" but with those the credit balance situation is > assumed to be temporary. We might have lines of credit accounts against > which checks can be written (normal way to make disbursements from the > account) but with these the balance is almost never* debit, the account > a liability. What we don't have is accounts designed to be used either way. > > Michael D. Novack > In Germany this account would also be listed as a liability on the balance shield. In fact the accounting program I use at work lets you select secondary account types so that accounts with a negative balance get assigned a new position on the other side of the balance sheet. Maybe this could also be a possible idea for GnuCash. Kind Regards, Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to process a purchase made without paying VAT and add it as an investment to be later depreciated
Hi, Am 13.07.2018 um 23:02 schrieb Jeremy D: > Hi Geert, Frank, > > First of all, I really appreciate the feedback. > > > > > > > > > *assets: VAT reimbursable Buys @ full rate: 21% > : liabilities: VAT Sales: 21% > Import with VAT ID: 21%* > > This resembles more or less what my accountant told me to do. Also he > strongly advised against the use of foreign VAT accounts for any of my > purchases (as a matter of fact I still have only two accounts - VAT > Receivable/VAT Payable -, and both are in use for Belgium). That's why > there's no tax table in the example sent, I just added and subtracted the > VAT manually. However, this solution creates a problem in that the > Liabilities placeholder account now has increased so much and I don't know > what the next step is. You would have to add two lines with a clearing account that cancel each other out, one with a tax table and the other without to adjust your liability. Also depending on your tax forms I might add different input and output vat accounts for all different reverse charge cases. I’m wondering why you didn’t come across this earlier. Don’t you use other services in the sense of VAT provided by companies from third countries or the EU, like some online services? Has Amazon always shipped from a Belgian warehouse or did they ship from Germany and in the end have provided you with technically wrong invoice since they didn’t know better? All these are cases where this whole reverse-charge thing also should apply if the Belgian laws are similiar to German ones, which they should be thanks to the EU VAT directive. > > My accountant and I created the example in my first message together but, > as he isn't familiar with Gnucash (he found it very difficult to use), I'm > afraid it might contain errors.> > Only minor ones in case of the German places names in your Vendors: Here have some umlauts and sharp-s: äöüßÄÖÜẞ :-). > I'm not an accountant by any means but I at least want to be able to > understand what I'm doing with regards to Gnucash. > > If it's not too much trouble, would you perhaps be so kind as to send me > one finished example of the former? Just to make sure I'm understanding > this correctly. I'm providing an early copy of my own Gnucash file in > attachment (I deleted all transactions first but all accounts necessary are > still there). I hope my take at your example will help. > > *I hope, you did not, because negative amounts are reserved for stornos.* > > You mean, like in the case of a reimbursed expense? Storno is the German word for a reversal transaction. > > Thanks for the support! > > Jeremy Kind regards Christian P.S.: I might like to remind everyone that bug 735408 is really annoying. Why can’t you add a link to original invoice to a transaction created by the business module. You might be asked to show your receipt for a particular transaction and how nice would it be if was just one click away without going through folder structures?a gnucash_jeremy.gnucash Description: application/gnucash ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
Am 02.07.2018 um 03:05 schrieb Christopher Lam: > Discussions are useful; but would anyone have an idealised template, or > sample output that the balance sheet should produce? Idealy with the > 'account-has-children-and-amounts' peculiarity? > The balsheet in development will, ideally, replace the current (non-eguile) > one. As I’ve written before the template for a German balance sheet is defined in § 266 HGB, but I don’t feel able to provide the English translations. Regards Christian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
Am 01.07.2018 um 01:57 schrieb DaveC49: > Stephen John, Geert > > In accounting terms there are really only 3 basic account types: > Asset > Liability > Equity > > These all *must *satisfy the basic accounting equation Assets=Liabilities > +Equity. > > The two sides of this equation are what the German /European system defines > as Activa and Passiva but these groupings are primarily reporting > requirements not account heirarchy. Is there really a need to have an > additional placeholder category as the reporting grouping can be readily > defined from the existing basic account heirarchy structure? > In the German system active and passive are seen as the fundamental account types. In the end it leads to the same result, but I get your point of view. Hovever I would suggest make changes to the balance sheet report to be able to produce European reports. Regards, Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
Am 30.06.2018 um 22:52 schrieb John Ralls:
>
>
>> On Jun 30, 2018, at 12:00 PM, Christian Kluge wrote:
>>
>> Am 30.06.2018 um 05:37 schrieb John Ralls:
>>>
>>>
>>>> On Jun 29, 2018, at 3:26 PM, Christian Kluge
>>>> wrote:
>>>>
>>>> Hi,
>>>>
>>>> Am 29.06.2018 um 19:26 schrieb John Ralls:
>>>>>
>>>>>
>>>>>> On Jun 29, 2018, at 9:52 AM, Geert Janssens
>>>>>> wrote:
>>>>>>
>>>>>> Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
>>>>>>> Stock accounts need to have a parent denominated the currency in which
>>>>>>> the
>>>>>>> stock trades in order for the asset roll-up to work correctly on the
>>>>>>> Accounts page. Three-commodity transactions are possible using trading
>>>>>>> accounts, but I haven’t dealt with that stuff in a while and the details
>>>>>>> have gone fuzzy on me.
>>>>>>>
>>>>>>> Stock accounts aside, let’s not conflate different purposes. We *should*
>>>>>>> have an account type to accommodate the European Passive account with
>>>>>>> Liability and Equity children, so let’s create that. We’ll need to tweak
>>>>>>> some of the reports a bit to accommodate it, but otherwise it won’t have
>>>>>>> much impact. It should, of course, be what we now call a placeholder
>>>>>>> and it
>>>>>>> should be able to have only Root as a parent and only one each Liability
>>>>>>> and Equity placeholder children.
>>>>>>>
>>>>>> I was in fact deliberately trying to come up with a solution that's more
>>>>>> flexible than fitting the currently known use cases. The European
>>>>>> Passive
>>>>>> account was just one example.
>>>>>>
>>>>>> However we may be spending more time on it than necessary. I checked in
>>>>>> the
>>>>>> current version of the commercial accounting package* I also have to
>>>>>> deal with
>>>>>> and it doesn't define a Passive type at all. "Passive" it doesn't even
>>>>>> appear
>>>>>> on its default balance sheet. That is a bit uncommon though as the
>>>>>> reports I
>>>>>> get from my accountant do have a passive section. However just like
>>>>>> gnucash
>>>>>> this package is targeting a worldwide audience (though with country
>>>>>> specific
>>>>>> extensions). That may explain why they didn't bother adding the Passive
>>>>>> section.
>>>>>>
>>>>>> Let me add that contrary to other accounting packages I have played with
>>>>>> in
>>>>>> gnucash the chart of accounts takes a very central place. So whether or
>>>>>> not we
>>>>>> want our own Passive type to group liabilities and equity hierarchically
>>>>>> on
>>>>>> the chart of accounts as well is up for debate.
>>>>>>
>>>>>>> I don’t think that creating a generic placeholder type account that can
>>>>>>> have
>>>>>>> children of any type is a good idea,
>>>>>>
>>>>>> Here's another example: a household that wants to track its finances,
>>>>>> but
>>>>>> would want to keep separate account hierarchies per family member.
>>>>>> Standard
>>>>>> response: create two files. However they would benefit from common
>>>>>> reporting
>>>>>> which is cumbersome with two separate files. So what if we would allow
>>>>>> to
>>>>>> create two independent account hierarchies in one file. With a view type
>>>>>> account one could create two top-levels ("Husband" and "Wife") and
>>>>>> create a
>>>>>> independent hierarchy for each. While this could also be solved if we
>>>>>> would
>>>>>> allow multiple root accounts and make that root visible I'm using it
>>>>>> here to
>>>>>> illustrate there are use cases we are not covering well.
>>>>>>
>>
Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
Am 30.06.2018 um 05:37 schrieb John Ralls:
>
>
>> On Jun 29, 2018, at 3:26 PM, Christian Kluge wrote:
>>
>> Hi,
>>
>> Am 29.06.2018 um 19:26 schrieb John Ralls:
>>>
>>>
>>>> On Jun 29, 2018, at 9:52 AM, Geert Janssens
>>>> wrote:
>>>>
>>>> Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
>>>>> Stock accounts need to have a parent denominated the currency in which the
>>>>> stock trades in order for the asset roll-up to work correctly on the
>>>>> Accounts page. Three-commodity transactions are possible using trading
>>>>> accounts, but I haven’t dealt with that stuff in a while and the details
>>>>> have gone fuzzy on me.
>>>>>
>>>>> Stock accounts aside, let’s not conflate different purposes. We *should*
>>>>> have an account type to accommodate the European Passive account with
>>>>> Liability and Equity children, so let’s create that. We’ll need to tweak
>>>>> some of the reports a bit to accommodate it, but otherwise it won’t have
>>>>> much impact. It should, of course, be what we now call a placeholder and
>>>>> it
>>>>> should be able to have only Root as a parent and only one each Liability
>>>>> and Equity placeholder children.
>>>>>
>>>> I was in fact deliberately trying to come up with a solution that's more
>>>> flexible than fitting the currently known use cases. The European Passive
>>>> account was just one example.
>>>>
>>>> However we may be spending more time on it than necessary. I checked in
>>>> the
>>>> current version of the commercial accounting package* I also have to deal
>>>> with
>>>> and it doesn't define a Passive type at all. "Passive" it doesn't even
>>>> appear
>>>> on its default balance sheet. That is a bit uncommon though as the reports
>>>> I
>>>> get from my accountant do have a passive section. However just like
>>>> gnucash
>>>> this package is targeting a worldwide audience (though with country
>>>> specific
>>>> extensions). That may explain why they didn't bother adding the Passive
>>>> section.
>>>>
>>>> Let me add that contrary to other accounting packages I have played with
>>>> in
>>>> gnucash the chart of accounts takes a very central place. So whether or
>>>> not we
>>>> want our own Passive type to group liabilities and equity hierarchically
>>>> on
>>>> the chart of accounts as well is up for debate.
>>>>
>>>>> I don’t think that creating a generic placeholder type account that can
>>>>> have
>>>>> children of any type is a good idea,
>>>>
>>>> Here's another example: a household that wants to track its finances, but
>>>> would want to keep separate account hierarchies per family member.
>>>> Standard
>>>> response: create two files. However they would benefit from common
>>>> reporting
>>>> which is cumbersome with two separate files. So what if we would allow to
>>>> create two independent account hierarchies in one file. With a view type
>>>> account one could create two top-levels ("Husband" and "Wife") and create
>>>> a
>>>> independent hierarchy for each. While this could also be solved if we
>>>> would
>>>> allow multiple root accounts and make that root visible I'm using it here
>>>> to
>>>> illustrate there are use cases we are not covering well.
>>>>
>>>> I borrowed the idea of a view type account from an old version of the
>>>> commercial package* we have to use. Looking more closely it turns out the
>>>> current version has dropped view accounts and instead is organizing charts/
>>>> reports using a combination of account type (roughly like we do) and
>>>> hierarchical account numbers. So I must admit perhaps the idea was not so
>>>> bright after all :)
>>>>
>>>> The package also doesn't have a hierarchical account tree. It's flat and
>>>> hierarchy is only added in reports as explained above. So there is no such
>>>> thing as a parent account in that package and hence no restriction on
>>>> which
>>>> account type a certain account can
Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)
t would be great. >> For reference this is the list of 17 account types supported by the >> commercial >> package*: >> Receivable, payable, bank and cash (one type), current assets, non-current >> assets, prepayments, fixed assets, current liabilities, non-current- >> liabilities, equity, current year earnings, other income, income, >> depreciation, expenses, cost of revenue, credit card. >> >> Gnucash currently has 15 of which a few are internal only: >> Bank, cash, credit, asset, liability, stock, mutual, currency, income, >> expense, equity, receivable, payable, root and trading. >> >> >> >> The leftovers from this long discussion for immediate use may be summarized >> as: >> - on reports display placeholder accounts once as aggregate account and once >> as its own account if it has splits. >> - work to be more pedantic about the meaning of "placeholder". It should >> become an empty account used for structuring the account hierarchy and for >> collecting (sub)totals. >> - introduce a read-only status for accounts one doesn't want to accidentally >> modify, but that should still appear in the chart of accounts in various >> places >> - replace "hidden" combined with current "placeholder" with "inactive". >> - consider introducing a passive account type to be able to structure the >> chart of accounts and reports conform European habits. >> - think of ways to have more than one chart of account in one file (only >> mentioned first in this message). > > There’s been an effort over the last several years between the IASB and the > US’s FASB to reconcile IAS and US GAAP for the obvious reason that it’s a > royal PITA for international businesses to have to present their books in > different ways to different regulators. I discovered when looking for an IAS > example CoA earlier today that it’s apparently come to fruition as IFRS and > that the standard CoA doesn’t have a “Passive” super-category [1], so perhaps > the rest of the world is catching up with GnuCash. ;-) > Not the whole world. Section 266 of the German HGB requires the balance sheet to split in active and passive and that’s how it’s displayed in every German accounting software. https://www.gesetze-im-internet.de/hgb/__266.html Also while you add it think about new account structures and the placeholder concept could you also consider the equivalents of the other types mentioned in the document above. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Associated Files in 3.1
Hi, I’m running a self-compiled version 3.1 on Linux. I use sqlite as database format. If I associate a file to a transaction everything seems fine as long I have gnucash running. If I reopen gnucash all file associations seem to be gone. However with a sqlite database program I can still see the URLs of the associated files. I’ve already played with the setting for a relative path. What could be the solution to this problem? Thanks in advance! Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Sending data to my accountant
Dear Ian, Am 05.04.2018 um 11:29 schrieb Roache Ian: > What is the best way to get my gnucash data to my accountant for him to check > and prepare my tax return? Is there a way I can do this if he doesn’t have > the gnucash platform? In the newest version 3.0 you have to ability to export all transactions into a CSV file via the file menu. It’ll be easier for your accountant because he’ll can just open your file as a spreadsheet and doesn’t have to copy information manually. And every decent professional accounting software should be able to import custom CSV files. Regards Christian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
