Re: [GNC] About bookkeeping and claiming non-currency expenses.

2020-04-17 Thread Christopher Lam
On Fri, 17 Apr 2020 at 15:53, Rich Shepard wrote: > What I do for non-cash donations (to Goodwill, for example) is enter the > value in an expense account called 'Donations - non-cash'. You could have > expense accounts for milage and volunteer time if appropriate. (I have run > my consultancy

[GNC] About bookkeeping and claiming non-currency expenses.

2020-04-17 Thread Christopher Lam
This question is for the resident accountants and bookkeeping. As we know if our book has *complete and* *perfect* information, the reports make accountant very happy. But there are numerous tax deductions allowed, that don't necessarily belong in the book. For example: - claiming mileage in

Re: [GNC] UK. Value added tax.

2020-04-12 Thread Christopher Lam
llow purchases to be recorded in any account; for now purchases must be expense accounts. On Wed, 20 Nov 2019 at 21:25, Maf. King wrote: > I have used this bridge product twice now, with experimental CSV report > directly output by GC > > https://www.chm-software.co.uk/ > > Christ

Re: [GNC] Strange reconciliation behavior

2020-04-12 Thread Christopher Lam
As others have reported, this change was *meant* to be more strict in interpretation of reconcile *statement_date* (which eventually becomes the split's *reconciled date*). My suspicion is that your first successful reconciliation used an incorrect *statement_date* which led to the second

Re: [GNC] QIF Importer does not work

2020-04-12 Thread Christopher Lam
This would need a bug report. The QIF importer isn't very good at logging errors, and would some hacking to log errors. On Thu, 9 Apr 2020 at 22:41, wrote: > Hi, > > > > I'm using > > https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-git-3.9-5 > -gbedc9631f+.setup.exe >

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread Christopher Lam
David please check out https://bugs.gnucash.org/show_bug.cgi?id=797678. The importer *can* be taught to not overwrite existing data. There are win32 builds; do try a master release. More features are upcoming, and all need beta testing. On Sun, 12 Apr 2020, 10:21 pm D. via gnucash-user, wrote:

Re: [GNC] How to change "Unrealized Gain/Loss" to "Readlized Gain/Loss" in Balance Sheet ?

2020-04-09 Thread Christopher Lam
I suggest you read https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html -- this is not hard accounting but simply rigorous mathematics. The author studied this using GnuCash so you'll be in good shape to understand the challenges of unrealized gains. On Thu, 9 Apr 2020 at 13:41, Long

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

2020-04-08 Thread Christopher Lam
Your HST seems very similar to UK VAT or GST in use in many other countries. You may use Tax Tables to set them up. And search the documentation & wiki on how to report the HST on Sales and Purchases and their quarterly differences. On Wed, 8 Apr 2020 at 18:57, Patrick Farrell wrote: > Is there

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam
Yes, you can do that. File import prices from CSV. On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, wrote: > I can get a CSV file of daily exchange rate data. Is there a way of > importing it into the price database? > > On 7 April 2020 7:17:54 pm Christopher Lam > wrote: > >&g

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam
The only report which is capable of using closest-to-date conversion is the Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD) accounts, using a Report Currency of AUD. It will choose the USD/AUD price from the price editor list closest to each transaction's posting date.

Re: [GNC] Gnucash 3.9

2020-04-05 Thread Christopher Lam
Apologies for this bug. If you are able please modify eguile-utilities.scm within the GnuCash.app and modify the following line: From: ((_ x . _) x) To: ((_ x . y) x) On Sat, 4 Apr 2020 at 14:39, Christopher Lam wrote: > Please file a bug on bugs.gnucash.org > Meanwhile the (Experi

Re: [GNC] Badly formed URL

2020-04-04 Thread Christopher Lam
, use words. > > > On Saturday, April 4, 2020, 9:50:19 AM MDT, Christopher Lam < > christopher@gmail.com> wrote: > > > The aging report cannot handle payments unattached to a customer or > vendor. Try the experimental aging report instead. > > On Sat, 4

Re: [GNC] Badly formed URL

2020-04-04 Thread Christopher Lam
The aging report cannot handle payments unattached to a customer or vendor. Try the experimental aging report instead. On Sat, 4 Apr 2020, 11:17 pm Bruce Irving via gnucash-user, < gnucash-user@gnucash.org> wrote: > > The above is a screenshot of Receivables Aging. The Company name was > blank.

Re: [GNC] Error in Income and GST statement

2020-04-04 Thread Christopher Lam
This is known and unfortunately cannot be fixed yet. It's planned for 4.0 due in a few months. On Sat, 4 Apr 2020, 11:37 pm finf...@gmail.com, wrote: > When you have purchase of a fixed asset, you miss the tax and purchase > amount in the report. > > It looks like this report does does not

Re: [GNC] Gnucash 3.9

2020-04-04 Thread Christopher Lam
Please file a bug on bugs.gnucash.org Meanwhile the (Experimental) Multicolumn Balance Sheet is likely to be very capable of generating a useful report. On Sat, 4 Apr 2020 at 13:28, jjatzkowski wrote: > I just upgraded to GnuCash 3.9 on (MacOS; Catalina 10.15.3). > > Version: 3.9 > Build ID:

Re: [GNC] GnuCash 3.9 still has problems with Budget ?

2020-04-01 Thread Christopher Lam
No, the budget editor is still buggy. This is why we really need beta testers. On Thu, 2 Apr 2020, 3:38 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > I get the same thing. Looks like a bug in the Budget Report then. I’m > going to hazard that perhaps rather than budgeting a

Re: [GNC] Goods and Services Tax - GST

2020-04-01 Thread Christopher Lam
up my business. So the screenshot I > sent through shows me using personal money to pay for a cellphone charge. > Is there a better way of accounting to capture this? > > On 1/04/20 11:41 pm, Christopher Lam wrote: > > Bingo. Everything is wrong about it :) You should probably inpu

Re: [GNC] Goods and Services Tax - GST

2020-04-01 Thread Christopher Lam
ata of a typical > expense entry. Please let me know if I've entered the data in the wrong > columns. > > On 1/04/20 11:06 pm, Christopher Lam wrote: > > Please remember to cc the mailing list for all replies. > > Now we've established you are on credit-accounts, the amounts showin

Re: [GNC] Goods and Services Tax - GST

2020-04-01 Thread Christopher Lam
alues (liability or > asset), it doesn't seem to affect the top-level account sum total at all. > > On 1/04/20 10:31 pm, Christopher Lam wrote: > > Hi > > (Screenshot containing private data snipped) > > The first rule here is that support emails are always public because > ot

Re: [GNC] Goods and Services Tax - GST

2020-04-01 Thread Christopher Lam
s GST paid minus GST returns > filed. Thanks for much for your help - it's starting to do my head in! > > On 1/04/20 9:45 pm, Christopher Lam wrote: > > Maybe you can share your account structure or a data file with sample > data, > > and we can try make it work? The documentati

Re: [GNC] Goods and Services Tax - GST

2020-04-01 Thread Christopher Lam
Maybe you can share your account structure or a data file with sample data, and we can try make it work? The documentation is still behind the reporting capability. On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek, wrote: > Hi, > I'm a new user of GNUCash for my fledgling consulting business. I love

Re: [GNC] some of my reconciliations in 3.9 are completely bonkers

2020-03-31 Thread Christopher Lam
This is due to https://bugs.gnucash.org/show_bug.cgi?id=797640 This change modifies the reconciliation starting balance calculator from Account->reconciled_balance to account->reconciled_balance on statement date. The reasoning for this change is with the observation: (A) if reconciliation is

Re: [GNC] European electronic invoicing standard

2020-03-19 Thread Christopher Lam
No but contributors are very welcome. On Wed, 18 Mar 2020 at 16:44, Michael L. Wilson wrote: > Greetings, > > Might someone be able to confirm whether GnuCash is able to issue > invoices in line with the European electronic invoicing standard? > > >

Re: [GNC] General Ledger

2020-03-16 Thread Christopher Lam
If it fits your needs then yes On Tue, 17 Mar 2020, 12:47 pm Adrian Yong, wrote: > Hi Christopher, > > That means I have to generate a report for each of the accounts ie Cash in > Bank, Trade Debtors, each customer at a time ? > > Regards, > Adrian > > On Tue, 17 M

Re: [GNC] General Ledger

2020-03-16 Thread Christopher Lam
Try the customer report in the experimental menu. On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, wrote: > Hi Adrien, > > In other accounting software, the General Ledger gives the ending balances > for each of the accounts which are then posted to the Balance Sheet.. > > For example, the General

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Christopher Lam
On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > * 14:57:56 WARN qif-parse:parse-date/format: format is y-d-m > but date is [2020/2/6]. > This warning only appears during QIF imports, and shouldn't appear in regular load/save to/from SQL or XML.

Re: [GNC] General Journal Report - Error

2020-03-15 Thread Christopher Lam
A heap error is not common. Please file a bug in bugzilla, and ideally attach https://wiki.gnucash.org/wiki/Tracefile Also try "gnucash.exe --debug" too On Fri, 13 Mar 2020 at 18:49, Gilberto Reis Filho < gilberto.reis.fi...@gmail.com> wrote: > Good afternoon. > > I am trying to generate a

Re: [GNC] GNC Equity and Retained Earnings not tracking together?

2020-03-13 Thread Christopher Lam
On Wed, 11 Mar 2020, 7:42 am David Cousens, wrote: > > Do you know if GnuCash has a flag indicating whether the books have been > closed formally or is just the presence or absence of the closing > transactions used to detect this? > No such flags exist. Only the presence of Closing

Re: [GNC] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Christopher Lam
The right answer will be to submit the Transaction Report to the accountant, have him/her calculate the Retained Earnings and Shareholder Distribution for you, then you pay your shareholders via Assets:Bank/Cash -> Liability:Shareholder (and later Liability:Shareholder -> Expenses:Shareholder

Re: [GNC] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Christopher Lam
On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user < gnucash-user@gnucash.org> wrote: > I'm wondering if GNUCash is actually calculating RETAINED EARNINGS > properly. Because after issuing a distribution to shareholder the > Retaining Earning calculation increased by Net Income but did not >

Re: [GNC] Help Find Feature

2020-03-10 Thread Christopher Lam
On Tue, 10 Mar 2020 at 03:08, Gio Bacareza wrote: > PS The root of all this was the issue with gnucash importing multicurrency > transactions with CSV. Would you have any idea if other imports eg QIF can > handle multi-currency? > There's old code to handle multicurrency/stock QIF imports but

Re: [GNC] Unable to import QIF

2020-03-09 Thread Christopher Lam
Maybe retry in a few weeks when 3.9 is out. On Mon, 9 Mar 2020 at 18:49, wrote: > I have exported my Quicken data to a QIF file which I have tried to import > into GNUCash. I load the QIF file, proceed through the steps to the point > where I get to the QIF Import without error. When I click

Re: [GNC] New User - Unique Transaction Number & Dates

2020-03-02 Thread Christopher Lam
On Mon, 2 Mar 2020 at 09:20, Mardem via gnucash-user < gnucash-user@gnucash.org> wrote: > Hello guys, > The first thing that I noticed is that I cant have a unique number for each > transaction (that I will write on the hard copy i.e. invoice). This is very > strange to me being an accountant for

Re: [GNC] NEW USER: SETTING UP GNUCASH TO WORK WITH MY BANK UNDER THE UK OPEN BANKING INITIATIVE

2020-02-29 Thread Christopher Lam
Not currently possible I'm afraid. The open banking initiative has strict requirements upon the data controller (ie FinTech apps) to have safeguards, and gnucash being open source will never be able to satisfy the encryption and authentication requirements to receive a licence to access the data.

Re: [GNC] How to accurately record Use Tax

2020-02-24 Thread Christopher Lam
Thus bringing the "Future Expenses:Use Tax" and "Liabilities:Use Tax" to > zero, and raising Expenses on the proper date. "Future Expenses" has to be > a top-level account, because if we stick it into "Liabilities" then it > "Liabilities&quo

Re: [GNC] How to accurately record Use Tax

2020-02-23 Thread Christopher Lam
For your use case you could use AP accounts and bills. Let's assume your use tax is 15% to be cleared in December 2020. I'd think, during purchase 24/02/2020 Buy something, will also need to pay use tax Expense:MI Use Tax +$100 Asset:Bank -$100 and post a bill, posting date is 01/12/2020

Re: [GNC] Failed import

2020-02-20 Thread Christopher Lam
It would be great if you could try narrow down the offending transaction and submit the qif file in Bugzilla. On Fri, 21 Feb 2020, 3:29 am Ron, wrote: > I thought I had this figured out and have been importing small chunks from > Quicken. I imported 6 months twice from a credit card and it was

Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?

2020-02-19 Thread Christopher Lam
On Wed, 19 Feb 2020 at 01:49, Greg Feneis wrote: > I typically import qif and ofx files into checking or credit card accounts. > GC does a pretty good job of matching pending import transactions with > transactions that are already present. Also, I have tried to import a file > that I previously

Re: [GNC] How to enter value when budgeting? And meaning ?

2020-02-18 Thread Christopher Lam
On Wed, 19 Feb 2020, 1:00 pm Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Yes, those are correct. > > #1 You planned to spend 100, but only spent 80. Thus your financial > position is 20 better than planned. (positive) > > #2 You planned to spend 100, but actually spent 120. You

Re: [GNC] Fwd: [GNC-dev] Fwd: Failed - import of QIF files from Quicken

2020-02-18 Thread Christopher Lam
You're right that scheme code logging is useful. The scheme way is to use pk, such as (pk "qif acct map is" qif-acct-map) But often you'll find that gnc objects are opaque; you can use (gnc:pk "qif acct map is" qif-acct-map) instead. You can combine multiple objects with pk or gnc:pk (gnc:pk

Re: [GNC] Failed - import of QIF files from Quicken

2020-02-18 Thread Christopher Lam
ose bad records for you to analyze and see where the new importer has > gone bad. > > DO you think something like the above can be done? > > > > -- > *From:* Christopher Lam > *Sent:* Tuesday, February 18, 2020 12:27 AM > *To:* tomh...@hot

[GNC] Fwd: [GNC-dev] Fwd: Failed - import of QIF files from Quicken

2020-02-18 Thread Christopher Lam
Forward from devel -- Forwarded message - From: Geert Janssens Date: Tue, 18 Feb 2020, 3:48 pm Subject: Re: [GNC-dev] Fwd: [GNC] Failed - import of QIF files from Quicken To: Cc: Christopher Lam Hi Tom, We don't need your complete financial history, just the bit

Re: [GNC] Failed - import of QIF files from Quicken

2020-02-17 Thread Christopher Lam
Hello If you'll be kind to offer the QIF file in bugzilla or privately -- feel free to amend it manually first to anonymize details, it will be useful to debug. C On Mon, 17 Feb 2020 at 15:09, Tom Hatzigeorgiou wrote: > I have seen few emails on this subject. > > Please see if the below

[GNC] Fwd: about these account-summary reports...

2020-02-13 Thread Christopher Lam
'. C -- Forwarded message - From: Christopher Lam Date: Mon, 23 Jul 2018 at 04:37 Subject: about these account-summary reports... To: gnucash-de...@lists.gnucash.org I'll be aiming to replace and upgrade the following reports: - balance-sheet - income-statement

Re: [GNC] Where to charge? Ins pays us, we pay vendor. Resolved

2020-02-13 Thread Christopher Lam
This is what I would do: (I assume you're the patient attending the clinic). Say the clinic bills $200 and Medicare pays/prepays $150 ($50 co-pay). I believe the Expenses:Medical:Rebates is an expense contra-account? The GnuCash account type would still be EXPENSE, but would become more negative

Re: [GNC] Where to charge? Ins pays us, we pay vendor.

2020-02-11 Thread Christopher Lam
Search archives for "trust accounts" On Wed, 12 Feb 2020, 7:34 am Fran_3 via gnucash-user, < gnucash-user@gnucash.org> wrote: > In the case at hand...The initial expanse was medical billed and billed > to the patient.The insurance company sent the money for the medical bill to > the patient.The

Re: [GNC] Missing invoice on Income & GST Statement Report

2020-02-02 Thread Christopher Lam
R account. > > https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te > > Thank you for making time to review this anomaly. > > Cheers. > > On 02-Feb-2020, at 2:04 PM, Christopher Lam > wrote: > > This report doesn't query the A/R register. It

Re: [GNC] Missing invoice on Income & GST Statement Report

2020-02-02 Thread Christopher Lam
ve.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p > > Please let me know if you need any more information. > > Cheers. > > > On 02-Feb-2020, at 1:34 AM, Christopher Lam > wrote: > > Doesn't previous quarter end on 31/12/2019? > > On Sat, 1 Feb 2020, 10:58 pm

Re: [GNC] Missing invoice on Income & GST Statement Report

2020-02-01 Thread Christopher Lam
Doesn't previous quarter end on 31/12/2019? On Sat, 1 Feb 2020, 10:58 pm , wrote: > Hello, > > I am running 3.7 on Mac OS High Sierra 10.13.6. > > Something peculiar is happening with my datafile this month. > > See attached 2 screenshots - one from Find Invoice dialog for the date > range

Re: [GNC] Sales, Sales Taxs & Deposits

2020-01-22 Thread Christopher Lam
Try the income gst statement report On Thu, 23 Jan 2020, 8:52 am Jimmy R via gnucash-user, < gnucash-user@gnucash.org> wrote: > I've been doing bookkeeping/accounting for my business for a long time, > going > back to the old Dome Book to present day alternatives. I have been doing > trial and

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-21 Thread Christopher Lam
On Tue, 21 Jan 2020 at 15:39, Christian Lynbech wrote: > It does seem as if the balance sheet contains all the information I need, > however have I understood it correctly that one only specifies a single > date (as opposed to an interval)? In other words, does the balance sheet > always produce

Re: [GNC] Sales Tax Report

2020-01-18 Thread Christopher Lam
expert. > > Thanks a lot for the help. > > Keith > > On Jan 18, 2020, at 5:35 PM, Christopher Lam > wrote: > > You may try the "Income GST Statement" report but it may not necessarily > meet your needs. > If you wish you can file an enhancement request in b

Re: [GNC] Sales Tax Report

2020-01-18 Thread Christopher Lam
You may try the "Income GST Statement" report but it may not necessarily meet your needs. If you wish you can file an enhancement request in bugzilla. On Sat, 18 Jan 2020 at 22:27, Keith Fetterman wrote: > Is there a report in GunCash that shows sales by tax table (tax code)? I > need to file

Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'

2020-01-15 Thread Christopher Lam
The updated budget report in 3.8 aims to display the YTD budget amounts. If it does not perform well then you'll need to file a bug. On Wed, 15 Jan 2020 at 23:48, larry johnston wrote: > Peter, > > I am still running 2.6.15. I am running Windows 10. Phil's report still > runs well in Wndows 10.

Re: [GNC] AR problems

2020-01-14 Thread Christopher Lam
On Tue, 14 Jan 2020 at 22:03, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Customer Overview *does* show a balance, though maybe not by default. > There is a down arrow with a drop-down menu to the far right of the header. > From there you can select visible columns, where you

Re: [GNC] Question about new 5 fundamental budget categories

2020-01-07 Thread Christopher Lam
Your contribution very welcome in https://bugs.gnucash.org/show_bug.cgi?id=797551 On Tue, 7 Jan 2020 at 07:09, Caleb Begly wrote: > In the changelog for 3.8, it says: > > [gnc-budget-view.c] totals - 5 fundamental types > previous showed income/expense/transfers/totals budget totals, of

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Christopher Lam
On Tue, 7 Jan 2020, 9:18 am Bill Dika, wrote: > > This is what I am looking for. Thank you. The "Options" dialog is a little > off (to get an income comparison of the two years being January 1, 2018 to > December 31, 2019, I must put in a start date of January 1, 2018 > (intuitive) but to get

Re: [GNC] Opening Balance on Reports

2020-01-06 Thread Christopher Lam
Good news; future releases where "Running Balance" is enabled, and the sorting/grouping options include account, *will* now print the balance brought forward. Zero-amount transaction hack isn't needed anymore. On Mon, 6 Jan 2020 at 05:01, Christopher Lam wrote: > Wouldn't seem r

Re: [GNC] Error running Advanced Portfolio report

2020-01-05 Thread Christopher Lam
This was bug 792800. On Mon, 6 Jan 2020, 10:31 am Dino Carubia via gnucash-user, < gnucash-user@gnucash.org> wrote: > Nevermind... figured it out. Found a transaction from 2011 that was the > culprit. This issue did not happen in older 2.x versions of GNUCash where > transaction was entered,

Re: [GNC] Opening Balance on Reports

2020-01-05 Thread Christopher Lam
Monteleone, < adrien.montele...@lusfiber.net> wrote: > Bummer. > > Regards, > Adrien > > > On Jan 5, 2020 w2d5, at 5:35 PM, Christopher Lam < > christopher@gmail.com> wrote: > > > > A disable-zer

Re: [GNC] Opening Balance on Reports

2020-01-05 Thread Christopher Lam
A disable-zero option does not feature in the transaction report though. On Mon, 6 Jan 2020, 6:15 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > There is a setting to show zero amounts. If you uncheck it, then it should > be blank. (though for the entire report, not that one

Re: [GNC] Opening Balance on Reports

2020-01-03 Thread Christopher Lam
Doable... On Fri, 3 Jan 2020 at 11:56, Christopher Lam wrote: > This is a nice hack. > > It would be even a nicer hack that the transaction report automatically > inserts the balance brought forward on the same row as the account name. I > suspect this is doable. > > On Fri

Re: [GNC] Opening Balance on Reports

2020-01-03 Thread Christopher Lam
mount carried forward. See attached example (our club financial > year runs from 1st August to 31st July). > > David > > On Thu, 2 Jan 2020, 23:17 Michael or Penny Novack, < > stepbystepf...@comcast.net> wrote: > > > On 1/2/2020 5:33 PM, Christopher Lam wrote: >

Re: [GNC] v3.8: Budget "total" field

2020-01-02 Thread Christopher Lam
https://lists.gnucash.org/pipermail/gnucash-user/2019-October/087700.html Yes an unfortunate minor regression while fixing a severe bug, because until now I could not understand why the totals section included budget equity values. On Fri, 3 Jan 2020 at 01:15, Adrien Monteleone via gnucash-user

Re: [GNC] v3.8: Budget "total" field

2020-01-02 Thread Christopher Lam via gnucash-user
https://bugs.gnucash.org/show_bug.cgi?id=797551 On Thu, 2 Jan 2020 at 21:45, Greg W wrote: > In the most recent release this change was made: > > [gnc-budget-view.c] totals - 5 fundamental types > previous showed income/expense/transfers/totals budget totals, of uncertain > meaning. now shows

Re: [GNC] Opening Balance on Reports

2020-01-02 Thread Christopher Lam
If it's a single-creditor liability account, you could try adding the Display/Running Balance. However it doesn't quite give you the 'balance brought forward' prior to the first printed transaction. On Thu, 2 Jan 2020 at 19:55, Paul Kroitor wrote: > Hello, and happy New Year to all of you using

Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers

2019-12-29 Thread Christopher Lam
Patches welcome in the documentation. Meanwhile you can open the html chart in firefox, File>Save as...>Webpage, complete and export the whole html+javascript for archival. On Sun, 29 Dec 2019 at 21:19, boldstripe wrote: > I think the user needs to know: > > 1. that the HTML Chart is platform

Re: [GNC] Unexpected currency change in a report

2019-12-28 Thread Christopher Lam
Hello Thank you for report. This is a known behaviour in some reports. Would you mind filing bugs describing the offending report (and options)? On Sat, 28 Dec 2019 at 17:04, boldstripe wrote: > Unexpected currency change in a report between two copies of Gnucash on > different machines > > >

Re: [GNC] Credits

2019-12-22 Thread Christopher Lam
FWIW the 'Credit Limit' customer property seems to be currently unused. On Thu, 19 Dec 2019 at 12:16, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I would suspect the ‘credit limit’ feature in the new customer dialog is > there to flag a warning when you are posting invoices to

Re: [GNC] Budget Questions and Observations

2019-12-12 Thread Christopher Lam
First, what is your global Reverse Balanced preference (Edit / Preference / Accounts / Reversed Balance)? On Thu, 12 Dec 2019 at 07:07, Tommy Trussell wrote: > Does anyone use the Budget features in GnuCash? I have been giving it a try > and am finding some aspects quite puzzling. I have never

Re: [GNC] Small business accounting importing transactions

2019-11-27 Thread Christopher Lam
debit from the strip holding account and a > credit to the checking (as sort of a transfer) > > Did any of that make any sense or should I go get another cup of coffee? > > > > > Christopher Lam wrote > > The proper way would be to include stripe's cut as part of e

Re: [GNC] Small business accounting importing transactions

2019-11-27 Thread Christopher Lam
The proper way would be to include stripe's cut as part of each sales transaction. Income:Sales -$100 Expense:Stripe Fees +$1.50 Asset:Bank +$98.50 The easy way would be to count each sale net of stripe's fees, and the accountant would use stripe's statements to determine gross sales and

Re: [GNC] How to create Report on Checking & Exclude one Entity ?

2019-11-21 Thread Christopher Lam
The good news is negate search (both simple substring and regex) will be available on transaction-report based reports for 3.8 onwards due early January. Or you could try a recent build on https://code.gnucash.org/builds/win32/maint/ -- these should have a bunch of recent fixes, and no known

Re: [GNC] Journaling taxable benefit

2019-11-15 Thread Christopher Lam
It's a regular asset account. On Fri, 15 Nov 2019, 11:17 gn00b, wrote: > My employer gives employees $350 under a wellness spending account to spend > on whatever we want. I claim it on public transit fares. This $350 is > considered a taxable benefit and every bi-weekly paycheck, $13.46 gets >

Re: [GNC] Problem entering splits

2019-11-09 Thread Christopher Lam
This is likely https://bugs.gnucash.org/show_bug.cgi?id=797416 which was fixed in code https://github.com/Gnucash/gnucash/commit/ee260d8e On Sat, 9 Nov 2019 at 23:59, Al Heynneman wrote: > Hello, > > I've got a new gnucash problem that I've never seen before. Maybe you > can help? > > When

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Oops. The regex filter is a late addition from 2017. Unfortunately regex negate string match (I.e. match not containing a string) is a general weakness of POSIX regex. May I suggest file an enhancement request in Bugzilla? On Sat, 9 Nov 2019, 23:38 Christopher Lam, wrote: > Hi Fran > &g

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Hi Fran You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report. You may be aware that the transaction report was, for many years, the most versatile report to extract information from a Gnucash data file. It had severe limitations and bugs and On Sat, 9

Re: [GNC] Problem with Saved Report

2019-11-09 Thread Christopher Lam
Looking through the account depth seeing, if your custom report uses the account-depth option in options-utilities, it has never shown any number other than level 5. It may be useful to submit the custom report in Bugzilla for a review. On Thu, 7 Nov 2019, 02:12 David T. via gnucash-user, <

Re: [GNC] Export values to Excel

2019-11-03 Thread Christopher Lam
in the gnucash account called Output Vat on the date 31st October > > 2019. > > > > Is there a way to do this? > > > > Hi, > > yes, there is. I did it last week. You're basically talking about MTD > (Making Tax Difficult) aren't you? > > Chr

Re: [GNC] How should I enter values on a budget in gnucash ?

2019-11-03 Thread Christopher Lam
On Sat, 2 Nov 2019 at 11:33, Jim Passmore wrote: > TL;DR--Summary lines are good, but poorly named. keep them. > > Regarding the summary lines, as already said Income and Expense totals are > self-explanatory. I'll try to explain a use-case for the other lines. > > First of all, let's ignore

Re: [GNC] should I upgrade from 2.6.15 for windows

2019-10-31 Thread Christopher Lam
YTD budget will definitely be affected because it's unmaintained and old. The good news is the conventional budget report will have similar functionality called "use accumulated amounts". On Fri, 1 Nov 2019, 06:56 larry johnston, wrote: > Hi, > > Just to followup. > > If 2.6.15 is working for

Re: [GNC] How should I enter values on a budget in gnucash ?

2019-10-29 Thread Christopher Lam
On Tue, 22 Oct 2019 at 15:32, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > “Transfers” = sum of amounts budgeted to Assets, Equity, or Liabilities > “Total” = Income - Expenses - Transfers > I understand the meaning of budgeted income/expense, maybe the meaning of budgeted

Re: [GNC] How should I enter values on a budget in gnucash ?

2019-10-22 Thread Christopher Lam
d "Total" ? On Sun, 20 Oct 2019 at 16:25, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > That is what I use. I prefer that negative signs only show up to reflect > contra balances, which is either good or bad per account as intended. > > Regards, > Adrien >

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Christopher Lam
(component Reports). On Mon, 21 Oct 2019 at 22:00, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Where should I post it? A bug report? > > > On Oct 21, 2019 w43d294, at 4:48 PM, Christopher Lam < > christopher@gmail.com> wrote: > > > &g

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Christopher Lam
On Mon, 21 Oct 2019 at 20:12, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Trial Balance took 21 seconds. (I didn’t use a stop watch, I just > watched my desktop clock tick by, so not very scientific, but enough of a > spread to be an issue) > > Both tally everything from all

Re: [GNC] How should I enter values on a budget in gnucash ?

2019-10-20 Thread Christopher Lam
Hi Edward and others. For a few weeks I've been reviewing the budget module. It's true that the budget *editor* prematurely reverses the signs of amounts, handling period amounts (i.e. changes in amounts in a period) assuming sign-reversals is set as credit-accounts. The advantage is positive

Re: [GNC] Understanding Transaction Report options

2019-10-13 Thread Christopher Lam
> Christopher, thank you. Let me ensure I understand. > and 2. When Account tab filter is set to "Include," and > Asset:Bank:Current, Filter-Type: Include to/from, Filter-By: > Expenses:School:Fees --> will show only school > fees. > Comment: "Include" appears to me to work similarly to the

Re: [GNC] Understanding Transaction Report options

2019-10-12 Thread Christopher Lam
Hello On Sat, 12 Oct 2019 at 15:38, wrote: > 1. Account tab: What does the “Include transactions to/from Filter > Accounts” (and “Exclude”) mean? The documentation uses those same words to > describe their function. > > 2. Account tab: I understand the Account tree selection under “Accounts”

Re: [GNC] Charts with Multiple Currency

2019-10-11 Thread Christopher Lam
asset > On 2019/10/06 14:14, Christopher Lam wrote: > > Hello, nice to hear users using multiple currencies in reports. Most > reports were designed to run converting all currencies into a "target" > currency. It would be useful to know exactly what report options you are > using, a

Re: [GNC] GnuCash 3.7 and Portfolio Report

2019-10-06 Thread Christopher Lam
Hello If you're using flatpak your portfolio.scm is probably located in another folder. I am sorry I don't know where exactly. Does anyone know if there is a flatpak nightly available? On Sun, 6 Oct 2019 at 13:02, NOSTOP wrote: > Hello John. > > I'm on ver 3.7, Flatpak, Linux Mint 18.3 > > My

Re: [GNC] 3.7 - Budget reports - accumulated accounts - can "envelope budgeting" logic be implemented?

2019-10-06 Thread Christopher Lam
This is a nice idea. Please file enhancement request on bugzilla (component Reports), attaching a sample datafile, current report, and desired report. For various reasons this would appear in 4.x onwards only. C On Fri, 4 Oct 2019 at 09:43, Antonio07 wrote: > Hi > > In version 3.7 accumulated

Re: [GNC] Charts with Multiple Currency

2019-10-05 Thread Christopher Lam
Hello, nice to hear users using multiple currencies in reports. Most reports were designed to run converting all currencies into a "target" currency. It would be useful to know exactly what report options you are using, and exactly what you're trying to achieve. On Sun, 6 Oct 2019, 12:56 risokei,

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

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 -

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

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-reports/portfolio.scm > @

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

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

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

<    1   2   3   4   5   6   >