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

2020-02-13 Thread Fran_3 via gnucash-user
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 in

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

2020-02-13 Thread Fran_3 via gnucash-user
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 p

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

2020-02-11 Thread Fran_3 via gnucash-user
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

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

2020-02-11 Thread 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

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

2020-02-10 Thread Fran_3 via gnucash-user
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 f

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

2020-02-10 Thread Fran_3 via gnucash-user
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 w

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

2020-02-10 Thread 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

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

2020-02-07 Thread 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

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

2020-02-07 Thread 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

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

2020-02-07 Thread 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

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

2020-02-06 Thread 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

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

2020-02-05 Thread Fran_3 via gnucash-user
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 o

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

2020-02-05 Thread 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

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

2020-02-05 Thread 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

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

2020-02-05 Thread Fran_3 via gnucash-user
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: > >

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

2020-02-04 Thread 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

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

2020-02-03 Thread 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.

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

2020-02-03 Thread 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

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

2020-02-03 Thread 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

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

2020-02-03 Thread Fran_3 via gnucash-user
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 >

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

2020-02-03 Thread 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

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

2019-11-18 Thread 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-u

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

2019-11-18 Thread 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

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

2019-11-18 Thread 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

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

2019-11-12 Thread Fran_3 via gnucash-user
ls 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 > configur

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

2019-11-11 Thread 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

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

2019-11-11 Thread Fran_3 via gnucash-user
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

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

2019-11-10 Thread 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

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

2019-11-10 Thread Fran_3 via gnucash-user
n 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:

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

2019-11-10 Thread 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

[GNC] (no subject)

2019-11-09 Thread Fran_3 via gnucash-user
ing `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 > > > >>

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

2019-11-09 Thread 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

Re: [GNC] Website Down

2019-11-09 Thread 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

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

2019-11-09 Thread 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

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

2019-11-09 Thread Fran_3 via gnucash-user
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 ap

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

2019-11-09 Thread 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

[GNC] Report Transaction Filter for: Not Equal To

2019-11-07 Thread 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

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

2019-11-07 Thread 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

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

2019-11-06 Thread Fran_3 via gnucash-user
vember 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 t

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

2019-11-02 Thread 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:

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

2019-11-01 Thread Fran_3 via gnucash-user
k 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 t

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

2019-11-01 Thread Fran_3 via gnucash-user
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... >&

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

2019-11-01 Thread Fran_3 via gnucash-user
, 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'

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

2019-11-01 Thread Fran_3 via gnucash-user
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.

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

2019-11-01 Thread 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

Re: [GNC] Saved Reports Disappearing

2019-10-31 Thread Fran_3 via gnucash-user
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

Re: [GNC] Saved Reports Disappearing

2019-10-31 Thread 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

[GNC] Bill Date Confusion

2019-10-28 Thread 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

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

2019-10-21 Thread 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

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

2019-10-20 Thread 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

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

2019-10-17 Thread 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.

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

2019-10-15 Thread Fran_3 via gnucash-user
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

[GNC] Applying Pre-Payments to a Bill

2019-10-15 Thread 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

Re: [GNC] Understanding Transaction Report options

2019-10-12 Thread 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

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

2019-10-12 Thread 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

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

2019-10-07 Thread Fran_3 via gnucash-user
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

[GNC] Print Report does not "page" properly

2019-10-07 Thread 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?

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

2019-10-05 Thread 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

Re: [GNC] How to merge 2 vendors?

2019-10-05 Thread 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... > - > Explan

[GNC] How to merge 2 vendors?

2019-10-05 Thread 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

[GNC] How2fix Vendor listed twice - need2merge transactions

2019-10-04 Thread 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

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

2019-10-04 Thread 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

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

2019-10-01 Thread 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:

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

2019-10-01 Thread Fran_3 via gnucash-user
. 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 Accou

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

2019-10-01 Thread Fran_3 via gnucash-user
fer 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 an

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

2019-10-01 Thread 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.

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

2019-10-01 Thread 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

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

2019-10-01 Thread 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

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

2019-10-01 Thread Fran_3 via gnucash-user
s 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&

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

2019-09-30 Thread 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

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

2019-09-30 Thread Fran_3 via gnucash-user
: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.

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

2019-09-30 Thread 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

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

2019-09-29 Thread 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

Re: Scheduled Vendor Bills vs Schedule Transactions

2018-02-25 Thread Fran_3 via gnucash-user
usiness 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 l

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

2018-02-22 Thread Fran_3 via gnucash-user
D 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 cov

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

2018-02-21 Thread Fran_3 via gnucash-user
> 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

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

2018-02-20 Thread Fran_3 via gnucash-user
r) 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 fou

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

2018-02-20 Thread 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

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

2018-02-15 Thread Fran_3 via gnucash-user
omers-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 >

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

2018-02-14 Thread 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

How to export structure without transactions?

2018-02-14 Thread 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

How to relate Transfer Sales to Cash to Customer?

2018-02-08 Thread 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

QBO and QFX files VS QIF and OFX files ?

2018-02-07 Thread 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

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

2018-02-06 Thread 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

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

2018-02-05 Thread 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

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

2018-02-05 Thread 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

Re: Processing Payment to Vendor from Imported Checking

2018-02-05 Thread Fran_3 via gnucash-user
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 wro

Re: Processing Payment to Vendor from Imported Checking

2018-02-04 Thread 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

Re: Processing Payment to Vendor from Imported Checking

2018-02-04 Thread 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

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

2018-02-03 Thread 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

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

2018-02-03 Thread Fran_3 via gnucash-user
own 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

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

2018-02-02 Thread Fran_3 via gnucash-user
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 unfortunate

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

2018-02-02 Thread Fran_3 via gnucash-user
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 > <gnuca

How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread 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

<    1   2