Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

That is dependent on the business. Not all businesses operate on those terms. I am in 100% agreement that quotations/proformas are 'useful' and they might even be so to a significant proportion of businesses. But they are not 'accounting' and (from my personal experience) do not exist in

Re: [GNC] A repository for user-contributed files

Thanks for the link, and I'll take a look, but I am curious... Why not just post that info on the Wiki in that place? What happens if your company site goes down/dark? Do the various tips not still apply to GnuCash which has no relation to your company? Are you opposed to sharing your tips

[GNC] Report 'Equity Statement' - Investments and Withdrawals are always "0.00"

Hello, My report 'Equity Statement For Period Covering 01.01.2021 to 31.12.2021' shows: Capital, 01.01.2021 >> "correct value" Net income for Period >> "correct value" Investments for Period 0.00 Withdrawals for Period 0.00 Increase in capital >> "correct value" Capital, 31.12.2021 >> "correct

Re: [GNC] 4.9 account set up of going business

Please disregard. About a year ago, I set up a new Gnucash data file and chart of accounts. I remember making some mistakes setting up the opening balances. I recollect having problems changing the Opening Balance entries and having to edit the Opening Balances account (from the Accounts

Re: [GNC] Incorrect QFX Import

OK, that would have been too easy :D... Any chance you could send me the OFX? Remove anything that's private in it if you want. I'll debug on my end. If you get a chance, open a bug, and put the file there, otherwise send it to me directly... Thanks! Jean On 12/29/2021 7:58 PM, Steve Cohen

Re: [GNC] Incorrect QFX Import

There do not appear to be any duplicate FITIDs here. I ran the command grep FITID downloaded.QFX | sort > fitid.txt and could easily see that there were no duplicates in the 136 entries in the file. The bank (Chase) appears to assign FITIDs of the form mmDD# where # is a consecutive number

Re: [GNC] 4.9 account set up of going business

Hi, thanks for that, but I cannot find any mechanism to "unlock" a read only account, nor does there seem to be anything in the manual about "unlocking?" Please clarify. On Wed, Dec 29, 2021 at 9:29 PM William Prescott wrote: > I'm not sure if this is relevant … > > By default, the Opening

Re: [GNC] 4.9 account set up of going business

I'm not sure if this is relevant … By default, the Opening Balance account is locked and transactions are only created there when you create a new account and give it an opening balance. But you can unlock the Opening Balance account and then adjust the transactions or add or delete them like

Re: [GNC] Advancing scheduled transactions

Roger, That would be nice.  Need to enter an enhancement request to have that added during the copious amounts of free time the developers have! But, to get around that limitation, I do use the "Create in Advance" so it is in the register early (but for the scheduled date).  That way I can

Re: [GNC] 4.9 account set up of going business

> On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen > wrote: > > I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately, > there appears to be some sort of corruption in my file. > > I am now doing it over in 4.9. > > However, I am having a problem with the Opening

Re: [GNC] Incorrect QFX Import

There a debug flag you can enable to have info printed out when transactions are skipped, but I don't remember off the top of my head which flag that is. On 12/29/2021 3:42 PM, Christopher Lam wrote: It would be nice to have visibility of these imported transactions? Checkbox at the bottom

Re: [GNC] Advancing scheduled transations

Exactly. I know how to program scheduled transactions and how to change them. But I don't want to change the entire schedule for a one time early deposit. You describe it perfectly, "right-click a scheduled transaction and have a post now option or even a skip this time option." I suspect such is

Re: [GNC] Advancing scheduled transactions

Steve, Just want the option to trigger a post manually, not a permanent change in the schedule. As you do, I set up my scheduled transactions to post on the 1st of the month regardless of the date of the transaction. I usually wait till the first to pay and post my bills to accommodate the

[GNC] 4.9 account set up of going business

I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately, there appears to be some sort of corruption in my file. I am now doing it over in 4.9. However, I am having a problem with the Opening Balances for 2020, as I seem to be unable to set up an opening balance for retained

Re: [GNC] Incorrect QFX Import

It would be nice to have visibility of these imported transactions? Checkbox at the bottom would reveal them, all grayed out, and clicky link to the matched split in the register? From: [1]Jean Laroche Sent: Thursday, 30 December 2021 6:18 AM To: [2]gnucash-user@gnucash.org

Re: [GNC] Incorrect QFX Import

GC will not import an ofx transaction it thinks it already has imported. To determine whether a transaction has been imported GC looks at the FITID. So if two transactions in your OFX file have the same FITID, the second one won't be imported. Can you check that the transactions that are

Re: [GNC] Incorrect QFX Import

Additionally, I tried exiting GnuCash and trying the import again. This made no difference. On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen wrote: > I downloaded all of 2021's transactions from my bank in QFX format and > tried to import the file. > > As I was doing so, I noticed an anomaly. I

[GNC] Incorrect QFX Import

I downloaded all of 2021's transactions from my bank in QFX format and tried to import the file. As I was doing so, I noticed an anomaly. I receive monthly direct deposits from a pension, all arrive on or shortly after the first of each month, the same amount every month. But on the QFX import

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On Wed, 29 Dec 2021 at 20:16, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Quotations/Proformas are not basic functionality. They aren't even > 'accounting'. (Invoices and Credit Notes are however) > Quotations are certainly not accounting, but they are really useful to a

Re: [GNC] A repository for user-contributed files

On Tue, 14 Dec 2021 at 00:36, D. wrote: > Dr. Kirkby, > > I appreciate your enthusiasm for this idea. > > I honestly doubt you'll get many contributors. > Far more useful, in my opinion, is for users to share their tricks for > getting gnucash to do their bidding, for which pages on the wiki

Re: [GNC] Exporting invoices and vendor bills to excel or Quickbooks

Yes. 1.) Find (from the CoA tab) For Invoices: Do a Find where the Account matches AR and Value has Debits ≥ 0.00 For Bills: Do a Find where the Account matches AP and Value has Credits ≥ 0.00 *For Credit Notes for each of AR/AP, change to Value has Debits/Credits ≤ 0.00

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

Yes, and the CSV schema is covered in the documentation. So one can use an outside app to generate a Quote/Proforma and then import the final invoice data to GnuCash for accounting purposes. Regards, Adrien On 12/29/21 7:24 AM, Maf. King wrote: just a thought. Create the Quote outside GC,

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On 12/29/21 7:00 AM, Dr. David Kirkby wrote: On Wed, 29 Dec 2021 at 03:41, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I thought the document number was assigned on creation, but I'd have to verify. (you can't delete an invoice for example, and you'd have to change the number to

Re: [GNC] Advancing scheduled transations

Thanks, Dan and Glenn, both are good options. I like Dan's option better for this "Holiday" scenario, but there are occasions where I think Glen's idea would work better. Good thing I have two work arounds now! Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile

Re: [GNC] Advancing scheduled transations

Hi Gyle, If the payment isn't consistent, using "duplicate" monthly may work better in your case. If the early pay is a rare occurrence, you could duplicate for that month and then change the start date in the scheduled transaction for the next month. On Wed, Dec 29, 2021 at 12:00 PM Gyle

Re: [GNC] Advancing scheduled transations

There is the option to create the entry so many days in advance. Then you can edit the date of the transaction. Dan On December 29, 2021 12:01:37 PM Gyle McCollam wrote: Editing works, but then you have to go back and edit it again to get it back on the "correct" schedule. Thank You,

Re: [GNC] Advancing scheduled transations

Editing works, but then you have to go back and edit it again to get it back on the "correct" schedule. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com email From:

Re: [GNC] Advancing scheduled transations

Roger, I was just looking at that the last few days myself. It would be fantastic if you could say right-click a scheduled transaction and have a post now option and even a skip this time option. I know if the payday comes on a Saturday or a Sunday you can set, under frequency/except on

Re: [GNC] Advancing scheduled transations

To edit a scheduled transaction, use Actions > Scheduled Transactions > Scheduled Transaction Editor. To enter a scheduled translation into the account register use Actions > Scheduled Transactions > Since Last Run... There is a lot more detail in the help manual. On Wed, Dec 29, 2021 at 10:24

[GNC] Advancing scheduled transations

Is there a way to advance a specific scheduled transaction in Version: 4.6 Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a scheduled transaction for example when I get paid before the end of the month. I don't see a way to do that. Hasn't been one as far as I know in previous

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

just a thought. Create the Quote outside GC, then iff the quote is accepted, import into GC? ISTR that it may be possible to CSV import an invoice? Best wishes for 2022, Maf. On Wednesday, 29 December 2021 13:00:30 GMT Dr. David Kirkby wrote: > On Wed, 29 Dec 2021 at 03:41, Adrien

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On Wed, 29 Dec 2021 at 03:41, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I thought the document number was assigned on creation, but I'd have to > verify. (you can't delete an invoice for example, and you'd have to > change the number to something like 'use next' if you made an