Re: [GNC] New accounts don't show up in GC
New accounts you create won’t show on the account tree because by default View->Filter By option is set to hide zero balance accounts. Try entering some transactions in the new account. Then it should show up with View->Refresh. Cheers. -- From: rsbrux To: gnucash-user@gnucash.org Subject: [GNC] New accounts don't show up in GC 5.8 under Flathub Message-ID: Content-Type: text/plain; charset=UTF-8; format=flowed When I create a new account in GC (v5.8 running in Flathub under Ubuntu Studio 22.04 LTS), it doesn't show up in the account tree. Clicking "View - Refresh" does not help.? The ony way I have found to get the new account to show up is to use "Edit - Find Account". The new account then shows up in the search results, but with a checkmark in the column "Not Used". When I double-click on the entry in the search results list,? the new account appears in the account tree. ___ 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] CSV Importer - Debit vs Credit
Paul, I don’t use the importer, but from reading the list responses, I seem to recall that if you are using a single column for the amount, then deposits and withdrawals should be of opposite sign. So for a bank import, if you choose debits to be positive, then credits must be negative. You can also preprocess the csv file to separate the debits and credits into 2 separate columns, wherein both amounts can remain positive. This is just from memory. I’m sure folks who use the importer will provide better responses. Cheers. -- From: "Paul Kroitor" To: Subject: [GNC] CSV Importer - Debit vs Credit Message-ID: <02c201dace27$1a8f5b60$4fae1220$@kroitor.ca> Content-Type: text/plain; charset="us-ascii" I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to use CSV for downloading (I hate TD Bank, who have removed the OFX download option). I can't immediately find any old messages describing this particular issue, so I thought I'd just ask. Simplified, TD Bank CSV downloads only basically have four fields: * Date * Description * "Debit" or "Credit" * Amount (always positive) Import works fine, except that I can't see any way (short of pre-editing the file) to get the CSV importer to understand that the amount field goes in a different column (D or C) depending on a different field's value. This must be fairly common - am I just blind? ___ 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] sales tax liability report?
Michael, If I’m not mistaken, Ted mentioned that he was looking for income & liabilities report. Hence my caveat - if the user followed instructions in the guide to setup tax tables and appropriate accounts, the report I mentioned could meet his requirements. In fact, before Income & GST Statement was introduced as part of standard reports, I was doing something similar when India was still under Sales Tax regime. I think at the time, the Transaction Report options had to be tweaked to produce something similar to the standard report now. By income, I presume Ted means net income after accounting for sales tax liability. Cheers. === Date: Thu, 9 May 2024 09:52:49 -0400 From: Michael or Penny Novack To: gnucash-user@gnucash.org Subject: Re: [GNC] sales tax liability report? Message-ID: <44cd4d3d-502e-45cb-8a95-62cd472c5...@comcast.net> Content-Type: text/plain; charset=UTF-8; format=flowed On 5/9/2024 2:57 AM, Deva via gnucash-user wrote: > Ted, > > If you have setup your accounts based on suggestions in the tutorial and > concepts guide, you can try the following report - > > Reports -> Income & Expense -> Income and GST Statement > > In your case, GST = Sales Tax We MIGHT need a clarification, but my sense was that the sales tax amounts collected but not yet sent to the gov't were (correctly) being credited to a liability, not an income account. So would not show up as an account under an I report. In other words, the amount collected (on behalf of some gov't) not being considered income so when paid to the gov't not an expense. Never YOUR money, just holding it for the gov't till sent, quarterly, or whatever. Maybe what we want here is a better description of the report that is wanted? What is it supposed to show?. For example, were I running a business that was collecting sales tax for many states, I'd probably want a report showing how much I owed each << and I think I would be using part of a Balance Sheet report to get that (ignore the rest of it). in other words, I'd have a parent under liabilities "sales tax owed" under which a child for each jurisdiction. Run each quarter (or whatever) looking at JUST this parent and its children to see what payment to make to each jurisdiction >> Michael D Novack ___ 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] sales tax liability report?
Ted, If you have setup your accounts based on suggestions in the tutorial and concepts guide, you can try the following report - Reports -> Income & Expense -> Income and GST Statement In your case, GST = Sales Tax Cheers. — Date: Tue, 7 May 2024 15:35:20 -0700 From: tburmas To: gnucash-user@gnucash.org Subject: [GNC] sales tax liability report? Message-ID: Content-Type: text/plain; charset=UTF-8; format=flowed Hello, ??? Is there a way to have a single report that shows sales tax liabilities?? This would need to have income and liabilities in one report, which I am not sure can be done (at least i haven't found it yet). Thank you, Ted ___ 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.