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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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-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] 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-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] 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] 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] 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] 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] 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] 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
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] 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] 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] 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] 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] 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] 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] 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
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
; 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] Question marks instead of currency in reports

2020-06-17 Thread Christopher Lam
The only technical difference between regular lines and total lines is that the latter is in bold. Try checking your font for bold symbol? On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote: > it now shows up in the reports but the total is still a question mark. see > screenshot below > [image: i

Re: [GNC] How to troubleshot a "Report error"

2020-06-27 Thread Christopher Lam
Hi Lipp The usual approach is to file a bug in bugs.gnucash.org Include the exact version used (3.10?) Also you are using pricedb - it would be worth reviewing the pricedb entries around 9th July and add this to the bug report. C On Sat, 27 Jun 2020 at 14:28, Lipp F. wrote: > Wondering if anyone

Re: [GNC] How to troubleshot a "Report error"

2020-06-29 Thread Christopher Lam
ices > prior to Jul 9 are recorded fractional (as 273 + 342939880122/353546268167) > but displayed correctly (as 273.97). So, it was enough to edit the entry > and re-enter the correct decimal value and everything works fine. > > On Sat, Jun 27, 2020 at 11:37 PM Christopher Lam < >

Re: [GNC] Customer Report - Account Receivable

2020-07-01 Thread Christopher Lam
On Thu, 2 Jul 2020, 12:28 am Geert Janssens, wrote: > Op woensdag 1 juli 2020 18:02:35 CEST schreef Adrien Monteleone: > In practice the most common use case for multiple AR accounts is as Frank > pointed out: you can > have one per currency you do business in. In that case you post invoices > fo

Re: [GNC] Australian System

2020-07-02 Thread Christopher Lam
GnuCash is designed to be world-neutral. Record your transactions in any currency. There is a report "Income and GST Statement" which will summarise your BAS for you, assuming you have recorded them correctly. On Thu, 2 Jul 2020 at 11:00, Mike Alsop wrote: > You have probably been asked a thousa

Re: [GNC] Cost Basis Report on Transaction

2020-07-02 Thread Christopher Lam
No such report exists. It'll be useful to illustrate a sample list of stock transactions and the desired report. On Fri, 3 Jul 2020, 6:59 am , wrote: > I'm evaluating gnuCash for tracking investments. For my taxes I need a > report of all stock sales during the year, showing the cost basis. Pe

Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread Christopher Lam
Going forward, it will be useful to attach your custom invoice and we can offer better feedback. On Fri, 3 Jul 2020, 12:53 am Geert Janssens, wrote: > I'm sorry your distro pulled the rug from under you at this crucial > moment. However if it's that > crucial perhaps you should revert your syste

Re: [GNC] Custom invoices don't work after upgrade

2020-07-03 Thread Christopher Lam
Here you go. Seems to be a nice css template. You should submit for inclusion ^_^ On Fri, 3 Jul 2020 at 11:24, wrote: > Still locked in battle with my invoice template. While testing a few > changes I noticed they weren't being picked up - because I was editing > the wrong file. A search reveale

Re: [GNC] Budgeting > transfers to liabilities and securities purchase

2020-07-07 Thread Christopher Lam
1. Please use the very latest gnucash 3.11 or 4.0; if there are still issues please file bug in Bugzilla. 2. Budget for securities is error prone; currency and share exchanges are complex and not proven to be reliable in budgeting module. On Tue, 7 Jul 2020, 3:43 pm Mark Walters, wrote: > Hi ev

Re: [GNC] Budgeting > transfers to liabilities and securities purchase

2020-07-07 Thread Christopher Lam
Ok. The 3.11 release will have fixed some bugs there. Please copy to list on replies. On Tue, 7 Jul 2020, 7:04 pm Mark Walters, wrote: > Thanks Christopher, just checked and I'm running v3.4 in debian buster. > > On Tue, 7 Jul. 2020, 18:07 Christopher Lam, > wrote: > >&

Re: [GNC] Command Line Report Options

2020-07-17 Thread Christopher Lam
Hi Robin The documentation is not comprehensive yet. The export-type argument refers to the *report-specific* export types available, rather than PDF/XLS/DOC etc. Report-specific exports are rather sparse; currently only the following exist: Income and GST Statement: CSV Tax Schedule Report & TXF

Re: [GNC] Adjusted Trial Balance

2020-07-21 Thread Christopher Lam
The various options in the Trial Balance are very ill-defined. This report was created in 2004 [1], with an addition of merchandising businesses [2], but not actually documented anywhere. They have received minor maintenance fixes only otherwise. So, it would be nice to open a dialogue on what thes

Re: [GNC] Adjusted Trial Balance

2020-07-21 Thread Christopher Lam
ccount is quick, but the Import looks > not so good. Am I missing any tricks here? > > On Tue, Jul 21, 2020, 7:43 AM Christopher Lam > wrote: > >> The various options in the Trial Balance are very ill-defined. This >> report was created in 2004 [1], with an addition of merc

Re: [GNC] Import Transaction Matcher issue in v4

2020-07-27 Thread Christopher Lam
As I understand the ofx spec*, the fitid should be an invariant for the bank and account. By any chance do you have older qfx files to compare? * https://www.ofx.net/downloads.html On Tue, 28 Jul 2020, 4:34 am Fross, Michael, wrote: > Thanks Jean / John for your thoughts. There is a register e

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-28 Thread Christopher Lam
On Mon, 27 Jul 2020 at 18:52, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > 2. Statement of Cash Flows > > I don't recall if this was heavily discussed in a thread or bug report > (I think a bug report, maybe both) but I recall looking over this last > year when trying to help a use

Re: [GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Christopher Lam
Hello Glad you managed to make your report work. The _ could not be used anymore because in guile-3.0 it is a reserved symbol. Many modern Linux distros had moved to guile-3.0 necessitating this change. This change is not limited to experimental reports; all custom reports using _ were similarly af

Re: [GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Christopher Lam
summary section of the report. > > As I mentioned earlier, I feel as if I have learned just enough to > accomplish what I wanted. There might be better or more efficient ways to > accomplish this and I’d welcome any suggestions for improvement. > > - Tim > > > > > On Au

Re: [GNC] recognition of unrealized gains

2020-08-05 Thread Christopher Lam
You may wish to read Peter Selinger's essay at https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html On Thu, 6 Aug 2020, 7:09 am doncram, wrote: > Does GnuCash recognize unrealized gains/losses of investments such as > stocks, so that they would appear in an Income Statement for a given

Re: [GNC] GnuCash and Swedish accounting legislation

2020-08-09 Thread Christopher Lam
This is not a problem that can be solved in an open-source software. Perhaps you're looking for a datafile archiving and notarization service? On Sun, 9 Aug 2020 at 09:27, wrote: > Would like to revive this old thread since the request made by the OP is > still valid for us Swedish users (and ma

Re: [GNC] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

2020-08-11 Thread Christopher Lam
The issue of budgets come back from time to time. There are proposals for shadow/virtual accounts, and also my proposal for virtual transactions; none have gained any traction over the years. https://lists.gnucash.org/pipermail/gnucash-devel/2018-January/041529.html On Wed, 12 Aug 2020, 8:34 am d

Re: [GNC] Recording Tax Correctly

2020-08-16 Thread Christopher Lam
Hi Omer, my approach is: - VAT:Input VAT - an ASSET account - VAT:Output VAT- a LIABILITY account - VAT:VAT Return - an ASSET or LIABILITY account and run the "Income & GST Statement" periodically, posting the govt returns as follows: Dr VAT:VAT Return Cr Bank HTH, C On Sun, 16 Aug 202

Re: [GNC] Recording Tax Correctly

2020-08-16 Thread Christopher Lam
payable (or receivable). It will reset towards zero. On Sun, 16 Aug 2020 at 13:46, Omer Hayat wrote: > @Christopher Lam I'll show this to my > accountant. > In the meanwhile, I tried following: > > Created a 'TAX' account under 'Liability' parent account.

Re: [GNC] Capital Gain Calculations on Split Stocks

2020-08-24 Thread Christopher Lam
David, I don't use stock at all myself but have a couple of suggestions. 1) lots can be made much more visible with the "lot-viewer" report which is hidden behind the --extra flag. 2) FIFO and LIFO are handled in advanced-portfolio, and adjusted cost basis is a difficult task documented and being

Re: [GNC] More Fun with Lots

2020-08-25 Thread Christopher Lam
Hi Geoff, feel free to analyse the Lot Viewer report (visible with gnucash --extra) and offer any suggestions. It was designed to assist AP/AR lot usage, and could be augmented to assist STOCK use of lots (afaik is optional for this). On Wed, 26 Aug 2020 at 02:19, Geoff wrote: > Yes David there

Re: [GNC] Unexpected change in reconcile status

2020-09-01 Thread Christopher Lam
The reconcile-status being reset when editing past transactions' description/notes/memo was a change that was later reverted, although I cannot find the exact release. In latest releases, reconcile-status is reset only when editing split's account & amount IIRC. On Wed, 2 Sep 2020 at 05:45, John

Re: [GNC] Asset accounts: cost, or value?

2020-09-02 Thread Christopher Lam
I can illustrate an example where costs etc are derived from my book. When I purchase a house at $100,000, using a $20,000 deposit and $83,000 mortgage. Purchase costs are $3,000 - includes insurance, buyer's agent fees etc. The Balance line describes Asset:Settlement Running Balance. Deposit As

Re: [GNC] Go To Date

2020-09-05 Thread Christopher Lam
after blank transaction Preferences menu) - already > done > 2. Go to date (menu item and shortcut) - now done > The go to date command makes it very easy to navigate around a large > multi-year GnuCash register. > Thank you Christopher Lam. Great work. > Regards, > Kim >

Re: [GNC] Need to - Mark Split as Un-reconciled - in GC 3.8

2020-09-16 Thread Christopher Lam
This freezing of reconciled splits was removed in a later release: you will be able to modify the textual fields without necessarily resetting reconcile status. In the old release, if you unreconcile then you can simply reconcile again (but you can't reconcile using old statement date, must be rec

Re: [GNC] How to stop a Transfer Funds dialogue autmatically appearing after reconciliation?

2020-09-21 Thread Christopher Lam
Try the preference setting Register / Reconciling / Automatic credit card payment On Mon, 21 Sep 2020, 3:12 pm Jim DeLaHunt, wrote: > Hello, folks: > > I have been catching up on reconciliation of a few credit card accounts > this weekend. For one credit card account, when I click the "Finish" >

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Christopher Lam
I wouldn't add an entry into Expenses:shop -- you didn't exactly spend your money into this shop. Spending/lending money: Liability:credit card -$50 Asset:Friend owes me +$50 Recovering funds: Asset:Friend owes me -$50 Asset:Cash or bank +$50 HTH On Mon, 21 Sep 2020, 9:40 pm Daniel Fishman, wr

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Christopher Lam
x27;t appear in your expense report. IMHO. On Mon, 21 Sep 2020, 10:25 pm Daniel Fishman, wrote: > On 9/21/20 5:15 PM, Christopher Lam wrote: > > I wouldn't add an entry into Expenses:shop -- you didn't exactly spend > your > > money into this shop. > > > > S

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Christopher Lam
aid, I > debit it to Reimbursables. > > Will > > On 2020 Sep 21, at 09-21 09:35:39, Christopher Lam < > christopher@gmail.com> wrote: > > Well you'd use the description field to describe the narrative of the > transaction. "Bought $50 of books from Sho

Re: [GNC] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

2020-09-25 Thread Christopher Lam
The Transaction Report cannot show Debit and Credit totals separately. The Reconciliation Report can, however, due to a prior feature request, the date filters from the reconciled dates. On Sat, 26 Sep 2020, 2:41 am Fran_3 via gnucash-user, < gnucash-user@gnucash.org> wrote: > Is there anyway to

Re: [GNC] $0 splits in QIF imported incorrectly, flipping + and - values

2020-09-27 Thread Christopher Lam
Please file a bug, and include .qif and screenshots from Quicken to illustrate the transaction. On Sun, 27 Sep 2020 at 23:06, B Wooster wrote: > Thanks everyone, I think once I clean up my example and terminology, I'll > file a bug. > > Certainly the checking account is all fine as far as total

Re: [GNC] Report headings, can one separate the company name from the report name?

2020-09-30 Thread Christopher Lam
Please be aware that inserting raw HTML into textual fields in datafile or report options is a wart and will very likely be sanitized in the future. At best, simple formatting elements e.g. multiline into tags are already possible in some report options. The reason is it's not difficult to craft

Re: [GNC] Report headings, can one separate the company name from the report name?

2020-10-01 Thread Christopher Lam
Ideally you'd submit changes in a PR or bugzilla so that further architectural changes may be debated. For illustration on further work, try this fix in html-style-info.scm: it'll sanitize most/all strings, but many old reports will be damaged because they use html for layout: gnucash/report/html-

Re: [GNC] withholding tax (Liz Dodd)

2020-10-02 Thread Christopher Lam
While experimenting this problem, I found it exposes a subtle behaviour/bug... I was hoping to do the following manual assignment: create a transaction with 3 splits - - asset:bank +80 - a/receivable -100 - asset:WHT +20 then right-click the transaction, assign $80 as payment for the invoice. B

Re: [GNC] withholding tax (Liz Dodd)

2020-10-02 Thread Christopher Lam
Typo in middle section: Therefore your *only *currently available steps is (IMHO): process payment as usual, for *$100 *only. This creates a regular transaction: - asset:bank +100 - a/receivable -100 (to clear the invoice) On Fri, 2 Oct 2020 at 15:26, Christopher Lam wrote: > Wh

Re: [GNC] Customer Listing Report and Receivable Aging Report Error

2020-10-02 Thread Christopher Lam
Hi, there have been some changes in the reports to fix errors. It is possible that other errors may have crept in. Please submit screenshots, suitably anonymised, in Bugzilla. On Sat, 3 Oct 2020, 5:31 am Bob Jenkins, wrote: > I recently updated from version 3.9 to 4.2. Version 4.2 seems to have

  1   2   3   4   5   6   >