[GNC] Imbalance Records with zero amounts

Hello, I have several consecutive records in my imbalance account where the amounts in the deposit and withdrawal columns are both zero (blank). These records are  split transaction records.  When I examine the items in the split the imbalance shows zero.  I don't see any error when I jump

[GNC] FYI: Backups on Linux

Hello, I've noticed some recent posts about backups and want to share the following. I have been using "Borg Backup" on Linux to backup my files.  With it I can restore files from backups made as far back as I choose. I have been using it for over two years and have had no problems.  I

Re: [GNC] Create New Gnucash File From Old One

On 11/9/22 02:55, Geert Janssens wrote: Hi Joe, In order to help you, can you describe exactly what you have tried and what went wrong ? Regards, Geert Thank you for your reply. Here is what I have done. I used "File -> Export Account Tree to CSV" to create a CSV file which I then

Re: [GNC] Create New Gnucash File From Old One

On 11/7/22 15:59, Derek Atkins wrote: Hi, On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote: Hello, Here is what I want to accomplish. 1. Create a new gnucash file with the same accounts as an old one but no transactions from the old one. 2. Copy the transactions from a single account

Re: [GNC] Create New Gnucash File From Old One

On 11/7/22 15:59, Derek Atkins wrote: Hi, On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote: Hello, Here is what I want to accomplish. 1. Create a new gnucash file with the same accounts as an old one but no transactions from the old one. 2. Copy the transactions from a single account

[GNC] Create New Gnucash File From Old One

Hello, Here is what I want to accomplish. 1. Create a new gnucash file with the same accounts as an old one but no transactions from the old one. 2. Copy the transactions from a single account from the old gnu cash file to the new one. I can accomplish 1. by exporting the account tree from

[GNC] Start New File

to a new one and heavily edit the new one to look the way I want.  Is there an easier way to do this? Thank you, Joseph Hesse ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

[GNC] Count Transactions

Hello, How do I count the total number of transactions in an account from a start to end date of my choosing? Thank you, Joe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Undo Reconciliation

Hello, How do I unreconcile about 100 transactions in an account? Thank you, Joe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user

Re: [GNC] Merge gnucash files

though I keep my files in a dropbox account so I can access them from any of several devices (but not at the same time). Other options are to use a file synchronization program like Unison to keep the files in sync after any changes are made. David Cousens On Fri, 2020-06-26 at 12:19 -0500, Joseph

[GNC] Merge gnucash files

Suppose I make a copy of my gnucash file so I now have the 2 files, the original A.gnucash and the copy B.gnucash. If my wife adds/deletes transactions in B.gnucash to one of the credit card accounts, is there a way I can merge her transactions from B.gnucash to A.gnucash so that A.gnucash has

[GNC] Report Question

I want to generate a report of: All the expenses for 2 subaccounts and their subaccounts of Expenses.  I want the report for all of 2019 and I don't want the matching transfer accounts. What Report type do you suggest I use?  There are too many to try them all. Thank you, Joe

Use MySQL to Create A Custom Expense Report

I have written a short paper on how to use MySQL to create a custom expense report.  You can download it from my web site "www.actcx.com".  Click on the MySQL link on the left. I hope someone finds this useful. Thank you Joe Hesse ___ gnucash-user

Question on mysql "account" table

Here is an example of what I am trying to do.  My expenses in gnucash have items that look like: Expenses   Auto     Gas     Service When I look in the mysql accounts table I can find the record containing Service but no easy way to find Expenses:Auto:Service. The record containing Service

Re: Save to MySQL

On 10/04/2017 09:40 PM, John Ralls wrote: On Oct 4, 2017, at 4:23 AM, Joseph Hesse <joehe...@gmail.com> wrote: I would like to save my data into a MySQL database. Please inform me how to do this. I am familiar with MySQL and queries, I would like to end up with a database with re

Save to MySQL

I would like to save my data into a MySQL database. Please inform me how to do this. I am familiar with MySQL and queries, I would like to end up with a database with relevant tables. Thank you, Joe Hesse ___ gnucash-user mailing list

Report Question

Hi, I am using the latest version 2.6.17 of gnucash.  I just ran the report "Expense Over Time = Expense Barchart" with the maximum number of vertical bars selected. The report lists all my expense items including one called "Other". Since the amount of "Other" is high, I would like to get a

Report Question

Hi, I am using the latest version 2.6.17 of gnucash.  I just ran the report "Expense Over Time = Expense Barchart" with the maximum number of vertical bars selected. The report lists all my expense items including one called "Other". Since the amount of "Other" is high, I would like to get a