[GNC] Printing Reports: Income and Expense Line Chart
Right now I'm struggling with the Income and Expense Line Chart. I want to print it out to show it to my partner. When I choose to print landscape, it still prints portrait, and it cuts off the edges. Trying various save and export methods have not yielded better results. Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Recommended Accounting Books
You may need to research inventory management systems. Here is one link I found "8 Best Free and Open Source Inventory Management Software Systems" https://www.goodfirms.co/inventory-management-software/blog/best-free-open-source-inventory-management-software-systems ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Thank you. I filed the bug at https://bugs.gnucash.org/show_bug.cgi?id=799269 On Thu, Apr 4, 2024 at 9:06 PM Christopher Lam wrote: > Hi, enhancements should be logged in bugs.gnucash.org > > On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >> >I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> I have already set up some Scheduled Transactions. So often when I open >> GnuCash it gives me a "Since Last Run" window. That gives me some >> information about the transactions it is going to create. At the bottom of >> that window is a checkbox which says, "Review Created Transactions". If I >> check that box, then GnuCash will take me to the main app and there is a >> tab named "Created Transactions". There I can see the transactions which >> were just created. >> >> That is what I want to see for Imported Transactions. >> >> >> >> >> On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs >> wrote: >> >> > Yes, I see that. >> > But I mean that GnuCash should take me to a tab that looks like how it >> > displays the results of a Find Transaction. It opens a Register page and >> > shows only the matching transactions. >> > I think it already does that for the Scheduled Transactions. It says >> > something like, oh some time has passed, would you like me to create >> these >> > transactions which you created in the Scheduled Transaction window. >> Okay, >> > here is a register page showing the transactions I just created. >> > >> > >> > >> > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> > wrote: >> > >> >> During the actual importation process, GNC always shows a confirmation >> >> dialogue box to take an action on all transaction it found. This is >> where >> >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> >> clear matched one, 'C' to clear existing matched one, or select >> nothing and >> >> do nothing with that transaction. This is automatic -- ie there is >> nothing >> >> needs to be done, either via setting or manually, to trigger it to >> come up >> >> during every import. Note that if a transaction is matched >> incorrectly, you >> >> can check either 'U+C' or 'C" and then double clicking on it will >> bring up >> >> another dialogue box with a list of transactions it believe matches or >> are >> >> similar from which you can select on that it should match with. >> >> >> >> -Original Message- >> >> From: Tom Balazs >> >> Sent: Friday, December 22, 2023 7:02 AM >> >> To: Post to GnuCash User >> >> Subject: [GNC] View Transactions After Importing from CSV >> >> >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> >> transactions from that, and importing them into GnuCash. Is there an >> option >> >> where I can view the transactions I just imported? So they appear on >> one >> >> page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> >> can't find it again. >> >> >> >> Tom >> >> >> >> >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
>I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. I have already set up some Scheduled Transactions. So often when I open GnuCash it gives me a "Since Last Run" window. That gives me some information about the transactions it is going to create. At the bottom of that window is a checkbox which says, "Review Created Transactions". If I check that box, then GnuCash will take me to the main app and there is a tab named "Created Transactions". There I can see the transactions which were just created. That is what I want to see for Imported Transactions. On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs wrote: > Yes, I see that. > But I mean that GnuCash should take me to a tab that looks like how it > displays the results of a Find Transaction. It opens a Register page and > shows only the matching transactions. > I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > wrote: > >> During the actual importation process, GNC always shows a confirmation >> dialogue box to take an action on all transaction it found. This is where >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> clear matched one, 'C' to clear existing matched one, or select nothing and >> do nothing with that transaction. This is automatic -- ie there is nothing >> needs to be done, either via setting or manually, to trigger it to come up >> during every import. Note that if a transaction is matched incorrectly, you >> can check either 'U+C' or 'C" and then double clicking on it will bring up >> another dialogue box with a list of transactions it believe matches or are >> similar from which you can select on that it should match with. >> >> -Original Message- >> From: Tom Balazs >> Sent: Friday, December 22, 2023 7:02 AM >> To: Post to GnuCash User >> Subject: [GNC] View Transactions After Importing from CSV >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> transactions from that, and importing them into GnuCash. Is there an option >> where I can view the transactions I just imported? So they appear on one >> page, as if I did a Find in GnuCash. I think I came across that once, but I >> can't find it again. >> >> Tom >> >> >> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
It is set to: QIF import: Default Transaction Status: Not Cleared On Tue, Apr 2, 2024 at 6:59 PM David Carlson wrote: > Tom, > > Take a look at your setting for Edit > Preferences > Import > Default > transaction status. In earlier releases (Release 4.x) the explanation > suggested that only came into play for QIF imports but it may apply to CSV > imports as well in the new CSV importer, I am not sure. > > On Tue, Apr 2, 2024 at 11:46 AM Tom Balazs wrote: > >> Yes, I see that. >> But I mean that GnuCash should take me to a tab that looks like how it >> displays the results of a Find Transaction. It opens a Register page and >> shows only the matching transactions. >> I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> >> >> On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> wrote: >> >> > During the actual importation process, GNC always shows a confirmation >> > dialogue box to take an action on all transaction it found. This is >> where >> > you get a chance to select 'A' to add transaction, 'U+C' to update and >> > clear matched one, 'C' to clear existing matched one, or select nothing >> and >> > do nothing with that transaction. This is automatic -- ie there is >> nothing >> > needs to be done, either via setting or manually, to trigger it to come >> up >> > during every import. Note that if a transaction is matched incorrectly, >> you >> > can check either 'U+C' or 'C" and then double clicking on it will bring >> up >> > another dialogue box with a list of transactions it believe matches or >> are >> > similar from which you can select on that it should match with. >> > >> > -Original Message- >> > From: Tom Balazs >> > Sent: Friday, December 22, 2023 7:02 AM >> > To: Post to GnuCash User >> > Subject: [GNC] View Transactions After Importing from CSV >> > >> > I'm using Financisto+ on my Android phone. So I am often exporting >> > transactions from that, and importing them into GnuCash. Is there an >> option >> > where I can view the transactions I just imported? So they appear on one >> > page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> > can't find it again. >> > >> > Tom >> > >> > >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Yes, I see that. But I mean that GnuCash should take me to a tab that looks like how it displays the results of a Find Transaction. It opens a Register page and shows only the matching transactions. I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel wrote: > During the actual importation process, GNC always shows a confirmation > dialogue box to take an action on all transaction it found. This is where > you get a chance to select 'A' to add transaction, 'U+C' to update and > clear matched one, 'C' to clear existing matched one, or select nothing and > do nothing with that transaction. This is automatic -- ie there is nothing > needs to be done, either via setting or manually, to trigger it to come up > during every import. Note that if a transaction is matched incorrectly, you > can check either 'U+C' or 'C" and then double clicking on it will bring up > another dialogue box with a list of transactions it believe matches or are > similar from which you can select on that it should match with. > > -Original Message- > From: Tom Balazs > Sent: Friday, December 22, 2023 7:02 AM > To: Post to GnuCash User > Subject: [GNC] View Transactions After Importing from CSV > > I'm using Financisto+ on my Android phone. So I am often exporting > transactions from that, and importing them into GnuCash. Is there an option > where I can view the transactions I just imported? So they appear on one > page, as if I did a Find in GnuCash. I think I came across that once, but I > can't find it again. > > Tom > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Imported Transactions Show as Cleared
In the Import / Match Transactions window, the "A" column is marked. After I complete the Import, I go to look at the transactions and they are marked "c" Cleared. ScreenCaps https://ibb.co/YBQ7Z9H https://ibb.co/dmVvytR On Tue, Apr 2, 2024 at 10:41 AM Tom Balazs wrote: > I don't understand why GnuCash marks the transactions as "c" Cleared. > > Financisto+ creates a row at the top of the CSV file which has the > Financisto+ column headers. In the Import Preview I tell it to skip that > top row. > > When importing the CSV file I select columns for Date, Account, Amount, > Transfer Account, Description, and Notes. That's all. > > The columns I leave as None (so I don't import) are time, currency, > original amount, original currency, parent, location, and status. > > (I'm reposting this message to put it in the correct thread.) > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Imported Transactions Show as Cleared
I don't understand why GnuCash marks the transactions as "c" Cleared. Financisto+ creates a row at the top of the CSV file which has the Financisto+ column headers. In the Import Preview I tell it to skip that top row. When importing the CSV file I select columns for Date, Account, Amount, Transfer Account, Description, and Notes. That's all. The columns I leave as None (so I don't import) are time, currency, original amount, original currency, parent, location, and status. (I'm reposting this message to put it in the correct thread.) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconcile window Start Balance, & Reconciled became UnReconciled
I don't understand why GnuCash marks the transactions as "c" Cleared. Financisto+ creates a row at the top of the CSV file which has the Financisto+ column headers. In the Import Preview I tell it to skip that top row. When importing the CSV file I select columns for Date, Account, Amount, Transfer Account, Description, and Notes. That's all. The columns I leave as None (so I don't import) are time, currency, original amount, original currency, parent, location, and status. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Imported Transactions Show as Cleared
I'm using Android Financisto+. I export transactions out of that. Then I import those into GnuCash. But why does GnuCash mark them as Cleared? In the Import Preview window I see a column Financisto+ created called Status and the transactions get "2" in that field. Is that the "Reconciled / Cleared" column? What number should I put there? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconcile window Start Balance, & Reconciled became UnReconciled
> Did you use Filter By Status in the Credit Card register and select "Unreconciled" ? No, but thanks for the tip. I bet that will help me next time. On Sat, Mar 30, 2024 at 4:05 PM David H wrote: > Tom, > > Did you use Filter By Status in the Credit Card register and select > "Unreconciled" ? > > Cheers David H. > > > On Sun, 31 Mar 2024 at 01:59, Tom Balazs wrote: > >> The problem with the Reconcile Window Start Balance went away after I did >> more reconciling. >> Searching for an error in a statement reconciled 6 months ago is a real >> pain. I hope I don't have to do that again. >> >> On Sat, Mar 30, 2024 at 11:14 AM Tom Balazs >> wrote: >> >> > I went to reconcile a recent credit card statement today. But I noticed >> > something was incorrect. I traced back a problem to about three months >> > prior. Apparently what happened is that my credit card statements were >> > reconciled. But recently I reconciled a few months worth of statements >> for >> > a checking account. I think what happened is I added or deleted a >> transfer >> > from checking to credit card (pay down the balance). >> > >> > Fortunately on the last day of the statement period I add a transaction >> > Description: Balance here should be $150 >> > Transaction amount = 0 >> > Category Miscellaneous >> > Balance column: should show $150. >> > Usually it does. Today it was my indicator that something went wrong. >> > >> > But now I'm having a problem reconciling my statements. >> > Somehow the work I did lead to a problem in Reconcile window Start >> Balance. >> > I marke all transactions as reconciled. >> > The reconcile window says that there is a difference of $19. So it won't >> > let me click Reconcile. >> > But when I look at my end of statement. >> > I see: >> > Description: Balance here should be $150 >> > And the actual Balance column does show $150. >> > >> > This is very confusing. >> > Is there something I can do to get the Reconcile Window Start Balance >> back >> > in order? >> > >> > >> > >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconcile window Start Balance, & Reconciled became UnReconciled
The problem with the Reconcile Window Start Balance went away after I did more reconciling. Searching for an error in a statement reconciled 6 months ago is a real pain. I hope I don't have to do that again. On Sat, Mar 30, 2024 at 11:14 AM Tom Balazs wrote: > I went to reconcile a recent credit card statement today. But I noticed > something was incorrect. I traced back a problem to about three months > prior. Apparently what happened is that my credit card statements were > reconciled. But recently I reconciled a few months worth of statements for > a checking account. I think what happened is I added or deleted a transfer > from checking to credit card (pay down the balance). > > Fortunately on the last day of the statement period I add a transaction > Description: Balance here should be $150 > Transaction amount = 0 > Category Miscellaneous > Balance column: should show $150. > Usually it does. Today it was my indicator that something went wrong. > > But now I'm having a problem reconciling my statements. > Somehow the work I did lead to a problem in Reconcile window Start Balance. > I marke all transactions as reconciled. > The reconcile window says that there is a difference of $19. So it won't > let me click Reconcile. > But when I look at my end of statement. > I see: > Description: Balance here should be $150 > And the actual Balance column does show $150. > > This is very confusing. > Is there something I can do to get the Reconcile Window Start Balance back > in order? > > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reconcile window Start Balance, & Reconciled became UnReconciled
I went to reconcile a recent credit card statement today. But I noticed something was incorrect. I traced back a problem to about three months prior. Apparently what happened is that my credit card statements were reconciled. But recently I reconciled a few months worth of statements for a checking account. I think what happened is I added or deleted a transfer from checking to credit card (pay down the balance). Fortunately on the last day of the statement period I add a transaction Description: Balance here should be $150 Transaction amount = 0 Category Miscellaneous Balance column: should show $150. Usually it does. Today it was my indicator that something went wrong. But now I'm having a problem reconciling my statements. Somehow the work I did lead to a problem in Reconcile window Start Balance. I marke all transactions as reconciled. The reconcile window says that there is a difference of $19. So it won't let me click Reconcile. But when I look at my end of statement. I see: Description: Balance here should be $150 And the actual Balance column does show $150. This is very confusing. Is there something I can do to get the Reconcile Window Start Balance back in order? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Rollover IRA and brokerage account
I want to add accounts to my chart of accounts. I need to add a Rollover IRA (which is a cash account). And I need to add a Trust, which is a brokerage account (the financial institution calls it a Resource Management Account) On the institution's website I can see that it contains mutual funds, corporate notes and bonds, and a "cash money fund". How do I add that into my chart of accounts? Would the rollover IRA go under "Current Assets" and just be an account like a checking account? In my COA I see Investments: Brokerage Account - Bond - Market Index - Mutual Fund - Stock Would those accounts be the place to put the mutual funds, corporate notes and bonds, and the "cash money fund". I will be selling assets and I need to track what is sold, at what price, taxes paid, and fees paid. Thanks, Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Manage Document Link
I want to attach an image of a bill to a transaction. I click Manage Document Link. I get "Path head not set, using "/home/tom/" for relative paths. Is that the best Path to use? Where does GnuCash begin navigating from? I would like the path to be relative so that if I move all my GnuCash files to another folder the document links will still work. Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] View Transactions After Importing from CSV
I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't find it again. Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports for Personal Finance
How do I navigate to the correct style sheet to edit it? On Wed, Dec 6, 2023, 7:06 PM R Losey wrote: > I haven't tried to change column widths. I expect that you may need to > edit the Style Sheets, but I have not attempted to do so. > > > > On Tue, Dec 5, 2023 at 7:49 PM Tom Balazs wrote: > >> Thanks, that's very helpful. I followed your recommendations and I like >> the report much better now. >> >> One thing, how do I make the column width for Description narrower. Do I >> have to use Edit->Style Sheets to do that? >> >> Tom >> >> On Tue, Dec 5, 2023 at 12:46 PM R Losey wrote: >> >>> >>> >>> On Tue, Dec 5, 2023 at 9:48 AM Tom Balazs >>> wrote: >>> >>>> I finished importing and reconciling months of bank data. Now I want to >>>> put >>>> that to good use. >>>> >>>> For the case of an individual or a family, what are the most useful >>>> reports? >>>> >>>> Common advice is that your emergency savings account should hold enough >>>> to >>>> cover 6 months of expenses. In order to to do that, I need to know my >>>> average monthly expenses. I guess I can use the Cash Flow report, look >>>> at >>>> "Money Out" and divide that by how many months have gone by in the >>>> year. Is >>>> there a better way to get average monthly expenses? >>>> >>>> I like the Cash Flow report. But I wish I could sort it by amount, high >>>> to >>>> low. That would be good to see as a stacked bar chart or a regular bar >>>> chart. >>>> >>>> I would like to see a multiple-account balance as a line chart or a bar >>>> chart. In a way that shows me balances over time. >>>> >>>> I guess I'm mostly interested in the Income and Expense reports, but >>>> also >>>> in Assets and Liabilities. >>>> >>>> What reports do you find useful? >>>> >>>> Tom >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> To update your subscription preferences or to unsubscribe: >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> - >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>>> >>> >>> The Transaction Report is excellent. >>> >>> You'll need to select your accounts (you can start with selecting all of >>> the Expense accounts - possibly Income as well, but the real key is to go >>> into the Options display, go to the Sorting tab, change the Secondary key >>> to "Date" with a monthly subtotal. Also go to the Display tab, scroll down >>> and enable the "Subtotal Table". >>> >>> You will then have, at the top of the report, for each month in your >>> selected range, an amount by month with an average at the end. >>> >>> I find this very useful. >>> >>> -- >>> _ >>> Richard Losey >>> rlo...@gmail.com >>> Micah 6:8 >>> >> > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports for Personal Finance
Thanks, that's very helpful. I followed your recommendations and I like the report much better now. One thing, how do I make the column width for Description narrower. Do I have to use Edit->Style Sheets to do that? Tom On Tue, Dec 5, 2023 at 12:46 PM R Losey wrote: > > > On Tue, Dec 5, 2023 at 9:48 AM Tom Balazs wrote: > >> I finished importing and reconciling months of bank data. Now I want to >> put >> that to good use. >> >> For the case of an individual or a family, what are the most useful >> reports? >> >> Common advice is that your emergency savings account should hold enough to >> cover 6 months of expenses. In order to to do that, I need to know my >> average monthly expenses. I guess I can use the Cash Flow report, look at >> "Money Out" and divide that by how many months have gone by in the year. >> Is >> there a better way to get average monthly expenses? >> >> I like the Cash Flow report. But I wish I could sort it by amount, high to >> low. That would be good to see as a stacked bar chart or a regular bar >> chart. >> >> I would like to see a multiple-account balance as a line chart or a bar >> chart. In a way that shows me balances over time. >> >> I guess I'm mostly interested in the Income and Expense reports, but also >> in Assets and Liabilities. >> >> What reports do you find useful? >> >> Tom >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > The Transaction Report is excellent. > > You'll need to select your accounts (you can start with selecting all of > the Expense accounts - possibly Income as well, but the real key is to go > into the Options display, go to the Sorting tab, change the Secondary key > to "Date" with a monthly subtotal. Also go to the Display tab, scroll down > and enable the "Subtotal Table". > > You will then have, at the top of the report, for each month in your > selected range, an amount by month with an average at the end. > > I find this very useful. > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reports for Personal Finance
I finished importing and reconciling months of bank data. Now I want to put that to good use. For the case of an individual or a family, what are the most useful reports? Common advice is that your emergency savings account should hold enough to cover 6 months of expenses. In order to to do that, I need to know my average monthly expenses. I guess I can use the Cash Flow report, look at "Money Out" and divide that by how many months have gone by in the year. Is there a better way to get average monthly expenses? I like the Cash Flow report. But I wish I could sort it by amount, high to low. That would be good to see as a stacked bar chart or a regular bar chart. I would like to see a multiple-account balance as a line chart or a bar chart. In a way that shows me balances over time. I guess I'm mostly interested in the Income and Expense reports, but also in Assets and Liabilities. What reports do you find useful? Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash Reconciliation Window
That's it. I entered -4448.88 where I should have entered 4448.88. Thank you! On Mon, Nov 27, 2023 at 6:35 PM Dale Alspach wrote: > What did you enter as the ending balance in the popup when you started the > reconciliation? You should have entered 4448.88. > Dale > > On Mon, Nov 27, 2023 at 4:57 PM Tom Balazs wrote: > >> This statement period begins with a negative balance, so the very first >> transaction (the first in the whole ledger) is in the right column, it is a >> "charge" for $9,851.37. >> Where a business refunded me $7.99 that appears in the left column as a >> "payment". >> When I paid down the credit card balance, that payment for $9,843.38 also >> appears in the left column as a "payment". >> >> Tom >> >> >> On Mon, Nov 27, 2023 at 5:49 PM Dale Alspach wrote: >> >>> When you look at the account register, you should see two columns next >>> to the balance column. The column on the right (Charge or Increase if not >>> using accounting labels) should begin with 9,851.37; all charges should >>> be in that column as positive entries. All payments should be positive >>> entries in the left column (label Payment or Decrease). The labels depend >>> on whether you selected liability or credit card for the type of account. >>> >>> Dale >>> PS Always send mail to the list, too. >>> >>> On Mon, Nov 27, 2023 at 3:50 PM Tom Balazs >>> wrote: >>> >>>> I see that Reverse Balanced Accounts is: >>>> Income and Expense: unchecked >>>> Credit Accounts: checked >>>> None: unchecked >>>> >>>> GnuCash 4.8 >>>> Ubuntu 22 >>>> >>>> Tom >>>> >>>> >>>> On Mon, Nov 27, 2023 at 4:44 PM Tom Balazs >>>> wrote: >>>> >>>>> However, in my chart of accounts, I see that Credit Card 1 has a >>>>> balance of positive $9,000. >>>>> But my Loans show as a negative balance. >>>>> Why is that? >>>>> >>>>> Tom >>>>> >>>>> On Mon, Nov 27, 2023 at 4:43 PM Tom Balazs >>>>> wrote: >>>>> >>>>>> Yes, in my chart of accounts it is "Liabilities: Credit Card 1" >>>>>> >>>>>> Tom >>>>>> >>>>>> On Mon, Nov 27, 2023 at 4:41 PM Tom Balazs >>>>>> wrote: >>>>>> >>>>>>> Under preferences I see "Accounts / Reverse Balanced Accounts" and >>>>>>> Credit accounts is checked. >>>>>>> >>>>>>> Does that mean that a credit card balance of $100, is actually -$100 >>>>>>> in my net financial worth? In which case it is correctly checked? >>>>>>> >>>>>>> Tom >>>>>>> >>>>>>> On Mon, Nov 27, 2023 at 4:37 PM Tom Balazs >>>>>>> wrote: >>>>>>> >>>>>>>> Yes, I have. >>>>>>>> >>>>>>>> Tom >>>>>>>> >>>>>>>> On Mon, Nov 27, 2023 at 2:27 PM Dale Alspach >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Have you cleared all of the transactions from your statement? >>>>>>>>> Dale >>>>>>>>> >>>>>>>>> Dale >>>>>>>>> >>>>>>>>> On Mon, Nov 27, 2023, 12:02 PM Tom Balazs >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> I'm having trouble understanding the GnuCash Reconciliation >>>>>>>>>> window. >>>>>>>>>> Specifically, the Ending Balance, Reconciled Balance, and >>>>>>>>>> Difference. >>>>>>>>>> Note: I'm not using GnuCash for my personal finances. And I'm not >>>>>>>>>> doing >>>>>>>>>> that because I'm good with my finances. I have struggled with >>>>>>>>>> this stuff. >>>>>>>>>> >>>>>>>>>> You may want to jump to the end of this message. But here is a >>>>>>>>>> detailed >>>>>>>>>> explanation of
Re: [GNC] GnuCash Reconciliation Window
This statement period begins with a negative balance, so the very first transaction (the first in the whole ledger) is in the right column, it is a "charge" for $9,851.37. Where a business refunded me $7.99 that appears in the left column as a "payment". When I paid down the credit card balance, that payment for $9,843.38 also appears in the left column as a "payment". Tom On Mon, Nov 27, 2023 at 5:49 PM Dale Alspach wrote: > When you look at the account register, you should see two columns next to > the balance column. The column on the right (Charge or Increase if not > using accounting labels) should begin with 9,851.37; all charges should > be in that column as positive entries. All payments should be positive > entries in the left column (label Payment or Decrease). The labels depend > on whether you selected liability or credit card for the type of account. > > Dale > PS Always send mail to the list, too. > > On Mon, Nov 27, 2023 at 3:50 PM Tom Balazs wrote: > >> I see that Reverse Balanced Accounts is: >> Income and Expense: unchecked >> Credit Accounts: checked >> None: unchecked >> >> GnuCash 4.8 >> Ubuntu 22 >> >> Tom >> >> >> On Mon, Nov 27, 2023 at 4:44 PM Tom Balazs >> wrote: >> >>> However, in my chart of accounts, I see that Credit Card 1 has a balance >>> of positive $9,000. >>> But my Loans show as a negative balance. >>> Why is that? >>> >>> Tom >>> >>> On Mon, Nov 27, 2023 at 4:43 PM Tom Balazs >>> wrote: >>> >>>> Yes, in my chart of accounts it is "Liabilities: Credit Card 1" >>>> >>>> Tom >>>> >>>> On Mon, Nov 27, 2023 at 4:41 PM Tom Balazs >>>> wrote: >>>> >>>>> Under preferences I see "Accounts / Reverse Balanced Accounts" and >>>>> Credit accounts is checked. >>>>> >>>>> Does that mean that a credit card balance of $100, is actually -$100 >>>>> in my net financial worth? In which case it is correctly checked? >>>>> >>>>> Tom >>>>> >>>>> On Mon, Nov 27, 2023 at 4:37 PM Tom Balazs >>>>> wrote: >>>>> >>>>>> Yes, I have. >>>>>> >>>>>> Tom >>>>>> >>>>>> On Mon, Nov 27, 2023 at 2:27 PM Dale Alspach >>>>>> wrote: >>>>>> >>>>>>> Have you cleared all of the transactions from your statement? >>>>>>> Dale >>>>>>> >>>>>>> Dale >>>>>>> >>>>>>> On Mon, Nov 27, 2023, 12:02 PM Tom Balazs >>>>>>> wrote: >>>>>>> >>>>>>>> I'm having trouble understanding the GnuCash Reconciliation window. >>>>>>>> Specifically, the Ending Balance, Reconciled Balance, and >>>>>>>> Difference. >>>>>>>> Note: I'm not using GnuCash for my personal finances. And I'm not >>>>>>>> doing >>>>>>>> that because I'm good with my finances. I have struggled with this >>>>>>>> stuff. >>>>>>>> >>>>>>>> You may want to jump to the end of this message. But here is a >>>>>>>> detailed >>>>>>>> explanation of my situation. >>>>>>>> >>>>>>>> Credit Card Statement Says >>>>>>>> Previous Balance: $9,851.37 >>>>>>>> Payments Made During This Statement Period >>>>>>>> ... $9,843.38 >>>>>>>> ... $7.99 >>>>>>>> = $9,851.37 So I effectively begin this statement period with a $0 >>>>>>>> balance >>>>>>>> on my credit card. >>>>>>>> Purchases $4,448.88 >>>>>>>> ... 69 purchase transactions >>>>>>>> >>>>>>>> GnuCash >>>>>>>> What should my opening balance be? >>>>>>>> In my Credit Card Ledger I begin with a transaction named "Opening >>>>>>>> Balance", Transfer Account: "Equity: Opening Balances", Charge: >>>>>>>> $9,851.37. >>>>>>>> That shows in the "Equity: Opening Balances" ledger as a "Decre
Re: [GNC] GnuCash Reconciliation Window
In the Reconcile window I have checked off all the appropriate transactions as reconciled. Under preferences I see "Accounts / Reverse Balanced Accounts" and Credit accounts is checked. Does that mean that a credit card balance of $100, is actually -$100 in my net financial worth? In which case it is correctly checked? My credit card is a liability. In my chart of accounts it is "Liabilities: Credit Card 1" However, in my chart of accounts, I see that Credit Card 1 has a balance of positive $9,000. But my Loans show as a negative balance. Why is that? I see that Reverse Balanced Accounts is: Income and Expense: unchecked Credit Accounts: checked None: unchecked I'm using: GnuCash 4.8 Ubuntu 22 On Mon, Nov 27, 2023 at 1:01 PM Tom Balazs wrote: > I'm having trouble understanding the GnuCash Reconciliation window. > Specifically, the Ending Balance, Reconciled Balance, and Difference. > Note: I'm not using GnuCash for my personal finances. And I'm not doing > that because I'm good with my finances. I have struggled with this stuff. > > You may want to jump to the end of this message. But here is a detailed > explanation of my situation. > > Credit Card Statement Says > Previous Balance: $9,851.37 > Payments Made During This Statement Period > ... $9,843.38 > ... $7.99 > = $9,851.37 So I effectively begin this statement period with a $0 balance > on my credit card. > Purchases $4,448.88 > ... 69 purchase transactions > > GnuCash > What should my opening balance be? > In my Credit Card Ledger I begin with a transaction named "Opening > Balance", Transfer Account: "Equity: Opening Balances", Charge: $9,851.37. > That shows in the "Equity: Opening Balances" ledger as a "Decrease" of > $9,851.37. > So I begin this credit card statement period with a liability balance of > $9,851.37. > Just as the Credit Card Statement says: Payments are Made During This > Statement Period > ... $9,843.38 > ... $7.99 > = $9,851.37 Payments Made > > Then just as on the credit card statement I go on to make 69 purchase > transactions totaling $4,448.88. > > I go to the GnuCash Reconciliation window > ... Funds In Total: $9,851.37 > ... Funds Out Total: $14,300.25 > Simple math shows me: Funds Out $14,300.25 - Funds In $9,851.37 = $4,448.88 > So, I'm doing something right. > > But the GnuCash reconciliation window also shows me: > Ending Balance: -$4,448.88 > Reconciled Balance: $4,448.88 > Difference: $8,897.76 > Shouldn't I get to "Difference = $0". This looks like it's telling me I > did something wrong. > What am I missing here? Is this telling me that it is all matched and > reconciled? > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash Reconciliation Window
I'm having trouble understanding the GnuCash Reconciliation window. Specifically, the Ending Balance, Reconciled Balance, and Difference. Note: I'm not using GnuCash for my personal finances. And I'm not doing that because I'm good with my finances. I have struggled with this stuff. You may want to jump to the end of this message. But here is a detailed explanation of my situation. Credit Card Statement Says Previous Balance: $9,851.37 Payments Made During This Statement Period ... $9,843.38 ... $7.99 = $9,851.37 So I effectively begin this statement period with a $0 balance on my credit card. Purchases $4,448.88 ... 69 purchase transactions GnuCash What should my opening balance be? In my Credit Card Ledger I begin with a transaction named "Opening Balance", Transfer Account: "Equity: Opening Balances", Charge: $9,851.37. That shows in the "Equity: Opening Balances" ledger as a "Decrease" of $9,851.37. So I begin this credit card statement period with a liability balance of $9,851.37. Just as the Credit Card Statement says: Payments are Made During This Statement Period ... $9,843.38 ... $7.99 = $9,851.37 Payments Made Then just as on the credit card statement I go on to make 69 purchase transactions totaling $4,448.88. I go to the GnuCash Reconciliation window ... Funds In Total: $9,851.37 ... Funds Out Total: $14,300.25 Simple math shows me: Funds Out $14,300.25 - Funds In $9,851.37 = $4,448.88 So, I'm doing something right. But the GnuCash reconciliation window also shows me: Ending Balance: -$4,448.88 Reconciled Balance: $4,448.88 Difference: $8,897.76 Shouldn't I get to "Difference = $0". This looks like it's telling me I did something wrong. What am I missing here? Is this telling me that it is all matched and reconciled? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] the url "ghelp:gnucash-guide" does not point to a valid page, Ubuntu 22
When I click Help / Tutorial and Concepts Guide I get the error message "The URI ‘ghelp:gnucash-guide’ does not point to a valid page." When I search my hard disk I see /usr/share/doc/gnucash-docs/gnucash-help-en/ which has the "GnuCash Help Manual" in it, in HTML format. How do I fix this link so that it works like it should? I'm on Ubuntu 22.04.3 LTS. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reconciling Accounts, Month 6, but not Months 1-5?
Is it possible to reconcile April-May if I have not reconciled March-April or February-March? I guess I'm asking because I used the GnuCash Reconcile featurer and it appears to me that I can't. That seems strange to me. I just want GnuCash to give me a kind of a worksheet where it shows me transactions between my chosen BeginDate and EndDate. And it uses "Bank Said Balance Began At", and "Bank Said Balance Ended At". I enter (or confirm) transactions. I can mark them as cleared. And then there is "My Bookkeeping Says My Balance Ended At" and that is compared to "Bank Said Balance Ended At". What if in June I imported all transactions to date, but right now all I can handle is confirming the May-June transactions. What is the best way to confirm transactions. Should I just mark them as "cleared"? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Financisto: How to Import Chart of Accounts Exported Out of GnuCash
I exported the Chart of Accounts out of GnuCash, in CSV format. I want to import that to Financisto (Android). I think I did that in the past. In Financisto, the Menu / CSV Import seems to be for importing transactions. Under Accounts I can create an account, but I don't see where I would import a CAO that is in a CSV file. How can I do that? Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Android Companion App, Export CSV
At one point I was using Financisto ("Open-source personal finance
manager") on my Android phone. But I don't even see that in Google Play
anymore.
Does anyone know if that is still in active development?
This website seems to say that it is.
https://financisto.en.softonic.com/android
On Google Play there is "Financisto Plus" by Blucat, but that seems to be a
different project.
UpToDown.com shows Financisto 1.8.2 by Denis Solonenko
https://financisto.en.uptodown.com/android
And GitHub has Financisto under the name of dsolenko, but it looks like it
hasn't been modified in about 4 years
https://github.com/dsolonenko/financisto
On Thu, Sep 7, 2023 at 10:57 AM Tom Balazs wrote:
> I'm a GnuCash and Android user. I'm liking GnuCash on Ubuntu. Now I'm
> looking for an Android bookkeping app.
>
> Something where I import my Chart of Accounts to it. I want to enter
> transactions on a daily basis, export transactions as CSV, and then then
> import the CSV to GnuCash. Preferably a free app. Split transactions would
> be good, but maybe not mandatory
>
> I know GnuCash Android is not officially connected.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] Android Companion App, Export CSV
I'm a GnuCash and Android user. I'm liking GnuCash on Ubuntu. Now I'm looking for an Android bookkeping app. Something where I import my Chart of Accounts to it. I want to enter transactions on a daily basis, export transactions as CSV, and then then import the CSV to GnuCash. Preferably a free app. Split transactions would be good, but maybe not mandatory I know GnuCash Android is not officially connected. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Expenses by Account
What is the best report to use if I want to show all my expenses for TimePeriodX broken down by account (e.g. Expense:Groceries, Expense:Auto, Expense:Restaurant). And how do I view trends over time (e.g. last month "Expense:Restaurant" seemed high, but show me "Expense:Restaurant" each month for the past 6 months). Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Enter Account in CSV Before Import
In order to enter a column with the Transfer Account: I Exported Account Tree to CSV. I am able to get out of that EXPENSE:"Expenses:Auto":Auto::Auto:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Fees":Fees::Fees:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Fuel":Fuel::Gas EXPENSE:"Expenses:Auto:Parking":Parking::Parking:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Repair and Maintenance":Repair and Maintenance::Repair and Maintenance:::USD:CURRENCY:F:F:F Then I extracted the "between the double quotes text". I used =REGEXEXTRACT(A49,"\""(.*?)\""") And put that in a column named "Transfer Account" Expenses:Auto Expenses:Auto:Fees Expenses:Auto:Fuel Expenses:Auto:Parking Expenses:Auto:Repair and Maintenance But when I use the Transaction Import Assistant the Transfer accounts are still unmapped. I still have to "Select a Row to Change the Mappings". That's pretty good. And if there are multiple "Expenses:Auto:Fuel", I'm still just mapping it once. And this avoids any chance that GnuCash will just create new accounts on import. On Sun, Sep 3, 2023 at 11:20 AM Geert Janssens wrote: > Op zondag 3 september 2023 15:47:26 CEST schreef Tom Balazs: > > > I'm importing checking account transactions from a CSV file. > > > > > > I see that in the Transaction Import Assistant I can > > > A. Choose Account at the top of the Assistant (Import Preview), where I > > > would designate it Checking Account #1 > > > OR I can > > > B. Choose Account as a column heading. Where I would designate it: > Expense: > > > Auto : Auto Repair > > > I can't do both. Is there a way for me to do both? > > > That might save me the trouble of having to go in an manually choose > > > account for each transaction. > > > > > > Check Account #1 Transaction ... Date: 1/1/23, Description: Bob's Auto, > > > Account: Auto Repair, Amount: 50.00 > > A transaction in GnuCash involves (at least) two accounts. > > I assume you want to import a csv file with several transactions related > to your Checking Account #1. As the example you give doesn't have a column > with this account name in it, that's probably what you want to set as your > base account. Your csv example holds the other account related to the > transaction: "Auto Repair". In the CSV importer that's known as the > "Transfer account". You should be able to select that in the list with no > issues. > > Put differently: if your csv data has two account columns, one will be > your "Account" and the other will be "Transfer Account". If you only have > one account column, the whole csv file is assumed to go into one account. > That account is what you have to set as base account. The column in your > csv data will be the "Transfer Account" in this case. > > Regards, > > Geert > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Import Transactions: Withdrawals vs Deposits, and Account
Problem solved: the withdrawal columns were all negative numbers. I changed them to positive and it worked correctly. On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs wrote: > I'm importing transactions into a checking account. Why do all transaction > amounts go into the deposits column? > > I'm trying to import transactions one month at a time for a checking > account. > I have a CSV file with one month of transactions. I went through the > Transaction Import Assistant / Import Preview. I set "Import Account" to > the checking account. I use the column headings map Date column, > Description column, Withdrawals, and Deposits. Many > withdrawal transactions, few deposit transactions. I import. And then I > view the ledger for that checking account and all the transactions are put > in the Deposits column. How do I fix this problem? > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to Enter Account in CSV Before Import
I'm importing checking account transactions from a CSV file. I see that in the Transaction Import Assistant I can A. Choose Account at the top of the Assistant (Import Preview), where I would designate it Checking Account #1 OR I can B. Choose Account as a column heading. Where I would designate it: Expense: Auto : Auto Repair I can't do both. Is there a way for me to do both? That might save me the trouble of having to go in an manually choose account for each transaction. Check Account #1 Transaction ... Date: 1/1/23, Description: Bob's Auto, Account: Auto Repair, Amount: 50.00 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Import Transactions: Withdrawals vs Deposits, and Account
I'm importing transactions into a checking account. Why do all transaction amounts go into the deposits column? I'm trying to import transactions one month at a time for a checking account. I have a CSV file with one month of transactions. I went through the Transaction Import Assistant / Import Preview. I set "Import Account" to the checking account. I use the column headings map Date column, Description column, Withdrawals, and Deposits. Many withdrawal transactions, few deposit transactions. I import. And then I view the ledger for that checking account and all the transactions are put in the Deposits column. How do I fix this problem? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)
According to John Ralls: "Several others have answered the question already: Import small pieces, a month or two at a time, until the matcher gets it mostly right, then move to larger pieces. This is another common issue to users coming to GnuCash from Quicken and there's a longer explanation at https://wiki.gnucash.org/wiki/Quicken_Migration."; On Sun, Aug 13, 2023, 12:22 PM john wrote: > > > On Aug 13, 2023, at 07:13, Tom Balazs wrote: > > (I know these are called accounts in GnuCash, but > I mean "account" like "auto expenses", and "home repair expenses", not > "account" like "Credit Card #1", and "Checking Account #1".) > > > That indicates that you don't understand double-entry accounting. They're > not called accounts, they *are* accounts. You need to spend some time > studying the Tutorial and Concept Guide and perhaps a basic accounting > text. > > Regards, > John Ralls > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)
I'm importing a large number of transactions into GnuCash. I want to speed up entering the expense category (account) of transactions, especially for credit card transactions. (I know these are called accounts in GnuCash, but I mean "account" like "auto expenses", and "home repair expenses", not "account" like "Credit Card #1", and "Checking Account #1".) There are two ways I could do that: 1. Create a column for account in the CSV file (exported from the bank's site), sort by payee name and enter account (expense category). Important, I need this to conform to the expense categories I created in GnuCash; I don't want GnuCash to automatically create new expense categories with the expense. That could lead to small typos creating new categories; e.g. "auto repair" and "auto rpeair". 2. Or I want to import all the transactions, and then in GnuCash sort by payee name, and then add expense category to 10-15 transactions at a time. How can I do that? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
