Re: [GNC] Where to charge? Ins pays us, we pay vendor. Resolved

[Fran_3 via gnucash-user]

 In this case the "Doctor" was actually a nationally known diagnostic & 
treatment clinicAnd the "Insurance Company" was Medicare.At that time the 
clinic accepted those insured by Medicare but it was not  "Medicare 
Assigned"What all that meant  effectively was the clinic sent the bill Medicare 
and later to the patient.Medicare sent the payment to the patient before the 
patient got the bill from the clinic.Then later, when the patient got the 
clinic bill they paid it with the money Medicare had sent them to pay the bill.
Regardless of whether this was normal or not, is is the way it happened.
In the "T" account example I provided it was charged initially to the medical 
expanse accountBut when the bill was paid that was offset so the net effect on 
the medical expense account was zero.
But your suggestion seems like a good one to a non-account type..Is this what 
you suggested?
Enter payment from insurance company:    Assign to Checking & ReimbursableEnter 
bill from the Clinic:    Assign to AP & ReimbursableEnter payment to the 
Clinic:    Assign to AP & Checking
Question: Wouldn't a pre-payment be a liability as opposed to an Asset?Not that 
it would matter so long as it was reconciled... right?
Just asking.
Thanks for the help.






On Thursday, February 13, 2020, 12:20:51 PM EST, Stephen M. Butler 
 wrote:  
 
 On 2/13/20 8:34 AM, Fran_3 via gnucash-user wrote:
>  This question was in regards to an individual recording a trip to the doctor 
>in their personal GC system.What was somewhat unusual here was the medial 
>insurance paid the patient instead of directly paying the doctor
> Here is the original scenario:1 - Doctor billed patient2 - Insurance paid 
> patient3 - Patient paid doctor
> The attached picture shows how is was recorded in GC.Problem solved... right?
> (And yes, this probably should have been posted to some account forum for US 
> accounting procedures. Can anyone suggest one?)

Wouldn't this be just like any other reimbursable expense?  Normally the
insurance is billed by the doctor and pays the doctor.  In some cases
the doctor may not have a relationship with the insurance company (out
of network) and may feel they need to bill the patient.  However, the
patient may have an agreement (approved referral) to have those expenses
reimbursed.

Therefore, this wouldn't be an expense to that patient.  Like any
expense you pay in relationship to your job for which you know you will
get reimbursed, you don't book it as an expense but rather put that
"split" against an asset account for reimbursement.  When paid, it
offsets that reimbursement account with the other "split" going back to
checking (for both transactions).

In cases when I don't know in advance that it will be reimbursed, I then
enter the original transaction as an expense.  When it is reimbursed
then I offset that expense account by the amount of the reimbursement. 
The net effect is that the expense account doesn't really have that
expense when all the transactions are done.


Normally when the doctor bills the insurance and is paid by them, that
portion paid by the insurance is never entered into a personal set of
books.  It is a transaction between the doctor and the insurance
company.  There may be co-pays involved in which the patient pays a
portion (10% or 20% or ...).  That portion would be booked as a medical
expense in the personal set of accounting books.

>
>    On Tuesday, February 11, 2020, 10:52:52 PM EST, Christopher Lam 
> wrote:  
>  
>  Search archives for "trust accounts"
> On Wed, 12 Feb 2020, 7:34 am Fran_3 via gnucash-user, 
>  wrote:
>
>  In the case at hand...The initial expanse was medical billed and billed to 
> the patient.The insurance company sent the money for the medical bill to the 
> patient.The patient aid the medical provider.
> So we have 3 transactions to record...1- The Medical Bill charged to AP & Med 
> Exp2 - The Ins reimbursement charged to ?? & ??3 - The Bill Pmt charged to AP 
> & Checking
> or what?
> Thanks for any help.
>
>     On Tuesday, February 11, 2020, 05:38:10 PM EST, Michael or Penny Novack 
>  wrote:  
>
>  On 2/11/2020 11:47 AM, Fran_3 via gnucash-user wrote:
>> When an insurance claim occurs the insurance pays us and we pay the vendor.
>> How to we charge the deposit from the insurance company and the payment to 
>> the vendor?
>> I considered setting up an Expense Account named Insurance Transactions or 
>> Insured Events or whatever...
>> Then allocating the insurance payment to that "Expense" account
>> and then allocating the vendor payment to the same "Expense" account
>> Or would you suggest just using the Insurance Payments Account where you 
>> record payments for the policy?
>> How wo

Re: [GNC] Where to charge? Ins pays us, we pay vendor. Resolved

[Fran_3 via gnucash-user]

 This question was in regards to an individual recording a trip to the doctor 
in their personal GC system.What was somewhat unusual here was the medial 
insurance paid the patient instead of directly paying the doctor
Here is the original scenario:1 - Doctor billed patient2 - Insurance paid 
patient3 - Patient paid doctor
The attached picture shows how is was recorded in GC.Problem solved... right?
(And yes, this probably should have been posted to some account forum for US 
accounting procedures. Can anyone suggest one?)



On Tuesday, February 11, 2020, 10:52:52 PM EST, Christopher Lam 
 wrote:  
 
 Search archives for "trust accounts"
On Wed, 12 Feb 2020, 7:34 am Fran_3 via gnucash-user, 
 wrote:

 In the case at hand...The initial expanse was medical billed and billed to the 
patient.The insurance company sent the money for the medical bill to the 
patient.The patient aid the medical provider.
So we have 3 transactions to record...1- The Medical Bill charged to AP & Med 
Exp2 - The Ins reimbursement charged to ?? & ??3 - The Bill Pmt charged to AP & 
Checking
or what?
Thanks for any help.

    On Tuesday, February 11, 2020, 05:38:10 PM EST, Michael or Penny Novack 
 wrote:  

 On 2/11/2020 11:47 AM, Fran_3 via gnucash-user wrote:
> When an insurance claim occurs the insurance pays us and we pay the vendor.
> How to we charge the deposit from the insurance company and the payment to 
> the vendor?
> I considered setting up an Expense Account named Insurance Transactions or 
> Insured Events or whatever...
> Then allocating the insurance payment to that "Expense" account
> and then allocating the vendor payment to the same "Expense" account
> Or would you suggest just using the Insurance Payments Account where you 
> record payments for the policy?
> How would you guys handle such an instance?
> Thanks for any help.

This is an accounting question, not a gnucash question, and to really 
know how to answer your question would need to know what conditions (or 
lack of conditions) were attached to the payment from the insurance company.

I'll perhaps need to give an example? In 2006 we had a house fire, and 
our insurance had "replacement" coverage. So each covered thing (or 
category) had TWO amounts associated with it. One amount was for the 
current depreciated value assigned, the other (far higher) was if we 
were choosing to replace. For what we opted to replace, they would give 
us the higher amount but we had to later submit proof/receipts that we 
had made the replacement purchase. For what we accepted the depreciated 
value, no conditions attached to the money.

And let me back off a bit. How did you do the accounting for the loss 
for which this insurance payment is made?

Michael D Novack



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

  ___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where to charge? Ins pays us, we pay vendor.

[Fran_3 via gnucash-user]

 In the case at hand...The initial expanse was medical billed and billed to the 
patient.The insurance company sent the money for the medical bill to the 
patient.The patient aid the medical provider.
So we have 3 transactions to record...1- The Medical Bill charged to AP & Med 
Exp2 - The Ins reimbursement charged to ?? & ??3 - The Bill Pmt charged to AP & 
Checking
or what?
Thanks for any help.

On Tuesday, February 11, 2020, 05:38:10 PM EST, Michael or Penny Novack 
 wrote:  
 
 On 2/11/2020 11:47 AM, Fran_3 via gnucash-user wrote:
> When an insurance claim occurs the insurance pays us and we pay the vendor.
> How to we charge the deposit from the insurance company and the payment to 
> the vendor?
> I considered setting up an Expense Account named Insurance Transactions or 
> Insured Events or whatever...
> Then allocating the insurance payment to that "Expense" account
> and then allocating the vendor payment to the same "Expense" account
> Or would you suggest just using the Insurance Payments Account where you 
> record payments for the policy?
> How would you guys handle such an instance?
> Thanks for any help.

This is an accounting question, not a gnucash question, and to really 
know how to answer your question would need to know what conditions (or 
lack of conditions) were attached to the payment from the insurance company.

I'll perhaps need to give an example? In 2006 we had a house fire, and 
our insurance had "replacement" coverage. So each covered thing (or 
category) had TWO amounts associated with it. One amount was for the 
current depreciated value assigned, the other (far higher) was if we 
were choosing to replace. For what we opted to replace, they would give 
us the higher amount but we had to later submit proof/receipts that we 
had made the replacement purchase. For what we accepted the depreciated 
value, no conditions attached to the money.

And let me back off a bit. How did you do the accounting for the loss 
for which this insurance payment is made?

Michael D Novack



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Where to charge? Ins pays us, we pay vendor.

[Fran_3 via gnucash-user]

When an insurance claim occurs the insurance pays us and we pay the vendor.
How to we charge the deposit from the insurance company and the payment to the 
vendor?
I considered setting up an Expense Account named Insurance Transactions or 
Insured Events or whatever...
Then allocating the insurance payment to that "Expense" account
and then allocating the vendor payment to the same "Expense" account
Or would you suggest just using the Insurance Payments Account where you record 
payments for the policy?
How would you guys handle such an instance?
Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

[Fran_3 via gnucash-user]

 OK, I've brought up the Vendor Report (beta) by clicking
Reports > Experimental  > Vendor Report (beta)
Then  click Edit Options in the popup windowThen in the next window on the 
General Tab select the date range, enter the vendor nameThen click the Display 
Columns TabThen at the bottom of the list click Links and select one of the 
choices.I selected Simple then clicked Apply to see the report come upNow the 
last column is titled "Links" and at the end of each Payment row the Vendor 
Bill/Invoice/Reference number shows up so you can see that check was used to 
pay that bill.
Very Cool !
Thank you Adrien and also the GC dev Team.


On Monday, February 10, 2020, 01:05:15 PM EST, Adrien Monteleone 
 wrote:  
 
 There is a way, but it is quite cumbersome. (using the Lot viewer) I won’t go 
into any detail on that because there is a much simpler method using a new 
Customer Report (still in beta, introduced in 3.8) found in Reports > 
Experimental.

At first the report will come up blank and you’ll need to choose a customer in 
Options.

Then in Options > Display you can choose to show the linked documents either in 
a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many 
people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction 
notes/memos the bill# that is being paid by that transaction/split and if 
partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo 
is probably better unless you need that field for something else. (you have 
more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the 
text on a memo also changes the notes field to match, and setting the notes 
field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> There is no way to see what bill a check paid... is there?
> When paying a bill you get 5 fields...DatePaymentRefundNumMemo
> Date, Payment, and Refund won't do it.Num is for the check numberMemo could 
> be used but that is just a visual association... 
> Seems like the system ought out to have a report showing Vendor's 
> Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to 
> do it?
> We considered putting the vendors invoice/bill number in the Num field but 
> that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

[Fran_3 via gnucash-user]

 Thanks Adrien! I'll give the experimental report a test run. I also like your 
technique of putting the vendors bill@ in the notes/memos.
One untested idea I came up with was to enter the check number in the Payment 
"Num" field followed by a space & then the vendors bill/invoice id# all in the 
num field like for check number 1423 and vendor bill number 08279 I would 
enter...1432 08279or maybe put a colon after the ck num.Wonder if that will 
break something in one of the reports or else where?


On Monday, February 10, 2020, 01:05:15 PM EST, Adrien Monteleone 
 wrote:  
 
 There is a way, but it is quite cumbersome. (using the Lot viewer) I won’t go 
into any detail on that because there is a much simpler method using a new 
Customer Report (still in beta, introduced in 3.8) found in Reports > 
Experimental.

At first the report will come up blank and you’ll need to choose a customer in 
Options.

Then in Options > Display you can choose to show the linked documents either in 
a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many 
people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction 
notes/memos the bill# that is being paid by that transaction/split and if 
partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo 
is probably better unless you need that field for something else. (you have 
more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the 
text on a memo also changes the notes field to match, and setting the notes 
field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> There is no way to see what bill a check paid... is there?
> When paying a bill you get 5 fields...DatePaymentRefundNumMemo
> Date, Payment, and Refund won't do it.Num is for the check numberMemo could 
> be used but that is just a visual association... 
> Seems like the system ought out to have a report showing Vendor's 
> Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to 
> do it?
> We considered putting the vendors invoice/bill number in the Num field but 
> that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Payment paid which Bill? How to see which check paid which bill?

[Fran_3 via gnucash-user]

There is no way to see what bill a check paid... is there?
When paying a bill you get 5 fields...DatePaymentRefundNumMemo
Date, Payment, and Refund won't do it.Num is for the check numberMemo could be 
used but that is just a visual association... 
Seems like the system ought out to have a report showing Vendor's Bill/Invoice 
number & date plus the Payment Check number and date...
Is noting the vendors invoice/bill number in the Memo field the only way to do 
it?
We considered putting the vendors invoice/bill number in the Num field but that 
field is for our check number...
Am I missing something obvious? (Won't be the first time :-)
Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Does date order matter for Importing Checking Transactions?

[Fran_3 via gnucash-user]

 Thank you David! Now I know how to assign multiple checking transactions at 
once. Great tip.
And "Roger That" on debit/credit description fields. Very long & often very 
confusing.
Thanks again.
On Friday, February 7, 2020, 04:49:37 PM EST, David Cousens 
 wrote:  
 
 Fran

"That brings up another question... is there anyway in GC to assign multiple
checking transactions at once to a single expense account?"

Yes there is. In the import matcher window you can multiply select the
transactions you want to assign to a given transfer account (click on them
while holding CTRL key down or use click on one transaction and SHIFT click
on a second to select transactions between them). Once you have the
transactions selected, right click and a popup menu will allow you to run
the account selection dialog to pick the transfer account you want to
assign.

The import matcher can obviously only assign the account if there is
sufficient identifying characteristic information in the description field.
I have most problems with direct debit/credit  transactions where the
description field is often of limited length and the originator puts in a
descriptor which is totally unique to that transaction and can't be matched.

Cheers

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Does date order matter for Importing Checking Transactions?

[Fran_3 via gnucash-user]

 Thank you David. Good info.
FYI, I'm importing checking transactions which I downloaded a csv file from the 
bank, imported into Google Sheets
I re-formatted the columns to have the following...

Date, Num, Description, Deposit, Withdrawal
I then exported this from Google Sheets to a csv file.
(I also set up tabs on the Google Sheet to have the original bank data on tab 1 
and a template on tab 2... this way I can automate the reformatting process 
somewhat.)
Next I imported the csv file for entity one into GC 3.8.
I have a number of entities... each with their own GC file... Business 1, 
Business 2, Personal Banking, etc
I completed the import into Business 1 yesterday in two parts... 
Import 1... where I had to double click every transaction and assign it to AP 
or Sales, etc... and
Import 2 which "guessed" the proper account most of the time.
Today I'm importing to another entities GC file with many more transactions... 
and yes, I'm going to do it in manageable chunks... so the GC importer can 
train itself to get better and better each time.And yes, I "Rev" the GC file 
myself as needed and stash the old revisions into their own folder so I can go 
get 'em if necessary.
One of the Personal Bank Account issues is... since the advent of the bank 
debit card... nobody carries cash any more so you end up with a zillion little 
debit card transactions... and no matter weather you import or key them in... 
it's a pain to assign them to the proper account(s). 

That brings up another question... is there anyway in GC to assign multiple 
checking transactions at once to a single expense account?
Thanks again for the help.








On Friday, February 7, 2020, 3:53:17 PM EST, David Cousens 
 wrote:  
 
 Fran,

The date shouldn't matter but having them date ordered can help when sorting
out any problems (easier to locate in the data file). David Carlson's reason
for suggesting importing in small batches initially are twofold. 

1. The importer has a Bayesian matcher which will automatically match
existing transactions in your record ( perhaps not too much of a problem) to
avoid duplicates (matches on information mainly in the description field).
It also automatically matches the transfer accounts on the second split of
the transaction if it can. The training information for this is the import
process itself and the account assignements you make in the importer.
Corrections you make after import in the account register will not be
included in the training data.  With QIF these,may be specified. If GnuCash
has to assign the transfer account (I can't remember if the accounts for
both splits are specified in QIF files) this will eventually speed up the
importing. If  the accounts are specified in the QIF there is a matching
step in which the accounts specified in the import data are matched to the
imported accounts and that mapping is stored for use on subsequent imports.

2. If a relatively small import doesn't work out, you can manually delete
the transactions and start again much more easily. A strategy which can help
with this is to exit and restart GnuCash between each import batch. This
will force the creation of a backup file and log file in the directory your
GnuCash data file is located (it is also agood practice to locate each data
file you may have in its own directory/folder). In this case if your data
was OK up to the last import, you can go back to the last backup data file,
rename the current data file as old, rename the backup file as your data
file and then repeat the import (after identifying any problems and fixing
them) without having to delete all the transactions. Deleting transactions
can only be done one by one and can get very tedious. If your import affects
several registers , which I think it can with QIF imports it can be fun
locating them all to delete.

If a transfer account is not specified during input Gnucash will normally
assign an account named Imbalance as the transfer account. This serves the
same purpose as the  "Un-allocated Expenditures" or "Sort Later" or "No Tax
Impact Purchases" although you can still do the latter if it makes your task
easier.  Check the Imbalance account after importing though. It should have
a 0 balance and no transactions to it and any transactions which end up in
it will need correcting.

Good luck

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To 

[GNC] Does date order matter for Importing Checking Transactions?

[Fran_3 via gnucash-user]

Does date order matter when importing checking transactions?
I'm guessing they are ordered by date in the Check Register view and not by the 
order in which they were entered or imported in the system... right?
I'm asking because this next account I'll be working on has almost 2,000 
transactions to import and a large number of the are debit cart transactions 
that will not be applied as payment towards a Vendor Bill...

So I was going to sort the downloaded checking transactions to separate the 
casual debit card purchases...Then import those transactions which will require 
Posting a BillThen apply those checking transactions.as payments for each 
posted bill.
Then import the truck load of casual debit cart purchases... and either put 
them all into an accoun named "Un-allocated Expenditures" or "Sort Later" or 
"No Tax Impact Purchases" or whatever.
So, are there any consequences when you import checking transactions not 
ordered by oldest date first?
Thanks for any help.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to upgrade from GC 3.7 to 3.8?

[Fran_3 via gnucash-user]

 This answer along with the others gave me the confidence to proceed with the 
upgrade from 3.7 to 3.8 on my Windows 10 PC.And it worked! So I' m now up and 
running with GC 3.78.
For others doing this here is the dialog box you will see during the upgrade...

Hope this helps.
And thanks to those here for your help!

On Thursday, February 6, 2020, 01:16:47 AM EST, David Cousens 
 wrote:  
 
 Fran 

On WIndow, the installer will ask you during the process if you want to
uninstall the previous version before installing the new version.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  ___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to upgrade from GC 3.7 to 3.8?

[Fran_3 via gnucash-user]

 I''m running Windows 10 so if anyone else is running the same OS let me hear 
if I should unstall GC 3.7 before installing 3.8 or just install 3.8 on top of 
3.7.Thanks

On Wednesday, February 5, 2020, 08:22:54 PM EST, Adrien Monteleone 
 wrote:  
 
 OS?

I’ve had some issues with linux but that was building from scratch with a very 
new version on an older distro. A regular install shouldn’t be an issue.

On Mac I’ve had no problems simply installing the newer version. MacOS asks if 
you want to overwrite or keep both.

I’ve never used Gnucash on Windows, so I can’t help there.

Regards,
Adrien

> On Feb 5, 2020 w6d36, at 6:10 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> Just realized I'm about to do a giant import and the advice here is to do it 
> with v3.8.
> Should I uninstall gnuCash first or just download and install 3.8 on top of 
> 3.7?
> Thanks.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to upgrade from GC 3.7 to 3.8?

[Fran_3 via gnucash-user]

Just realized I'm about to do a giant import and the advice here is to do it 
with v3.8.
Should I uninstall gnuCash first or just download and install 3.8 on top of 3.7?
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

[Fran_3 via gnucash-user]

 Derek, your answer confirmed Adrian's post and both gave me the confident to 
experiment today. I'll pull the trigger on the big import tomorrow and report 
back.
On Wednesday, February 5, 2020, 09:18:35 AM EST, Derek Atkins 
 wrote:  
 
 Hi,

Fran_3 via gnucash-user  writes:

> Will assigning the Expense Account during import conflict with later
> creating a bill and then assigning a checking transaction as payment
> for that bill? (Since the Expense Account is normally assigned during
> creation of the bill... so this will be kind of backwards... I think)
> I hope I made the issue and question clear. At least I gave it my best shot 
> :-)

The short answer is "yes".  If you import the check into Bank and
always assign the "correct" Expense account, then you will bypass the
Bill completely.  For Vendors that have a Bill you *MUST* assign the
payment to AP, not the appropriate Expense.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
      Derek Atkins                617-623-3745
      de...@ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

[Fran_3 via gnucash-user]

 Thank you Adrien. Your answer was very helpful. I experimented today and hope 
to do the big import tomorrow. Wish me luck :-)

On Tuesday, February 4, 2020, 12:17:54 PM EST, Adrien Monteleone 
 wrote:  
 
 It’s okay to not give a final “thanks” message, but it is helpful to inform 
the list that the particular advice either did or did not answer the question 
or help solve the problem. (or even help lead you to the solution and what that 
might have turned out to be) This way, future readers of the archive aren’t 
left in limbo as to how the thread resolved in case they have a similar 
question. Sometimes, a simple “thanks, that worked” is sufficient and 
acceptable. (with the ’that worked’ part being more important than the ’thanks’ 
part)

As for the mechanics of the import, it should allow you to train the importer 
for each payee. Thus the vendors you pay outright without raising bills would 
be assigned to a relevant expense account, but vendors you do raise bills for 
would get a different assignment, most likely Accounts Payable, then after the 
import, assign each of those as payment individually as appropriate to the 
relevant vendor invoices. (normally you don’t make manual entries against AP, 
noted in another thread) Be certain to use the “Assign as payment” feature from 
the checking register as a safety measure. (I’m not even sure you can do it 
from AP)

It is highly recommended when first starting an import workflow to do so with 
just a few transactions at a time, then move up to perhaps an entire month, 
then you can move up to a larger batch. Some veterans on this list always 
recommend to do one month at a time no matter what, check over everything 
carefully, reconcile, then move to the next month.

As you do each import, you are refining the training of the importer so you 
have to do less and less work each time making assignments or correcting 
mismatched imports. (you don’t want to jump head first and then have to review 
hundreds or thousands of transactions for errors or improper account 
assignments, and then you miss the benefit of training the importer)

You might want to start with just importing basic expenses and get some of 
those payees trained and make sure the importer matches subsequent imports 
correctly. Then move on to the business payments that need to be assigned. All 
of them should go to AP and each subsequent import should do this correctly.

As you move through the process (working from oldest imports to current day) 
the importer will improve and the entire process will be faster with less 
manual input. Future imports will be even smoother.

Finally, be certain to use the latest v3.8 as older versions had their 
individual bugs and quirks with the importer. (there might still be some 
outstanding to be fixed or improved, but the best state of the feature is in 
the current version)

Regards,
Adrien

> On Feb 4, 2020 w6d35, at 10:55 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> We have two types of vendors...1 - Vendors for which we receive & post bills2 
> - Vendors for which we just write a check and make an entry into the checking 
> account
> Normally...In Case 1, we post bills first, assign an expense account, and 
> later pay the bill. The expense account is assigned when we create the bill.
> In Case 2 we assign the Expense Account when entering the transaction into 
> the check register.
> Now...- We are about to import months of checking transactions.
> - Later we will Post Bills for any of those transactions for which we receive 
> bills.
> - Then we will Apply the associated checking transactions as payments for the 
> associated vendor Bills.
> 
> Here is the question:
> When we import the checking transactions I'm guessing we can assign the 
> appropriate Expense Account during that import.
> 
> Will assigning the Expense Account during import conflict with later creating 
> a bill and then assigning a checking transaction as payment for that bill? 
> (Since the Expense Account is normally assigned during creation of the 
> bill... so this will be kind of backwards... I think)
> I hope I made the issue and question clear. At least I gave it my best shot 
> :-)
> Thanks for any help.
> PS - I've recently posted a number of questions leading up to this big import 
> and when given answers have chosen not to send out a "Thank You" response. 
> I've done this in order to not needlessly clog up everybody's inbox. But, I 
> do want to say "Thank You" now for your assistance. I hope my choice of not 
> sending out a simple "Thank You" is appropriate protocol but if not let me 
> know as the members here are just terrific and very helpful.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash

[GNC] Importing Checking Transactions: Expense Acct Assignment Question.

[Fran_3 via gnucash-user]

We have two types of vendors...1 - Vendors for which we receive & post bills2 - 
Vendors for which we just write a check and make an entry into the checking 
account
Normally...In Case 1, we post bills first, assign an expense account, and later 
pay the bill. The expense account is assigned when we create the bill.
In Case 2 we assign the Expense Account when entering the transaction into the 
check register.
Now...- We are about to import months of checking transactions.
- Later we will Post Bills for any of those transactions for which we receive 
bills.
- Then we will Apply the associated checking transactions as payments for the 
associated vendor Bills.

Here is the question:
When we import the checking transactions I'm guessing we can assign the 
appropriate Expense Account during that import.

Will assigning the Expense Account during import conflict with later creating a 
bill and then assigning a checking transaction as payment for that bill? (Since 
the Expense Account is normally assigned during creation of the bill... so this 
will be kind of backwards... I think)
I hope I made the issue and question clear. At least I gave it my best shot :-)
Thanks for any help.
PS - I've recently posted a number of questions leading up to this big import 
and when given answers have chosen not to send out a "Thank You" response. I've 
done this in order to not needlessly clog up everybody's inbox. But, I do want 
to say "Thank You" now for your assistance. I hope my choice of not sending out 
a simple "Thank You" is appropriate protocol but if not let me know as the 
members here are just terrific and very helpful.






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Why doesn't Posted Bill show up in AP? Only after Paid

[Fran_3 via gnucash-user]

When you post a bill I would expect it to be charged to the appropriate expense 
account and to AP
But I have to pay it before it appears in AP
Clearly I'm no accountant but that is my understanding of how "Double Entry" 
bookkeeping works


Maybe someone can educate me :-)
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] What "Transfer" acct when paying vendor out of Checking?

[Fran_3 via gnucash-user]

Its been quite awhile since I've used gnuCash & I'm trying to catch.
When I pay a vendor directly from checking... not paying a bill,  just writing 
a check & recording it in the check register...
For "Transfer"do I select "Libalities: Accounts Payable"orUse the dropdown to 
select the percise expense account?

Thanks for reminding me of how to do this.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

[Fran_3 via gnucash-user]

 Ignore my "tried to test this" post. I think I have it figured out.. I'll 
repost question otherwise. Thanks for the help.
On Monday, February 3, 2020, 12:32:27 PM EST, Fran_3 via gnucash-user 
 wrote:  
 
  Well I tried to test this via...- Creating an Exp Account named Unassigned 
Expenses- Then entered a test $99 transaction in the check register and 
assigned it to Unassigned Expenses.- I tried right clicking the $99 checking 
transaction but no option to Apply As Payment.
- I tried right clicking the $99 transaction in the Unassigned Expense account 
but no option to Apply As Payment.
Maybe I didn't do the test correctly.
Maybe importing a CSV file puts the items elsewhere in the system.

Thanks if you can give me some additional guidance.



    On Monday, February 3, 2020, 11:41:40 AM EST, Adrien Monteleone 
 wrote:  
 
 If those previously imported transactions are payments, then yes you can.

Simply right-click the imported transaction and choose ‘Apply as payment’. 
You’ll then get the Process Payment window where you can choose which 
bill/invoice to apply to.

Just make sure your dates in the registers and on invoices/bills reflects the 
real world transaction and not the date you happen to enter them in GnuCash or 
else down the road you’ll have a hard time tracing an error or when otherwise 
investigating something. You can certainly do the data entry out of order 
though. (such as importing payments and receipts before entering the 
bills/invoices they were for.)

If you are receiving or making pre-payments routinely and that is why you are 
using this order, consider marking each of those affected transactions as such 
using the same “Apply as payment” option. Then when you create and post the 
documents, ‘pay’ them by applying the pre-payments as needed. This would allow 
you to see in Vendor/Customer reports and aging reports (the new version) the 
tracking for the pre-payments rather than just having them floating around in 
your bank register waiting for you to post the bills/invoices and then 
assigning them as payments. How much time lag there is between the transaction 
dates from step 1 and step 2 would help guide you on if this is the right 
course.

Regards,
Adrien

> On Feb 3, 2020 w6d34, at 9:37 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> Can I 1 - import banking transactions
> Then2 - Post Bills from vendors & Invoices to clients
> Then
> 3 - Apply the previously imported bank transaction to the appropriate bill or 
> invoice?
> Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

[Fran_3 via gnucash-user]

 Well I tried to test this via...- Creating an Exp Account named Unassigned 
Expenses- Then entered a test $99 transaction in the check register and 
assigned it to Unassigned Expenses.- I tried right clicking the $99 checking 
transaction but no option to Apply As Payment.
- I tried right clicking the $99 transaction in the Unassigned Expense account 
but no option to Apply As Payment.
Maybe I didn't do the test correctly.
Maybe importing a CSV file puts the items elsewhere in the system.

Thanks if you can give me some additional guidance.



On Monday, February 3, 2020, 11:41:40 AM EST, Adrien Monteleone 
 wrote:  
 
 If those previously imported transactions are payments, then yes you can.

Simply right-click the imported transaction and choose ‘Apply as payment’. 
You’ll then get the Process Payment window where you can choose which 
bill/invoice to apply to.

Just make sure your dates in the registers and on invoices/bills reflects the 
real world transaction and not the date you happen to enter them in GnuCash or 
else down the road you’ll have a hard time tracing an error or when otherwise 
investigating something. You can certainly do the data entry out of order 
though. (such as importing payments and receipts before entering the 
bills/invoices they were for.)

If you are receiving or making pre-payments routinely and that is why you are 
using this order, consider marking each of those affected transactions as such 
using the same “Apply as payment” option. Then when you create and post the 
documents, ‘pay’ them by applying the pre-payments as needed. This would allow 
you to see in Vendor/Customer reports and aging reports (the new version) the 
tracking for the pre-payments rather than just having them floating around in 
your bank register waiting for you to post the bills/invoices and then 
assigning them as payments. How much time lag there is between the transaction 
dates from step 1 and step 2 would help guide you on if this is the right 
course.

Regards,
Adrien

> On Feb 3, 2020 w6d34, at 9:37 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> Can I 1 - import banking transactions
> Then2 - Post Bills from vendors & Invoices to clients
> Then
> 3 - Apply the previously imported bank transaction to the appropriate bill or 
> invoice?
> Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing bank transactions B4 posting bills & Invoices - question

[Fran_3 via gnucash-user]

Can I 1 - import banking transactions
Then2 - Post Bills from vendors & Invoices to clients
Then
3 - Apply the previously imported bank transaction to the appropriate bill or 
invoice?
Thanks for any help.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to assign a pre-existing payment to a bill?

[Fran_3 via gnucash-user]

 Great. Thank you for the help Greg.
Fran3

On Monday, November 18, 2019, 11:28:12 AM EST, Greg Feneis 
 wrote:  
 
 What about right click transaction and select assign as payment?

Kind regards, Greg Feneis
(Pixel 3)


On Mon, Nov 18, 2019, 06:14 Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> How can I assign a recorded Payment in gnuCash written to a vendor...
> As a payment for the Bill that was posted after the payment was made?
> Must I delete the deposit/payment and then re-create it as a payment for
> that particular Bill or what?
>
> Also...
> How can I assign a pre-existing deposit in gnuCash as a payment for a
> specific Invoice for CustomerX?
> Must I delete the deposit and re-create it as a payment for that invoice
> or what?
> Thanks for any help.
> Fran3
>
>
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to assign a pre-existing payment to a bill?

[Fran_3 via gnucash-user]

 Perfect. Thank you.

On Monday, November 18, 2019, 11:20:21 AM EST, Geert Janssens 
 wrote:  
 
 Op maandag 18 november 2019 15:10:55 CET schreef Fran_3 via gnucash-user:
> How can I assign a recorded Payment in gnuCash written to a vendor...
> As a payment for the Bill that was posted after the payment was made?
> Must I delete the deposit/payment and then re-create it as a payment for
> that particular Bill or what?
> 
> Also...
> How can I assign a pre-existing deposit in gnuCash as a payment for a
> specific Invoice for CustomerX? Must I delete the deposit and re-create it
> as a payment for that invoice or what? Thanks for any help.
> Fran3

In both cases, right-click on the pre-existing transaction and select "Assign 
as payment". It should pop up a payment dialog in which you can select your 
vendor or customer, then the proper bill or invoice and then complete the 
payment handling as you would otherwise.

Regards,

Geert


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to assign a pre-existing payment to a bill?

[Fran_3 via gnucash-user]

How can I assign a recorded Payment in gnuCash written to a vendor...
As a payment for the Bill that was posted after the payment was made?
Must I delete the deposit/payment and then re-create it as a payment for that 
particular Bill or what?

Also...
How can I assign a pre-existing deposit in gnuCash as a payment for a specific 
Invoice for CustomerX?
Must I delete the deposit and re-create it as a payment for that invoice or 
what?
Thanks for any help.
Fran3







___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Will the reports file "saved-reports-2.8" recreate itself if deleted or moved?

[Fran_3 via gnucash-user]

To be clear on your answer to question 1... 

If I delete or move the file  "saved-reports-2.8" gnuCash will recreate it WHEN 
I create a new report and save the report configuration... right?
Thanks for the help John.
Fran3


On Monday, November 11, 2019, 10:58:29 PM EST, John Ralls 
 wrote:  
 
 

> On Nov 11, 2019, at 1:11 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I have about 40 reports I created for this project and I  would like to keep 
> them for future reference.
> BUT that many reports clutter up the view when retrieving saved report 
> configurations...
> I may not reference these particular reports for a year so I would like to  
> stash them... that is stash  their definitions/configuration file 
> "saved-report-2.8" in another folder until I need those particular reports 
> again.
> 
> 
> Question 1: If I move the reports config file saved-report-2.8 to a  backup 
> folder for future use and then delete it from its normal folder at
> C:\Users\User-X\AppData\Roaming\GnuCash
> Will gnuCash recreate a new "saved-report-2.8" file when I re-launch the 
> gnuCash App?
> 
> Question 2: If months down the road I need to recover the saved-report-2.8 
> file that I stashed elsewhere...
> Can I swap the current saved-report-2.8 file with the one I stashed... and 
> visa-versa as needed?
> 
> Question 3: I made a simple Transaction Report named Test that only looked at 
> the checking account. Then I made a copy of saved-report-2.8 and looked at it 
> with NotePad++. 
> 
> The text in the file, I assume, consist of instructions used by gnuCash to 
> create the report... 
> 
> meaning the contents of saved-report-2.8 is not a language to query the 
> gnuCash data... right?
> Thanks for any help. Fran3
> 

1. No, unless you create new saved report configs.
2. Yes. Just make sure to shut down GnuCash while you're switching the files.
3. The current version of the file contains the report names and a Scheme 
(that's a computer programming language) representation of the options you 
changed from the default values to create the custom report. You are correct 
that it does not contain queries. Most GnuCash reports work by iterating over 
the accounting objects in memory rather than using the query framework.

Regards,
John Ralls  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Will the reports file "saved-reports-2.8" recreate itself if deleted or moved?

[Fran_3 via gnucash-user]

I have about 40 reports I created for this project and I  would like to keep 
them for future reference.
 BUT that many reports clutter up the view when retrieving saved report 
configurations...
I may not reference these particular reports for a year so I would like to  
stash them... that is stash  their definitions/configuration file 
"saved-report-2.8" in another folder until I need those particular reports 
again.


Question 1: If I move the reports config file saved-report-2.8 to a  backup 
folder for future use and then delete it from its normal folder at
C:\Users\User-X\AppData\Roaming\GnuCash
Will gnuCash recreate a new "saved-report-2.8" file when I re-launch the 
gnuCash App?

Question 2: If months down the road I need to recover the saved-report-2.8 file 
that I stashed elsewhere...
Can I swap the current saved-report-2.8 file with the one I stashed... and 
visa-versa as needed?

Question 3: I made a simple Transaction Report named Test that only looked at 
the checking account. Then I made a copy of saved-report-2.8 and looked at it 
with NotePad++. 

The text in the file, I assume, consist of instructions used by gnuCash to 
create the report... 

meaning the contents of saved-report-2.8 is not a language to query the gnuCash 
data... right?
Thanks for any help. Fran3




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to create report on checking showing only withdrawals? Or only deposits?

[Fran_3 via gnucash-user]

 Adrien, 


I ran a find on the check register and looked for...

Value has credits greater than zero
Looks like that gave me all withdrawals from checking...

Then I ran another Ctrl-F and searched for date after... 

Then again and searched for date before...
Looks like that gave me all withdrawals from checking for the period...

Then I ran an Account Report to get the totals
So thanks for (once again :-) reminding me to search the register and then run 
an Account Report.
That said, my issue with this is you only get the split view... and the Account 
Report does not give you all the options you have with the Transaction 
Report... 

But, going the Transaction Report route will not let me see only deposits or 
only withdrawals... so your way is best because it actually works :-)
Thanks again, Fran3



On Monday, November 11, 2019, 9:43:09 AM EST, Adrien Monteleone 
 wrote:  
 
 You don’t run the report and then search it.

You search from the target register or from the Accounts tab. (usually better 
results)

Then run a report from the result tab. (if you need it, I usually just work 
from the search results, but reports can give you totals, subtotals and may do 
some sorting.)

Regards,
Adrien

> On Nov 10, 2019 w46d314, at 7:31 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I can't seem to create a report on checking (or another asset account) that 
> only shows goes-outta's... aka withdrawals... aka credits.
> I tried running a Transaction Report on Checking then hitting Ctl-F and 
> setting the parameters to...
> Search for "value" where credits are greater than or equal to zero...
> But that did not appear to search the the report as I got opening balances 
> from numerous accounts... and who knows what else.
> I made a number of other attempts/experiments but... no joy.
> I'm sure this is obvious to those more experienced and hopefully someone will 
> enlighten me :-)
> Thanks, Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to create report on checking showing only withdrawals? Or only deposits?

[Fran_3 via gnucash-user]

I can't seem to create a report on checking (or another asset account) that 
only shows goes-outta's... aka withdrawals... aka credits.
I tried running a Transaction Report on Checking then hitting Ctl-F and setting 
the parameters to...
Search for "value" where credits are greater than or equal to zero...
But that did not appear to search the the report as I got opening balances from 
numerous accounts... and who knows what else.
I made a number of other attempts/experiments but... no joy.
I'm sure this is obvious to those more experienced and hopefully someone will 
enlighten me :-)
Thanks, Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to create Report on Checking & Exclude one Entity ?

[Fran_3 via gnucash-user]

 Adrian, Thanks for the response.
I have to admit I have done regular expressions... but I often tire of the 
fight... as I ultimately did in this case.
My solution in this particular case was to port the gnuCash check register into 
a spreadsheet and manipulate it from there to exclude the target entity and 
ultimately get the desired result.
Fran3
PS - I did try running a Transaction Report on Checking and then hit Ctl F and 
searched the Description for the entity name using the "does not match regex" 
option... but the results were confusing to  me... 

Actually I was unsure if I should just enter the entity name in the "does 
notmatch regex" search field...
 or if I should enter a regular expression... 

but just entering the entity name... Vendor X... didn't seem to return all 
checking transactions except those to/from Vendor X.







On Sunday, November 10, 2019, 6:37:23 PM EST, Adrien Monteleone 
 wrote:  
 
 You have two options, but both require a negative regex, which while possible, 
might not be part of the regex library used by GnuCash. (I don’t know, you’d 
have to try it out)

#1 - Transaction Report (as requested) with regex *not matching* a string in 
the Filter field. (it will return transactions that do not match that string in 
the Description, but also the Notes & Memo, which may or may not, be okay.)

#2 - Find, followed by Account Report - same regex expression, but with the 
ability to *only* filter on the Description and not also the Notes and Memo 
fields.

Which you use is up to you, or which one actually works at all. (if either)

Please do let us know if you manage this as I’m sure others would be interested.

Regards,
Adrien

> On Nov 10, 2019 w46d314, at 9:21 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> I guess I suffering from project fatigue on this exercise as, all of a 
> sudden, I cant run a Transaction Report on Checking and then exclude all 
> transactions to a particular entity... Vendor X
> I thought I had done this before but... maybe not.
> 
> Without grinding through all the attempts I've made this morning would some 
> kind soul just tell me how to do this...
> And note... the entity name has two words in it... "Vendor X" in this 
> example... both of which are necessary for unique identification.
> Thanks for any help. Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to create Report on Checking & Exclude one Entity ?

[Fran_3 via gnucash-user]

I guess I suffering from project fatigue on this exercise as, all of a sudden, 
I cant run a Transaction Report on Checking and then exclude all transactions 
to a particular entity... Vendor X
I thought I had done this before but... maybe not.

Without grinding through all the attempts I've made this morning would some 
kind soul just tell me how to do this...
And note... the entity name has two words in it... "Vendor X" in this 
example... both of which are necessary for unique identification.
Thanks for any help. Fran3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] (no subject)

[Fran_3 via gnucash-user]

 Ah Ha! Thanks Chris, I'll give this a try. Good tip.Thanks again.

On Saturday, November 9, 2019, 3:28:55 PM EST, Chris Good 
 wrote:  
 
 Hi Fran,

Something I didn't realize you could do for a long time was to open 2 reports 
in separate side by side windows so you can easily visually compare them. I'm 
not at my computer now but I think the options to do this are under the Window 
or View menus.

Regards,

Chris Good
---
> 
> Message: 8
> Date: Sat, 9 Nov 2019 18:17:02 + (UTC)
> From: Fran_3 
> To: Gnucash Users ,  Adrien Monteleone
>    
> Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan
>    transactions
> Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
> 
> Adrian, you said... "instead do a Find operation then run an Account Report 
> instead of a Transaction Report. (since Find can filter on more fields)"
> My comment: 
> I did not know about the "Account Report"? option... It seems it only appears 
> under the Reports Menu if you are looking at a register (aka account)... like 
> the check register or AP or AR register... or after you do a Ctl F (Find) 
> operation... 
> This is very useful.
> Thanks for this tip Adrian !
> Fran3
> 
>    On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone 
> wrote:  
> 
> I would say consider the criteria you used to create the set of transactions 
> for each report, then try to craft a report using the options that gives you 
> only those that don?t lie in the joint set.
> 
> If *every* transaction on both reports is between two and only the *same two* 
> accounts then you might do better with using regex and/or instead do a Find 
> operation then run an Account Report instead of a Transaction Report. (since 
> Find can filter on more fields)
> 
> My personal mileage is better with running Find operations from the Accounts 
> tab rather than a particular register.
> 
> If however, the two reports have transactions all sharing one account in 
> common (say checking) but not other splits, you might want to investigate the 
> Account Filter option. So while filtering on other data might appear to get 
> you what you want, sometimes filtering by the ?other? split narrows things 
> down much faster. With a Transaction Report (as opposed to Find then Account 
> Report) you can filter based on including or not including transactions which 
> have splits in other accounts.
> 
> Otherwise, the spreadsheet approach is likely the simplest. If you know how 
> to use command-line tools, you could use the spreadsheet step just for saving 
> in CSV format, then using a cli `diff` tool to show you what is different 
> between the two files. (MacOS as well as most if not all BSD & Linux 
> distributions have this built-in. I?m not sure about Windows)
> 
> Such tools are very fast and each one has its own features. The output takes 
> some getting used to as most are not super ?clean? on screen, but once you do 
> it enough, you?ll be able to use them more effectively.
> 
> You could jump straight to using `diff` and get used to it, and it will help 
> get the job done, but the better option is to think carefully about what you 
> are trying to find and then crafting a Find or Report that gets you there 
> from within GnuCash.
> 
> Regards,
> Adrien
> 
> 
> 
>> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user 
>>  wrote:
>> 
>> I want to compare Transaction Report A to Transaction Report B
>> and find transactions that appear on one report but not on the other... aka 
>> orphan transactions
>> In past I have either...
>> - Done a screen capture of each, pasted them side by side in PC Paint and 
>> marked off matching transactions one by one...
>> - Or printed them out and done the same with pen & paper
>> - Or exported the reports and then imported them into a spreadsheet and 
>> marked matching transactions one by one
>> All of this is a bunch of work...
>> 
>> Is there an easier way?
>> Thanks for any help - Fran3  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] EZ Tip - Porting a GC Report into a Spreadsheet

[Fran_3 via gnucash-user]

This may work with Excel but we most often use the free Google Docs version... 
Google Sheets...
And, I'm sure I'm the last person on the block to discover this but...
 In order to "port" a GC Transaction Report to a spreadsheet for special 
manipulation...

 I have been Exporting the report
And then importing it into the spreadsheet.
A quick and easy shortcut is to simply drag your mouse over the report 
transactions you want and then paste that into Google Sheets... and ka-boom... 
there you have it...
Saved me a lot of time exporting and importing.
Hope this works for you if you need it. Fran3



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Website Down

[Fran_3 via gnucash-user]

 John, 
Just wondering who host the website? 
Also, is it a shared server  or  is the traffic so intense that it takes a 
dedicated server?Thanks, Fran3


On Saturday, November 9, 2019, 1:34:02 PM EST, John Ralls 
 wrote:  
 
 

> On Nov 9, 2019, at 9:52 AM, Derek Atkins  wrote:
> 
> 
> On Sat, November 9, 2019 12:45 pm, John Ralls wrote:
>> 
>> Liz,
>> 
>> Because there are two separate hosts involved. The website lives at
>> https://www.gnucash.org, 67.198.37.17. It's currently down with a failed
>> power supply. Everything else (including the mailing lists) is on
>> https://code.gnucash.org, 204.107.200.6, and its various aliases
> 
> It is actually .65, not .6.  :)
> 
>> (lists.gnucash.org, wiki.gnucash.org, etc.).  If the mailing lists are
>> working so is the wiki.
> 
> We've been trying to figure out a way to get HA for www.gnucash.org.  We
> just haven't quite figured out the right technology.  Maybe this is the
> time to think about it?

If we want to go HA I'd think code would be a better candidate, it's far more 
important to day-to-day operation than www, but we might as well do both if 
we're going to the effort.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

[Fran_3 via gnucash-user]

Christopher said "You've stumbled upon a limitation SFX of regular expressions 
on filtering the transaction report."
My Question: Wikipedia list numerous definitions for SFX... in this case what? 
(Self Extracting Software or what?)
Greg Francis suggested NotePad++
My Response: Yes, I am a longtime user of NP++ but for a number of reasons it 
didn't do the trick in this particular case.
In this case I ended up having to use a spreadsheet ... I won't go through the 
blow by blow but I (finally) got it done :-)
Fran3


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

[Fran_3 via gnucash-user]

 Adrian, you said... "instead do a Find operation then run an Account Report 
instead of a Transaction Report. (since Find can filter on more fields)"
My comment: 
I did not know about the "Account Report"  option... It seems it only appears 
under the Reports Menu if you are looking at a register (aka account)... like 
the check register or AP or AR register... or after you do a Ctl F (Find) 
operation... 
This is very useful.
Thanks for this tip Adrian !
Fran3

On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone 
 wrote:  
 
 I would say consider the criteria you used to create the set of transactions 
for each report, then try to craft a report using the options that gives you 
only those that don’t lie in the joint set.

If *every* transaction on both reports is between two and only the *same two* 
accounts then you might do better with using regex and/or instead do a Find 
operation then run an Account Report instead of a Transaction Report. (since 
Find can filter on more fields)

My personal mileage is better with running Find operations from the Accounts 
tab rather than a particular register.

If however, the two reports have transactions all sharing one account in common 
(say checking) but not other splits, you might want to investigate the Account 
Filter option. So while filtering on other data might appear to get you what 
you want, sometimes filtering by the ‘other’ split narrows things down much 
faster. With a Transaction Report (as opposed to Find then Account Report) you 
can filter based on including or not including transactions which have splits 
in other accounts.

Otherwise, the spreadsheet approach is likely the simplest. If you know how to 
use command-line tools, you could use the spreadsheet step just for saving in 
CSV format, then using a cli `diff` tool to show you what is different between 
the two files. (MacOS as well as most if not all BSD & Linux distributions have 
this built-in. I’m not sure about Windows)

Such tools are very fast and each one has its own features. The output takes 
some getting used to as most are not super ‘clean’ on screen, but once you do 
it enough, you’ll be able to use them more effectively.

You could jump straight to using `diff` and get used to it, and it will help 
get the job done, but the better option is to think carefully about what you 
are trying to find and then crafting a Find or Report that gets you there from 
within GnuCash.

Regards,
Adrien



> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> I want to compare Transaction Report A to Transaction Report B
> and find transactions that appear on one report but not on the other... aka 
> orphan transactions
> In past I have either...
> - Done a screen capture of each, pasted them side by side in PC Paint and 
> marked off matching transactions one by one...
> - Or printed them out and done the same with pen & paper
> - Or exported the reports and then imported them into a spreadsheet and 
> marked matching transactions one by one
> All of this is a bunch of work...
> 
> Is there an easier way?
> Thanks for any help - Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to compare 2 Transaction Reports to find orphan transactions

[Fran_3 via gnucash-user]

I want to compare Transaction Report A to Transaction Report B
and find transactions that appear on one report but not on the other... aka 
orphan transactions
In past I have either...
- Done a screen capture of each, pasted them side by side in PC Paint and 
marked off matching transactions one by one...
- Or printed them out and done the same with pen & paper
- Or exported the reports and then imported them into a spreadsheet and marked 
matching transactions one by one
All of this is a bunch of work...

Is there an easier way?
Thanks for any help - Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Report Transaction Filter for: Not Equal To

[Fran_3 via gnucash-user]

When I create a Transaction Report and click on Filter...
I can put a word into the Transaction Filter field and click OK to search the 
report for transactions with that word in their description field.
The Question:
How would I search for all transactions that do not contain a certain word such 
as "Printing" ...


I assume I would have to use Regular Expressions (groan) but I've attempted 
several regX syntax strings and can't seem to get it right.

Thanks for any help - Fran3
PS - BTW, what fields are searched when you put a word into the Transaction 
Filter field? Description, Memo, Notes, Value, or what or all fields in a 
transaction entry?




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to delete multiple payments & posted bills?

[Fran_3 via gnucash-user]

BizA had an issue with VendorX and needs to delete most of VendorX's posted 
bills & associated payments.
We can go in and...
- delete each individual payment one at a time

- then un-post each individual bill one at a time

- then delete each individual bill one at a time
But... is there any way to...
- delete all the appropriate payments at once
- and then delete all the appropriate posted bills at once
- without having to do each and every one individually?

Thanks for any help - Fran3



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Export Report Issue: "There is no disk in the drive." I must click Continue 21 Times !

[Fran_3 via gnucash-user]

 Thanks Michael but no joy. 

When I'm looking at the GC report and I click Export the "Save HTML to file" 
window opens and shows the path to the correct folder on my PC... 

But I have to click "Continue" 21 times before the "No Disk" window will go 
away and let me actually enter a name for the report and then click Export.
C:\Users\UserMe\folder-x\folder-y\folder-z\gnuCash

That folder exist and the report will ultimately save there fine... but only 
after clicking Continue 21 times:-(
Thanks for any more ideas or suggestions.
Fran3

On Wednesday, November 6, 2019, 7:39:11 PM EST, Michael or Penny Novack 
 wrote:  
 
 On 11/6/2019 6:54 PM, Fran_3 via gnucash-user wrote:
> Running GC3.7 on Win7 Pro. Here is the issue
>
> When I click File > Export > Export Report
> I get a popup message...
>
>
> "There is no disk in the drive. Please insert a disk into drive 
> \Device\Harddisk9\DR-9"
>
This isn't QUITE a gnucash problem, you'd have it with any "save as" 
type of operation. Which is why you are also having this problem trying 
to save PDFs.

When you export from gnucash you will be supplying a name and a 
directory (aka "file folder"). In other words, a PATH.  There will 
already be SOME path currently there (maybe from the last time you did a 
"save as" type of operation) but this is almost certainly not where you 
want the export to put things.

In other words, you will want to be supplying that path (choosing that 
folder)

The "error" message you saw was because although there was a path 
specified, it is one not currently/no longer valid (say referring to a 
mountable device that is not currently mounted). It is telling you that 
you DON'T have a "\Device\Harddisk9\DR-9". You want to be specifying a 
path that you DO have.

You are on Windows7? Do you know where your Documents folder is? In 
Documents create a subfolder with a name like "gnucash reports". See 
what the full path to that is? Try specifying THAT path when you do the 
File > Export > Report operation. While you are at this, you might as 
well create a subfolder for those PDFs.

Michael D Novack



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Adrien, 

What is the CoA tab for all accounts? Where is it?
(This is what is so great about gnuCash, it is so rich in features that you can 
almost learn something new abut it's capabilities every day :-)
Fran3


On Friday, November 1, 2019, 10:01:07 PM EDT, Adrien Monteleone 
 wrote:  
 
 As Fran notes, the Transaction report has several filters and sorting means, 
but using an amount cut-off is not one of them.

But you can run a Find on a particular register (or from the CoA tab for all 
accounts) and then use multiple criteria to narrow down your search. (no need 
to run multiple searches) One of those can be ‘value’ is either debit/credit or 
both.

You can then run a ‘register report’ on the Find results tab.

Regards,
Adrien

> On Nov 1, 2019 w44d305, at 1:12 PM, Gareth Davies via gnucash-user 
>  wrote:
> 
> Hi all,
> 
> I have been reading these emails with interest, but I was wondering if I
> could apply a filter in the transactions to only show those people who have
> paid Membership Fees above a certain amount i.e £100
> 
> Cheers,
> Gareth

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Gareth,
I'm not sure you can use the Transaction Report to search an account... say the 
checking account... for a value greater than X.
I also don't see a way using the Customer Report.
But, you can just bring up the register... say the checking account register... 
and search (Ctl-F) the Description, Notes, and Memo fields for whatever... like 
find all transactions in checking to or from GoDaddy...
Then, press Ctl-F again but this time, instead of searching for something in 
the Description, Notes, or Memo fields search for Value... then you can set 
that search to return transactions greater than... your magic number.
So maybe if your Paid Members were in Sales... I guess there might be two 
cases...
Sales from Paid Members and Sales from whatever else.
If some keyword were in the Paid Member transaction... like "membership dues" 
than you could search the Sales Register for that then do your search of those 
results for the Value greater than X.
I'm sure there may be a better way but maybe this will give you an idea of 
something to try.
Good Luck,
Fran3

On Friday, November 1, 2019, 2:13:26 PM EDT, Gareth Davies via gnucash-user 
 wrote:  
 
 Hi all,

I have been reading these emails with interest, but I was wondering if I
could apply a filter in the transactions to only show those people who have
paid Membership Fees above a certain amount i.e £100

Cheers,
Gareth


-Original Message-
From: gnucash-user
 On Behalf Of
Michael or Penny Novack
Sent: 01 November 2019 13:28
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to
print out ?

On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote:
> I think I know the answer to this but I wanted to double check.
> .
> 2 - Is there any way to add a comment to the report before you print it...
other than making the title long?
> 3 - Can you include HTML tags like  and  to have a report's
first line bold and 2nd line small for additional comments?
> Thanks,
> Fran3

This is a perfect example (even though minimal changes compared to what I am
usually doing)

Why ask for/expect this capability from WITHIN the accounting software? 
These are the sort of changes you might want/need for the finished product
(the report as will be presented) but have nothing to do with the accounting
data.

Export the report, bring it into a document under control of your favorite
editor, then add the details like notes, change font or size of certain
parts, selective bolding or italics, etc.

COULD the developers add (to within the accounting package) the capabilities
of an editor? Perhaps. But WHY do that when plenty of perfectly good editing
apps already exist.

Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Adrien,
I tried to  check out style sheets and have a couple of questions...
1 - Under Edit > Style Sheets
I clicked on Easy > Edit
And expected to be able to either add a field or edit the name of a field... 
like change the name of Prepared By to something like Comments or Notes...
But I couldn't see how to do it... so then I tried to create a new Style Sheet 
using Easy as a template...
Again expecting to be able to add a field or two but no joy.
Of course I can do this as Michael suggest and just export and modify in 
another program... and I'm not suggesting any modifications to GC, I'm just 
trying to make sure I didn't miss anything when exploring Editing or creating a 
New Style Sheet.
2 - Finally, when I created a Transaction Report and choose Easy as the Style 
Sheet I expected to see the "Prepared by" field under the report name field... 
but it wasn't there.
I guess I'm completely missing something here.

BTW, Win7 Pro and GC 3.7.
Thanks for the help.
Fran3

On Friday, November 1, 2019, 9:48:28 AM EDT, Adrien Monteleone 
 wrote:  
 
 But the abilities *have* been added via stylesheets. (as noted)


Regards,
Adrien

> On Nov 1, 2019 w44d305, at 8:28 AM, Michael or Penny Novack 
>  wrote:
> 
> On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote:
>> I think I know the answer to this but I wanted to double check.
>> .
>> 2 - Is there any way to add a comment to the report before you print it... 
>> other than making the title long?
>> 3 - Can you include HTML tags like  and  to have a report's first 
>> line bold and 2nd line small for additional comments?
>> Thanks,
>> Fran3
> 
> This is a perfect example (even though minimal changes compared to what I am 
> usually doing)
> 
> Why ask for/expect this capability from WITHIN the accounting software? These 
> are the sort of changes you might want/need for the finished product (the 
> report as will be presented) but have nothing to do with the accounting data.
> 
> Export the report, bring it into a document under control of your favorite 
> editor, then add the details like notes, change font or size of certain 
> parts, selective bolding or italics, etc.
> 
> COULD the developers add (to within the accounting package) the capabilities 
> of an editor? Perhaps. But WHY do that when plenty of perfectly good editing 
> apps already exist.
> 
> Michael D Novack

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Michael, no request for added features to GC was intended. I was just 
exploring the existing capabilities of the program.

 Having been involved in product development I have experienced countless 
meetings, discussions and passionate exchanges about nailing down product 
design spec's and later product update priorities and considerations.
As I have been immersed in using GC extensively for the last few weeks I have 
learned a lot about it and its capabilities and all of that has only 
contributed to my admiration of the product, the development team, and their 
efforts.
But, none of that negates continuing to explore and dig for features that may 
be in the system... but not obvious to a user who is up against the clock 
spending day and night trying to get a job done.
Hopefully that clears up my intent and any unintended interpretations of my 
original post in this thread.
Finally I want to compliment the great help and those who provide it here on 
this list.
I do have a couple of follow-up questions on the topic but I'll put those in a 
separate post.

Best,Fran3

On Friday, November 1, 2019, 9:28:43 AM EDT, Michael or Penny Novack 
 wrote:  
 
 On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote:
> I think I know the answer to this but I wanted to double check.
> .
> 2 - Is there any way to add a comment to the report before you print it... 
> other than making the title long?
> 3 - Can you include HTML tags like  and  to have a report's first 
> line bold and 2nd line small for additional comments?
> Thanks,
> Fran3

This is a perfect example (even though minimal changes compared to what 
I am usually doing)

Why ask for/expect this capability from WITHIN the accounting software? 
These are the sort of changes you might want/need for the finished 
product (the report as will be presented) but have nothing to do with 
the accounting data.

Export the report, bring it into a document under control of your 
favorite editor, then add the details like notes, change font or size of 
certain parts, selective bolding or italics, etc.

COULD the developers add (to within the accounting package) the 
capabilities of an editor? Perhaps. But WHY do that when plenty of 
perfectly good editing apps already exist.

Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Thanks Adrien, I'll give that a go.
FYI, this HTML for the Transaction Report "Report Name" seem to work but then 
it creates a long name and clutter when finding and opening a saved report.
Transaction Report: HTML Demo2nd line 
normal text demo
Again, I'll be switching to "the right way to do it" based on your answer.
Thanks,
Fran3

On Friday, November 1, 2019, 8:56:34 AM EDT, Adrien Monteleone 
 wrote:  
 
 

> On Nov 1, 2019 w44d305, at 7:46 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> I think I know the answer to this but I wanted to double check.
> 1 - Can I print a Transaction Report and exclude the line items and only show 
> the total(s) ?

Options > Sorting > Show Subtotals Only (hide transactional data) - this is the 
last option on that tab.

> 2 - Is there any way to add a comment to the report before you print it... 
> other than making the title long?

Use the ‘Head or Tail’ stylesheet which you’ll need to customize in Edit > 
Stylesheets.

You’ll get several new fields (including preparer, prepared for, and comments) 
and you can place them at the bottom if you don’t like them up top.

> 3 - Can you include HTML tags like  and  to have a report's first 
> line bold and 2nd line small for additional comments?

Not without hacking the report, but you can maybe adjust what you need via 
editing the style sheet from within GnuCash. (like above) You can specify 
colors, fonts and sizes. Simply assign a bold font to the particular element 
you want. Note, it might take some trial and error to figure out which settings 
affect which elements in the report. Not all reports will have all elements. 
(like when you hide transactional data)

You can also achieve all of this by exporting or copy/pasting a report to a 
spreadsheet app like LibreOffice and manipulating from there.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

I think I know the answer to this but I wanted to double check.
1 - Can I print a Transaction Report and exclude the line items and only show 
the total(s) ?
2 - Is there any way to add a comment to the report before you print it... 
other than making the title long?
3 - Can you include HTML tags like  and  to have a report's first 
line bold and 2nd line small for additional comments?
Thanks,
Fran3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved Reports Disappearing

[Fran_3 via gnucash-user]

 Ah Ha ! Got it. Found it (saved-reports-2.8) on Win7 Pro machine in...
C:\Users\UserX\AppData\Roaming\GnuCash\
Filename = saved-reports-2.8
Made a copy and was able to open with NotePad++ and I can see the way the 
report options are saved.
Regarding having that file automatically sync'd to the cloud... I'm not sure 
how to do that using the cloud/sync system I'm using.
I guess I could gin up a little code that would, when used to launch gnuCash, 
would go to the appropriate sync'd folder and get the saved-reports-2.8 file 
and put it in the proper AppData folder for gnuCash to use... then upon exit 
copy the saved-reports-2.8 file back over to the sync'd.

No time for that at the moment so I'll just trudge along for now as deadlines 
are killin' me :-)
Thanks again for the help folks.
Fran3


On Thursday, October 31, 2019, 10:00:04 AM EDT, Geert Janssens 
 wrote:  
 
 Op donderdag 31 oktober 2019 13:57:56 CET schreef Fran_3 via gnucash-user:
> Original Question 4 - Is there anyway to set where the Transaction Report
> Configurations are saved? My conclusion: I'm giving up on this but for
> reference here is the issue for consideration...
> 
> My GC entity files are saved on my local disk and auto sync'd to the cloud
> so I can work on them at home or at work.
> 
> Problem is if I create and save a Report Configuration at home it is not
> available at work because the saved report config files are buried in with
> the installed program files... and I do not want to sync installed programs
> to the cloud. It would be nice if the report config files were saved in the
> same folder with mybooks.gnucash so they could be backed up to the cloud
> along with the mybooks.gnucash file.

That's not quite right. The save report configurations are not stored with the 
installed program files, they are stored in your home directory, but in a path 
you typically don't go directly as a user. For that exact path, check the link 
David Cousens provided earlier.

There is no harm in synching this saved-reports file to your work PC. Your 
sync tool may or may not support synching arbirtrary files though.

Other than that, your use case is exactly why we are considering to store the 
report configurations directly in mybooks.gnucash at some point in the future.

Regards,

Geert


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved Reports Disappearing

[Fran_3 via gnucash-user]

 Thanks to all for replying to my post.
I should have noted that I'm running GC 3.7 on a Win7 Pro machine.
Original Question 1 - I began saving recent report configurations with a dash 
like in order to distinguish them from other reports...But, some of them 
disappear later on when I attempt to re-open them...
Any ideas on what is going on?

My conclusion: This should have read... I'm saving some report configurations 
using a dash and a space at the beginning of the report name. I'm discontinuing 
that practice as some of those reports seem to just disappear. (Hopefully I 
have not corrupted my report file.)
Original Question 2 - Where are the Saved Transaction Report Configurations 
saved?

My conclusion: I will take a look at the link posted by David C. But I'm 
thinking I will just leave this be as is and not try to tinker with it.
Original Question 3 - Is there a limit on how many Saved Transaction Report 
Configurations you can have?

My conclusion: I have about 30 or 31 reports saved and understand that should 
not be a problem. I'm thinking putting a dash followed by a space at the 
beginning of the saved report configuration file name may have contributed to 
the cause of my disappearing saved report config's. From here forward I'll 
begin each saved report config filename with a letter or a number and see if 
the disappearing report config file problem continues.

Original Question 4 - Is there anyway to set where the Transaction Report 
Configurations are saved?
My conclusion: I'm giving up on this but for reference here is the issue for 
consideration... 

My GC entity files are saved on my local disk and auto sync'd to the cloud so I 
can work on them at home or at work. 

Problem is if I create and save a Report Configuration at home it is not 
available at work because the saved report config files are buried in with the 
installed program files... and I do not want to sync installed programs to the 
cloud. It would be nice if the report config files were saved in the same 
folder with mybooks.gnucash so they could be backed up to the cloud along with 
the mybooks.gnucash file.
Original Question 5 - Can you have each "entity" save reports in different 
folders?
My conclusion: I'll use a naming convention to distinguish between which saved 
report config's go with which entity.

Thanks again to all for their comments and suggestions.
Fran3

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Bill Date Confusion

[Fran_3 via gnucash-user]

On a bill from a vendor I would typically find...
A - Bill Date
B - Due Date
Looking at a bill formerly entered into gnuCash I see 3 dates...

C - Date Opened
D - Date Posted
E - Date
There has been some confusion on which dates on the gnuCash (C, D, E) bill 
would match up with A & B.
I'm thinking when looking at a formerly entered bill...

C - Date Opened = the date we happen to enter the bill into GnuCash
D - Date Posted = "Bill Date" on the vendors bill to us ("A" above)

E - Date = Date item was purchased from the vendor when billed monthly for 
multiple purchases (else 1st of prior month to indicate the item was purchased 
last month)

Thanks for any help.
PS - Note that the "Due Date" does not show on the gnuCash Bill but does appear 
on the Vendor Report (along with "D" above which is referred to as  "Date 
Posted" on the formerly posted bill and as simply "Date" on the Vendor Report)











___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to create Expense Report to Business from Personal Acct?

[Fran_3 via gnucash-user]

 Thank you David. Perfect answer.
Fran3

On Sunday, October 20, 2019, 11:45:00 PM EDT, David Cousens 
 wrote:  
 
 In the personal accounts if you have expended money on items for the business
it creates a Liability for the business  and in your personal accounts by
expending money from your bank you are creating an asset.  You would record
a purchase as follows

Personal


Asset:PersonalBankAccount      Cr  xxx
Asset:Reimbursable                Dr  xxx

in the Business account, the purchase would appear as

Liability:Reimbursements        Cr xxx
Expenses:...                          Dr xxx

When you transfer money from your business bank account to your personal
bank account to 
reimburse yourself  in the Buisness accounts it appears as

Asset: BusinessBankAccount            Cr xxx
Liability:Reimbursements                Dr xxx  


and in your personal accounts

Asset:PersonalBankAccount          Db  xxx
Asset:Reimbursable                    Cr  xxx

You would put notes in the description and/or memo  section in each  to make
it clear that it was a purchase of an item for the business from your
personal account in the first case and reimbursement of that in the second
to keep the tax man happy. (The reverse if you expend business funds on a
personal item.)

David Cousens  






-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to create Expense Report to Business from Personal Acct?

[Fran_3 via gnucash-user]

Given two gnuCash files.. Personal.gnuCash andBusiness.gnuCash
Questions:
1 - When I buy items for the business and pay for them using personal funds... 
How do I create an "Expense Report" in Personal.gnuCash so that I can get 
reimbursed?
I considered setting up the business as a customer in Personal.gnuCash so that 
I could invoice the business to get reimbursed... but I'm not sure that is the 
best way to do it... or is it?
2 - How do I handle this on the business side in Business.gnuCash?
In Business.gnuCash I considered creating a vendor named Personal Expense 
Account
 and then creating an itemized Bill so that each purchased item could be 
charged to the proper Expense Category... is there a better way?
Thanks for any help.






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to Export Search Results to CSV file?

[Fran_3 via gnucash-user]

When I run a search on checking and get the results listed in a new gnuCash Tab 
named "Search Results"
How can I export those Search Results to a CSV file?
When I click on File > Export
I am unsure if any of the four options listed will do it.
Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Applying Pre-Payments to a Bill

[Fran_3 via gnucash-user]

 Thanks Adrien.
I'm running the latest version of gnuCash Version: 3.7Build ID: 
3.7+(2019-09-07)on Windows 10.
In this case the PrePayments were left to accumulate until they were great 
enough to cover an entire Monthly Bill.
Did not fill out the 'refund' portion of the payment window.
I'll run some experiments tomorrow and try to post back.
Thanks again for the help.
Fran3



On Tuesday, October 15, 2019, 8:24:13 PM EDT, Adrien Monteleone 
 wrote:  
 
 Yes, it should work that way and has for me in the past. I don’t know if 
something recently has changed.

What version of GnuCash and what OS are you using?

You could have also applied the pre-payments each month, which would have 
resulted in one larger pre-payment to apply rather than several little ones. It 
should still work out either way.

Did you accidentally fill out the ‘refund’ portion of the payment window the 
last time? If that is the case, then GnuCash thinks you got that $2 back in 
change, so it no longer sits there as a pre-payment.

You can right-click and choose ‘Edit Payment’ to examine/fix this. The splits 
in that payment transaction would also reflect a $2 debit back to cash/checking 
accordingly which should be a tip-off.

As for formatting e-mail, just hit enter/return. I’ve separated my lines here 
by hitting it twice.

Maybe your mail client is stripping out line endings so your sent copies may 
not look right to you. Don’t worry about line length, that is determined by the 
viewing client.

You might also prefer switching to viewing and/or composing in plain text. Of 
course, you’ll have to get more creative for emphasis since bold, italic, and 
underline would no longer be available. (I opt to view in plain text anyway - 
so that is usually stripped out, thus sending in html doesn’t matter)

Regards,
Adrien

> On Oct 15, 2019 w42d288, at 7:15 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> For Vendor X the Monthly Bill is $10.00-
> But the Monthly Payment has been $13.00-
> After 5 months of Bills and 4 months of Payments we go to pay the $10 Bill #5 
> and see four PrePayments listed at $3.00 each-We click Bill #5 and Control 
> Click the four PrePayments in order to apply the $12 worth of PrePayments to 
> Bill #5.-Now Clicking Business > Vendor > Find Bill for Vendor X we see all 
> five Bills marked as Paid.-Now we get the next months Bill and Post it and go 
> to Pay it... expecting to see the $2.00 un-applied remainder of the 
> PrePayments listed...-But the $2.00 un-applied PrePayment remainder does not 
> appear as available...-So, how do we apply the $2.00 PrePayment remainder to 
> the $10.00 Bill number 6?-I would think any "remainder" of applied 
> PrePayments would still appear as a PrePayment when you go to pay a 
> Bill.-Thanks for any help.-PS - Pardon all the dashes on blank lines but I'm 
> trying to find out how to force line breaks so formatting can be retained. (I 
> wonder if the html line break tag would work?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Applying Pre-Payments to a Bill

[Fran_3 via gnucash-user]

For Vendor X the Monthly Bill is $10.00-
But the Monthly Payment has been $13.00-
After 5 months of Bills and 4 months of Payments we go to pay the $10 Bill #5 
and see four PrePayments listed at $3.00 each-We click Bill #5 and Control 
Click the four PrePayments in order to apply the $12 worth of PrePayments to 
Bill #5.-Now Clicking Business > Vendor > Find Bill for Vendor X we see all 
five Bills marked as Paid.-Now we get the next months Bill and Post it and go 
to Pay it... expecting to see the $2.00 un-applied remainder of the PrePayments 
listed...-But the $2.00 un-applied PrePayment remainder does not appear as 
available...-So, how do we apply the $2.00 PrePayment remainder to the $10.00 
Bill number 6?-I would think any "remainder" of applied PrePayments would still 
appear as a PrePayment when you go to pay a Bill.-Thanks for any help.-PS - 
Pardon all the dashes on blank lines but I'm trying to find out how to force 
line breaks so formatting can be retained. (I wonder if the html line break tag 
would work?




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Understanding Transaction Report options

[Fran_3 via gnucash-user]

 OK, I'll take a shot  at this since I've been using  the  Transaction Report a 
lot  over the last two weeks.
If you run a Transaction Report on Checking and select...

 Filter Type: Transactions To/From Filter Accounts...
Filter By: Expenses > Utilities
Then Click Apply...

then gnuCash will show you all transactions that hit the checking account that 
were charged to the Utilities Expense Account
ALSO... If you want more than one account you can Ctl Click to add accounts...
For instance if you want the Transaction Report to include both Checking and 
Savings then you can Click Checking and Ctl Click Savings in "Accounts" section 
at the top sections of the Accounts Tab in the Options popup window.
And, you can also add additional "Filter By: accounts in the same way... for 
example you can "Filter By"...
 Expenses > Insurance > Health Insurance
 and then Ctl  Click Medical Expenses and then Apply
Then the Transaction Report will show you what hit your Checking and Savings 
Accounts that were charged to either Health Insurance or Medical Insurance.
I suggest you copy your gnuCash file and rename the copy test.gnucash and then 
open that and do some experiments... shouldn't take long to get the general 
idea.
Regarding Regular Expressions... That is a really complicated way to search 
used mainly by programmers and I would suggest you avoid it unless you 
really... really need a special type of search. If so there are plenty of 
YouTube Tutorials on how to search using Regular Expressions.
Didn't cover all your questions but this should get you started.
 And finally, I must say, the Transaction Report is a great feature of 
gnuCash... so thanks to the development team for that!
Hope this helps.


On Saturday, October 12, 2019, 11:37:33 AM EDT, orn...@tutanota.com 
 wrote:  
 
 
I’m having some trouble understanding the meaning of the Accounts and Filter 
tabs options and I find the Help and the Tutorial and Concepts Guide needs a 
bit more explanation.

1. Account tab:  What does the “Include transactions to/from Filter Accounts” 
(and “Exclude”) mean? The documentation uses those same words to describe their 
function.

2. Account tab:  I understand the Account tree selection under “Accounts” (top 
block), but what is the account tree under “Filter By” used for? How can you 
“filter by” something you’ve already chosen?

3. Filter tab: How is the “Account Name Filter” used? Am I to change it each 
time for a selection or is this invoking a previously-named “Account Name 
Filter?”

4. Filter tab: The “Transaction Filter” appears to be used to specify the words 
I want to report and link them to the specific transaction in which they 
appear, but sometimes the Transaction Report indicates “No transactions were 
found,” so perhaps I’m mistaken.

5. Filter tab: When would I select “Use regular expressions for transaction 
filter?”

6. Filter tab: What is POSIX and how and why should I invoke it?

7. Filter tab: How can I invoke a boolean “OR” to report either of two or more 
transaction filters? (in this case I want to report a transaction that has 
either one person’s name or another in the Description.)

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to find Bill that a Payment was applied to?

[Fran_3 via gnucash-user]

I've got a strange case here.
Assets: Current Assets: Checking Account shows a 12/10/18 Payment to Vendor 
XThe Split shows- Liabilities: Accounts Payable- Assets: Current Assets: 
Checking Account
The 12/10/18 Payment also shows in Accounts Payable with the same Split
But when I run a Vendor Report on Vendor X the 12/10/18 Payment does not show.
The Bill shows posted on 12/3/18 in the Vendor Report but when I View Bill it 
shows unpaid.
So I'm guessing I must have two Vendor X accounts and applied the 12/10/18 
payment to the wrong one BUT when I look at Business > Vendor > Vendors 
Overview only one Vendor X is listed.
The Question: How can I find which Bill the 12/10/18 Payment was applied to?
Thanks for any help.
PS
a - I searched everywhere for a 2nd account named Vendor X but can not find it 
anywhere except in the List of Vendors
b  - I'm running v3.7 on Windows 10


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Print Report does not "page" properly

[Fran_3 via gnucash-user]

 Adrien,
Great suggestion!I copied and pasted the 5 page Transaction Report into a 
Google Sheet and it appears to work perfectly.I did loos the bold headings but 
that will be easy to fix.Thanks for the help.

On Monday, October 7, 2019, 5:04:31 PM EDT, Adrien Monteleone 
 wrote:  
 
 I seem to recall this issue in previous threads, perhaps a list search might 
turn up something. There may also be a bug report.

If memory serves, this is a problem with webkit which renders the page, and 
which version of webkit has to be included with GnuCash.

The only work around I can think of right off is to instead copy/paste or 
save/open into a spreadsheet app like LibreOffice Calc and handle printing 
there.

Regards,
Adrien

> On Oct 7, 2019 w41d280, at 3:53 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I have the preferences set to Landscape and the margins set to .5 inches on 
> all 4-sides.
> When I print it does not always "form-feed" at the end of a line... 
> meaning half a line will be at the bottom of one page...and the other half at 
> the top of the next page.
> What is the best way to fix this?
> Thanks for any help.
> PS - I guess I could experiment around with different top and bottom margins 
> hoping to get the reports to print properly but that seems like a brute force 
> approach. Hopefully there is a more elegant approach that I am missing. 
> Thanks again.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Print Report does not "page" properly

[Fran_3 via gnucash-user]

I have the preferences set to Landscape and the margins set to .5 inches on all 
4-sides.
When I print it does not always "form-feed" at the end of a line... 
meaning half a line will be at the bottom of one page...and the other half at 
the top of the next page.
What is the best way to fix this?
Thanks for any help.
PS - I guess I could experiment around with different top and bottom margins 
hoping to get the reports to print properly but that seems like a brute force 
approach. Hopefully there is a more elegant approach that I am missing. Thanks 
again.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to see which Bill a Payment was applied to?

[Fran_3 via gnucash-user]

For a particular vendor... is there an easy way to see which payment was 
applied to which bill?
Thank for any help.
PS - I have been able to look at the AP ledger, find a particular  payment, 
right click, and then click "edit payment" but instead of hunting up every 
individual payment I was hoping there was a way to see all bills and associated 
payments for a particular vendor.





.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to merge 2 vendors?

[Fran_3 via gnucash-user]

 Derek, OK, That did it! Thanks.


 Hi,

On Sat, October 5, 2019 9:38 am, Fran_3 via gnucash-user wrote:
> Apologize for re-posting this but I decided my earlier question was not
> clear.-
> The Question: How to merge 2 vendors... merge VenB into VenA...
> -
> Explanation: Actually they are the same vendor but appear twice in
> Business > Vendor > Vendor > Vendors Overview-
> So we inadvertent created two accounts for the same vendor and posted
> bills and payments to both.-Is there an easy way in GC to "merge" them
> into one vendor account? Like merge VenB into VenA...
> -Hopefully this question is articulated more clearly.-Thanks for any help

I'm sorry, but no, there is currently no easy way to merge them.
Assuming you want to merge VenB into VenA, the only way to do it is to
manually go through every VenB invoice, unpost it, reaasign the VenA, and
then re-post.  Then you'll also have to repost all payments to VenB.

There is no shortcut or automated way to do this.

Sorry,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
      Derek Atkins                617-623-3745
      de...@ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to merge 2 vendors?

[Fran_3 via gnucash-user]

Apologize for re-posting this but I decided my earlier question was not clear.-
The Question: How to merge 2 vendors... merge VenB into VenA...
-
Explanation: Actually they are the same vendor but appear twice in Business > 
Vendor > Vendor > Vendors Overview-
So we inadvertent created two accounts for the same vendor and posted bills and 
payments to both.-Is there an easy way in GC to "merge" them into one vendor 
account? Like merge VenB into VenA...
-Hopefully this question is articulated more clearly.-Thanks for any help



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How2fix Vendor listed twice - need2merge transactions

[Fran_3 via gnucash-user]

Somehow we ended creating a duplicate vendor account.
Vendor A acct-1Vendor A acct-2
Most bills & payments are posted to Vendor A acct-1So I want to "move" the two 
bills and two payments posted to Vendor A acct-1 to Vendor A acct-2
I guess I could just delete the transactions from Vendor A acct-2 and post them 
from scratch into Vendor A acct-1 but I thought there may be a better way.
I did try to un-post one of the bills hoping I could change the account there 
but that doesn't seem to work.
Thanks for any help.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Message "There is no disk in the drive"

[Fran_3 via gnucash-user]

Running the latest gnuCash on Windows 7 Pro machine.
When I click Edit > PreferencesorWhen I have a Transaction Report up and 
attempt to export it as a PDFI get...
There is no disk in the drive. Please insert a disk into drive
\Device\Harddisk8\DR8
\Device\Harddisk8\DR9
\Device\Harddisk8\DR-10
\Device\Harddisk8\DR11
\Device\Harddisk8\DR-10
\Device\Harddisk8\DR-11
\Device\Harddisk8\DR9
\Device\Harddisk8\DR10
\Device\Harddisk8\DR11
\Device\Harddisk8\DR9
\Device\Harddisk8\DR-10
\Device\Harddisk8\DR11
\Device\Harddisk8\DR9
\Device\Harddisk8\DR-10
\Device\Harddisk8\DR9
\Device\Harddisk8\DR8
\Device\Harddisk8\DR8
\Device\Harddisk8\DR8

etc for 21 times before I can proceed.
Short of grinding through all the Google results... can some kind soul direct 
me to the proper way to fix this... as it's driving me nuts!
Thanks for any help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Confused on: Business > Receivable Aging > To Date

[Fran_3 via gnucash-user]

Looking at Reports > Business > Customer Report
I see a customer had 3 invoices in December of 2018.
Date: 11/13/18 
Due Date 11/13/18Amount: $360.00
Date: 11/13/18 
Due Date 12/15/18Amount: $765.00
Date: 12/28/18
Due Date 1/28/18
Amount: $855.00
And one payment in December of 2018
Date: 12/19/18PaymentAmount: $360.00
Total Dec 2018 Invoices - Total Dec 2018 Payments = $1,620.00
BUT, when I run 
Reports > Business > Receivable Agingand set the "To" Date to either 12/31/18 
or 1/1/19
Neither the customer nor the $1,620.00 the owe us appears.
I've experimented with other "To" dates for the Receivable Aging Report but 
nothing seems to pickup the unpaid amount from the customer.
I guess I don't understand the Aging Report and/or the "To" field so please 
tell me the error of my ways.
Thanks.







___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to run report on Paid Sales for a period? (Cash Accounting Method)

[Fran_3 via gnucash-user]

 What is the proceedure to update gnuCash?a - uninstall oldb - install new
or what?
and, will the old v2.6.19 gnucash files still work properly?
Thanks

On Tuesday, October 1, 2019, 1:57:50 PM EDT, Adrien Monteleone 
 wrote:  
 
 I’m not seeing anything like that. However, I’m on 3.7. There was a 
significant update to the transaction report since 2.6.x.

Regards,
Adrien

> On Oct 1, 2019 w40d274, at 11:46 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> OK, here is the  problem I see when I run a Transaction Report originating 
> from the Accounts Receivable Account and filtered to the Checking Account...
> I see, for example...
> 
> Line 1:
> Account = Assets:Accounts ReceivableTransfer from/to = Assets:Current 
> Assets:Checking AccountAmount = $(80.00)
> 
> Line 2:Account = Assets: Accounts ReceivableTransfer from/to = 
> Income:SalesAmount = $80.00
> Line 2 shouldn't be there if the report is being filtered first by A/R and 
> then by the Checking Account... right?
> With Line 2 there the paid sale gets eliminated from the total "paid" sales 
> for the period.
> Any suggestions?
> Thanks for the help.
> 
> fyi, I'm running gnuCash v2.6.19... 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to run report on Paid Sales for a period? (Cash Accounting Method)

[Fran_3 via gnucash-user]

 OK, here is the  problem I see when I run a Transaction Report originating 
from the Accounts Receivable Account and filtered to the Checking Account...
I see, for example...

Line 1:
Account = Assets:Accounts ReceivableTransfer from/to = Assets:Current 
Assets:Checking AccountAmount = $(80.00)

Line 2:Account = Assets: Accounts ReceivableTransfer from/to = 
Income:SalesAmount = $80.00
Line 2 shouldn't be there if the report is being filtered first by A/R and then 
by the Checking Account... right?
With Line 2 there the paid sale gets eliminated from the total "paid" sales for 
the period.
Any suggestions?
Thanks for the help.

fyi, I'm running gnuCash v2.6.19... 



On Tuesday, October 1, 2019, 11:25:29 AM EDT, Christopher Lam 
 wrote:  
 
 Try transaction report, originating from a/receivable account, filtered to 
bank account only. Business reports typically prefer to use invoice posted 
dates rather than payment dates.
On Tue, 1 Oct 2019, 23:17 Fran_3 via gnucash-user,  
wrote:

Sorry for the flurry of questions but I should be done with project in a few 
days.
When I run.. Reports > Income & Expenses > Income Statementfor a given period 
and then selectOptions > Accounts > Sales > ApplyI get total "Sales" for that 
period weather they are paid or not.
I need to know how much money was actually collected from sales during that 
period as our small business is accounted for on a "Cash" basis as apposed to 
an "Accrual" basis.
How can I do this?
Thanks for any help.
PS - I considered this process...
- running the Income Statement for the period (last year)- this gives me Total 
Sales for Last Year no matter weather paid or unpaid... right?
- then runningReports > Business > Receivable Aging > Options > End of Last 
Year- that should give me how much money was owed us and unpaid at the End of 
Last Year- I would then rerun the Receivable Aging Report usingOptions > End of 
year before Last Year- Now if I subtract Receivables at the end of Last Year 
from Receivables at the end the year before that I will get the amount owed us 
and not paid for Last Years sales... right?
- Then I could subtract that from last years sales to get total paid sales last 
yearor is their a more simple way to do this?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to list/view a chronological journal of all transactions? (general journal)

[Fran_3 via gnucash-user]

 Thanks John, that seems to be it.

On Tuesday, October 1, 2019, 11:17:21 AM EDT, John Ralls 
 wrote:  
 
 

> On Oct 1, 2019, at 6:16 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> Is there anyway in gnuCash to create a report that list all transactions in 
> chronological order... aka "general journal" or "book of original entry"
> Thanks for any help.

How about Reports>Assets & Liabilities>General Journal?

Regards,
John Ralls
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to run report on Paid Sales for a period? (Cash Accounting Method)

[Fran_3 via gnucash-user]

Sorry for the flurry of questions but I should be done with project in a few 
days.
When I run.. Reports > Income & Expenses > Income Statementfor a given period 
and then selectOptions > Accounts > Sales > ApplyI get total "Sales" for that 
period weather they are paid or not.
I need to know how much money was actually collected from sales during that 
period as our small business is accounted for on a "Cash" basis as apposed to 
an "Accrual" basis.
How can I do this?
Thanks for any help.
PS - I considered this process...
- running the Income Statement for the period (last year)- this gives me Total 
Sales for Last Year no matter weather paid or unpaid... right?
- then runningReports > Business > Receivable Aging > Options > End of Last 
Year- that should give me how much money was owed us and unpaid at the End of 
Last Year- I would then rerun the Receivable Aging Report usingOptions > End of 
year before Last Year- Now if I subtract Receivables at the end of Last Year 
from Receivables at the end the year before that I will get the amount owed us 
and not paid for Last Years sales... right?
- Then I could subtract that from last years sales to get total paid sales last 
yearor is their a more simple way to do this?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to list/view a chronological journal of all transactions? (general journal)

[Fran_3 via gnucash-user]

Is there anyway in gnuCash to create a report that list all transactions in 
chronological order... aka "general journal" or "book of original entry"
Thanks for any help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

[Fran_3 via gnucash-user]

 I'll do that. Thanks.

On Monday, September 30, 2019, 12:09:14 PM EDT, Adrien Monteleone 
 wrote:  
 
 In the meantime, you can use the Notes field of the payment to indicate which 
invoices the payment applied to. This will display on the Customer Report in 
the Description column.

Regards,
Adrien

> On Sep 30, 2019 w40d273, at 10:12 AM, Christopher Lam 
>  wrote:
> 
> There's currently no easy mechanism to marry up the links from
> invoice->partial payments, and payment->multiple invoices. We hope to
> complete an upgrade to the customer report but this will need much testing
> before it's ready.
> 
> You are very welcome to help beta test...
> https://user-images.githubusercontent.com/1975870/60812797-d7823a80-a181-11e9-8cc2-b2f1e53145d1.png
> 
> On Mon, 30 Sep 2019 at 15:01, Fran_3 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Got it. Thanks. But...
>> ... when I setup a test customer account... then created two invoices
>> inv-01 and inv-02
>> ... then applied a partial payment to the inv-01.. then ran the
>> customer report... I see each the two invoices and the payment but..
>> How can I tell the payment was applied to inv-01 ?
>> In other words... in the event of many invoices and payments and/or
>> partial payments... how can you determine which invoice the payment was
>> applied too?
>> Thanks for the help.
>> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

[Fran_3 via gnucash-user]

 Got it. Thanks. But... 
... when I setup a test customer account... then created two invoices inv-01 
and inv-02
... then applied a partial payment to the inv-01.. then ran the customer 
report... I see each the two invoices and the payment but.. How can I tell 
the payment was applied to inv-01 ?
In other words... in the 

On Sunday, September 29, 2019, 6:56:43 PM EDT, David Cousens 
 wrote:  
 
 The Transaction report  should do what you want if you select the appropriate
display options

Transaction_Report_001.png
  

gives the settings which should produce what you want. You can vary the
setting to get the deatil you need.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

[Fran_3 via gnucash-user]

 Got it. Thanks. But... 
... when I setup a test customer account... then created two invoices inv-01 
and inv-02
... then applied a partial payment to the inv-01.. then ran the customer 
report... I see each the two invoices and the payment but.. How can I tell 
the payment was applied to inv-01 ?
In other words... in the event of many invoices and payments and/or partial 
payments... how can you determine which invoice the payment was applied too?
Thanks for the help.


On Monday, September 30, 2019, 9:16:27 AM EDT, Derek Atkins 
 wrote:  
 
 Hi,

On Mon, September 30, 2019 8:58 am, Fran_3 via gnucash-user wrote:
>  That helped but how can I run a transaction report for a single
> customer... in order to see all postings relative to that customer?
> Thanks.

Nope, just run a Customer Report and it will show you all invoices and
payments for that customer.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
      Derek Atkins                617-623-3745
      de...@ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

[Fran_3 via gnucash-user]

 That helped but how can I run a transaction report for a single customer... in 
order to see all postings relative to that customer?
Thanks.

On Sunday, September 29, 2019, 6:56:43 PM EDT, David Cousens 
 wrote:  
 
 The Transaction report  should do what you want if you select the appropriate
display options

Transaction_Report_001.png
  

gives the settings which should produce what you want. You can vary the
setting to get the deatil you need.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to show a transactions history: 1) debit A/R, credit Sales 2) credit A/$, debit Cash

[Fran_3 via gnucash-user]

Is there a way to show a transactions history... 

Example:

Sold an item on credit for $10.00 on 1/5/19Got paid on  2/20/19
So that it shows sort of like this...
Transaction History:
1/5/19
debit Accounts Receivible $10.00
credit Sales $10.00

2/20/19
credit Accounts Receivable $10.00
debit Cash/Checking $10.00

Thanks for any help.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Scheduled Vendor Bills vs Schedule Transactions

[Fran_3 via gnucash-user]

 The Vendor Report works great so long as we manually post each vendor bill and 
then use the Business Features to Process Payment.

 I was looking for a way to automate some of that using Scheculed 
Transactions... ditto for Invoices to our Customers who are invoiced on the 
first of every month for the same amount each month.
But automatic transactions will not associate a customer or a vendor with the 
transaction... just the appropriate accounts in the chart of accounts
 like for a vendor...
Credit AP, Debit ExpensesDebit AP, Credit Checking
or for a customer...
Debit AP, Credit SalesCredit AP, Debit Checking
No worries, We can use the "duplicate" bill or invoice feature to do that and 
maybe use the Scheduled Transactions only as a reminder.
Thanks,
Fran3





On Sunday, February 25, 2018, 2:18:28 AM EST, Adrien Monteleone 
<adrien.montele...@gmail.com> wrote:  
 
 Does the Vendor Report not give you the info you’re looking for without 
involving scheduled transactions? That report shows a full history of bills and 
payments for a particular vendor over whatever time period you run the report 
for. (that is, bills and payments run through the business features or properly 
imported)

Regards,
Adrien

> On Feb 24, 2018, at 4:40 PM, Fran_3 via gnucash-user 
> <gnucash-user@gnucash.org> wrote:
> 
> It seems when you do a "scheduled transaction" there is no way to relate it 
> to a vendor... right?
> Asking because we like to be able to track how much we paid to Vendor A, 
> Vendor B, etc.
> Electric Bill for example... With a "Scheduled Transaction" you could 
> schedule...
> 1 - Credit AP and Debit Utilities Electric
> then maybe the next day
> 2 - Debit AP and Credit Checking
> But there seems no way to affiliate it to the Electric Company as would 
> happen if you Created and Posted a Vendor Bill then "Paid" the Bill.
> Right? or did I miss something?
> Thanks for the help.
> Fran
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

rested in PieCash which allows for accessing either the XML or 
> SQL formatted data file for report writing. 
> https://github.com/sdementen/piecash
> 
> This was also posted to the mailing list recently and is an example of using 
> PieCash: https://github.com/ebridges/accounting-reports
> 
> Before you get started, you’ll want to look over this: 
> https://wiki.gnucash.org/wiki/FAQ#SQL_Database, and 
> https://wiki.gnucash.org/wiki/SQL and mind the warnings never to WRITE to the 
> data file from outside of Gnucash. (at least for the foreseeable future)
> 
> Here’s the SQL table map - yes, it’s ugly: 
> https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
> 
> Unless you are comfortable with Scheme, or learning a new language, your best 
> bet is definitely to stick with the SQL/PieCash route.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 20, 2018, at 4:59 PM, Fran_3 <mailbox0...@yahoo.com> wrote:
> > 
> > Thanks Adrien,
> > 
> > Regarding custom reports... I do SQL but am having gnuCash save account 
> > files in it's default XML format.
> > 
> > Where would I get a list of the tables in gnuCash and their associated 
> > fields/columns?
> > 
> > Is there a window I can open to just put in an SQL query or what?
> > 
> > Can I create an SQL query that will query the default XML format file 
> > format?
> > 
> > (I've actually never considered using XML for a full fledged database until 
> > I just started using gnuCash and discovered that it uses XML)
> > 
> > Or do I have all of this wrong?
> > 
> > thanks again.
> > 
> > 
> > 
> > On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
> > <adrien.montele...@gmail.com> wrote:
> > 
> > 
> > You could leverage a multi-column report perhaps with a customer report in 
> > each column, that will get you invoice & payment detail, but no aggregate 
> > totals across all customers. (but each customer would have it’s own total)
> > 
> > Then there is the P/Income Statement, but it will show you revenue by 
> > type (account) not by customer. It will have a total however.
> > 
> > Finally, there is the Customer Report. The Sales column will show what you 
> > want. Though you may not need the other columns, the only one you can turn 
> > off is the expense column. I’ve yet to figure out where to put costs or 
> > markup figures for that report to make much sense. It will report a sales 
> > total per customer with a grand total.
> > 
> > If you want to see revenue by type AND customer with totals, you’ll have to 
> > make your own report either with SQL or Scheme.
> > 
> > All of these reports (as are any others in GnuCash) allow you to set either 
> > the date of the report, (such as for a Balance Sheet) or the date range the 
> > report covers. There are shortcut date selectors for month, quarter, year 
> > and ‘accounting period’ (if your fiscal year differs from the calendar) as 
> > well as boxes to let you put in any specific dates you want. You’ll find 
> > that under the General tab of any report options.
> > 
> > 
> > Regards,
> > Adrien
> > 
> > > On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
> > > <gnucash-user@gnucash.org> wrote:
> > > 
> > > I'm sure there is a way but I haven't found it yet...
> > > How do we run a report to see how much business we booked/invoiced for a 
> > > particular month?Total and/or including a list of customers and amounts?
> > > Ditto for  a specified period of time... current quarter, last quarter, 
> > > so far this year... so far this date last year... etc?
> > > Thanks for any help.
> > > Fran 3
> > 
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see 
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please 

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

 Re: Converting to MySQL...
When I develop in MySQL on Windows I install IIS localhost server and MySQL... 
but that is not practical on other office computers.
1 - I'm not familiar with sqLite but a quick Google makes me think it is a way 
to run MySQL on a local PC without running server software like IIS... right?
2 - Or is sqLite a desktop version of MySQL that requires no server?
3 - Also, it looks like PieCash is a collection of Python programs... right?
4 - And if so then you simply have to have the Python interrupter installed on 
your machine and then run the appropriate PieCash program after editing in the 
name and path to the gnuCash file... right?
Thanks again Adrien.
Fran3





On Tuesday, February 20, 2018, 9:54:08 PM EST, Adrien Monteleone 
<adrien.montele...@gmail.com> wrote:  
 
 In order to use SQL on the Gnucash data, it needs to be saved in that format. 
This requires the particular backend drivers (sqlite3, MySQL) be installed 
already for the format to be available as a choice in the Save As dialog. See 
the installation notes on the wiki for more info.

There is no built-in facility for writing queries. You’d have to access the 
datafile from something else.

You may be interested in PieCash which allows for accessing either the XML or 
SQL formatted data file for report writing. https://github.com/sdementen/piecash

This was also posted to the mailing list recently and is an example of using 
PieCash: https://github.com/ebridges/accounting-reports

Before you get started, you’ll want to look over this: 
https://wiki.gnucash.org/wiki/FAQ#SQL_Database, and 
https://wiki.gnucash.org/wiki/SQL and mind the warnings never to WRITE to the 
data file from outside of Gnucash. (at least for the foreseeable future)

Here’s the SQL table map - yes, it’s ugly: 
https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png

Unless you are comfortable with Scheme, or learning a new language, your best 
bet is definitely to stick with the SQL/PieCash route.


Regards,
Adrien

> On Feb 20, 2018, at 4:59 PM, Fran_3 <mailbox0...@yahoo.com> wrote:
> 
> Thanks Adrien,
> 
> Regarding custom reports... I do SQL but am having gnuCash save account files 
> in it's default XML format.
> 
> Where would I get a list of the tables in gnuCash and their associated 
> fields/columns?
> 
> Is there a window I can open to just put in an SQL query or what?
> 
> Can I create an SQL query that will query the default XML format file format?
> 
> (I've actually never considered using XML for a full fledged database until I 
> just started using gnuCash and discovered that it uses XML)
> 
> Or do I have all of this wrong?
> 
> thanks again.
> 
> 
> 
> On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
> <adrien.montele...@gmail.com> wrote:
> 
> 
> You could leverage a multi-column report perhaps with a customer report in 
> each column, that will get you invoice & payment detail, but no aggregate 
> totals across all customers. (but each customer would have it’s own total)
> 
> Then there is the P/Income Statement, but it will show you revenue by type 
> (account) not by customer. It will have a total however.
> 
> Finally, there is the Customer Report. The Sales column will show what you 
> want. Though you may not need the other columns, the only one you can turn 
> off is the expense column. I’ve yet to figure out where to put costs or 
> markup figures for that report to make much sense. It will report a sales 
> total per customer with a grand total.
> 
> If you want to see revenue by type AND customer with totals, you’ll have to 
> make your own report either with SQL or Scheme.
> 
> All of these reports (as are any others in GnuCash) allow you to set either 
> the date of the report, (such as for a Balance Sheet) or the date range the 
> report covers. There are shortcut date selectors for month, quarter, year and 
> ‘accounting period’ (if your fiscal year differs from the calendar) as well 
> as boxes to let you put in any specific dates you want. You’ll find that 
> under the General tab of any report options.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
> > <gnucash-user@gnucash.org> wrote:
> > 
> > I'm sure there is a way but I haven't found it yet...
> > How do we run a report to see how much business we booked/invoiced for a 
> > particular month?Total and/or including a list of customers and amounts?
> > Ditto for  a specified period of time... current quarter, last quarter, so 
> > far this year... so far this date last year... etc?
> > Thanks for any help.
> > Fran 3
> 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
&

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

 Thanks Adrien,

Regarding custom reports... I do SQL but am having gnuCash save account files 
in it's default XML format.
Where would I get a list of the tables in gnuCash and their associated 
fields/columns?
Is there a window I can open to just put in an SQL query or what?
Can I create an SQL query that will query the default XML format file format?
(I've actually never considered using XML for a full fledged database until I 
just started using gnuCash and discovered that it uses XML)
Or do I have all of this wrong?
thanks again.


On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
<adrien.montele...@gmail.com> wrote:  
 
 You could leverage a multi-column report perhaps with a customer report in 
each column, that will get you invoice & payment detail, but no aggregate 
totals across all customers. (but each customer would have it’s own total)

Then there is the P/Income Statement, but it will show you revenue by type 
(account) not by customer. It will have a total however.

Finally, there is the Customer Report. The Sales column will show what you 
want. Though you may not need the other columns, the only one you can turn off 
is the expense column. I’ve yet to figure out where to put costs or markup 
figures for that report to make much sense. It will report a sales total per 
customer with a grand total.

If you want to see revenue by type AND customer with totals, you’ll have to 
make your own report either with SQL or Scheme.

All of these reports (as are any others in GnuCash) allow you to set either the 
date of the report, (such as for a Balance Sheet) or the date range the report 
covers. There are shortcut date selectors for month, quarter, year and 
‘accounting period’ (if your fiscal year differs from the calendar) as well as 
boxes to let you put in any specific dates you want. You’ll find that under the 
General tab of any report options.


Regards,
Adrien

> On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
> <gnucash-user@gnucash.org> wrote:
> 
> I'm sure there is a way but I haven't found it yet...
> How do we run a report to see how much business we booked/invoiced for a 
> particular month?Total and/or including a list of customers and amounts?
> Ditto for  a specified period of time... current quarter, last quarter, so 
> far this year... so far this date last year... etc?
> Thanks for any help.
> Fran 3
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

I'm sure there is a way but I haven't found it yet...
How do we run a report to see how much business we booked/invoiced for a 
particular month?Total and/or including a list of customers and amounts?
Ditto for  a specified period of time... current quarter, last quarter, so far 
this year... so far this date last year... etc?
Thanks for any help.
Fran 3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

[Fran_3 via gnucash-user]

‘process payment’ window where you can 
> search for a vendor, see all of their unpaid bills, then assign the 
> transaction as a payment. (be mindful the dates, amounts, and check# are 
> correct and that it is taking the payment from the proper account)
> 
> Now, everything is imported and properly assigned just as if you had entered 
> it in real time originally from scratch.
> 
> As an added tip, when assigning payment to a transaction, I’d recommend 
> tagging that transaction with the bill number from the Vendor. (or something 
> to ID the payment for if the vendor doesn’t use invoice #s) Gnucash doesn’t 
> make it easy by default to see what bills a payment applies to. (possible, 
> just not easy) You’ll probably want to know that info from time to time when 
> looking at a register. You have two main options here. Either turn on View > 
> Double-line mode and use the Notes line for this info, or place it in the 
> Memo of the split for either the checking account credit or the AP debit, 
> whichever makes the most sense to you. (putting it in notes, also puts it in 
> the memo for the AP debit split) Now, when you run a vendor report, you’ll 
> see that bill# note in the Description column for easy reference.
> 
> Here’s a link to documentation on the CSV for importing bills/invoices: 
> https://lists.gnucash.org/docs/C/gnucash-guide/import-invoices.html
> 
> Here’s the link for customers/vendors (note the caveat about billing info): 
> https://lists.gnucash.org/docs/C/gnucash-guide/import-customers-vendors.html
> 
> If you’re coming from some other software, you might even be able to get that 
> data exported as a CSV and then do some minor surgery on the column order for 
> Gnucash to be happy rather than typing it all from scratch.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 14, 2018, at 5:59 PM, Fran_3 via gnucash-user 
> > <gnucash-user@gnucash.org> wrote:
> > 
> > OK, as I understand it after we import checking transactions for a small 
> > business...
> > For each Vendor Payment we must first create a Bill and then Pay that bill 
> > so that it remains associated with the vendor. That's a lot of clicking and 
> > typing.
> > So would this work?
> > In the chart of accounts under say... Expenses > Office Supplies
> > we create sub accounts for each Office supply vendor...
> > Than from the check register just assign that payment to that account...
> > Now we are tracking total office supply expenses and how much we spent with 
> > each vendor.
> > We are considering this for 2017 transactions as we are under a very short 
> > deadline to come up with some numbers and every step we save helps.
> > What do you think?
> > Thanks,
> > Fran3
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Creating Account for each Vendor to avoid Creating and Paying each Bill?

[Fran_3 via gnucash-user]

OK, as I understand it after we import checking transactions for a small 
business...
For each Vendor Payment we must first create a Bill and then Pay that bill so 
that it remains associated with the vendor. That's a lot of clicking and typing.
So would this work?
In the chart of accounts under say... Expenses > Office Supplies
we create sub accounts for each Office supply vendor...
Than from the check register just assign that payment to that account...
Now we are tracking total office supply expenses and how much we spent with 
each vendor.
We are considering this for 2017 transactions as we are under a very short 
deadline to come up with some numbers and every step we save helps.
What do you think?
Thanks,
Fran3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to export structure without transactions?

[Fran_3 via gnucash-user]

 We have setup a gnucash file for 2018 and created all our customer and vendor 
accounts... plus customized the chart of accounts... and entered all the 
transactions to date.
Now we want to do 2017.
Is there a way to export the structure leaving the vendors, customers, and 
customized chart of accounts in place so we can begin populating for 2017.
Thanks for any help.
Fran3

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to relate Transfer Sales to Cash to Customer?

[Fran_3 via gnucash-user]

 When a customer pays cash or by credit card there is no reason to create an 
invoice... so we click Accounts Tab -> Action -> Transfer
and transfer directly Sales to Cash
But there seems to be no way to relate this to a customer so when we run a 
Customer Report the transactions don't show up.
Is there a way to fix this short of creating an invoice first... putting it in 
Sales and A/R
And then "Process Payment" to take it out of A/R and into the Cash account?
Thanks for any help.
Fran3

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

QBO and QFX files VS QIF and OFX files ?

[Fran_3 via gnucash-user]

 Our bank offers QBO and QFX files but I see gnuCash works with QIF and OFX 
files.
Are QBO and QFX files imprtable into gnuCash?
Thanks for any help
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to pay 2-bills to 1-vendor with 1-check?

[Fran_3 via gnucash-user]

 Adrien,
Your solution worked. As a new user it did not occur to me (even though it 
should have :-) that I could select more than one bill in the Process Payment 
window.
Thanks for the help ! ! !
Fran3

On Monday, February 5, 2018, 8:40:09 PM EST, Adrien Monteleone 
 wrote:  
 
 First, I would not recommend editing in AP directly. Use the business features 
to create a vendor, then a bill for that vendor.

When you do so, paying multiple bills is as easy as choosing “Process Payment” 
in the Business > Vendor menu, entering the vendor name, selecting their bills 
you want to pay, making sure your date, check #, and proper checking account 
are selected. (you’ll still have to print this check separately, but this will 
handle the transaction)

You wouldn’t necessarily have separate AP accounts for each Vendor unless you 
wanted them. I’ve not tested doing so or if such sub accounts would work with 
the business features or if you have to keep everything lumped together in the 
special AP account that GnuCash created for you on startup. The Vendor reports 
preclude the need to do this. (you can create your own ‘statement of account’ 
with that vendor at any time for any time period)

If you really need to take the route of direct entry and not using the business 
features, then you should be able to post any transaction to any account you 
want. *Note, you might need to create a special AP account as type ‘other 
liability.’ You can move it back as a child of the special AP account if you 
like, but don’t create it as a child of that account initially, create it 
directly under Liabilities.

As for the transactions, you have the debits and credits backwards in your T 
account examples.

That would be:

Dr. Expenses > Lawn
Cr. AP ( or AP > pro Lawn Svc)

(debit is on the left, credit on the right - always)

Paying the bill you also have backwards:

Dr. AP > pro Lawn Svc
Cr. Checking

Both your T account example and the screen shot have the debits/credits 
correctly for a transaction that pays a liability.

As for your last question, using the business features will create a payment 
transaction in AP with two splits, one for each bill. Unfortunately, there is 
no way at present to ‘jump to’ or ‘view’ that bill from the AP register. You’ll 
have to look for it using the Find Bill feature, or by clicking the bill number 
in a Vendor Report.

Unfortunately, the AP register does not show you the linked bill for payment 
transactions. (the easy method here is to look at a Vendor Report) For this 
reason, the only editing I do of AP transactions is to add the relevant bill #s 
to the Memo lines for each ‘payment’ split. I do this from the account register 
I paid the bill from however, and NOT from the AP register - just to be safe. 
(though I don’t think it matters)

In addition, you can attach a link to a PDF scan of the bills using the 
right-click menu on the transaction. However, I don’t think you can attach two 
different files to different splits in the same transaction. What would be more 
useful here is instead attach the files to each bill transaction rather than 
the consolidated payment transaction.

You can take both routes if you need, using the business features for some 
liabilities and directly editing for others. However in this case, for the 
non-business feature direct editing, I would create a separate liability 
account called ‘Other Accounts Payable’ or something similar, or even by the 
vendor name (as you did here) and do manual entry there. Of course, direct 
entries are not visible at all to the business features or to any vendor 
related account. You would have to generate any similar reports in a manual 
fashion likely using the Transaction Report.

Regards,
Adrien

> On Feb 5, 2018, at 7:08 PM, Fran_3  wrote:
> 
> We get billed by one vendor weekly but pay every two weeks.
> We started entering each weeks bill into AP individually
> Now we want to pay two of those bills with one check.
> I assume this is a split transaction
> But trying to do it from the check register I am unable to associate each 
> split to a its associated bill...
> 
> The normal sequence to me (not an accountant :-) for an individual bill would 
> be... post the bill...
> 
> Expense > Lawn            AP > pro Lawn Svc
>       
>              | 100                    100 |
>              |                                  |
> 
> Pay the bill
> 
>        Checking            AP > pro Lawn Svc
>       
>      100 |                                  |  100
>              |                                  |
> 
> But the below seems to do this when the bill is paid
> 
>        Checking            Liabilities > AP
>       
>      100 |                                  |  100
>              |                                 

How to pay 2-bills to 1-vendor with 1-check?

[Fran_3 via gnucash-user]

 We get billed by one vendor weekly but pay every two weeks.We started entering 
each weeks bill into AP individuallyNow we want to pay two of those bills with 
one check.I assume this is a split transactionBut trying to do it from the 
check register I am unable to associate each split to a its associated bill...
The normal sequence to me (not an accountant :-) for an individual bill would 
be... post the bill...
Expense > Lawn            AP > pro Lawn Svc       
             | 100                    100 |             
|                                  |
Pay the bill
       Checking             AP > pro Lawn Svc       
      100 |                              |  100     
        |                                  |
But the below seems to do this when the bill is paid
       Checking             Liabilities > AP       
      100 |                              |  100     
        |                                  |
I would have thought in the "Account" column of the register I could get to AP 
> Lawn but it only let's me get to AP
How can I associate the each split with a particular bill from the vendor?
Thanks for any help.  ___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Is "Transfer" same as making a "Journal Entry"

[Fran_3 via gnucash-user]

gnuCash Menue's offer:   Actions -> Transfer
Which seems to allow a simple way to debit one account and credit another... 
right?
if so isn't that the same functionality as what is called a "Journal Entry" ?
Thanks.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Processing Payment to Vendor from Imported Checking

[Fran_3 via gnucash-user]

 Maf,
Thanks for the response and the info. In our case we are a small USA Sub S corp.
I think I meant to say "distributions" and not "disbursements" ... so clearly 
no accountant here :-)
Some info on USA Sub-S Corp's "distributions" here: Taking money out of an S 
corporation
I think what we were looking for was how to account for a loan to a 
shareholder... and ended up putting it under Assets as it is money owed the 
business.
Regardless, our use of gnuCash will be scrubbed at year end by a professional 
accounting firm... that said we want to be as close to 'correct' as possible :-)
gnuCash is the next step in our accounting system process...
1 - left pocket, right pocket2 - paper and pencil3 - spreadsheets4 - gnuCash
:-)
I'm sure I will have more questions so thanks for the help all !
Fran3








| 
| 
|  | 
Taking money out of an S corporation

S corporation owners may take money out of the corporation in a variety of 
ways, such as in the form of wages an...
 |

 |

 |




On Sunday, February 4, 2018, 5:52:07 PM EST, Maf. King <m...@chilwell.net> 
wrote:  
 
 On Sunday, 4 February 2018 20:39:02 GMT Fran_3 via gnucash-user wrote:
>  Geert,
> There are three ways (that I know of) for a shareholder or owner to get
> money out of their business...1 - Pay themselves as an employee2 - Loan
> themselves money3 - Discernment- which is like a "dividend" payment to
> shareholders ( I think) But I'm no accountant... so someone else will
> surely weigh in on this. When is gnuCash 3 going to be released?

Hi Fran,

I'm not an accountant (or lawyer) either, but I have to say that what you've 
written isn't my understanding of (UK) corporate law. I don't know where you 
are in the world, so the below may only be partially true for you.

1. a shareholder of a ltd company can't take a wage unless they are also an 
employee (directors are employees).  Often in small & family firms the 
shareholders are directors, but the 2 roles are distinct & must not be 
conflated.  If you're not clear about this, maybe talk to an accountant?

2. A loan.  not really getting money out of the company, as it should be paid 
back in due course.  there are (in the UK, at least) some pretty stringent 
anti-tax avoidance rules around loans, too.  Record as something like 
Asset:Bank:Current -> Asset:LoansGiven:JoeBloggs

3.  IIRC, the term you want might be disbursement.  Yes, dividends are the 
usual way shareholders get money from a ltd (or plc) company.  I record them 
as transfers to Expenses:dividends. My accountant has never complained.

4. you didn't mention selling shares.  Again, a tax & legal minefield where 
professional advice is required.  But it is a way of getting money as a 
shareholder.

Note. I don't download transactions, so I'm not sure about this "assign as 
payment" workflow you talk about.  All my transactions are either entered 
directly in the registers, or for bills / invoices through the "Process 
Payment" buttons which are outlined in the docs.


HTH,
Maf.

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Processing Payment to Vendor from Imported Checking

[Fran_3 via gnucash-user]

 Geert,
There are three ways (that I know of) for a shareholder or owner to get money 
out of their business...1 - Pay themselves as an employee2 - Loan themselves 
money3 - Discernment- which is like a "dividend" payment to shareholders ( I 
think)
But I'm no accountant... so someone else will surely weigh in on this.
When is gnuCash 3 going to be released?
Thanks
Fran3


On Sunday, February 4, 2018, 3:00:00 PM EST, Geert Janssens 
 wrote:  
 
 Op zondag 4 februari 2018 20:38:47 CET schreef Fran_3:
>  Setup:
> a - Imported CSV bank transactions
> b - CSV format = date,deposits,witdrawls,num,description
> 
> Discovered:
> 1 - Withdrawals must be positive number in CSV file (else show up as
> deposits in check register)

That is correct. The "withdrawal" column type is meant for csv files in which 
you have a separate debit (deposit) and credit (withdrawal) column. Generally 
when there are two columns they are both represented as positive numbers. The 
fact that it's positive or negative is already represented by the column in 
which the amount is recorded. I concede the names chosen for this can be a bit 
confusing.

> 2 - Must assign withdrawals to pay bills to
> Liabilities -> Accounts Payable during the import process

> Then I can right click them in Check Register view and Assign Payment As
> will let me choose a vendor.

> (1 above is true even if you label the columns deposits and
> withdrawals during the import process)

> Questions:
> I - Is the process described above correct? Better alternative?

Yes, that process is correct for gnucash 2.6. Gnucash 3.0 will make it easier 
on you. Regardless of the state of the transaction you will always be able to 
choose vendor, customer or employee in the payment window.

> 2 - How would you properly assign a withdrawal for a loan to an employee
> or shareholder or other entity?

There is no way in gnucash 2.6, but there will be in gnucash 3.0.

> 3 - How would you properly assign a withdrawal that was a dismemberment
> to a shareholder?

I don't know what that is, so I can't advise authoritatively. However you 
could either define shareholders as vendors and treat a dismemberment as a 
payment to that vendor (if that makes any sense) or you record it as a normal 
transaction, unrelated to the business features.

Is there a document to go with this, something like a bill ? Do you need to 
keep track of both that document and the payment and how they relate ? Is it 
tax related ? Then you could model it via a vendor and payment, otherwise you 
could just make it a normal transaction during import.

> 4 - How would you properly assign a capitol deposit to shareholder equity?

I suppose this would have a similar answer as number 3.


> Thanks again for the help.

You're welcome.

Geert


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Processing Payment to Vendor from Imported Checking

[Fran_3 via gnucash-user]

 Setup:
a - Imported CSV bank transactionsb - CSV format = 
date,deposits,witdrawls,num,description

Discovered:
1 - Withdrawals must be positive number in CSV file (else show up as deposits 
in check register)2 - Must assign withdrawals to pay bills to Liabilities -> 
Accounts Payable during the import process
Then I can right click them in Check Register view and Assign Payment As will 
let me choose a vendor.
(1 above is true even if you label the columns deposits and withdrawals during 
the import process)
Questions:I - Is the process described above correct? Better alternative?2 - 
How would you properly assign a withdrawal for a loan to an employee or 
shareholder or other entity?3 - How would you properly assign a withdrawal that 
was a dismemberment to a shareholder?4 - How would you properly assign a 
capitol deposit to shareholder equity?
Thanks again for the help.
Fran3






On Sunday, February 4, 2018, 9:32:29 AM EST, Geert Janssens 
 wrote:  
 
 Op zondag 4 februari 2018 14:53:26 CET schreef Fran_3:
>  How to Assign imported checking transaction to a Vendor?
> All I can see is assigning to a Customer:
> See Click Sequence and Ref Manual 7.1 below for more detains.
> Thanks for any help.
> Fran3
> Click Sequence:- Imported Checking Transactions- Viewed Checking Account-
> Right Clicked a payment- Clicked Assign As Payment- Process Payment Window
> Opens- BUT only allows choosing Customer- Can not choose Vendor
> 
The assign as payment logic in 2.6 is fairly primitive. It tests for two 
things:
1. does the transaction has at least one split in an Accounts Receivable or 
Accounts Payable account ? If yes to the first, it will only allow to select a 
customer in the presented payment window. If the second it will only allow to 
select a vendor in the presented payment window

2. if none of these, it will look at the sign of the checking split: is it 
positive (that is you receive money) it will propose a customer payment, 
otherwise it will propose a vendor payment.

And that's it. So does the transaction you have selected match any of these 
that would lead to a customer selection (split in A/R or you receive the 
money) ?

Regards,

Geert

> Reference Manual 7.1 
> 
> There is an alternative way of assigning a payment to (one or more) bills
> where the payment transaction already exists, say in the case where
> transactions are imported from a bank.
> 
> This can best be done starting from the asset account register holding the
> imported payment transaction (like your bank account). In that account,
> select the payment, right-click (control-click for Mac OS X) and
> choose Assign as payment The payment window will pop-up, partly filled
> in with the information from the transaction. Fill in the missing
> information like the proper vendor and bill to complete the payment.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to edit and post 'duplicate' customer invoice?

[Fran_3 via gnucash-user]

 I assume this mail list is not the appropriate place to file a bug report. Is 
there another email address or a forum or what? Thanks.

On Saturday, February 3, 2018, 1:51:20 PM EST, Geert Janssens 
 wrote:  
 
 Op zaterdag 3 februari 2018 19:33:44 CET schreef Fran_3:
>  Geert,
> Your suggestion worked. Thank you !
> 
Glad you got that sorted :)

> Question: If you should not use "duplicate" transaction while looking at the
> A/R register... I wonder why they don't disable the "Duplicate" icon at the
> top of the register or the one in the Transactions > Duplicated drop down
> menu?
> 
It was late yesterday evening when I wrote my reply and your observation 
crossed my mind today as well. I think this is a valid usability bug that 
should get fixed eventually.

Can I ask you to file a bug report for this in bugzilla [1] ? That way the 
issue won't get lost.

Thanks!

Geert

[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla to learn how to use 
bugzilla


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to edit and post 'duplicate' customer invoice?

[Fran_3 via gnucash-user]

 Geert,
Your suggestion worked. Thank you !

Question: If you should not use "duplicate" transaction while looking at the 
A/R register... I wonder why they don't disable the "Duplicate" icon at the top 
of the register or the one in the Transactions > Duplicated drop down menu?

That said we are learning the software and with a couple of bumps in the road 
are doing well.
Thanks for the help !
Fran3

On Friday, February 2, 2018, 4:46:27 PM EST, Geert Janssens 
<geert.gnuc...@kobaltwit.be> wrote:  
 
 Op vrijdag 2 februari 2018 20:45:44 CET schreef Fran_3 via gnucash-user:
>  Running v2.6.19 on Windows 10 PC
> When I duplicate an A/R or Sales Transaction there is no option to "Post"
> Search -> is Posted -> untick
> returns nothing
> using an experimentl gnuCash file I created another "duplicate" of an A/R
> transaction and did not click on the"?" and then attempted various Business
> -> Customer -> Find Invoice
> searches... some using the regex dot/wildcard operator ... searching for ID
> and by Company Name... Still, the "duplicated" A/R Sales transaction only
> appears in those two registers and can not be found using any search
> technique I can find... It is as if the record does not exist... We really
> would like to use the "Duplicate" A/R Transaction and/or Sales Transaction
> but if we can't post, edit, or find the duplicated entry then we will have
> to continue manually entering each transaction from scratch. Thanks for any
> additional help as we were really depending on using gnuCash. Thanks,
> Fran3
Please never ever directly manipulate invoice related transactions in A/R or 
A/P registers!

Gnucash is not designed to be used like that. If you want to duplicate an 
invoice, open that invoice and select "Duplicate Invoice" from the menu. That 
will do what you are after.

Also if you ticked the "?" to change it into an "I", you have effectively 
created a transaction you can not remove any more. You could try to run check 
& repair on the register to check whether that will undo it. I have not tried 
that myself yet (it's a bit late here).

Regards,

Geert


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to edit and post 'duplicate' customer invoice?

[Fran_3 via gnucash-user]

 Running v2.6.19 on Windows 10 PC
When I duplicate an A/R or Sales Transaction there is no option to "Post"
Search -> is Posted -> untick
returns nothing
using an experimentl gnuCash file I created another "duplicate" of an A/R 
transaction and did not click on the"?" and then attempted various
Business -> Customer -> Find Invoice
searches... some using the regex dot/wildcard operator ... searching for ID and 
by Company Name...
Still, the "duplicated" A/R Sales transaction only appears in those two 
registers and can not be found using any search technique I can find... It is 
as if the record does not exist...
We really would like to use the "Duplicate" A/R Transaction and/or Sales 
Transaction but if we can't post, edit, or find the duplicated entry then we 
will have to continue manually entering each transaction from scratch.
Thanks for any additional help as we were really depending on using gnuCash.
Thanks,
Fran3



On Friday, February 2, 2018, 12:04:04 PM EST, Maf. King <m...@chilwell.net> 
wrote:  
 
 On Friday, 2 February 2018 15:43:10 GMT Fran_3 via gnucash-user wrote:
>  Thanks but unfortunately it didn't work... here is what I did... Clicked
> Business> Customer > Find Invoice > Company Name > matches regex > "."
> (without quotes) Shows the three invoices we have entered (num    01,
> 02, 03) but does not show the duplicated invoice. (fyi, we
> duplicated 01) I can clearly see the duplicated transaction in A/R and
> Sales Ledgers but can not see or get to it any other way. Thanks for any
> help!
> Fran3
> 
> 

Hi Fran,

Did you post the duplicated invoice first time around?

I find that the Search -> Is Posted ->  unticked (or set "not true" depending 
on the GC version) is often useful...

You may have shot yourself in the foot when you clicked on the ?  If you 
click it again does it go back from I to ?  ?

HTH,
Maf. 

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to edit and post 'duplicate' customer invoice?

[Fran_3 via gnucash-user]

 Thanks but unfortunately it didn't work... here is what I did... Clicked
Business> Customer > Find Invoice > Company Name > matches regex > "." (without 
quotes)
Shows the three invoices we have entered (num     01, 02, 03) but 
does not show the duplicated invoice. (fyi, we duplicated 01)
I can clearly see the duplicated transaction in A/R and Sales Ledgers but can 
not see or get to it any other way.
Thanks for any help!
Fran3


On Friday, February 2, 2018, 10:32:33 AM EST, Adrien Monteleone 
<adrien.montele...@gmail.com> wrote:  
 
 Try using the invoice search window again. This time change the search to be 
“Customer” “matches regex” and use a period “.” (without the quotes) as the 
search term. This will show ALL invoices in the system.

Regards,
Adrien

> On Feb 2, 2018, at 9:21 AM, Fran_3 via gnucash-user 
> <gnucash-user@gnucash.org> wrote:
> 
> H E L P - hours spent on this so far and no joy:-(
> From the Accounts Receivable or Sales ledger view... (can't remember which)...
> - I selected a customer invoice and duplicated it.- it asked for a date and 
> id number- I entered the date but not the id number as I thought it would 
> auto increment and populate - it did not- In Accounts receivable view 
> the"Type" was a question mark '?' so I clicked that and it turned into an 'I' 
> (that's a capitol 'i' and not an 'L')
> The Problem:
> - No "Ref" number appears in A/R Ledger or Sales Ledger view- Can not find 
> the invoice via Business > Customer > Find Invoice- Alternately clicking 
> Reports > Business > Customer Report shows the original customer invoice but 
> not the 'duplicated' one
> The Question:
> How can I get to this 'duplicate' invoice to edit it and then post it?
> Should I have entered an id number when I originally 'duplicated' the 
> original record?
> If so I would have to guess the next auto increment number right?
> Thanks for any help.
> Fran3
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to edit and post 'duplicate' customer invoice?

[Fran_3 via gnucash-user]

H E L P - hours spent on this so far and no joy:-(
>From the Accounts Receivable or Sales ledger view... (can't remember which)...
- I selected a customer invoice and duplicated it.- it asked for a date and id 
number- I entered the date but not the id number as I thought it would auto 
increment and populate - it did not- In Accounts receivable view the"Type" was 
a question mark '?' so I clicked that and it turned into an 'I' (that's a 
capitol 'i' and not an 'L')
The Problem:
- No "Ref" number appears in A/R Ledger or Sales Ledger view- Can not find the 
invoice via Business > Customer > Find Invoice- Alternately clicking Reports > 
Business > Customer Report shows the original customer invoice but not the 
'duplicated' one
The Question:
How can I get to this 'duplicate' invoice to edit it and then post it?
Should I have entered an id number when I originally 'duplicated' the original 
record?
If so I would have to guess the next auto increment number right?
Thanks for any help.
Fran3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.