Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Adrien Monteleone
> On Oct 2, 2019 w40d275, at 1:19 AM, Arman Schwarz > wrote: > > Thanks Adrien, > > I think it's the "if you aren't careful" part of the reconciliation > philosophy that I don't like, but I think your message helped me understand > the intended workflow with GnuCash. > > Just to explain my f

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Arman Schwarz
Thanks Adrien, I think it's the "if you aren't careful" part of the reconciliation philosophy that I don't like, but I think your message helped me understand the intended workflow with GnuCash. Just to explain my first comment; Reconciliation seems to depend on the user checking that transaction

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Adrien Monteleone
For now, the workflow is that if you alter a reconciled transaction, you’ll get a warning. (which is dismiss-able, and which you can elect to not be shown) There is at least one (though I think several) bug reports on what should trigger this warning when a reconciled transaction is edited, depe

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Arman Schwarz
Thanks Christopher, also for putting a name to what I was trying to describe. It seems odd to me that the devs would spend time implementing "Reconciliation" and then delete the most important part right after it's provided (the balance). Was this a deliberate design decision or are balance assert

Re: [GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread Christopher Lam
This is a feature called balance assertions present in ledger-cli, another bookkeeping tool. GnuCash doesn't have it. However you can approximate it: https://bit.ly/2mMAKmf On Wed, 2 Oct 2019, 12:28 armanschwarz, wrote: > Suppose on July 1, 2019 I get a statement that my account balance is $100

[GNC] How can I add statement balances to my accounts as checks?

2019-10-01 Thread armanschwarz
Suppose on July 1, 2019 I get a statement that my account balance is $100. Since I know this is true and won't change in the future, I should be able to tell GnuCash that this is the expected balance, and for some kind of warning to appear if that condition is ever violated for the corresponding ac

Re: [GNC] GnuCash 3.7 and Portfolio Report

2019-10-01 Thread John Ralls
You don't need perl unless you want to retrieve stock prices or currency exchange rates. It doesn't have anything to do with anything else. The next two errors are unusual, but they also relate to setting up online quote retrieval and don't have anything to do with the report failing. Was there

Re: [GNC] Please suggest approach to track a category of disbursements

2019-10-01 Thread Adrien Monteleone
I’m sure there are various methods but you can change IRA distributions to be a parent account. Then make the necessary sub-accounts for the various distributions. You can report on only the total distributions or the individual ones as needed. You also don’t need to make a transaction include

Re: [GNC] gnuCash 3.7 portfolio report

2019-10-01 Thread Christopher Lam
See email previously sent. Error in portfolio.scm On Tue, 24 Sep 2019, 23:03 Christopher Lam, wrote: > There's an error in portfolio.scm -- modify the 'report-currency' to > 'currency' and it should be fine > > modified gnucash/report/standard-reports/portfolio.scm > @@ -196,7 +196,7 @@ >

[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: 12/19/18Pa

Re: [GNC] Please suggest approach to track a category of disbursements

2019-10-01 Thread David Cousens
I would use placeholder accounts under some sort of Assets:Investments top level structure to record funds whose tax treatments was different. You could use the description/memo fields to cross reference funds transferred between the different categories of investment as you suggest with a searcha

Re: [GNC] Incactive Customer in Customer List

2019-10-01 Thread Adrien Monteleone
I could be mistaken but I think there is a bug report on this. (there is also some talk of revamping that feature entirely) The Customer Summary Report however is a bit similar and does have the option to exclude inactive customers. However, it doesn’t report all of the same info. Regards, Adri

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

2019-10-01 Thread Adrien Monteleone
Unfortunately, the Statement of Cashflows Report in GnuCash does not work as you describe. There is a large bug report on this. More than likely, that report will get renamed, and a more proper version implemented from scratch. While I understand the workarounds I presented aren’t optimal (they

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

2019-10-01 Thread Michael or Penny Novack
On 10/1/2019 5:20 PM, doncram wrote: Since GnuCash does not have the Cash Flow Statement report as an option, WHAT? for your immediate purpose you can/should generate one manually, working from a printout of the Balance Sheet at the beginning and another at the end of your period, and an Inco

Re: [GNC] GnuCash 3.7 and Portfolio Report

2019-10-01 Thread Ed Fields
checked the trace file, * 17:12:27 WARN Could not spawn perl: Failed to execute child process (Bad file descriptor) * 17:12:27 ERROR gnc_process_get_fd: assertion 'proc' failed * 17:12:27 ERROR gnc_detach_process: assertion 'proc && proc->pid' failed * 17:13:14 WARN14 (apply-smob/

[GNC] GnuCash 3.7 and Portfolio Report

2019-10-01 Thread Ed Fields
Creating a portfolio report seems doesn't seem to work after selecting Reports / Assets and Liabilities / Investment Portfolio I am presented with Report error An error occurred while running the report. ordinarily I would expect to asked to set up the report -

[GNC] Incactive Customer in Customer List

2019-10-01 Thread Proberts042
I am using gnucash version 3.5 in Windows 10 Home. I wish to not display inactive customers in Customers Overview. I cannot seem to find any way to do that. Inactive customers are still listed. Can anyone help? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

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

2019-10-01 Thread doncram
Since GnuCash does not have the Cash Flow Statement report as an option, for your immediate purpose you can/should generate one manually, working from a printout of the Balance Sheet at the beginning and another at the end of your period, and an Income Statement report for the period. You can do t

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

2019-10-01 Thread doncram
What you want is a Cash Flow Statement, which in effect "undoes" accruals. This is basic in any accounting system, along with Balance Sheet statements and Income statements. Any introductory accounting course at a community college or university, or any introductory accounting text book will cover

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

2019-10-01 Thread Adrien Monteleone
#1 - make a copy/backup of your data file and put it somewhere else. #2 - you should be able to just install new. Your OS should remove the old version as needed. If you find that doesn’t work, then yes, uninstall old, then install new. Your data file is readable by 3.x, however, it will on fir

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

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

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

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

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

2019-10-01 Thread Adrien Monteleone
The GnuCash business features were built for Accrual accounting. The corresponding reports were built accordingly. For a cash-basis operation you have two work arounds as options: #1 - don’t post invoices until they are paid. (thus they won’t hit Income, but they also won’t hit AR) #2 - create

[GNC] Please suggest approach to track a category of disbursements

2019-10-01 Thread ornd25
I would like to track IRA disbursements. (For those who don't know, an Individual Retirement Account is a US category of retirement investments in which taxes are not paid until the funds are withdrawn, i.e., "disbursed." In our case and these are disbursements from an IRA mutual fund and will b

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

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

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... aka "general j

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

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

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

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

[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 m

[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 p

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
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,