Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, david whiting wrote:


Ah, I sent this before I saw your other reply that got separated from this
thread.


David,

No harm done. The SQLite info is useful.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, david whiting wrote:


One way you can do this is to save your gnucash file in sqlite format (if
you don't use that already)...


David,

I've been using SQLite for a very long time so I can easily work with single
tables. Now, I'm using the default database.


It won't be in the right format to import, so you'll
need to open it in a spreadsheet program and move some columns around and
delete some columns that aren't needed. You can see the import format
here:
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html


Thanks very much.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transferring data from one set of books to another [RESOLVED]

[Rich Shepard]

On Tue, 18 Apr 2023, Rich Shepard wrote:


I have two sets of books: business and personal; still running gnucash-3.11
on my Slackware64-14.2 desktop; it does all I need it to do. I updated my
customer list in the personal book rather than the busienss book by mistake.
Is there a way for me to transform those data from person to business
without having to manually re-keyboard all of them?


All fixed. I opened two instances of gnucash on my 24" monitor, displayed
the personal books Business -> Customers page on both. Selected a row,
opened the edit dialog box, and copied the lines to a New Customer in the
business books.

Can't seem to delete the rows in the personal book so I'll just leave them
there.

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, Gyle McCollam wrote:


I don't know if it is possible, but have you checked out whether you can
export this information? Then you can import into your business system. I
don't use for business, but it seems like you should be able to do this.


Gyle,

Not according to the gnucash-guide.

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transferring data from one set of books to another

[Rich Shepard]

I have two sets of books: business and personal; still running gnucash-3.11
on my Slackware64-14.2 desktop; it does all I need it to do. I updated my
customer list in the personal book rather than the busienss book by mistake.
Is there a way for me to transform those data from person to business
without having to manually re-keyboard all of them?

TIA,

Rich

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can a bank account have sub-accounts?

[Rich Shepard]

On Mon, 13 Mar 2023, Mort Q wrote:


I act as Treasurer for a community organisation, and want to look for a
way that GnuCash can subdivide the money in the bank account into planned
expenses e.g. a few members do ongoing fund raising for equipment, so
could I make a sub-account of the bank account called "Equipment
enhancement"? When making a deposit, allocate that money to
"Assets:Current Assets:Bank Account:Equipment Enhancement" instead of the
currently-used "Assets:Current Assets:Bank Account".


Mort,

Why not have multiple asset accounts? For example, "Checking," "Equipment,"
"Petty Cash?" When you make a deposit you can split it among all pertinent
accounts.

They're not sub-accounts of a checking account, for example, but idividual
accounts. It's similar to a set of expense accounts; e.g, Rent, Utilities
(which would have sub-accounts for Electric, Gas, Water, Garbage or whatever
utility expenses you have), Repair & Maintenance, etc.

HTH,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new user woes

[Rich Shepard]

On Sat, 11 Mar 2023, Jamie Tolbert via gnucash-user wrote:


how do I edit it to put my opening balance in ?!?!?!


Jamie,

You understand double-entry accounting, so an opening balance in an asset
account is a debit, while a withdrawal is a credit. The off-setting account
for that asset opening balance can be a liability or an equity account.

First thing for you to do: using pencil and paper or a text editor, create a
Chart of Accounts for your rental business. I've attached my business book
CoA as revised by me an my accountant 6 years ago. It ain't copyrighted so
you're welcome to use the same thing Of course, if you keep the bank names
the same you're welcome to add money to them. :-)

You'll see that the first Equity account is Opening Balances. That should
help you grok how to get started.

Regards,

Rich

CoA.2017-02-01.pdf
Description: Adobe PDF document
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new user woes

[Rich Shepard]

On Sat, 11 Mar 2023, Jamie Tolbert wrote:


I dont have another asset account,yet...soon I will have a business
checking account, but in the meantime, I do I tell the software I started
a business with an initial investment of 500.00, and that money should be
in petty cash?


Jamie,

Adding accounts to GC is totally independent of bank accounts.

Here, I have two GnuCase cases: personal and business. Each has its own
Chart of Accounts and individual accounts.

I switch between them (and transfer funds as needed) because both are
available under the File menu item: Properties. I don't recall how I
originally set them up because that happened years ago, just after Y2K
FUBARed my former system. But, the larger user manual has instructions.

Using the Business menu, consider setting up each rental unit as a Customer,
and each renter as a Job for that Customer. That keeps a record of all
renters for a unit and you have independent information for each.

Go to the Accounts tab and add a new asset called, for example, Rental
Income, under that sub-accounts for each rental unit and perhaps Rental
Deposit (the type can be specified in the memo). And annother called
Accounts Receivable.

Add appropriate expense accounts, including vendors who do work on the
rental units, and any other accounts your location (and CPA) require.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new user woes

[Rich Shepard]

On Sat, 11 Mar 2023, Jamie wrote:


its really a question on the software, not accounting practicesmy
initial investment, for now, is 500.00..how can I get the 500.00 into
Owner equity, and then get it into petty cash, like I said I tried the
transfer button on the toolbar, and when I do that, I end up with 1000.00
in my equity account?


Jamie,

I'm not an accountant.

Why do you want to want to do the above? Consider an asset account called
'petty cash' and provide a starting balance by transfering it from checking,
savings, or another asset account.

You'll be gaining income from this business, and have expenses (which can be
attributed to each rental unit or customer) and probably have to pay taxes
on the revenue. Where equity enters the picture I've no idea.

Also, keep the thread on the mail list as it may be of value to others now
or later.

Regards,

Rich

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new user woes

[Rich Shepard]

On Sat, 11 Mar 2023, Jamie Tolbert wrote:


Started a new property rental business, and for now, am on a cash basis,
Originally , I thought I would just pay each bill, and credit owner equity
and debit the bill, but that seems very cumbersome and confusing, so
before I get into the actual upcoming rental season, I thought I would
credit owner equity, lets say 500.00 and debit petty cash. and then pay
the bills out of petty cash..but I cant get that initial transaction
correct, I tried the TRANSFER button on the toolbar, and I end up with
1000.00 in owner equity instead of 500.00what would be the best
way to do this?


Jamie,

Your accountant should advise you on this, depending on any local laws or
requirements.

It's a business so use the business functions. Set up each rental unit as a
customer and have a matching income account and damage/pet deposit account.
If you have multiple people renting the same unit you'll have a lot of
customers, but that provides you with a history for each one.

Since you're operating on a cash basis, issue an invoice each month for each
renter/customer, don't post that to accounts receivable until it's paid and
pay it the same time with the money debited to your rental income account.

HTH,

Rich

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is this a wacky idea?

[Rich Shepard]

On Sun, 29 Jan 2023, Liz Dodd wrote:


I envisage burning a CDROM with the books, and a Windows distribution
of GNC, hopefully so they can simply put the disk in and click to run.
Obviously, the books will be read-only in that event, but they'd be
navigable.



I do it, and the year I didn't provide the .exe file I got asked for
it. That was related to Covid lockdown and sending the files
electronically, instead of my usual CD-ROM


I've not followed this whole thread, so excuse me for jumping in. I've run
my business using only linux since 1997 and gnucash for most of that time.
I've sent business and personal end-of-year financials to my CPAs as PDF
files ... generated by gnucash, with scanned supporting documents. As of
last year I'm completely paperless. Saves a lot of file draw space. :-)

Here in Oregon CPAs must use the state's software which limps along on only
Windows, so no matter whatever form the client data arrives they have to
rekey it. I suppose the feds have the same requirement.

It's never been an issue.

HTH,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting split, specifying one expense account [FIXED]

[Rich Shepard]

On Sat, 28 Jan 2023, Adrien Monteleone wrote:


You need to have at least one 'anchoring' split to that register. If you
have more than one split for that account, it will make you keep the first
one, but you can delete the others.


Adrien,

Adrian,

That's the way it worked in the past. Today I futzed with deleting the
split, deleting other splits, and a few other things. What finally worked
was using delete other splits after a right-click on the transfer column
when it displayed `split transaction`.

Regards,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting split, specifying one expense account [FIXED]

[Rich Shepard]

On Sat, 28 Jan 2023, Rich Shepard wrote:


This used to work for me, but not today.


Fixed now.

The 'delete other splits' appeared to be greyed out, but it wasn't.

Right click on the Transfer column blanked it; selecting Groceries in the
Expenses worked. Entered the amount and saved transaction.

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Deleting split, specifying one expense account

[Rich Shepard]

This used to work for me, but not today.

The last transaction in the checking account for groceries was entered as a
split because I took cash back (which displays in the cash register). Now I
have a cash groceries transaction, but gnucash won't let me delete the split
and enter only the credit for the groceries account.

What am I doing incorrectly?

TIA,

Rich

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting customer

[Rich Shepard]

On Sat, 25 Jun 2022, Derek Atkins wrote:


You can't.
Just change it and reuse it for another customer.


derek,

Okay. Thanks.

Rich
___
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] Deleting customer

[Rich Shepard]

I'm using gnucash-3.11-x86_64-1_SBo on Slackware64-14.2 and unintentionally
entered an existing customer twice. I don't find how to delete that record
in the gnucash-guide. How do I delete the new record?

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

On Tue, 12 Apr 2022, Liz wrote:


By looking at such a small number of transactions it is possible to find
whatever the errors are. I too have been on Gnucash for a couple of
decades, but still found 4 errors in one file this March, payments not
entered as received, and digit transposition.


Liz,

The reason I started this thread is all transactions for the month match. No
switched digits, no missing GnuCash transactions. And, now and then during
the month I check the accounts on the bank's web site and marked GnuCash
transactions as cleared as they appear on the bank's web page.


I hope you find what is happening and let us know.


Based on everyone's response my assumption that it's something unknowable at
the bank's side seems to be confirmed.

Thanks,

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

On Tue, 12 Apr 2022, Alan A Holmes wrote:


I had a problem with reconciling just over a year ago. It happened on 2
separate occasions.



My workflow to reconcile on both occasions was :-

...


It only happened the twice. I still follow the workflow in steps 1-5 now,
but don't have the problem is step 5. Any differences I've found was down
to me.


Alan,

That looks like what I do, too, but I don't copy-and-paste the bank
statement's closing balance. I type it.

There are occasions when I forget to enter a transaction into GnuCash, and
that's remedied during the reconciliation process.

Because these discrepancies appear infrequently but only since I moved my
accounts to this bank in 2010 I suspect it's something at their end. And my
banker can't do anything about it because it's somewhere in their IT
department it'll probably remain an annoying mystery.

Thanks,

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Gyle McCollam wrote:


These may not apply, but check that your reconciliation date is the same
as the bank's. Also, check the dates of the transactions as GC shows
transaction past the reconciliation date, that you don't want to
reconcile. The ending balance that GC shows for the reconciliation can be
changed, so put in the bank's balance and see if you get a zero
difference.


Gyle,

I check both the reconciliation date and that date's balance. There are
discrepancies between the purchase date entered in GnuCash and when the
transaction cleared the bank but those are immaterial.

As an aside, I've used GnuCash for more than two decades, starting in 1997.
These large, sporatic discrepancies appeared only a few years ago, long
after I moved my business and personal accounts to my current bank. I did
catch the bank several years ago for charging me twice for the same Amazon
purchase and my banker had that quickly fixed. That was the only obvious
error I've seen.

Thanks,

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Dan Black wrote:


It is possible that you transposed two digits that you may not notice.


Dan,

I compare each transaction and haven't yet seen one with transposed digits.

Thanks for the suggestion,

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Ed Reeder wrote:


When that happens to me I will discover that I entered a transaction
incorrectly. I would check each GC transaction against the banks.


Ed,

That's what I do. As I wrote, they all match.

Thanks,

Rich
___
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] Reconciliation discrepancies

[Rich Shepard]

Every now and then one of my bank accounts doesn't reconcile because what
the bank shows differs from what GnuCash shows. The amounts are significant.
What puzzles me is that the previous month's balances (bank and GC) match
and so do all the transactions. But, the end of month balances don't match.

Many decades ago a penny or two difference when reconciling a bank account
was common; I assume due to rounding errors. But why it is now more common
(but sporatic) puzzles both me and my banker. We've gone over the
transactions shown by the bank and by GC and neither of us can explain the
discrepancies.

Has anyone an idea of why this happens?

Rich
___
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] Cash Basis Accounting

[Rich Shepard]

On Thu, 6 Jan 2022, Michael or Penny Novack wrote:


But somebody who like Rich is invoicing "clients" is perhaps not doing
sales but a service and only needs "income from clients" on a cash basis.
Could do that by having a contra account (usually zero) with a name like
"client income not yet received". Then a single adjusting before (balance
of AR to "not yet received" and a single after ("not yet received to" AR)
should do the trick.


Michael,

I have a sole professional services consulting practice, B2B, with clients.
No product sales. My approach to cash accounting has worked for me for more
than two decades; it might not work as well for others.

Regards,

Rich
___
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] Cash Basis Accounting

[Rich Shepard]

On Thu, 6 Jan 2022, R. Victor Klassen wrote:


The only problem being if you want to send the invoice to your customer,
it says “invoice in progress”.


Since I don't use GC to prepare client invoices it's not an issue for me. I
use LaTeX for invoices.

Rich
___
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] Cash Basis Accounting

[Rich Shepard]

On Tue, 4 Jan 2022, Don Gray wrote:


The problem stems from the report being off by several thousand dollars as
I’ve posted invoices but not received the payments.


Don,

What I do, on the advice of my previous accountant who's now retired, is not
to enter an A/P or A/R invoice until payment is made or received,
respectively. That way what you see is what you have.

In your case, I'd delete the accrual transactions until you receive the
payments.

HTH,

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Wed, 20 Oct 2021, David H wrote:


No the url works here, make sure you are using the full url as it's split
over 2 lines in Geert's email.


David,

Worked as described.

Thanks,

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Wed, 20 Oct 2021, David H wrote:


No the url works here, make sure you are using the full url as it's split
over 2 lines in Geert's email.


True. I thought I had them both in the address bar but there likely was a
space between them.

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Tue, 19 Oct 2021, Geert Janssens wrote:


The way to fix it is described here: https://wiki.gnucash.org/wiki/
Business_Features_Issues#Unposting_and_reposting_a_paid_invoice_loses_its_payment


Geert,

That URL displayed an empty page. The suggestion on it to search for the
topic on another page also returned an empty page.

Ah, well. Thanks,

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Tue, 19 Oct 2021, Geert Janssens wrote:


Did you by any chance unpost and repost the given invoice at some point in
time ? That would cause gnucash to lose the connection between the invoice
and the payment. The way to fix it is described here:
https://wiki.gnucash.org/wiki/
Business_Features_Issues#Unposting_and_reposting_a_paid_invoice_loses_its_payment


Geert,

I don't recall un- and re-posting it. I'll look at the wiki page.

Thanks,

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Tue, 19 Oct 2021, Geert Janssens wrote:


The customer invoice due reminders have been implemented in think back in
2.4 or 2.6 already.


Geert, Derek, et al.

I'm running gnucash-3.11 on Slackware-14.2/x86_64.

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Tue, 19 Oct 2021, Derek Atkins wrote:


Um, I thought the "Due" reminders are only for Vendor Bills, not Customer
Invoices?


derek,

This is the first time I've seen it and it is with a client invoice.

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

On Tue, 19 Oct 2021, Derek Atkins wrote:


If it is still popping up that means GnuCash does not think the invoice
was paid. Most likely this means you did not Process Payment and mark that
invoice as paid. Check your AP account, and ensure the payment was
properly marked to that invoice.


Derek,

That's the first place I looked. The newest A/R entry shows that was paid so
the current A/R balance is $0.00.

I don't enter client invoices until payment is received. Then I enter the
invoice and post it to A/R and pay it to clear A/R and enter the amount into
checking.

Thanks,

Rich
___
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] Clearing due invoice reminder

[Rich Shepard]

Each time I open the company books a 'Due Invoice Reminder' window pops up.
That invoice was paid on Sept. 11th so the reminder shouldn't appear.

Why might that unwarranted reminder show up? And, how do I remove the
unwarranted reminder? My only choices are 'View/Edit Invoice,' 'Process
Payment,' or 'Close.'

TIA,

Rich

___
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] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

[Rich Shepard]

On Sun, 19 Sep 2021, Simone Gaiarin wrote:


Accounts:
- Income
- Bank Account
- Tax
- Pension fund


Simone,

I suggest you add more accounts.

For example, under Assets have Service Income, Pension Income, Bank
(Checking?). Cash, Savings, etc.

Under Expenses the types of expenses you incur.

Under Liabilities, both Current Liabilities and Long-term Liabilities. You
pension fund and taxes would be here.

A book on bookkeeping would be worth reading so you'll learn how to work
with these accounts as you explained in your message.

Rich
___
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] Cash Accounting Method

[Rich Shepard]

On Sat, 11 Sep 2021, Steve Morrow wrote:


I spent much of today evaluating GnuCash for use with my U.S. based small
business. I found it to be robust in its functions.



Unfortunately, it only supports the accrual accounting method (income and
expense recognized when invoiced or billed). My business uses cash
accounting method (income and expense recognized at time of receipt or
payment).

I highly recommend an enhancement to add an accounting method option for
accrual or cash method.


Steve,

Permait me to disagree. I've run my sole professional services practice for
29 years using GnuCash for ... many, many years. For both personal and
professional.

Years ago I had the same perception as you. Discussing this with my
accountant I learned how to use cash accounting.

When I send an invoice to a client (typeset using LaTeX, not generated by
GnuCash) I don't enter it into Accounts Receivable until I receive the check
(or wire transfer). When I have the money I enter the invoice, post it, and
pay it recording the payment details.

Works like a charm. If you have more questions ask.

Stay well,

Rich
___
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] Sorting client list [RESOLVED]

[Rich Shepard]

On Sat, 11 Sep 2021, david whiting wrote:


In gnucash 4.6 you can click on the Customer Number heading to sort by
number. I think this has been around for a while so it should work on the
version you are using, too.


David,

Interesting. Clicking on the header did nothing, but clicking on the client
numbers individually did move them to their position in an ordered list.

Thanks very much!

Rich
___
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] Sorting client list

[Rich Shepard]

I'm running gnucash-3.11-x86_64-1_SBo on Slackware-14.2/x86_64.

Looking at Business -> Customer -> Customer Overview I can see a list of
clients. I've put the client number at the left, followed by the client
name. The list is in random order.

Is there a way for me to order the list by ascending client number?

TIA,

Rich
___
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] Recording non-cash donations

[Rich Shepard]

On Mon, 2 Aug 2021, Stan Brown wrote:


If you're donating items that have no value on your books, I'm not sure I
would call that a "donation" in accounting terms. You could keep a record
by entering a transaction that would have only one split, with Account =
your charity account and Debit and Credit both = 0.


Stan,

Non-cash donations are tax deductible; for example, milage and fuel while
delivering Meals on Wheels to shut-ins, books to the county library, and
items given to Goodwill. For those of us who are sole members of an LLC the
company's net profits roll over to our personal accounts so both business
and personal donations (cash and non-cash) are reported on my personal tax
reports.

For years I've sent my accountant the proof of non-cash donations separate
from the business and personal financial reports for tax preparation. I've
decided now to record these in my personal books so they show up in the
year's balance sheet and income statement.


If the item does have significant value but for some reason you never
entered them in your books, you would create one or more asset accounts
for them. Then you'd make two transactions for each item:
(1) Debit: asset account
   Credit: Equity (I think this is a case for making a direct credit to
the main equity account, essentially a correcting item, because the item
is not new income but something that you've had all along but just not
in your books.)
(2) Debit: Expenses:Charity
   Credit: asset account


I'll look closely at this. It makes sense and allows me to think about it
until I see something from my accountant.

Thanks for the idea,

Rich
___
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] Recording non-cash donations

[Rich Shepard]

While I've sent my account an email asking how to book non-cash donations
I'm also asking here how folks do this. I can set up an Expense account for
non-cash donations but cannot think of an appropriate off-setting account in
Assets (since these are items and books I've owned but are now donating to
Goodwill or the county library).

Your thoughts?

Rich
___
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] So confused about Jobs

[Rich Shepard]

On Mon, 5 Jul 2021, Sabina Iseli-Otto wrote:


I think I might be misunderstanding how jobs work. I’ve gone through the
list archives and the help information on the website but I think I might
be missing something super-basic — too used to my old way of doing things!


Sabina,

Jobs are assigned to customers/clients.


I would like to assign the cost of materials to specific jobs: to track
them, not necessarily to have them appear on invoices for customers.


That's do-able.


I’m not sure if it matters, but so far, I have not been using GnuCash’s
invoicing feature (making my own separately).


I run a professional services consultancy and I provide clients with letter
invoices so I don't use GnuCash's invoicing, either.


I think I need to add job costs directly to invoices for specific
customers, is that right?


If you want those job costs to be included on the invoice, yes.


If I add those job costs to invoices, will those job costs show up in a
place where I can reconcile them against my statements?


I don't know because I don't use the invoicing capabilities.


Is there a better way to track individual job costs?


Not if you want to keep all costs and payments in one place.

Others with much more pertinent experience and knowledge will help you more.

Stay well,

Rich
___
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 not seeing selected account

[Rich Shepard]

For some reason I need to learn a transaction report fails telling me it
needs an account name. I've selected the single account for which I want to
see all transactions to a payee. The failure report shows the account (see
attached) and I don't know what's missing or what I did incorrectly.

A clue stick will be helpful.

Regards,

Rich


transaction-report-06-27-2021.pdf
Description: Adobe PDF document
___
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 export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


You'll probably have to do a bit of cleaning up whichever way you go if
you want to get rid of all the extraneous headers the are in the html file
to get to a true .csv looking file :-)


David,

Figured out how to do it. In Calc -> Sheet -> Link to external data brings
in the .html. And saving as .csv does work.

Cleaning up the cruft in emacs is simple.

I've learned something new today.

Thanks,

Rich
___
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 export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
scroll down until you find the LibreOffice calc menu item and click on it.


David,

When I invoke LO and select ctrl-o to open a file I'm not asked which tool
should open it. It opens as a read-only Writer file.

Regards,

Rich
___
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 export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
scroll down until you find the LibreOffice calc menu item and click on it.


David,

Okay. I sit corrected.

I'll try that rather than opening a new spreadsheet and then opening the
data file.

Thanks,

Rich
___
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 export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


What about the cut and paste from html into Calc ?


David,

I'd first have to remove all the html markup. If I do that I have a plain,
ASCII text file regardless of where it's used. And I can reformat it in
emacs however I want.

Regards,

Rich
___
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 export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Don't know what your objective is but if it helps MS Excel on MacOS will


David,

That's fine if you run Apple and Microsoft software; the linux spreadsheets
I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything
other than .xls(x) or .csv.

Thanks,

Rich
___
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 export file type

[Rich Shepard]

On Thu, 24 Jun 2021, David Carlson wrote:


I have not tested this, but sometimes one can either open a pdf file with
a spreadsheet application or copy a PDF file and paste it into a new
spreadsheet. Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.


David,

I don't think that LibreOffice's Calc or gnumeric will do this.

Thanks,

Rich
___
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 export file type

[Rich Shepard]

On Thu, 24 Jun 2021, John Ralls wrote:


It usually works to copy-and-paste the report into a spreadsheet.


John,

Oh. Okay.

Thanks,

Rich
___
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 export file type

[Rich Shepard]

Is there a way to export a transaction report as a .csv or .txt file? I
looked at all options and didn't see any place to select the export format.
When I did export the file it defaulted to .html; that would take a lot of
cleaning and it would be nice to export to .csv or .txt.

Any thoughts?

Rich
___
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] Cleaning out unneeded 'pre-pays' when paying vendors

[Rich Shepard]

On Thu, 22 Apr 2021, Rich Shepard wrote:


Over the years I've sometimes processed a vendor invoice forgetting to print
it. So I unpost the invoice, repost it, then repay it, this time actually
printing the check. I then delete the extranious payment from checking.

During the payment process I'm offered a dialog box asking which of the
vendor invoices shown I want to pay. There should be only the one I just
entered.

When I look at current liabilities I don't see these 'pre-paid' invoices.
How do I clean out this cruft?


Anyone know how to do this?

Rich
___
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] Cleaning out unneeded 'pre-pays' when paying vendors

[Rich Shepard]

Over the years I've sometimes processed a vendor invoice forgetting to print
it. So I unpost the invoice, repost it, then repay it, this time actually
printing the check. I then delete the extranious payment from checking.

During the payment process I'm offered a dialog box asking which of the
vendor invoices shown I want to pay. There should be only the one I just
entered.

When I look at current liabilities I don't see these 'pre-paid' invoices.
How do I clean out this cruft?

TIA,

Rich
___
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] Reports using accounts (fwd)

[Rich Shepard]

-- Forwarded message --
Date: Fri, 12 Mar 2021 20:55:55 -0700
From: Chuck 
To: Rich Shepard 
Subject: Re: [GNC] Reports using accounts

Hi:
Thanks, Missed that somehow.
Selecting accounts with a account with children was unable to include that
in the report.  so moved it to the parent & then I get it OK.
Perhaps it is not possible to choose both?
Still working on things but things are lookingup, thanks.
Chuck

___
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] Reports using accounts

[Rich Shepard]

On Fri, 12 Mar 2021, Chuck wrote:


Selecting accounts with a account with children was unable to include that
in the report. so moved it to the parent & then I get it OK. Perhaps it is
not possible to choose both? Still working on things but things are
lookingup, thanks.


Chuck,

A parent account, e.g., Expenses will have a small triangle at the left end.
Click that and all the sub-accounts are displayed.

Please keep the thread on the mail list so others can learn, too.

Rich


___
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] Selecting appropriate report [RESOLVED]

[Rich Shepard]

On Sat, 6 Mar 2021, David H wrote:


The Transaction report certainly allows you to select Liability and
Expense accounts, this doesn't fit with your requirements ? You need to go
in and tweak the options obviously.


David,

I was (erroniously) under the impression that only a single account's
transaction could be selected. Thanks to you I've learned differently.

Another day, another lesson learned.

Regards,

Rich
___
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] Selecting appropriate report

[Rich Shepard]

The SBA-PPP loan program allows businesses to apply for repayment
forgiveness if the loan is used for specific purposes. I want to produce a
report that shows the loan amount (a long term liability) and its
distribution (an expense account).

Looking at the available reports, I don't find one that will allow me to
select both a liability and an expense account.

I need to learn how to produce such a report so all suggestions and advice
are appreciated.

Rich
___
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] Need help correcting transaction account [RESOLVED]

[Rich Shepard]

On Mon, 1 Mar 2021, Adrien Monteleone wrote:


The context menu (right click) should give you the option to open the
invoice. The should work for either the invoice transaction or linked
payment transaction.


Adrien,

That right click did the trick; it never occurred to me to try that on
anything.

Yes, I was able to display the invoice, unpost it, change the transfer
account, and re-post it. Now it shows up where it belongs.

Thanks very much for the valuable lesson!

Stay well,

Rich
___
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] Need help correcting transaction account

[Rich Shepard]

On Mon, 1 Mar 2021, Derek Atkins wrote:


Jump over to the AR/AP account for the transaction and there it should
have the Invoice # in the register.


derek,

Ah! I overlooked that account. I see it in the A/P register but there's no
invoice number in any of the columns. I don't suppose I can directly delete
that A/P transaction and it's invoice and recreate the invoice and payment
correctly?

Regards,

Rich
___
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] Need help correcting transaction account

[Rich Shepard]

ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to
the loan liability account rather than to the members draw expense account.

I cannot delete that transaction and re-enter it because gnucash tells me it
was paid on an invoice, and I cannot find that invoice searching for the
payee name in the Business->Vendor->Find invoice dialog box.

I'm stymied and need to learn how to correct that transaction. The liability
account should show only the PPP loan amount while the draw against it
should be to the Expenses->SBA-PPP Salary account.

TIA,

Rich

___
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] {GNC} How secure is Gnu-Cash? Good enough for a credit union?

[Rich Shepard]

On Tue, 29 Dec 2020, Edward Bainton wrote:


Can anyone give a view on whether Gnucash is suitable for a very small
credit union?


Edward,


From my perspective as a long time user and follower of tech security news I

suggest your concern should focus on users, not the software.

Bad actors prefer to use social engineering (e.g., phishing emails,
deceptive web sites) because it's so much easier and doesn't leave signs in
networks or individual hosts.

Whether it's suitable for your credit union should be based on the use cases 
needs
for any bookkeeping software.

My $0.25 (inflation adjusted),

Rich

___
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] Which report to use?

[Rich Shepard]

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Sure it does, the first part of a criteria is the field to search. By
default, that is description. You have many options, including Notes
alone, or as part of 'Description, Notes, or Memo'.


Adrien,

Okay, I missed that ...


Be careful here though. You need to do your Finds from the Accounts tab.
It is possible to do them from a register, but results aren't always what
you might expect.


... and this is probably why I did.


You can either keep doing Finds from subsequent results tabs to narrow the
search (to include or exclude transactions that meet the new criteria) Or
you can craft a single multi-criteria Find.


I'll learn how to effectively use Find.

Thanks again,

Rich
___
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] Which report to use?

[Rich Shepard]

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Though a carefully crafted Find ...


Adrien,

Find apparently does not look in the Notes for the search string. That's
where the unique string is located.

Regards,

Rich
___
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] Which report to use?

[Rich Shepard]

On Wed, 16 Dec 2020, Adrien Monteleone wrote:


Though a carefully crafted Find (or series of them) should narrow down
those desired transactions, you also have View > Filter By... at your
disposal which might hide any undesirables that remain which meet the
available criteria. (but Find also allows you to choose to exclude
transactions from results, so it is probably more powerful)


Adrien,

Thanks very much.

Regards,

Rich
___
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] Which report to use?

[Rich Shepard]

On Wed, 16 Dec 2020, David Carlson wrote:


You use the search function to do the editing, then simply print the
results with the account report. If you want to hide some of the details
you could print to PDF then open the PDF with a spreadsheet app and
manipulate the data there.


Thanks, David.

Rich
___
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] Which report to use?

[Rich Shepard]

On Wed, 16 Dec 2020, David Carlson wrote:


From that description it sounds like you want to nearly arbitrarily pick a
few transactions to print out.


David,

That's true. Four transactions involving two accounts.


I would use the search function starting from the chart of accounts to
pick those needles out of the haystack then use the Account Report.


I'll see if the Account Report can be edited to show only specific
transactions in the two accounts.

Thanks,

Rich

___
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] Which report to use?

[Rich Shepard]

I want to print a report that shows 4 transactions: an initial debit to
checking account/credit to current liabilities, and 3 credits to checking
account/debit to that current liability account.

Which report on the Reports menu would be most appropriate for this task?

TIA,

Rich
___
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] GnuCash 3.904 Released

[Rich Shepard]

On Sun, 7 Jun 2020, John Ralls wrote:


It won't. It will run on distributions that provide the required
dependencies and not all choose to do so.


John,

I thought so and this makes good sense.

Regards,

Rich
___
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: selected date range

[Rich Shepard]

On Sun, 24 May 2020, Fred Bone wrote:


When I run the transaction report it points out that I need to select the
account in "Options".


Fred,

Huh! I saw the link but missed the instruction above it. Mea culpa!


Having said which, I'm not on the latest version. What version are you
running?


3.10

Thanks,

Rich
___
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: selected date range

[Rich Shepard]

On Sun, 24 May 2020, Rich Shepard wrote:


-> Options and do find where I can specify starting and ending dates. When I

   ^ NOT

___
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: selected date range

[Rich Shepard]

I'm missing something in my attempts to define a date range for a
transaction report on a single account.

The account is displayed and has focus. I select Reports -> Account report
-> Options and do find where I can specify starting and ending dates. When I
try Reports -> Transactions GC tells me no account's been selected.

What am I missing?

Rich

___
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] [MAINT] VM (bugfix) Upgrade this weekend

[Rich Shepard]

On Wed, 29 Apr 2020, Derek Atkins wrote:


PS: I wonder if it makes sense to get a second CPU server (and a third
system to act as an "arbiter") in order to allow real-time VM migration
and allow host system upgrades without affecting VM uptime? *ponders*


Derek,

If system upgrades are infrequent then all of us can certainly live with no
access for the time it takes you to perform the upgrade. This also
eliminates SysAdmin time on another host.

Just my $0.02 worth,

Rich
___
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] Gnucash logs

[Rich Shepard]

On Mon, 27 Apr 2020, Michael or Penny Novack wrote:


If true THAT should be be a bug report.


Michael,

Well, okay. I'll find where to mention it.

For those who are only opening books at unpredictably infrequent intervals, 
try this.


That's me. :-)


Put your gnucash data file into a directory with nothing else. Then that's
where the logs will go (and the lock file when the data file is open). Now
it will be easy to remove the clutter, just delete everything in the
directory but the data file (when the data file is closed, the lock file
won't be there)


Here, for several decades, it's all in /data/gnucash/personal and
../business. I let the *datetime.log and *datetime.gnucash files accumulate
until I decide to remove them leaving only the CoA and most recent *.gnucash
files. I could write a short bash shell script and have cron run that once a
week or so but it's not been enough of a nuisance to do so.

Stay well,

Rich
___
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] Gnucash logs

[Rich Shepard]

On Mon, 27 Apr 2020, Frank H. Ellenberger wrote:


doesn't adjusting Edit->Preferences->General:Retain log/backup files bring
some relief?


Frank,

Not here. long ago I set log/backup retention for 1 day but they accumulate
until I manually remove them, perhaps once a month. Pehaps the reference is
for a Venusian day? :-) (Version 3.10 is installed, but it was the same in
prior versions.)

Regards,

Rich
___
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] invoice set up

[Rich Shepard]

On Fri, 17 Apr 2020, Marianne Swienink-Havard via gnucash-user wrote:


Would you mind checking the PDF attached.


Marianne,

There is no attachement.


This is a generic invoice which I need to enter as a GNucash invoice. I am
having trouble with the top area. I am a tourguide and receive commission
on tours sold locally. This will go down as an income but I need to deduct
the expenses. I have tried all sorts of ways. I can’t just put it down as
any old expense account because it would not be deducted from the
commission earned. I don’t want to make a new invoice. Do you have any
idea how to create an account for this, where the expenses on commission
are automatically deducted from the Commission earned.


I'm not sure that I fully understand your situation so I'll write what I
think is your situation. (As explanation, I am a professional services
consultant and I invoice clients based on our agreed fee; similar to you
being paid a commission.) I assume that you have two sets of books in
GnuCash: business and personal.

You work on commission and need to invoice the company for whom you work for
each tour you sell. Then I see two possibilities:

1) You do not include your expenses in the invoice because your commission
is based on the price of the tour you sold.

Enter the invoice using the Business -> Customer -> New invoice process
for the amount you are owed. That is posted to your Accounts Receivable as
an Asset in your business book.

Enter your expenses in the appropriate accounts.

2) You include your commission and your expenses in the invoice because the
expenses are re-imbursed.

Enter the total amount of the invoice as revenue and have separate accounts
for re-imbursed expenses.

Now, ignoring the above if I have missed your point, I don't know how to use
GnuCash to prepare a multiline invoice (e.g., commission and expenses)
because I prepare letter invoices for my clients and enter only the total
amount in GnuCash. So if this is what you're asking others will need to
advise you.

Regards,

Rich
___
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] About bookkeeping and claiming non-currency expenses.

[Rich Shepard]

On Fri, 17 Apr 2020, Christopher Lam wrote:


This question is for the resident accountants and bookkeeping.


Christopher,

Check with your accountant for their preferences and local requirements.


But there are numerous tax deductions allowed, that don't necessarily
belong in the book. For example:
- claiming mileage in dollar per km for business travel
- claiming home running costs (e.g. claiming $0.80/hour working from home
allowance)
- further examples welcome. etc.


What I do for non-cash donations (to Goodwill, for example) is enter the
value in an expense account called 'Donations - non-cash'. You could have
expense accounts for milage and volunteer time if appropriate. (I have run
my consultancy from home for 27 years and have separate books for personal
and business transactions.)

When I prepare reports for my accountant I include the non-cash donations
with the personal balance sheet and income statement and business expenses
from personal funds in the business balance sheet and income statement.
We've been doing this for almost 2 decades and neither the feds, the state,
nor the county have had any complaints.

HTH,

Rich

___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Derek Atkins wrote:


But for version 2.4 docs when 3.10 is now current?


The book has not been updated, but MOST of the content is still relevant.
Certainly all the background and process planning is still relevant, even
if the UI has moved on.



Maybe we should reach out and see if they want to refresh the book?


Derek,

That would make good sense if there's still value in a dead-tree version for
software that updates frequently. Perhaps leaving out specifics that would
change more frequently and expanding the background and process planning for
various types of businesses, currencies, and financial transactions would be
relevant longer.

Regards,

Rich
___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Derek Atkins wrote:


It's working for me...  https://www.gnucash.org/


Derek,

It's now working for me, too. Perhaps it was restricted from being viewed at
the time I visited.


Just a note that the GnuCash team DOES receive a small royalty fee from
PACKT publishing for copies of this book that get sold (assuming this is
the PACKT publishing book). It's not a lot, mind you, but it is something.


But for version 2.4 docs when 3.10 is now current?

Regards,

Rich
___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Edward Bainton wrote:


I'm planning to start using Gnucash in my small business.


Edward,

Good for you!


There appears to be one published beginners manual
,
by Ashok Ramachandran.  It relates to GnuCash 2.4, though.


Er, not correct ...


Before I buy it, can anyone comment on its usefulness, especially as we're
now at 3.10 I gather. And are there other good introductory guides?


There are two, free, docs for current versions: the guide and a help
manual. The gnucash web site seems to be down now as I get to look at only
a blank page. But, I uploaded both docs (for gnucash-3.6; I've not upgraded
to 3.10 docs yet) to a cloud sever. Download them from
. They'll be there for 5 days.

Read those, grab newer versions when available, and ask for help here. Don't
give Amazon your money for that book.

HTH,

Rich
___
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] GnuCash 3.10 Released

[Rich Shepard]

On Sat, 11 Apr 2020, John Ralls wrote:


The GnuCash development team announces GnuCash 3.10, the eleventh release
of the 3.x stable release series. Changes


Thanks to all you devs. It built, installed, and runs on
Slackware-14.2/x86_64.

Regards,

Rich
___
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] Unsplitting a transaction

[Rich Shepard]

On Fri, 20 Dec 2019, Adrien Monteleone wrote:


As I noted, they should be in the Transactions menu.


Adrien,

And the reason I missed it is that the menu item is 'Remove Other Splits'
and the Other was ambiguous to me. I like the right-click solution. :-)

Carpe weekend,

Rich
___
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] Unsplitting a transaction

[Rich Shepard]

On Fri, 20 Dec 2019, Geert Janssens wrote:


The same commands are also in the normal gnucash menus. Right-clicking is
just a convenient shortcut.


Geert,

Good to know. I looked at all menus (except Business) and missed that
function.

Happy holidays,

Rich
___
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] Unsplitting a transaction

[Rich Shepard]

On Thu, 19 Dec 2019, Adrien Monteleone wrote:


1) Right click the split for the cash-back and choose ‘Delete Split’


Adrien,

Well, doh! I don't think of right-clicking on anything, probably because I
do almost all my work in consoles.

That did the trick. And this message I'll save for the next time I forget.
:-)

Thanks very much,

Rich
___
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] Unsplitting a transaction

[Rich Shepard]

I think this thread appeared before but I don't have a saved solution. What
surprises me is that I cannot find how to unsplit a transaction in the Guide
or from a Web search.

On occasion I'll use my debit card in the supermarket and get additional
cash back to save a trip to a bank branch's ATM. I enter the transaction as
a split: one offsetting account is Cash, the other is Groceries.

The next time I want to enter a transaction for that supermarket (cash or
debit) it defaults to 'split transaction' and no matter how I futz with the
descriptions and amounts it refuses to change to Groceries as the cash
offsetting account.

Please explain how to do this and consider putting this information in the
next version of the Guide and Manual.

TIA,

Rich


___
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] Want to find some GnuCash example files

[Rich Shepard]

On Wed, 30 Oct 2019, Tommy Trussell wrote:


... and show me how a real complex accounting book in GnuCash would
look like.



The first place to look might be the Concepts Guide available on the
GnuCash web site. https://www.gnucash.org/docs.phtml


Do read the Concepts Guide to become familiar with GnuCash's capabilities
and structure.

One thing to keep in mind that while GnuCash's application category is
accounting it is actually a bookkeeping tool. The 'accounting' aspect (what
accounts to have, how to book entries for specific business activities,
etc.) are location-dependent and should be addressed by a qualified
accountant. Depending on the record-keeping and taxing requirements of your
business' location a practicing account will advise you of how to meet these
requirements.

Once you're all set you'll find GnuCash a pleasure to use.

Regards,

Rich
___
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] Recording invoice payment issue [FIXED]

[Rich Shepard]

On Mon, 28 Oct 2019, John Ralls wrote:


Edit /usr/share/gnucash/gtkbuilder/dialog-search.glade and change the
value in line 305 (the expand property) to True. When you're done it will
look like:

 
   True
   True
   1
 


John,

Yep. That did the trick.

Many thanks,

Rich
___
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] Recording invoice payment issue

[Rich Shepard]

On Mon, 28 Oct 2019, Adrien Monteleone wrote:


Personally, I don’t care that it is there. Its presence doesn’t mean I’m
processing a vendor bill as opposed to a customer invoice. But I can see
how it might confuse someone who thinks it doesn’t belong there.


It confused me because that's what my eyes saw when the dialog box appeared.

Now I know it's the same dialog box used for both vendor and client payments
I, too, can live with it.

Not being able to select the invoice/vendor, though, is a concern.

Regards,

Rich
___
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] Recording invoice payment issue

[Rich Shepard]

On Mon, 28 Oct 2019, Derek Atkins wrote:


Umm, That's a "Bills Due Reminder", which is only supposed to show Vendor
Bills (i.e. A/P). If your "Invoice" is showing up there, that means you
did it backwards and that you processed it as a Vendor Bill. That's why it
has a checkbox for a check -- because you might want to pay it by check.


Derek,

I explicitly selected Business -> Customer -> Find invoice. And checking
just now the dialog box presented when Business -> Vendor -> Find invoice is
the same: no text entry widget and the heavier line (seen on the screenshot
attached to my original message) cannot be expanded.


As for the FIND dialog not working -- it sounds like a geometry issue.
There is a criteria box at the top.  If it's not visible, try resizing the
window and/or pulling on the lines that separate the frames.


Well, there is a border around search criteria box, with a heavier line just
above the bottom border. However, no separator or that heavier line responds
with a double-headed arrow when the cursor rests on it. There's nothig to
resize here.

Regards,

Rich
___
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] Recording invoice payment issue

[Rich Shepard]

On Mon, 28 Oct 2019, Adrien Monteleone wrote:


With that find dialog up, can you position the mouse in the upper portion
of the window (with the criteria) and scroll? I and others have noticed
this issue with the find dialog recently. I can scroll in mine.


Adrien,

If you're referring to the drop-down box there are only two choices ('all
criterial are met' or 'any criteria are met') and I can scroll or click on
the arror to switch between the two. Neither allows me to enter 'criteria'
which would be the client's name.

So we can't search for an outstanding A/R invoice now using that menu
option, eh?


Note, you can also bring up an invoice (that is posted) from the Customer
Report for that Customer.


True.


As to why the normal workflow failed, I don’t know what might have caused
that without a few more clues.


That's moot. I opened gnucash several hours later and there was a dialog box
showing outstanding invoices due for payment. I selected the new one (the
older ones were paid long ago) and processed the payment. The 'print check'
checkbox doesn't belong on that dialog box because we're processing checks
received and not one of ours to be sent.

Regards,

Rich
___
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] Recording invoice payment issue

[Rich Shepard]

I'm running gnucash-3.7 on Slackware-14.2/x86_64.

Because my business is cash based I enter invoices only when the client
pays, and I record the payment immediately after posting the invoice.

Today, this workflow failed. When I tried paying the invoice the dialog box
appeared to be for paying a vendor invoice, not a client payment; the print
check checkbox caught my eye. So, I closed the dialog box and tried again by
finding the new invoice: Business -> Customer -> Find invoice.
Unfortunately, I could not find the invoice because the dialog box has no
text entry widget (see attached screenshot.)

If I've done something incorrectly please point me in the proper direction.
I want to process this payment so it clears A/R and debits my business
checking account.

Regards,

Rich___
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] Printing checks to a pdf file

[Rich Shepard]

I've looked through the guide without finding any information on paying
invoices and printing the checks to a pdf file. I'd like to do this and
transfer the .pdf to a host directly connected to the laser printer.

I've not tried this using gnucash and don't recall seeing that option when
paying bills.

Possible?

Rich
___
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] U.S. Small Biz Question: Keeping Original Printed FI Statements

[Rich Shepard]

On Sun, 15 Sep 2019, Greg Feneis wrote:


If any of you in the US has been audited recently, and don't mind writing
about it, did they require everything be printed on paper for them to look
at? Did they require everything be the originally printed paper item
issued by the financial institution or actual receipt from the vendor,
etc.?


Greg,

I've not been audited and have run my sole practitioner consultancy since
1993. My accountant told me that record retention time is now 4 years (I
keep all paper in monthly folders for each year and recycle those of the
fifth prior year each January) and that digital records are fine. I send her
pdf balance sheets and income statements each month and she now submits my
business and personal taxes (federal and state) online; I don't think the
IRS accepts paper any more, at least from small businesses.

On the other end, news reports are that the IRS lacks personnel and this has
affected all their operations.

I suggest you consult with _your_ accountant for a local opinion.

Regards,

Rich
___
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] Simple Reports

[Rich Shepard]

On Mon, 9 Sep 2019, D wrote:


Not quite. Using your method, open the account, open View->Filter by, set
your dates, then run the account report.

Alternatively, open the generic Transaction report, in options, choose the
account in question, and set the dates.

I prefer option 2, inasmuch as I don't have to remember to clear the
filter from the account after my query, which you have to do in the first
method.


David,

Those approaches look familiar. I was working from memory so I'm not
surprised I was off a bit.

Thanks,

Rich
___
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] Simple Reports

[Rich Shepard]

On Mon, 9 Sep 2019, mrtibbsabq wrote:


Hi. I have been using GnuCash for awhile now but I cannot see a way to
tunnel down into the data and generate some simple reports. I would like
to generate a report between two dates that show only the expenses for a
specific expense category. That seemed easy to do in MS Money but I am
stuck with GnuCash. Can someone set me on the right path here? Thanks.


I asked the same question a while ago and learned how to do this.

Using the Accounts tab open the account you want to view.

Isolate the dates by highlighting them.

Then select the Account Report.

If I've mis-remembered the sequence others will put us both back on the
rails.

Rich
___
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] Default print-to-file directory

[Rich Shepard]

On Wed, 4 Sep 2019, Adrien Monteleone wrote:


Sorry, stumped on that one.


Adrien,

That makes two of us.


... but I don’t recall having a default starting directory issue with other
apps. Do you have that option and does it present the same issue with the
default location? (I don’t recall what format the ‘print-to-file’ printer
function resulted in)


When I want to print a web page, text document, or a GnuCash report the
Xfce4 print dialog opens and presents choices of printing to a file, or to
the LJ5 or color laserjet printer. Most of the time I print to a .pdf file
because it will be either stored on the computer or attached to an e-mail
message.

While all other applications do present the last used directory and
filename, when I make a change that change then becomes the default until
changed again. With GnuCash, the default is /rshepard/workspace/ and I
change back to my home directory and that's where the report is printed. But
the next time the default is still /rshepard/workspace/ rather than only
rshepard/. It must be stored somewhere but I cannot find where.

Thanks,

Rich
___
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] Default print-to-file directory

[Rich Shepard]

On Wed, 4 Sep 2019, Adrien Monteleone wrote:


I thought it defaulted to the last used location, but if not, investigate CUPS.


Adrian,

No, it doesn't remember the last used location. The issue is not CUPS
because GnuCash is the only application I run that keeps defaulting to the
same directory even though I don't directly print files there.

Thanks,

Rich
___
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] Default print-to-file directory

[Rich Shepard]

I've looked for a config file where the default print-to-file directory is
specified so I can change it, but I cannot locate this file. Please point me
to it (on a linux system).

TIA,

Rich
___
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] Thank you

[Rich Shepard]

On Wed, 4 Sep 2019, Mike or Penny Novack wrote:


Just because you might end up printing an exported report does not mean
you have to send to your accountant as hard copy. Instead of printing the
file, simply attach it as a document to an email. Your accountant does not
need access to gnucash to read an exported document << for example, a
browser reads html >>


I've sent my accountant PDFs attached to e-mail messages monthly for more
than 25 years. She must use proprietary, vertical market software as well as
web sites for federal and state revenue agencies. The PDFs make it easy for
her to extract the information she needs and enter it wherever.

Rich
___
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] Non-expense, non-income transactions?

[Rich Shepard]

On 9/3/2019 3:08 PM, Roderick Anderson wrote:


I am looking for suggestions on how to account for cash pulled from the
checking account to be used for making change for our fund raising event
and then redeposited into checking.


Rod,

I have an asset account called 'Petty Cash'. Most of the time it has a zero
balance but when I need to fuel my diesel pickup truck (which I drive
to/from client sites) I'll withdraw cash from the checking account and enter
it in the books as a transfer from checking (credit, withdrawal) into petty
cash (debit, addition).

When I fill the tanks I'll enter that transaction as a credit (withdrawal)
from petty cash and a debit (addition) to the vehicle fuel account.

If I were using petty cash to make change what I'd probably do is add all
the cash received and add that to the remaining petty cash in the Income
'fund raising event' account. Then when I deposit the cash in the checking
account I do the reverse account transfer from one asset account to another
asset account.

I also do account transfers between the business checking and business
savings accounts when I move funds from one to the other. Transfer accounts
are your friend for moving amounts between accounts in the same parent
account type.

Regards,

Rich
___
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] Newbie

[Rich Shepard]

On Thu, 8 Aug 2019, S. Sliackus wrote:


As a new user, I didn't learned how to achieve certain tasks yet, so my
feedback might not be relevant sometimes, but that is why I came here and
I hope this will be right place to get and give an advice :-)


Have you read the help/tutorial or guide? Almost all answers to your implied
questions can be found there. And, for cash accounting rather than accrual
accounting don't post invoices until the payments are received.

Start using gnucash and you'll figure out how to make it work for you,
especially if you search the mail list archives for specific issues.

Rich

___
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] Income statement incorrect

[Rich Shepard]

On Wed, 31 Jul 2019, Adrien Monteleone wrote:


I didn’t mean it like that.


Adrien,

Thank you. It is far too common with e-mail messages to be mis-read or
mis-interpreted. Non-verbal communication (body language and facial
expressions) have been reported to comprise about 60% of face-to-face
communications. That means that only 40% is conveyed in writing.

Regards,

Rich

___
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] Income statement incorrect

[Rich Shepard]

On Wed, 31 Jul 2019, Derek Atkins wrote:


1) You'll need to manually back out your AR and AP to convert from Accrual
to Cash, or

Sorry, but that's where we are.  Personally, I use option #1.


Derek,

I'm not an accountant but I know that each taxing authority has different
rules and requirements. Now I, too, will use option #1.

Thanks,

Rich
___
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.