Re: [GNC] Owning stocks which are not publicly quoted - which account type suits better?

2024-09-24 Thread Christopher Lam
Interesting question... as someone who's been intimately involved in some gnucash code improvements, I have no idea how to account for "my own company stock share". Could anyone more qualified (and with knowledge of double-entry as it applies to personal *and* own company (cf publicly traded compa

Re: [GNC] How to treat a sale which involves more accounts?

2024-09-24 Thread Christopher Lam
If your instrument is a valuable item, I'd personally insert it into its own account, exactly as you'd record purchase of a property: Purchase: 1/1/2020 Asset:Bank -$1 Asset:Stradivarius +$1 Sale: 1/1/2024 Asset:Stradivarius +$4000 Income:CapGain -$4000 Asset:Bank +$14000 Asset:Stradivar

Re: [GNC] Report stock price history

2024-09-02 Thread Christopher Lam
On Mon, 2 Sept 2024 at 21:36, David Houlden wrote: > Thank you Martin. That is just about perfect and I think it is probably > close enough for me. > > There are two things that would be really nice to have but I can live > without them. > > 1. Display dates along X axis instead of numbers. > Li

Re: [GNC] I need Feature Request format help

2024-08-03 Thread Christopher Lam
Unfortunately the transactions created via Scheduled Transactions are indistinguishable from regular transactions. There's no way to search for them specifically*. *However you could run a Transaction Report, select all accounts, like start and end dates as "today", and set the General>Date Filter

Re: [GNC] Autocomplete only searches displayed entries

2024-07-10 Thread Christopher Lam
This is fixed in 5.8 -- please get a newer release https://bugs.gnucash.org/show_bug.cgi?id=799047 On Wed, 10 July 2024, 2:59 pm Keith Edmunds, wrote: > I've just upgraded vrom v4.13 to v5.6. I have my ledgers filtered to hide > reconciled transactions. With 4.13 the autocomplete would search a

Re: [GNC] Consolidated billing of two credit cards

2024-07-07 Thread Christopher Lam
No one's replied with a direct answer to your query. On Sun, 7 July 2024, 11:55 pm rsbrux via gnucash-user, < gnucash-user@gnucash.org> wrote: > This has led me to consider merging the two credit card accounts in > GnuCash. How easy is this? Easy-- just delete one of the credit card accounts a

Re: [GNC] Bug Version 5.7

2024-06-30 Thread Christopher Lam
Please file all bugs in bugs.gnucash.org On Mon, 1 July 2024, 2:16 pm Jan Lubach, wrote: > LS, > I encountered the following bug in the new version GnuCash 5.7 > The import qif file procedure has a bug. After trying to apply the qif > file, the application closes. After trying to open it again,

Re: [GNC] Account export corruption (GnuCash 5.5)

2024-06-26 Thread Christopher Lam
Hello Please file a bug on https://bugs.gnucash.org/ On Tue, 25 Jun 2024 at 16:39, David Sumbler wrote: > I am using GnuCash 5.5 on xubuntu 24.04. > > Every couple of months or so I need to export about 30 accounts, all of > which are members of the same placeholder account. I export them using

Re: [GNC] Transaction Report Shortcomings

2024-05-04 Thread Christopher Lam
recently or is about > to be fixed. > > > > Also, I should look for the fixed version in the nightly builds, right? > > > > Is that right? > > > > Sorry for double-checking, I just want to be sure I understand, > > Paul > > > > *From:* Chr

Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Christopher Lam
Hi, See Sorting/Show Account Description. This is a bug which will be fixed tomorrow. https://code.gnucash.org/builds/win32/stable/ HTH On Wed, 1 May 2024 at 22:07, Paul Kroitor wrote: > Is there a way to get the Transaction Report to show Account Description > rather than Account Name in the gr

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Christopher Lam
Please pick a recent build from https://code.gnucash.org/builds/win32/stable/ On Sun, 28 Apr 2024 at 21:54, Hao Huang wrote: > Hi, > > The original problem was "The erroneous transaction seems to be the last > of those imported". If that's the case, it won't apply. What is shown in my > case is

Re: [GNC] Recommend Accounting Books

2024-04-20 Thread Christopher Lam
Welcome to Gnucash userlist. GnuCash will happily handle most of your bookkeeping needs. IMHO Learning double-entry is an important business skill that you can acquire via the GnuCash Tutorial & Concepts guide, or https://www.dwmbeancounter.com/bookkeeping-course.html is another that I've used.

Re: [GNC] Use same transfer column info for identical description

2024-04-17 Thread Christopher Lam
ience was > great. > I have done the hard work and quicker than expected. > > Let's see for future updates how the automatic detection works. > > Thanks everyone > > El mar., 16 abr. 2024 5:19, Christopher Lam > escribió: > >> The importer has had some upg

Re: [GNC] Use same transfer column info for identical description

2024-04-15 Thread Christopher Lam
The importer has had some upgrades in the past couple years. You can sort by description in the importer, select multiple transactions with similar descriptions, mass assign to a particular account, mass rename the description too, via the right click menu. On Tue, 16 Apr 2024, 4:14 am Adrien Lave

Re: [GNC] Recording transactions (date)

2024-04-08 Thread Christopher Lam
This is the formal terminology that the accountancy expert bodies deem "revenue recognition". Numerous formal (see IFRS and GAAP) publications exist, with a much better supporting evidence than our informal discussions here. On Tue, 9 Apr 2024, 6:12 am R Losey, wrote: > Since I first learned abo

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-07 Thread Christopher Lam
Correct Geoff, and the latest nightlies will have the correct fix. https://code.gnucash.org/builds/win32/stable/ On Sun, 7 Apr 2024, 12:10 pm Geoff, wrote: > I suspect this bug fix in the 5.6 release notes is the cause: > > Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button

Re: [GNC] View Transactions After Importing from CSV

2024-04-04 Thread Christopher Lam
Hi, enhancements should be logged in bugs.gnucash.org On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Schedu

Re: [GNC] (Multicolumn) Reports no longer sort accounts by account code after date change

2024-01-20 Thread Christopher Lam
Please file a bug in https://bugs.gnucash.org/ and include relevant screenshots. On Sun, 21 Jan 2024 at 08:17, Paul Bente via gnucash-user < gnucash-user@gnucash.org> wrote: > Specifically, Income Statement (Multicolumn) and Balance Sheet > (Multicolumn) Reports > > I’m currently using GnuCash 5.

Re: [GNC] Feature request: Import assistant, room for big improvements

2024-01-15 Thread Christopher Lam
On Tue, 16 Jan 2024, 2:13 pm David Cousens, wrote: > > I haven't yet imported anything under v5.5. but will be catching up in a > few > days. Being able to edit/add data to the description and or memo fields > would be > something I would find useful too as the imported bank data often has > limi

Re: [GNC] Feature request: Import assistant, room for big improvements

2024-01-15 Thread Christopher Lam
Has anyone tried right click the relevant transaction(s) in the ofx or csv import assistant? On Tue, 16 Jan 2024, 12:49 pm David Carlson, wrote: > Which import assistant is being discussed here? The Generic assistant > behind the OFX and QIF imports is quite limited in placing new transactions

Re: [GNC] Train (or Configure?) Bayesian Mapping

2023-12-02 Thread Christopher Lam
Unfortunately there's no mechanism to retrain the Bayesian matcher based on past ofx files. The old ofx textual fields description/notes etc are discarded when ofx import completes. On Sun, 3 Dec 2023, 9:18 am Matt Wise, wrote: > Hi GnuCash users! > > I've been using GnuCash for the last ~3 year

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Christopher Lam
Check the Transaction Report's Account tab. On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Yeah, that's why I started off with this would be trial and error level > effort. > > The OP wants transactions where at least one split appears in set A, but > e

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Christopher Lam
A bit tangential to the issue of reconciliation is that fundamentally IMV reconciliation means to marry up (aka reconcile) the physical periodic (monthly/quarterly/annually) bank statements *against* your own books which carry the canonical data which hopefully supports your financial activity. Gn

Re: [GNC] New Balance entry

2023-10-25 Thread Christopher Lam
It's poorly documented. https://bugs.gnucash.org/show_bug.cgi?id=563565 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please

Re: [GNC] I need basic help

2023-10-25 Thread Christopher Lam
As a non-accountant (although I pretend to be one sometimes) I can't figure out Dr/Cr except that Dr=left,Cr=right. But I do understand numbers (referring to dollars, or, a hot potato). My 4 Rules: 1. Each transaction must total to zero (i.e. after a transaction is complete, no hot potato burning

Re: [GNC] GnuCash 5.4 Repackaged

2023-09-29 Thread Christopher Lam
There's no known change affecting clean up upon exit. It would be nice if the bug hunt could be crowd sourced to identify the exact daily build which introduced this issue https://code.gnucash.org/builds/win32/stable/ On Fri, 29 Sept 2023, 7:08 pm Ian Keiller via gnucash-user, < gnucash-user@gnu

Re: [GNC] Using GnuCash as an Accounting Tutor

2023-09-10 Thread Christopher Lam
Addendum to excellent advice given already. If you're offering a pedagogic approach to accounting principles, it's very likely that you'll have valuable and useful feedback about the usability of the software for learners, the correctness of its tools and reports. The software has improved a lot f

Re: [GNC] Budgeting glitch after upgrading to 4.14

2023-07-27 Thread Christopher Lam
Please upgrade to 5.3 which should have fixed most of these budget issues On Fri, 28 July 2023, 12:24 pm larry johnston, wrote: > We just finished upgrading from 2.6.15 to 4.14 in Windows 10. Our budget > has a glitch. In the bottom rows the Income, Expenses, Transfer and > Remaining to Budget r

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-26 Thread Christopher Lam
On Wed, 26 Jul 2023 at 11:32, john wrote: > Yeah, it's gotten a lot faster since Chris Lam figured out it was checking > every transaction for every split in the transaction and fixed it to only > traverse the transactions once. > This was only 1 part of the speedup: each typical (2 or more spli

Re: [GNC] Transferring mutual funds

2023-07-06 Thread Christopher Lam
Oops forward to user list. On Fri, 7 July 2023, 12:24 pm AC, wrote: > On 2023-07-06 20:46, Christopher Lam wrote: > > On Fri, 7 July 2023, 11:31 am AC, wrote: > > > >> > >> I'm able to log into the new broker's website and see the entire history >

Re: [GNC] Transferring mutual funds

2023-07-06 Thread Christopher Lam
On Fri, 7 Jul 2023 at 05:16, AC wrote: > I just took a look at the Advanced Portfolio report to see what GC > thought about what I had done. It does appear that the basis was lost as > part of the transfer because for each of the funds that transferred over > the new basis is exactly the value at

Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are wrong

2023-04-15 Thread Christopher Lam
https://bugs.gnucash.org/ On Sat, 15 Apr 2023, 5:49 pm Richard Lindgren, wrote: > How do I file a Bugzilla report? > > > > Richard > > > > *From:* Christopher Lam > *Sent:* Saturday, April 15, 2023 5:37 AM > *To:* Richard Lindgren > *Cc:* GnuCash users g

Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are wrong

2023-04-15 Thread Christopher Lam
It's true that only the "Budget report" has been scrutinized for bugs. Please file in Bugzilla. On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, wrote: > I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: > 5.0+(2023-03-25)) after realizing that the budget expense calculations were > not co

Re: [GNC] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

2023-01-16 Thread Christopher Lam
If your company was operating for a while before 01/03/22, you'll want your balance sheet (aka "Statement of Financial Position") to reflect accurately the value of your assets on 28/02/22. You could input your depreciated asset values on that date. However I also like to record the original purch

Re: [GNC] GnuCash 4.900 Released

2023-01-10 Thread Christopher Lam
Note also this release will perform a one-time change to the internal representation of budget amounts to fix a class of bugs. The budget amounts will hopefully be more stable and reliable, and reflect the reverse balanced accounts global preference closely. Beta testers are needed to verify the b

Re: [GNC] NEw user assistance

2023-01-06 Thread Christopher Lam
I would think that if your home currency is CAD and you buy some USD stocks, you'd first transfer some cash from your CAD bank into your brokerage account in USD, then immediately use the latter to purchase your AAPL. On Sat, 7 Jan 2023, 5:46 am Karl, wrote: > Hi there John, > > Thanks for the i

Re: [GNC] Feature request - prevent a transaction with todays date

2022-12-27 Thread Christopher Lam
On Tue, 27 Dec 2022, 8:44 pm Stan Brown, wrote: > > > A related feature I _would_ like to see is the ability to specify a date > range within which no new transactions could be entered. I would use > that to prevent myself from unintentionally changing transactions from > prior years. The existin

Re: [GNC] What accounts should I reconcile?

2022-12-19 Thread Christopher Lam
These are nice examples but I think are still formally assets and liabilities. e.g. I buy dinner for myself and sibling Asset:Bank -$50 Asset:Sibling $25 Expense:Restaurant $25 Later hopefully sibling pays back Asset:Sibling -$25 Asset:Bank +$25 The original question was IIUC about reconciling

Re: [GNC] Net Worth Barchart

2022-12-06 Thread Christopher Lam
Hi Liz; I guess we should do similar activities in tracking GSTs, except I don't handle company tax. I have an account structure: GST GST:GST Sales [L] GST:GST Purchases [A] GST:GST BAS [A] My sales are recorded as: Income:Sales -$1000 GST:GST-Sales -$100 Asset:Bank +$1100 My purchases are recor

Re: [GNC] User-defined commands

2022-11-30 Thread Christopher Lam
On Wed, 30 Nov 2022 at 15:55, Helmut Eller wrote: On Tue, Nov 29 2022, john wrote: > See the definition of gnc:add-report-template-menu-item at https:// > github.com/Gnucash/gnucash/blob/maint/gnucash/gnome/report-menus.scm# > L42 for example code. It's all specialized for report

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Christopher Lam
In release 4.12 - try Help > About On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > It looks like you want the chart here: > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > 1. /home//.local/share/gnucash > 2. /home//.local/sha

Re: [GNC] Lots report?

2022-09-03 Thread Christopher Lam
No such report exists. Please feel free to relearn scheme and submit as a PR on GitHub. You may find the Lot Viewer report (exposed only when running GnuCash with --extra) a useful starting point. Good luck! On Sun, 4 Sept 2022, 12:27 pm Brent McBride, wrote: > Hi GnuCash experts, > > Does Gnu

Re: [GNC] Crash in Trial Balance report

2022-08-13 Thread Christopher Lam
May I suggest that any report crash of this sort should be logged in Bugzilla? On Sat, 13 Aug 2022, 9:13 pm Fred Tydeman, wrote: > I am running Linux and GnuCash 4.11 > When I try to do a Trial Balance report, I get a crash. > Screenshot attached. > I assume it is due to bad data somewhere, > bu

Re: [GNC] Build From Source Near Impossible

2022-08-09 Thread Christopher Lam
AdrienM: You may have seen my successful experiment in building on Linux (or WSL2) using Nix to load the dependencies into a temporary shell for building. Note this is not considered canon. https://github.com/christopherlam/gnucash-on-nix On Wed, 10 Aug 2022 at 04:36, Adrien Monteleone < adrien.m

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Christopher Lam
You may try this service which is free for personal use. (Not mine) https://bankstatementconverter.com/ On Thu, 4 Aug 2022, 6:40 am Tom Browder, wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthly PDF statements for

Re: [GNC] more integrated lots features

2022-07-11 Thread Christopher Lam
This use of lots sounds harmless and unlikely to break anything. You can find a handy Lot Viewer report in the Experimental reports, only visible by running GnuCash with --extra cli option. On Tue, 12 July 2022, 1:29 am Mattia Rizzolo, wrote: > Hi people! > > Recently I've been noticing and usin

Re: [GNC] How to reorganize the account tree

2022-06-14 Thread Christopher Lam
On Tue, 14 Jun 2022 at 15:07, Christopher Lam wrote: > Some users have intuitively suggested using Account Codes, which is the > right answer: the default sorting within the account tree has *always*[1] > prioritised account codes over other fields e.g. account type and name. > Howev

Re: [GNC] How to reorganize the account tree

2022-06-14 Thread Christopher Lam
Some users have intuitively suggested using Account Codes, which is the right answer: the default sorting within the account tree has *always*[1] prioritised account codes over other fields e.g. account type and name. However there was an undocumented base-36 sort[2] which was removed without fanfa

Re: [GNC] Missing 2nd entry

2022-06-08 Thread Christopher Lam
It's possible to create a single split transaction. The only requirement is that the transaction must be balanced i.e. the total is zero. Therefore, create a zero-amount split and leave the "other account" field blank. If this is not the case, then you'll have found a quantum anomaly in the engine;

Re: [GNC] GST Report - not showing tax amounts - got it!!!

2022-06-05 Thread Christopher Lam
> realize I could pick more than one account to include and after a few tries > I got it to work – sale transaction plus tax or purchases plus tax. > > Thanks for taking the time to respond. > > I appreciate it. > > Nora > > > > > > > > > > *Fro

Re: [GNC] GST Report - not showing tax amounts

2022-06-05 Thread Christopher Lam
Did you set the Tax accounts correctly as suggested in the report? On Sat, 4 June 2022, 3:14 am Nora, wrote: > Hi Gnucash Users, > > I'm trying to get a report that shows my last 6 months of GST/HST amounts > for both sales and expenses. > I've used the GST report - the headings are correct - l

Re: [GNC] Is there a report with transactions by date and accounts in columns?

2022-05-03 Thread Christopher Lam
I guess the report intends to show the inputs and outputs into the company, you could use the income and GST statement report. Inputs and sales, and outputs are purchases. You can ignore the tax accounts. Then select detailed sales and purchase accounts in the display options. On Tue, 3 May 2022,

Re: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

2022-04-29 Thread Christopher Lam
There's a global preference that you can toggle which removes the update option. On Sat, 30 Apr 2022, 9:52 am Eric H. Bowen via gnucash-user, < gnucash-user@gnucash.org> wrote: > Gyle, > > I do this when I remember, especially with regard to checks. But I've > still had data overwritten later whe

Re: [GNC] Some questions about reports

2022-04-06 Thread Christopher Lam
On Wed, 6 Apr 2022, 9:43 pm Chris Green, wrote: > On Wed, Apr 06, 2022 at 09:24:20AM -0400, Michael or Penny Novack wrote: > > On 4/6/2022 8:15 AM, Chris Green wrote: > > > > > > > > The auditor wants a report which looks pretty much like the profit and > > > loss report but with the underlying b

Re: [GNC] Report - Income Statement - Layout problem

2022-03-23 Thread Christopher Lam
Please be aware that GnuCash is a volunteer effort. In so many (20+) years of users there have been no complaints about this particular layout issue in the Income Statement. A fresh pair of eyes, however, found this genuine layout issue. The Multicolumn Income Statement report in the Experimental m

Re: [GNC] How to apply overpayment to new invoice?

2022-03-23 Thread Christopher Lam
Find the prepayment in the AP or bank register, right click, edit payment, and use it to clear the later invoice. On Wed, 23 Mar 2022, 6:45 pm Eric H. Bowen via gnucash-user, < gnucash-user@gnucash.org> wrote: > I was late with my property taxes this year and incurred a penalty. I > had earlier e

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

2022-03-20 Thread Christopher Lam
On Sun, 20 Mar 2022 at 14:34, Fran_3 wrote: > (snip). > Now I don't see you participating and it seems traffic on the list is way > down. > Have the developers abandoned the project? > Thank you Fran; no, the project is alive as long as there is interest in it. The number of live bugs seems to b

Re: [GNC] Report - Income Statement - Layout problem

2022-03-20 Thread Christopher Lam
You can do Edit > Stylesheet > (choose stylesheet - technicolor?) > Tables > Table Border Width to 1px or more. then OK > Close > Reload report to draw the table lines, which will help show layout errors. I wonder if you have an unusual account tree hierarchy. Maybe file a bug and attach File > Exp

Re: [GNC] Directly posting payments

2022-02-21 Thread Christopher Lam
If you're so inclined, you are very welcome to create a transaction from Bank to A/Payable, then assign as payment to the vendor eg restaurant or grocery store. You can use the Vendor Report to show all payments. To be useful you'll want to create Bill from Vendor which then posts from A/P to the a

Re: [GNC] Stock Merger

2022-02-18 Thread Christopher Lam
Although the UI allows 1 transaction with splits in >1 stock, I believe that there's zero likelihood that portfolio reports are written to handle them. Therefore I would recommend that a stock merger is recorded as two separate transactions -- (1) original stock sale as cash into the broker account

Re: [GNC] Focus on international standards

2022-02-05 Thread Christopher Lam
3. Only the transaction report has the ability to convert transaction amounts into target currency using price at transaction date. Other reports will aggregate the amounts in original currency then convert using price at report date. On Sat, 5 Feb 2022, 8:36 pm Fiable.biz via gnucash-user, < gnuc

Re: [GNC] Warning account contains splits whose reconcile date is after statement date

2022-01-31 Thread Christopher Lam
In more recent builds (4.9 onwards I think) you can view the reconciled date in the transaction report display options. On Tue, 1 Feb 2022, 3:39 am Cricket Onebit, wrote: > I get this warning each time I reconcile my credit card statement. It's > happened for several months now. > > The balance

Re: [GNC] Budget calculation possible bug

2022-01-17 Thread Christopher Lam
Please file a bug report on Bugzilla? On Mon, 17 Jan 2022, 5:42 pm Peter Jackson, wrote: > I am using the Budget routine with Expenses and Income selected, set to > range, manual periods, with 1 selected in both cases. > In the January ie first column only for Income, the Total does not equal >

Re: [GNC] Incorrect QFX Import

2021-12-29 Thread Christopher Lam
It would be nice to have visibility of these imported transactions? Checkbox at the bottom would reveal them, all grayed out, and clicky link to the matched split in the register? From: [1]Jean Laroche Sent: Thursday, 30 December 2021 6:18 AM To: [2]gnucash-user@gnucash.org S

Re: [GNC] Search Results

2021-12-20 Thread Christopher Lam
Hi David-- You cannot, from the UI, explore the search criteria, however if you launch with enhanced logging: "gnucash --log qof.query=debug --logto stdout" then the search parameters will be shown on console. HTH On Mon, 20 Dec 2021 at 20:12, David Carlson wrote: > How can I find our what the s

Re: [GNC] Stock data export to Portfolio Performance

2021-12-10 Thread Christopher Lam
Imnsho, portfolio "performance" is a popular term, and I'm not sure it has an official definition. There's an IFRS report in the experimental menu to analyse a single stock activity. It aims to calculate a mathematical average cost price of the stock. You can then compare it with the stock latest

Re: [GNC] clearing reconciled transactions

2021-12-02 Thread Christopher Lam
Even faster: [Ctrl-A], and [space] to select/deselect 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

Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

2021-11-29 Thread Christopher Lam
If this is the case, then this is very likely a genuine bug and would need a test data file, sample reports in Bugzilla. On Mon, 29 Nov 2021, 9:58 pm Charles Crossan, wrote: > I believe I found the answer to this. > > The Budget report (and the Transaction Report) are showing the "expected" > va

Re: [GNC] Stock transaction research

2021-11-27 Thread Christopher Lam
I believe gnucash can record all your detailed stock accounting accurately, however, the data entry is (imho) difficult to do correctly. Additionally, to extract data from your stock accounts is also not obvious-- from dividends to notional distributions to stock splits, or reinvesting dividends in

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

2021-11-22 Thread Christopher Lam
; really is/was a payment. (I made the invoice when I received the bill, > then entered the payment when I physically paid it) > > And had that band-aid been in place, I would have been unlikely to > discover this discrepancy. > > Regards, > Adrien > > On 11/22/21 7:37 PM,

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

2021-11-22 Thread Christopher Lam
l add that I'm not totally dense, and it seems like you're offering a > > fix, but either some important details are missing, or, we are > > misunderstanding one another. > > > > Regards, > > Adrien > > > > On 11/22/21 6:04 PM, Christopher Lam wrote: &

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

2021-11-22 Thread Christopher Lam
No, the way around, P changes to I. Same fix. On Tue, 23 Nov 2021 at 00:04, Christopher Lam wrote: > You must have opened the AR register, and clicked on the Transaction type > "I" payment split. This stupidly changes it to "P". > The official fix is to not click

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

2021-11-22 Thread Christopher Lam
You must have opened the AR register, and clicked on the Transaction type "I" payment split. This stupidly changes it to "P". The official fix is to not click on the AP/AR register. On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > I was entering annual pr

Re: [GNC] Budget Report Questions

2021-10-10 Thread Christopher Lam
Hello, does the budget report option "Use accumulated amounts" help? If not, please file a bug. On Mon, 11 Oct 2021, 6:21 am Steve Welch via gnucash-user, < gnucash-user@gnucash.org> wrote: > I apologize in advance if the answers to these questions are painfully > obvious. I have tried to read t

Re: [GNC] Split Transaction Confusion Again

2021-10-09 Thread Christopher Lam
I think you're recording the dividend into the Brokerage cash account only. Beware the Advanced portfolio report (and upcoming IFRS average cost report) will not recognise this dividend because it has no split into the stock account. So, you'll want to record as follows: Asset:Broker:Stock 0 STOCK

Re: [GNC] table header alignment in easy invoice and customer reports

2021-09-30 Thread Christopher Lam
You could edit the "CSS-based stylesheet (experimental)" and use this instead of "Easy", Then add somewhere body > table:nth-child(5) > thead > tr > th {text-align:left;} On Thu, 30 Sept 2021 at 15:44, James Thorpe wrote: > I've just migrated from an old 3.5x version to 4.8 and copied across m

Re: [GNC] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

2021-09-25 Thread Christopher Lam
The only mechanism that really exists to have "templated arbitrary formulas" is to use the periodic Scheduled Transactions. It would be nice to have them created ad-hoc (ie menu item Create Transaction from Template which pops up a list of available templates) instead of periodically... On Sat, 2

Re: [GNC] Report Question

2021-09-22 Thread Christopher Lam
Yes it will use 2022 year if the report is launched in 2022. This report is stable and will not be removed from gnucash. The only known blocker against it moving out of experimental is that the valuation into target currency is known to be slightly* flawed when multiple columns are involved. To fi

Re: [GNC] Redo account reconciliations

2021-09-04 Thread Christopher Lam
action, >> it doesn't matter what date the transaction has -- you should re-reconcile >> 31 August! You just need to re-check the February transaction. >> >> -derek >> >> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote: >> > Derek, >> > C

Re: [GNC] Redo account reconciliations

2021-09-04 Thread Christopher Lam
March 2021 onwards. C On Sat, 4 Sept 2021 at 13:01, Derek Atkins wrote: > Chris, > > On Sat, September 4, 2021 8:36 am, Christopher Lam wrote: > > I agree that if an account reconciliation is done periodically correctly > > every time, then it works well. If an ol

Re: [GNC] Redo account reconciliations

2021-09-04 Thread Christopher Lam
I agree that if an account reconciliation is done periodically correctly every time, then it works well. If an old reconciled split is unreconciled and we need to re-reconcile a previous reconciliation date, then the code falls apart. It may be an idea to allow batch unreconciliation of all splits

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread Christopher Lam
There's no mechanism to modify report options from the command line. The gnucash-cli is meant mainly to run reports with sensible defaults (eg balance sheet) and saved reports (eg transaction report with modified options). On Tue, 31 Aug 2021, 5:53 pm flywire, wrote: > This report needs accounts

Re: [GNC] piecharts/linecharts turned blank in reports after upgrade

2021-07-24 Thread Christopher Lam
Try exporting the report to HTML and view source to determine where it's trying to find chartjs sources. On Sun, 25 Jul 2021, 9:06 am Dong Lin via gnucash-user, < gnucash-user@gnucash.org> wrote: > > I created a fresh VM using ubuntu 21.04, minimal install with no gnucash > installed. > > $ sudo

Re: [GNC] Finding sales tax liability

2021-07-10 Thread Christopher Lam
. Is there some way to > differentiate this, like some way for interest and any > other income to be separated from actual sales? > > It seemed to work just fine previously, was the capability > removed for some reason? > > Thanks! > -Paul Kinzelman > > On 7/9/2021 4:46 P

Re: [GNC] Finding sales tax liability

2021-07-09 Thread Christopher Lam
It's likely the Income and GST statement report can be used for your purposes. On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman, wrote: > This is for a business that sells stuff and keeps track of sales tax. > At the end of the reporting period, I need a report of the sales > tax owed to the state. >

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread Christopher Lam
That's exactly how I'd record the RCTI. Auto calculation of GST is only available when using Invoices and Bills, or when using the Scheduled Transactions feature. On Wed, 7 Jul 2021 at 10:53, flywire wrote: > Let's just enter that transaction. > > Following: > * https://wiki.gnucash.org/wiki/Qu

Re: [GNC] Accounting for GST in Australia

2021-07-06 Thread Christopher Lam
Maybe you can paste an example of a complex RCTI? In Australia only 2 TaxTables would be useful. In some jurisdictions you may need more, eg UK has standard 20% and reduced 5% VAT rates. On Tue, 6 Jul 2021 at 12:15, flywire wrote: > Thanks for the wiki Chris. A lot of people use a Recipient Crea

Re: [GNC] Accounting for GST in Australia

2021-07-05 Thread Christopher Lam
hese words on the left side of the screen and the > relevant liability account on the right side. > You did show us how to 'print' a complying Australian GST invoice, but we > are unable to find this back again. Can you please let us know how to do > this? > Thanks agai

Re: [GNC] GnuCash crashes when generating Equity Statement

2021-06-28 Thread Christopher Lam
The clue is in the report file name; there's never been an equity report in the example folder. Where did you get the report from? gnucash/reports/example/equity.scm On Tue, 29 Jun 2021, 9:54 am Jakub Sygnowski, wrote: > Hi all, > I have a problem with GnuCash where it's crashing when generatin

Re: [GNC] Accounting for GST in Australia

2021-06-22 Thread Christopher Lam
Welcome Nathan, Have you checked out the following? https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS On Tue, 22 Jun 2021, 2:59 pm Nathan Ellery, wrote: > Hi, > I have recently started using GnuCash and am having difficulty in > attributing GST to the GST accounts as set up in the chart of

Re: [GNC] Inconsistent meanings of "AsOfDate"?

2021-06-14 Thread Christopher Lam
Hi, On Tue, 15 Jun 2021 at 00:09, Hong Xu wrote: > I'm checking out the APIs of GnuCash. In > xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR > BEFORE the date: > > > https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Christopher Lam
better term? > > Anyway, I'll leave that to the experts. > > Regards > > Geoff > = > > On 9/06/2021 11:34 am, Christopher Lam wrote: > > Hi Geoff > > > > On Wed, 9 Jun 2021, 9:27 am Geoff, > <mailto:cleanoutmys...@gmail.com>>

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Christopher Lam
Hi Geoff On Wed, 9 Jun 2021, 9:27 am Geoff, wrote: > > Gnucash will permit you to run a negative balance on a stock, see > attached screenshot. > The UI will allow you to record transactions when short-selling, but bear in mind: - the current portfolio and advanced portfolio reports cannot hand

Re: [GNC] Read-only transaction

2021-05-20 Thread Christopher Lam
Try right click and select "jump to associated invoice". If this doesn't work then attach the relevant tracefile. On Thu, 20 May 2021, 4:03 pm coolnodje, wrote: >Hi >I have this odd transaction that I can't fix or delete. I'm met with >the following error message when trying to delet

Re: [GNC] UK. Value added tax.

2021-04-29 Thread Christopher Lam
rthern Ireland [from/in] EU > member > states" > > > thanks again, > Maf. > > > > On Monday, 13 April 2020 02:35:10 BST Christopher Lam wrote: > > Hi Maf, any gossip about the treatment of VAT and EU displacement of VAT > > post Brexit? Is it wort

Re: [GNC] Securities disposals: pooling (not FIFO/LIFO/average costing) for UK cgt purposes: average price and identity (GNUCash v.4.5)

2021-04-25 Thread Christopher Lam
On Thu, 22 Apr 2021 at 18:44, RW Jones via gnucash-user < gnucash-user@gnucash.org> wrote: > > [Summary of main question: can GNUCash v.4.5 operate with the UK capital > gains tax rules on pooling requirements for determining price and ident > of securities sold outright and/or on part disposals?]

[GNC] New price source

2021-04-24 Thread Christopher Lam
To casual and regular users: In addition to pricedb-nearest and pricedb-latest, there'll be a new price source 'pricedb-nearest-before' in 4.6 onwards; this will ignore prices *after* the report date. e.g. a user records weekly prices e.g. on 19-dec, 26-dec, 2-jan, 9-jan etc and runs the balance sh

Re: [GNC] Gnucash Close Books option

2021-04-20 Thread Christopher Lam
On Wed, 21 Apr 2021 at 01:15, Derek Atkins wrote: > That is not how GnuCash does it. GnuCash uses a real calendar and has no > "special" dates in there. > > How it *did* it, initially, was to take the "default timestamp" of Dec 31 > and add one second to it. This was because all posted times ha

Re: [GNC] Pdf Export Problems

2021-04-10 Thread Christopher Lam
It's been noted. https://bugs.gnucash.org/show_bug.cgi?id=798158 On Sat, 10 Apr 2021, 7:06 pm Gareth Davies via gnucash-user, < gnucash-user@gnucash.org> wrote: > Hi, > > > > If I create a Transaction Report and export it to Pdf. > > When I try and open it in Adobe Acrobat DC Reader, it will not

Re: [GNC] Hand-over on Succession or Short Term Absence

2021-04-08 Thread Christopher Lam
Michael First, good luck and hope all goes well. Second, you can 'describe' a custom report by the following process. This uses the gnucash-cli tool. $gnucash-cli -R list This will list all built-in and saved reports, the latter denoted by a 'C'. e.g. * Account Summary * Advanced Portfolio *

  1   2   3   4   5   6   >