[GNC] Cash Accounting with Automated GST

2021-09-15 Thread flywire
TLDR; Automate GST for cash accounting by preprocessing transactions to enrich with GST and import as a multisplit file GST effectively doubles the number of transactions so you'll want automated gst calculations. Automated gst has been arbitrarily restricted to business finances in GnuCash which

[GNC] how to import a csv of transactions?

2021-07-13 Thread flywire
I've had success importing csv files with https://github.com/sdementen/piecash ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If

Re: [GNC] Help needed in Australia

2021-07-29 Thread flywire
David, good suggestion to split the task: 1. Get accounting advice on needs - how to structure business accounts and required processes 2. Select software and set it up Just because your accountant can advise you on the best accounting setup for your business doesn't necessarily mean their

[GNC] Simple Update Question

2021-08-03 Thread flywire
> *I successfully transferred from Quicken to GnuCash years ago, with no > troubles. I'm a home user, nothing complex. *>>* Is there any reason I should upgrade from Version 3.8? Are the changes mostly for business folks or are there changes that a home user would enjoy?* It's continual

[GNC] Combine user accounts

2021-07-30 Thread flywire
I posted a piecash example I wrote to create a book from csv: https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html One of the good things about piecash is it's scripted so you get the same result every time without any wayward keystrokes, It only takes a few minutes to install

Re: [GNC] Help needed in Australia

2021-07-28 Thread flywire
That's my understanding of accrual accounting. The GnuCash Tutorial and Concepts Guide, Part III, Business Features explains how it works, includes a tutorial. Discussed in a recent thread: https://lists.gnucash.org/pipermail/gnucash-user/2021-June/096943.html continuing

[GNC] Import CSV account names matching problems

2021-10-10 Thread flywire
Stephan, you're right, you can't. Try python - https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html Email me directly if you want support. Splits are a bit different. ___ gnucash-user mailing list gnucash-user@gnucash.org To update

[GNC] Default Accounting period permanent change (Ver 4.6 still..)

2021-10-09 Thread flywire
Hack Financial / Fiscal Year in all Reports - https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097880.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Hack Financial / Fiscal Year in all Reports

2021-10-02 Thread flywire
I've been using this hack which changes the definition of current and previous year in reports to start 1 July. It will be overwritten each time a new version of GnuCash is installed and it's unlikely to work with the next major release. Find date-utilities.scm eg C:\Program Files

[GNC] Build 4.8 docs issue

2021-10-03 Thread flywire
Arthur, that's a nice summary of a https://en.wikipedia.org/wiki/Reflowable_document The issue has been raised and https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was offered as a format. Does it work on a Kindle? ___ gnucash-user mailing

[GNC] Tax and Budget Reporting

2021-10-05 Thread flywire
Your reports show Expense:X and Asset:Tax Collected (but not reimbursed). Why do you want to budget for tax if it is reimbursed with a net cost of zero? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Ineffective Mailing List Searching

2021-08-28 Thread flywire
I raised this issue because despite asking users to search the mailing lists this demonstrates the provided searches have little value. I followed mailing list search instructions - https://lists.gnucash.org/mailman/listinfo/gnucash-user (note Nabble is inoperational and the only other search is

[GNC] About stylesheets

2021-11-19 Thread flywire
> Is there any documentation concerning the CSS-based stylesheet (experimental)? Is this an area a mug punter like myself should be playing with? CSS is discussed in https://wiki.gnucash.org/wiki/Custom_Reports#The_Report-Renderer but be careful because the wiki documentation is broken so you'll

[GNC] Why do people start new threads?

2021-12-13 Thread flywire
...and Mailman3 provides a forum-like interface with direct replies through the interface. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2021-07-21 Thread flywire
Looks like it needs a Dividend contra account which should cancel itself out or be ignored in reporting: Dividend Date Deposit into Bank account from Dividend account End Previous Year Date Deposit into Dividend account from Component splits > ___

[GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2021-07-21 Thread flywire
In Australia ETFs operate under a trust structure, so distributions received in the new fiscal year are income for the previous tax year. Being tax, there are many splits associated with each transaction. (Essentially, if the year was changed to the previous fiscal year it would be reported for

[GNC] Use Piecash to Import Transactions Creating Account Structure

2021-07-18 Thread flywire
I previously mentioned piecash will easily import csv transactions. It also creates the account structure in the process. piecash is a GnuCash compatible python library. It doesn't use GnuCash but creates files that are compatible with GnuCash. piecash is an alternative to the python bindings

[GNC] Making Tax Digital (MTD) for Tax Self-Assessment

2021-07-21 Thread flywire
This mailing list is for discussion. I suggest you raise an enhancement request: https://wiki.gnucash.org/wiki/Bugzilla ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Use Piecash to Import Transactions Creating Account Structure

2021-07-22 Thread flywire
> Why not just use the built-in importer? Won't run without manual input. Anyway, this just demonstrates one process. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Removing "," (comma) delimiters from large numbers

2021-07-23 Thread flywire
You could have also picked a different field separator eg Semicolon (;) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are

[GNC] Help needed in Australia

2021-07-28 Thread flywire
What do you need Weiwu? eg Bookkeeping familiarity, type of business, number of enterprises, cash or accrual tax accounting, gst registered, number of bank accounts. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Help needed in Australia

2021-07-28 Thread flywire
You're on cash accounting for tax. Two GnuCash limitations compared to other packages you need to understand: 1. No automated GST support for cash accounting (it's manual): https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097092.html 2. No support for non-account transaction

Re: [GNC] Help needed in Australia

2021-07-28 Thread flywire
GnuCash integrates with bank statements so you won't miss any small amounts. GST is automated for accrual accounting but not for cash accounting. I wouldn't expect it to be a big programming job to enable, just not a current priority for any developer.

[GNC] Bill - Book Item lines to different Customers.

2022-01-10 Thread flywire
OP, Have you looked at other software? Next you'll be looking for Bug 113772 - Add categories for more reporting flexibility, https://bugs.gnucash.org/show_bug.cgi?id=113772 . ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

[GNC] How to get debug to work (saying "uncle")

2022-01-17 Thread flywire
Try part of the qif file at a time. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see

Re: [GNC] How to get debug to work (saying "uncle")

2022-01-17 Thread flywire
Test one and a few records too. Alternatively, you could try csv format. On Tue, Jan 18, 2022 at 9:50 AM flywire wrote: > Try part of the qif file at a time. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscr

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread flywire
Arthur, Your original message was clarified to be about automatically posting weekly rent so a rental statement can be produced with the balance of the account at that date. This is a very simple schedule of regular dates and amounts but GnuCash can't do it without manual workarounds.

[GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-05 Thread flywire
Excellent question Arthur. This isn't a budget issue and you have no idea if tenants are in front or behind unless you compare it to payments due. Adrien seems to have presented the GnuCash features the best using a scheduled A/R. I've used a different approach with quickbooks for this purpose

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread flywire
https://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_print_a_Rental_Statement_for_my_Tenant.3F A start. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Fwd: GnuCash page FAQ has been changed by Flywire

2022-03-08 Thread flywire
Thanks all, that contribution fits much better there and it's well supported by the tip above it. Ultimately, private rentals are probably common enough for it to be worthwhile supporting this feature directly. I'll offer a few comments for consideration. There was a fair amount of discussion on

[GNC] Report Help

2022-03-19 Thread flywire
https://wiki.gnucash.org/wiki/Custom_Reports - it's broken when you get down into it. There are two basic reports, the transaction report, and most of the others are based on the income and expense report. ___ gnucash-user mailing list

Re: [GNC] Report Help

2022-03-20 Thread flywire
This: https://wiki.gnucash.org/wiki/Custom_Reports#Technique_to_reload_reports_without_restarting_GnuCash Except for the bash script the process works the same in Windows as linux. The code comments work well:

[GNC] Managing multiple vehicles

2022-02-04 Thread flywire
> This farm has over 10 vehicles that we'd like to keep track of gas, maintenance and tax expenses... > I've read that using other softwares one can benefit from "category" to better filter the information you want and create reports... It's not so much filtering, more grouping of cost components

[GNC] Don't get this at all

2022-02-01 Thread flywire
> On Feb 1, 2022, at 1:47 AM, Don Robertson wrote: > Well, I guess it isn't for me. I think computers should save people time. If I need to open my bank page in my browser and copy the transactions manually into Gnucash and make a bill, post it, and pay it for every packet of paperclips

Re: [GNC] Managing multiple vehicles

2022-02-05 Thread flywire
> I've read that using other softwares one can benefit from "category" to better filter the information you want and create reports One of the workarounds previously discussed is to add a tag [ie category] to the split notes, it's just under the description in the account register. A transaction

Re: [GNC] Managing multiple vehicles

2022-02-05 Thread flywire
> How many "classes" can be assigned to the same account? In other words, can an account be a member of many different "classes"? If that is not possible, if only one, then it should be obvious why an accountant would find pretty useless. Rest assured, classes have nothing directly to do with

Re: [GNC] How to get debug to work (saying "uncle")

2022-01-17 Thread flywire
https://bugs.gnucash.org/show_bug.cgi?id=113772 Try https://kmymoney.org/ On Tue, Jan 18, 2022 at 1:07 PM Greg Feneis wrote: > Also, I'm not sure, but I don't think GnuCash has a facility for > QuickBooks' or Quicken's categories > ___ gnucash-user

[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

[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

[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=C=guide I doubt many people

[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 & Balance Sheet from a 2002 version of Quickbooks together with end of year bank statements - he has never wanted to get the

[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

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:

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

2023-09-24 Thread flywire
://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 from that project

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

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

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

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

[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

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

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,

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

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] Help with GnuCash's 'help'

2022-04-26 Thread flywire
A couple of years ago https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was tested (as external help) but there was no interest. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Switching from Quickbooks and getting started

2022-06-03 Thread flywire
Two things you need to consider before deciding to switch: 1) classes are not supported and the workarounds won't do grouping for reports (ie list all transactions ordered by workaround for class) 2) with cash accounting there is no automatic tax (GST, sales tax, VAT etc), it only works with

[GNC] New User Oh boy I need an accountant

2022-07-18 Thread flywire
Firstly, an accountant won't know how to use GnuCash unless they are a user. Have you done the GnuCash Tutorial and Concepts Guide as an introduction for Getting Started and Managing Personal Finances? Put it in a window on one side of your screen and start a new GnuCash file in a window on the

[GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-25 Thread flywire
TLDR: GnuCash Windows version is compiled on linux so, considering the note below, you are unlikely to get python bindings working in Windows. > Important > The Python extensions are an optional feature which creates additional > dependencies. To be > able to use Python scripts, GnuCash must

[GNC] Lost 4 hours of data input

2022-07-24 Thread flywire
Is a crash in the import system part of the autosave scope? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble

[GNC] Regularly importing transactions from CSV files

2022-07-24 Thread flywire
Seems you are following https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv. Figure 6.5. The CSV Import Preview Pane is hard to read so click https://www.gnucash.org/docs/v4/C/gnucash-help/figures/Help_CSV_Import_transactions_Preview.png to view it in a new tab. *

[GNC] Online Help manual CSV import section is out of date

2022-07-27 Thread flywire
>* the original remains in the Tutorial and Concepts Guide. It should have been *>* removed...* David, Thinking about this again. How about a section which imports the tutorial transactions from csv referencing the help manual? Maybe an export/import with multi-splits. It would complement the

[GNC] Online Help manual CSV import section is out of date

2022-07-17 Thread flywire
I think the GnuCash Tutorial and Concepts Guide is an excellent introduction for Getting Started and Managing Personal Finances. The small dataset demonstrates a lot. The only thing that really looks dated is the checkbook-style transaction descriptions which are very different to modern bank

[GNC] Account setup for reports

2022-04-27 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html is part of a discussion on classes. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

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

2022-08-24 Thread flywire
The three lines below work using a Multi-split import - based on https://bugs.gnucash.org/show_bug.cgi?id=797450 Save *PP-Demo_Transactions_Minimal_Priced2.csv*: Date,Description,Action,Account,Deposit,Rate/Price 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2022-08-24 Thread flywire
I uploaded the spreadsheet I've been using and a python program I wrote to https://github.com/flywire/ETF-Annual-Statement It's basically just a lookup and pivot table saved to csv using rounding as an error check (credit to Chris Grinton). It could easily be extended to automatically extract

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

2022-08-24 Thread flywire
> Does the CSV importer handle floating point values for amount and price or do I need to use integers? Floating point works fine for me in all amounts except price: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102535.html > e.g you'd write $497.65 for 57 shares as 49765/5700

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

2022-08-25 Thread flywire
Did you carefully work through the known working process described in the bug report Comment 3 using the file below? The broker csv file almost certainly needs manipulating. The best approach is to enter the data into GnuCash, and then export the account to csv. You can use the exported csv to

[GNC] Reports: Account ending balances

2022-08-28 Thread flywire
Try Reports, Account Summary ___ 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 on all your

[GNC] Example of importing Stock transactions from CSV

2022-08-20 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102526.html > CSV stands for "common separated variables. > data must be in the right order AND any data that is null (not present still has its space in the record. Hmm: * Comma separated variables -

[GNC] rounding of Invoice vs Accounts Receivable

2022-10-18 Thread flywire
Since I use cash accounting I don't have any experience with GnuCash invoicing. I process heaps of invoices, including recipient-created invoices. Tax-inclusive or tax-exclusive costs are optional in Quickbooks (which I use for business accounts) and calculated values can be user overwritten. I

[GNC] gnucash-user Digest, Vol 235, Issue 46

2022-10-20 Thread flywire
>* - BUT: For income and expense accounts, multi-currency accounts seem to be *>* a total disaster. Why? Because all PAST transactions on both income and *>* expense accounts will be valued at the CURRENT exchange rates.* Simply recording value in local currency works for me. You can add a

[GNC] invoicing

2022-10-26 Thread flywire
The process needs to be right before worrying about the accounts: 1. If your tenant is reluctant to pay rent find a new tenant, no different to any other business clients that are hard work. 2. Weekly tenant notices with the amount owing seems more like harassment, and too much work

[GNC] Unable to import CSV with charges and payments

2022-10-28 Thread flywire
Try https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097442.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user -

[GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-09-30 Thread flywire
This is similar to rental payments but my experience is with cash accounting. It is easy to skip an invoice and in my jurisdiction, this eventually means it isn't required to be paid. I'd suggest providing a statement instead of pairing payments and invoices so payments are applied to the oldest

[GNC] Build From Source Near Impossible

2022-08-10 Thread flywire
Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html > You're correct that the Python bindings aren't included. I'd be happy with a non-standard download available that included the bindings. It wouldn't need gui support. ___

Re: [GNC] Third party OFX/CVS providers

2022-08-10 Thread flywire
That never used to be the case but it's still pretty useless for a tax return: Please note that if you wish to download transactions that is more than the 12 month period, you must choose the 'View Statement' option. However, please be advised that it does not have the facility to transfer them in

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread flywire
Oh, security isn't a thing anymore? Maybe supply your DOB and mother's maiden name too so they don't have to get it from social media. On Sun, Aug 7, 2022 at 09:09 Christopher Lam https://lists.gnucash.org/mailman/listinfo/gnucash-user>> wrote: >* You may try this service which is free for

[GNC] Crash in Trial Balance

2022-08-14 Thread flywire
They look big numbers. I wonder if it's an overflow issue. ___ 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

[GNC] Using GnuCash with Portfolio Performance Share Software

2022-08-14 Thread flywire
Share software can manage shares and show all sorts of interesting things. I use Portfolio Performance portfolio-performance.info/en/ and Sharesight sharesight.com is also popular. Portfolio Performance easily imports broker trade pdfs (Sharesight even strips emails or uploads a hot folder) but

[GNC] How to bulk import about 130 Securities entries?

2022-08-14 Thread flywire
Jim, this overlaps with what I was putting into https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102404.html so I stripped the data exchange part out. The sample data sets and references might still be useful. The GnuCash GUI won't import security data so in addition to what has been

Re: [GNC] Using GnuCash with Portfolio Performance Share Software

2022-08-15 Thread flywire
I'd appreciate any comments if this could be able to be managed as a single portfolio (ie one security). I can't get it to work without entering every share. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-15 Thread flywire
Once share securities are created the share accounts can be created with File, Import, Import accounts from CSV. File, New Cancel Tools, Security Editor Securities: Add New security Full Name: *** Symbol: *** Type: *** - Sticky Fraction Traded: *** OK File, Import, Import Accounts from CSV

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-15 Thread flywire
I haven't used GnuCash securities before the last week and I'm still not clear about them. I understood importing security entries were transactions. Further to my last post with minimal security information the fraction traded is not required. I hadn't realised importing transactions with

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread flywire
Obviously it wasn't clear that the post copied below identifies the keystroke operations from opening GnuCash through the Security Editor with *** as user input. The Import accounts was an aside comment. (Thanks David for start the account tree comments.) Interestingly New security is one of the

[GNC] Share Values recording

2022-08-11 Thread flywire
This might be a TAX issue but financial reporting is very much a GnuCash issue and has nothing to do with tax advice. Different terms being used for the same thing in different jurisdictions complicate the discussion, and then the taxes actually vary. I've managed to move most of my spreadsheet

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2022-08-12 Thread flywire
Thank you for the discussion. To clarify, these ETFs are index funds: https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205=prices-and-distributions I don't see the point of entering the attribution values since they don't exist in the bank statement or tax return. A contra account

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2022-08-12 Thread flywire
This Account Summary demonstrates the last part of the need to distribute all [Family] Trust income from the ETFs. Note: 1. ETFs have been manually revalued at the end of the tax year (after working through https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html ) 2. Distributions

[GNC] Third party OFX/CVS providers

2022-08-06 Thread flywire
My Citibank statements are only available as pdf and I use https://github.com/flywire/pdf_statement_reader . It is based on tabula and forks another project to make it functional. More config info at https://github.com/marlanperumal/pdf_statement_reader/issues/34

[GNC] Request for two new features in GnuCash

2022-08-07 Thread flywire
More cat skinning: >* the ability to have two separate (at least) GnuCash file systems: * In Windows (or probably any GUI) double-click file in data folder and it will use file association to open the file (in GnuCash). Alternatively, for each file: right-click file, create a shortcut, drag

[GNC] questions from a new user

2023-01-09 Thread flywire
I'd expect there are easier invoicing packages, but you will likely need much more. I don't know why there is no tutorial for GnuCash business features (which only support accrual accounting) but each feature has an example transaction. I don't use those features and agree, they seem confusing.

[GNC] import settings file

2023-01-04 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user -

[GNC] Can I add to Equity?

2022-12-02 Thread flywire
It is my understanding certain legal documents need an amount to be effected but normally it is not actually paid, so there would be no £1 in the books. It probably becomes an unpaid invoice or loan but that's lawyer/accountant detail. ___ gnucash-user

Re: [GNC] Tracking Travel expenses

2022-11-18 Thread flywire
https://wiki.gnucash.org/wiki/Using_GnuCash#Tracking_Reimbursable_Expenses > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user -

[GNC] Account structure for tracking trip expenses

2022-11-18 Thread flywire
See first part of https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html re tags for most practical workaround. You could use multiple tags on one split to get all or particular trips, eg: #trip #cruise. As noted, there is no support for grouping (ie display all transactions in

[GNC] Importing csv files

2023-01-19 Thread flywire
Make sure you understand what Gnucash offers as it could be a massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for different books because neither has all the features I need. Specifically, GnuCash does not support classes or automated GST (tax) for cash accounting (so I've

Re: [GNC] Importing csv files

2023-01-19 Thread flywire
There is no panacea for replacing QuickBooks with GnuCash but I'm starting to warm to the workarounds: * https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html - use tags instead of classes, the transaction report is the only one that supports filtering so other reports would

[GNC] Entering Dividend Confusion

2023-01-21 Thread flywire
The guide isn't really enough. Try these (checking the attachments) and follow the last thread: * Dividends - https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097500.html * Trusts (eg ETFs) - https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102563.html * Portfolio -

[GNC] Scheme Report - SubTotals to Normal Style with Hidden Transactions

2023-01-20 Thread flywire
The Transaction report has an option to hide transaction data and just report Account totals; Option, Sorting, Show subtotals only (hide transaction data). Prefixing all lines with "Total for " and highlighting them makes the report harder to read. I tweaked

Re: [GNC] Entering Dividend Confusion

2023-01-21 Thread flywire
R Losey wrote: > You need to make sure that your... stock is set up as an account type of > "Mutual Fund" or "Stock" No you don't, dividends can be entered into a dividend account like any other transaction. The main feature of a "Stock" account type is easier revaluation of a portfolio, ie

[GNC] Start up cost in GnuCash

2023-01-24 Thread flywire
Common advice is don't mix personal and business bank accounts but almost everyone does with personal tax. You could do what you want with a business account under each top-level account or bank account then report against those accounts but it would be fiddly. It is a classic class issue, ie one

<    1   2   3   >