Re: [GNC] Adding more than one government tx to client invoice

2024-02-25 Thread Jediator
I don't see including multiple tax tables in one invoice item is possible.  But if you don't need to itemize your taxes, you can create a combined tax table.  Another option would be to create separate invoice items as tax items, and specify the tax rate in the Quantity field (e.g., 8% =

Re: [GNC] Install of GNC fails on Flatpak

2024-02-23 Thread Jediator
You may want to install the plugin first. https://flathub.org/setup/Ubuntu.  Hope this helps.  -- JC On 2/23/24 2:14 AM, jeffrey black wrote: I'm having to do this via my cell phone so please excuse typos. I had a complete network failure when a surge suppressor decided to explode in my

Re: [GNC] Automatic account match doesn't work when import transactions

2024-02-04 Thread Jediator
b of the dialogue. Tools_>Import Map Editor allows you to edit the data in the probability tables which makes up the rules. Also see https://gnucash.org/docs/v5/C/gnucash-manual//trans-import.html On Sat, 2024-02-03 at 21:01 -0500, Jediator wrote: I couldn't get the automatic account matc

Re: [GNC] Automatic account match doesn't work when import transactions

2024-02-04 Thread Jediator
Mostly CSV files, but other file formats as well. On 2/3/24 9:26 PM, Steve Butler wrote: Which import?  CSV? On Sun, Feb 4, 2024, 13:04 Jediator wrote: I couldn't get the automatic account match to work when importing bank/credit card transactions to GC.  Is there anyway to manually

[GNC] Automatic account match doesn't work when import transactions

2024-02-03 Thread Jediator
I couldn't get the automatic account match to work when importing bank/credit card transactions to GC.  Is there anyway to manually create the matching rules?  Thanks!  -- JC ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Deferred Income << the general case is "imputed income"

2024-01-15 Thread Jediator
I am not an accountant, so please excuse my ignorance.  I was wondering is it really necessary to create a separate deferred income account when you could just do a transaction report on your IRA account to see how much distribution you had in a year or a month?  -- JC On 1/15/24 5:33 PM,

Re: [GNC] GnuCash 5.5 Windows 11 crashing when running reports

2024-01-05 Thread Jediator
Does it mean that this won't be an issue for MacOS users? No report crash for running GnuCash on Mac?  Thanks! On 1/5/24 11:36 AM, john wrote: No need to troubleshoot, that's already been done. This is https://bugs.gnucash.org/show_bug.cgi?id=799167, and is caused by a crash in WebKit's

[GNC] GC Best Practices for Investment Management

2023-11-08 Thread Jediator
After dumping QB and using GC for couple of months, I started really enjoying its features and simplicity.  I noticed that a major feature in GC is the stock and investment management function, which I was hesitating to get into.  I'd like to hear from fellow GC users on the usefulness and

Re: [GNC] Recording medical reimbursements

2023-11-06 Thread Jediator
I would use the same expense account to record refund, since the refund reduces your medical expenses. -- JC On 11/6/23 10:53 PM, Andrew Gross wrote: I have various expense accounts for medical expenses. When I receive an insurance check, I record these against the medical expense accounts so

Re: [GNC] Dealing with escrow account

2023-11-02 Thread Jediator
One way to automate the bill generation would be to create a payment plan in a spreadsheet.  It should be fairly easy to calculate principal and interest in each installment in a spreadsheet, and convert that spreadsheet in to csv format for bill generation in GC, and import the csv file to GC

Re: [GNC] Dealing with escrow account

2023-11-01 Thread Jediator
In addition to setting up the proper account structure, I would make your mortgage company as a vendor and set up a bill each month with split transactions to map to mortgage-related subaccounts (e.g, property tax, insurance, interest and principal) as such: * Mortgage Payment o PMI

Re: [GNC] How to display account total with subaccounts in a report

2023-10-26 Thread Jediator
Thanks for your detailed instructions! On 10/26/23 5:31 PM, Stan Brown (using GC 4.14) wrote: On 2023-10-26 14:25, Jediator wrote: Forgive my ignorance, but where is the P Account options located?  Do you mean report options?  Could you please be specific on how to set the options (not very

Re: [GNC] How to display account total with subaccounts in a report

2023-10-26 Thread Jediator
nt balances"->select calculate sub total Saludos Cordiales Murugan *From:* gnucash-user on behalf of Jediator *Sent:* Thursday, October 26, 2023 6:03 PM *To:* gnucash-user@gnucash.org *Subject:* [GNC] How to di

Re: [GNC] New Balance entry

2023-10-26 Thread Jediator
This feature is useful when doing recon of a credit card account. After a successful recon run, the new balance window will popup up with the balance amount preset so you can issue a credit card payment from a bank account.  Certainly you can cancel the action (which doesn't affect your recon

[GNC] How to display account total with subaccounts in a report

2023-10-26 Thread Jediator
The P report for instance displays the account hierarchy and the account balance for each account.  However, all parent accounts show zero balances.  Is there anyway to display the account balance of a parent as a sum of all its child accounts? This may have been asked before, but I searched

[GNC] Assigning payment inside a split

2023-10-24 Thread Jediator
I was trying to assign a payment to a transaction inside a split (a parent transaction).  However, to my surprise, this action resulted not only the child entity assigned as a payment, but also the rest of the siblings merged together and assigned as a payment to the same bill.  I ended up

Re: [GNC] How to Delete a Runaway Invoice?

2023-09-27 Thread Jediator
wrote: On 9/27/23 8:26 PM, Jediator wrote: Thanks again Adrien!  I did answer your initial questions in one of the response messages, but it didn't get published.  Cutting and Pasted them below. You may be right this isn't a replicated ID issue. To summarize what I encountered was: 1

Re: [GNC] Window resizing issues on MacOS

2023-09-27 Thread Jediator
I haven't encountered any window resizing issue on Ventura 13.5. -- JC On 9/27/23 9:22 PM, Adrien Monteleone wrote: I'm running 5.4 on 12.6.9 Monterey and I just noticed that window resizing issues appear worse. Prior to 5.4, resizing worked, but would temporarily or partially blank the

Re: [GNC] How to Delete a Runaway Invoice?

2023-09-27 Thread Jediator
Note, you have to wait to use it for your next Credit Note. (for any customer, as you can re-assign it) Shouldn't a refund/credit note show up in AR as a credit? But this one shows under invoice (debit) in AR. On 9/27/23 9:02 PM, Adrien Monteleone wrote: On 9/27/23 7:28 PM, Jediator wro

Re: [GNC] How to Delete a Runaway Invoice?

2023-09-27 Thread Jediator
Not sure if the title is too "violent" that prevents it from being accepted by the list.  Resending... On 9/27/23 6:24 PM, Jediator wrote: Thanks Adrien!  I am using the latest version 5.4 of GC, running on Mac with a Postgresql in the back-end.  Please see answers to your quest

[GNC] How to Kill a Runaway Invoice?

2023-09-26 Thread Jediator
I was trying to reuse/repurpose an invoice ID for a customer (e.g. change the amount and date), but made a mistake of changing the customer name in between (not sure if was the cause).  Now I ended up with two invoices with the same ID on the customer report, with the old entry labeled as a

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Jediator
Did you perhaps modified/added/deleted transactions after reconciliation?  Any changes could easily break your reconciled balance.  This is typical in a double-entry system: you changed one account and didn't realized it affected the balance of another.  I guess the only way to make the

Re: [GNC] Using GC for Property Management

2023-09-25 Thread Jediator
make inline notations below, but with Debit(Dr.) & Credit (Cr.) labels as those are more traditional and easier to follow, especially using GnuCash. Regards, Adrien On 9/22/23 1:36 PM, Jediator wrote: Dear GC users, I am trying to set up GC for a small property management busi

Re: [GNC] ANNOUNCE: GnuCash 5.4 Released

2023-09-24 Thread Jediator
Thanks John and the GC team for all your hard work and dedication! On 9/24/23 5:26 PM, John Ralls wrote: The GnuCash development team announces GnuCash 5.4, the fifth release in the stable 5.x series Between 5.3 and 5.4, the following bugfixes were accomplished: Bug 728875 - Back button

Re: [GNC] Have code run when a new invoice is posted.

2023-09-24 Thread Jediator
I am facing the same problem.  My solution is to leverage the Import Invoices/Bills function in GC (using version 5.3 now) and transfer the invoices and bills in CSV to GC.  It may require some manual steps, but it should be easy to create a python script to generate your invoices and bills in

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-24 Thread Jediator
David, You need to create the log.conf file manually first on your Mac to enable tracing.  Please see this thread for details (https://lists.gnucash.org/pipermail/gnucash-user/2023-September/108759.html). Are you using the default sqlite as the GC database?  The error message of "procedure

Re: [GNC] Using GC for Property Management

2023-09-22 Thread Jediator
13:36, Jediator wrote: Dear GC users, I am trying to set up GC for a small property management business. There are three actors involved:  Renter, Property Owner, and Property Manager.  Renter pays rent on a monthly basis to property management, and the manager pays the property owner after

[GNC] Using GC for Property Management

2023-09-22 Thread Jediator
Dear GC users, I am trying to set up GC for a small property management business. There are three actors involved:  Renter, Property Owner, and Property Manager.  Renter pays rent on a monthly basis to property management, and the manager pays the property owner after taking out certain

Re: [GNC] How to display Job Report

2023-09-22 Thread Jediator
That's wonderful!  Thanks John! On 9/22/23 1:11 PM, John Ralls wrote: That's https://bugs.gnucash.org/show_bug.cgi?id=798998. It's fixed in GnuCash 5.4 that will be released this weekend. Regards, John Ralls On Sep 22, 2023, at 2:43 AM, Jediator wrote: Hi GC users, I can't figure out how

[GNC] How to display Job Report

2023-09-22 Thread Jediator
Hi GC users, I can't figure out how to display a job report.  The menu item Report->Business->Job Report shows empty content and there is no job selection under report options.  The user's manual left this part incomplete.  Is this function still under development?  I am using GC version 5.3. 

[GNC] Upcoming/future invoices not visible on vendor report

2023-09-20 Thread Jediator
Hi GC users, I created some invoices for vendors with future dates (e.g. 10/16/2023), so I can plan ahead to see what bills are coming.  The invoices were created correctly and clearly visible under account payable, but they won't show up on vendor report.  Is this a normal behavior of GC

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread Jediator
automatically.  Thanks! On 9/11/23 4:25 PM, John Ralls wrote: Yes, log.conf is a user-created file, there is no default. Note that that's about the tracefile (https://wiki.gnucash.org/wiki/Tracefile), not the transaction logs. Regards, John Ralls On Sep 11, 2023, at 12:46 PM, Jediator wrote

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread Jediator
Thanks John!  Apparently in version 5.3 on Mac, the data directory and config directory of GC is the same on Mac at /Users/username/Library/Application Support/GnuCash, and the log files are in the translog directory underneath.  However, the log.conf file is nowhere to find (supposed to be

[GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread Jediator
Hi GC users, I am using GC (version 5.3) on Mac.  I noticed that the log files are generated in the same directory of the GC data file (sqlite3).  But I couldn't find the log files after switching to a remote database server.  The info on the GC wiki on logging seems to be outdated, as I can't

Re: [GNC] Transaction inconsistency when deleting account

2023-09-04 Thread Jediator
card before importing.   So I decided to get rid of the credit card account and create and re-import everything from scratch (luckily GC allows you to do this), thus the inconsistency problem. Thanks! On 9/3/23 3:12 PM, Michael or Penny Novack wrote: On 9/3/2023 2:27 PM, Jediator wrote: Hi, I'm

[GNC] Transaction inconsistency when deleting account

2023-09-03 Thread Jediator
Hi, I'm a new GC user after using QB for many years.  One problem I encountered was when I delete an account with transactions (instead of deleting transactions manually one at a time), the corresponding transactions in other accounts won't get deleted automatically.  For instance, I have a