[GNC] Request for Automatic Reconciliation Function

2023-01-03 Thread Bite Gao
GnuCash Developers and Maintainers: Hello! While your software has done many tedious jobs previously done by accountants manually, it cannot automatically reconcile its accounting data to the bank statement in its digital form. In my opinion, the automation of

Re: [GNC] Clarification of Total (Period) column

2023-01-03 Thread devaps
I think one shows total as of today and the other shows total for today and beyond… This distinction helps me and I don’t think it’s a bug. For my use case, I setup any future known income or future tax payments till the end of my tax year., by entering all those future transactions at the

[GNC] import settings file

2023-01-03 Thread Kevin T via gnucash-user
All, I have moved the base gnucash data files to a different location on the file system (windows). All of the 'saved' import settings have been lost. Where are these import settings saved?  Is it a single file or embedded in some other ? The import settings aren't covered in the 

Re: [GNC] Are accountants happy with CVS exports?

2023-01-03 Thread Stephen M. Butler
On 1/3/23 17:43, Dr. David Kirkby wrote: multi-page Q his office provides. Do you not provide details of what the individual transactions to your accountant? If you do provide that, do you just use the unedited CSV files exported from GnuCash? Dave I do print off a detailed

Re: [GNC] Transfer between receivable accounts

2023-01-03 Thread Adrien Monteleone
There's no direct method of transferring balances or payments between AR accounts. (sadly, but GnuCash is not unique in this regard) Some type of intermediary account would be required. (likely, one that is a sub-account of AR so as not to disrupt the overall AR balance) While not as 'clean'

Re: [GNC] Are accountants happy with CVS exports?

2023-01-03 Thread Dr. David Kirkby
On Mon, 2 Jan 2023 at 22:08, Stephen M. Butler wrote: > My CPA accepts the Balance Sheet and Profit/Loss Statement along with a > multi-page Q his office provides. Do you not provide details of what the individual transactions to your accountant? If you do provide that, do you just use the

[GNC] Transfer between receivable accounts

2023-01-03 Thread davidvernonlong
I run the accounting for a member's club. Members are customers in the accounts receivables. Sometime a member may pay the invoices of several other members in one cash payment. For example, in family situations where father pays membership invoices of his children who are also members. What I

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread ml
This is what I would expect to see. Note the “Buy” in the Action field. However, I had to add that as the QIF import process doesn’t appear to be doing it. Thank you. > On Jan 3, 2023, at 18:50, Derek Atkins wrote: > > Screen cap came through (at least to me) -- but you cut out too much

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread Derek Atkins
Screen cap came through (at least to me) -- but you cut out too much info so I can't tell what I'm supposed to be seeing or not. -derek On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote: > Yes. Trying again to paste a screen cap. > > > > I also tried on my Linux box and got the same result.

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread ml
Yes. Trying again to paste a screen cap. I also tried on my Linux box and got the same result. No action showing. > On Jan 3, 2023, at 18:27, Derek Atkins wrote: > > Are you in double-line mode? If not, try turning that on.. > > -derek > > On Tue, January 3, 2023 7:16 pm, m...@tgr66.me

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread Derek Atkins
Are you in double-line mode? If not, try turning that on.. -derek On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote: > I only included the snippet relevant to the question; my real file has the > header lines and carets. The back ticks were included because I’m used to > using those to show

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread ml
I only included the snippet relevant to the question; my real file has the header lines and carets. The back ticks were included because I’m used to using those to show a code block :-) They’re not in the real file. I’ll include the entire test file at the end of this message. So I just double

Re: [GNC] new user, new file

2023-01-03 Thread Jamie Tolbert
I got it, thanksjust need to wrap my head around the software, -- Original Message -- From "Adrien Monteleone" To gnucash-u...@lists.gnucash.org Date 1/3/2023 5:12:36 PM Subject Re: [GNC] new user, new file Strange. Placeholder would stop you from editing or adding

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
Strange. Placeholder would stop you from editing or adding transactions in the account, but it doesn't stop me from creating a sub-account. Try creating Owner's Capital as a sub of the parent: Equity instead. Also, what version of GnuCash and what OS? Regards, Adrien On 1/3/23 4:07 PM,

Re: [GNC] new user, new file

2023-01-03 Thread Stan Brown
On 2023-01-03 13:15, Jamie Tolbert wrote: > Starting a new business. For the next month or so, what few bills I have > will be paid by me, until I get my business checking set up. Its been > years since I studied double entry accounting, but I thought if I paid a > bill for lets say 100.00, I

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread Kalpesh Patel
Your QIF may not be complete. I believe it is not documented but need first four lines and the last line as shown in the below example; carets are important in qif format as well! This would be the minimal example: !Account NTest TInvst ^ !Type:Invst D12/2/2022 NBuy PXYZ, INC YXYZ I150 T450 Q3

Re: [GNC] new user, new file

2023-01-03 Thread Jamie Tolbert
I tried that, same results.screenshot attached. I did find where to remove the placeholder option, but same result: -- Original Message -- From "Adrien Monteleone" To gnucash-u...@lists.gnucash.org Date 1/3/2023 5:03:54 PM Subject Re: [GNC] new user, new file Jamie, Please use

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
Jamie, Please use Reply-List or Reply-All to keep the discussion on the list. I've copied your personal reply below. I'm not sure why that would happen. I just added an Equity account with no issue. Let's be sure we're discussing the same thing. At initially creating a new book with

Re: [GNC] new user, new file

2023-01-03 Thread Adrien Monteleone
It sounds like you are considering your current personal payments as your equity investment as you pay, rather than fronting the money and then using it from there. You should be able to simply: Dr. Expense Cr. Equity:Owner's Capital (or whatever you determine is the best name for that

Re: [GNC] Clarification of Total (Period) column

2023-01-03 Thread Adrien Monteleone
Hmmm... I'm seeing the same thing. It appears to default to 'this year' regardless of the setting. I'd call that a bug. Regards, Adrien On 1/3/23 3:14 PM, Kalpesh Patel wrote: I have added a column called ‘Total (Period)’ in the accounts view page but I am not sure what that period is? I

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 2:43 PM, Dr. David Kirkby wrote: Unless I am mistaken, it is not easy to delete transactions when using the business features. I don't think one can simply delete a transaction and it goes away. You can't delete invoices, but you can remove their entries in your books by un-posting.

[GNC] new user, new file

2023-01-03 Thread Jamie Tolbert
Starting a new business. For the next month or so, what few bills I have will be paid by me, until I get my business checking set up. Its been years since I studied double entry accounting, but I thought if I paid a bill for lets say 100.00, I would credit my owner account for 100.00 and debit

[GNC] Clarification of Total (Period) column

2023-01-03 Thread Kalpesh Patel
Hi GNC community – I have added a column called ‘Total (Period)’ in the accounts view page but I am not sure what that period is? I made changes to it in the ‘Edit à Preference à Accounting Period’ but didn’t change the value there so I don’t think the “period” denoted is in anyway reflected

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Dr. David Kirkby
On Tue, 3 Jan 2023 at 17:00, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > On 1/3/23 7:08 AM, Dr. David Kirkby wrote: > > I have the following situation > > > > I'm in the UK, where the currency is GBP > > A customer in Poland paid $540 for consultancy via Zoom. He paid in > >

Re: [GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Adrien Monteleone
That is true, but not the reason GnuCash doesn't offer the facility to delete them. (you could edit and change the invoice number, as a work around) Maybe Derek can shed light on the code reasoning. I vaguely recall it being discussed a few years ago, but I long since lost that thread.

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Adrien Monteleone
I don't think they end up in the same place. I also checked the archive and the message was not there. I only saw it because you also happened to copy me personally. gnucash-user@gnucash.org works gnucash-u...@lists.gnucash.org did not go through. Regards, Adrien On 1/3/23 11:47 AM, Simon

Re: [GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Murugan Muruganandam
Simon Deleting invoices are not allowed as per law in many states. The reason is the tax authorities prefer to see your continous running invoice numbers. i think this came from the tax authorities to avoid any errors/frauds. Again with newer connected tax systems where invoices are

Re: [GNC] Scary moment

2023-01-03 Thread David G. Pickett via gnucash-user
Yes, currently we depend on a lock file, which is sensible in a very traditional model.  In many apps, you can mod a file in one app and other app notifies you that the file changed and you can reload, like two text editors on the same machine. If you have unsaved changes in the less current

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Simon Roberts
This sounds great Steve, thanks. I'll pursue that! Cheers, Simon On Tue, Jan 3, 2023 at 11:34 AM Steve Brown wrote: > Looking further, the taxinvoice report Options->Display screen allows > using an alternate template and css file. On my system, > ~/.local/share/gnucash is on the search path.

Re: [GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Simon Roberts
Hah, well, I did: Business->Customer->FindInvoice. Double click the invoice in the list, close the finder window. Select the invoice "row" Click "Delete" in the toolbar, brings up "Are you sure you want to delete the selected entry" Click yes. But having just tried this with more than one item

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Steve Brown
Looking further, the taxinvoice report Options->Display screen allows using an alternate template and css file. On my system, ~/.local/share/gnucash is on the search path. I put the modified and renamed files there and they get used. This works with a standard distribution. Unless you want to do

Re: [GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Derek Atkins
Hi, On Tue, January 3, 2023 12:33 pm, Simon Roberts wrote: > Back again, and very grateful for your ongoing tolerance and help! > > We just created an erroneous invoice, specifically it was assigned to the > wrong customer. Now we're finding two problems and I'm not sure if it's > user error, or

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Simon Roberts
Steve, Adrien, thanks again. I think I shall have a look at hacking the source for the default invoice. It's important to me to keep my bookkeeper's life as easy as possible during this transition. Fortunately, we have a very simple business with very few clients, and virtually all the work is the

[GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Simon Roberts
Back again, and very grateful for your ongoing tolerance and help! We just created an erroneous invoice, specifically it was assigned to the wrong customer. Now we're finding two problems and I'm not sure if it's user error, or something else. 1) If we try to edit the invoice, and use the pop-up

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 7:08 AM, Dr. David Kirkby wrote: I have the following situation I'm in the UK, where the currency is GBP A customer in Poland paid $540 for consultancy via Zoom. He paid in advance, so I've not added him as a customer under the business features. Murugan answered the main question on

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Adrien Monteleone
Interesting approach concerning modifying the tax invoice. I'd say all of that sounds correct to my understanding as well, save I think you have the Scheme—HTML bit reversed. The files are in Scheme, which generate the report as an HTML table. (not the other way around) I'm pretty sure

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread Derek Atkins
Hi, On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote: > Oops, I guess the mailing list doesn’t show attached images. You need to attach it as a file, not embed it in HTML. > >> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: >> >> In my import file: >> >> ``` >> !Type:Invst >> D12/2/2022 >>

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-03 Thread ml
Oops, I guess the mailing list doesn’t show attached images. > On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: > > In my import file: > > ``` > !Type:Invst > D12/2/2022 > NBuy > PXYZ, INC > YXYZ > I150 > T450 > Q3 > CR > M3 shares @ 150; Nothing to see here > ``` > > Import and GnuCash creates

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Murugan Muruganandam
David your entries should be Dr Assets:Bank account £424 Cr Income:Sales:Services sold worldwide (USD) : 540 Dr Expenses: Bank Fees : £7 when entering the transacitons , conversion pop up will be enabled, use the debit amount option and enter the action amount to avoid conversion issues.

Re: [GNC] Fields present in invoices?

2023-01-03 Thread Steve Brown
I've been wrestling with this too, specifically with regard to invoices. This is a rather lengthy comment. I hope it is useful. Also, if some of this is inaccurate, which is likely, please let me know. I've looked at the wiki and sifted through the code trying to understand how reports work.

Re: [GNC] Invoice emailing?

2023-01-03 Thread Maf. King
Just a further 0.02 on this. generating a PDF in a folder gives you (with no extra work) a handy archive of invoice documents actually generated. If you ever need to quickly refer to one (or have the tax man come to visit), an archive of PDFs is IMHO quicker than firing up GC and searching.

Re: [GNC] Invoice emailing?

2023-01-03 Thread david whiting
Gnucash can use SQLite and that works well. I set up what Cam Ellison described for our football club, where I needed to send about 450 statements at the end of each month showing players how much they had paid and how much they owed. Querying the SQLite database to create the statements as pdf