Re: [GNC] Rule based bank account transaction allocation

2020-04-27 Thread flywire
I've been working on a spreadsheet to "Lookup Part of Text Randomly Placed Text in Cell" ie lookup a search string. Figured it could be run for each field to be added to the csv. qifqif ( https://github.com/Kraymer/qifqif ) is nice but it won't run on windows.

Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-04-25 Thread flywire
The import was successful but I imagine the experience is like going through a binder and reaper blindfolded in the dark. The issues weren't all GnuCash. I reduced the form size, imported 50 (?) transactions (into a sqlite file) and then the rest. The account matching still occurred :(( but the

Re: [GNC] A Milk Run

2020-04-25 Thread flywire
Dave, this is a personal thank you for your reply, it has made all the difference. I'll update [GNC] Why do Imported Transactions NEED to be Matched? https://lists.gnucash.org/pipermail/gnucash-user/2020-April/090631.html separately. On Sat, Apr 25, 2020 at 10:59 AM David Cousens wrote: >

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

2020-04-30 Thread flywire
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. >&g

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

2020-04-30 Thread flywire
Adrein, thank you for those tips. I've simplified the example too much. There are multiple accounts, some with more than a handful of transactions to be moved, but your workflow seems to work using the transaction report to open up the account register. I understand you're suggesting if the bulk

[GNC] Superannuation Co-Vid payment

2020-04-30 Thread flywire
oz ___ 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

[GNC] Change account type by editing XML?

2020-05-01 Thread flywire
No it's not specific to type A/R and/or A/P accounts. I clicked the wrong account and accidentally imported an expenses account into assets. I was expecting I could just delete it and move it to Expenses:Account but it just moved to Assets. (Import Matcher pisses me off because the account was

Re: [GNC] Change account type by editing XML?

2020-05-01 Thread flywire
The intent of my post was to report you can't reassign transactions between Asset and Expenses accounts either using the process previously described. Yes, the account in Asset was created by the import wizard. It's nothing serious, went back to the previous file and imported again. On Sat, May

[GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

2020-05-02 Thread flywire
Is exporting Transaction Report as pdf splitting the last line horizontally over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either Chrome or Edge under Win10. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

2020-05-02 Thread flywire
Thank you. Yes, calc opens them directly with File, Open *.html. With Right-click, File open with, select calc and it opens in writer. (File association for html is chrome.) On Sat, May 2, 2020 at 9:51 PM Derek Atkins wrote: > Yes, it will.. And will parse tables properly into rows/columns. >

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

2020-05-02 Thread flywire
Off-topic but will LO calc directly open a HTML file? (It opens in writer and wiki is more about excel.) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Record Loan Interest

2020-05-04 Thread flywire
Sorry, another loan query. Going in circles and thoroughly confused by https://www.gnucash.org/docs/v3/C/gnucash-guide/loans_mortgage1.html which seems to cut out before the interest is paid and flip to making a loan. I have a loan account (say $1000 Liabilities:Loan) and the interest is

Re: [GNC] Trying to set up online banking

2020-04-26 Thread flywire
https://wiki.gnucash.org/wiki/Bugzilla or more to the point, do your research then https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread flywire
@Tom Seesink - Will you log that as an enhancement bug at https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash (Import - other)? Please link back here. @David Cousens, that excellent explanation about how the Import Matcher works helps answer my question. The documentation needs to explain the

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

2020-04-26 Thread flywire
Fair point, they are relational tables. >From the Savings Account To the Transfer would have to be displayed as or display the whole thing at splits level using a single transaction as a single split. Filtering anything with a specified Transfer would still be useful. As @Christopher Lam

Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread flywire
> Do you know other (including closed source) apps don’t use something similar? I've used many other financial apps that just import Transfer Account directly in as listed in the csv. > Why would a user normally need to know this implementation detail? Because it's counter-intuitive to load a

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

2020-04-26 Thread flywire
This is a very old thread so how does it work now? How can I sort Savings Account by Transfer account? The Sort by options are: Date, Date of Entry, Statement Date, Number, Amount, Memo, Description, Action and Notes. ___ gnucash-user mailing list

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

2020-04-26 Thread flywire
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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] A Milk Run

2020-04-25 Thread flywire
Do you realise you are commenting on a personal email sent to David Cousens who cc'd the mailing list into the reply? I may not have made the point about rapid changes in communication technology in the last few years that way on a public forum. As you know I followed your recommendation and

[GNC] Why do Imported Transactions NEED to be Matched?

2020-04-25 Thread flywire
I have a few thousand transactions in a bank statement csv file tagged with a transfer account. Why can't I skip the import matching process? Firstly, assume this test data from the Concepts Guide checking account with the addition of a typical bank statement description and transfer account. It

[GNC] Transaction Report Default Account

2020-05-10 Thread flywire
A Transaction Report is grouped by Account. The Default Display selecting Account Name and not Other Account Name seems wrong, the whole group has that account name. The setting is contrary to the equivalent report in other Financial packages. Any concerns with me listing it as a bug?

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread flywire
Something must have changed eg: https://www.gnucash.org/docs/v3/C/gnucash-guide/figures/cbook_TransactionRptAssets.png I know I can change the report setting. Can someone point me to the guile file on my computer for that report? I'd like to tweak it.

Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-05-12 Thread flywire
Good information and very readable code on Bayesian matching - https://wiki.gnucash.org/wiki/Bayes ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Navigating the Wiki

2020-05-12 Thread flywire
I keep discovering good information in the wiki I wasn't aware of, mainly through external links. To understand how to use the wiki you need to read https://www.gnucash.org/docs/v3/C/gnucash-help/Help-Window.html#wiki which basically explains you need to navigate by searching. Fortunately the faq

[GNC] Managing Profit Centers, Enterprises, Projects

2020-05-12 Thread flywire
I don't know the proper accounting term for this, the intent is to use reports to compare finances between the different parts of the entity. I'm asking how people do it. https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users uses a simple rental business as an example. Assume

[GNC] Backup to encrypted 7zip file

2020-05-12 Thread flywire
Hmm, old idea apparently. GnuCash is launched in Windows from a batch file to it seems to integrate well. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Backup to encrypted 7zip file

2020-05-12 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2014-September/056076.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 If

Re: [GNC] Backup to encrypted 7zip file

2020-05-13 Thread flywire
Er ... no encryption. https://wiki.gnucash.org/wiki/FAQ#Q:_Can_you_please_add_a_password_feature.3F ...[No] The actual problem is access to personal data on a work supplied computer. An optional program based backup is more appropriate. GnuCash won't install but thankfully there is a portable

Re: [GNC] Managing Profit Centers, Enterprises, Projects

2020-05-13 Thread flywire
As always, thanks for your considered advice David. It's a single entity where everything is shared except for specific income and expenses. Separate books are not-on. I'm understanding you are suggesting a separate subaccount for each Enterprise/Project under the existing CoAs (eg

Re: [GNC] Budgeting

2020-05-06 Thread flywire
Before moving to budget reporting here are the notes using Creating a Budget - https://www.gnucash.org/docs/v3/C/gnucash-guide/budget_creation1.html Choose Which Accounts To Budget For - for cashflow, chose Expenses and Income Choosing a Budget Period - Annual budget, monthly periods, commencing

[GNC] Budgeting

2020-05-06 Thread flywire
> On Wed May 6 13:33:24 EDT 2020 Adrien Monteleone wrote: > >> On May 6, 2020 w19d127, at 4:23 AM, flywire wrote: >> >> ... It would be really useful to be able to export as a csv, change it and import it back in. > > Are you referring to export/import of the bu

Re: [GNC] Budgeting

2020-05-06 Thread flywire
Let's run a budget report. Reports, Budget, Budget Report Edit, Report Options (or press Options button), General: Budget - Annual Budget, Accounts: Account Display Depth - 3, Account - Select all Expenses and Income accounts only, Display: Show column with Totals - Tick, Apply File, Export,

Re: [GNC] Record Loan Interest

2020-05-05 Thread flywire
Thank you. The guide explains a credit card account is a short-term loan. The Loans section probably needs a reference back to Credit Card Putting It All Together section which clearly explains Interest and Payments. Aaron describes it pretty well, a loan interest transaction generates an expense

[GNC] Porting the Tutorial & Concepts Guide to ReadTheDocs.org

2020-05-05 Thread flywire
I thought there would have been more comments on Porting the Tutorial & Concepts Guide to ReadTheDocs.org tested recently at https://gnucash-docs-rst.readthedocs.io/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

[GNC] Budgeting

2020-05-05 Thread flywire
The budget estimate didn't give me an average monthly expense as I expected, everything was zero. It would really benefit from a tutorial. Can I get a cash flow report with the monthly expenditure in columns for all of the income and expense accounts?

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread flywire
Thanks @John Ralls that wiki page was what prompted this thread, hoping to tweak report without going through the full report development process. > just save the report configuration The issue is Save Report Configuration saves those reports in a different part of the menu to the default

Re: [GNC] Backup to encrypted 7zip file

2020-05-13 Thread flywire
Simply put: - I'm not the one using it - it's to prevent casually or accidentally displaying the data - considering the external value of personal cashbook data this very accessible process kindly provided by a community member seems fit-for-purpose - GnuPG may well offer better security but it's

Re: [GNC] Porting the Tutorial & Concepts Guide to ReadTheDocs.org

2020-05-06 Thread flywire
On 5/6/2020 11:15 AM, Adrien Monteleone wrote: > ... I personally would like to see its development move to something with less of a hurdle or learning curve as that could include more seasoned users who aren’t build savvy. - That's certainly one potential benefit. A few comments from

Re: [GNC] Budgeting

2020-05-06 Thread flywire
Thanks Adrien, that got my budget going. I'd tried current date and 12 months prior to shutting it down so there must be something else too. I thought I read somewhere that it wouldn't do subaccounts but I' added them in separately. Rolling out an old comment again: It would be really useful to

[GNC] Reformat Bank Description to Capitalise Every Word

2020-05-08 Thread flywire
My bank statements use uppercase text which is harder to read than mixed case. Is it possible to reformat the bank description to capitalise every word? It could happen as part of the import process on any field selected but ideally it would be nice to run on existing transactions without

[GNC] Importing data from a CSV file

2020-05-08 Thread flywire
lol - Welcome to GnuCash. That's how it is designed. Discussed https://lists.gnucash.org/pipermail/gnucash-user/2020-April/090631.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread flywire
A useful tip but an unfortunate post title because this exports the transactions. The Transaction Report can be exported as a html and opened directly in a spreadsheet (LibreCalc). GnuCash csv import not initially recognising anything in the csv file it just exported is also a surprise and

[GNC] Job Costing as now available

2020-05-23 Thread flywire
Mentioning a couple of related threads: https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091134.html https://lists.gnucash.org/pipermail/gnucash-devel/2020-May/045064.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

[GNC] [GNC-dev] Is the import match map still required?

2020-05-23 Thread flywire
The most obvious match would be to match any Transfer Accounts in the data to gnu Accounts, even if the result needs to be verified. Other comments: 1) User's rapid clicks can unintentionally select the wrong account, mapping invalid data 2) Seems there could be an opportunity for user to re-run

Re: [GNC] Reformat Bank Description to Capitalise Every Word

2020-09-04 Thread flywire
gnu sed v4.7 on win10 sed -i.bak '/^/s/\w\+/\L\u^&/g; s/^\^|Trn:Description/\L^&/g' filename Delete the ^ escape characters if not on windows. On Sat, May 9, 2020 at 6:22 AM flywire wrote: > My bank statements use uppercase text which is harder to read than mixed > case.

Re: [GNC] Problème export / import dans GNU CASH

2020-05-31 Thread flywire
3. Use 6.2. The CSV Transaction Import Assistant - Introduction https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#idm45801348293200 > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Problème export / import dans GNU CASH

2020-05-31 Thread flywire
Bonjour Choose: 1. Use original file 2. Restore from Backup 3. https://gnucash.org/viewdoc.phtml?rev=3=C=help - you will have to Match Transfer Accounts ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Running both Stable and Development Releases

2020-05-26 Thread flywire
GnuCash setup is quick enough but it asks for the existing version to be uninstalled. Can both Development and Stable releases be installed at the same time under Win10? Installing the Stable release and running a PortableApp version of the Development release would be good.

[GNC] Gnucash - user

2020-07-07 Thread flywire
> This will change when (if) we migrate to mailman3, which includes the > "hyperkitty" forum-like interface, but at this point in time we do not > have a timeline for when this will happen. mailman3 would put wheels on the sled. ___ gnucash-user mailing

Re: [GNC] Gnucash - user

2020-07-08 Thread flywire
I understand it is a word-picture. The wheel is a big technological improvement to reduce the work of moving a sled, a flat device for moving an irregularly shaped object across the ground. btw, almost no snow in Australia. >> mailman3 would put wheels on the sled. > > > >I must admit I don't

[GNC] Style Sheets - general questions

2020-06-18 Thread flywire
I was really pleased to be pointed to opening HTML reports directly in LO Calc last month. I can see CSS is very versatile but I'm not proficient with it. Hopefully someone can contribute a quick guide for GnuCash reports at some stage. I'd be happy with just turning off the white background

Re: [GNC] Style Sheets - general questions

2020-06-18 Thread flywire
> How is it interfering with adding columns in LO Calc? Only different formatting. > select the entire sheet (clicking that empty cell in both row/column headers) and remove *all* styling. No luck with that, Just selected cells and set to Background colour (No Fill). I suppose my preference

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-05 Thread flywire
I started a thread before the one I linked where I explained I had been through an equivalent process of adding transfer accounts. David explained it well in the thread I linked which is supported by https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png and the code. > I really want to avoid

[GNC] importing multiple CSVs to Gnucash

2020-06-02 Thread flywire
This is a bad idea. You are thinking logically like other software but you don't understand it MUST go through account matching which is ALWAYS a manual process that doesn't really recognise the Transfer Account in your data (details in thread:

[GNC] Check printing via the command line?

2020-07-17 Thread flywire
Could Windows macro software that interacted with the gui help automate the check printing process? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-26 Thread flywire
> Here's what my accounting 101 textbook says about cash receipts: >> * All cash receipts should be deposited intact in the bank... Cash disbursements should not be made from cash receipts but only by check or from petty cash. lol Do the accountants want to handle the books for all community

[GNC] bulk operations?

2020-12-07 Thread flywire
>* If it's not possible through the GUI, how about via issuing SQL *>* statements to a database backend?* *Seems reasonable.* ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Transaction ordering on num field

2021-06-15 Thread flywire
> What "standard" are you referring to? > GnuCash stores information at the highest level in files. A file can be > stored on your computer either as a single XML file (in all versions of > GnuCash), or in a SQL database (in GnuCash version 2.4 and higher). The sort order of the application a

Re: [GNC] Transaction ordering on num field

2021-06-15 Thread flywire
http://gnucash.1415818.n4.nabble.com/GNC-dev-Dev-s-features-of-choice-tp4726710p4726713.html > "you can use Microsoft Access or Open/LibreOffice Base with SQLite3 via an > ODBC driver" -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Transaction ordering on num field

2021-06-10 Thread flywire
How can special customisation to sort a GnuCash field be justified when it makes future transitions even more difficult? This field should be sorted in a standard way. It's clearly the old *numeric* field for sorting cheques, and the banks tell us cheques are as good as dead. When it was changed

Re: [GNC] Transaction ordering on num field

2021-06-11 Thread flywire
The question is about custom changes to the sorting algorithm (with an undocumented feature) and I'm questioning actually using a *non-standard* sorting algorithm. Using the 80:20 rule most of the benefit of the system comes from a small part of it. How can GnuCash evolve if custom code is carried

Re: [GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread flywire
Work through https://gnucash.org/viewdoc.phtml?rev=4=C=guide It would have been simpler as a tutorial if it was only two accounts deep. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] Interface Issues

2021-05-14 Thread flywire
8) [Transaction] Report, Sorting tab options at bottom of form should be on Display tab. 9) [Transaction] Report, Sorting tab /Show subtotals only (hide transactional data)/ is very useful but headings should be normal text at this level. -- Sent from:

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread flywire
Sample account that shouldn't need manual matching: -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread flywire
Original post about turning off Bayesian matching prompts: flywire wrote > It's not that hard to match most transactions and add accounts using a > spreadsheet or other tool leaving the rest for manual confirmation. It > would be reasonable to have a setting so they could be imported

Re: [GNC] Associate a file with the selected transaction.

2021-05-15 Thread flywire
I did and was told it's out of scope. David Carlson-4 wrote > Did I mention encryption? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Associate a file with the selected transaction.

2021-05-15 Thread flywire
https://wiki.gnucash.org/wiki/FAQ#Security:_Encryption.2C_Password_Feature -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or

Re: [GNC] apply a factor to profit/loss report

2021-05-19 Thread flywire
I'm sure this sort of thing is fairly common with one spouse holding some investments and others shared. Alternative spreadsheet approaches are: 1) A record on each line then import file as say csv format 2) Setup a form and perhaps paste them straight into a GnuCash transaction, but probably

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

2021-06-01 Thread flywire
Entering data for someone else is likely to produce a lot of /corner cases/ too. This leads to insert/delete splits, which always causes me grief, and I have to delete the imbalance line manually. Is my workflow wrong? -- Sent from:

Re: [GNC] Import Format

2021-05-27 Thread flywire
Thanks Dave, that's one of the four main banks: https://commbank.simplify.com/commerce/docs/misc/dataexport Interestingly there's a developer's link on that page too. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

[GNC] Import Format

2021-05-27 Thread flywire
The documentation could offer users more guidance in choosing the import format. Most banks allow account transactions to be downloaded (usually as files) and most financial software (including GNUCash) allows the transactions to be imported. GnuCash offers six options but in reality the user

Re: [GNC] question - how do I move one or more transactions between accounts?

2021-05-29 Thread flywire
If most transactions are to be moved to one account it can be worth renaming the account and moving out the other transactions. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] Frustration

2021-06-06 Thread flywire
What you want is very simple, just not in GnuCash which is possibly the only package without it. The workaround changing accounts is just not worth the grief. Other software allows a category or class[ification] field on each transaction. Normally the field is even auto-populated based on say a

Re: [GNC] Import Format

2021-05-28 Thread flywire
Sample pdf bank statement attached. Format will vary by bank but note "Opening balance" before first transaction, "BALANCE CARRIED FORWARD" at end of non-last page, "BALANCE BROUGHT FORWARD" at start of non-first page and "CLOSING BALANCE" on last page would allow transaction filtering. Some

Re: [GNC] Import Format

2021-05-28 Thread flywire
Another two of the four Australian banks: * https://help.anz.co.nz/app/answers/detail/a_id/334/~/transaction-history-export-formats * https://www.westpac.com.au/business-banking/online-banking/support-faqs/export-detailed-transaction-history/ Don't assume these formats are available with all

Re: [GNC] export to PDF

2021-05-26 Thread flywire
You're disappointed with the webkit developers not the GnuCash developers. Maybe your OS has a scripting facility. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] GNUCash & Macros

2021-05-26 Thread flywire
https://autohotkey.com/board/topic/50354-ironahk-alpha-cross-platform-net-rewrite-of-autohotkey/ -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread flywire
GST is only really supported if it's auto-calculated otherwise a user has to enter twice the splits with the associated logic and keying errors. I've only been using the Account Register for data entry. Are Invoices and Bills the way to do it without obligating the user to additional Accounts

[GNC] Accounting for GST in Australia

2021-07-06 Thread flywire
Thanks for the wiki Chris. A lot of people use a Recipient Created Tax Invoice (RCTI) without Accounts Payable/Receivable. One of the complications is the invoice might have a whole range of different charges with different GST treatments. Could you extend the wiki with a simple example for those

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread flywire
in GnuCash) auto-populated Data entry is pretty efficient but you miss out on the benefits of open data. On Wed, Jul 7, 2021 at 8:52 PM flywire wrote: > Are auto-generated GST calculations available for cash accounting without > Accounts > Payable/R

[GNC] Transaction report export file type

2021-06-25 Thread flywire
Last year I found the process of getting a budget report in a spreadsheet confusing ( https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091064.html). I understood it after help from the community and twigging to turning off the white background colour for the cells on the page. It would be

Re: [GNC] Accounting for GST in Australia

2021-07-06 Thread flywire
Try this. Sample RCTI but varies by recipient. Note GST-Free Transaction Levy is in this example. This is really simplified because income and cost components are being tracked for different enterprises and these livestock aren't necessarily from the same enterprise. Tax Invoice Income

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread flywire
Let's just enter that transaction. Following: * https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS#My_Tax_Tables * https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS#How_do_I_record_complex_business_transactions.3F It's always fiddly and there's no free ride. It's similar for grain

Re: [GNC] CSV matching produces duplicates?

2021-03-26 Thread flywire
David, your response doesn't change: > For csv transactions GnuCash pretty well prompts with the correct account > each time, so [provide a setting] to accept all prompts. 1) From my experience it's unreasonable to assume user can assign accounts when they don't understand

Re: [GNC] CSV matching produces duplicates?

2021-03-25 Thread flywire
> The matching of the account names... only happens... This doesn't change the suggestion of allowing the user to import the file, with accounts as coded, and fix tagged records afterwards (like any other software). To confirm "Car" account is "Car" account, wtf -- Sent from:

Re: [GNC] CSV matching produces duplicates?

2021-03-25 Thread flywire
Yes, this topic broke off the original thread, something to do with me replying from email. A chart of accounts imports easily, as expected with no issues or nagging. For csv transactions GnuCash pretty well prompts with the correct account each time, so set to accept all prompts. There is no

[GNC] CSV matching produces duplicates?

2021-03-20 Thread flywire
It's not that hard to match most transactions and add accounts using a spreadsheet or other tool leaving the rest for manual confirmation. It would be reasonable to have a setting so they could be imported straight in like any other software. ___

Re: [GNC] CSV matching produces duplicates?

2021-03-20 Thread flywire
Yes, there would be no matching decisions if it was coded in the input file but you won't be powering through it, GnuCash still requires user to verify each [iirc] account (which is coded in the input file). I'm suggesting user should be able to turn that checking off (since input file has been

Re: [GNC] Interface Issues

2021-04-12 Thread flywire
7) Imbalance errors (they're not intended) easily overlooked that sneak into transactions without any warning. Confirmation should be required to save transactions with imbalances. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

[GNC] Interface Issues

2021-04-11 Thread flywire
Raising a few interface issues again: 1) File, Properties. What is the current filename and path? 2) File, Open. How can I restrict the file list to certain types (extensions)? 3) Pressing the triangle to expand the account list often expands it below the bottom of the pane. Chances are the

[GNC] Multi-split CSV Import

2021-08-20 Thread flywire
CSV Import is documented in https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv In a lot more detail than the Guide and Concepts Manual (which is hardly more than a list of headings). The only dataset demonstrated is a screenshot in Figure 6.5. The CSV Import Preview

Re: [GNC] Multi-split CSV Import

2021-08-20 Thread flywire
Geert, thank you. With that pretty simple explanation I completely understand it. I've rolled all that together ordering the split description lines the same as the input form and added an example based on the Tutorial and Concepts Guide. David T, I'm with you on contributing but iirc the

Re: [GNC] Financial Account Structure for Australian Shares and ETFs

2021-08-27 Thread flywire
Thanks Chris, that helps me understand it a bit more but a little differently. I see Franking Credits as Income. Maybe someone with a formal accountancy background has an opinion. So, Income account has Franked, Unfranked (from Bank) and Franking Credit (from Asset). I'm not sure how taxes should

[GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread flywire
This report needs accounts and dates to be specified in Win10 and I'd like to tweak some other settings. "A datafile may be specified to describe some saved options." Where is the documentation for gnucash-cli ? E:\>"C:\Program Files (x86)\gnucash\bin\gnucash-cli" --report

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-09-01 Thread flywire
tions from the command line. The > gnucash-cli is meant mainly to run reports with sensible defaults (eg > balance sheet) and saved reports (eg transaction report with modified > options). > > On Tue, 31 Aug 2021, 5:53 pm flywire wrote: > >> This report needs accounts and dates to

[GNC] Financial Account Structure for Australian Shares and ETFs

2021-08-26 Thread flywire
The guide leaves stock and mutual fund financial account structure very open and search only showed one Franking/Franked thread in the recent past. I'm wondering what people do in practice. Share dividends looks doable: Bank deposit = Unfranked + Franked - Tax Withheld. Franked has unpaid

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

2021-08-19 Thread flywire
I've finally figured it out, one of those John Ralls comments that leaves you scratching your head. Anyway, with covid and all, I'm starting to understand a bit more about the accounting side of shares. Apparently, dividends and distributions are different

Re: [GNC] Transaction Report Account Name Style

2021-08-19 Thread flywire
I want to change character style (font attributes), just for Account Names. > Under Display tab, there are the "Use Full Account Name" options. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Transaction Report Account Name Style

2021-08-19 Thread flywire
How can I change the Transaction Report Account Name Style? I can't see it listed in Edit, Stylesheets or a unique class in the html. (The CSS-based stylesheet is a welcome addition. Not that long ago I didn't know what CSS was but it works well for GnuCash.)

[GNC] Cash Accounting Method

2021-09-12 Thread flywire
Rich, Do you use GST? GST doubles the number of transactions and is only automated in business (accrual) accounting. This is demonstrated in a recent example: https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097082.html I don't use the business accounting features but at first glance

  1   2   3   >