Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David H
Yes I thought that would be the case, good luck and I hope you can work something out that works for you. Cheers David H. On Sat, 24 Dec 2022 at 2:51 pm, Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Fri, 23 Dec 2022 at 23:00, David H wrote: > >> Dave, >> >> Probably doesn't h

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Dr. David Kirkby
On Fri, 23 Dec 2022 at 23:29, William Prescott wrote: > It would be pretty simple to add a column next to the date. Then put a > formula in the new column that made it equal to the date in the adjacent > column if there was one, and to the date in the preceding line if it was > blank. Then sort o

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Dr. David Kirkby
On Fri, 23 Dec 2022 at 23:06, David Cousens wrote: > > Dave, > > Not sure how you achieved that. I just exported one of my accounts and it > appears to be in date order from the first transaction entered (2015) > until the > last (a few days ago). I haven't checked the whole file but the first an

Re: [GNC] Gnucash on macOS Ventura

2022-12-23 Thread William Prescott
For what it's worth ... I just started running the latest version GnuCash 4.13-1 on Ventura 13.1. No real issues. I did have one momentary apparent glitch where it would not let me scroll the drop down list of accounts when trying to assign a transaction line to an account. But I just accepted

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Dr. David Kirkby
On Fri, 23 Dec 2022 at 23:00, David H wrote: > Dave, > > Probably doesn't help but I just did a test export and noticed there's a > "Simple Layout" checkbox on the first screen - doesn't export all the > splits and just has "-- Split Transaction --" as the description. Also > just has the follo

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David H
I’m a bit surprised that the csv export doesn’t include the txn id and date on the splits instead of leaving them blank though. Cheers David H. On Sat, 24 Dec 2022 at 10:57 am, David Cousens wrote: > Phyllis, > Export Transactions to CSV by default places additional splits on > succeeding > lin

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Phyllis Bruce
Thanks, DC! That information will be helpful to me if I have a need to export to another app. I;ll check it out. On Fri, Dec 23, 2022 at 6:56 PM David Cousens wrote: > Phyllis, > Export Transactions to CSV by default places additional splits on > succeeding > lines. You can force a single line

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David Cousens
Phyllis, Export Transactions to CSV by default places additional splits on succeeding lines. You can force a single line export with the split information on the same line with one of the options in the export dialogue. as David H pointed out. David On Fri, 2022-12-23 at 18:14 -0600, Phyllis Bruc

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread William Prescott
It would be pretty simple to add a column next to the date. Then put a formula in the new column that made it equal to the date in the adjacent column if there was one, and to the date in the preceding line if it was blank. Then sort on the new column. Will On Dec 23, 2022, at 16:26, Dr. David

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Phyllis Bruce
How will thee port handle multiple splits? > On Dec 23, 2022, at 5:07 PM, David Cousens wrote: > >  > Dave, > > Not sure how you achieved that. I just exported one of my accounts and it > appears to be in date order from the first transaction entered (2015) until > the > last (a few days ago)

Re: [GNC] Gnucash on macOS Ventura

2022-12-23 Thread R Losey
Thank you... I think I'll go ahead and update then. On Thu, Dec 22, 2022 at 2:53 PM David H wrote: > Richard, > > Working fine here with the update to 4.13 on Ventura 13.1 > > Cheers David H. > > > On Thu, 22 Dec 2022 at 07:16, R Losey wrote: > >> Which version of Ventura do you have? 13.0, 13.

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David Cousens
Dave, Not sure how you achieved that. I just exported one of my accounts and it appears to be in date order from the first transaction entered (2015) until the last (a few days ago). I haven't checked the whole file but the first and last hundred or so transactions at each end are all in data ord

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David H
Dave, Probably doesn't help but I just did a test export and noticed there's a "Simple Layout" checkbox on the first screen - doesn't export all the splits and just has "-- Split Transaction --" as the description. Also just has the following columns. Cheers David H. Date Account Name Number

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread David H
Dave, Exporting transactions to csv means you get a lot of extraneous crap with it :-) Depending on how much detail you need, it might be easier to run a transaction report, filter on dates required, sort into required order and then copy and paste into LibreOffice ??? Cheers David H. On Sat, 2

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Phyllis Bruce
Ouch. What about copying your date onto each line first? Sounds like it needs major manipulation. I hope someone with experience can help you. On Dec 23, 2022, at 4:26 PM, Dr. David Kirkby wrote:  On Fri, 23 Dec 2022 at 21:39, Phyllis Bruce <[1]pobruc...@gmail.com>

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Dr. David Kirkby
On Fri, 23 Dec 2022 at 21:39, Phyllis Bruce wrote: > I have not used Libre Office much but it is very similar to Excel. Excel > allows me to choose my entire spreadsheet and then sort it in any order - > and on any column I wish. I'd guess Libre Office has that ability. > > For reasons I don't

Re: [GNC] Backups

2022-12-23 Thread David Cousens
Elmar, The storage locations are defined in the following wiki page  https://wiki.gnucash.org/wiki/Configuration_Locations#:~:text=The%20usual%20locations%20per%20OS,to%20as%20%24HOME%20or%20~%2F for all 3 OS types. It just requires copying the files in these locations to a USB or other location.

Re: [GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Phyllis Bruce
I have not used Libre Office much but it is very similar to Excel. Excel allows me to choose my entire spreadsheet and then sort it in any order - and on any column I wish. I'd guess Libre Office has that ability. On Fri, Dec 23, 2022 at 3:25 PM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk>

[GNC] What determines the order of transaction is CSV file?

2022-12-23 Thread Dr. David Kirkby
I exported a list of transactions, then opened them in the LibraOffice spreadsheet. The transactions seem to be in a random order. Since they are split across multiple lines, it would not be possible to just sort them on the date column. I'm sure there must be some logic to it, but I can't see it.

Re: [GNC] UK Flat Rate VAT

2022-12-23 Thread Murugan Muruganandam
Paul The Tax table will not change and will affect the full value in the invoice. You need to create a separate transaction to effect the Flat VAT, by Dr tax payable £2 and Cr income £2 Saludos Cordiales Murugan From: gnucash-user on behalf of Paul W

[GNC] UK Flat Rate VAT

2022-12-23 Thread Paul W via gnucash-user
There's a few posts about this subject but I can't find any that provide a solution. I'd like to know how to account for UK Flat Rate VAT. EgInvoice: £1000+ VAT @ 20%: £200Invoice Total: £1200 Flat Rate VAT @ 16.5% of invoice total is paid to the government: £198The remainder is added to income:

[GNC] How to generate Budget V Actual Report for Profit and Loss

2022-12-23 Thread davidvernonlong
I am trying to report an income statement showing actual against budget. If I select an Income Statement report or a Profit and Loss statement report I see the actuals for the period , but not the budget. If I select Budget Income Statement Report or Budget Profit and Loss statement report

Re: [GNC] "Path Head for Linked Files Relative Paths" - per file setting?

2022-12-23 Thread Glenn Fowler
Meaning this is the only option available. However, I think the best option in your case would be to either use an external HDD or cloud storage that way the links will still work if you have your accountant the drive or they can open the receipt in their browser. On Fri, Dec 23, 2022, 12:51 PM tu

[GNC] Backups

2022-12-23 Thread Elmar Schmeisser
The hard part is backing up all the specialized reports and the online settings, etc. The datafile is easy; the rest is not. On Fri, Dec 23, 2022, 12:00 PM wrote: > > At Fri, 23 Dec 2022 10:34:44 +1000 Daryl Hillgrove < > daryl.hillgr...@gmail.com> wrote: > > > > > Can a simple backup function

Re: [GNC] "Path Head for Linked Files Relative Paths" - per file setting?

2022-12-23 Thread tuuranton--- via gnucash-user
Hi How does that solve anything? If you send your .gnucash file to your accountant/taxman they won't be able to open any files because they're assumed to be in file://C:\Users\\Documents\business1\ and their is likely completely different (assuming they're even on Windows) and additionally a

Re: [GNC] "Path Head for Linked Files Relative Paths" - per file setting?

2022-12-23 Thread Glenn Fowler
Hi TA, You are correct, it is global. What I do is use "Linked Location" instead of "Linked File" and just enter the path. For example: file://C:\Users\\Documents\business1\MyReceipt.pdf On Fri, Dec 23, 2022 at 12:17 PM tuuranton--- via gnucash-user < gnucash-user@gnucash.org> wrote: > Hell

[GNC] "Path Head for Linked Files Relative Paths" - per file setting?

2022-12-23 Thread tuuranton--- via gnucash-user
Hello First, the *question*: Currently it appears the "Path Head for Linked Files Relative Paths" is a global setting applied to *all* .gnucash files. Is there a way to turn it into a *per file* setting? Here is why I want to do this: I have many .gnucash files on my system located at various