[GNC] Enhancement Request - Filter Reports

2025-07-31 Thread flywire
A couple of years ago extensive transaction report filter proposals were made that were ultimately not adopted. I'd like request the following specific proposals: 1. Enable all transactions/splits to be shown with appropriate heading(s), including those excluded by the Filter Options 2. E

[GNC] Proposal to Redesign the GnuCash Website with Wordpress

2025-06-12 Thread flywire
This is the XY problem. A solution to the perceived poor GnuCash Website is not tied to Wordpress. It is hard for others to imagine what is in your mind; a mock-up would be much clearer. eg: https://flywire.github.io/gnucash-modern-mockup/ from https://www.perplexity.ai/search/prepare-a-mock-up-fo

Re: [GNC] How to find the transaction entered one minute ago

2025-06-02 Thread flywire
> *From the register, View > Sort by... > Date of Entry. It'll be the newest *one. Good question and good answer. Finding a transaction with a messed up date can be frustrating. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscr

[GNC] How to find the transaction entered one minute ago

2025-06-02 Thread flywire
> Can you find a report that shows you all transactions in all accounts (one account after another) .THAT is what I would call a "General Ledger Report" I'd call it a transaction report. ___ gnucash-user mailing list gnucash-user@gnucash.org To update yo

[GNC] Percentage Report

2025-05-21 Thread flywire
> *I need to monitor the evolution of my investments* *Why would you try to do that in a cashbook instead of the myriad of portfolio tracking tools?* ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to uns

[GNC] Info about getting started

2025-05-21 Thread flywire
Since you didn't offer, I guess you use Windows in the USA with cash based accounting and don't track transaction taxes. 1. After you look at all the options for converting your quickbooks data to gnucash you are going to come back to the option of starting a new file in GnuCash from the

Re: [GNC] Generating Yearly Figures for Accountant/Tax Return (UK)

2025-05-14 Thread flywire
Michael, I recognised different software uses different names for similar reports. Mentioning the GnuCash Transaction Report option sorting Show subtotals only (hide transaction data) doesn't twist anything. One click in options to hide/unhide transaction detail would be really useful in OP's use c

[GNC] Generating Yearly Figures for Accountant/Tax Return (UK)

2025-05-13 Thread flywire
QuickBooks uses a Profit and Loss report for this functionality and transaction detail can be shown by running it as an Itemised Profit and Loss report. The appropriate accounts still need to be selected to display in the report though QuickBooks handles account changes better. The functionality i

[GNC] Allocate costs across residents, while “categorizing”

2025-05-08 Thread flywire
Filter Reports - https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111804.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-use

[GNC] Global replacement of the name of Payee (Description)

2025-04-20 Thread flywire
Open xlm file in a text file editor and do a search and replace all. Regards ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - P

[GNC] Vested and Un-Vested Stocks

2025-04-06 Thread flywire
Let's kick this off... Say you have an Assets:Brokerage Account:Stock:AMZN account from ( https://www.gnucash.org/docs/v5/C/gnucash-guide/invest-setup1.html#invest-setup-example2 ). Maybe use an Assets:Unvested:Stock:AMZN account and transfer them when they vest. Unvested stock may never vest so

[GNC] Help with GNU Cash

2025-03-26 Thread flywire
Seems like your preference for numbers. It would be quicker to learn by entering the transactions in https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide > Each chapter follows a simple format. A chapter begins with a “Concepts” > discussion which introduces general themes and terminology, ad

Re: [GNC] Tracking UnPaid Bills

2025-03-21 Thread flywire
I have updated https://wiki.gnucash.org/wiki/Using_GnuCash#Printing_a_Rental_Report which would be well worth someone with a sound accounting background checking. I also consider hybrid accounting is worth a mention in the Guide. Regards > ___ gnucash-u

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread flywire
On Thu, 20 Mar 2025 at 06:30, flywire wrote: > So how do you propose actually tracking unpaid bills? Recording a > transaction doesn't do it. It would normally involve specific reports run > frequently enough to manage payments due. > Hmm, no mention of any specific reports to u

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
Try the pdf file: > Rent.pdf Description: Adobe PDF document ___ 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 remember

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
The approach discussed in this thread seems workable for rental properties. Attached is a sample rent Transaction Report. The transactions are shown in Assets:Rent Owing (ie A/R) account which could be used as a tenant rent report if the Debit/Credit column labels were changed to something like Pa

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
On Wed Mar 19 16:57:40 EDT 2025 Doug wrote: > I have an issue tracking rental property income A reasonable solution to this is a fairly common issue would be a good outcome from this thread. It doesn't seem easy to report with the accounts cutting across Balance Sheet, Income and Expense, and Tra

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
On Wed Mar 19 10:07:19 EDT 2025 griffin wrote: > > The transactions are working the way they are supposed to, so thank > you everyone who contributed to this topic. So how do you propose actually tracking unpaid bills? Recording a transaction doesn't do it. It would normally involve specific repor

[GNC] Tracking UnPaid Bills

2025-03-16 Thread flywire
I understand this to be a request for Hybrid Accounting, basically a combination of Cash Accounting and Accrual Accounting. (Rental Income being the other side of the ledger tracking unpaid Invoices - Accounts Receivable). A bill you receive is a liability. From https://www.gnucash.org/docs/v5/C/g

Re: [GNC] Searching mailing lists

2025-03-04 Thread flywire
Re: https://lists.gnucash.org/search/?idxinfo=gnucash-user * Mail-Archive (GnuCash-User) - link is malformed * Mail-Archive (GnuCash-Devel) - works well Regards On Wed, 5 Mar 2025 at 02:07, Derek Atkins wrote: > I've updated the index.html with links to mail-archive for gnucash-user > and gnuca

Re: [GNC] Searching mailing lists

2025-03-04 Thread flywire
ttention to this. I actually had forgotten > about that page. > I've removed all references to nabble from the /search/index.html page. > I agree we probably need a better search mechanism, but I don't know what > it is. > > -derek > On Thu, 13 Feb 2025, flywire

[GNC] Import troubles

2025-02-24 Thread flywire
> > I have over 30 000 transactions! > even IF it were just 2% it would be impossible to do manually.. One match might cover 100's of transactions. Import your file in small batches so the match will recognise transactions in future batches. Regards ___

[GNC] Cost basis adjustment

2025-02-21 Thread flywire
I do enough of these to avoid keyboard entry by stripping the data from the annual pdf statement. eg: * from https://github.com/flywire/ETF-Annual-Statement/blob/main/Tax/VAS-annual-tax-statement-2018.pdf * to https://github.com/flywire/ETF-Annual-Statement?tab=readme-ov-file#sample-output I dump

Re: [GNC] Searching mailing lists

2025-02-14 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2025-February/115508.html Derek Atkins wrote: > > I tend to only upgrade the distro every couple years. "If it > aint broke" So THAT is why code is still running such an old distro. That is not the reality. It is an old platform with issues w

[GNC] Searching mailing lists

2025-02-12 Thread flywire
https://lists.gnucash.org/search/?idxinfo=gnucash-user is useless and should be replaced with https://www.mail-archive.com/gnucash-user@gnucash.org/maillist.html before updating the wiki. Bo Buckley wrote https://lists.gnucash.org/pipermail/gnucash-user/2025-February/115450.html : In the docs: ht

[GNC] confusion on new fields in csv import

2025-02-08 Thread flywire
Read the posts around: https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112480.html The only sure way is to try Amount and if that doesn't work use Amount (negated). Regards ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

[GNC] Issues Importing CSVs

2025-02-04 Thread flywire
> > It should be possible to use the GnuCash Export multiline format for both > export and import but the debits and credits will be reversed and the > account names will be different in the two sets of books. > For issue A I would think it would be possible to process the CSV file 1. No need, du

[GNC] Simple report(s) wanted

2025-01-21 Thread flywire
Nice question for a basic and most common need. > You need two reports and the standard report versions will likely do what you require: Balance Sheet, Income Statement > You might be able to get both [current/previous period] Balance Sheet on one page with the multi report section. I have not tr

Re: [GNC] Feature Request: Add Support for Functional Currency Amount in Transactions

2025-01-05 Thread flywire
So Kevin, you also appreciate the limitation of those powerful features. The suggestion of using PriceDB as the transaction conversion rate is as disingenuous as using the closing price for share transactions. In my view your issue is entering transaction data through the register form. Prepare tr

[GNC] Importing Accounts

2024-09-22 Thread flywire
TLDR; Create a new file choosing one of the template accounts to use as a basis to export account tree as csv then modify as required. The GnuCash csv conventions don't apply to the coa csv file. Specifically: 1. It must have a header line 2. iirc all fields must be included even though most of t

Re: [GNC] Australian Mutual Funds

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html John Ralls wrote: > ... Posts with links can be opened directly if there is clear space around the link. Would commodity Wheat be Type Stock? While this is raised in the context of Managed Funds https://www.gnucash.org

Re: [GNC] Project and Design Documentation

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html John Ralls wrote: > ... Posts with links can be opened directly if there is clear space around the link. Would commodity Wheat be Type Stock? While this is raised in the context of Managed Funds https://www.gnucash.org

Re: [GNC] Project and Design Documentation

2024-09-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-September/112961.html sunfish62 wrote: > As I understand it, the developers focus on entries in bugzilla ( bugs.gnucash.org) to address problems and proposals. It is better advice to suggest that users with specific suggestions for improvement s

[GNC] Australian Mutual Funds

2024-09-20 Thread flywire
> an Australian Mutual Fund... It is a combination Fund with a primary focus on Property. Mutual fund is a very American term. Can you give an example fund? I assume you are referring to a managed fund that is not directly traded on the ASX, unlike an ETF (Exchange Traded Fund). Regards

[GNC] Project and Design Documentation

2024-09-07 Thread flywire
I've seen https://wiki.gnucash.org/wiki/Project_and_Design_Documentation raised a bit in the gnucash-user mail list recently and I recall Geert's comments about updating the csv importer and not documenting it. That wiki hasn't effectively been updated for a decade with the meaningful part written

[GNC] New top-level accounts

2024-09-07 Thread flywire
You need the QuickBooks class feature, it works, I've been using it for years. GnuCash doesn't have classes but you can use Filter Reports to filter characters (tags) on split memo, transaction notes, or transaction description. The problem with this is the report will only match the filter. https

[GNC] Detailed Search

2024-09-07 Thread flywire
Sounds like https://wiki.gnucash.org/wiki/Using_GnuCash#Printing_a_Rental_Report ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user

Re: [GNC] Financial Statements

2024-09-07 Thread flywire
1. Which report will display Balance Sheet splits for each share, particularly for Shares, Retained Earnings, and Unrealised Gains? Transaction report has shares by security type rather than value, and Advanced Portfolio doesn't split CostBase or Retained Earnings. 2.How do you get a Balance Sheet

[GNC] Fwd: Projects/classes for transactions

2024-09-06 Thread flywire
nucash-custom-reports/blob/main/README.md S L O W L Y including the introduction description and be guided by the filter examples. Regards -- Forwarded message - From: BANO notIT Date: Sat, 7 Sept 2024 at 00:38 Subject: Re: Projects/classes for transactions To: flywire Cc: Gnucash U

[GNC] Projects/classes for transactions

2024-09-05 Thread flywire
> I am wondering if there's any possibility to assign projects to transactions. Yes, certainly. There have been a couple of answers but have a look at https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111804.html Regards ___ gnucash-user mailing

Re: [GNC] Financial Statements

2024-09-05 Thread flywire
Thank you Chris, that's really nice. I've verified it all. My concern about compromising account integrity isn't an issue, and all from csv imports (once securities created). To recap: 1. Income Distribution Report: Include Income:Distribution without the subaccounts 2. Tax Component Rep

Re: [GNC] Financial Statements

2024-09-05 Thread flywire
Chris, I've missed the point. Can you run that report? I've attached the files (GnuCash V 5.8). This crosstab is effectively a 30/06/2018 trial balance with the $62.21 CostBase rolled into the Asset account: Full Account Name Sum - Value Asset:Shares:VAS 501,918.69

[GNC] GnuCash modifications

2024-09-03 Thread flywire
The responses to noobs can be brutal. There is no restriction on the number of people with read access to GnuCash but only one person can have write access at one time. I've had no problems using a similar application in a workgroup of a dozen people, including people preparing data for batch entr

Re: [GNC] Financial Statements

2024-09-02 Thread flywire
Chris Grinton https://lists.gnucash.org/pipermail/gnucash-user/2024-September/112855.html writes: > ... Thank's Chris. Unfortunately that doesn't resolve the issue. Although more direct this still passes the Asset:Bank transaction to Income:Distribution and Asset:Shares:Costbase so Income:Distrib

Re: [GNC] Financial Statements

2024-09-01 Thread flywire
Is there a better way to handle CostBase? Lets try the transactions again (keeping lines to 75 characters): Bank:SavingsTypically 2-4 payments23,053.38 Income:Distribution -23,053.38 Asset:Shares:CostBase

[GNC] Financial Statements

2024-09-01 Thread flywire
nnual tax statement: https://github.com/flywire/ETF-Annual-Statement/blob/main/Tax/VAS-annual-tax-statement-2018.pdf Transactions: Bank:Savings Typically 2-4 payments 23,053.38 Income:Distribution -23,053.38 Asset:Shares:CostBase -62.21 Income:Distribution 23,053.

[GNC] Is this a legit part of the bug process, or is it spam?

2024-07-31 Thread flywire
Thanks, that explains the JIRA messages I received after commenting on a bug. I deleted them and forwarded all JIRA messages to spam. I just had a look and it keeps generating them. Regards ___ gnucash-user mailing list gnucash-user@gnucash.org To update

[GNC] Check & Repair

2024-07-21 Thread flywire
Report a bug eg https://bugs.gnucash.org/show_bug.cgi?id=797711 ___ 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 remember

Re: [GNC] Sales items, Service items, Inventory items

2024-07-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112486.html > Assume a retail business. I don't. I don't know what GnuCash was initially modeled on but it is very close to an old Quickbooks +/- a few features. eg in Quickbooks from memory: Income:Sheep:Lambs $2500 (with GST turned on

Re: [GNC] Example of importing Stock transactions from CSV

2024-07-20 Thread flywire
This post is from the https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112463.html thread with discussion moving in a different direction. https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112470.html Greg Julius wrote: > FWIW, I really struggled with this to figure out what w

Re: [GNC] GnuCash getting worse?

2024-07-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112481.html > For CSV import “Deposit” and “Withdrawal” were no less ambiguous than “Amount” and “Amount (negated)”. The meanings are different, Amount does not indicate direction whereas Deposit/Withdrawal is clearly Add/Remove. > The fo

[GNC] Sales items, Service items, Inventory items

2024-07-20 Thread flywire
GnuCash does have an inventory system but it has been increasingly customised to stock (shares not livestock). Inventory (businesses refer to it as stock) is a standard part of most business taxation systems and It has little to do with point of sale. Four posts into the https://lists.gnucash.org/

[GNC] GnuCash getting worse?

2024-07-19 Thread flywire
I've noticed csv parser user interface problems reported since it was remodelled to include things like Namespace and Amount(negated). Even if users can't understand the labels or documentation and have to resort to trial and error the processes should still work. https://lists.gnucash.org/piperma

[GNC] Delete acct + move txns - can't specify acct

2024-06-03 Thread flywire
> Next ... to learn how to help revise/expand this page- https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html ... to capture what I've learned here. https://wiki.gnucash.org/wiki/Documentation_Improvement Fairly daunting for many. It might be simpler to just contribute suggested modified

[GNC] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread flywire
> I make money personally, I own a couple of properties, and I also design and manufacture audio devices. These are basically different entities... I doubt it. If they are all reported as part of the one tax return they are enterprises rather than entities. Entity finances are normally kept separa

[GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-25 Thread flywire
Just use a sub account of the bank account for credits and debits. If you have more complex reporting then use filter reports - https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111804.html Regards > ___ gnucash-user mailing list gnucash-user@gn

[GNC] Newbie Questions

2024-05-25 Thread flywire
Welcome to GnuCash. I use an old version of QuickBooks for Business Cash Accounting, and I also use GnuCash. Transaction data is not available from QuickBooks in iif format. The best you can do is print reports containing transaction data but it's not worth the effort. Again, welcome to GnuCash wh

[GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-12 Thread flywire
https://github.com/Gnucash/gnucash/releases describes the release changes but your question is obviously about understanding the practical impact from a user's perspective. I note lots of Gremlins reported in the mailing list about V5. https://lists.gnucash.org/pipermail/gnucash-user/2024-April/11

Re: [GNC] Help request starting out with Gnucash

2024-05-05 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111808.html > Does [Debits and Credits] make more sense now? Yes, well put. That perspective would be worth reworking as a brief information pane in the Guide. > ___ gnucash-user mailing list gnu

Re: [GNC] Help request starting out with Gnucash

2024-05-04 Thread flywire
David, the guide even warns that accounting debits and credits are used contrary to the way most people understand them. The average punter will be wrong, and if they get it right the next punter will likely bet they are wrong. https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111801.html

[GNC] Filter Reports

2024-05-04 Thread flywire
Reporting other than by a normal COA structure has always and continues to be in demand. The latest dev decision seems to be: https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1585771847 > ...if we take out the language about multidimensional analysis and... tags > and do it as a report o

[GNC] Help request starting out with Gnucash

2024-05-04 Thread flywire
> > You need to get a grasp of double entry bookkeeping concepts... I agree but I wouldn't focus on the formal meaning of Credit/Debit, even if you understand it most people have the wrong understanding - https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106929.html - and following the thr

[GNC] The equivalent for Quicken Tag

2024-04-28 Thread flywire
Use the custom transaction report at https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.or

[GNC] Recommend Accounting Books

2024-04-21 Thread flywire
A significant limitation for small business is GnuCash will not do cash accounting *and* automated sales tax. https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111635.html Christopher Lam wrote: > Please be aware that the inventory part won't be handled via GnuCash: while > you can reco

[GNC] Merge amounts in report

2024-04-20 Thread flywire
Tag the transactions and report on tagged transactions. ___ 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 remember to CC t

Re: [GNC] What account name do you use to record the apartment/house expenses related to the building?

2024-04-17 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111588.html Michael or Penny Novack wrote: > I don't think you are picturing what I meant by both ways. Yes, it is very clear but given my experience with other financial software I don't agree endlessly dividing the COAs into unknown f

[GNC] What account name do you use to record the apartment/house expenses related to the building?

2024-04-16 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111576.html Michael or Penny Novack wrote: > d) What you can;t do is have it both ways. Traditional double entry > bookkeeping allows only one tree structure for the CoA. To get it > different in different reports you would have to BOTH s

[GNC] New user looking for some reporting help

2024-04-02 Thread flywire
GnuCash reports are much more basic than QuickBooks but should be adequate and there is no sample dataset available for testing the system. If you use classes have a look at https://github.com/dawansv/gnucash-custom-reports The big advantage is you have import/export access to your data and it dum

[GNC] Last day of month

2024-03-24 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2024-March/111217.html Fred Tydeman wrote: > Is there a way to force reports (such as Assets over time) to show values > on the last day of the month (instead of the first day of the month)? Try GnuCash V4 ___

Re: [GNC] gnucash suggestions

2024-03-19 Thread flywire
Just simplifying the field/attribute names with terms like Item and Type would help more generalised inventory use without detracting from current functionality. Jargon like Namespace has no place in the user interface. ___ gnucash-user mailing list gnuca

[GNC] gnucash suggestions

2024-03-18 Thread flywire
>* I created a "FUND" with the symbol "Miles" abbreviated "M," and I created a* >* Liability account called Mileage, whose currency is Miles, with a contra* >* liability account called "Driving Owed," whose currency is Dollars.* The GnuCash inventory interface is very ordinary comparing the attach

Re: [GNC] Multiple Fiscal Years

2024-03-04 Thread flywire
te of the option system in > C++ so the hack can't be applied any more. But I think it's unnecessary since changing the accounting period in > preferences to e.g. 1 July 2023 - 30 June 2024 accompanies [sic] the same > thing... https://lists.gnucash.org/pipermail/gnucash-us

[GNC] split transaction description field length limit

2024-03-04 Thread flywire
You don't need long text lines to allocate splits to rental properties. Have a look at Custom GnuCash 5.x Transaction Report with Tags - https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107048.html ___ gnucash-user mailing list gnucash-user@gnuca

Re: [GNC] Multiple Fiscal Years

2024-03-02 Thread flywire
On Sat, 2 Mar 2024 at 17:26, Geoff wrote: > Maybe I am missing something here Absolutely. Say the height of a sporting team member was given as 2.2m high. Was the measurement correct? Who knows! You can use relative values to assess the credibility of a number. Given two other members measured

[GNC] Share Records When Receivers Appointed

2024-03-01 Thread flywire
How should shares be recorded in GnuCash once receivers are appointed? Shares are no longer being traded but the ASX quote feed returns the price last traded. There seems to be a realistic (management) value and a tax value. The realistic share value is zero but I understand the tax value is the p

Re: [GNC] Multiple Fiscal Years

2024-03-01 Thread flywire
Follow the links through to the code - cur-year and cal-year. The hack supports: this, last and 2 years prior fiscal years which is about what you want preparing tax reports. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscripti

[GNC] Multiple Fiscal Years

2024-03-01 Thread flywire
With Gnucash V5 current year with a configurable day/month/year was removed and hard-coded as calendar year. Alternatives: 1. Run a GnuCash portable app version since settings are held in the app folder - https://sourceforge.net/projects/portableapps/files/GnuCash%20Portable/ 2. The e

[GNC] Australian Accountants familiar with GNUCash

2023-10-25 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109255.html Alan Hopkins wrote: > I know an accountant who has, for at least one business, accepted printed P&L & Balance Sheet from a 2002 version of Quickbooks together with end of year bank statements - he has never wanted to get the

Re: [GNC] I need basic help

2023-10-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109184.html Edwin Booth wrote: > I need to wrap my head around the whole “debit/credit” concept. No you don't but you do need to understand the concept of account types and moving money between them. I've studied economics at Uni, evalu

[GNC] I need basic help

2023-10-19 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109173.html David Cousens wrote: > I would suggest you read at least the introductory sections of the GnuCash Tutorial and Concepts guide under the heading Basics https://www.gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide I doubt many

Re: [GNC] Importing stock prices from a CSV file

2023-10-02 Thread flywire
While importing csv files is only really explained in the manual https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv (not the guide) in terms of transactions, there is a lot of supporting information for the Price Import Assistant in https://www.gnucash.org/docs/v5/C

Re: [GNC] Importing stock prices from a CSV file

2023-10-01 Thread flywire
Can we focus this back on improving the clarity of the Price Import Assistant? The first page is essentially the full documentation of the process. https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55 uses the column labels: Date, Amount, From Namespa

Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread flywire
Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. _

Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread flywire
The process works but the Price Import Assistant Summary description and poor user interface labels are confusing. I use csv import all the time but this is so bad I can't understand it. [the minimum columns] are Date, Amount, From Namespace, From Symbol and Currency To. If all entries are for the

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread flywire
I'll work with the Price Import Assistant druid. Is it actually documented? I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to un

[GNC] Importing stock prices from a CSV file

2023-09-29 Thread flywire
I have loaded my stock portfolio into GnuCash for tax reporting purposes. I'd like to update stock prices annually by importing the closing value for 30 June from a csv. Can someone give me a rundown on the required input and process? I'd be happy to add it to https://wiki.gnucash.org/wiki/Using_Gn

Re: [GNC] Have code run when a new invoice is posted.

2023-09-25 Thread flywire
JC writes : > If using QuickBooks in which you can assign a transaction to a > vendor/customer, I don't have to create invoices and bills just for the > sake of tracking the payment sources and targets. Yeah, the GnuCash business workflow seems a crazy complicated manual process coming from Quic

[GNC] Have code run when a new invoice is posted.

2023-09-24 Thread flywire
and https://github.com/flywire/ETF-Annual-Statement from tax statements, both for csv import. Given Python bindings are not available in a binary they are really a fake feature and https://piecash.readthedocs.io is not genuine GnuCash so you'd have to get support fr

Re: [GNC] Using GC for Property Management

2023-09-22 Thread flywire
Also, https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107567.html would probably readily adapt for commission. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gn

[GNC] Using GC for Property Management

2023-09-22 Thread flywire
* https://wiki.gnucash.org/wiki/Using_GnuCash#Printing_a_Rental_Report * https://github.com/dawansv/gnucash-custom-reports JC wrote: > I really wished that GC would have the option to link Vendor/Customer to a > transaction without creating a bill or invoice. Any future development > plans for t

[GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread flywire
The first two sections of the GnuCash Guide https://www.gnucash.org/viewdoc.phtml?doc=guide are a tutorial to introduce accounting and the application respectively. The whole concept of reconciling a cheque account is very dated in a time when countries move to abandon cash, but it covers the basi

[GNC] Transaction Splits for Australian ETF Annual Statements

2023-09-09 Thread flywire
I got sick typing into a spreadsheet so I got the app to extract the data directly from the pdf to create the transaction splits: https://github.com/flywire/ETF-Annual-Statement One line of code will compile it into a Windows *.exe to avoid python if anyone wants it. There is a start on a gui

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread flywire
> it's already available as a custom report which I will maintain for the time being: https://github.com/dawansv/gnucash-custom-reports On Mon, 14 Aug 2023 at 09:57, flywire wrote: > A classic case for a single file with tags: > https://github.com/Gnucash/gnucash/pull/1623 >

[GNC] Consolidation of family member accounts

2023-08-13 Thread flywire
A classic case for a single file with tags: https://github.com/Gnucash/gnucash/pull/1623 It works but it is not part of standard GnuCash. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: ht

[GNC] Will GNU CASH work on a Chromebook

2023-08-10 Thread flywire
Try https://github.com/joshuabach/gnucash-web ___ 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 remember to CC this list o

Re: [GNC] Addition to basis

2023-08-09 Thread flywire
On Tue, Aug 8, 2023 at 8:24 PM David Carlson https://lists.gnucash.org/mailman/listinfo/gnucash-user>> wrote: >* IIRC There is a description in chapter 9 of the Tutorial.* https://www.gnucash.org/docs/v5/C/gnucash-guide/invest-retofcap.html ___ gnucash-

[GNC] Addition to basis

2023-08-08 Thread flywire
On Tue, August 8, 2023 4:12 pm, Fred Tydeman wrote: > How does one record an Addition to basis for a stock? Good question. I only got my head around this recently (eg https://github.com/flywire/ETF-Annual-Statement uses ASX:VAS - Vanguard Australian Shares). Entity,Date,Description,Acco

[GNC] GnuCash preferred OS - Windows or Linux

2023-08-01 Thread flywire
?? Importing Bank Statements works fine and saves the data entry issues. Certainly, other means are required to verify the data. A duplicate insurance payment was identified straight away after importing a bank statement for tax reporting. ___ gnucash-use

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-26 Thread flywire
On Wed, 26 Jul 2023 at 13:31, john wrote: > Yeah, it's gotten a lot faster since... > GnuCash V5.2 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listi

[GNC] Accounts which are both Income and Expense accounts

2023-07-24 Thread flywire
Another example recently discussed in https://wiki.gnucash.org/wiki/User_talk:Christopherlam Businesses aim to make money and GST is charged on that income so it follows GST is a liability. Liability:GST:GST on Sales (ie tax collected) and Liability:GST:GST on Purchases (ie tax paid) shows the net

  1   2   3   4   >