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 prefere
I recently started using GNUCash at the end of 2017. I'm very thankful I
found this app. I'm using version 2.6.19.
For managing my checking account, my main strategy is to simply download
QFX files from my bank and import. Using this approach, I've found that
pre-entering transactions usually b
On Wed, 14 Feb 2018, John Ralls wrote:
Is the trial balance report in balance on 1 Jan 2017?
John,
Yes. Thank you for asking. Because I rarely look at the Accounts tab I was
unaware that the Imbalance account was directly accessible until Mike
pointed me to it
Working from the Imbalance
I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but I
can not see how to export them...
The File > Export menu offers...
1 - Export Account Tree to CSV2 - Export Transactions to CSV3 - Export Accounts
BTW, difference between 1 and 3 above ? Maybe 3 just exports the top le
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
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 neede
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
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 n
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"
Subject: Re: trial balance - how to find mismatch que
> 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 AqBankingUsers.jpg).
> Also, the cho
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
Holly,
I’m relying on what I see from an export, but here’s something that might help:
‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In Wallet'
where ‘name’ is just ‘Cash In Wallet’
All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ fields
contain ‘CUR
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 t
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
https://ww2.odu.edu/~lhenry/acc
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, te
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
> Payables Aging or Recei
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> wrote
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,
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
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
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-applying the original.
>
>
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 i
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 issues.
>
> David C
>
> On
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 matching procedure on an import
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
DaveC49,
If it appeared that I was talking to you I apologize. I was using a
cellphone and couldn't see what I was doing.
I was trying to emphasize to Ramble that importing should not be confused
with reconciling.
The documentation has been very sparse and vague so it does not help to
clear up
No problem David.
I was interested because I was importing OFX data at the time I saw the post
and I have often been confused about exactly what happens, even though most
of the time it works without any problem. It appears that that when R is
checked in the import window, it sets the A column i
FYI:
Commodityn=commodity namespace=CURRENCY for currencies or NASDAQ for
commodities on NASDAQ (see
https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-security-edit.html)
Commoditym=commodity mnemonic=USD for us dollar or AAPL for Apple stock=the
symbol in the page referenced hereabove
On Feb
28 matches
Mail list logo
