Hello,
I added a new user for my Charles Schwab investment account, and it
retrieved accounts and found my account.
I then matched it when an existing mutual fund account that I created
in gnucash.
However, when I try to retrieve transactions, it says:
AqBanking v6.1.4.0stable
Sending jobs to
Michael,
Exactly. The QFX file only contains the information that the bank would
put on your monthly account statement along with the necessary
infrastructure to identify which bank created the file and which account
and the time frame which the file describes and sometimes some additional
Hello David,
In looking at the QFX file, I only see one side of the transaction. This
file has 3 distinct transactions ( records) that are not related
and only one account ID is listed.
Michael
On Mon, Jul 27, 2020 at 5:56 PM David Carlson
wrote:
> There is another use case which GnuCash
I am not proficient in css but the is a lot that has changed in the naming
of many of the tags. Attached is an example of some of the slight change in
names. Nowonder they did not work. The one you posted I had working for 3.91
but the tag names jhas been updated
If someone from the Dev team
Thanks, Adrien
I found that out yesterday when I created an invoice but didn't post it
I'll live with it until I can track them all down. My goal is to eventually
delete the AR module.
Bruce
Try Business > Customer > Find Invoice, then set criteria to `Is
posted?` and uncheck the box. (without
On 27/07/2020 11:56 pm, "Lipp F." wrote:
Just installed 4.1 on Windows 10 and advanced portfolio report throws an
error. The report was working fine on 3.10. Here it is:
Report error
An error occurred while running the report.
In c-interface.scm:
24:4 19 (gnc:call-with-error-handling _
There is another use case which GnuCash also needs to handle. Some OFX
files may contain both sides of an inter-account transfer between two
accounts within the same bank because the OFX file can include multiple
accounts. In fact, I do that on a regular basis at one of my banks. I do
not test
Fross, Michael,
Are you trying to match bank payments to credit card accounts from QFX/OFX
downloads from both sides? If so, the FITID's might accidentally match but
the FID and/or BANKID and/or ACCTID of the bank/credit card transaction
split line in the import file should be different from
Got it. Thanks. Now I understand why it used to work. And I certainly
wouldn't expect GnuCash to correct a bank's horrible behavior. I'll keep
an eye on the FITID and see if that's what they are doing.
Thanks everyone for your help. Much appreciated.
Michael
On Mon, Jul 27, 2020 at 5:13 PM
Ah, OK I get it now!
Yes, you should check that from one day to the next, the FTID returned
by citibank remains the same (for the same transaction). If not, then
that's going to be a problem.
What has changed recently with GC is that it not will not match a new
imported transaction with one
No. Section 3.2.3 of the OFX 1.6 spec:
"An FI (or its Service Provider) assigns an to uniquely identify a
financial transaction
that can appear in an account statement. Its primary purpose is to allow a
client to detect
duplicate responses. Open Financial Exchange intends for use in
statement
Here ya go.
/* This is an example GTK CSS file that can be used with Gnucash.
Simply copy this file to the location specified below according
to your platform and then restart gnucash.
- Windows: CSIDL_APPDATA/GnuCash
(or the default is users\%USERNAME%\AppData\Roaming\GnuCash)
-
Chris can you upload a copy here
I want to compare with my GNC 3.91 custom CSS that I had and worked, maybe
they changed the css tags
I I have installed Flatpack GNC, cannot find a css for it
I spent weeks before customizing my own before
Having issues with the concept using the gtkinspector
Hi Christopher. Alas I do not keep the QFX files. I'll hang on to them
for now and see if the FIDID does change.
On Mon, Jul 27, 2020 at 4:20 PM Christopher Lam
wrote:
> As I understand the ofx spec*, the fitid should be an invariant for the
> bank and account. By any chance do you have older
Hi Jean. Let me try to better explain my issue.
On most days, I download QFX files from my Checking and Credit Card
accounts and import them. In this way I clear transactions and I can see
what's going on. The next day I'll do so again, and the importer skips
those that have already been
I suppose mileage varies. In my experience, I've seen a case or two
(different businesses) where the bank had another signatory appear in
person to sign the check before they would honor it.
If your bank offers this protection, I'd certainly bring it to their
attention when they aren't
As I understand the ofx spec*, the fitid should be an invariant for the
bank and account. By any chance do you have older qfx files to compare?
* https://www.ofx.net/downloads.html
On Tue, 28 Jul 2020, 4:34 am Fross, Michael, wrote:
> Thanks Jean / John for your thoughts. There is a register
There's a misunderstanding here.
This is what GC does:
- It looks at the OFX transaction, which always has an FITID.
- IF GC sees this FITID in one of the register transactions, it skips
the OFX transaction, because it's already been imported (when a
transaction gets imported from the ofx, the
I would not put much faith in requiring two signatures. It is unlikely that
the bank is actually paying any attention to this requirement. I learned
this from a former bank employee who was on the board of a nonprofit I work
with. In other words it is an internal control only.
Dale
On Mon, Jul
There is an example .css file which ships with Gnucash. On macOS, it’s located
here:
/Applications/Gnucash.app/Contents/Resources/share/doc/gnucash/gtk-3.0.css
> On Jul 27, 2020, at 7:56 AM, GTI .H wrote:
>
> I would like it too. but for that we have to run the GtkInspector (
>
Thanks Jean / John for your thoughts. There is a register entry that
matches, IMHO, very closely. I increased the Match Display Threshold from
1 to 3, and then to 6 (which appears to be the highest value allowed.)
Every transaction from the import says "Match Missing."
Digging around a bit,
All but one business or non-profit I've worked for or with had a
two-person signature rule. (over a certain small amount) One still
writes paper checks to keep that standard. (not sure myself how that is
handled electronically)
For the one business that allowed only one signature for any
Will,
That's a basic tenet of access control. (part of accounting itself, and
is in my text book too.)
The the person with access to funds (of any kind) should not be the
person who accounts for those funds. (but should of course provide all
the required documentation for what they do with
Will, of course, get official advice, but I can speak to my prior
experience dealing with Petty Cash and what were taught to me as 'best
practices'.
1. All receipts of physical cash should be kept separate of Petty Cash
and deposited in full, coins and all. Ideally, these should be placed in
Samantha,
Regardless of the shell you must enclose paths with spaces in quotes, e.g.
cd "c:\Program Files (86)\gnucash\bin"
You can use ' instead of " if you like. You can also start typing and use tab
completion, for example type
cd c:\prog
and the shell will change it to
cd 'C:\Program
Sorry John (and everyone). I can't get it to accept (x86) now:
C:\Users\User> cd C:\Program Files (x86)\gnucash\bin
x86 : The term 'x86' is not recognized as the name of a cmdlet,
function, script file, or operable program.
Check the spelling of the name, or if a path was included,
I'm not an accountant or an attorney either. But I've been a manager and
I've caught people stealing from various cash sources. I can attest,
that if you don't track it tightly, even with access control, it will
magically walk away at some point.
Not treating PayPal like an account in your
1. Job Costing
While not 'out of the box and in your face obvious' I think GnuCash can
handle 'Job Costing' at least at a rudimentary level now. This sounds
like a more specific request of the generic 'classes/categories' RFE
that pops up frequently. (another is for revenue/profit centers
Samantha,
Sorry I wasn't more explicit: Yes, each command is a line on its own, followed
by . You need to use quotes around your API key, so
$Env:ALPHAVANTAGE_API_KEY = "[my API key]"
I see that I left off the second quote in the perl command line, it should be
perl 'c:\Program Files
I'd go for the second. Account balances are on amounts (i.e. shares if that's
what the account commodity is) and AFAIK nothing in the account code looks at
split values.
Regards,
John Ralls
> On Jul 27, 2020, at 10:24 AM, David Carlson
> wrote:
>
> I am curious. Is it possible for this
GnuCash itself doesn't have SSL support, so there is indeed no clear way to do
it. You might be able to set up a proxy of some sort.
Regards,
John Ralls
> On Jul 26, 2020, at 12:25 PM, Gregory Patricoski
> wrote:
>
> Hey team,
>
> I am using a postgres database for my gnucash storage, but
Try Business > Customer > Find Invoice, then set criteria to `Is
posted?` and uncheck the box. (without that criteria, others should show
a `Posted` column anyway, 'un-posted' invoices will show "12/31/1969" as
the date - a bug, but usable info still.)
You can of course add criteria, and/or
Ah, forgot about the ID, thanks.
Regards,
Adrien
On 7/27/20 12:31 PM, Jean Laroche wrote:
No,
>> - There's a matching transaction but it's already been matched to an
>> imported transaction at some point so it's not available to be matched
>> to the new imported one.
This means, if you
No,
>> - There's a matching transaction but it's already been matched to an
>> imported transaction at some point so it's not available to be matched
>> to the new imported one.
This means, if you re-import the same file, the register transactions
that were previously imported are marked as
I am curious. Is it possible for this behavior to occur if
1) a commodity account has a balance of zero shares but a residual value
because it has a unrealized gain or loss.
2) a commodity account actually has a tiny share balance or residual value
below the threshold visible at the account
On 7/27/2020 12:13 PM, Stephen M. Butler wrote:
I am able to send along an account ID or Invoice ID and then there is
the entire memo field on the check. I also get an email from the CU (if
I request) stating that it has been sent. I can forward that to the
recipient with additional notes.
Sorry, the report appears to be working correctly for me on MacOS
(10.15.6) using GnuCash 4.1.
The 1st option should be the only one you need to toggle the zero
balanced accounts from appearing.
The 2nd option will remove just the zero figure but retain the account
name if the 1st option is
This appears to mean that if a subsequent import file contained a
duplicate transaction for some reason, (or the user accidentally
selected an already imported file) then duplicates would be imported. Or
am I reading that wrong?
Regards,
Adrien
On 7/26/20 4:56 PM, jean laroche wrote:
-
Without more info on what isn't working, there's not much to help with.
(a copy of your custom file would help)
But you can still do this on your own. (probably best if there are lots
of things to tweak)
1. Install Virtualbox
2. Create a new VirtualMachine and install a linux distribution in
On 7/27/20 2:07 AM, Liz Dodd wrote:
> On Sun, 26 Jul 2020 17:40:19 -0400
> Michael or Penny Novack wrote:
>
>> Having the bank mail a check? When I mail a check, there is always
>> going to be supporting documentation in the envelope along with it.
>> Are you receiving checks with no indication
I've encountered a bit of a Scooby Doo mystery, and I'm hoping someone can
help me figure it out.
My Balance Sheet report consistently includes commodity accounts with 0
balance figures for me, even when I've unchecked "Include accounts with
zero total balances." Trying to reproduce this with a
I would like it too. but for that we have to run the GtkInspector (
https://wiki.gnome.org/action/show/Projects/GTK/Inspector?action=show=Projects%2FGTK%2B%2FInspector)
and it doesn't run on Windows and nobody with an OS that runs GtkInspector
so far hasn’t offered to help.
--
Regards
Em seg.,
Just installed 4.1 on Windows 10 and advanced portfolio report throws an
error. The report was working fine on 3.10. Here it is:
Report error
An error occurred while running the report.
In c-interface.scm:
24:4 19 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 18 (catch
CSS for Windows 10
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Has anyone figured out yet if we can use our custom css.
Would like to get my font sizes and colors back if possible
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
Hi John
I am sorry to have to come back to you for more support on this and
thanks again for your patience.
After some fumbling (am I right that I should type each line you have
typed followed by the "Enter" key? I really am that much of a newb at
this), I got an error message
On Sun, 26 Jul 2020 17:40:19 -0400
Michael or Penny Novack wrote:
> Having the bank mail a check? When I mail a check, there is always
> going to be supporting documentation in the envelope along with it.
> Are you receiving checks with no indication what for? What do you do
> then?
>
There's
Don,
One of the reasons I started using GnuCash was to prepare assignments while
doing a Master's in accounting 10 years ago.
It's value then and now was it could be adapted fairly easily to a variety of
needs and the transition to it from
traditional accounting theory and T accounts was pretty
48 matches
Mail list logo
