Hi there
I have used GNU Cash for a number of years to monitor my personal finances. I
have just run the Tools > Close book function to clear down all my expense &
income account balances as at 31/12/17 however I seem to have transactions in
all of these accounts going back, in some cases, to
I was about to ask the same question! Thanks.
On Mon, Jan 15, 2018 at 9:03 AM, Jack Whyte wrote:
> Hi there
>
> I have used GNU Cash for a number of years to monitor my personal
> finances. I have just run the Tools > Close book function to clear down
> all my expense & income account balances
No, there isn’t. The Close book feature simply creates a transaction that
zeroes out your income and expense accounts as of a given date.
In a double entry accounting system, if you delete the expense side of the
transaction, what do you suggest doing for the Checking account side? If you
are d
David -- Excellent point. To expand upon it let's demonstrate this:
At 12/31/2017 -- you have balances in all your accounts -- for brevity, will
just use one real simple example:
At 12/31/2017 - let's assume the checking account has a balance of $500. If
you eliminate all 2017 transaction
Thanks David
Yes but as it’s a double entry system, the net effect of deleting a year’s
worth of transactions in an account where close book has been applied
should be nil so the Checking account should not be effected?
Am I missing something?
It could be a bit laborious deleting all these trans
Thanks Ken
I wrote a reply before reading yours!
The file is very large and unwieldy already - are there any limits on the
file size? One of the impacts is also that each time I update the file at
least one copy is made - the folder on my MAC for December grew to >130MB.
JACK
On 15 January 201
Hi,
Macho Philipovich writes:
> Dear fellow Gnucash users,
>
> I have two questions about invoices.
>
> First, I deal with some of my clients in French, some in English. I'd
> like to be able to provide invoices in either language. Gnucash reports
> generally allow me to edit all of the headings
Hi,
Jack Slater writes:
> Is it possible to create/save default NUM items such as:
>
> EFT (electronic funds transfer)
> DEP (deposit)
> TRN (transfer)
> ATM (auto teller machine)
> And a simple free form text entry (this would allow for sequenced check
> number entries)
The Num column is a tex
Hi David,
Yes, that is exactly what I am referring to and yes, that is what I have
noticed as well :).
Adrien - I took a look, but still no commas in my graphs :(. Maybe this
could be a feature request, but for now I can keep surviving without it :)
- it would just be a nice to have.
Thank You,
I was hoping AutoFill was an option as well but it’s not seeming to remember
what I’ve typed.
> On Jan 15, 2018, at 10:53 AM, Derek Atkins wrote:
>
> Hi,
>
> Jack Slater writes:
>
>> Is it possible to create/save default NUM items such as:
>>
>> EFT (electronic funds transfer)
>> DEP (depo
Auto fill is not enabled for the NUM column. Maybe a feature request would get
it added in a future release.
Ken Schneider
> On Jan 15, 2018, at 12:04 PM, Jack Slater wrote:
>
> I was hoping AutoFill was an option as well but it’s not seeming to remember
> what I’ve typed.
>
>> On Jan 15,
Is there a place/method I should use to request?
> On Jan 15, 2018, at 11:12 AM, Kenneth Schneider
> wrote:
>
> Auto fill is not enabled for the NUM column. Maybe a feature request would
> get it added in a future release.
>
> Ken Schneider
>
>> On Jan 15, 2018, at 12:04 PM, Jack Slater wr
Jack - - Not sure on the size constraints – someone else can maybe answer.
With respect to getting it down to a manageable size – I can only speak from my
experience. When I transferred over from Quicken, I had transactions dating
back to 2003. Bringing them all over was messy. But I did
Thank you for the responses to date. I will work on the bank accounts
first, then go back to the manual for direction before turning to investment
accounts.
Here is an example of what I am encountering: One of the accounts that
popped up after the conversion from Quicken is a credit card that I
Hello
I hope this is the right forum/email address to ask questions. This is the
first time I am posting a question on GnuCash.
My question is: where does GnuCash store exchange rates for balance sheet
items, where the balance sheet items have two (or more) currencies? I will
illustrate my probl
I suspect that it is not easy to have both auto increment and auto fill at
the same time. You can still ask.
David C
On Jan 15, 2018 11:18 AM, "Jack Slater" wrote:
> Is there a place/method I should use to request?
>
> > On Jan 15, 2018, at 11:12 AM, Kenneth Schneider <
> kschnei...@bout-tyme.
On Monday, 15 January 2018 15:03:33 GMT Jack Whyte wrote:
> I am concerned the file, currently at around 1.3MB, will
> become unwieldy and unmanageable.
>
> Thanks & regards
> Jack
Hi Jack,
My business data file is around the 25 MB mark at the moment, my personal file
is more like 5.6MB, so yo
On 1/15/2018 10:26 AM, Jack Whyte wrote:
> Thanks Ken
>
> I wrote a reply before reading yours!
>
> The file is very large and unwieldy already - are there any limits on the
> file size? One of the impacts is also that each time I update the file at
> least one copy is made - the folder on my MAC
I’ve become very confused and am hoping someone can provide some basic help.
I’m attempting to transition from Quicken to GnuCash. I will be starting
from a set of accounts that I already have in Quicken, but I have no
intention of importing data from Quicken. I’ll be obtaining balance
informati
Let's discuss this (and possible options)
First, you need to understand what "close the books" does do and what is
does not do. It creates a transaction (or transactions) to zero out
income and expense accounts to equity. It does NOT remove transactions
and so will not make your file smaller.
This is what I do, but I'm only dealing with household and personal
accounts and smallish investment portfolios. Because the statement
closing dates for the investment and personal bank and credit accounts
don't correspond exactly with the beginning date of the new book,
there's always some mon
Hi,
I need to upgrade the VM system so I'd like to take it down at 2100
US/EST (0200 UTC) tonight. I expect only ~1 hour (or less) of downtime.
I'll make a quick announcement on IRC before I start.
Please let me know if this is a problem.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MI
Well, this is embarrassing. Turns out there was an Interest Charge dialog
box on a display that I had turned off. So upgrading to 2.6.18 fixed the
crash, and there was no freeze. Thanks for your help!
On Sat, 13 Jan 2018 at 21:51 David Carlson
wrote:
> The Windows versions can get very slw.
The first question I’d ask is where does that money collected from the Etsy
sale go?
Does it get auto-deposited into a bank account, or do you have to transfer it
manually? (like Paypal)
Let’s assume it’s auto-deposited. (more like a regular merchant account with a
credit card company)
To keep
David,
I did create subfolder but the same error pops up. I definetly have
full access to the folder and subfolder. Is there any special first
time steps that I could be missing?
Sent: Sunday, January 14, 2018 at 3:51 PM
From: "David Carlson"
To: "Snarky Email"
Cc: "
Can you save other documents such as spreadsheets to that folder? Is there
plenty of free space on your C: drive (like several GIG's)? is this machine
owned by someone else such as your employer?
David C
On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email wrote:
> David,
>
> I did create subfolder b
I haven't been able to find much on getting past AqBanking not verifying
certificates for OFX connections.
https://wiki.gnucash.org/wiki/De/Setting_up_OFXDirectConnect_in_GnuCash_2
says to "blindly" accept them, which seems risky in this day and age. I
found a question around it asked on the l
If you don't have it open elsewhere you can click "Open anyway"
Depending on how it shutdown the lock file may be there.
On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
gnucash-user@gnucash.org> wrote:
I'm not making much progress... I see I got some replies to my manual entry
iss
Try run in gnucash as administrator by right clicking on the icon and
selecting "Run as administrator"
What does that do?
On Jan 15, 2018 9:13 PM, "David Carlson"
wrote:
> Can you save other documents such as spreadsheets to that folder? Is there
> plenty of free space on your C: drive (like s
I was looking at some of my loans and wanted to get an idea of how much
I paid in interest to each loan over their life. I've got one account
that collects the amount of loan interest every time I pay (as part of a
split transaction) while the principal portion of the payment goes to
the specific
Try the Transaction Report which has an Account Filter in the first tab.
On 16 Jan 2018 11:54 AM, "AC" wrote:
> I was looking at some of my loans and wanted to get an idea of how much
> I paid in interest to each loan over their life. I've got one account
> that collects the amount of loan inte
I’d like to thank you for your time and response. You’ve cleared up a few
things I was confused about, and made me feel better about how I was setting
things up.
Aside from how you’ve categorized some of the accounts, it looks like my 1st
example was right on the money (no pun intended), or at le
No, that didn't work. It still pulls the interest payments from
multiple loans and won't let me filter out the specific interest
payments for one of the loans.
On 2018-01-15 20:13, Christopher Lam wrote:
> Try the Transaction Report which has an Account Filter in the first tab.
>
> On 16 Jan 201
I’d choose “Open Anyway” as well, but you could also delete that LCK file.
That’s the one causing the problem. (Note, it is supposed to be there if you
have the file already open, but since you know for a fact you don’t, you can
delete it. Normally, this file is deleted when you close the applic
Trevor,
Have you tried making a copy of the file on your local drive and working on
it there. I have never worked with dropbox so I have no idea if it could
confused by the way GnuCash makes backups, for example.
David C
On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith wrote:
> If you don't have
I use Dropbox however I maintain my gnucash data file on my local drive
rather than directly in Dropbox. I think from memory the lock file hangs
around in Dropbox so when you try to re-open your data file the LCK file is
still the and triggers the warning dialog. As others have said you can
just
> On Jan 15, 2018, at 10:26 PM, sszd wrote:
>
> I’d like to thank you for your time and response. You’ve cleared up a few
> things I was confused about, and made me feel better about how I was setting
> things up.
>
> Aside from how you’ve categorized some of the accounts, it looks like my 1st
Thanks Derek,
On 2018-01-15 11:51 AM, Derek Atkins wrote:
> Unfortunately the report translation is based on your system locale.
Ah, of course! I can just run Gnucash from terminal after changing the
locale environment variable whenever I want to print French invoices.
Excellent!
>
>> Is there
Have you tagged each interest payment split with the loan name? You could use
that as the filter, though I would think the memo field would suffice.
Regards,
Adrien
> On Jan 15, 2018, at 10:29 PM, AC wrote:
>
> No, that didn't work. It still pulls the interest payments from
> multiple loans a
The description for each split does have the specific loan to which it
applies. I used the search to filter on all of those but the
transaction report still pulls everything in.
On 2018-01-15 21:14, Adrien Monteleone wrote:
> Have you tagged each interest payment split with the loan name? You cou
Did you install GnuCash using the same user account as you are using
now? Or with an Administrator account?
If you installed GnuCash while logged in as an administrator or
different user GnuCash may not have the correct permissions to access
the directory in which the data file is located eve
Ah the transaction report as it stands currently cannot do description text
filtering. The next release will be. For now the easiest workaround is to
export to spreadsheet and filter from there.
On 16 Jan 2018 13:33, "AC" wrote:
The description for each split does have the specific loan to which
In France, even for small clubs like ours, we face a regulatory
requirement that the books be immutable after end of year. This makes
sense in that if the tax authorities (even though we don't have to file
taxes) ask us a question and then find out that our books for some past
year have changed, t
I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We
also use GoDaddy for our WordPress web page, so I already have the hosting
account. GnCash keeps giving me an error "The server at URL
mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
error or
Hi Jeff,
I do not think that aqbanking checks against the system certificates. But you
should have to accept a certificate only once. BUT when called directly from
Gnucash aqbanking this does not work. It only remembers the certificate when
called from the the command line e.g. with
"/Applicat
On Tue, 16 Jan 2018 07:08:23 +0100
Jeff Abrahamson wrote:
> In France, even for small clubs like ours, we face a regulatory
> requirement that the books be immutable after end of year. This makes
> sense in that if the tax authorities (even though we don't have to
> file taxes) ask us a question
Or just add the new transaction report to GnuCash. It’s an attachment here on
the list from a few months ago. Sorry I don’t have the link to the thread
directly. But I’m sure a Google search will turn it up.
Regards,
Adrien
> On Jan 15, 2018, at 11:57 PM, Christopher Lam
> wrote:
>
> Ah the
On Tue, 16 Jan 2018 15:03:04 +1000
Dave H wrote:
> I use Dropbox however I maintain my gnucash data file on my local
> drive rather than directly in Dropbox. I think from memory the lock
> file hangs around in Dropbox so when you try to re-open your data
> file the LCK file is still the and trig
AC,
I went a different way. I created Subaccounts for each grouping I wanted to
track. So, if I want to track interest on a particular loan (for example, if I
expected a 1099 for it), I created a subaccount under Expenses:Interest. That
made it simple to track individual loans. I also can assig
On 16 January 2018 at 06:34, Jim_S wrote:
> I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We
> also use GoDaddy for our WordPress web page, so I already have the hosting
> account. GnCash keeps giving me an error "The server at URL
> mysql://gnuc...@gnucash.db.3879949.
50 matches
Mail list logo
