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

Re: [GNC] About 'parent-account-subtotal' option.

2021-02-13 Thread Christopher Lam
To clarify: The subtotal options are: Parent account balances ( Account Balance / Subtotal / Do not show) Parent account sub-totals (Show subtotals / Do not show / Text-book style (experimental)) The first one describes subtotals *before* an account group -- see [1] below. Options will cause

Re: [GNC] About 'parent-account-subtotal' option.

2021-02-12 Thread Christopher Lam
Of course, no reason to remove the 'do not show' option. On Sat, 13 Feb 2021 at 03:25, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The 'Do not show' option will still be available correct? > > > Regards, > Adrien > > On 2/12/21 8:41 PM, Christopher

[GNC] About 'parent-account-subtotal' option.

2021-02-12 Thread Christopher Lam
To long-time and new users, Regarding subtotals in several reports e.g. Asset $0 Asset:Bank $8,000 Asset:House $100,000 Total Asset $108,000 >From 2003 onwards, there was a 'parent account subtotals' option 'text book style (experimental)' to show subtotal after groups of accounts. It mimics

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-11 Thread Christopher Lam
You normally specify the name when Saving a report. What name did you use? On Fri, 12 Feb 2021, 12:36 am Elmar, wrote: > Running "/usr/bin/flatpak run --branch=stable --arch=x86_64 > --command=gnucash --file-forwarding org.gnucash.GnuCash > --logto=$HOME/gnucash.trace" in a terminal window

Re: [GNC] flatpak 4.4 reports anomaly

2021-02-10 Thread Christopher Lam
Scheme backtraces are usually found at https://wiki.gnucash.org/wiki/Tracefile but if flatpak hides them somewhere obscure you can dump onto console via "gnucash --logto=stdout". See https://wiki.gnucash.org/wiki/Logging On Thu, 11 Feb 2021, 6:29 am Elmar, wrote: > The sequence of events was

Re: [GNC] Help adding withholding tax and VAT in seperate fileds of the invoice.

2021-01-29 Thread Christopher Lam
A final note relating to recording the withholding tax as liability: it will artificially decrease your net worth by the cumulative tax amount. On Thu, 28 Jan 2021, 12:29 am Nikos Parafestas, wrote: > Thank you Derek for your answer. > In my case I am not accountable whether or not my client

Re: [GNC] The man who saw everything twice....

2021-01-24 Thread Christopher Lam
> Why do Gnucash balance sheets print account and subaccount totals twice: once at the beginning of each such account and again at the end? Because you'd selected Subtotal on both options as you described. This is a long-standing wart/bug because it's nonsensical to allow subtotals to be shown

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
gt; Lastly, simple portfolio accounting (e.g. crypto currencies) if they are > bought in different countries. > > I am curious what the potential mines are so I can try to avoid them. > > Lukas > > > > On 2021-01-21 20:20, Christopher Lam wrote: > > Mult

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
ng (e.g. crypto currencies) if they are > bought in different countries. > > I am curious what the potential mines are so I can try to avoid them. > > Lukas > > > > On 2021-01-21 20:20, Christopher Lam wrote: > > Multicurrency is a major minefield. > > Start fro

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Christopher Lam
You could use the stock split assistant to record the stock split (cannot record stock split using the register only), then use the security editor to rename the stock. Someone else may have better ideas. On Fri, 22 Jan 2021, 3:59 pm Peter Lamb via gnucash-user, < gnucash-user@gnucash.org> wrote:

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Christopher Lam
gt; > Lastly, simple portfolio accounting (e.g. crypto currencies) if they are > bought in different countries. > > I am curious what the potential mines are so I can try to avoid them. > > Lukas > > > > On 2021-01-21 20:20, Christopher Lam wrote: > > Multicurrenc

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Christopher Lam
Multicurrency is a major minefield. Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html and finish with https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the background on trading accounts. >From discussion with accountant, it would seem that the safest

Re: [GNC] UK specific: MTD - Making Tax Digital

2021-01-17 Thread Christopher Lam
But the CSV export already exists. See the "Income and GST Statement" report which is definitely tailored for VAT/GST calculations for UK and Australia but can be used for any similar tax regimes, and has a dedicated CSV export facility. If your bridging software has particular requirements for

Re: [GNC] Styles of different items in GNUcash reports

2021-01-13 Thread Christopher Lam
Check the style sheets on the edit menu. On Wed, 13 Jan 2021, 5:41 pm mummins heitzel, wrote: >I am trying to fix an issue with the formatting of different items in a >simple journal or general ledger. > >What I am trying to achieve is to format the primary sorting key in >BOLD,

Re: [GNC] Best way to upgrade from an old version (2.6.14) to current

2021-01-08 Thread Christopher Lam
A last note: during upgrades, check the trace file for possibly important logs. These are overwritten, hence upgrade messages can disappear easily. https://wiki.gnucash.org/wiki/Tracefile On Sat, 9 Jan 2021, 9:58 am Tfastle via gnucash-user, < gnucash-user@gnucash.org> wrote: > Well, I must

Re: [GNC] Shortcut to Custom Reports query

2021-01-07 Thread Christopher Lam
The shortcut key combo is: Alt-R S if your locale is English-US. On Thu, 7 Jan 2021 at 09:51, Roberts Klotiņš wrote: > Hi, > I often use "Saved Report Configurations", but I find menu click-through > access rather cumbersome. Is there a shortcut key combination for that, or > has someone found

Re: [GNC] Income statement with transactions

2020-12-26 Thread Christopher Lam
You're nearly there. In the Transaction Report, you'll want to: 1) sort by account code instead of account name, and ensure all accounts have appropriate code. eg. Revenue accounts code "I-01" and Expense accounts "X-01" 2) sorting/show full account name is enabled. HTH On Thu, 24 Dec 2020 at

Re: [GNC] multi col income report

2020-12-20 Thread Christopher Lam
The usual recommendation to export reports as HTML and import from Excel still applies. To format date differently, review your global preferences found in Edit > Preferences > Numbers, Date and Time On Sun, 20 Dec 2020 at 22:41, Ian D Henry wrote: > I have been using the experimental multi

Re: [GNC] barcode & invoices

2020-12-15 Thread Christopher Lam
Liz there's https://en.m.wikipedia.org/wiki/EPC_QR_code and someone could write a QR code plugin connector for use by the invoice report. On Wed, 16 Dec 2020, 5:40 am Liz Dodd, wrote: > On Tue, 15 Dec 2020 21:54:50 +0100 > Saša Janiška wrote: > > > Hello, > > > > I'm using GC to track our

Re: [GNC] bulk operations?

2020-12-07 Thread Christopher Lam
But it's crucial to input the exchange rate - and IIUC you are encouraged to use https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly On Mon, 7 Dec 2020 at 22:47, Samantha Payn wrote: > > Thanks for the suggestion, Adrien. I’ve got entering the invoice data into >

Re: [GNC] Income in foreign currency - unrealized vs realized gains / losses How To

2020-11-27 Thread Christopher Lam
Agreed. https://www.ato.gov.au/Individuals/Income-and-deductions/In-detail/Income/Converting-foreign-income-to-Australian-dollars/ Either convert *all* amounts into home currency AUD, or show original currencies (and any conversion) to an accountant who will apply the correct fx rate and any

Re: [GNC] Create Chart to Forecast Future Cash Flow

2020-11-23 Thread Christopher Lam
The the Balance Forecast report in the Asset menu. On Mon, 23 Nov 2020 at 17:49, Chris Gifford wrote: > Hello all, > > I am relatively new to Linux computing and new to GNU Cash and > considering to move from Microsoft Money. However, Microsoft Money has > the capability to graph future cash

Re: [GNC] Apparent Miscalculation

2020-11-16 Thread Christopher Lam
Because it's what it was written to do. Try the closest direct price first if one exists. If not try with 1 intermediate currency. If not, it fails. https://github.com/Gnucash/gnucash/blob/maint/libgnucash/engine/gnc-pricedb.c#L2576 On Mon, 16 Nov 2020 at 10:55, Eric Coates via gnucash-user <

Re: [GNC] Budget screen Grand Total

2020-11-14 Thread Christopher Lam
You'll need to upgrade to 4.2 -- see the flatpak releases. On Sun, 15 Nov 2020, 9:54 am Andrew, wrote: > Hi All > > I have just rolled from Ubuntu 18.04 to 20.04 and note a difference in > the GNUCash app versions making it more difficult to for me to manage my > expenses. > > Current Ubuntu 20

Re: [GNC] Gnucash 4.2 QIF download issue

2020-11-07 Thread Christopher Lam
Would you please file a bug on bugs.gnucash.org ideally with a small full qif file On Sat, 7 Nov 2020, 5:42 am Roderick Averill, wrote: > Version 4.2 problem: When I import a qif file from my bank, it imports the > "+" transaction amounts (deposit), but not the "-" transaction amounts (EFT >

Re: [GNC] Looking for Upgrade Tips

2020-11-01 Thread Christopher Lam
Safest approach would be to upgrade 2.4 -> 2.6.21 -> 3.11 -> 4.x and of course backups before each step. On Sun, 1 Nov 2020 at 22:11, TanyaMc70 wrote: > I currently have v. 2.4.13 and am needing to upgrade to get export and > reporting options. I have researched on the site, wiki, and archives.

Re: [GNC] Bizarre happenings

2020-11-01 Thread Christopher Lam
This may happen if there's a report options window hidden behind the main Gnucash window. On Sun, 1 Nov 2020 at 18:39, alessandra derniat <4san...@live.com> wrote: > My copy of gnucash is acting strange and will not let me access any > options for reports. I’m stuck with the options I had the

Re: [GNC] How to turn off report/chart animations in 4.x?

2020-10-28 Thread Christopher Lam
Chartjs animation uses its own options mechanism to disable animation. The animation will be removed in 4.3 onwards. There's no plan to introduce an option to reenable animation. On Thu, 29 Oct 2020, 8:17 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Perhaps try setting

Re: [GNC] Simple reporting help

2020-10-27 Thread Christopher Lam
The experimental multicolumn reports have a "show report options" or something in the general tab, which will assist troubleshooting. On Tue, 27 Oct 2020, 8:26 pm Michelle, wrote: > I did try. Had to get the flatpak version 4.2 as Mint is too far behind > that I couldn't easily "make" it, but

Re: [GNC] 4.2 on Windows 10 keeps randomly crashing

2020-10-21 Thread Christopher Lam
Is there a comma in the pasted amount? You'll want to remove it. https://bugs.gnucash.org/show_bug.cgi?id=797959 On Wed, 21 Oct 2020 at 15:21, mike823 wrote: > My new installation of 4.2 on Windows 10 keeps randomly crashing. Maybe 10 > times in the last two weeks. Version 3 was extremely

Re: [GNC] v4.2 exchange rates' decimal places

2020-10-16 Thread Christopher Lam
Please file bug in Bugzilla and some screenshots. On Sat, 17 Oct 2020, 12:39 pm Phil Diacono, wrote: > Hi team, > > I have a multi-currency setup so when I run reports (Balance Sheet, > Profit and Loss, Trial Balance) I click on options -> commodities -> and > tick "Show Foreign Currencies" and

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
-activities/technical-resources-search/2015/march/frs102-foreign-currency-translation.html On Fri, 16 Oct 2020, 4:10 am Christopher Lam, wrote: > As I understand, for personal tax most would offer the original currency > income statements to the accountant; the latter would convert to local >

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
As I understand, for personal tax most would offer the original currency income statements to the accountant; the latter would convert to local currency using an exchange rate from legislated sources. To achieve this using the formal reports you'd ensure there is price data USD/ILS on the report

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
The only report with ability to exchange currency amounts using price on posting date is the Transaction Report. On Thu, 15 Oct 2020, 5:40 pm Gal Bar Mashiah, wrote: > I have expense accounts in several currencies, for example: > Expenses:Food:USD > Expenses:Food:ILS > > I run the income

Re: [GNC] Issues with Balance Sheet report in 4.2

2020-10-12 Thread Christopher Lam
The old venerable balance sheet (and many "classic" reports) are not exactly well behaved when a subset of accounts, especially of varying levels, is selected for reporting. The experimental and eguile reports may behave better. Unless someone steps up and decodes the classic reports, this is

Re: [GNC] Issues with Balance Sheet report in 4.2

2020-10-11 Thread Christopher Lam
Always easier to post screenshots, with appropriately placed smudges. Also post screenshots of the report options. On Sun, 11 Oct 2020 at 23:15, mike823 wrote: > I definitely do not understand what you are trying to say. > > - Are talking about "Balance Sheet (eguile)" report or "Balance

Re: [GNC] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

2020-10-09 Thread Christopher Lam
I'd think that invoices are much more useful than bills. Because I send invoices and want to track being paid; as a customer I send (usually future dated) payments on time (or dispute them) and don't need to remind myself. On Sat, 10 Oct 2020, 7:20 am Fran_3 via gnucash-user, <

Re: [GNC] Account view question

2020-10-08 Thread Christopher Lam
Easiest process would be to generate a daily-resolution table, then post-process in spreadsheet. e.g. from Asset/Liability/Income/Expense Chart General/Start date: start of this month General/End date: today General/Step size: day Display/Show table: enabled Run report This generates a chart and

Re: [GNC] Fwd: Changing report title of the General,Journal; was: Solving printer issues

2020-10-07 Thread Christopher Lam
Usually https://bugs.gnucash.org/ would be the preferred reporting mechanism, but this one will be fixed for 4.3 onwards. On Tue, 6 Oct 2020 at 18:37, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > Might have gotten to actually look at the problem if had been described > clearer.

Re: [GNC] Changing report title of the General,Journal; was: Solving printer issues

2020-10-06 Thread Christopher Lam
The General Journal was an oddball among reports for ages. https://idioms.thefreedictionary.com/%27twas+ever+thus On Mon, 5 Oct 2020 at 21:05, Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Chris, you know this part better. > > Anita, are you not subscribed to >

Re: [GNC] Invoice Payment

2020-10-05 Thread Christopher Lam
This one's slightly different because both payments must be used to clear invoices from 2 separate entities. The best method here is to use a suspense account. On Mon, 5 Oct 2020, 4:28 pm Liz, wrote: > On Mon, 5 Oct 2020 09:12:07 +0200 > Oliver Arnold wrote: > > > I have a customer with two

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

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] 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.

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:

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] $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] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

2020-09-26 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] How to balance correctly a particular transaction which involves debt?

2020-09-22 Thread Christopher Lam
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 Shop for frie

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

2020-09-21 Thread Christopher Lam
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. > > > > Spending/lending money: &g

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,

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

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

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

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. Then created 2 >

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

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

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

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] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Christopher Lam
y 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 Aug 2, 2020,

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

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

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

Re: [GNC] Adjusted Trial Balance

2020-07-21 Thread Christopher Lam
t account 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 additi

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

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 &

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

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

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

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.

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

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 >

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

2020-06-29 Thread Christopher Lam
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 < > c

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

Re: [GNC] Question marks instead of currency in reports

2020-06-18 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:

Re: [GNC] GnuCash 3.905 Released

2020-06-15 Thread Christopher Lam
A couple of notes: - Balance-sheet is reverted back to the legacy report: multicolumn balance-sheet had a few more bugs identified related to currency conversions, so, isn't ready yet. The latter is downgraded back to experimental submenu. - gnucash-cli --report run --name "VAT Report"

Re: [GNC] Default View: Tip

2020-06-10 Thread Christopher Lam
The full list of free-text fields available to use are: per-Transaction: Num, Description per-Split: Action, Memo The book property 'Use Split Action Field For Number' will internally swap Num & Action IIUC. The main purpose was originally likely to mimic Quicken behaviour. Quicken (DOS) is

Re: [GNC] Transaction Report Filter Questions

2020-05-21 Thread Christopher Lam
Until 4.x is ready, yes you'll have to use this syntax. On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, < gnucash-user@gnucash.org> wrote: > Transaction Filter seems to be case sensitive as searching for "Chevron" > will not find "CHEVRON" so you must use regx like >

Re: [GNC] Is there a better way enter multi-currency split transaction?

2020-05-17 Thread Christopher Lam
Bugzilla will be a better forum to discuss issues with the multicolumn P report: bugs.gnucash.org On Mon, 18 May 2020, 7:31 am davygc, wrote: > Just want to share what I will do as I don't think there will be a solution > soon. > > I will create a sub-account for each currency under all my

Re: [GNC] Cash Flow with Split Transaction

2020-05-16 Thread Christopher Lam
Hi, The cashflow report is not wrong and not right either. See https://bugs.gnucash.org/show_bug.cgi?id=797093 for the full dev understanding. C On Sat, 16 May 2020 at 20:45, Matthew Clay wrote: > Gnucash Community, > > I have a question about the "Cash Flow" report. When I set up a simple

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Christopher Lam
The Transaction Report will convert a split amount to the nearest price if required. I think the OP is reporting issues with the TXF report. On Wed, 13 May 2020 at 03:44, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Transaction Report doesn’t offer this option. (not sure

Re: [GNC] RegEx Case insensitive Search via Reports > Transaction Report > Transaction Filter ?

2020-05-09 Thread Christopher Lam
You'll need to use [Gg][Oo][Dd][Aa][Dd][Dd][Yy] On Sat, 9 May 2020 at 16:06, Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > When using Reports > Transaction Report > I want to use the Transaction Filter to do a case insensitive search for > some word like, for instance ... godaddy

Re: [GNC] Import matcher shortcomings, OFX realm (at least)

2020-05-06 Thread Christopher Lam
6, 2020 8:09:03 PM Christopher Lam > wrote: > > > Are you discussing qif or ofx. The main difficulty is qif code written 20 > > years ago and has not modernised. > > > > The multi to multi issue will always be very difficult, hence I'd > > previously imagined a t

Re: [GNC] Import matcher shortcomings, OFX realm (at least)

2020-05-06 Thread Christopher Lam
Are you discussing qif or ofx. The main difficulty is qif code written 20 years ago and has not modernised. The multi to multi issue will always be very difficult, hence I'd previously imagined a two pane register, qif/ofx on left, existing register on right, and drag and drop to marry up the

Re: [GNC] QIF file import still doesn't work with Gnucash 3.10

2020-05-06 Thread Christopher Lam
These issues would benefit from bugzilla reports, ideally with anonymised data. On Wed, 6 May 2020 at 11:07, Fross, Michael wrote: > I have to keep importing the same QFX file over and over until I get > “nothing to import” message. If I don’t, it seems to miss transactions in > the file. Not

Re: [GNC] Payroll Report

2020-05-03 Thread Christopher Lam
Your major design challenge is to decide how and why you'll link these completely separate transactions together. It does not seem necessary to use business features (AP/AR) for them. So, you have no internal links to marry up the 4 transactions. However these are (hopefully) regular transactions

Re: [GNC] Reporting transactions

2020-05-01 Thread Christopher Lam
GnuCash and naive in economics. I just find it > interesting, learning new concepts as part of learning GnuCash. > > On Fri, 1 May 2020 at 10:41, Christopher Lam > wrote: > >> I wouldn't classify sipp contributions as expense. You'd be incorrectly >> reducing your net worth whe

Re: [GNC] Reporting transactions

2020-05-01 Thread Christopher Lam
I wouldn't classify sipp contributions as expense. You'd be incorrectly reducing your net worth whenever you contribute to it. On Fri, 1 May 2020, 5:23 pm Ruaraidh Sackville Hamilton, < ruaraidh...@gmail.com> wrote: > Ah yes you are right! I didn't think of the case where an employer pays >

Re: [GNC] Reporting transactions

2020-04-30 Thread Christopher Lam
On Thu, 30 Apr 2020 at 14:15, Ruaraidh Sackville Hamilton < ruaraidh...@gmail.com> wrote: > In my reply I replaced your "Income:Me" with "Assets:my bank account". The > point is that, when the SIPP is in the same GC file as my other assets, the > transaction is from one asset (the bank account I

Re: [GNC] notify when new version is available?

2020-04-27 Thread Christopher Lam
27/04/2020 4:18 pm, Christopher Lam wrote: > > because AFAIK this app which handles your personal data never accesses the > outside internet, otherwise many users will yell. > > On Mon, 27 Apr 2020 at 06:09, Ed Love wrote: > >> For some reason, no. Is there any particular

Re: [GNC] notify when new version is available?

2020-04-27 Thread Christopher Lam
oops. the Get-Quotes and AQBanking modules do access the outside world, but these are "external" modules. On Mon, 27 Apr 2020 at 06:18, Christopher Lam wrote: > because AFAIK this app which handles your personal data never accesses the > outside internet, otherwise many

<    1   2   3   4   5   6   >