Re: [GNC] Discovered install link for Finance Quotes in Win11 app

2024-06-18 Thread Adrien Monteleone
If gnucash-cli --quotes can write to the book, then try that with the Windows Task Scheduler. Regards, Adrien On 6/18/24 1:21 PM, David G. Pickett via gnucash-user wrote: Only issue now is the price database window hiding itself. Some way to easily schedule price updates would be nice.

Re: [GNC] reconcile buttons

2024-06-17 Thread Adrien Monteleone
One design. They even all use the GTK toolkit for drawing the UI. (though not always the same version across all platforms) As for the web server idea, see the RoadMap on the Wiki. GnuCash is not at present following the MVC paradigm or even an 'proper' database application. Work is being

Re: [GNC] Missing Register Right Click Options

2024-06-17 Thread Adrien Monteleone
Good to know, thanks for reporting back on the resolution. Regards, Adrien On 6/14/24 8:37 PM, j a wrote: Hi, Adrien, This is to confirm that the issue has been resolved. It was due to a misconfiguration on my Gentoo Linux system. I inadvertently compiled some packages with flags that caused

Re: [GNC] Color tabs: General Journal

2024-06-14 Thread Adrien Monteleone
Correct. Neither has an ID. Regards, Adrien On 6/12/24 8:50 AM, Stan Brown (using GC 4.14) wrote: Thanks, Adrien. I'll enter the request for enhancement and mention both General Journal and the Accounts tab, which I'll bet is also not separately ID'd.

Re: [GNC] gnucash-user Digest, Vol 255, Issue 13

2024-06-14 Thread Adrien Monteleone
Bruce, Try this: Set the Journal to show all transactions in Preferences. Set a filter while viewing the Journal to the period in question. Run an Account Report. You can do the same with individual accounts. The Transaction Report is also very powerful and can be customized quite a bit. I

Re: [GNC] GC now only opens a report

2024-06-12 Thread Adrien Monteleone
Indeed. I guess I never encountered it because I only use tabs and don't open reports or registers in separate windows. (*not* using separate windows will avoid this issue) Regards, Adrien On 6/12/24 3:17 AM, Geert Janssens wrote: You can close it as follows: - Start gnucash - open a report

Re: [GNC] Missing Register Right Click Options

2024-06-11 Thread Adrien Monteleone
Anytime you have an issue with something not working properly, please also include your Operating System. (and version) I can confirm that the right-click also works fine on 5.6 using MacOS 12.7.5 Monterey. I seem to recall some context menu issues (what you get when you right-click) way

Re: [GNC] Color tabs: General Journal

2024-06-11 Thread Adrien Monteleone
I fired up the inspector and poked around. Unfortunately, I didn't see any way to target just that tab for styling. It would need an ID (optimum) or class to write a CSS rule. So the only avenue left is to file an RFE on the bug tracker and ask to add the ability to set the tab color for the

Re: [GNC] GC now only opens a report

2024-06-11 Thread Adrien Monteleone
GnuCash opens whatever tabs were open when you shut down. Why the Accounts tab doesn't come back up for some folks, I have no idea, as I don't know of a way to close it. (it is always visible for me) But you can certainly bring it back up via the View menu as you have discovered. Regards,

Re: [GNC] Color tabs: General Journal

2024-06-10 Thread Adrien Monteleone
Not in the UI, but perhaps with a CSS file. You'll want to fire up GnuCash with the GTKInspector to find out how to target that one tab, if it is even possible. Regards, Adrien On 6/10/24 8:34 PM, Stan Brown (using GC 4.14) wrote: I set the color on a couple of accounts, and then went to

Re: [GNC] Clearing filters on account registers

2024-06-10 Thread Adrien Monteleone
Tabs don't change color on their own. You have to do that intentionally by editing an account and setting a color. This has nothing to do with filters. Make sure that Preferences > Register Defaults > Number of transactions is set to ZERO to show all transactions. While you mentioned the

Re: [GNC] Clearing filters on account registers

2024-06-09 Thread Adrien Monteleone
Paul, To further a bit on David's advice, see the Wiki about File Locations. Note the locations of GnuCash files for your particular OS. Then copy over the appropriate (or all) files between the two machines. Note, if you make any preference or settings changes, then you'll have to re-sync

Re: [GNC] Clearing filters on account registers

2024-06-09 Thread Adrien Monteleone
In any register, if a filter is applied, the right end of the Status Bar (top or bottom of the tab, depending on a preference) will say 'Filtered' to alert you of that fact. If that is visible, then simple click View > Filter by..., and clear or update the filter to match the other computer.

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone
You don't need to roll back a reconciliation that is now out of whack. If need be, un-reconcile that transaction split, then re-reconcile. Regards, Adrien On 5/29/24 8:33 AM, Peter Cuthbert via gnucash-user wrote: So final thought for the GNUCash programmers.  Please consider a 'roll back'

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone
GnuCash is supposed to warn you when editing a reconciled transaction that would change the flag. If not, perhaps you turned that message off. Check Actions > Reset Warnings and look for something like "change contents of reconciled split". If it is there, select it and Apply to reset the

Re: [GNC] Reconciliation Roll Back

2024-05-29 Thread Adrien Monteleone
And I learn something new everyday. Thanks David! Regards, Adrien On 5/28/24 9:17 AM, David Carlson wrote: A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that

Re: [GNC] Running balance/total from search results is always $0.00

2024-05-29 Thread Adrien Monteleone
If the Memo field is your only criteria, then just use the Transaction Report and use the Filter tab for your Memo text. Note, you'll need to decide which account you are summing on the report though. (likely the same issue with the Account Report) In the case of multiple expense accounts for

Re: [GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-27 Thread Adrien Monteleone
Both Michael & user 'flywire' have offered the 'how to do that' answer. Michael's answer involves out-of-the box reports that are further manipulated outside of GnuCash to achieve the desired end result, using the standard method of entering transactions. (this is quite normal for anything

Re: [GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Adrien Monteleone
This is a perfect example of why this list is not the place for accounting advice. We can't answer, "What should I do?" You have to know that first, then ask, "How do I accomplish this using GnuCash?" In many cases, the answer is, "The same way you'd do so with Pen & Paper." (sans the

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

  1   2   3   4   5   6   7   8   9   10   >