Re: [GNC] Charts with Multiple Currency

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] 3.7 - Budget reports - accumulated accounts - can "envelope budgeting" logic be implemented?

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 ac

Re: [GNC] GnuCash 3.7 and Portfolio Report

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 fi

Re: [GNC] Charts with Multiple Currency

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] Understanding Transaction Report options

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] Understanding Transaction Report options

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

Re: [GNC] How to set a customer "opening balance" for the Customer Report

On Wed, 16 Oct 2019 at 14:45, Stan Brown wrote: > However, I believe it's possible to accomplish the same thing by > creating a transaction of this form, dated the day before the beginning > of your first GC accounting period: > > Debit: AR:Customer 1 - Balance forward x.xx > Debit: AR:Customer 2

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

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 num

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

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 t

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

is perfect (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] How should I enter values on a budget in gnucash ?

t; and "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] How should I enter values on a budget in gnucash ?

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 asset/l

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

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 m

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

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 th

Re: [GNC] Export values to Excel

found 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? >

Re: [GNC] Export values to Excel

Use a recent build (3.7 should be fine), copy https://raw.githubusercontent.com/christopherlam/gnucash/maint-csv-export/gnucash/report/standard-reports/uk-vat-report.scm into the standard-reports folder. It should add the UK-VAT report. Please note the 4.x series should not need it; the Income-GST

Re: [GNC] Problem with Saved Report

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

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

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] How to compare 2 Transaction Reports to find orphan transactions

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] Problem entering splits

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 enter

Re: [GNC] Journaling taxable benefit

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] How to create Report on Checking & Exclude one Entity ?

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 regre

Re: [GNC] Small business accounting importing transactions

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 stripe

Re: [GNC] Small business accounting importing transactions

k, line stripe income up as a 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 st

Re: [GNC] Budget Questions and Observations

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 b

Re: [GNC] Budget Questions and Observations

ense, and that fixed the signs on the Budget. > Excellent! Thank you. > > On Thu, Dec 12, 2019 at 2:08 AM Christopher Lam > wrote: > >> First, what is your global Reverse Balanced preference (Edit / Preference >> / Accounts / Reversed Balance)? >> >> On

Re: [GNC] Credits

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 th

Re: [GNC] Unexpected currency change in a report

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

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

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 sp

Re: [GNC] Opening Balance on Reports

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] v3.8: Budget "total" field

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] Opening Balance on Reports

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

Re: [GNC] Opening Balance on Reports

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

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 fig

Re: [GNC] Opening Balance on Reports

am Adrien 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 d

Re: [GNC] Error running Advanced Portfolio report

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

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

Re: [GNC] Gnucash Reports - Comparative Income Statement

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 the

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

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 uncerta

Re: [GNC] AR problems

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] budget reports 'YTD' vs 'use accumulated amounts'

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] Sales Tax Report

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 a

Re: [GNC] Sales Tax Report

g 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

Re: [GNC] Handling of Equity and Retained Earnings

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, Sales Taxs & Deposits

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 er

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

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

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

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

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

, is my A/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 registe

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

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] Where to charge? Ins pays us, we pay vendor. Resolved

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 w

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

'show subtoals'. 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: - balan

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

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 statem

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

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

ll > those 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:* t

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

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] How to enter value when budgeting? And meaning ?

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 o

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

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

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 f

Re: [GNC] How to accurately record Use Tax

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 31/12/2

Re: [GNC] How to accurately record Use Tax

uture Expenses:Use Tax" and debits Expenses. > 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 &qu

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

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] New User - Unique Transaction Number & Dates

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] Unable to import QIF

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] Help Find Feature

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 no

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

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

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

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 Divid

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

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 Transactions

Re: [GNC] General Journal Report - Error

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 Genera

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

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 Ledger

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 Led

Re: [GNC] General Ledger

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] European electronic invoicing standard

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? > > > https://ec.europa.eu/growth/single-market/publ

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

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 pe

Re: [GNC] Goods and Services Tax - GST

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] Goods and Services Tax - GST

o IRD' > in my mind should be GST collected minus 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

Re: [GNC] Goods and Services Tax - GST

the account type to for these values (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

Re: [GNC] Goods and Services Tax - GST

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

Re: [GNC] Goods and Services Tax - GST

hases while I'm starting 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

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

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 sin

Re: [GNC] Gnucash 3.9

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

Re: [GNC] Error in Income and GST statement

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 check

Re: [GNC] Badly formed URL

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] Badly formed URL

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

Re: [GNC] Gnucash 3.9

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] Australian Foreign Investments Taxation

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

Re: [GNC] Australian Foreign Investments Taxation

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

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

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] How to change "Unrealized Gain/Loss" to "Readlized Gain/Loss" in Balance Sheet ?

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 wr

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

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] QIF Importer does not work

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] Strange reconciliation behavior

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 reconcili

Re: [GNC] UK. Value added tax.

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

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

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 doll

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

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 fr

[GNC] About Experimental Reports

Dear Users We hope the revamped reports have been useful and welcome to the community. With 4.0 round the corner, it is time to consider replacing the old reports with the experimental ones. Balance Sheet and Income Statement (Multicolumn) reports are now well tested, and can replace the previou

Re: [GNC] Order listing in account by "Transfer"? Select and modify multiple?

Use the Transaction Report. On Mon, 27 Apr 2020 at 03:40, flywire wrote: > By first transfer account. If you open the transfer account register it > would list all accounts it received transactions (including splits) from. > > I'd be happy with filter. > _

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

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 reason why there isn't an > option in GC itself? It's a very popular way of doi

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

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 users w

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

; On 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 particul

Re: [GNC] Reporting transactions

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 u

<    1   2   3   4   5   6   >