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-21 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
xperience 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 up

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

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

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"

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

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

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 >

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

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 >

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.

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

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, <

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

Re: [GNC] Budgeting glitch after upgrading to 4.14

2023-07-28 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

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

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 > >> o

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

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

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

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

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

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

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

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.

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

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, >

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 <

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

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

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.

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

Re: [GNC] Missing 2nd entry

2022-06-09 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

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 > > > > > > > > > > *From:* C

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 -

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-30 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

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

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

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

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

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 >

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

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

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, <

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

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

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

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" >

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

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, Chri

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

2021-11-22 Thread Christopher Lam
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: > >> You must hav

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 no

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

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

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

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

2021-10-01 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

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,

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

Re: [GNC] Redo account reconciliations

2021-09-04 Thread Christopher Lam
- 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, >> > Consider a well-used bank account. You reconcile every end of the month >

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

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

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

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
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 PM,

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: > *

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

Re: [GNC] Accounting for GST in Australia

2021-07-05 Thread Christopher Lam
he 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 again for your assistance, > > > On Tue,

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

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

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: > > >

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

2021-06-08 Thread Christopher Lam
er 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>> wrote: &

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

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

Re: [GNC] UK. Value added tax.

2021-04-29 Thread Christopher Lam
ern 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 worth merging the U

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

[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

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

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

Re: [GNC] Investments: Bank, Asset or Equity?

2021-03-27 Thread Christopher Lam
Looks fine. However I'm not convinced there's benefit in having placeholder 'Mutual Funds' nor 'Stocks' accounts. Thus the following works well too: Assets (Top-level Parent) = Asset [placeholder] ---Current Assets = Asset [placeholder] --Bank 1 = Bank [placeholder] -Account 1a = Bank

Re: [GNC] Investments: Bank, Asset or Equity?

2021-03-27 Thread Christopher Lam
This looks fine. Alternatively some may record brokerage cash assets into the brokerage parent non-placeholder account itself but I'd recommend your structure. On Sun, 28 Mar 2021, 9:05 am viking, wrote: > @Christopher, > Sorry, our posts crossed. > Still, how do I classify the linked bank

Re: [GNC] asset discrepancy in change of year

2021-03-27 Thread Christopher Lam
Hi Michael, On Sat, 27 Mar 2021 at 18:11, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > There is an issue with keeping multiple currencies in the same set of > books that I have not yet seen discussed in detail, Namely that exchange > rates are not constant over time. > There

Re: [GNC] Investments: Bank, Asset or Equity?

2021-03-27 Thread Christopher Lam
This is the recommended (i.e. to ensure reports and UI behave well) structure: Assets (Top-level Parent) = Asset *[placeholder]* ---Current Assets (sub-account) = Asset [*placeholder]* --Banks etc = *Bank* ---Investments (sub-account) = Asset *[placeholder]* --Brokerage Account

Re: [GNC] Investments: Bank, Asset or Equity?

2021-03-27 Thread Christopher Lam
Looks like a buggy default chart of accounts. On Sun, 28 Mar 2021, 7:01 am viking, wrote: > When I create a new file (category = US) with investment accounts I get the > following structure and types: > > Assets (Top-level Parent) = Asset > ---Current Assets (sub-account) = Asset >

Re: [GNC] Mystery per-security Opening Balances accounts appearing

2021-03-17 Thread Christopher Lam
May be side effect from https://github.com/Gnucash/gnucash/pull/762 On Thu, 18 Mar 2021, 11:09 am Robin Chattopadhyay, wrote: > I've been meaning to ask about this behavior too. I *think* it started > sometime between version 4.1 and 4.4. It seems to me to happen when > creating -- or editing

Re: [GNC] Error on report over time

2021-03-15 Thread Christopher Lam
This is a strange report indeed. May I suggest a bug report at Bugzilla. On Mon, 15 Mar 2021, 3:00 am , wrote: > Hello, > > My "Expenses over time" report and also the "Income over time" report > from last year (2020) is showing November 2019 instead of November 2020 > and the amounts appear as

Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Christopher Lam
Hi David, nice to see the documented method of writing off bad debts. However it seems hackish. It would be good to formalise the methods via a menu item or toolbar button. Similarly, processing refunds is currently done afaiu via credit notes. Numerically it's fine, but does it pass the tax

Re: [GNC] CSV matching produces duplicates?

2021-03-03 Thread Christopher Lam
You mean transactions imported via ofx then reimported with CSV? This may be https://bugs.gnucash.org/show_bug.cgi?id=798128 For now, it'll be best to narrow down your CSV import to exclude the already imported date range. On Thu, 4 Mar 2021, 5:59 am Elmar, wrote: > Version 4.4 from flatpak on

Re: [GNC] Minor issue with invoice layout

2021-02-26 Thread Christopher Lam
Please file a bug report and attach relevant changes. On Sat, 27 Feb 2021, 2:02 am Ajnkns, wrote: > "I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15). My custom > invoice layout changed. Particularly, the Client information, which was > flush with the left margin, is now moved much

  1   2   3   4   5   6   >