I have run a Transaction report (for all accounts) for just one day in the
past (to find all the transactions on that one day). It found just one
transaction where I bought 600 yuan for 99.07 USD (at an ATM in china).
The grand totals in the report are 0 USD and 0 yuan.
That one transaction has
On Sat, 7 Jan 2023 at 23:15, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Yes, the principle of Materiality.
The link Geoff gave was quite useful to me. I have noticed some differences
between my calculations and my accountants before. He has replied “That
will be reflected in
If, as Adrien's post asks, it is a credit card type account you are
reconciling check Preferences >> Register >> Automatic credit card payment
- if it's set on you'll get the popup.
Cheers David H.
On Sun, 8 Jan 2023 at 10:09, Kevin T via gnucash-user <
gnucash-user@gnucash.org> wrote:
> OK.
Karl:
I understand your situation. I also keep my books primarily in Canadian
dollars, but track investments in US dollars.
On 2023-01-07 09:56, Karl wrote:
…If I purchase foreign stocks
(foreign to Canada), my broker automatically converts my CAD "broker cash
account" to USD to purchase the
> On 1/7/23 12:23 PM, Stan Brown (using GC 2.6.19) wrote:
>> Update -- 2.6.19 does prompt only once per variable, after all.
>>
>> I thought it did, because, when the transaction fires, the UI for
>> prompting for an amount and accepting is pretty confusing (to me,
>> anyway). I entered the
GnuCash Developers and Maintainers:
Thanks for your suggestion.
Yours,
Bite Gao
Jan 8th, 2023
On 2023/1/8 6:30, Gyle McCollam wrote:
I agree John, this is as close as you need to get to automatic reconciliation.
The only items you need to look at are the ones that don't match and
>>>> On Jan 7, 2023, at 12:53 PM, Jean L
>>>>> <mailto:rip...@gmail.com> wrote:
>>>>>
>>>>>
>>>>> And you're saying that when you import this into a blank account, nothing
>>>>> shows up?
>
Is this an account of type Credit Card by chance?
Regards,
Adrien
On 1/7/23 6:08 PM, Kevin T via gnucash-user wrote:
OK. getting that off the plate.
When i do a reconcile, change the date to the previous reconcile datae, and the
balances match, with no manipulations, when I click the finish
OK. getting that off the plate.
When i do a reconcile, change the date to the previous reconcile datae, and the
balances match, with no manipulations, when I click the finish button, a funds
transfer form pops up!
I saved, exitted, restarted and this behavior is consistent.
Is that
sting, I was
simply trying to get one transaction to work first.
DATA:OFXSGML
ENCODING:UTF-8
0
INFO
20230107105800
ENG
0
INFO
USD
b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING
19700101
20230107
CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Another alternative:
Import one month
Reconcile
Repeat
-
But I'll add another case for including later transactions:
-For whatever reason, you entered them for a later date than they really
occurred.
If they aren't visible, you'll think they are missing and then enter
them againor
True, and sometimes I move the transaction to the actual month. But if it’s
supposed to happen in the future, and happens now instead, if gnucash isn’t
showing me pending transactions after the closing date, then reconciling is
harder because I won’t get the reminder that the credit union was
Yes, the principle of Materiality.
It isn't worth spending time looking for small errors. Just adjust them
out and move on.
Otherwise, I'd say enter the transaction on what you think is the proper
date and re-reconcile.
But that begs the question, how did you reconcile without it?
If you
Glad to hear you got it squared away.
I'm not sure if this has to do with my SX preferences, but I no longer
get a pop-up window for variables. There is an entry field in the Since
Last Run dialog to enter them. (which I have to Tab out of to commit)
That may have been implemented after
As long as the change in value isn't cumulative, I would want to know.
If I wanted to budget the same 'purchasing power' as last period/year, I
would not want to budget the exact same nominal amount. (on that note, a
feature to factor inflation for budgets would be swell!)
But I do
Personally I like it just the way it is as I want to see a full picture of
my account when reconciling and I don't usually have a lot of future
dated txns. I think the OP's issue is that he's not doing just another
monthly reconciliation, he's trying to reconcile months and months of
imported
On 1/7/23 3:41 AM, Chris Green wrote:
I really don't want or need to save reports, it's just one more bit of
configuration that I'd need to keep track of. I want things to be
configured in as few places as possible.
Unfortunately, that's as few steps as you can get right now.
Note, Saved
Technically, if your credit union credits the January payment in December and
you have access to the money in December it should be credited in your books
in December, not January. However, if you enter it as January in your books, I
can see why you would need to have Gnucash look past the
My credit union activates deposits for my account when received. Deposits from
outside that are intended for the first of the month are usually credited in
the prior month. When that happens, I need gnucash to look beyond the end of
the month for the transaction that represents a January
When I write a post dated cheque and the recipient cashed it prematurely, most
banks these days don’t blink an eyelash.
While rare, this is a case where a transaction dated after the reconciliation
window needs to be included.
Sent from my iPhone
> On Jan 7, 2023, at 5:29 PM, Gyle
On 1/7/23 8:29 AM, Dr. David Kirkby wrote:
It’s difficult for me to comprehend why that fancy template in that form
should exist at all. I don’t think anyone could consider it sane. I
reported it a bug
https://bugs.gnucash.org/show_bug.cgi?id=798717
and see it has been closed with a note that
I agree John, this is as close as you need to get to automatic reconciliation.
The only items you need to look at are the ones that don't match and Gnucash
would have no way of knowing what is correct.
Thank You,
Gyle McCollam
Gyle McCollam
I to don't see the need to include transactions whose date falls beyond the
closing date of the reconciliation. Gnucash could cutoff any transactions
whose date is after the closing date. However, I will say that I have gotten
used to this little quirk and since I import most of my monthly
Minor Transactions
Accountants may sometimes deem minor transactions to be immaterial. This
may happen when a financial controller is attempting to close the books
for a particular accounting period. Accountants can choose to omit minor
transactions from the final calculations if they would
GnuCash already provides the nearest thing resembling "automatic"
reconciliation. It requires periodically downloading and importing account
activity from the bank to mark which transactions have 'cleared'. Then, in
reconciliation, GnuCash automatically 'ticks' the cleared transactions. Nine
Your records and the bank's differ. The reconciliation date may include entries
that you've entered with later dates, and how would GnuCash determine the
proper cutoff?
Personally, I don't have trouble determining when the difference figure goes to
0.
David T.
On Jan 7, 2023, 11:45 PM,
ccurred on Line 27, Column
23)LibOFX WARNING: ofxdate_to_time_t():
Successfully parsed date part, but unable to
parse time part of string 20230107. It is not
in proper MMDDHHMMSS.XXX[gmt offset:tz
Is there some reason that the reconcile feature looks past the closing date
specified?
I have imported numerous months of transactions for an account. Trying to
reconcile only the first month with 0 balance and 0 transactions before the
starting date. I provide the 'statement date' to the
get one transaction to work first.
DATA:OFXSGML
ENCODING:UTF-8
0
INFO
20230107105800
ENG
0
INFO
USD
b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING
19700101
20230107
CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim
On Jan 7, 2023,
ARNING: ofxdate_to_time_t(): Successfully
parsed date part, but unable to parse time part of
string 20230107. It is not in proper
MMDDHHMMSS.XXX[gmt offset:tz name] format!(Above message
occurred on Line 28, Column 21)LibOFX ERROR: OpenSP parser: othe
INFO
20230107105800
ENG
0
INFO
USD
b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING
19700101
20230107
CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim
On Jan 7, 2023, at 12:41 PM, Jean L wrote:
Can you post a small OFX file that's
ARNING:
ofxdate_to_time_t(): Successfully parsed date part, but unable to parse time part of
string 20230107. It is not in proper MMDDHHMMSS.XXX[gmt offset:tz name] format!(Above
message occurred on Line 28, Column 21)LibOFX ERROR: OpenSP parser: otherError (misc
parse error):/tmp/libofxtmp
bfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING
19700101
20230107
CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim
But nothing appears to import.
In my logs:
LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting...
(Above message occurred on Line 40, Column 1)
LibOF
Update -- 2.6.19 does prompt only once per variable, after all.
I thought it did, because, when the transaction fires, the UI for
prompting for an amount and accepting is pretty confusing (to me,
anyway). I entered the amount and clicked the OK button, but was
immediately prompted again for the
Family Checking
Using csv2ox with a custom mapper, I get an ofx with guts of the transaction
like this:
0
INFO
USD
b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING
19700101
20230107
CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim
But n
Thanks, John.
I am a self-directed investor, using an online broker. My structure would
be something like this:
Bank account ---> transfer funds to ---> online broker cash account (all in
CAD $) > all my investments
I then use my single online broker cash account to purchase my investments
message occurred on Line 27, Column 23)LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date part, but unable to parse time part of string 20230107. It is not in proper MMDDHHMMSS.XXX[gmt offset:tz name] format!(Above message occurred on Line 28, Column 21)LibOFX ERROR: OpenSP parser
Hi Fred,
Thanks for the thought! I agree the change in value is 10,000. My point is,
basically, that I don't care about currency fluctuations in money already
spent when planning *next* year's budget.
But the 'problem' (which might just be that I need someone to explain what
a 'budget' is!) is
On Sat, 7 Jan 2023 at 14:37, Maf. King wrote:
>
> Is the Effective Legal Tax date 6th or 19th? Enter it to that date. The
> reconcilliation will not be affected either way.
>
> Maf.
Certainly not the 19th, but probably not the 6th either. It was for postage
and a pickup fee. I must have
On 07 January 2023 at 10:21, ml enquirer said:
> Just to add that I was wrong that this could be solved by making budgets
> with a single period. I *think* this problem arises for any multi-currency
> sub-accounts and becomes visible when you have a book which has been
> running for many years.
On Saturday, 7 January 2023 14:21:21 GMT Dr. David Kirkby wrote:
> I'm inputting my 2022 accounts, and have reconciled up to 10/04/2022
> (DD/MM/). Now I just found a refund, dated 06/04/2022, but does not
> appear in the bank account until 19/04/2022. Is it safe to create a credit
> note,
On Fri, 6 Jan 2023 at 23:18, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Fair enough.
>
> I see you managed to clear it up with a registry edit.
>
> I did manage to get a similar looking invoice to yours by default
> though. That was via Reports > Business > Fancy Invoice.
>
>
I'm inputting my 2022 accounts, and have reconciled up to 10/04/2022
(DD/MM/). Now I just found a refund, dated 06/04/2022, but does not
appear in the bank account until 19/04/2022. Is it safe to create a credit
note, dated 06/04/2022, then reconcile up to 19/04/2022 at a later date? Or
should
> On 1/6/23 2:41 PM, Stan Brown wrote:
>> I don't think there's a global setting for time period in reports. It
>> would be nice if there were -- why not enter an enhancement request?
On 2023-01-06 13:13, Adrien Monteleone wrote:
> There already is such a preference. It is the very first
On Fri, Jan 06, 2023 at 12:41:22PM -0800, Stan Brown wrote:
>
> On 2023-01-06 11:35, Chris Green wrote:
> > On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:
> >> Chris,
> >>
> >> Did you run a report then click on Options / General Tab - the reports I
> >> run allow you to set the period
Just to add that I was wrong that this could be solved by making budgets
with a single period. I *think* this problem arises for any multi-currency
sub-accounts and becomes visible when you have a book which has been
running for many years. In that circumstance, the 'actual' column is only
Yes, working right to left is the way to do it, generally it works like a
charm once you get used to it, I find it just as easy sometimes to left
click on the column divider and move it left or right as necessary.
Sometimes I still have to click on the right hand border of the autosized
Hi Adrien,
Thanks for the mental bandwidth on this. I don't like replying inline, but
I'm going to grit my teeth and do it here - forgive me!
Cheers,
D
On Sat, Jan 7, 2023 at 12:47 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Christopher Lamm had been working on various
Bite Gao,
Jim mentions the import matcher, and I reiterate here to emphasize that GnuCash
provides most of what you're asking, but places it in the import process,
rather than in reconciliation. A user can match incoming entries to existing
ones. They can also set the reconcile flag to "C" for
49 matches
Mail list logo
