Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread John Ralls
SQLite3 is incredibly widely used so it's already on just about everything except Windows. libdbi and libdbd-sqlite are tiny, less than 100K for both. Regards, John Ralls > On Sep 21, 2020, at 11:15 AM, Adrien Monteleone > wrote: > > The disadvantage would be for those users who don't want

Re: [GNC] MT940 memo being truncated

2020-09-21 Thread Derek Atkins
Hi, Did you expand the transaction and turn on double-line mode to see if some of it is in a Split Memo or the Transaction Notes fields? -derek On Mon, September 21, 2020 5:30 pm, Gordonjackson75 wrote: > Notwithstanding the known requirement to "skip first 3 lines" of ABN Amro > MT940 files, I

[GNC] MT940 memo being truncated

2020-09-21 Thread Gordonjackson75
Notwithstanding the known requirement to "skip first 3 lines" of ABN Amro MT940 files, I think there's a problem with 4.1 import. In 4.1, importing MT940 results in tag 86 ( Info to Account Owner ) being truncated, to only show the first line of the tag. In the ABN Amro format, the contents can

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Fred Bone
On 21 September 2020 at 16:37, Daniel Fishman said: > Hello, > > Suppose that you go with your friend to a shop, and then a friend > remembers that he forgotten his credit card and asks you to pay > for his merchandise. He intends to return the money later. You pay > in the shop (for example,

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
I think the implied meaning of "Account" got me confused... Transaction Report - Accounts Tab:I selected the "Account" via the Accounts Tab to be... "Assets > Current Assets > Checking Account" Transaction Report - Filter Tab - Account Name Filter field: Is the "Account Name Filter" field

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Adrien Monteleone
Daniel, I use: Assets:Current Assets:Reimbursements I then have category accounts under that for, Family Friends Other And then individual accounts with each person's name. (I have one for each sibling, parent, and several close friends where this happens regularly enough to need them) But

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread Adrien Monteleone
The disadvantage would be for those users who don't want or need it and like to manage lean and clean systems. Without getting into any specific issues, the less code and packages to worry about, the less 'general' chance for bugs, breakage, and vulnerabilities. And while for I'm sure many

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread Adrien Monteleone
I'm pretty sure that *is* documented on the Wiki build pages, or at least used to be. I once built on Ubuntu and found that option on the Wiki to get it working. I was lightly following some Wiki Build Instruction discussion on IRC recently and I think that very option (with needed

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Michael or Penny Novack
On 9/21/2020 9:37 AM, Daniel Fishman wrote: Hello, Suppose that you go with your friend to a shop, and then a friend remembers that he forgotten his credit card and asks you to pay for his merchandise. He intends to return the money later. You pay in the shop (for example, buy a book) using

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread John Ralls
> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user > wrote: > > How can I create a Transaction Report for the Check Register... > set to only display transactions where a keyword appears in the Description > field? > I'm confused by the "Account Name" Filter and the "Transaction Filter"

Re: [GNC] Standard chart of accounts?

2020-09-21 Thread John Ralls
> On Sep 21, 2020, at 8:42 AM, Jimmy R via gnucash-user > wrote: > > I believe there is a wizard to select personal or business chart of accounts > which you can edit or add/remove > Yup. File>New starts it. If you want to use templates to add to an existing book go to the Accounts page

[GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
How can I create a Transaction Report for the Check Register... set to only display transactions where a keyword appears in the Description field? I'm confused by the "Account Name" Filter and the "Transaction Filter" fields... Thanks for any help.

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Stan Brown
On 2020-09-21 06:37, Daniel Fishman wrote: > Suppose that you go with your friend to a shop, and then a friend > remembers that he forgotten his credit card and asks you to pay > for his merchandise. > > Since the payment to the shop was made by the credit card, an account > 'Expenses:' is

Re: [GNC] Standard chart of accounts?

2020-09-21 Thread Jimmy R via gnucash-user
I believe there is a wizard to select personal or business chart of accounts which you can edit or add/remove -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread w...@theprescotts.com
IANAA (I am not an accountant), but I handle that situation in my personal books with an expense account named "Reimbursable expenses". When the money is spent I credit it to Reimbursables, and when the money is repaid, I debit it to Reimbursables. Will On 2020 Sep 21, at 09-21 09:35:39,

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Christopher Lam
Well you'd use the description field to describe the narrative of the transaction. "Bought $50 of books from Shop for friend". Later on when friend settles debt into your bank you'd write "recover $50 from friend". This approach would mean the widget shop shouldn't appear in your expense report.

[GNC] Standard chart of accounts?

2020-09-21 Thread Ken Brown via gnucash-user
Is there a good standard chart of accounts as a starter for a small proprietorship home business including personal as well? Where can I find and how do I use to get started? Thx for any tips. Ken G. Brown ___ gnucash-user mailing list

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Daniel Fishman
On 9/21/20 5:15 PM, Christopher Lam wrote: I wouldn't add an entry into Expenses:shop -- you didn't exactly spend your money into this shop. Spending/lending money: Liability:credit card -$50 Asset:Friend owes me +$50 Recovering funds: Asset:Friend owes me -$50 Asset:Cash or bank +$50 It

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Christopher Lam
I wouldn't add an entry into Expenses:shop -- you didn't exactly spend your money into this shop. Spending/lending money: Liability:credit card -$50 Asset:Friend owes me +$50 Recovering funds: Asset:Friend owes me -$50 Asset:Cash or bank +$50 HTH On Mon, 21 Sep 2020, 9:40 pm Daniel Fishman,

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread Derek Atkins
On Mon, September 21, 2020 9:59 am, Chris Green wrote: > On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: >> No need.  >> https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html >> > OK, it's there, but I didn't find it very easily (could be me of > course). > > Is there any major

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread Chris Green
On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: > No need.  https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html > OK, it's there, but I didn't find it very easily (could be me of course). Is there any major disadvantage to making it a dependency on Linux as well as on Windows

[GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Daniel Fishman
Hello, Suppose that you go with your friend to a shop, and then a friend remembers that he forgotten his credit card and asks you to pay for his merchandise. He intends to return the money later. You pay in the shop (for example, buy a book) using your credit card. Then a few days later the

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-21 Thread Michael or Penny Novack
On 9/20/2020 10:47 PM, doncram wrote: Just to say GnuCash could serve churches and other nonprofits much better if Job Costing were supported.  And relatedly, more churches and other nonprofits could use GnuCash if Job Costing were supported.  Thank you Jacob Oomen for sharing the links to

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-21 Thread doncram
Just to say GnuCash could serve churches and other nonprofits much better if Job Costing were supported. And relatedly, more churches and other nonprofits could use GnuCash if Job Costing were supported. Thank you Jacob Oomen for sharing the links to your extensive past work to help accountants

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread D. via gnucash-user
No need.  https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html Original Message From: Chris Green Sent: Mon Sep 21 03:47:20 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? On Sun, Sep 20, 2020 at

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread Chris Green
On Sun, Sep 20, 2020 at 11:19:42PM -0500, Adrien Monteleone wrote: > See my other reply about versions and database support. I've been using > SQlite3 since the 2.6.x days. > > The build instructions on the wiki are very good. The most time will be > spent reading and making sure you have the

Re: [GNC] How to stop a Transfer Funds dialogue autmatically appearing after reconciliation?

2020-09-21 Thread Christopher Lam
Try the preference setting Register / Reconciling / Automatic credit card payment On Mon, 21 Sep 2020, 3:12 pm Jim DeLaHunt, wrote: > Hello, folks: > > I have been catching up on reconciliation of a few credit card accounts > this weekend. For one credit card account, when I click the "Finish"

[GNC] How to stop a Transfer Funds dialogue autmatically appearing after reconciliation?

2020-09-21 Thread Jim DeLaHunt
Hello, folks: I have been catching up on reconciliation of a few credit card accounts this weekend. For one credit card account, when I click the "Finish" button to complete the reconciliation, a Transfer Funds dialogue appears automatically. It has the ending balance of the credit card