Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

You can put this in a combine.py file. Install python3 (preferably), change the names of the files at the bottom and give it a shot (python combine.py) Python is a blast as far as languages are concerned, so give it a shot, you probably won't regret it! Good luck, Jean # This combines a

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Long, As long as i have been doing accounting, profit or gain has *never* been the difference between Assets and Equity. Assets = Liabilities + Equity or in the extended form with the temporary accounts broken out separately from Equity: Assets =Liabilities + Equity + Income - Expenses.

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

Jean, I would love to see how you did it with Python. That's actually on the shortlist of languages I want to learn. I realized that at least in so far as the Citi produced OFX file is concerned, I will always need to delete a fixed number of lines. If I download only one account at a time, I

Re: [GNC] Should i create "Equity Account" for each currency I had ?

David Cousens, Do you know that : if you created each accounts (equity) for each currencies you are holding. And when the rate changed, you will never know Gain or Loss after exchange rate changed, You can create a new file to test it! I had talking about this in previous comment. Example :

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Long, Adrien's description applies to the situation where you are starting off with all your money in the one currency, the home currency of your set of accounts /book and then you subsequently have trading transactions. If this is your situation, then you will not need foreign currency accounts

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

Sorry, I wasn,t clear that I was intentionally comparing apples with oranges because they both grow on trees On Wed, Apr 15, 2020 at 5:49 PM Jean Laroche wrote: > I think we're talking about OFX here, which is a lot more robust that > QIF as far as importing. In any event, when you combine

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Hi David Cousens, I can't understand what you mean and what you are talking about. I think because you are guiding me more information about Equity accounts. Generally, i will do the same way like Adrien Monteleone-2 does. only "My home currency" for Equity. Thanks for your helped. -- Sent

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

I think we're talking about OFX here, which is a lot more robust that QIF as far as importing. In any event, when you combine the OFX files, the OFX import is done sequentially (apparently) in GC as if you opened them one after the other, but I may be wrong. The transactions do all appear

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche wrote: > I hacked some python code to do that if you're interested. I'm taking > ofx files, reading them and combining them just the way you describe it. > It's not beautiful code but it works. > What would be awesome would be if you could select

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

I hacked some python code to do that if you're interested. I'm taking ofx files, reading them and combining them just the way you describe it. It's not beautiful code but it works. What would be awesome would be if you could select multiple files in GC, and then do the import! On 4/15/20 2:58

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Long, Tthese accounts in Equity are Opening Balances. They are intended to treat the situation where you start using Gnucash and you already have existing assets or accounts with existing balances in other currencies when you create the set of books. They serve no other purpose. Any trading gains

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

I did some experimenting today and I think I am seeing something similar. If I take the tag that ends the first account’s transaction data and then select all text up to and including the tag that starts the next account’s transaction it will work perfectly. There is a bunch of stuff in

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Long, It’s one thing to start a new topic for a truly new question. It is also a good idea to change the subject line of a thread if it really does branch off to something else. But simply starting a new thread with the same question, though re-worded makes following the discussion difficult

Re: [GNC] Should i create "Equity Account" for each currency I had ?

Update : Add some pictures for more details, click to the link to view. 1 - GnuCash documents - chapter 12 2 - Currency Transfer

[GNC] Should i create "Equity Account" for each currency I had ?

This is a new topic moved from older topic : Because my question is not clearly. - In GnuCash documents - chapter 12 : They created Equity accounts for each currency in their guide.(More details) I think, it not good if we follow that, because when the exchange rate changed, Your

Re: [GNC] Manuals for GnuCash

On Wed, 15 Apr 2020, Derek Atkins wrote: But for version 2.4 docs when 3.10 is now current? The book has not been updated, but MOST of the content is still relevant. Certainly all the background and process planning is still relevant, even if the UI has moved on. Maybe we should reach out

Re: [GNC] Delayed Direct Payment of Sales Tax from Vendor Bill?

It would probably be easier to treat this as a separate ‘use tax’ type transaction where you recognize the liability independent of the invoice. (some jurisdictions impose a tax on items used in business that otherwise wasn’t charged sales tax for some reason) So a separate transaction like:

Re: [GNC] Manuals for GnuCash

On Wed, April 15, 2020 2:12 pm, Rich Shepard wrote: > On Wed, 15 Apr 2020, Derek Atkins wrote: > >> It's working for me... https://www.gnucash.org/ > > Derek, > > It's now working for me, too. Perhaps it was restricted from being viewed > at > the time I visited. > >> Just a note that the

Re: [GNC] Manuals for GnuCash

On Wed, 15 Apr 2020, Derek Atkins wrote: It's working for me... https://www.gnucash.org/ Derek, It's now working for me, too. Perhaps it was restricted from being viewed at the time I visited. Just a note that the GnuCash team DOES receive a small royalty fee from PACKT publishing for

[GNC] Delayed Direct Payment of Sales Tax from Vendor Bill?

Okay, folks, I'm lost. I normally use cash accounting, not accrual. But I recently purchased a software package from a vendor who offered "Net 30" terms and wanted a purchase order. I hadn't really used the billing function before and since I'm paying before the end of the month I set up the

Re: [GNC] Manuals for GnuCash

Hi, On Wed, April 15, 2020 1:34 pm, Rich Shepard wrote: > On Wed, 15 Apr 2020, Edward Bainton wrote: > [snip] > The gnucash web site seems to be down now as I get to look at only > a blank page. It's working for me... https://www.gnucash.org/ > Don't give Amazon your money for that book.

Re: [GNC] Manuals for GnuCash

On Wed, 15 Apr 2020, Edward Bainton wrote: I'm planning to start using Gnucash in my small business. Edward, Good for you! There appears to be one published beginners manual

[GNC] Manuals for GnuCash

Hello I'm planning to start using Gnucash in my small business. There appears to be one published beginners manual , by Ashok Ramachandran. It relates to GnuCash 2.4,

Re: [GNC] Would like to use, but ....

Op woensdag 15 april 2020 18:12:29 CEST schreef John Ralls: > That solves the problem of the link on our page but there's still a > SourceForge problem: When you visit any of the GnuCash pages on SF there's > a big green download button. What download it points to is determined by > the user agent

Re: [GNC] Would like to use, but ....

> On Apr 15, 2020, at 7:27 AM, Geert Janssens > wrote: > > Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone: >> On 15 April 2020 at 9:02, Derek Atkins said: >>> Hi Andrew, >>> >>> First, please remember to CC gnucash-user on your replies so that others >>> may benefit from the

Re: [GNC] Would like to use, but ....

Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone: > On 15 April 2020 at 9:02, Derek Atkins said: > > Hi Andrew, > > > > First, please remember to CC gnucash-user on your replies so that others > > may benefit from the conversation and chime in. You can do this by using > > the

Re: [GNC] Would like to use, but ....

At Wed, 15 Apr 2020 14:31:35 +0100 fred.b...@dial.pipex.com wrote: > > On 15 April 2020 at 9:02, Derek Atkins said: > > > Hi Andrew, > > > > First, please remember to CC gnucash-user on your replies so that others > > may benefit from the conversation and chime in. You can do this by using >

Re: [GNC] Would like to use, but ....

On 15 April 2020 at 9:02, Derek Atkins said: > Hi Andrew, > > First, please remember to CC gnucash-user on your replies so that others > may benefit from the conversation and chime in. You can do this by using > the Reply-To-List or Reply-All functionality in your mailer. > > If you could

Re: [GNC] Would like to use, but ....

Andrew, PLEASE CC gnucash-user on your replies! -derek On Wed, April 15, 2020 9:24 am, Andrew Ruddle wrote: > > https://www.gnucash.org/download.phtml - towards the bottom has the last > XP version. > > Although page https://www.gnucash.org/offers a link CALLED with > reference to the

Re: [GNC] Would like to use, but ....

Hi Andrew, First, please remember to CC gnucash-user on your replies so that others may benefit from the conversation and chime in. You can do this by using the Reply-To-List or Reply-All functionality in your mailer. If you could supply us with the URL of the page that points to WinXP, there

Re: [GNC] Would like to use, but ....

Hi, On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote: > > Greetings > > I have been very highly recommended to GnuCash, but I am having difficulty > getting started. > > I have downloaded and installed [the XP Vista version on Sourceforge], but > when I try to open it all I get is a rather

Re: [GNC] Would like to use, but ....

please use "reply all" or "reply to list" for your answers. Am 15.04.20 um 11:27 schrieb Andrew Ruddle: > > Thank you > > a) For my own reasons, it is desirable to run it on a machine that is not > the main one I use. NP > b) I accept that it is unsupported; however if they offer the XP

Re: [GNC] Would like to use, but ....

Greetings Andrew, Am 14.04.20 um 14:00 schrieb Andrew Ruddle: > > Greetings > > I have been very highly recommended to GnuCash, but I am having difficulty > getting started. > > I have downloaded and installed [the XP Vista version on Sourceforge], but are you still running a computer with

[GNC] Would like to use, but ....

Greetings I have been very highly recommended to GnuCash, but I am having difficulty getting started. I have downloaded and installed [the XP Vista version on Sourceforge], but when I try to open it all I get is a rather unhelpful message as follows : The procedure entry point GetTickCount64