Re: QFX Import and Reconciled Transactions

Hi David, Agreed that the process of importing of transactions to an account is a separate and distinct process from that of reconciliation with an external statement. Given that however, the import process, if it matches an existing transaction in your accounts will classify a transaction as

Re: QFX Import and Reconciled Transactions

Please do not confuse importing transactions with reconciliation. While you must develop a procedure that is efficient, the OFX import is very error prone and needs to be checked against another reference. David C On Feb 15, 2018 6:16 PM, "DaveC49" wrote: > Any

Re: trial balance - how to find mismatch question

How timely. Any way to solve this or do I just chalk it up? Regards, Adrien > On Feb 15, 2018, at 8:00 PM, David Carlson > wrote: > > If you have multiple currencies or if you buy and sell commodities or > securities there is another level of opportunities for

Re: trial balance - how to find mismatch question

It seems at least in my case, the imbalance really appears to be Gnucash’s fault. I narrowed down the date to my opening date. This should be easy right? Not so fast. Of course, everything is in balance as I expected it to be. So I decided to compare the report totals for each account to the

Re: trial balance - how to find mismatch question

If you have multiple currencies or if you buy and sell commodities or securities there is another level of opportunities for issues. David C On Feb 15, 2018 5:55 PM, "Adrien Monteleone" wrote: > I just noticed the subject was wrong due to a user-digest error, >

Re: QFX Import and Reconciled Transactions

Any matching procedure on an import is not going to be perfect. Make the criteria too tight and almost nothing is matched. Too loose and everything is matched, so it is always a compromise. I have found the order in which I process the OFX imports from my various accounts can have some impact on

Re: Headers for importing accounts from CSV

Sorry, I don’t use that feature at all, so I’ll have to defer. Try a google search on the list with “site:lists.gnucash.org” (without the quotes) followed by your search terms. You’ll get hits only from the list archives. There are many threads on OFX and AqWizard and I doubt you’re the first

Re: trial balance - how to find mismatch question

I just noticed the subject was wrong due to a user-digest error, re-applying the original. ——— I’m having a bit of issue understanding the point of the trial-balance report in modern times. (I generally don’t use it as I mentioned) If each transaction self-balances, that is, debits = credits,

Re: Headers for importing accounts from CSV

Sweet! What a simple solution... Can't believe I didn't think of trying to make an account then export it. Setting up all the accounts I need one by one is painful. Thanks for the info! Regards, Holly Ochidi On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone < adrien.montele...@gmail.com>

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

Nice trick, thanks Chris! Regards, Adrien > On Feb 15, 2018, at 2:47 PM, Chris Good wrote: > > Hi Fran3 & Adrien, > > Currently (2.6.19 or under development in 2.7/3.0), there is no menu option > for exporting customers or vendors. You can do so by using either the >

Re: gnucash-user Digest, Vol 179, Issue 59

The 1899 date seems to make me think that has something to do with a setting in your OS concerning how to interpret 2-year dates. (I don’t think Gnucash has this option, it might be hard coded) Try running the report again and make sure to enter the full 4-digit date and not just ’16’. Also,

Re: gnucash-user Digest, Vol 179, Issue 59

Elmar, If you have narrowed the date range in which the error has occurred then it is down to old fashioned accounting practices for finding errors. Some of these articles may help: http://www.reallifeaccounting.com/pubs/Article_Theme_Detecting_Accounting_Errors.pdf

Re: Headers for importing accounts from CSV

Sorry, I forgot to mention that in the hidden and place_holder columns, the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 should suffice. The tax column also appears to be binary. I think the setting is just a check box for each account that asks “Tax Related?” so

[no subject]

Hi Fran3 & Adrien, Currently (2.6.19 or under development in 2.7/3.0), there is no menu option for exporting customers or vendors. You can do so by using either the Payables Aging or Receivable Aging reports. Use the report options to choose the columns that the imports require, then run the

Re: 1. How do I update the AqWizard version within GnuCash v. 2.6.19 on Windows

> On Feb 15, 2018, at 11:22 AM, Holly Ochidi wrote: > > So for setting up a new user, the AqBanking version that is installed with > GnuCash 2.6.19 is not updated. I do not have the option of entering the > Bank Code while creating a new user (see attachment

Re: gnucash-user Digest, Vol 179, Issue 59

On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: -- Message: 1 Date: Thu, 15 Feb 2018 13:27:17 -0600 From: Adrien Monteleone To: "gnucash-user@gnucash.org"

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

Thanks Adrien, Actually we are using 2.6.19. Looks like I didn't type the number "9" at the end of my last post. Roger on deleting all 2018 transactions but not being able to delete invoices and bills. What we do when we want to 'delete' an invoice or bill is... 1 - create vendor and customers

Re: trial balance - how to find mismatch question

I don’t perform a close-books operation so I never bothered with this report. On a whim I ran it to see what would happen. I’m pretty careful about all of my transactions. Each of them self-balances and my imbalance and orphan accounts are empty. Yet, sure enough, the Trial Balance has $111.59

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

2.6.1 is rather old, by a few years. 2.6.19 is the most current version. As far as I know, even in the most current version, there is no way to export customers and vendors. (might be possible with the upcoming 3.0, but I’m not certain on that) The link I provided was on the assumption you

trial balance - how to find mismatch question

The recent threads on trial balances has me wondering why mine seems to be ~$1600 out of balance, despite having everything else in the account balance and reconcile correctly, i.e. nothing in the imbalance account, and setting the dates to the earliest date in the file and today.  Either I am

Re: Controlling Gnucash from 2 computers

Resilio Sync is an effective and relatively quick way to do this between two computers, and does not leave anything in the cloud, if that matters. --Chris ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription