Re: [GNC] OFX import date questions

2022-12-30 Thread Adrien Monteleone
That's a matching problem on the import if I recall correctly. You have to fix it there. I've seen threads on the topic, but since I don't use it, the details are not sticky in my brain. If I understand properly, GnuCash *should* be able to match existing transactions and simply set the 'c' fl

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-30 Thread Adrien Monteleone
How do you do that for a posted bill/invoice? Mine is immutable. (and should be) Regards, Adrien On 12/30/22 4:32 PM, Stephen M. Butler wrote: I just modify the account on that one line to point to Postage.  It doesn't seem to hurt any and is a whole lot simpler than trying to enter the whole

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-30 Thread Adrien Monteleone
On 12/30/22 4:29 PM, Dr. David Kirkby wrote: It's actually a bill, not an invoice, but I think they are pretty similar. When I unpost and edit, then look at the register, everything looks okay. Yes, similar code too. Just different terms based on perspective of Vendor vs. Customer. CR: Accou

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-30 Thread Adrien Monteleone
I would only use them for cases where you are billed (incurred the expense) before you pay, not at the same time. Using your postage example: If you pay a company periodically for postage, quite possibly for more than one shipment, or have to take explicit action to pay a bill, use the Busine

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-30 Thread Adrien Monteleone
Glad to know that worked! (and that there isn't another bug to squash) Regards, Adrien On 12/30/22 5:47 PM, Dr. David Kirkby wrote: Thank you. I think that you solved my problem. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Scary moment

2022-12-30 Thread Adrien Monteleone
Where is your data file? Are you using 3 separate physical machines, or are some of these VMs? If you've done various finds, reports, and other searches to eliminate data-entry error possibilities, and since this has happened more than once to the same data, I'm inclined to hazard one more gue

Re: [GNC] Config files?

2022-12-30 Thread Adrien Monteleone
On 12/30/22 8:02 PM, Simon Roberts wrote: Thanks Murugan, that's really useful. First it tells me that I'm using a significantly old release (3.8, from the Ubuntu "built in" stuff). Better fix that, methinks. Are the data files I'm working on in 3.8 going to read directly into version 4, or does

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-30 Thread Adrien Monteleone
On 12/31/22 1:18 AM, Dr. David Kirkby wrote: On Sat, 31 Dec 2022 at 00:13, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I would only use them for cases where you are billed (incurred the expense) before you pay, not at the same time. Why is that? Because that is the p

Re: [GNC] Scary moment

2022-12-31 Thread Adrien Monteleone
Not boring. Well detailed, thanks! It looks like that rules out file-access issues. Okay, last gasp here: For safety, I'd make 2 copies for testing. 1. Update prices via GUI rather than CLI. Check if transactions disappear. Exit, reopen, check again. Since you were running the CLI update on

Re: [GNC] Scary moment

2022-12-31 Thread Adrien Monteleone
Not sure where you saw that odd string. It didn't appear in your last post. Binaries would be stripped off anyway. It must be something with your mail client. Regards, Adrien On 12/31/22 6:56 PM, Robert Kesterson wrote: I don’t know what that content is, but I didn’t knowingly post a binary h

Re: [GNC] One File, Two Users

2022-12-31 Thread Adrien Monteleone
On 12/31/22 2:43 PM, Paul Kroitor wrote: 1. Put the data file in an existing MySQL server in the cloud and allow the MySQL lockout mechanisms to deal with access conflicts; No go. At least if you're considering the MySQL backend. GnuCash doesn't use it except as a store. It reads the whol

Re: [GNC] how to use information of vendor and customer for report as a same person

2023-01-01 Thread Adrien Monteleone
GnuCash doesn't have the ability as of yet to combine Customer/Vendor accounts. The best option I can think of is to create them both as separate entities (customer & vendor) and handle them separately. Where you have cross-over in credits/payments, you'd need to set up an intermediary accou

Re: [GNC] Printing Invoices

2023-01-01 Thread Adrien Monteleone
When you bring up the invoice report from the Reports menu, no invoice is selected, so this is a correct message. The message *should* be giving you a link to click bringing up the General tab of Options, but if not, click the Options button on the toolbar (which should default to the General

Re: [GNC] Crash on account delete

2023-01-01 Thread Adrien Monteleone
First, Welcome to GnuCash! As with most issues, but particularly with crashes, can you provide the version of GnuCash you are using and the Operating System? Now, for some additional detail questions: 1. Did the account you were trying delete contain transactions? If not, was it set as a 'p

Re: [GNC] Crash on account delete

2023-01-01 Thread Adrien Monteleone
On 1/1/23 6:36 PM, Xe Roy wrote: I have the latest version 4.13 downloaded yesterday running on Windows 11 on AMD Ryzen 9 5950x. Thanks for the clarification, and good to know you are up to date. I can't remember if the account I was trying to delete was the placeholder or the subaccount.

Re: [GNC] Crash on account delete

2023-01-01 Thread Adrien Monteleone
I don't know specifically other than there are some issues with 'libraries' on some systems. I've used the SQLite back-end on Linux and currently use it on Mac with no effort. Windows takes some work regardless of choice if I understand correctly. However, if you already have MySQL installed,

Re: [GNC] Trial Balance Report Settings

2023-01-02 Thread Adrien Monteleone
Surprisingly, no, there is no such setting. Many if not most other reports have it. You can file an RFE (Request for Enhancement) at bugs.gnucash.org In the meantime, export or copy/paste the report to a spreadsheet and edit them out from there. Regards, Adrien On 1/2/23 9:51 AM, Benjamin S

Re: [GNC] Invoice emailing?

2023-01-02 Thread Adrien Monteleone
Not that I'm aware of. You could export or print to file for each invoice, then attach the resulting document. This is entirely a manual operation though. You may want to investigate gnucash-cli, but I don't know if the business features are exposed there. A third option may be to script y

Re: [GNC] Invoice emailing?

2023-01-02 Thread Adrien Monteleone
If by 'directly' you mean from 'within GnuCash', no, you can't. Since the customer's e-mail address can appear on the invoice in their info block, you might be able to set up a script, possibly combined with a folder 'watcher' that can automate e-mailing a resulting PDF from printing the invoi

Re: [GNC] Fields present in invoices?

2023-01-02 Thread Adrien Monteleone
The Options allow you to turn some things on or off explicitly, but they are not all-inclusive. You might want to investigate customizing a stylesheet, but that does muck with the workflow to get an invoice report in most cases, resulting in lots of clicks. Using a CSS rule like 'display: no

Re: [GNC] Fields present in invoices?

2023-01-02 Thread Adrien Monteleone
Scheme. See the Wiki development section for links to details of the reporting system. (which isn't much as it is not well documented, for programmers, so far) Regards, Adrien On 1/2/23 8:05 PM, Simon Roberts wrote: Ah yes! I just found Edit->Report Options, which at first glance looks like

Re: [GNC] Fields present in invoices?

2023-01-02 Thread Adrien Monteleone
Not a bug. Most likely a design decision. Not sure how you'd figure out what options to show if you don't know yet which report you want options for... Stylesheets are not peculiar to a certain report. You can edit them independently, then assign them to reports for use. Unfortunately, I don

Re: [GNC] Fields present in invoices?

2023-01-02 Thread Adrien Monteleone
Simon, I'm not sure why this reply from you was not appearing on the list. The server must have had a hiccup. I'm quoting and replying inline below. Regards, Adrien On 1/2/23 9:21 PM, Simon Roberts wrote: Oh... so the fields to show are specific to the invoice? Oh, that's a pity, and we we

Re: [GNC] Fields present in invoices?

2023-01-02 Thread Adrien Monteleone
That's "dialect" of Lisp. (please excuse my fingers not syncing with my brain) Regards, Adrien On 1/3/23 12:15 AM, Adrien Monteleone wrote: Scheme is indeed, a dialog of Lisp. ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] Scheduled transactions

2023-01-02 Thread Adrien Monteleone
Is this just a one-off? I'd just enter the transaction. If it is complicated and you already have an instance in a register, duplicate it. If it hasn't ever occurred, and you don't want to manually enter it, edit to run today, click Actions > Since Last Run to fire it off, then edit to revert

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Adrien Monteleone
Interesting approach concerning modifying the tax invoice. I'd say all of that sounds correct to my understanding as well, save I think you have the Scheme—HTML bit reversed. The files are in Scheme, which generate the report as an HTML table. (not the other way around) I'm pretty sure ther

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 7:08 AM, Dr. David Kirkby wrote: I have the following situation I'm in the UK, where the currency is GBP A customer in Poland paid $540 for consultancy via Zoom. He paid in advance, so I've not added him as a customer under the business features. Murugan answered the main question on

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Adrien Monteleone
I don't think they end up in the same place. I also checked the archive and the message was not there. I only saw it because you also happened to copy me personally. gnucash-user@gnucash.org works gnucash-u...@lists.gnucash.org did not go through. Regards, Adrien On 1/3/23 11:47 AM, Simon Ro

Re: [GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Adrien Monteleone
That is true, but not the reason GnuCash doesn't offer the facility to delete them. (you could edit and change the invoice number, as a work around) Maybe Derek can shed light on the code reasoning. I vaguely recall it being discussed a few years ago, but I long since lost that thread. Since

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 2:43 PM, Dr. David Kirkby wrote: Unless I am mistaken, it is not easy to delete transactions when using the business features. I don't think one can simply delete a transaction and it goes away. You can't delete invoices, but you can remove their entries in your books by un-posting.

Re: [GNC] Clarification of Total (Period) column

2023-01-03 Thread Adrien Monteleone
Hmmm... I'm seeing the same thing. It appears to default to 'this year' regardless of the setting. I'd call that a bug. Regards, Adrien On 1/3/23 3:14 PM, Kalpesh Patel wrote: I have added a column called ‘Total (Period)’ in the accounts view page but I am not sure what that period is? I made

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
It sounds like you are considering your current personal payments as your equity investment as you pay, rather than fronting the money and then using it from there. You should be able to simply: Dr. Expense Cr. Equity:Owner's Capital (or whatever you determine is the best name for that acco

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
Jamie, Please use Reply-List or Reply-All to keep the discussion on the list. I've copied your personal reply below. I'm not sure why that would happen. I just added an Equity account with no issue. Let's be sure we're discussing the same thing. At initially creating a new book with t

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
Strange. Placeholder would stop you from editing or adding transactions in the account, but it doesn't stop me from creating a sub-account. Try creating Owner's Capital as a sub of the parent: Equity instead. Also, what version of GnuCash and what OS? Regards, Adrien On 1/3/23 4:07 PM, Jami

Re: [GNC] Transfer between receivable accounts

2023-01-03 Thread Adrien Monteleone
There's no direct method of transferring balances or payments between AR accounts. (sadly, but GnuCash is not unique in this regard) Some type of intermediary account would be required. (likely, one that is a sub-account of AR so as not to disrupt the overall AR balance) While not as 'clean'

Re: [GNC] Variables in Scheduled transactions

2023-01-05 Thread Adrien Monteleone
Are you using GnuCash 4.13? I just tested this and I only get one prompt. Regards, Adrien On 1/4/23 10:53 PM, Stan Brown wrote: My mortgage payment (say 900.00) is the same each month, but of course every month interest (intamt) is a few cents less and principal (900-intamt) the same few cents

Re: [GNC] beginner bookkeeping question

2023-01-05 Thread Adrien Monteleone
That depends on your setting for Preferences > Accounts > Reversed balanced accounts. The default is 'Credit Accounts' if I'm not mistaken. So in that case, the more you owe, the more positive the liability balance will be. If you set the preference to Income & Expense or None, then 'greater

Re: [GNC] Register column sizing

2023-01-06 Thread Adrien Monteleone
I don't play with it too often these days, but if I do, I won't miss the auto-size or accidentally exposing the price column. Regards, Adrien On 1/5/23 9:40 PM, john wrote: It would be really easy to turn off autosizing on the Description field and only a little work to figure out another way

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

2023-01-06 Thread Adrien Monteleone
Maybe it is used for things other than reports? Regards, Adrien On 1/6/23 5:11 AM, Chris Green wrote: On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote: There is also a setting in preferences somewhere to change the accounting period. As I don't use the feature, I don't

Re: [GNC] Why can't I set 'selcted' accounts for reports permananently?

2023-01-06 Thread Adrien Monteleone
That would depend on the report. For some, it makes sense that GnuCash doesn't know which accounts you want till you tell it. For others, there are sane defaults. (like the Income statement that already has Income & Expense accounts selected) Some reports also behave a tad differently dependin

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

2023-01-06 Thread Adrien Monteleone
No, if you set the period in Preferences, it remembers it. Do a test and set specific odd dates here and run an annual-style report before and after doing so. If you change a report's Options to something other than "beginning/end of this period" which is usually the default for most reports,

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

2023-01-06 Thread Adrien Monteleone
I'll follow up that if you've left the default Accounting Period defined as 'Start of this Year/End of this Year' and you try to run your annual reports in the following year, such as today for 2022, yes, the range will be wrong. As I noted in my other reply, use Saved Report Configs. Get the

Re: [GNC] Request for Automatic Reconciliation Function

2023-01-06 Thread Adrien Monteleone
I understand your explanation, but if you aren't checking and verifying every transaction, how do you ever discover when the automated process makes a mistake? Reconciliation was invented long before computers, but I appreciate that the process demands one to slow down, take your time, and met

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

2023-01-06 Thread Adrien Monteleone
That also happens to be the very FIRST preference overall. First tab of Preferences, first preference. You'd have to really not be looking top-down or in any order to miss it. Regards, Adrien On 1/6/23 3:51 AM, David H wrote: Yeah it's Prefs >> Accounting Period - not sure if that's used by r

Re: [GNC] Sort order not being maintained

2023-01-06 Thread Adrien Monteleone
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 was retained. (I tested with your options of Date, Reverse, & Save) Try 4.13? Regards, Adrien On 1/6

Re: [GNC] Register column sizing

2023-01-06 Thread Adrien Monteleone
That's a good question and one I've had myself. It is even more perplexing when I discovered the registers are based on code from the Gnumeric spreadsheet app. My wild and very limited understanding guess is: That part of the UI didn't get borrowed from Gnumeric, maybe for a good reason. A l

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

2023-01-06 Thread Adrien Monteleone
Then set your accounting period to the desired range or else use Saved Configurations as needed. But do note if you customize the Accounting Period to specific dates, you'll have to change it again next time. The easiest option that requires the least amount of repetitive work is to leave th

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

2023-01-06 Thread Adrien Monteleone
There already is such a preference. It is the very first preference on the first tab. Most reports (certainly annual ones) default to 'beginning of accounting period' and 'end of accounting period'. The OP's issue is that preference by default is 'beginning/end of *this* year, and we're alre

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

2023-01-06 Thread Adrien Monteleone
You didn't like the looks of an invoice so you tried uninstall/re-install? Holy cow. Since you don't specify what about the invoice you don't like, the best I can do is guess: You're not a fan of your duplicated company name and info. That's certainly reasonable. I'm not sure why it would ap

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

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

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 Conf

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 understand

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 2.6.19

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 h

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 enter

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

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

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 wro

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 di

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] 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. The

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 GnuC

Re: [GNC] Sort order not being maintained

2023-01-11 Thread Adrien Monteleone
shouldn't 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,

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 pro

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

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

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

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 up

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

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

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 red

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

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 thos

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

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 ru

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

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 fin

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

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 you're

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

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 m

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 differ

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

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 those

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

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 b

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