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

2019-10-02 Thread Derek Atkins
doncram writes: > GNUcash should include such a statement/report, but I think it does not. > You should not have to try to cobble together something from bank > statements; it should simply be available. GnuCash does include a Cash Flow report. > Please remember to CC this list on all your

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

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

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

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

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

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 -

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)

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

[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