Re: [GNC] best accounting practice for refund

2019-07-03 Thread Adrien Monteleone
You’re welcome. Glad to help any time. > On Jul 4, 2019, at 12:50 AM, Eric Rathhaus (general) > wrote: > > Thanks, Adrien for your assistance and patience. > >> On Jul 3, 2019, at 10:35 PM, Adrien Monteleone >> wrote: >> >> Short answer — yes. >> >> Slightly longer answer — figure out

Re: [GNC] How do I double check scheduled transactions?

2019-07-03 Thread ToddAndMargo via gnucash-user
On 7/3/19 9:04 PM, David Carlson wrote: Read Chapter 6 section 6.12 of the help manual.  If you have any further questions please ask. David Carlson Hi David, Ah Ha! It was the edit button I was missing. I had presumed that it was a floating windows and that the buttons were from the

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread David Cousens
If you post it again but Select View->Transaction Journal it will expand the transaction splits so we can better see what is happening on import. Might also help to be able to see one or two records of the CSV file.Cheers David Cousens - David Cousens -- Sent from:

Re: [GNC] best accounting practice for refund

2019-07-03 Thread Adrien Monteleone
Short answer — yes. Slightly longer answer — figure out what caused that to happen, undo it, and then redo the payment properly. The reason for doing so rather than just creating a correcting entry is so that you learn what went wrong and don’t repeat the same situation in the future. (you’d

Re: [GNC] best accounting practice for refund

2019-07-03 Thread Eric Rathhaus (general) via gnucash-user
So I did assign the credit note to the AR account and then processed two payments by selecting the posted invoices and the credit note all in the AR account. I didn’t do anything else but somehow the remaining balance of the credit note ended up in a liability account. Should I just move it

Re: [GNC] How do I double check scheduled transactions?

2019-07-03 Thread David Carlson
Read Chapter 6 section 6.12 of the help manual. If you have any further questions please ask. David Carlson On Wed, Jul 3, 2019 at 8:15 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi All, > > Looks like I figured out how to do scheduled transactions. > A very useful

[GNC] How do I double check scheduled transactions?

2019-07-03 Thread ToddAndMargo via gnucash-user
Hi All, Looks like I figured out how to do scheduled transactions. A very useful feature! Questions: 1) when I get paranoid that I put the wrong amount in, how can I go back and double check it? 2) how do I change the amount (Netflix raises its prices, etc..)? 3) how do I terminate a

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

2019-07-03 Thread David Carlson
On Wed, Jul 3, 2019 at 6:43 PM John Ralls wrote: > Only slightly. The tarball release is e.g. 3.6. The first Windows bundle > is 3.6, but if there's a dependency problem or I screw up the bundle > subsequent bundles of that same release will be 3.6-1, 3.6-2, etc. The > MacOS bundles work the

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread David Cousens
You will find it useful to have a basic account structure already in place but you can usually add extra accounts as you need then. I think the dialogue which comes up when you select an account has a new account button but GnuCash's windows are not generally modal so you can usually go back to

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

2019-07-03 Thread John Ralls
Only slightly. The tarball release is e.g. 3.6. The first Windows bundle is 3.6, but if there's a dependency problem or I screw up the bundle subsequent bundles of that same release will be 3.6-1, 3.6-2, etc. The MacOS bundles work the same way except that the first one is 3.6-1... 1-based

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread David Carlson
Are your sub-accounts assets under your bank account? Your screenshot looks like every transaction has both a debit and a credit to the same sub-account, thus zero net. Most transactions should be either an income or an expense resulting in either a deposit or a withdrawal resp. to or from a

[GNC] Transaction matching on import

2019-07-03 Thread Kenneth Schneider
Is it possible to “manually match” a transaction when importing a transaction , method of import does not matter, into an account? I’ve had a problem with the importer making the wrong choice. Ken Schneider ___ gnucash-user mailing list

Re: [GNC] Income vs expense

2019-07-03 Thread David Cousens
Peter, This section of the Gnucash Tutorial and Concepts guide should give you an introduction to the concepts in using GnuCash https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_basics.html. GnuCash is a double entry system so every transaction has two or more components which each affect

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread morayweb
Hi Sorry for the bother. My exact method was. 1. Create a new company 2. Create a New Main Bank account. 3. Create all the sub accounts ie Camps in Camps out etc 4. Import the transactions csv file. 5. Map using date for date. Account for type ie Camps in Camps out, Description and deposit

Re: [GNC] Editing List of Income/Expenses

2019-07-03 Thread Colin Law
You can change the name of an account, if that is what you mean by right clicking the account in the Accounts tab and selecting Edit Account. You can also move it in the hierarchy in the edit dialog. On Wed, 3 Jul 2019 at 18:25, Amanda Schafer wrote: > > I'm wanting to edit the list of income

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread Adrien Monteleone
Sorry, I might have misunderstood. Does the csv file contain 8 splits per transaction or are you just ending up with duplicates after the imports? The importer is supposed to check for duplicates so it doesn’t re-import something, but if you’re importing with different assignments it might not

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread morayweb
This is one of the imported accounts Camps In I have own server so could upload files for you to have a look. If possible. Screenshot -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread Adrien Monteleone
You can just copy and paste it into a reply. (might have to format it a bit with tabs or spaces to make it readable) If you use the list directly instead of through Nabble you can try posting a screenshot. (though image hosting services like imgur work best) Regards, Adrien > On Jul 3, 2019,

Re: [GNC] print check register

2019-07-03 Thread Chris Tsuji
Thank you I will give it a try Chris Sent: Tuesday, July 02, 2019 at 11:57 PM From: "Geert Janssens" To: gnucash-user@gnucash.org Cc: "Chris Tsuji" , sunfis...@yahoo.com Subject: Re: [GNC] print check register Hi Chris, You can use View->Filter By... on the register

[GNC] Import Customers to Acct Rec

2019-07-03 Thread Bruce Irving via gnucash-user
Thanks, Adrien.  I didn't find it in the first 100 pages (and, for some reason, find would not work, then!).  For the benefit of others, since all of my customers are individuals and not companies and, since Company is what one sees when selecting the customer, I formatted the company as

Re: [GNC] Employees function fields

2019-07-03 Thread Scott A. Wozny via gnucash-user
Hi Derek, Thanks very much for the clarification. Scott From: Derek Atkins Sent: July 2, 2019 4:38 PM To: Scott A. Wozny Cc: gnucash-user Subject: Re: [GNC] Employees function fields Hi, "Scott A. Wozny" writes: > GNUCash Gurus, > > I have a couple

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread morayweb via gnucash-user
can i email you the file or attach it somewhere on the forum Thanks -- 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

Re: [GNC] best accounting practice for refund

2019-07-03 Thread Adrien Monteleone
If you didn’t involve a liability account initially, the remaining credit on the credit note would sit in AR. But if you ‘paid’ the credit note with a liability, you transferred that amount from AR to the liability, which is the account you will ‘pay’ future invoices from when offsetting with

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread Adrien Monteleone
8 splits for each transaction? Could you provide an example. (you can make up amounts of course, or make the payee/description generic if you like) I’m curious to see what accounts those 8 splits are assigned to. Are they generally the same for each transaction. Are one set of 4 always the

Re: [GNC] Income vs expense

2019-07-03 Thread Adrien Monteleone
Peter, Welcome to GnuCash. Your expense transactions should be split between where the money is coming from (cash, checking, credit card, etc.) and the relevant expense account. Your income transactions should be split between where the money is going to (cash, checking, undeposited funds,

Re: [GNC] cut/paste problem in 3.4?

2019-07-03 Thread Adrien Monteleone via gnucash-user
Seeing how it functions I doubt it would use the OS clipboard. It isn’t just copying/cutting text. It also re-assigns the anchor split to the new account you paste it in. So this is certainly held in an internal ‘clipboard’ of sorts until pasted. I would say the feature is much more

Re: [GNC] Editing List of Income/Expenses

2019-07-03 Thread David T. via gnucash-user
Each entry in your list of expenses is a separate account in your chart of accounts.  You edit the list by removing accounts.  Bear in mind that if your account has transactions in it, you will be asked the account to which you want these transactions to be moved.  David On Wed, Jul 3,

[GNC] Editing List of Income/Expenses

2019-07-03 Thread Amanda Schafer
I'm wanting to edit the list of income and expenses so that my transactions are more specific to my situation, but I can't find that anywhere in the menu listing or in the Help Guide. Can someone direct me to that area please? ASchafer ___ gnucash-user

Re: [GNC] [GNC-dev] Announcement: GnuCash 3.6 Released

2019-07-03 Thread Stephen M. Butler
It appears that dpkg-buildpackage didn't setup the environment correctly for the xenial/bionic build.  I have removed that version from the Google drive. It will take some more experimentation to figure out how to do this reliably. --Steve On 7/2/19 2:04 PM, Manfred Usselmann wrote: > >   > >

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

2019-07-03 Thread David Carlson via gnucash-user
Is it normal for MAc releases to have a different number than Windows, Linus, BSD, and tarballs? On Wed, Jul 3, 2019 at 9:16 AM John Ralls wrote: > > > > On Jul 3, 2019, at 6:46 AM, Marco Rossi wrote: > > > > Hi everybody, > > I’m experiencing an issue with Gnucash 3.6.1 installed on macOS

Re: [GNC] Balance sheet report period

2019-07-03 Thread Rich Shepard
On Wed, 3 Jul 2019, Christopher Lam wrote: Or, you could download 3.6 and test the new experimental multi date balance sheets :-) Christopher, My accountant has been happy with the information I've provided. My question was my own, not hers. I missed the announcement for 3.6. Just built and

Re: [GNC] Balance sheet report period

2019-07-03 Thread Mike or Penny Novack
On 7/3/2019 9:44 AM, Christopher Lam wrote: Or, you could download 3.6 and test the new experimental multi date balance sheets :-) THAT, however, has nothing to do with this question. The "multi date balance sheet" report ISN'T a balance sheet with multiple dates but a report that shows

Re: [GNC] Balance sheet report period

2019-07-03 Thread Christopher Lam
Or, you could download 3.6 and test the new experimental multi date balance sheets :-) On Wed., 3 Jul. 2019, 21:37 Rich Shepard, wrote: > On Wed, 3 Jul 2019, benny.webs...@gmail.com wrote: > > > The balance sheet is a snapshot in time. It reflects the asset, liability > > and equity account

Re: [GNC] best accounting practice for refund

2019-07-03 Thread John Griessen
On 6/26/19 8:51 PM, Eric Rathhaus (general) via gnucash-user wrote: In the past I created a credit note under the special job and sent my client a check. This year they want me to use the credit to offset invoices for subsequent work. I like the idea of creating a credit note under the

Re: [GNC] Balance sheet report period

2019-07-03 Thread Rich Shepard
On Wed, 3 Jul 2019, benny.webs...@gmail.com wrote: The balance sheet is a snapshot in time. It reflects the asset, liability and equity account balances as of the date you choose. Compare two or more balance sheets to see how those balances change over time (eg. month-end to month-end or

Re: [GNC] Balance sheet report period

2019-07-03 Thread Mike or Penny Novack
On 7/2/2019 4:20 PM, Rich Shepard wrote: Looking in the Guide the only reference I see to 'balance sheet report' is a brief description. When I prepare the report the only date option I see is the ending date. Is the start date that of the first entry in GnuCash? Can I produce a balancve

Re: [GNC] Balance sheet report period

2019-07-03 Thread Rich Shepard
On Wed, 3 Jul 2019, D wrote: Although it might not be fully clear, the Guide states that the Balance Sheet report "provides totals as of a given date." David, This is fully clear. I wanted to confirm that it meant the results include everything for the past three years (since I switched back

Re: [GNC] Custom reports don't survive upgrade to v3

2019-07-03 Thread Christopher Lam
Hi Macho There were API changes between 2.x and 3.x, and there'll be further ones from 3.x and 4.x Perhaps you'd be kind to post your custom .scm files on bugzilla, and the stack traces? On Tue, 2 Jul 2019 at 01:50, Macho Philipovich wrote: > Dear gnucash users, > > I decided to upgrade from

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread morayweb
Ok story so far. Managed to import the file but when checking the transactions I have 4 entries for each one 4 incomes and 4 charges. Set the transfer account setting to account date etc ok. When i go to the next stage everything is green but then all as mentioned at the start. Back to dear old

[GNC] Income vs expense

2019-07-03 Thread Peter Peterson
Hi my name is Peter. Iam a new user. I did something wrong i don't know what precisely. My income and expenses always show the same to the cent. I cannot evaluate the difference between income. Whatever for income becomes a expense.please advice. Regard, Peter

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-03 Thread morayweb
Good Morning David Thats a great bit of help. I will keep at it and see how I get on, I only have about 170 transactions I need to import. I was using an online tool to convert the csv to other formats also my date is different it was coming up with error as I have the / rather than the -. To

Re: [GNC] print check register

2019-07-03 Thread Geert Janssens
Hi Chris, You can use View->Filter By... on the register to filter on a date range. After that select Reports->Account Report as David mentioned. Regards, Geert Op woensdag 3 juli 2019 05:20:33 CEST schreef Chris Tsuji: >David >Thank you >How about printing a range of date. >

[GNC] Miscalculation in cashflow reports

2019-07-03 Thread mongolie2006-gnu--- via gnucash-user
Erdenet (Mongolia). Hello. This discussion concerns the following bug: 797093 – Miscalculation in cashflow reports | | | | 797093 – Miscalculation in cashflow reports | | | When there is a split, GnuCash doesn't correctly calculate the cash flow. The attached file, which is