Re: [GNC] How should I enter values on a budget in gnucash ?

2024-05-24 Thread Adrien Monteleone
Daniel, The Budget module needs lots of testing. Some changes were made (not sure at what release) to sort out issues with negative signs and the book preference for 'reverse balanced accounts.' I used to use this module quite a bit, but about that time, I fell behind and haven't gotten

Re: [GNC] [gnc] Forecasting savings

2024-05-22 Thread Adrien Monteleone
There is a budget module. Otherwise, you can use scheduled transactions, or just enter transactions in advance and run relevant reports. As the real-world transactions happen, edit those already entered to reflect any differences. If you want to preserve the prediction vs. actual, you might

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone
PDFs that are images are almost always scans of physical paper without an OCR step. Though, I'm sure some 'printers' take the image route rather than create a proper PDF. (Portable Document Format) Regards, Adrien On 5/20/24 7:43 PM, David G. Pickett via gnucash-user wrote: PDF pitfall: some

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone
Does this answer your question?:https://askubuntu.com/questions/1263902/how-to-quickly-modify-cups-pdf-printer-output-folder-setting If not, you can set bookmarks to other locations in that file dialog. While this won't change the default, it would just be one extra click on the bookmarked

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Adrien Monteleone
Any reason not to use CTRL+A? Regards, Adrien On 5/19/24 9:08 PM, Joseph Keithley wrote: If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse

Re: [GNC] Finance-Quote 1.62 released!

2024-05-16 Thread Adrien Monteleone
Bruce, et al, Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! Thank you for the insane amount of effort you put forth on this project. I have yet to use (or profit) from all of it, but

Re: [GNC] Use of cash discounts in business account tree

2024-05-16 Thread Adrien Monteleone
I am no accountant, but that doesn't sound quite correct. If you put the Cash Discounts account under Expenses, then that would be a contra-account as it reduces the price of your expenses you pay the wholesaler. So that credit is correct, but I don't see that there should be a debit to your

Re: [GNC] Unable to Refine Existing Search

2024-05-15 Thread Adrien Monteleone
The Transaction Report has a Filter option that takes simple text as well as a Regular Expression. Regards, Adrien On 5/14/24 2:24 AM, Patrick Skelton wrote: I realise what I am really wanting here is a custom report but I need it to contain only records containing a certain string and I

Re: [GNC] How to transfer customer and vendor information from a previous GNUCash file?

2024-05-15 Thread Adrien Monteleone
Please remember to hit reply-all or reply-list so others can participate and benefit from the discussion. - While you can't delete an Invoice/Bill, you can reuse them. When I end up in such a situation, I change the document ID to "Use Next" so I can find it easily, and then simply edit

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Adrien Monteleone
Please read over my original reply again. I gave you the transaction templates that illustrate what you are looking for. Step 1 is recording the accrued expense. This should be dated when the expense was incurred. (when service rendered) Step 2 is entering the Vendor Bill which accomplishes

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Adrien Monteleone
That's only if you do everything manually as you describe. You could also use the Business Features to enter the Accountant's Invoice (Bill) to you, and then enter a payment to clear it. The line item(s) of that Bill, would connect to your Accrued Expenses account, though admittedly, not

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-14 Thread Adrien Monteleone
A confirmation dialog that the Check & Repair was completed (maybe even with or without incident or a summary) would be nice to have, but I know the devs already have a full plate. Perhaps file an RFE (Request For Enhancement) in the bug tracker if that one doesn't already exist. Regards,

Re: [GNC] How to transfer customer and vendor information from a previous GNUCash file?

2024-05-14 Thread Adrien Monteleone
As far as I am aware, there is no means within GnuCash to export/import Business Features setup data such as Customers, Vendors, Employees, or Tax Tables. You can import Invoices/Bills from a CSV, (such as data generated by another app) but you can't export them. (outside of running relevant

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-14 Thread Adrien Monteleone
This is essentially a basic accounting question, not so much 'how to do this in GnuCash.' The exact accounts used are up to you, but generically between an accounts such as: Dr. Expenses:Professional Services Cr. Liabilities:Accrued Expenses When the invoice is received, draw down the

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread Adrien Monteleone
I think there were issues too with reports on Linux with NVIDIA graphics though there is a workaround and if I'm not mistaken, now also a fix. Regards, Adrien On 5/12/24 6:03 PM, Paul Kroitor wrote: You're on a Linux platform so it won't directly matter, but be aware that the Windows 5.5

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-11 Thread Adrien Monteleone
Correct. The Check & Repair should run silently automatically upon first opening your file with 5.5, but it doesn't hurt to do it intentionally. The biggest change I recall between 4 & 5 is the new type-ahead search method for the Description field. I personally prefer the change, but some

Re: [GNC] [resolved] Re: no drop-down accounts list in ledger Transfer column.

2024-05-09 Thread Adrien Monteleone
You're welcome. Though, I don't think those AppImage builds are from the GnuCash development team. Caution is advised. Regards, Adrien On 5/9/24 5:59 AM, v@scottsonline.org.uk wrote: On 09/05/2024 01:16, Adrien Monteleone wrote: Any opposition to using flatpak? You wouldn't have

Re: [GNC] [resolved, sort-of] Re: no drop-down accounts list in ledger Transfer column.

2024-05-08 Thread Adrien Monteleone
Any opposition to using flatpak? You wouldn't have to wait. Regards, Adrien On 5/8/24 3:18 AM, v@scottsonline.org.uk wrote: That could explain things. Unfortunately, I can't (readily) install 4.13 on mint - even the latest mint 21.3 has libraries too old for the deb's off the website. But

Re: [GNC] no drop-down accounts list in ledger Transfer column.

2024-05-07 Thread Adrien Monteleone
Hmm.. it has been many moons since I made the move from 3.x to 4.x, so I don't see an obvious preference either. But perhaps toggle the: Preferences > Register > Actions > Auto-raise lists checkbox and see if that helps. If not, note as I mentioned, you should still be able to type through

Re: [GNC] no drop-down accounts list in ledger Transfer column.

2024-05-06 Thread Adrien Monteleone
4.x introduced a better 'type ahead search' in that field if I'm not mistaken, which could be why you see a discrepancy between 3.8 & 4.8. You can still use the old method either directly by typing the beginning of the full account path with separators like before to speed things up, or just

Re: [GNC] Account Hierarchy

2024-05-03 Thread Adrien Monteleone
Thanks Stan, I've bookmarked for future reference. Regards, Adrien On 5/3/24 9:50 PM, Stan Brown (using GC 4.14) wrote: https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix ___ gnucash-user mailing list

Re: [GNC] Account Hierarchy

2024-05-03 Thread Adrien Monteleone
There is another, simpler, option, such as: Sales and that's it. If you're using the Business Features and will be creating Invoices for your sales, then the invoice line items will contain the individual product sales data. (you also might have separate sub-accounts under Assets:Inventory

Re: [GNC] Printing Reports: Income and Expense Line Chart

2024-04-30 Thread Adrien Monteleone
What version of GnuCash and what OS? I just created a PDF output via the 'Print to File' option in landscape just fine using GnuCash v5.5 on MacOS Monterey v12.7.4. Regards, Adrien On 4/30/24 8:02 AM, Tom Balazs wrote: Right now I'm struggling with the Income and Expense Line Chart. I want

Re: [GNC] Finance::Quote on a Mac with a foreign perl

2024-04-26 Thread Adrien Monteleone
John, I have Homebrew installed. I'm not familiar with @INC, but happy to learn. I just ran gnc-fq-update without issues. I still have the output from that update if you need it, or if you need output from any other commands, just let me know. I'm still on GnuCash 5.5, my Perl is 5.30 and

Re: [GNC] Please address broken QIF import

2024-04-25 Thread Adrien Monteleone
What do you find about dropping to an earlier release, not 'straightforward'? It is a simple matter of removing the current release, and installing the older one. (I believe on Windows systems, you can safely just install the older release as the installer will do the in-place replacement for

Re: [GNC] Is anyone else getting these malicious e-mails?

2024-04-15 Thread Adrien Monteleone
So far, nothing like that has come across the wire to me. Regards, Adrien On 4/14/24 9:57 PM, Michael DeBusk wrote: I've gotten two or three obviously-malicious e-mails pretending to be from this mailing list. The From: line lists the sender as "Gnucash User" but the address is not this one. I

Re: [GNC] how to find open invoices

2024-04-14 Thread Adrien Monteleone
Business > Customer > Find Invoice Set criteria to: Is Posted?, unchecked You can of course add other criteria to refine the search. Regards, Adrien On 4/13/24 10:07 PM, tburmas wrote:     I often have invoices that are open (in progress) that are not ready to post.  Is there a way to see

Re: [GNC] Zorin os

2024-04-10 Thread Adrien Monteleone
The distro does not matter. (with perhaps some caveats concerning dependencies) While you technically can jump from 2.6.21 to 5.6 (current version), that isn't officially supported, nor recommended. See the Wiki FAQ about upgrading procedures from one major version to another. (In this

Re: [GNC] I'm looking at installing GnuCash but has a couple of questions first

2024-04-09 Thread Adrien Monteleone
Mac comes with screensharing built in. No need for a separate app. Some linux distributions also include VNC apps by default, or they can easily be installed. Regards, Adrien On 4/9/24 3:23 PM, G R Hewitt wrote: Also Teamviewer runs on a MAC too.

Re: [GNC] Recording transactions (date)

2024-04-09 Thread Adrien Monteleone
You 'paid' when you 'tendered' the payment. (tender isn't just an offer of payment, but includes acceptance/receipt, which has happened in this case. It does not include cashing/depositing or otherwise processing a negotiable instrument that was tendered as payment.) How you handle the

Re: [GNC] Recording transactions (date)

2024-04-08 Thread Adrien Monteleone
While there are other considerations, such as cash versus accrual and following the Recognition Principle, I see this as more of a general case of Your Books vs. the Bank's Books. You keep Your Books. The Bank keeps theirs. You then reconcile the two. (which does *not* involve changing

Re: [GNC] gnucash-devel list down?

2024-04-08 Thread Adrien Monteleone
An announcement posted on 4/2 came through for me. And while you can get to it here: https://lists.gnucash.org/mailman/listinfo/gnucash-devel The archive link returns a Not Found. Regards, Adrien On 4/7/24 8:50 PM, Michael or Penny Novack wrote: I have received nothing from that list since

Re: [GNC] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone
The name of the class for #2 is just: .register-primary Though I don't know if you can add padding to it or not. (which is where the GTK Inspector comes in handy) Regards, Adrien On 4/1/24 2:31 PM, J R via gnucash-user wrote: I read all the wiki many times plus other sources 1. This

Re: [GNC] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone
See this wiki page: https://wiki.gnucash.org/wiki/GTK3 I'm not sure how to run the inspector on Windows. Perhaps some other users here can help. There are plenty of threads on CSS in the list archives. Maybe one of them describes the Windows process. Without it, you're just shooting in the

Re: [GNC] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone
Are you using the GTK Inspector? It provides a sandbox to play with rules to see their effect and then you can put them in your CSS file. Keep in mind, not every element in the UI is exposed or even addressable for styling. Regards, Adrien On 4/1/24 6:34 AM, J R via gnucash-user wrote: I

Re: [GNC] Find account

2024-03-30 Thread Adrien Monteleone
That only works if the account is visible and not in a collapsed part of the tree. Regards, Adrien On 3/30/24 12:03 PM, Stan Brown (using GC 4.14) wrote: While in the Accounts pane you don't need to "use" anything. Just start typing a part of the name you're looking for. (It doesn't need to

Re: [GNC] Segmentation fault while importing invoice data

2024-03-30 Thread Adrien Monteleone
See the wiki about crashes and bug reports. Take a look there as well about getting a Tracefile, then file a bug with the crash report and tracefile as attachments. (The Tracefile may or may not contain relevant info) You don't mention your OS by the way. Regards, Adrien On 3/30/24 10:56

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-03-30 Thread Adrien Monteleone
GnuCash 5.6 should be out tomorrow with F::Q 1.59. Regards, Adrien On 3/29/24 10:32 AM, David G. Pickett via gnucash-user wrote: Yes, but as I went to flatpak to get a later release, it is discouraging that it fails to get updated for newer releases of Finance Quote and for all I can tell,

Re: [GNC] Updating gnucash

2024-03-27 Thread Adrien Monteleone
David, I could be mistaken, but I thought that the 'All' function negated the need to be viewing the CoA when running it, and that the non-All function operates as you describe. (context aware) Good tip about the task manager. Sometimes the process is so fast, you aren't sure if it

Re: [GNC] Gnucash Frozen

2024-03-27 Thread Adrien Monteleone
Anytime you have a problem, please report the GnuCash version and Operating System you are using. As for the issue at hand, my first guess is a hidden window has input control, but your OS allows you to scroll other 'background' windows. (I know MacOS and some Linux distributions can do this,

Re: [GNC] Updating gnucash

2024-03-27 Thread Adrien Monteleone
In addition to the advice given by the other replies, it is advised to run Actions > Check & Repair > Check & Repair All when first opening a file after an upgrade between major releases. These checks and repairs are supposed to run automatically, but that doesn't always go smoothly or

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-03-26 Thread Adrien Monteleone
David, What makes your messages that contain quoted material difficult to read is your e-mail client doesn't indicate they are quoted, so it all appears as your new message. There is also some wacky formatting going on. That isn't the mailing list software, that is your client as the

Re: [GNC] Can't enter expense transactions after migrating

2024-03-21 Thread Adrien Monteleone
Are you 'TAB'ing through the transaction or attempting to 'ENTER' through the transaction? ENTER *commits* the transaction and could possibly generate the warning/dialog you mention. TAB is the documented method for moving from one field to the next without committing the full transaction,

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-11 Thread Adrien Monteleone
Here's the bug link: https://bugs.gnucash.org/show_bug.cgi?id=799248 Your attachment seems to be a printed version of the report, rather than an HTML 'export'. (Use the Export button on the toolbar, don't try to 'print to file') I'm spinning up a VM with 4.8 to confirm. As of 5.5 at least,

Re: [GNC] Bill total does not match real total

2024-03-11 Thread Adrien Monteleone
I'm not sure if it is still entirely open source, but it started that way. I think they've added on features that are closed. (some may simply be built with Odoo itself) The base package is still available as far as I'm aware, and it is pretty powerful, but likely overkill for most small

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-11 Thread Adrien Monteleone
Account Name sharing a class that makes it non-obvious what to change. Regards, Adrien On 3/11/24 5:30 AM, Chris Green wrote: On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote: Chris, Once again, look into Edit > Stylesheets. For the record, I'm using defaults, and the

Re: [GNC] Max value during year

2024-03-11 Thread Adrien Monteleone
You can take that same report and copy/paste into a spreadsheet, then set up a MAX() function in another cell to look at whatever column. (Balance, I would presume in this case) Some spreadsheet apps have a configurable 'stats' bar at the bottom that can show preset analysis, such as MIN,

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
You can certainly set that as a style in Calc. Regards, Adrien On 3/9/24 9:01 PM, Robert Heller wrote: I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
Neal, You are welcome. But please remember to hit 'reply-all' or 'reply-list' rather than just 'reply' so everyone on the list benefits and can participate in this discussion. Individual users may not always be able to help fully with any issue or question, others may have better answers

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-09 Thread Adrien Monteleone
You can certainly do so. The exact work flow can vary depending on your precise needs. I don't often have very long transactions (30 or more items) but it does happen a few times a year. I frequently have transactions with at least 5 or so 'splits'. I'd recommend experimenting with either

Re: [GNC] Separating tax years for payments in next year

2024-03-09 Thread Adrien Monteleone
Why not create a transaction for the appropriate year between tax expense and tax payable? Dr. Expenses:FederalTax Cr. Liabilities:FederalTaxPayable Then when you actually pay, Dr. Liabilities:FederalTaxPayable Cr. Checking (or whatever source account) That way, the expense shows up for

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-09 Thread Adrien Monteleone
Liabilities and Accounts Payable are not Equity type accounts so they don't belong there. They both are of type 'Liability' generally and belong in that part of the tree, but specifically, the Accounts Payable account is the special type 'Accounts Payable' in the GnuCash Edit Account dialog.

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as

Re: [GNC] Importing Reports into LO Calc

2024-03-08 Thread Adrien Monteleone
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook.

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-08 Thread Adrien Monteleone
Chris, Once again, look into Edit > Stylesheets. For the record, I'm using defaults, and the is 12pt bold and the lines are 10pt normal weight. The total lines match the . Regards, Adrien On 3/8/24 3:41 AM, Chris Green wrote: Maybe I have set something somwhere without knowing it but

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-08 Thread Adrien Monteleone
But XAU no longer works with Alphavantage at least. GC=F (SI=F for silver) works fine. Regards, Adrien On 3/7/24 10:50 AM, Kalpesh Patel wrote: Oh! XAU symbol is indeed named Gold in Currencies name space which seems ... ___ gnucash-user mailing

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-06 Thread Adrien Monteleone
That is installed by default in Ubuntu for many years now. I would suspect the same is true of its various flavors. Regards, Adrien On 3/6/24 4:17 AM, Alan Hopkins wrote: You just need CUPS-PDF installed as a print driver for producing pdf files.

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-06 Thread Adrien Monteleone
Chris, LibreOffice uses Draw for PDF editing, not Writer. That doesn't mean the text isn't text. Everything is essentially in various text boxes. But having used it quite a bit, I can attest it is way more of a pain for large edits than either HTML or using Calc. For a small change though,

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
Yes, those PDFs are indeed reasonably editable. Even LibreOffice can pull it off. Otherwise, your answer is to either edit the HTML (which is the native format of the reports once rendered) or put them in a spreadsheet which relieves you of the HTML and leaves you with rows and cells that are

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
You can also select-all and copy/paste into a spreadsheet while viewing any report. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I

Re: [GNC] How to get a report in a format which is easy to edit?

2024-03-05 Thread Adrien Monteleone
The standard export/save of reports is an HTML table. You can edit that with any decent text editor, and/or open/import it into a spreadsheet app for further manipulation. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of

Re: [GNC] How can I book Sales when invoice is paid vs when posted?

2024-03-05 Thread Adrien Monteleone
On 3/4/24 11:34 PM, Blake Hannaford wrote: 1) At end of year, figure out the total dollar amount of unpaid invoices. Check the Receivables Aging Report. This should give you the total you want. 2) Create a new Income account "unpaid sales" 3) Debit sales by the unpaid total and credit

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
You could employ custom 'tags' for each property either in the Notes, Action, Num, Memo, or Description fields, whatever works best for you. Then when you run a Transaction Report, you can filter the results that match your tag. The only downside to this method, at this time, over setting up

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
Your example doesn't really need the business features. You can do that with a single transaction too, and that isn't 'kludging' the memo fields at all. That is what they are intended to be used for—info relating to just that particular split. ('Notes' would be info relating to the transaction

Re: [GNC] Reports Options: Unexpected Behavior

2024-03-04 Thread Adrien Monteleone
When the income statement is first run, it is including the hidden account. (but is not supposed to) Toggling the radio button is apparently 'fixing' this to work as intended. Therefore since the initial behavior is not as designed, I'd call it a bug. I just tested this on a Mac and it is

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Adrien Monteleone
Combined with the other suggestions of an outside log file, using vendor bills, or using the Notes field, consider this: If you are advised of work as it occurs, record transactions between the expense accounts and a liability account named something like "Work Payable". Put your detail in

Re: [GNC] split transaction description field length limit

2024-03-03 Thread Adrien Monteleone
That log file can also be attached to the transaction in GnuCash. Also, explore using View > Double Line as that exposes a Notes field for the entire transaction. Regards, Adrien On 3/3/24 7:08 PM, Jim DeLaHunt wrote: I suggest a workaround: write in separate log document your detailed

Re: [GNC] Multiple Fiscal Years

2024-03-02 Thread Adrien Monteleone
I'm still not understanding what change you are referring to. In both 4.x and 5.x you can set your Accounting Period to a relative date or an absolute date such as Jul 1 2024 to Jun 30 2024 and when you run reports, choose relative dates such as 'Start/End of Accounting Period' or 'start/end

Re: [GNC] Multiple Fiscal Years

2024-03-02 Thread Adrien Monteleone
Wow, an accounting period of 54 years? I'm not sure I'd ever need to do so, but glad to know it works! Regards, Adrien On 3/2/24 12:26 AM, Geoff wrote: Maybe I am missing something here, but I created a book with a start date of 1-Jan-1970 and an end date of 31-Dec-2024, keyed transactions

Re: [GNC] Multiple Fiscal Years

2024-03-01 Thread Adrien Monteleone
What do you mean this was removed? I'm on 5.5 and I still see Relative & Absolute Accounting Period settings. Regards, Adrien On 3/1/24 4:45 PM, flywire wrote: With Gnucash V5 current year with a configurable day/month/year was removed and hard-coded as calendar year. Alternatives: 1.

Re: [GNC] reports

2024-03-01 Thread Adrien Monteleone
The 'best' is up to you to figure out based on your needs and what you want to see or do with the spreadsheet. Three possibilities immediately come to mind: 1. Budget Report — Even without using GnuCash to budget, it can still show consolidated Actuals by period, quarter, year, etc. 2.

Re: [GNC] Trouble importing bills via csv

2024-02-26 Thread Adrien Monteleone
Yes, if your field contains the separator character you should double-quote it, but *only* in that case. Id's, dates, et cetera will not, so no reason to quote them. The OP had quotes on most if not all fields and none of them were necessary. Regards, Adrien On 2/26/24 8:23 AM, Kalpesh Patel

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
There is the caveat, noted in that link, that if you use the same delimiter for your account tree as the CSV, then (and only then) do you need to enclose account references in double-quotes. (this is generally a CSV thing, not something specific to GnuCash) Regards, Adrien On 2/24/24 6:02

Re: [GNC] Net Assets

2024-02-24 Thread Adrien Monteleone
And I'm pretty sure there is a bug filed on it. Regards, Adrien On 2/24/24 2:14 PM, David H wrote: Thank you for that as I don't think that in 10 or more years of using Gnucash that I've realised that it is a drop down list :-) I've always been puzzled as to why it always shows a zero amount

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread Adrien Monteleone
That would be: Preferences > Scheduled Transactions > Since Last Run > Run when data file opened. So you want a dialog box to confirm the preference each time? What's the point of the preference then? Regards, Adrien On 2/24/24 2:03 PM, David H wrote: Strikes me that it wouldn't be a bad

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
Although you should be able to have header row(s), perhaps remove it and try again. The Documentation for this is worded oddly, but the samples provided don't show header info at all. https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html Regards, Adrien On 2/24/24

Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread Adrien Monteleone
There are some changes between major versions. There are checks silently run when you first open your file with a new major version. You can run those checks explicitly via Actions > Check & Repair. The goal is usually to keep compatibility between the last minor release of a major version

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-23 Thread Adrien Monteleone
Stan gave you the answer, but also, please just start a new e-mail to the group when beginning a topic. It looks like you hit 'reply' on someone else's topic to start your own. I'll add to Stan's answer that other than deleting the Scheduled Transactions, if you are going to be in the habit

Re: [GNC] How to fix error note on receivable aging report?

2024-02-23 Thread Adrien Monteleone
Note in the 2nd screenshot (of the register) that the 'type' column shows a "?". That's not supposed to happen, and you aren't supposed to be able to change it from the register. I don't know exactly what caused it, but for sure, there are problems with your Credit Note. Normally, an

Re: [GNC] Install of GNC fails on Flatpak

2024-02-23 Thread Adrien Monteleone
Jeffrey, you referenced Snap, then Flatpak. I'm guessing the 'snap' was a mental typo. What are the commands you are using to install GnuCash via Flatpak? Regards, Adrien On 2/23/24 1:14 AM, jeffrey black wrote: I'm having to do this via my cell phone so please excuse typos. I had a

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-22 Thread Adrien Monteleone
s location or to the main release location. Gmail does not show me the announcement that this thread follows. On Wed, Feb 21, 2024 at 9:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I thought John made that pretty clear in the initial post of this thread. Regards, Adrien On 2/21/2

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-21 Thread Adrien Monteleone
I thought John made that pretty clear in the initial post of this thread. Regards, Adrien On 2/21/24 6:00 PM, David Carlson wrote: Was there an annoumcement about who should try this and whrre to find it? ___ gnucash-user mailing list

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-21 Thread Adrien Monteleone
I'm pretty sure that release was to fix a Windows-specific issue. Pre-compiled Linux versions are available from various distributions. Otherwise, a flatpak is also available if you need something more recent than your distro's repo. Regards, Adrien On 2/21/24 4:50 AM, hc.stoellinger wrote:

Re: [GNC] Can't open old GnuCash file

2024-02-17 Thread Adrien Monteleone
Incremental updates, yes, but you jumped 4 major versions and skipped those incremental updates. The recommended process (in the wiki FAQ) is to upgrade in steps to each of the final releases of each major release, running Actions > Check & Repair > Check & Repair All upon first opening the

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
I see now, these are likely replies to a digest that result in thread splitting. Regards, Adrien On 2/11/24 10:11 AM, Adrien Monteleone wrote: Not just Gmail. I replied too early to this thread before realizing it was split in 3 parts. Or maybe someone using Gmail is causing them to split

Re: [GNC] Repeatable crashes with 4.14 on 32-bit arm Linux

2024-02-11 Thread Adrien Monteleone
Under Preferences > Register > Reconciling there is "Automatic Credit Card Payment" For some other accounts (Liability type I think) in the account Edit screen there is an "Auto Interest Transfer" checkbox. Regards, Adrien On 2/11/24 8:02 AM, Robert Heller wrote: Can these dialogs be

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
Not just Gmail. I replied too early to this thread before realizing it was split in 3 parts. Or maybe someone using Gmail is causing them to split... Regards, Adrien On 2/10/24 2:07 PM, David Carlson wrote: In my Gmail these threads are getting disconnected. Gmail doesn't seem to know what

Re: [GNC] GNC UI problem...

2024-02-11 Thread Adrien Monteleone
Robert, You can only size columns with the right-handed border in the header. To make them wider, click one and drag it to the right. To auto-size to 'fit' the content, double left-click a header. (any OS) Resize all columns other than Description first, then either double left-click the

Re: [GNC] New user error

2024-02-08 Thread Adrien Monteleone
Nice. I'm using 5.4 and it shows all transactions. I learn something new every day. Thanks! Regards, Adrien On 2/8/24 12:41 PM, Stan Brown (using GC 4.14) wrote: On 2024-02-08 08:59, Adrien Monteleone wrote: I'm aware of the report. There is also Tools > General Journal where you can m

Re: [GNC] New user error

2024-02-08 Thread Adrien Monteleone
ack wrote: On 2/7/2024 11:11 PM, Adrien Monteleone wrote: Michael, Transaction Journal View is simply the same full transaction accessible via either 'Split' or 'Auto-Split' but for all transactions - *not* one at a time. Yes of course, can have on your screen "journal view" for all

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
No, you're not seeing the entire transaction in the view you are using, so you think you need to enter both splits as separate lines. That's not how GnuCash works by default and had you read the manual, you'd know this. If you want to see both splits in a simple transaction, you need to use

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
Michael, Transaction Journal View is simply the same full transaction accessible via either 'Split' or 'Auto-Split' but for all transactions - *not* one at a time. Regards, Adrien On 2/7/24 4:26 PM, Michael or Penny Novack wrote: IF you select "journal view" you can enter transactions that

Re: [GNC] Import CSV settings location

2024-02-07 Thread Adrien Monteleone
They aren't in the data file itself, I don't think. Check the Wiki for 'File Locations' which describes the various directories used by GnuCash to store various settings, reports, and other bits. Copy those over from Computer A to B as needed. Regards, Adrien On 2/7/24 8:57 AM, Aryeh

Re: [GNC] New user error

2024-02-07 Thread Adrien Monteleone
In both situations where you provided screenshots (Equity & Expenses) you have recorded equal and offsetting transactions, which balance to ZERO, which is why you see $0.00 on the Accounts tab. (note the respective account balance columns - that is what is reported on the Accounts tab) While

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-03 Thread Adrien Monteleone
Not sure what you mean by 'un-commented'. There were a few message exchanges in each thread, though there was no resolution for any of them. I have the column turned on and I haven't noticed it not working properly, but I also haven't had any cases like yours or those in the other threads

Re: [GNC] How can I visualize financial spending in gnucash?

2024-02-03 Thread Adrien Monteleone
That's a fairly broad question, and I'm not clear *exactly* what you mean by 'visualize' 'map out' and 'tweak'. GnuCash does have a Budget module that works much like a spreadsheet. Various Reports, Charts & Graphs are available based on the budget and can compare actuals as well as show

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-02 Thread Adrien Monteleone
I found two threads: https://lists.gnucash.org/pipermail/gnucash-user/2023-January/104675.html https://lists.gnucash.org/pipermail/gnucash-user/2023-December/109930.html It seems there has been an issue with this column for at least a year, or it is working as intended, just not as expected.

Re: [GNC] 'Total Period' shows 'Total' for one bank account

2024-02-01 Thread Adrien Monteleone
This sounds familiar. Perhaps search the last few months of the list archive for 'Total(Period)' and you should find at least one more thread on this. It might be a bug. (and may be already filed, so a search on Bugzilla would be in order.) Regards, Adrien On 2/1/24 5:51 AM, G R Hewitt

Re: [GNC] SX

2024-01-31 Thread Adrien Monteleone
It works when I right click on the calendar and then as I move around a pop-up that follows the mouse changes to show SX info, or none, accordingly. Regards, Adrien On 1/31/24 8:27 AM, Gyle McCollam wrote: IIRC the calendar in SX used to show what transactions were due on each day when you

  1   2   3   4   5   6   7   8   9   10   >