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 dif

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 > https://lists.gnu

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] 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] 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, < gnucash-user@gnucas

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 Sheet

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 likel

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 stateme

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 d

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

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 it

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 Options

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 las

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

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

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 flo

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 gain

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

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 perso

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 col

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

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 a

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 chim

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

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 approac

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

2021-01-21 Thread Christopher Lam
> > 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: > > Multicurren

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-22 Thread Christopher Lam
ounting (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. > > Star

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

2021-01-22 Thread Christopher Lam
he new place. > > 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 w

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 bot

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 pay

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 tha

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 invok

[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 'pa

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

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 thi

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 toward

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

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

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 (sub-accoun

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 is

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 accou

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] 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] 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] Gnucash Close Books option

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

[GNC] New price source

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

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

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

Re: [GNC] UK. Value added tax.

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

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

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

Re: [GNC] 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] Transferring mutual funds

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

Re: [GNC] Transferring mutual funds

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

Re: [GNC] Upgrading to 5.3 from 2.6.15

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

Re: [GNC] Budgeting glitch after upgrading to 4.14

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

Re: [GNC] Using GnuCash as an Accounting Tutor

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

Re: [GNC] GnuCash 5.4 Repackaged

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

Re: [GNC] I need basic help

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

Re: [GNC] 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] Reconciliation with a strange opening balance

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

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

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

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

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

Re: [GNC] 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] Feature request: Import assistant, room for big improvements

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

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

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

Re: [GNC] See what payments apply to which bills

2019-08-06 Thread Christopher Lam
Depending how confident you are with building from source, or backing up and restoring your code files, you can help design the next gen owner report at https://github.com/Gnucash/Gnucash/pull/535/ On Wed., 7 Aug. 2019, 07:26 lebyarules via gnucash-user, < gnucash-user@gnucash.org> wrote: > Just

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Christopher Lam
Hi Geert Wish to add a small contribution: On Wed., 7 Aug. 2019, 15:43 Geert Janssens, wrote: > > For the other importers, this isn't implemented. The idea is that you > typically import from bank statements in qif/ofx/csv format and banks > don't > have reconcilation information. The other acou

Re: [GNC] QIF Import Problem

2019-08-07 Thread Christopher Lam
For completion, Colin sent me 2 QIF files from 2 different bank accounts. Some lines indicated transfer from 1st QIF acct to 2nd QIF acct. The solution is tedious. Importing QIF acct will require careful mapping of QIF account/category, and when importing the 2nd QIF account, the importer *will* *

Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-08 Thread Christopher Lam
>From my understanding, the account-type is mainly used in reports. Otherwise you're right, you can tweak any account-type at leisure within limits eg can't change currency-type account to stock-type account; subaccounts of Asset/Liability/Income/Expense are limited according to the parent-type. e

Re: [GNC] Transaction Report Sign Reverses

2019-08-11 Thread Christopher Lam
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_does_the_Transaction_Report_.27Sign_Reversal.27_setting_not_work_on_subtotals This issue could be fixed if the scenario addressed in this FAQ can be resolved. I don't really know how to handle that particular case. On Mon., 12 Aug. 2019, 13:02 David T. via

Re: [GNC] First Day of the Week

2019-08-12 Thread Christopher Lam
On Tue., 13 Aug. 2019, 11:12 John Morris, wrote: > I set this up with a simple transaction report by setting the date range > to run from the "start of previous month" to "today". I then set the > primary sort key to "Date" and the primary subtotal for date key to > "Weekly". If there is a way t

Re: [GNC] Transaction Report Sign Reverses

2019-08-12 Thread Christopher Lam
Maybe I'm being thick here, but it's still not easy. We need to start with the knowledge that *internally* income amounts are negative -- after all they usually balance with positive asset amounts. Also, liability amounts are also internally negative, but no one seems to have a problem with that.

Re: [GNC] Bookkeeping for a club's charity account - use business features?

2019-08-26 Thread Christopher Lam
This "pledged income" tracking looks eerily similar to the budgeting aka "virtual transactions" that I was floating about some time ago... On Tue., 27 Aug. 2019, 00:29 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > > > On Aug 26, 2019 w35d238, at 3:43 AM, Michael Hendry < > hendry.

Re: [GNC] Find Invoice display issue

2019-08-30 Thread Christopher Lam
Agreed. 3.7 will behave better on this regard. On Thu, 29 Aug 2019 at 20:32, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Looks like a bug. I haven’t had to search for invoices in many moons so I > can’t say when this first appeared. > > I don’t see any reason the criteria portion

Re: [GNC] Thank you

2019-09-03 Thread Christopher Lam
Doug VAT/GST is handled for nearly 2 years now -- see section 2.7 onwards https://wiki.gnucash.org/wiki/Alternate_Australian_GST_setup https://wiki.gnucash.org/wiki/FAQ#Tax_Handling:_Goods_and_Service_Tax_.28GST.29_or_Value_Added_Tax_.28VAT.29 and a more capable "Income&GST Statement" to report Aus

Re: [GNC] Thank you

2019-09-04 Thread Christopher Lam
FWIW in the 4.x series it is planned to allow a book-specific accounting-period, so, one can select (e.g. 30-June for Australia, 5-April for UK, or another arbitrary date) an eofy date, and reports should be able to pick 'current-FY' or 'previous-FY' as report dates... On Wed, 4 Sep 2019 at 13:56,

Re: [GNC] GnuCash 3.7 and Weekly Reports

2019-09-09 Thread Christopher Lam
Only the transaction report is expected to use the new locale-sensitive start-of-week feature. It is tested working on Linux, and is known to be not yet locale sensitive on windows. On Tue, 10 Sep 2019, 00:58 John Morris, wrote: > Hi Adrien, > Thank you for looking into this issue. The transac

Re: [GNC] Invoice report error

2019-09-13 Thread Christopher Lam
This is not an invoice-report. This is either customer, vendor or job report. There must be something unusual in the AP/AR account selection in the General tab in options. Or there may be something from a previous installation which must be cleared properly. On Sat, 14 Sep 2019 at 05:32, michielu

Re: [GNC] Badly formed URL unknown-type

2019-09-17 Thread Christopher Lam
The rest of us haven't seen any screenshot attached to the original email 🙂 On Tue, 17 Sep 2019, 17:13 Geert Janssens, wrote: > You picture and extra details are very helpful. > > I can see now this is another bug still. > > It appears you have managed to create an outstanding balance somehow >

Re: [GNC] Badly formed URL unknown-type

2019-09-17 Thread Christopher Lam
I can replicate this type of error. Open AP/AR account, manually enter a transfer to asset/liability account, right click->assign as payment to a new vendor/customer, don't choose any document, click ok. I think that does it. On Wed, 18 Sep 2019, 00:46 Uttam Chakravorty, wrote: > I'm at a loss.

Re: [GNC] Invoice report error

2019-09-19 Thread Christopher Lam
running into consistent segfaults with my local builds on > Ubuntu 16.04, so it is kinda frustrating to work with. > > Regards, > > Michiel > > Op 14 sep. 2019 7:48 a.m. schreef Christopher Lam < > christopher@gmail.com>: > > This is not an invoice-report.

Re: [GNC] gnuCash 3.7 portfolio report

2019-09-21 Thread Christopher Lam
Perhaps the https://wiki.gnucash.org/wiki/Tracefile would be useful? On Sat, 21 Sep 2019 at 18:09, Ed Fields wrote: > will not get past this error screen > > *Report error* > > *An error occurred while running the report* > > I have selected populated accounts via ed|report options and reloaded

Re: [GNC] gnuCash 3.7 portfolio report

2019-09-24 Thread Christopher Lam
There's an error in portfolio.scm -- modify the 'report-currency' to 'currency' and it should be fine modified gnucash/report/standard-reports/portfolio.scm @@ -196,7 +196,7 @@ (if (not (null? accounts)) (let* ((commodity-list (gnc:accounts-get-commodities

Re: [GNC] Import bug? no account matching options

2019-09-25 Thread Christopher Lam
It'll be very useful to file on bugs.gnucash.org attaching a small anonymized qif file. On Thu, 26 Sep 2019, 03:47 Grant, wrote: > I'm trying to import transactions I've downloaded from Chase in a QIF > file but when I'm importing Gnucash doesn't give me any options to > match them to an account

Re: [GNC] Can not insert text on transaction after import QIF

2019-09-26 Thread Christopher Lam
This is unfortunate. Perhaps you could anonymize a sample qif file which fails and attach into a bug report ? It's plain text, so easy to modify. On Thu, 26 Sep 2019, 17:06 dmeece, wrote: > After a huge effort to install Gnucash 3.7 on a Win 10 machine and then on > a > production build (no erro

Re: [GNC] Can not insert text on transaction after import QIF

2019-09-26 Thread Christopher Lam
Also there seems to be confusion. CSV files and QIF files are quite different, and both have dedicated importers. Both may slow with large numbers of transactions to import, hence it's always safer to import in chunks. Which ones are not functioning? On Thu, 26 Sep 2019 at 09:06, dmeece wrote: >

Re: [GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

2019-09-30 Thread Christopher Lam
There's currently no easy mechanism to marry up the links from invoice->partial payments, and payment->multiple invoices. We hope to complete an upgrade to the customer report but this will need much testing before it's ready. You are very welcome to help beta test... https://user-images.githubuse

Re: [GNC] How to run report on Paid Sales for a period? (Cash Accounting Method)

2019-10-01 Thread Christopher Lam
Try transaction report, originating from a/receivable account, filtered to bank account only. Business reports typically prefer to use invoice posted dates rather than payment dates. On Tue, 1 Oct 2019, 23:17 Fran_3 via gnucash-user, wrote: > Sorry for the flurry of questions but I should be don

Re: [GNC] gnuCash 3.7 portfolio report

2019-10-01 Thread Christopher Lam
See email previously sent. Error in portfolio.scm On Tue, 24 Sep 2019, 23:03 Christopher Lam, wrote: > There's an error in portfolio.scm -- modify the 'report-currency' to > 'currency' and it should be fine > > modified gnucash/report/standard-rep

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Christopher Lam
This is a feature called balance assertions present in ledger-cli, another bookkeeping tool. GnuCash doesn't have it. However you can approximate it: https://bit.ly/2mMAKmf On Wed, 2 Oct 2019, 12:28 armanschwarz, wrote: > Suppose on July 1, 2019 I get a statement that my account balance is $100

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-02 Thread Christopher Lam
FWIW I do think it's a nice feature to have. It's not terribly difficult to implement either. Allow user to add a special entry with some metadata stating the balance should be X dollars, and if the user tries to input a transaction which will fail the balance assertion, pops a warning "Error - th

Re: [GNC] custom report freezing - work done gets lost.

2019-10-05 Thread Christopher Lam
qof-session isn't currently accessible to scheme. Why do you think you'll need to save session? It may help to publish your report on Bugzilla or devel mailing list. On Sun, 6 Oct 2019, 12:53 Steven Bruniges, wrote: > Hi. > > > > Have a custom report that appears to be freezing, so I have to ha

<    1   2   3   4   5   6   >