Re: [GNC] GNUcash is using 538MB

2022-12-17 Thread Adrien Monteleone
I don't think any such packages are pre-built, and they certainly aren't available to mistakenly download. Regards, Adrien On 12/17/22 12:03 AM, dev...@asia.com wrote: Not sure if this applies to gnucash app, but when I download certain software, I get an option to download standard or debug

Re: [GNC] GNUcash is using 538MB

2022-12-15 Thread Adrien Monteleone
If it is indeed RAM, and it gets worse over time, that is a memory leak, and I'd bet the devs would like to know about it. A bug report would be in order in such case. Regards, Adrien On 12/15/22 6:04 AM, David T. via gnucash-user wrote: I'm guessing you're talking about RAM, though, as this

Re: [GNC] The "purpose of reconciliation" [was: Re: Reconciling PayPal]

2022-12-14 Thread Adrien Monteleone
Ooh! A Can-o-Worms to munch on! (I promise to only nibble) On 12/14/22 4:49 PM, Jim DeLaHunt wrote: On 2022-12-14 02:58, Dr. David Kirkby wrote: My understanding is that the purpose of the reconciliation is to enable one to compare that the balances of two sets of accounts are in

Re: [GNC] Does it matter the other transactions are entered?

2022-12-14 Thread Adrien Monteleone
To each their own, but that seems like lots of work. You can cancel a reconciliation once started, so if you discover transactions are missing, and can't find the data, just start over later when you do. Maybe I'm misunderstanding the issue? Regards, Adrien On 12/14/22 11:09 AM, Dr. David

Re: [GNC] Reconciling credit card

2022-12-14 Thread Adrien Monteleone
Glad to hear that helps! Regards, Adrien On 12/14/22 4:53 AM, Mahon Finbar wrote: "This is essentially a 'reversing' transaction. (which you could enter manually, or via Transaction > Add reversing transaction, with the original expense transaction selected)" Aha, the solution, thank you so

Re: [GNC] Invoice now printing with huge text!

2022-12-13 Thread Adrien Monteleone
property to see an explanation of the differences between size units for choosing the right one for you. (if printing, usually 'pt' is proper, but others can/will work) Regards, Adrien On 12/13/22 12:45 PM, Adrien Monteleone wrote: You might be looking for: Edit > Stylesheets But you can a

Re: [GNC] Invoice now printing with huge text!

2022-12-13 Thread Adrien Monteleone
You might be looking for: Edit > Stylesheets But you can also make changes directly for the invoice header in the report Options on the Layout tab. It appears Row1-Left & Row2-Right have your business info duplicated. (I think this is oddly, the default) Their font and size can be

Re: [GNC] Does it matter the other transactions are entered?

2022-12-13 Thread Adrien Monteleone
David, As noted, the order does not matter, however, there is a quirk. The transactions are listed in the order of entry, for each date. If you have 10 transactions entered for say 2/15/22, that you type in today (with the proper February date) they will appear and will affect the balance in

Re: [GNC] Does it matter the other transactions are entered?

2022-12-13 Thread Adrien Monteleone
If you haven't entered all previous transactions, a reconciliation should be impossible as your records will never match the bank's. That imbalance should be a flag to either track down a data entry error, or missing (or duplicate) transactions. In the case you thought they were all entered,

Re: [GNC] Reconciling credit card

2022-12-13 Thread Adrien Monteleone
I'll second Michael's take on the labels. This thread is a good example of why they aren't so 'friendly'. Sure I'll bet lots of folks use them with no issues, but when something out of the ordinary happens, 'Debit/Credit' (Dr. & Cr. for short) is much more sane and helpful. At least while

Re: [GNC] Reconciling credit card

2022-12-12 Thread Adrien Monteleone
On the contrary, the preference I mentioned could very well show a negative balance and this would be proper. (not contra) Try toggling the preference yourself with a Liability account open and you'll see the balance change from negative to positive. The question is what does the user prefer

Re: [GNC] Reconciling credit card

2022-12-11 Thread Adrien Monteleone
Are you trying to put images inline? They are getting stripped out by Mailman. Just put them in 'as attachments'. (setting in your mail client) Credit accounts normally have a negative balance. If you want to see them as positive change the setting in Preferences > Accounts > Reversed

Re: [GNC] Possible bug - Note added in Transfer window is ignored. Memo shown twice in Accounts

2022-12-11 Thread Adrien Monteleone
There's also nothing special about the Transfer function. You can just do it as a manual transaction between two (or more) accounts. Regards, Adrien On 12/11/22 6:26 AM, Dr. David Kirkby wrote: On Sun, 11 Dec 2022 at 11:19, Fred Bone wrote: Open any account and set View to Double-line and

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Adrien Monteleone
The easier way to approach this is to ask yourself, "what happens in the real world?" Then model that in your accounts and transactions. Thus, do you transmit funds in advance to the PayPal account? If so, make that transaction, with PayPal as an asset (just like another Bank account) then

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Adrien Monteleone
That is not categorically true. Sellers (some at least) have the option to pass on the fees. Not sure if that is relevant to the OP's case, but the possibility does exist. Regards, Adrien On 12/10/22 11:09 AM, Chris Skudder wrote: When you BUY something using paypal, the SELLER pays

Re: [GNC] Overflow menus in invoices/bills not working in latest release on MacOS Ventura

2022-12-09 Thread Adrien Monteleone
John, It sounds like Victor is describing the ToolBar overflow 'menu'. I can get this menu when I narrow my window width such that icons would be 'off window' to the right. But I can't reproduce the behavior described. My overflow entries appear to work properly. (4.12 on Monterey)

Re: [GNC] searching for inventory tags -- bind keys -- best ways

2022-12-06 Thread Adrien Monteleone
I was fairly certain they were immutable, and indeed, at least in 4.12, they are. (if you have a different version and they are, that is a bug) You can't edit memos of splits for posted bills (AP) or invoices (AR). If they are unposted, they don't appear in the respective registers. Note, I'm

Re: [GNC] searching for inventory tags -- bind keys -- best ways

2022-12-06 Thread Adrien Monteleone
, Adrien On 12/5/22 11:13 AM, John Griessen wrote: On 12/4/22 22:27, Adrien Monteleone wrote: Any changes you make otherwise might cause havoc. Changes to memo lines will cause havoc?  Why -- no numbers in transactions are changed by memo lines

Re: [GNC] Same security, two namespaces

2022-12-06 Thread Adrien Monteleone
I thought that has been around since the 2.6.x days. (many years now) Regards, Adrien On 12/6/22 7:07 AM, Stan Brown wrote: (And anyway, my version of GC doesn't have Edit » Find Account.) ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] Same security, two namespaces

2022-12-06 Thread Adrien Monteleone
The method Stan described only works for 'visible' text in that tab. Thus, you need to have the entire chart expanded. (or at least the portion where those accounts exist) Regards, Adrien On 12/6/22 9:06 AM, Fred Tydeman wrote: Edit -> Find Account works fine for finding 'KOF' and 'coca

Re: [GNC] Net Worth Barchart

2022-12-06 Thread Adrien Monteleone
Thanks for the clarification. I think you're on the right track now. Regards, Adrien On 12/6/22 2:55 AM, Liz wrote: Thanks Adrien No I didn't have any reversed balance accounts set and it wasn't the Payroll tax, that was OK. 'Super' is the standard way of pronouncing 'Superannuation' here,

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Adrien Monteleone
Liz, I just ran the chart for myself and indeed, it appears your Liabilities are backwards. That is, if you owe money, they should have a Credit balance, but yours show as Debit balance. (The *normal* balance of a Liability account is Credit, not Debit) What is your preference setting for

Re: [GNC] Same security, two namespaces

2022-12-05 Thread Adrien Monteleone
If you are searching for Accounts and not Transactions use Edit > Find Account. Regards, Adrien On 12/5/22 11:05 PM, Fred Tydeman wrote: Another issue I have noticed: If I change what is being searched from Description to Account, and change Selected Accounts to select some, then there is

Re: [GNC] searching for inventory tags -- bind keys -- best ways

2022-12-04 Thread Adrien Monteleone
I would absolutely *not* edit directly in AR. (I'm surprised they are even editable) If you want to change them, you need to unpost the invoice, edit, then repost. Any changes you make otherwise might cause havoc. If you do not 'consolidate splits on posting' (that's a per invoice or

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Adrien Monteleone
Let's get this cleared up: You're telling us that *all* of your expense accounts are *not* under the top-level 'Expenses' account but exist as each their own top-level account? (but maybe of 'type' Expense) If so, that sounds like an error (I'll hazard, user) in the import. The easiest

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread Adrien Monteleone
If I understand correctly, the AR & AP accounts use them to track links between payments and bills/invoices. If you don't use the Business Features, then those two shouldn't be an issue. I'm not so sure simply using View Lots is how they are activated for an account. Some accounts have none

Re: [GNC] Can I add to Equity?

2022-12-02 Thread Adrien Monteleone
Correct, There's nothing special about the 'opening balance', it is just a regular transaction that you can enter when you set up the account/book. You can always edit or add more transactions just like any other account later. Regards, Adrien On 12/2/22 10:42 AM, Maf. King wrote: On

Re: [GNC] can't create a transaction report

2022-12-01 Thread Adrien Monteleone
Sometimes Check & Repair can take a while, some folks have reported an hour or more in rare cases. It has always been a second or two for me. - Usually when apps close unexpectedly like that, your Mac will generate a Crash Report and show it on screen. (and give you the option to relaunch

Re: [GNC] Shortcut key to today's date

2022-12-01 Thread Adrien Monteleone
It's also always available on the GnuCash website either for separate download in various formats, or to view on the web. I know I looked for key combo info for many months before I happened to stumble on the Help document! (it wasn't installed by default on my machine either) Regards,

Re: [GNC] Shortcut key to today's date

2022-12-01 Thread Adrien Monteleone
It's covered in the Help file along with other ways to increment/decrement the date by set amounts. (day, month, etc.) Regards, Adrien On 12/1/22 8:09 AM, MW via gnucash-user wrote: Thanks. I thought it would be some key combination. ___

Re: [GNC] Carry over losses

2022-12-01 Thread Adrien Monteleone
Those are very much accounting questions, *and* tax advice, not a GnuCash question. Regards, Adrien On 12/1/22 7:40 AM, Fred Tydeman wrote: As a USA taxpayer, how should I record long term and short term carryover losses from stock sales? And, how do I show that they get used up or added to?

Re: [GNC] ANNOUNCE: IRC: irc.gnome.org Alias Changed

2022-11-30 Thread Adrien Monteleone
Thanks Derek, As you could see in the channel, that helped. I notice I had changed the Network Name but not the server. I now have them both as 'irc.gimp.org' and I'm now in the right channel. For anyone else seeing this, I got a bit confused with the various aliases and the page on the

Re: [GNC] can't create a transaction report

2022-11-30 Thread Adrien Monteleone
Do other reports work? If so, the devs may be interested in why this one in particular doesn't. Regards, Adrien On 11/30/22 9:55 AM, ph hermes wrote: today, i started with my file and opened it from there. today i could create a report, but when i went to look at it, i couldn't scroll and

Re: [GNC] can't create a transaction report

2022-11-30 Thread Adrien Monteleone
Hmm... First, since you upgraded, if you didn't already do so, run: Actions > Check & Repair > Check & Repair All If something is off with the underlying data, it could be wrecking havoc with report code as that seems to be the area at issue. Run from the Terminal to see if there is any

Re: [GNC] ANNOUNCE: IRC: irc.gnome.org Alias Changed

2022-11-30 Thread Adrien Monteleone
John, I'm a bit confused. I originally had the network & server name set to irc.gnome.org. I could see activity just fine. I switched the network name to irc.gimp.org as advised, had to re-register my nick, and now the channel is quiet. Am I missing something? Now I see warlord is

Re: [GNC] monthly balance report

2022-11-28 Thread Adrien Monteleone
You could do a Multi-Column report. Place an Account Summary report in one section with just your selected accounts. Place a Transaction Report in another section, again, with selected accounts, sort by Account as PrimaryKey, and play with the Display tab to remove clutter as desired.

Re: [GNC] Should one use Accounts Payable if a vendor is paid immediately ?

2022-11-28 Thread Adrien Monteleone
I was about to reply the same. I've never had an issue in many years of using GnuCash because I start typing a Payee/Payor and Autofill keeps my fingers/brain from flubbing the remainder. If Autofill appears to not be 'responding' as I type someone I've entered many times before, that's a sure

Re: [GNC] can't create a transaction report

2022-11-28 Thread Adrien Monteleone
That's normal. You are 'installing' it, correct? That is, opening the .dmg you downloaded, then dragging and dropping the GnuCash icon to your /Applications folder, then running it from /Applications or via Launchpad or your Dock. (you will likely have to open it twice, the first time is

Re: [GNC] can't create a transaction report

2022-11-27 Thread Adrien Monteleone
Where did you download GnuCash from? The correct location is gnucash.org. It is not in the App Store. Regards, Adrien On 11/27/22 7:43 PM, ph hermes wrote: i installed 4.12 for mac. having same issues. can't create a transaction report. i can open the initial window, choose options, get to

Re: [GNC] Should one use Accounts Payable if a vendor is paid immediately ?

2022-11-27 Thread Adrien Monteleone
Either you use the business features for a transaction or you don't. You can certainly enter a *regular* transaction for any entity, including vendors you normally raise a bill for first, but as noted, those regular transactions won't show up in a Vendor Report. But you can certainly pay

Re: [GNC] importing simple investment account

2022-11-19 Thread Adrien Monteleone
I can't speak to your main question, but significant changes were made to the importer(s) in the 4.x series. If you can run the latest, 4.12, that would be a better start. Regards, Adrien On 11/19/22 8:43 PM, ar wrote: Hi, I am downloading my data in the form of .csv file and I have a

Re: [GNC] Can I export a list of vendors and customers?

2022-11-19 Thread Adrien Monteleone
David, I might stand corrected. I haven't tested this for customers/vendors that don't have transactions, so give it a go and please report back what you find. Try one of the following: (both give the same end result) 1. Reports > Business > Payables Aging/Receivables Aging then Options

Re: [GNC] Can I export a list of vendors and customers?

2022-11-19 Thread Adrien Monteleone
Chris, There is only a Customer Summary (no Vendor Summary) and at best, that can get you a list if you also select in Options > Display > Show Inactive. But I'm not sure it will include Customers with no invoice or payment history at all. (all of mine have history) You might be thinking of

Re: [GNC] Account structure for tracking trip expenses

2022-11-19 Thread Adrien Monteleone
Peter, In line with David's suggestion of using the Action field, you can create your own 'tag' system. Your tags can be placed in Description, Notes (need 2nd line mode to view) Action or Memo fields. You can designate tags with whatever symbol you like, such as '#' or '@' or no symbol at

Re: [GNC] Can I export a list of vendors and customers?

2022-11-18 Thread Adrien Monteleone
Unfortunately no. Regards, Adrien On 11/18/22 12:11 PM, Dr. David Kirkby wrote: Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. ___ gnucash-user

Re: [GNC] Reusing old invoices?

2022-11-17 Thread Adrien Monteleone
I recall an issue not long ago with an uneditable, unposted invoice. I'll check to see if I resolved it and if so, how. (this was an issue with the line-items, the details were editable) Be sure you aren't trying to edit the details directly in the fields on the invoice tab. (I know, that is

Re: [GNC] General journal report: limit to a period of time

2022-11-16 Thread Adrien Monteleone
Sounds reasonable enough. Filing an RFE (Request For Enhancement) at bugs.gnucash.org might be in order. I can see how one might want to know the amounts are zero and show those accounts, but of course, if it is an option... Regards, Adrien On 11/16/22 3:52 PM, Brook Milligan wrote:

Re: [GNC] General journal report: limit to a period of time

2022-11-15 Thread Adrien Monteleone
Rather than run the General Journal report directly, you can filter the General Journal view (Tools > General Journal, then View > Filter by...) then run Reports > Account Report. For more fine-grained control, do an Edit > Find while viewing the Accounts tab, then run Reports > Account

Re: [GNC] Tracking Travel expenses

2022-11-14 Thread Adrien Monteleone
might go either way with some people at different times, I just keep them all under Assets and pay attention to 'normal' or 'reverse' balances. The part of my tree about travel is strictly my own expenses - not on behalf of someone else. Regards, Adrien On 11/14/22 2:27 PM, Adrien Monteleone

Re: [GNC] Tracking Travel expenses

2022-11-14 Thread Adrien Monteleone
I'm not sure there is a 'recommended' method. (and that would be an 'accounting' question anyway) However, I have the following in my account tree: Expenses: -Entertainment: -Travel: -Food -Lodging -Transportation That way I can keep those separate from my 'everyday'

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
That is very odd indeed as now this isn't necessarily a Find Account problem as it is an Accounts Tab problem. Does this only happen after doing Find Account? Now that you know where the account is, can you open it without doing a Find Account first? Regards, Adrien On 11/14/22 12:41 PM,

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
It should not open any account. It should show you in the Accounts tab where in the tree, that account exists, with it highlighted. Then you double click or choose Open on the toolbar to open that account register. Odd that it is opening any account at all from the Find window. Regards,

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
What specifically do you mean by 'work'? Does the window not open at all? Are you using the Edit menu option, or the keyboard shortcut? If the window opens, does it just not find an account you know exists? Regards, Adrien On 11/14/22 9:58 AM, Alan Magnus via gnucash-user wrote: I can’t get

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread Adrien Monteleone
I'm forever locked on Monterey so I can't test, and I don't see that problem with GnuCash, but, I do see it running Firefox on Monterey and Win10, and I get it all over the UI in *buntu based VMs starting with the 22.04 release. I don't know if Firefox uses GTK+ code, but if so (and

Re: [GNC] Credit Note to pay bill

2022-11-07 Thread Adrien Monteleone
That might be a bug and I thought it was fixed in 4.11. If you are using an older version, that would explain it. There was a case where the "I" or "P" were changed to a "?". That field is supposed to be immutable. Clicking it should do nothing. It is for display/info only. Each transaction

Re: [GNC] Credit Note to pay bill

2022-11-06 Thread Adrien Monteleone
Yes. Process Payment for that Vendor. Select both the Jan bill and the credit note. Set the date as desired. Put any note you want. Click 'OK' to commit the payment. The credit note will offset the bill as a payment. You can verify this with a Vendor Report for that vendor and use Options

Re: [GNC] Found a bug, accounts gone haywire.

2022-11-06 Thread Adrien Monteleone
Sounds like an account was deleted and the transactions not moved, or moved somewhere not expected. Regards, Adrien On 11/6/22 9:32 AM, Michael Davis wrote: I was just about to do that and I realized I’d been reading it wrong, the credits do increase the balance and the debits decrease it.

Re: [GNC] Found a bug, accounts gone haywire.

2022-11-05 Thread Adrien Monteleone
Before getting too far in the weeds with other possibilities, I'd caution to closely examine your accounts/transactions first, particularly if you can hazard a reasonable guess as to when you first saw the balance go awry. From near that point, find a transaction with the allegedly correct

Re: [GNC] Invoice Template

2022-11-01 Thread Adrien Monteleone
Yes, any report can be copy/pasted or exported/imported into a spreadsheet app for further manipulation. However, most if not all of what you've described is achievable from within GnuCash. Explore and play with custom sytlesheets for reports. Particularly, play with Edit > Style Sheets >

Re: [GNC] Paying invoices from the edit invoice screen

2022-10-31 Thread Adrien Monteleone
I'm guessing you mean the Transfer Account pane in the bottom right of the Payment dialog. I seem to recall that it defaults to no selection, then to whatever was last used, per customer or vendor. As to why it ever was used for Liabilities in your case, I have no idea. But intentionally

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-28 Thread Adrien Monteleone
No worries Paul, I hope those replies are of some help. Regards, Adrien On 10/28/22 6:42 PM, Paul Kinzelman wrote: Re: The post, and Adrian's reply the next day, both show up here: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/thread.html Oops, sorry, somehow I missed the

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-28 Thread Adrien Monteleone
tackled by the devs first of course, some RFEs either aren't hard to implement, or might interest a developer enough to give it a shot. Regards, Adrien On 10/28/22 12:03 PM, Peter S. Shenkin wrote: On Fri, Oct 28, 2022 at 12:22 PM Adrien Monteleone < adrien.montele...@lusfiber.net>

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-28 Thread Adrien Monteleone
AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: On 10/27/22 2:12 AM, Peter S. Shenkin wrote: Print menu? There is none. Then what would you call the window labeled Print that appears when you enter Ctl-P from a Report?___ g

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-27 Thread Adrien Monteleone
You found all the right places for the settings, but are the accounts of the right 'type'? When you Edit an account, the Type is in the bottom left pane. I would think auto-interest would need to be of type 'Bank' and the auto-payment would need to be of type 'Credit Card'. **I'm pretty

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-27 Thread Adrien Monteleone
On 10/27/22 2:12 AM, Peter S. Shenkin wrote: Hi, I don't think it is possible to create the "hanging paragraph" view from the Options menu, if one is displaying one transaction per line. At least, I could not find a way. That's why I said: >> Funny, the way to do that with the Transaction

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
Arthur, if you aren't seeing many messages a day from 'gnucash-user@gnucash.org' then, no, you aren't subscribed to the list. But your messages to it are getting through. If people happen to reply-all to your posts, then you get their messages, but if they reply-list then you don't. To fix

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Yes, I think a clarification would be useful in the interim til the option is fixed. Regards, Adrien On 10/26/22 7:53 PM, Vincent Dawans wrote: Yes it is indeed a simplified example I was using. And your second example is the one that indeed I show as working (the one with all expense

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
It could just be that you're providing a simplified example, but in that screenshot I noticed every single line had the Checking Account as the 'Transfer' account. (other account) Why not just run the report on the Checking Account only? It would then give you a running balance that makes

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
Arthur, I'm copying you directly this time in addition to the list, not sure if you are subscribed to the list. (If not, you won't see replies sent only to the list that don't include you in the CC field) - You might find it much easier to just invoice monthly as normal and send a

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Nope, the first one came through the list just fine. Regards, Adrien On 10/26/22 4:24 PM, Vincent Dawans wrote: [Ooops I think I messed up my reply to/cc mix, so trying again -- still new to this mailing list thing] ___ gnucash-user mailing list

Re: [GNC] The meaning of Running Balance in Transaction Report: bug or enhancement request?

2022-10-26 Thread Adrien Monteleone
Perhaps a clarification as you mentioned would be best and easiest for now. I'd dare ask, if you're sorting primarily by date, with multiple accounts selected, what do you want the running balance to be? Just those accounts? (is that even useful?) Or the entire Book? Any of those could get

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-26 Thread Adrien Monteleone
On 10/26/22 1:58 PM, Peter S. Shenkin wrote: Thank you for the suggestion about General Journal. I like the way the Account Report is formatted; namely, in "hanging paragraphs" with the first split, only, labeled with the Description. This makes it easy to discern the boundaries between

Re: [GNC] invoicing

2022-10-26 Thread Adrien Monteleone
One trick I've heard works wonders from someone who has used it: Don't *just* charge a late fee. Bymp your rent to *include* the (former) late fee and still list the late fee. Then offer a discount (removing the original late fee) for early payment. For example: Current Rent $1000 Current

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-26 Thread Adrien Monteleone
You may be also interested in viewing the General Journal (Tools menu). This defaults to 30 days, but you can use View > Filter by... and change that to 'all'. (or your desired date range) Then run Reports > Account Report. You'll get a similar report with all transactions for all accounts

Re: [GNC] Total and Grand Total at the end of a Transaction Report

2022-10-25 Thread Adrien Monteleone
The Subtotal in this case is for one month. It represents the net (credit in this case) balance *for the chosen accounts* over that period. (you could have set subtotal by account first instead of date first) The Grand Total is the net debit/credit over the entire report range - *for those

Re: [GNC] invoicing

2022-10-25 Thread Adrien Monteleone
You might find it easier to invoice monthly sending that first. Then send a Customer Report each following week, which will reflect payments, and thus the amount outstanding, automatically. That would significantly reduce the effort on your part, and the number of invoices in your system.

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread Adrien Monteleone
You can turn it off. Some may have and forgot. And I'm not sure when that was added. It may not have been available for 2.3.4. That version was never intended to be used regularly. It was a development/testing version only. Though such a file or files might be in the OPs data directory,

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread Adrien Monteleone
By 'backup' we don't mean something you do within GnuCash, we mean something you do with your entire computer/personal files. If you never make backups of any of your files, or only rarely, then I guess you're stuck rebuilding data if you can't recover this file. (this would be the case with

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-19 Thread Adrien Monteleone
Unlikely, but you might get lucky. (You really don't have *any* backup at all? Really? You've been using a decades old version of GnuCash and you never make backups?) Note, the GnuCash file, by default unless you changed it, is a compressed XML file. Uncompressed, it is just plain text and

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-19 Thread Adrien Monteleone
Indeed, if you were truly running 2.3.4, you'll need to step to a 2.4.x version, then a 2.6.x version, then 3.x, then 4.12, running Actions > Check & Repair > Check & Repair All when first opening the file after each upgrade, and of course ideally, keeping backup versions each step along the

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Adrien Monteleone
The problem with advertising 'inclusive' sales tax is, except in limited circumstances, usually impossible. This is because in many jurisdictions, there are taxes that scale with the amount of the total purchase, or on the day of the purchase (tax holidays anyone?) or even who the buyer is,

Re: [GNC] Slow migration

2022-10-15 Thread Adrien Monteleone
Please forgive me if this is too non-specific and generalized, I'm sure someone else who's made the MSmoney –> GnuCash migration can lend assistance (there are threads from the past on this subject, so it has been done) but I'll offer some general considerations and ideas. #1 Can MSmoney

Re: [GNC] Follow up on Gnucash invoicing and payment - questions on process

2022-10-14 Thread Adrien Monteleone
As far as I know, that exact report doesn't exist in GnuCash, but there are various ways to see this information. #1 Invoices Due Reminder This is a dialog window, not a report. (and sadly no way to get that data to a report as far as I know.) It shows the Invoice, Customer, Date Due &

Re: [GNC] Sub-Accounting (Was: Problem with missing balance in a parent account **FINAL POST**)

2022-10-13 Thread Adrien Monteleone
I agree. Some years ago, there were a few threads here that delved into various means of implementing an envelope method in GnuCash and my personal take-away was, while it can be done, the only sane method is lots of work. (you mention a not so sane method, or rather, one that could quickly

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
Abe, please remember to reply-all or reply-list that way others can benefit from the conversation, and may be able to help where I can't. - You should be able to edit everything in a spreadsheet app with ease. Every report is just an HTML table, so it has cells with labels and data which

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
I forgot to add, if you go the CSS route (or use CSS customizations before going to a spreadsheet) you'll want to focus on learning the basics of headings, fonts, colors, and tables. That should be sufficient for working with GnuCash reports. (there might be a few others, but this will get you

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
While you *could* learn Scheme or Guile and craft our own version, these are presentational details, and can more easily be handled by other means. #1 - Options > General Report name - This allows you to change the report name. Note for this report, the entire displayed name is 'Report

Re: [GNC] Creating/Modifying a Budget Report

2022-10-10 Thread Adrien Monteleone
Can you describe the modification? What you want to change might make a difference in the offered possible solutions and ideas. Regards, Adrien On 10/10/22 11:07 AM, Abe Sternberg wrote: I have been using GnuCash for about a year and am not a very sophisticated user.  I am the treasurer for

Re: [GNC] Mac Installation 4.12 issue

2022-10-09 Thread Adrien Monteleone
Dragging .app packages from a .dmg to /Applications (or ~/Applications) is standard for all MacOS apps not installed by the AppStore. It is not particular to GnuCash. Many Apps have made a handy /Applications shortcut in their .dmg main folder to prompt the user to do so, but that is not

Re: [GNC] Saved report configurations

2022-10-07 Thread Adrien Monteleone
are viewing. 'Save Config As...' saves the current config as a *new* config, and you get to name it. There are also Reports menu items for both actions, and keyboard shortcuts for both. (though similar save for one extra key - so be careful!) Regards, Adrien On 10/7/22 7:42 AM, Adrien

Re: [GNC] Saved report configurations

2022-10-07 Thread Adrien Monteleone
You have to set your mail app to 'attach' rather than pasting the images within the text. (known as 'inline') The mailman software that this list runs on will strip out inline images, but does allow attachments. A usually more robust method is to store the images on a 3rd party site and

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-07 Thread Adrien Monteleone
Thanks Geert for the correction & clarification. I think you've had to set me straight more than once on that point. I'm not sure why I have it stuck it my head. Apologies. Regards, Adrien On 10/7/22 2:18 AM, Geert Janssens wrote: That's not a GnuCash restriction. You can have multiple.

Re: [GNC] CoGS on Income Statement

2022-10-07 Thread Adrien Monteleone
On 10/6/22 8:35 PM, Jared Squires wrote: I'm trying to find a way to implement the Cost of Goods Sold in the Income Statement. Right now I have it as it's own Expense Top Level Account but it messes up my Income Statement for my actual Gross Profit. How does it 'mess up' your statement for

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-06 Thread Adrien Monteleone
On 10/6/22 1:59 PM, Charles Vincent wrote: Hello Gnucash users list members, I come back on the issue of invoicing clients and payment by the clients or a third party. As background: For info, I am keeping the accounts for a small not for profit school in Cambodia. I have done the 70 invoices,

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, It looks like you want the chart here: https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux 1. /home//.local/share/gnucash 2. /home//.local/share/gtk-3.0 3. /home//.config/gnucash 4. /home//.config/gtk-3.0 One of those four directories should have the file you are looking for.

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
Glad to hear you don't need to reinstall the entire system! Now, to troubleshoot the OneDrive problem... I don't use it, so sorry if I can't be of further help, but I'm sure others here on the list do and might be able to assist. Search the list archives for 'OneDrive' and you might find

Re: [GNC] Saved report configurations

2022-10-06 Thread Adrien Monteleone
It looks like you were putting screenshots inline rather than as attachments. Those images did not come through, so we can't see what you are referring to. Your saved configuration should be under: Reports > Saved Report Configurations. You'll then get a pop-up with a list of your saved

Re: [GNC] Reconciling subaccounts

2022-10-06 Thread Adrien Monteleone
Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for

Re: [GNC] Troubleshooting and/or database repair

2022-10-06 Thread Adrien Monteleone
If you try to add a transaction with a split to a non-existent account, do you get the option to create that account? If so, and you choose to create it, does the new-account window show up? And one additional 'environment' question: Is this a local file, or stored on an

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Adrien Monteleone
David, The Wiki FAQ has a section on file locations. I don't have the exact answer off-hand, but I'm sure one of those locations has what you are looking for. (allegedly, there are no other places used by GnuCash) Regards, Adrien On 10/6/22 8:49 AM, David Carlson wrote: Where are the

<    4   5   6   7   8   9   10   11   12   13   >