Re: [GNC] Exporting reports to spreadsheet

2023-03-29 Thread Adrien Monteleone
George, You created the circle. Skip adding/changing the extension entirely. Just export, then open the file *from* Calc. (double-clicking will most likely use your default HTML editor, whatever that may be, or even a web browser) Regards, Adrien On 3/29/23 11:11 AM, George Riner wrote:

Re: [GNC] Should I upgrade or update?

2023-03-27 Thread Adrien Monteleone
Because there are some issues pushing updates to it. The alternate address is up to date: https://code.gnucash.org/website/ Regards, Adrien On 3/27/23 10:50 AM, Dennis West wrote: Go directly to the sourceforge page and search for gnucash. You'll find all the download links there.  I don't

Re: [GNC] Should I upgrade or update?

2023-03-27 Thread Adrien Monteleone
The website still isn't getting updates. You have to go directly to SourceForge or use the alternate web address: https://code.gnucash.org/website/ Regards, Adrien On 3/27/23 10:45 AM, Dr. David Kirkby wrote: On Mon, 27 Mar 2023 at 14:45, Derek Atkins wrote: Version 5 was just released

Re: [GNC] Error in "Close Book" help text

2023-03-25 Thread Adrien Monteleone
Aha, good to know Stan, thanks! Regards, Adrien On 3/24/23 6:43 PM, Stan Brown wrote: Thanks, Adrien. I started at then followed "Q: I think I found a bug. How do I report it?" to . From there I searched the bug

Re: [GNC] Error in "Close Book" help text

2023-03-24 Thread Adrien Monteleone
When you first click 'New' or 'File a Bug', you get the option to select Documentation. (see screenshot) I'm not sure if you can move it after filing, but if not, one of the devs can do that for you. Regards, Adrien On 3/24/23 4:05 PM, Stan Brown wrote: "Documentation" doesn't seem to be an

Re: [GNC] Reporting Woes - Newbie incompetence

2023-03-24 Thread Adrien Monteleone
If the Transaction Report can't get you what you want, consider an Account Report. You could filter any register to show just the transactions you are concerned with. If the filters are not quite nuanced enough for you, or if you want multiple accounts in one report, then craft a Find set

Re: [GNC] Reporting Woes - Newbie incompetence

2023-03-24 Thread Adrien Monteleone
I haven't tested other apps, but both LibreOffice Calc & Apple Numbers can either open the exported file directly as it is just an HTML table, and both accept copy/pasted reports though either or both methods may pop up a dialog for handling column widths, delimiters, special characters, etc.

Re: [GNC] Modify Balance Sheet report in 4.13?

2023-03-24 Thread Adrien Monteleone
I don't see that you can as an option, but you can remove the Equity total. Fortunately those cells have classes, so you can hide them with CSS using the CSS stylesheet: .total-label-cell, .total-number-cell { display: none; } Regards, Adrien On 3/23/23 6:01 PM, Stan Brown wrote: I'm

Re: [GNC] Error in "Close Book" help text

2023-03-24 Thread Adrien Monteleone
Maybe file a documentation bug for tracking? Regards, Adrien On 3/23/23 6:06 PM, Stan Brown wrote: In 4.13, the Close Book help text, which is the Close Book section of the installed manual, includes the following text under "How It Works", as the second paragraph under "Necessity": "In fact,

Re: [GNC] Two versions, same computer

2023-03-21 Thread Adrien Monteleone
Maybe I missed something, but you decided on 2 options: 1. Install both versions if possible side-by-side, or use VirtualBox for 4.13 2. Upgrade so you only need one version. That second option was as simple as: -Make a copy of your file (should always exist anyway) -Install 3.11 & Open your

Re: [GNC] Outstanding / due invoices report?

2023-03-20 Thread Adrien Monteleone
Wow, after nearly 10 years of bills and invoices, that somehow escaped me, thanks! Regards, Adrien On 3/20/23 12:49 PM, Murugan Muruganandam wrote: Adrien Please see the screenshots where you have to enter the description at invoice level (Bills level). Notes will not be reflected in your

Re: [GNC] Outstanding / due invoices report?

2023-03-20 Thread Adrien Monteleone
Current shows documents posted which have not reached their due date. (non-posted documents are not reported) The Aging columns are for Past Due documents. Regards, Adrien On 3/20/23 6:36 AM, Simon Roberts wrote: 2) In the report it has a row across the bottom listing "current", "0-30 days"

Re: [GNC] Outstanding / due invoices report?

2023-03-20 Thread Adrien Monteleone
There is also a Report option to show linked documents with or without full detail. This allows you to see which payments have been applied to which bills/invoices. (and the reverse: which bills/invoices offset each payment) That might be a bit messy visually to send a customer, but I find it

Re: [GNC] Outstanding / due invoices report?

2023-03-20 Thread Adrien Monteleone
How did you get the Description to populate? Where did you put that text in the Bill/Invoice or Edit Bill/Invoice window? There was a recent thread on this subject. This report cell grabs text from the Notes field of a relevant transaction, and that works for Payments, but Bills & Invoices

Re: [GNC] Reuse Credit Note as Invoice

2023-03-15 Thread Adrien Monteleone
There's no way to do it in the GUI, I can't speak for manually editing the file. Regards, Adrien On 3/15/23 1:03 PM, Morgan Read via gnucash-user wrote: Hi Folks, Is it possible to reuse a Credit Note as an Invoice - I have a few spare, created but not used and would like to get rid of them

Re: [GNC] Please help

2023-03-14 Thread Adrien Monteleone
Your work is unlikely to be gone. By default (unless you changed it) there is a preference set to periodically save the file. The lock file issue is because either GnuCash crashed, or you shut down the computer without closing the app first. Open the app, (choose 'open anyway' if you like,

Re: [GNC] Schedule transaction for 2 Wednesday?

2023-03-13 Thread Adrien Monteleone
bottom of the list that makes it pretty clear that there are options below. On Fri, Mar 10, 2023 at 7:27 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I wouldn't pull the RFE though, but instead re-word it to improve the UX for better discoverability. If at first you see a

Re: [GNC] Schedule transaction for 2 Wednesday?

2023-03-10 Thread Adrien Monteleone
Apologies and thanks! I too did not scroll far enough. I wouldn't pull the RFE though, but instead re-word it to improve the UX for better discoverability. If at first you see a partial list of nth days of a month, it isn't intuitive to keep scrolling to see the other options. One would only

Re: [GNC] Transaction Report Overlaps Page Breaks

2023-03-10 Thread Adrien Monteleone
I usually have to Export, then open with a web browser and either Print to PDF or to a printer from there. Regards, Adrien On 3/10/23 12:37 PM, p...@kroitor.ca wrote: Hi all. Not for the first time I've run across an issue in which printing the Transaction Report (at least - there may be

Re: [GNC] Schedule transaction for 2 Wednesday?

2023-03-09 Thread Adrien Monteleone
I don't think you can. The closest method I can find is to set the first instance to the second Wednesday then set frequency to 28 days, or 4 weeks. But of course, that will sometimes fall on the first Wednesday. The workaround there is to set it for remind and review without auto-creation

Re: [GNC] Business Features: How to put info in "Description" field of a vendor's Bill?

2023-03-09 Thread Adrien Monteleone
Unfortunately, you can't. That field is populated from the Notes on payment transactions as you have discovered, but the Notes field from a bill do not auto-fill into the AP register Notes field on that transaction, and once it is there (by posting it) it is immutable and you can't edit it.

Re: [GNC] Confusing version numbers

2023-03-07 Thread Adrien Monteleone
That was until 3.x This is covered in the Wiki: https://wiki.gnucash.org/wiki/Release_Process#New_Major.2FMinor_Version and the release schedule is here: https://wiki.gnucash.org/wiki/Release_Schedule Regards, Adrien On 3/7/23 7:30 PM, LI Daobing wrote: I thought gnucash is somehow

Re: [GNC] Confusing version numbers

2023-03-07 Thread Adrien Monteleone
For each set of numbers, they run sequentially, without leading zeros. 9 is less than 12. How is that confusing? It isn't '90' and '12' It is '9' and '12'. Until 3.x, minor odd versions (like 2.7) were used for 'beta' or 'unstable'. That was changed to x.90x. This gives plenty of room for

Re: [GNC] credit account negative balance increases with payment

2023-03-06 Thread Adrien Monteleone
As I noted above, with the 'Reverse Balance' preference set to Credit Accounts, a balance due on a Liability will show as positive. Negative will only display if you've overpaid. (a 'contra-balance' condition) Payments therefore would make a Liability balance more negative (away from zero).

Re: [GNC] credit account negative balance increases with payment

2023-03-06 Thread Adrien Monteleone
No. That shows a 'contra condition' as negative numbers. The normal balance for a Liability (when you owe someone else) is a Credit balance. GnuCash represents Credit balances as negative numbers. If you have 'reverse balance' set to Credit Accounts, than those accounts will only show

Re: [GNC] The custom invoice problem

2023-03-05 Thread Adrien Monteleone
Simon, this change is coming in 5.0 (and maybe 4.14?) due out at the end of March. You will be able to set a Saved Configuration as the default for invoices. The beta version should already include this change for testing. (version 4.902) Regards, Adrien On 3/5/23 2:35 PM, Simon Roberts

Re: [GNC] Manually edit pmt info (reverse a payment) for a vendor?

2023-03-02 Thread Adrien Monteleone
Start over if you want, but editing and re-assigning payments is a simple enough process. If you want to go that route instead (or find you need to do it again) then say so and we can help. Regards, Adrien On 3/2/23 12:07 PM, Eric Chapman wrote: I think I have a plan: I will just start the

Re: [GNC] Any way to "unpay" (reverse payment of bill)?

2023-03-02 Thread Adrien Monteleone
In addition to Derek's options, you can leave the payment after unposting the bill, and then from a register containing that payment (usually the source account), right-click and choose 'Assign as Payment' where you can then edit the date, as well as change, if desired, which bill it applies

Re: [GNC] No longer receiving the e-mail from the user group

2023-02-25 Thread Adrien Monteleone
You may either be able to whitelist the list address, or set a filter to run before junk filtering and file list messages in their own folder. This may or may not have to be done on both the server and your local client depending on your setup. Regards, Adrien On 2/24/23 9:30 PM, kschneider

Re: [GNC] Migrating from PC to Mac

2023-02-18 Thread Adrien Monteleone
, Adrien On 2/18/23 10:00 PM, Adrien Monteleone wrote: I have not tried using iCloud or any other non-local storage for my data file (I consider a 'LAN' as 'local') but this *might* be an issue with Gatekeeper and permissions to access other storage locations. I recall being pestered by MacOS when

Re: [GNC] Migrating from PC to Mac

2023-02-18 Thread Adrien Monteleone
I have not tried using iCloud or any other non-local storage for my data file (I consider a 'LAN' as 'local') but this *might* be an issue with Gatekeeper and permissions to access other storage locations. I recall being pestered by MacOS when it was implemented to approve of various

Re: [GNC] Migrating from PC to Mac

2023-02-18 Thread Adrien Monteleone
Martin, You've got your answer about the data file, but preferences and any Saved Report Configurations (special animals) are a different matter. Those should be addressed by the Wiki if you look in the FAQ for backup/file locations. If you copy over those files respectively, you should be

Re: [GNC] Customer Summary without the Pre-payment-Current-..-Total Table

2023-02-18 Thread Adrien Monteleone
My Customer 'Summary' does not show such a block. My various Customer 'Reports' however, do. And as far as I can tell, there is no official preference to turn it off. One option might be to export of copy/paste the report to a spreadsheet before printing and remove it. Another option

Re: [GNC] importing

2023-02-18 Thread Adrien Monteleone
Gyle, You may be 'stuck' with having to just manually check those off during reconciliation this one time. They are already in your books, so the import failure is just a matter of auto-clearing them. It only takes a few seconds to either click them as cleared before reconciling or clicking

Re: [GNC] Feature Request

2023-02-15 Thread Adrien Monteleone
Indeed, I see that now. I need to switch back to contacts! These glasses are terrible. Regards, Adrien On 2/15/23 1:26 PM, Maf. King wrote: On Wednesday, 15 February 2023 19:14:06 GMT Adrien Monteleone wrote: Third, with respect to your actual request, what do you mean by "Unrecog

[GNC] MacOS installation procedure & upgrade path from 2.6.x, was: Re: gnucash.org is down -- for how long?

2023-02-15 Thread Adrien Monteleone
Libby, From the Applications folder, right-click Gnucash.app and choose 'Open'. The MacOS Gatekeeper will likely ask you if you are sure you want to open it as it was downloaded from the internet. Confirm that you do. It may or may not then open the app. But if not, simply double-click the

Re: [GNC] Feature Request

2023-02-15 Thread Adrien Monteleone
Ron, First, when you want to start a new topic on the list, just send a new e-mail to the list address rather than replying to an existing message. Even though you changed the subject, it can get threaded as a reply to that previous message, and may get 'lost' in the shuffle, or at least

Re: [GNC] Net Income & Retained Earnings do not match

2023-02-14 Thread Adrien Monteleone
David, it's a gnucash file. But Murugan figured out the discrepancy. Regards, Adrien On 2/14/23 11:34 AM, David Carlson wrote: What document type is that attachment? If it isn't something my computer can scan for viruses, I won't open it. ___

Re: [GNC] Is GnuCash.org down (Monday, 2/13/2023, 7:20PM PST)

2023-02-14 Thread Adrien Monteleone
There are some issues with the website the devs are aware of but can't yet fix. (has to do with limited access rights) The list server, wiki, bugzilla & github should all be working however. Regards, Adrien On 2/14/23 11:18 AM, Ken Pyzik wrote: Tuesday 2/14/2023 at 9:15PST- GnuCash.org is

Re: [GNC] Saved Report Configurations

2023-02-13 Thread Adrien Monteleone
I do the same. I have general configurations saved, but anything particular to that solitary instance of the report, I do not save as part of the configuration. Those will be one-offs so no need to save them as a config, just run and if I want, save as a PDF. Regards, Adrien On 2/13/23 8:18

Re: [GNC] GC cannot make backup file

2023-02-09 Thread Adrien Monteleone
Certainly not a GnuCash problem, but I'd hazard a guess to set up a Scheduled Task to periodically copy over your GnuCash files to the X drive, keeping them somewhere else. That way, the sync never steals ownership while in progress as the file doesn't appear there till the Task puts it there.

Re: [GNC] Report question

2023-02-09 Thread Adrien Monteleone
Eric, When starting a new topic, rather than replying to an existing one, simply send a new message to the list address. Otherwise, it might not get noticed. -- As to your specific question, I'm not sure how you're dividing up your Ordinary & Exceptional expenses. GnuCash doesn't have

Re: [GNC] Transaction regex help

2023-02-08 Thread Adrien Monteleone
Also, do you not split your receipts by line item? That would make this a cinch. Regards, Adrien On 2/8/23 4:10 AM, Michelle wrote: I think part of my problem may be that in the transaction filter, the account name may not be included as part of the comparison, but even then if I try various

Re: [GNC] Transaction regex help

2023-02-08 Thread Adrien Monteleone
Is this for a Transaction report? Simply don't include that account in the Accounts tab of the report Options. Regards, Adrien On 2/8/23 4:01 AM, Michelle wrote: I've been bashing my head against this for a while. I'm after a grocery report, so I want everything that I buy from Sainsburys,

Re: [GNC] Entry of unknown transaction

2023-02-07 Thread Adrien Monteleone
This might be a timing case. There are different ways to handle it, some just ignore it, but one method is to employ an 'undeposited funds' account for checks you receive into a book that have yet to be deposited and cleared as an intermediary account. This allows you to show a receipt date,

Re: [GNC] Can't get to my download

2023-02-07 Thread Adrien Monteleone
On Windows, your 'My Downloads' folder is usually a sub folder of your user directory, unless you've specifically changed it. Regards, Adrien On 2/6/23 10:30 AM, Phyllis Bruce wrote: Windows 10, Gnucash Version 4.13 I've downloaded a bank's transactions as a QFX and I can find it in my

Re: [GNC] Can one add notes / memos / whatever to reconciled transactions?

2023-02-07 Thread Adrien Monteleone
Unfortunately, the transactions for bills/invoices cannot be even annotated after posting. Your option is to: unpost - edit notes, repost However, in the case of the payment transaction - that *should* be editable (from the Bank Account) with no issues. The expense account will not be

Re: [GNC] How do I Upgrade from 2.6.12 to v4?

2023-02-01 Thread Adrien Monteleone
I could be mistaken, but I think the main reason for upgrading to a final minor release before each major jump is simply for backwards compatibility if needed. But if you're proceeding with a backup at each stage (which should be the case anyway) then one could just revert to a backup and try

Re: [GNC] Issuing a credit to customer

2023-01-30 Thread Adrien Monteleone
Gyle & Robert gave the proper answer, but for completeness, you'd issue a Credit Note when you need to issue a refund, or you need to create a credit for reason other than a pre-payment. (which is your current case) The Credit Note, if needed, can be 'paid' with an actual refund, or simply

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Adrien Monteleone
Reconciliation verifies that: Opening Balance + *listed* transactions = Ending Balance That is all. Sometimes, banks don't clear transactions in the same period they were submitted. It appears in this case, it cleared an entire period late. You were able to reconcile June & July because the

Re: [GNC] Deleting split, specifying one expense account [FIXED]

2023-01-30 Thread Adrien Monteleone
Strange, I do this often, and just did it today, though I admit I don't use the 'delete split' option from the context-menu, I just tab-delete my way through till I get to a split I want to keep. Regards, Adrien On 1/28/23 3:22 PM, Rich Shepard wrote: That's the way it worked in the past.

Re: [GNC] how-to track refinancing and other cost related to it.

2023-01-30 Thread Adrien Monteleone
Same way as on paper. Both of those are expenses. There may be a way to do that with sub-accounts though. I think some folks use an 'accumulated depreciation' sub-account to not affect the main asset account for that item. The same might be possible with the financing expenses, but are

Re: [GNC] Deleting split, specifying one expense account [FIXED]

2023-01-28 Thread Adrien Monteleone
You need to have at least one 'anchoring' split to that register. If you have more than one split for that account, it will make you keep the first one, but you can delete the others. Regards, Adrien On 1/28/23 10:35 AM, Rich Shepard wrote: On Sat, 28 Jan 2023, Rich Shepard wrote: This

Re: [GNC] GnuCash: What scheduled transactions can't do

2023-01-28 Thread Adrien Monteleone
And there is the option to review them in their own register. Also, there *is* a 'Value' column in the SLR dialog, but I think it is for variables, not certain. Regards, Adrien On 1/28/23 1:57 PM, Fred Bone wrote: On 28 January 2023 at 9:55, Kalpesh Patel said: Not able to see the amount

Re: [GNC] Scheduled Transactions Window Sorting

2023-01-28 Thread Adrien Monteleone
As for the SX list on the SX tab, I did get it to stick after an exit and restart, best I can tell. But I have a very short list (5) and one of those is inactive. I'm not sure what the reference was towards 'still open windows' as the sort order didn't magically change if I clicked on a

Re: [GNC] coalesce the stock accounts in the report

2023-01-26 Thread Adrien Monteleone
Saved reports are HTML tables. Any spreadsheet app should be able to open them properly. Exactly how would depend on that app. Otherwise, you can run the report, Select All, Copy, Paste into a new spreadsheet. Regards, Adrien On 1/26/23 2:07 PM, Mattia Rizzolo wrote: Could you please tell

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-26 Thread Adrien Monteleone
Fred, see my last reply before this one. I was able to reproduce this issue using an exchange rate *other* than 1:1 with Trading Accounts turned off and trying to pay the bill in a currency other than the one the bill is denominated in. (in this case, trying to pay a USD bill with GBP)

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-26 Thread Adrien Monteleone
Dave, First off, let's get this out of the way: I noticed in your last screenshots, the window title bar is included with a 'Reconciled ...' file name. Name your file whatever you want, but I can imagine that will get tedious as time goes on to keep renaming the file. (but I suppose if

Re: [GNC] how to create monthly revenue and expense report for just one year

2023-01-25 Thread Adrien Monteleone
There is also: Reports > Experimental > Income Statement (Multicolumn) *this will be moved out of 'Experimental' for version 5.0 and into the regular reports menus. (I think it doesn't handle multi-currency very well, yet...) In the report Options > General tab, set Period Duration to 'One

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-25 Thread Adrien Monteleone
I'm not saying this is particularly necessary, (I'm not sure myself) but just for completeness of information: Do you have Trading Accounts turned on? Regards, Adrien On 1/25/23 1:29 PM, Dr. David Kirkby wrote: I have some issue with some non-GBP transactions showing as outstanding if I look

Re: [GNC] Is there any way to find all outstanding bills?

2023-01-23 Thread Adrien Monteleone
The Bills Due Reminder is not just short term, it should show all unpaid bills *that are posted*. (in conjunction with setting the reminder window via Preferences > Business > Bills > Notify when due & Days in advance.) You can also do Business > Vendor > Find Bill and set the criteria to

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Adrien Monteleone
On 1/23/23 2:33 PM, flywire wrote: that isn't the latest, nor official documentation. No, it's not but it is the version I recommend. Feedback on how it compares with the official version would be useful. The official documentation should always be the recommendation. It is actively

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Adrien Monteleone
For completeness, Once you have the report in the spreadsheet app of choice, you can then save/export from there as CSV if that format is otherwise still needed. Regards, Adrien On 1/23/23 11:32 AM, Phyllis Bruce wrote: Oops, never mind. Found good instructions on Chrome.

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Adrien Monteleone
Ann, that isn't the latest, nor official documentation. For that, see https://gnucash.org/docs.phtml (the Documentation link from the left-hand menu under either Downloads or Support) There is the 'Help' and the 'Tutorial & Concepts Guide'. Both should be accessible from the Help menu when

Re: [GNC] Weird MacOS UI issue with windows cutoff on bottom and right

2023-01-20 Thread Adrien Monteleone
Indeed, that works, thanks! Regards, Adrien On 1/19/23 4:04 PM, John Ralls wrote: This problem was subsequently documented in https://bugs.gnucash.org/show_bug.cgi?id=798728 and https://gitlab.gnome.org/GNOME/gtk/-/issues/5535. I've fixed the problem and uploaded a new dmg to SourceForge

Re: [GNC] Importing csv files

2023-01-18 Thread Adrien Monteleone
Welcome to GnuCash! I'm not sure there is any single discussion on this outside of what you'll find in the documentation. There are plenty of list threads on the topic in general, but most of them deal with a specific aspect, issue, error, etc. 'Best Practice' is to export small chunks and

Re: [GNC] Invoices processing with Shopify payments?

2023-01-18 Thread Adrien Monteleone
You can get line-item detail using invoices, just uncheck the option to 'consolidate splits' when posting. There is also a default preference. Without consolidating, you get to see each of the line items on an invoice in any affected register. You don't get price or qty data though unless

Re: [GNC] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

2023-01-17 Thread Adrien Monteleone
On 1/17/23 10:00 AM, Dr. David Kirkby wrote: That would require a *lot* of accounts, but I guess it makes it blindingly obvious what the items are. I was hoping to try to automate the depreciation with the Scheduled Transactions in GnuCash. I've not used them yet, but I assume that it would be

Re: [GNC] A bug or not ? - Windows shuts down with no warning of GnuCash running.

2023-01-16 Thread Adrien Monteleone
It *might* be a GnuCash bug, but of course, others would need to confirm this behavior. That seems more like a facility of Windows than something for which GnuCash is responsible. And as noted, fixing it only applies to clean OS shutdowns/reboots. Nothing catches the case of a power outage,

Re: [GNC] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

2023-01-16 Thread Adrien Monteleone
Chris & Michael have both offered sound advice. I'll add towards your question of individual item tracking, simply create sub-accounts under Assets:Fixed Assets for each one, and the parent Fixed Assets should be empty. And no, they don't belong under Equity, they are Assets. The other side

Re: [GNC] Invoices processing with Shopify payments?

2023-01-16 Thread Adrien Monteleone
Etienne, Unfortunately, the current Process Payment dialog does not facilitate other splits in the transaction, such as a payment fee. Enter the payment without it as if you had received the full amount. Then from the receiving register (Bank, Undeposited Funds, etc.) edit the payment to

Re: [GNC] Scheduled Transactions Window Sorting

2023-01-14 Thread Adrien Monteleone
I find it is sticky regardless of the column used for sorting. I've tested each one, close and reopened the tab, and also closed and reopened the app entirely. 4.13 on MacOS Monterey. - I wonder if this is related to the sticky sorting in register problem some others are seeing? Are

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone
I seem to recall having done that once or twice too! Regards, Adrien On 1/14/23 12:37 AM, David T. via gnucash-user wrote: Thanks. I did a little testing, trying both your suggestion and Stan's. Both seemed to have the same result: I was only prompted once. I suspect that "formula-izing" the

Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone
I had the same problem and I think I solved it by making all of the variables part of a formula, so your transaction would look like: DB Checking TOTALAMT*1 CR Asset TOTALAMT*1 CR Income A TOTALAMT*1 DB Income B TOTALAMT*1 Regards, Adrien On 1/13/23 10:48 AM, David T. via gnucash-user wrote:

Re: [GNC] exporting from gnucash to Excel

2023-01-12 Thread Adrien Monteleone
Do a list search on this topic. I'm pretty certain someone has a solution already worked out. I recall several threads over the last 2 years or so about this. Apologies, but I don't use this myself, so I can't comment further. Regards, Adrien On 1/12/23 8:05 AM, Paul W via gnucash-user

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-12 Thread Adrien Monteleone
Careful folks. This is now way beyond 'how to do this in GnuCash' and very much knee deep in realms that require (several) special pieces of framed paper hanging on walls. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-12 Thread Adrien Monteleone
Thanks for the trip down Memory Lane, Michael. I had long forgotten the 'Owes/Trusts' origin of the system. I think many things are much easier to understand when you find out 'why they are'. Learning the basics of the 'old days' helped me to grok Debits & Credits many moons ago. Regards,

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-12 Thread Adrien Monteleone
It is intuitive, but your issue is one of perspective: From *your* perspective, your bank account is your asset. You increase it *in your books* by a Debit. But from the *bank's* perspective, your account with them is their liability, and is increased by a Credit. That is why when you put

Re: [GNC] Sort order not being maintained

2023-01-12 Thread Adrien Monteleone
Please don't forget to 'reply-all' or 'reply-list' to keep the discussion on the list. -- By *per account* I don't mean per book, I mean *per account*. That is, if you sort your checking account register one way, you can sort your credit card another. The sort order can be customized for

Re: [GNC] Why is this entry "in and out"

2023-01-12 Thread Adrien Monteleone
I'm not following exactly, but I'm guessing this is Interest paid to you? If so, the entry should be: Dr. Savings Cr. Income Just change the Opening Balances account to a relevant Income account. Regards, Adrien On 1/12/23 8:27 AM, Mahon Finbar wrote: Hi, I have an account for a savings

Re: [GNC] Sort order not being maintained

2023-01-12 Thread Adrien Monteleone
On a whim I just exited and restarted GnuCash and it did retain the 'standard' sort order I last set. (just as it did the first time I tested it) I'll chalk up the reversion to the crash. Note, that sort order is *per account*. Regards, Adrien On 1/12/23 2:37 AM, Dr. David Kirkby wrote: Il

Re: [GNC] Sort order not being maintained

2023-01-12 Thread Adrien Monteleone
Reasonable enough. It was a crash after all. Regards, Adrien On 1/11/23 11:13 PM, David Carlson wrote: I think that register sort order, register window size/column widths, memorized reports, open report window details and memorized CSV import settings all only get saved when doing a manual

Re: [GNC] Sort order not being maintained

2023-01-11 Thread Adrien Monteleone
expect such prefs to persist after a crash... Regards, Adrien On 1/6/23 9:28 AM, Adrien Monteleone wrote: I just tested using 4.13 on Mac. It works properly there. I tested closing the register I sorted, then re-opening. I then tested closing GnuCash and re-opening. In both cases, the sort order

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-11 Thread Adrien Monteleone
+1 Regards, Adrien On 1/11/23 6:29 PM, Stan Brown wrote: How would you do it in a pen-and-ink ledger? The answer is the same for GnuCash. So many people seem to be under the impression that GnuCash does accounting ion its own special way. It's much more helpful, in my opinion, to think of

Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-11 Thread Adrien Monteleone
For completeness and posterity, that would be: Dr. Assets:Bank Dr. Expenses:Tax Cr. Assets:Fund If you're ever unsure as to what the 'formal' column labels would be, you can always toggle Preferences > Accounts > Labels > Use formal accounting labels while viewing a register in question.

Re: [GNC] GnuCash 4.900 Released

2023-01-10 Thread Adrien Monteleone
On 1/11/23 12:37 AM, Fred Tydeman wrote: On Tue, Jan 10, 2023 at 8:11 PM john wrote: In the case of the Fedora 26 system it won't even let him connect, probably because it doesn't have TLS 1.3 and Flathub (rightly) refuses to connect. Is there a way to update to a later version of TLS? Not

Re: [GNC] Billing terms / payment due x days from the end of the month

2023-01-10 Thread Adrien Monteleone
If using the Business Features and raising Bills for that Vendor, then set up terms either in the Vendor, or per Bill. (there is a separate Terms editor) When you first create the Bill, if that Vendor has set terms, that will be populated by default, otherwise you can set it in that initial

Re: [GNC] gnucash on debian

2023-01-10 Thread Adrien Monteleone
Anne, I don't have it available at the moment, but I recently spun up a vm running Mint MATE and did some GnuCash testing in it. GnuCash installed with zero difficulty. (MATE *is* Gnome anyway, albeit using Gnome's old codebase kept alive.) Regards, Adrien On 1/9/23 6:10 PM, Anne Possoz

Re: [GNC] ASSETS

2023-01-10 Thread Adrien Monteleone
You *do* want and must have both a Dr. & Cr. in those transactions. Since these are assets, you'll Dr. to increase them. The Cr. side will be Equity:Opening Balances. Regards, Adrien On 1/10/23 10:24 AM, davidbrown.r...@photos.bozeat.biz wrote: Thank you Michael for your reply it is a

Re: [GNC] GnuCash 4.900 Released

2023-01-10 Thread Adrien Monteleone
I thought one of the points of Flatpaks were that they didn't require the base system to match the software being installed. If the software needs it, Flatpak will bring it in just for that app. (it won't change the base system to a different DE or WM) I could be mistaken of course. Regards,

Re: [GNC] GnuCash 4.900 Released

2023-01-09 Thread Adrien Monteleone
Lots of great improvements already and I'm sure more to look forward to. (some new reports too!) But of the list so far, my money is on this one getting the most sighs of relief and smiles: "The description field quickfill in the register now displays a drop-down list of possible

Re: [GNC] reconcile dates

2023-01-07 Thread Adrien Monteleone
Is this an account of type Credit Card by chance? Regards, Adrien On 1/7/23 6:08 PM, Kevin T via gnucash-user wrote: OK.   getting that off the plate. When i do a reconcile, change the date to the previous reconcile datae, and the balances match, with no manipulations, when I click the finish

Re: [GNC] reconcile dates

2023-01-07 Thread Adrien Monteleone
Another alternative: Import one month Reconcile Repeat - But I'll add another case for including later transactions: -For whatever reason, you entered them for a later date than they really occurred. If they aren't visible, you'll think they are missing and then enter them againor

Re: [GNC] Will adding a transaction dated earlier than the last reconciliation cause a problem?

2023-01-07 Thread Adrien Monteleone
Yes, the principle of Materiality. It isn't worth spending time looking for small errors. Just adjust them out and move on. Otherwise, I'd say enter the transaction on what you think is the proper date and re-reconcile. But that begs the question, how did you reconcile without it? If you

Re: [GNC] Variables in Scheduled transactions

2023-01-07 Thread Adrien Monteleone
Glad to hear you got it squared away. I'm not sure if this has to do with my SX preferences, but I no longer get a pop-up window for variables. There is an entry field in the Since Last Run dialog to enter them. (which I have to Tab out of to commit) That may have been implemented after

Re: [GNC] Budget report fails in multiple currencies

2023-01-07 Thread Adrien Monteleone
As long as the change in value isn't cumulative, I would want to know. If I wanted to budget the same 'purchasing power' as last period/year, I would not want to budget the exact same nominal amount. (on that note, a feature to factor inflation for budgets would be swell!) But I do

Re: [GNC] Where do I set the "Accounting Period" for reports?

2023-01-07 Thread Adrien Monteleone
On 1/7/23 3:41 AM, Chris Green wrote: I really don't want or need to save reports, it's just one more bit of configuration that I'd need to keep track of. I want things to be configured in as few places as possible. Unfortunately, that's as few steps as you can get right now. Note, Saved

Re: [GNC] Is a screwed-up style sheet hiding somewhere?

2023-01-07 Thread Adrien Monteleone
On 1/7/23 8:29 AM, Dr. David Kirkby wrote: It’s difficult for me to comprehend why that fancy template in that form should exist at all. I don’t think anyone could consider it sane. I reported it a bug https://bugs.gnucash.org/show_bug.cgi?id=798717 and see it has been closed with a note that

Re: [GNC] Budget report fails in multiple currencies

2023-01-06 Thread Adrien Monteleone
Christopher Lamm had been working on various aspects of the Budget Report not long ago. He may be able to squeeze in a look at this. He'll likely be the one to see your bug report and maybe shed light on the math logic. If I can find some time this weekend I'll test as well. I normally don't

Re: [GNC] Is a screwed-up style sheet hiding somewhere?

2023-01-06 Thread Adrien Monteleone
Fair enough. I see you managed to clear it up with a registry edit. I did manage to get a similar looking invoice to yours by default though. That was via Reports > Business > Fancy Invoice. The other options of Easy, Printable, & Tax Invoice are more sane looking. You can change the

<    2   3   4   5   6   7   8   9   10   11   >