when withdrawing at a foreign location, most of the time you get charged a
fee. So, for example, your bank is in PHP, then when you're in Japan, you
withdraw in JPY.
Here are the facts:
1. You receive JPY10,000.00
2. ATM charges JPY110.00
3. Your local bank shows a withdrawal of PHP4282.49
4. At
unks. You don't want to have to
> manually assign those in a large quantity in a single pass.
>
> Regards,
> Adrien
>
> On 10/7/23 12:01 AM, Gio Bacareza wrote:
> > I'm experiencing difficulties when importing a CSV file into GnuCash,
> > particularly when the fil
>
> It is up to you, how big the import chunks are, but bigger is not
> necessarily faster, and maybe rarely is.
>
> Regards,
> Adrien
>
> On 10/6/23 11:57 PM, Gio Bacareza wrote:
> > I've been attempting to import a large, consolidated CSV file containing
> > multi
I'm experiencing difficulties when importing a CSV file into GnuCash,
particularly when the file contains both "Account" and "Target Account"
columns. Despite meticulously encoding the account names in the CSV to
match the exact account names as they appear in GnuCash (e.g.,
“Asset:Cash”), the
I've been attempting to import a large, consolidated CSV file containing
multiple accounts into GnuCash. Previously, I used to import transaction
logs from various accounts individually, which I thought was a cumbersome
process. To simplify this, I’ve created scripts to compile all transactions
Hi guys, this is my scenario simplified with hypothetical figures:
1. I bought property ex valued at $100 5 years ago.
2. I start with GnuCash today
3. As of today, let's say I have paid off a part of the loan, and let's say
I have $25 left to pay.
Is this how you would do it?
1. create an asset
> > work in pesos so there is no added information it gives me.
> >
> > Is there a way to configure such that no currency symbol is displayed or
> > printed?
> >
> > thanks
> >
> > On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt
> wrote:
> >
> On Feb 27, 2021, at 1:37 PM, D. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > ISTR that there is a place in the settings to choose the character to
> display with each currency. Never tried it though.
> >
> >
> > Original Mess
information it gives me.
Is there a way to configure such that no currency symbol is displayed or
printed?
thanks
On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt wrote:
> On 2021-02-26 17:21, Gio Bacareza wrote:
>
> > This seems to be a nagging problem with currencies in reports. I
This seems to be a nagging problem with currencies in reports. I thought I
had solved this in previous versions of mac that I'm using but it's back
again with Big Sur and the remedies that worked before no longer works now.
My currency is Philippine Peso. Reports show a square looking symbol
ols? thanks
On Sat, Aug 15, 2020 at 12:07 AM John Ralls wrote:
>
>
> > On Aug 13, 2020, at 10:07 PM, Gio Bacareza wrote:
> >
> > Test 1:
> > Import:
> >Withdraw Deposit
> > 02/21/2020,test first transaction,Account 1 in AUD,1486,0,,
> > ,,A
on.
>
> I think that the work around is to specify a price in multi-commodity
> imports, but I'm not as familiar with the csv importer as I should be so I
> can't say authoritatively that it will work.
>
> Regards,
> John Ralls
>
> > On Aug 13, 2020, at 4:16 AM, Gi
Thanks!
On Mon, Aug 3, 2020 at 11:29 PM GTI .H wrote:
> Em seg., 3 de ago. de 2020 às 01:07, Gio Bacareza
> escreveu:
>
>> Hi,
>>
>> I read in this list some time ago that multi-currency imports is a known
>> issue in gnucash. I just wanted to know i
Hi,
I read in this list some time ago that multi-currency imports is a known
issue in gnucash. I just wanted to know if this has been fixed.
Also, is there a best recommended format for import. I mean is CSV, QIF,
etc, whichever format, is better in handling imports in general and
multi-currency
Thanks!
On Fri, Jul 17, 2020, 12:53 AM John Ralls wrote:
>
>
> > On Jul 16, 2020, at 3:38 AM, Gio Bacareza wrote:
> >
> > Just fresh installed a new mac. installed gnucash. it can't seem to find
> > the printer (see screenshot). Help!
> >
> > [image:
Just fresh installed a new mac. installed gnucash. it can't seem to find
the printer (see screenshot). Help!
[image: image.png]
when printer is set up properly (see screenshot)
[image: image.png]
Hardware: MacAir Mid 2013
OSX Catalina 10.15.5
Gnucash Version: 4.0
--
cheers,
Gio
that
> > the latter is in bold. Try checking your font for bold symbol?
> >
> > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote:
> >
> >> it now shows up in the reports but the total is still a question mark.
> see
> >> screenshot below
> >> [image:
Thank you Fred. I was also pointing out to other fonts. That was just an
example to show that it's there.
On Fri, Jun 19, 2020, 7:04 PM Fred Bone wrote:
> On 19 June 2020 at 18:29, Gio Bacareza said:
>
> > Thank you for the help Christopher. Yes there are bold fonts capable of
&g
nes and total lines is
> that the latter is in bold. Try checking your font for bold symbol?
>
> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote:
>
>> it now shows up in the reports but the total is still a question mark. see
>> screenshot below
>> [image: image.png]
&
n 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> > The only technical difference between regular lines and total lines is
> that
> > the latter is in bold. Try checking your font for bold symbol?
> >
> > On Thu, 18 Jun 202
it. (that is
> a really bad UI/UX for this, but it is doable)
>
> Also check Tools > Security editor and make sure a symbol is displayed
> there. If not, you can reset it manually.
>
> Regards,
> Adrien
>
> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza
Why am I getting question marks instead of currency in the reports?
Gnucash Version: 3.7
Preferences / Default Currency = PHP (Philippine Peso)
Mac OSX Catalina
--
cheers,
Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your
Hi Cliff,
I also want to first say thanks to all the developers. I am a user and a
fan. 2nd, awesome to meet you Cliff. I love your products too.
I was also looking into an automated way of classifying transactions. I did
a quick automl using google and have achieved 90%+ accuracy.
However, I
> Of course, that would be complicated by anything you enter between
> reconciling and when you decide to roll it back if you don’t do it right
> away.
>
> Regards,
> Adrien
>
> > On Jun 11, 2020 w24d163, at 5:11 AM, Gio Bacareza
> wrote:
> >
> > Hi David,
> >
with the
> last used date and balance and when the reconciliation window displays the
> txns I just re-select the one/s that have become excluded from the original
> reconciliation to rebalance it for the reconciliation.
>
> Cheers David H.
>
>
> On Thu, 11 Jun 2020 at 18:1
Hi experts, if one finds himself having to redo reconciliation, what is a
better way than having the change R on a line by line basis?
--
cheers,
Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to
o to map the account name in the trnsfer
> field to an internal GnuCash account each time it encounters an account
> name for the first time in the import data.
>
> David Cousens
>
>
>
> On Tue, 2020-06-02 at 17:57 +0800, Gio Bacareza wrote:
> > Hi GNUCash experts,
>
Hi GNUCash experts,
I'm planning to consolidate all my statements into 1 big CSV. This CSV
would naturally have an account field and a transfer field.
Since all transactions are there, there will be instances where there will
be duplicates. For example, a statement from bank1 could have a
e you wanted a better way to load a
> price database rather than entering them manually.
>
> Cheers.
>
> On 11-Mar-2020, at 10:32 AM, Gio Bacareza wrote:
>
> Hi Pobox.Deva,
>
> Thank you for the suggestion. I'll try that out. However my problem, I
> think though
Hi Alton, I'm sorry I shot from the hip and answered before I realized I
misunderstood you. Your solution is exactly what I'm following now. Thanks.
On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley
wrote:
> In situations like this, I have usually just moved the 10 or so
> transactions from the
Hi Alton, I actually tried that at first but I have hundreds of
transactions and it became cumbersome fast. Thanks for the suggestion.
On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley
wrote:
> In situations like this, I have usually just moved the 10 or so
> transactions from the current
rg wrote:
> >
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza mailto:gbacar...@gmail.com>>
> > To: GnuCash Users gnucash-user@gnucash.org>>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Messa
e registers you want to deal with,
> do a search for “All Accounts” that match AccountA - delete those
> transactions, proceed to the next expense account. Rinse, repeat.
>
> Regards,
> Adrien
>
> > On Mar 9, 2020 w11d69, at 9:54 PM, Gio Bacareza
> wrote:
> >
No worries. You;ve been a great help. Thanks!
On Tue, Mar 10, 2020 at 11:19 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
>
> > On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza
> wrote:
> >
> > Hi Adrien,
> >
> > Yes I
uld
> save you lots of time.
>
> For those expense accounts that *do* involve *any* account, other than
> AccountA, then you’ll have to do them one-by-one, from a Find done from
> AccountA.
>
> Regards,
> Adrien
>
>
>
> > On Mar 9, 2020 w11d69, at 9:05 PM, Gio Bacareza
&g
>
> Do ANY of the target expense accounts involve transactions with ANY other
> account than AccountA?
>
> Put another way, do you have even a single transaction between some other
> bank account in any of those same expense accounts?
>
>
> Regards,
> Adrien
>
&g
at 10:59 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Try the search with just one expense account then. (that you can easily
> see in the register so you know it is there)
>
> Regards,
> Adrien
>
> > On Mar 8, 2020 w11d68, at 9:44 PM, Gio Ba
nd then enter
> a line All Accounts - Matches Any Account - XXX for each expense account
> that you want to include in the result.
>
> Regards,
> John Ralls
>
>
> > On Mar 8, 2020, at 8:00 PM, Gio Bacareza wrote:
> >
> > Hi John,
> >
> > I als
only return results that match in both
accounts."
Thanks
On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote:
>
>
> > On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote:
> >
> > Thanks John. I'm trying to run in from the register page.
> >
> &
this if
> needed)
>
> Regards,
> Adrien
>
>
> > On Mar 8, 2020 w11d68, at 9:20 PM, Gio Bacareza
> wrote:
> >
> > Hi Adrien, thanks for this. I really appreciate it.
> >
> > I've tried exactly what you have prescribed because that's how I tho
ust an
> illustration)
>
> Use View > Transaction Journal, if you aren’t already, to see this.
>
> Regards,
> Adrien
>
>
>
> > On Mar 8, 2020 w11d68, at 8:46 PM, Gio Bacareza
> wrote:
> >
> > Hi Adrien, thanks for the response.
> >
> > To an
card accounts), I just need to delete the
expenses.
I hope this is much clearer. If it's not responsibility to improve clarity
is mine. Do let me know.
Thanks.
On Mon, Mar 9, 2020 at 1:49 AM Stephen M. Butler wrote:
> On 3/7/20 8:03 PM, Gio Bacareza wrote:
> > Thanks Tommy. This is
ed transactions, but you would still need to edit those
> transactions one at a time.
>
> David Carlson
>
> On Sat, Mar 7, 2020 at 10:10 PM Gio Bacareza wrote:
>
>> Thanks Tommy. This is a really interesting method and I can already think
>> of use cases. For my scena
swer to a problem that might have a better
> solution.
>
> Regards,
> Adrien
>
> > On Mar 7, 2020 w10d67, at 10:03 PM, Gio Bacareza
> wrote:
> >
> > Thanks Tommy. This is a really interesting method and I can already think
> > of use cases. For my scenario though, a
Thanks John. I'm trying to run in from the register page.
On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote:
>
>
> > On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote:
> >
> > Hi I tried to search all expenses in a certain account by doing Find >
> > Account > Ma
and I am looking for the fastest way to do that. Thanks
On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell
wrote:
> On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote:
>
> > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote:
> > > Hi,
> > >
> > > I've read th
much time. So I'm looking for a
better way.
On Sat, Mar 7, 2020 at 7:41 PM Maf. King wrote:
> On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote:
> > Hi,
> >
> > I've read the manual, tried everything and searched the lists but can't
> > seem to figure out
Hi,
I've read the manual, tried everything and searched the lists but can't
seem to figure out how you can search for ALL expense transactions from a
certain account.
Any help would be appreciated.
--
cheers,
Gio
___
gnucash-user mailing list
Hi I tried to search all expenses in a certain account by doing Find >
Account > Matches Any Account - Selected Expense Account and ALL child
accounts.
Result: blank
What am I doing wrong?
--
cheers,
Gio
___
gnucash-user mailing list
t; the transaction manually and enter the resulting exchange rate in the price
> db. But I could be mistaken. Perhaps that was one of the bugs Geert was
> referring to.
>
> Regards,
> Adrien
>
> > On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza
> wrote:
> >
> &g
.
The issue I have with this is that pre-populating the price DB is
cumbersome.
There has to be a better way.
More details of test here
https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
On Fri, Mar 6, 2020 at 11:48 AM Gio Bacareza wrote:
> Thank you Adr
ugs with multi-currency csv imports. I don't think it's
> currently possible to do such imports. Sorry.
>
> Geert
>
> Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> > I'm encountering problems with importing transactions in csv when
> accounts
> > have d
.
i'll do some test with a blank price database and let everyone know.
On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
>
>
> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza
> wrote:
> >
> > I'm encountering problems w
I'm encountering problems with importing transactions in csv when accounts
have different currencies.
I've been reading the debates. So this is not about definitions of
multi-split or terminology.
I did a test with a sample csv with the following contents:
Thank you David.
On Sun, Jan 26, 2020 at 5:56 AM David Cousens
wrote:
> Gio,
>
> There is one problem that does occur with importing multiple currencies
> associated with the price that I am aware of. If the price is expressed as
> a
> rational number i.e. one integer number divided by another
So I started a new file. Then I imported csvs containing transactions which
have been pre-populated with Gnucash expense accounts. While Gnucash
expense accounts are in 1 currency, there are some accounts that have other
currencies.
After importation, I find that gnucash created a trading
Many thanks!!
On Fri, May 4, 2018 at 7:20 PM John Ralls <jra...@ceridwen.fremont.ca.us>
wrote:
>
>
> > On May 4, 2018, at 5:32 AM, Gio Bacareza <gbacar...@gmail.com> wrote:
> >
> > I'm just about to start tracking my stocks. I'm reading the manual and
> &
I'm just about to start tracking my stocks. I'm reading the manual and
tried to enter a stock which is traded in the Philippine Stock Exchange.
Under type I only see AMEX, EUREX, NASDAQ, NYSE, FUND, All non currency.
I assume I enter All Non Currency. But what does FUND mean?
--
cheers,
Gio
Thanks!
On Fri, May 4, 2018 at 4:31 PM Maf. King <m...@chilwell.net> wrote:
> On Friday, 4 May 2018 09:13:57 BST Gio Bacareza wrote:
> > Hi,
> >
> > My partner and I are moving in together and we'd like to share expenses
> > like groceries, rent, etc. So we
Hi,
My partner and I are moving in together and we'd like to share expenses
like groceries, rent, etc. So we'd like to track expenses as well as our
appropriate contributions to make sure that we both are contributing
equally to house expenses.
How should I set up the contribution? Under what
Hi,
I have used gnucash initially to track household expenses. So my flatmate
and I would contribute. We track what the transactions are for and also
keep track of contributions so we know that we both contribute equally.
Now that we are also going into a small business, I'd like some tips on
61 matches
Mail list logo