Re: [GNC] USAA OFX Direct connect stopped working

2023-07-23 Thread Jon Schewe
I just tried going through the setup page again and I was able to
retrieve my accounts from USAA during the setup. However after that
when I try and download transactions I get the following:


Status for signon request: General error (Code 2000, severity "ERROR")
Error other than those specified by the remaining error codes. (Note:
Servers should provide a more specific error whenever possible. Error
code 2000 should be reserved for cases in which a more specific code is
not available.)
Status for transaction statement request: Signon invalid (Code 15500,
severity "ERROR")
The user cannot signon because he or she entered an invalid user ID or
password.
Unlocking customer "4"


Any other suggestions?

Jon


On Tue, 2023-07-18 at 10:12 -0700, John Ralls wrote:
> BTW, I also got the invalid signon from USAA this morning. I repeated
> the drill at
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA a
> nd got the exact same access id and pin. Once completed I was able to
> retrieve my transactions.
> 
> Regards,
> John Ralls
> 
> 
> > On Jul 18, 2023, at 9:15 AM, john  wrote:
> > 
> > Access id is configured in the AQBanking setup wizard accessed from
> > Tools>Online Banking Setup. The PIN is collected every time you run
> > Actions>Online>Get Transactions unless you told GnuCash to remember
> > it. If you did you can tell it to forget from Preferences>Online
> > Banking.
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Jul 17, 2023, at 20:41, Daffy Duck 
> > > wrote:
> > > 
> > > Ok, as of today, I can no longer use the online download again.
> > > 
> > > 22:35:38 Status for signon request: General error (Code 2000,
> > > severity "ERROR")
> > > Error other than those specified by the remaining error codes.
> > > (Note: Servers should provide a more specific error whenever
> > > possible. Error code 2000 should be reserved for cases in which a
> > > more specific code is not available.)
> > > 22:35:38 Status for account info request: Signon invalid (Code
> > > 15500, severity "ERROR")
> > > The user cannot signon because he or she entered an invalid user
> > > ID or password.
> > > 
> > > And the problem is, I can't find the info on how to set ACCESS
> > > ID: and ACCESS PIN: so I can do it over again.
> > > 
> > > Any ideas?
> > > 
> > > On Mon, 2022-08-22 at 09:18 -0700, John Ralls wrote:
> > > > 
> > > > > On Aug 21, 2022, at 8:13 PM, john
> > > > > mailto:jra...@ceridwen.us>> wrote:
> > > > > 
> > > > > 
> > > > > 
> > > > > > On Aug 21, 2022, at 7:54 PM, Daffy Duck
> > > > > > mailto:suffsuccot...@gmail.com>>
> > > > > > wrote:
> > > > > > 
> > > > > > Hello,
> > > > > > 
> > > > > > A while back, USAA changed their OFX stuff and there had to
> > > > > > be a
> > > > > > workaround with a PIN, etc.
> > > > > > 
> > > > > > I did that, without a problem, but I just noticed today it
> > > > > > has broken
> > > > > > again?
> > > > > > 
> > > > > > This is the output:
> > > > > > 
> > > > > > AqBanking v6.5.2.0stable
> > > > > > Sending jobs to the bank(s)
> > > > > > Sorting commands by account
> > > > > > Sorting account queues by provider
> > > > > > Send commands to providers
> > > > > > Send commands to provider "aqofxconnect"
> > > > > > Locking customer "1299"
> > > > > > Sending request...
> > > > > > Connecting to server...
> > > > > > Resolving hostname "df3cx-services.1fsapi.com" ...
> > > > > > IP address is "45.60.151.211"
> > > > > > Connecting to "df3cx-services.1fsapi.com"
> > > > > > Connected to "df3cx-services.1fsapi.com"
> > > > > > Using GnuTLS default ciphers.
> > > > > > TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-
> > > > > > GCM:AEAD
> > > > > > Connected.
> > > > > > Sending message...
> > > > > > Message sent.
> > > > > > Waiting for response...
> > > > > > Receiving response...
> > > > > > HTTP-Status: 200 ()
> > > > > > Response received.
> > > > > > Disconnecting from server...
> > > > > > Disconnected.
> > > > > > Parsing response...
> > > > > > Status for signon request: Success (Code 0, severity
> > > > > > "INFO")
> > > > > > The server successfully processed the request.
> > > > > > Status for transaction statement request: General error
> > > > > > (Code 2000,
> > > > > > severity "ERROR")
> > > > > > Error other than those specified by the remaining error
> > > > > > codes. (Note:
> > > > > > Servers should provide a more specific error whenever
> > > > > > possible. Error
> > > > > > code 2000 should be reserved for cases in which a more
> > > > > > specific code is
> > > > > > not available.)
> > > > > > Unlocking customer "1299"
> > > > > > --
> > > > > > 
> > > > > > any ideas?
> > > > > 
> > > > > First, try again tomorrow on the off chance USAA had a server
> > > > > outage over the weekend. If it still fails, turn on OFX
> > > > > logging (see
> > > > > https://wiki.gnucash.org/wiki/AqBanking#Debugging) and
> > > > > capture the actual OFX response. Edit it to remove your
> > > > > actual account number and credentials then post 

Re: [GNC] Transaction line debit/credit in split view

2023-07-23 Thread NoobAlice

On 2023-07-23 02:54 PM, john wrote:
https://bugs.gnucash.org/show_bug.cgi?id=799041 coomplains that the 
transaction line in split view shows the amount for the anchor split 
in the register account in the Tot Debit or Tot Credit columns instead 
of the value in the transaction currency as is shown in the 
single-line view. He proposes that the transaction line in split view 
should also show the value in the transaction currency, that is shares 
* price. Does anyone have an opinion about this? 



I sometimes found Steven Bruniges' writing a little difficult to follow, 
so pardon if I've missed something.  I disagree with him; the 
transaction line in the split view shouldn't show the value in the 
transaction currency because the share price isn't being shown.  (Why 
doesn't he have the "Price" column header?)


My preferences would be, referencing the first two screenshots from the 
original bug:


Screenshot https://bugs.gnucash.org/attachment.cgi?id=374842
* Leave all numbers as-is

Screenshot https://bugs.gnucash.org/attachment.cgi?id=374843
* In the "Tot Sell" column remove the top black 3 and leave that cell blank.

In BOTH screenshots
* change heading "Balance" to "Shares Balance" to indicate it is not the 
cash value total but the shares total
* no need for "Tot" in any of the three column headings that use it.  
They are not really totals, which just makes this a little odd.



Surprisingly, this does not appear to be an issue in my single 
other-currency balance sheet account (except for the "Tot" parts of 
column heads), probably because conversion rates are not displayed in 
the register.



___
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] Transaction line debit/credit in split view

2023-07-23 Thread Jim DeLaHunt

On 2023-07-23 11:54, john wrote:

https://bugs.gnucash.org/show_bug.cgi?id=799041 coomplains that the transaction 
line in split view shows the amount for the anchor split in the register 
account in the Tot Debit or Tot Credit columns instead of the value in the 
transaction currency as is shown in the single-line view. He proposes that the 
transaction line in split view should also show the value in the transaction 
currency, that is shares * price.

Does anyone have an opinion about this?


I feel like I ought to have an opinion about this, since my book has 
several currencies and securities, and the handling of securities and 
currencies regularly surprises me. But in reading the bug 799041 
discussion, I have a hard time following the issue. Part of the problem 
is that my small laptop screen means I can't refer to the screen shots 
while I read discussion text.  I may do better if when I open the bug 
discussion on a system with multiple, large monitors.


Cheers,
    —Jim DeLaHunt

___
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] strange lack of exchange rates in a new currency cash account

2023-07-23 Thread john
Scott,

> On Jul 23, 2023, at 03:11, Scott Ellsworth  wrote:
> 
> ...sorry, accidentally didn't reply to all, so I'm forwarding my reply to the 
> list
> 
> - Original message -
> From: Scott Ellsworth 
> To: john 
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Sunday, July 23, 2023 17:10
> 
> *Hi John,*
> 
> - Original message -
> From: john 
> To: Scott Ellsworth 
> Cc: GnuCash user forum 
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Sunday, July 23, 2023 02:17
> *Thank you for your help. **I've used Gnucash for over 15 years, but suddenly 
> I'm running into my ignorance about some features:*
> The simple solution is to fix that split and remove or fix the 0 price 
> entries in the pricedb.
> *I never even knew about the Price Database before. In there I saw one item 
> for every day, and I see a non-zero price for only one day, the 20th. When I 
> went to the dong account just now, went into every split of every 
> transaction, and clicked Edit Exchange Rate on each one, I only found one 
> that was blank. I don't think I've solved the problem by entering the rate 
> for that transaction, because I still see the Account Summary telling me that 
> my ₫2,394,000.00 is worth $0.00 after refreshing it, when I know that it's 
> actually worth about $101.*
> **

It works off the latest price in the pricedb. If that's 0 then so will be the 
home-currency values on the accounts page and in the summary bar.

> 
> You should check your other VND transactions to make sure that there aren't 
> any other 0-price splits. There's only one set of prices for any particular 
> commodity pair so you'd have to make a new book to see different price 
> behavior.
> *I think I have this covered now based on what I said above, but the problem 
> remains. Looking at the Price Database again now, I still see a non-zero 
> price only for one day in spite of the correction I made.*

Editing transactions won't change an entry in the pricedb. Only creating a 
transaction will, and then only if there isn't already a corresponding price 
for that day. That means that if you create the first transaction of the day 
with a zero price and immediately correct it you still have a 0 price in the 
pricedb that you have to manually fix or delete.

> 
> The more complicated problem is how did that 0-price split get created and 
> why did that become the price for the day instead of one of the others. Would 
> you be willing to post a transaction report of the VND account with Display 
> optiions set to show date, date entered, accounts, shares, and prices  with 
> one line per split? Leave off description, memo, and account to keep 
> confidential what you spent the money on, that's irrelevant here.
> *I'll be happy to do this, but I haven't figured out how to add those columns 
> to the register view.*

Not in the register view, in Transaction report options on the Display page, 
but in light of your other answers I think that it's not necessary.

Regards,
John Ralls

> 
> *Be Well,***
> * ***
> *Scott***
>  Scott Ellsworth || +1 (775) 386-2519 
> On Jul 22, 2023, at 01:34, Scott Ellsworth  wrote:
>> 
>> Hi John,
>> 
>> Every transaction is big enough to equal more than one cent. And the dong 
>> cash register starts with an ATM withdrawal of 2 million dong. 
>> 
>> In the Price Database, which I was not familiar with before, I see three 
>> entries, two of which are at zero value. The Account Summary now shows 
>> "₫540,780.00 $0.00" but the transactions do usually have dollar equivalent 
>> values: When I look at my Food account I see that the most recent 
>> transactions were worth $1.18, $0.25, and $38.53. But I notice one 
>> transaction from the 19th, a split transaction where the Food component came 
>> out to zero and the number fields are simply blank on that line, not with 
>> zeroes shown. The other parts of the transaction were $6.19 spent from 
>> Assets:Cash:vn dong balanced against $3.18 spent on Expenses:Health, so the 
>> transaction obviously does not balance. When I go to the blank line for 
>> Expenses:Food and click on Jump, nothing happens. But when I go to the 
>> Cash:vn dong account and find that transaction, I see an amount for the food 
>> component, 549,000 dong, which was missing in the Food account.
>> 
>> This is confusing. I hope my file is not corrupted, since my financial data 
>> is important to me. And it's strange that even after I created a second dong 
>> cash account to test, the new account had the same exact problems.
>> 
>> Be Well,
>> 
>> Scott
>>  Scott Ellsworth || +1 (775) 386-2519 
>> 
>> - Original message -
>> From: john 
>> To: Scott Ellsworth 
>> Cc: GnuCash user forum 
>> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
>> account
>> Date: Friday, July 21, 2023 23:24
>> 
>> Scott,
>> 
>> Did you perhaps get the balance to  2M 

Re: [GNC] Help with counters problem

2023-07-23 Thread Jim DeLaHunt

Dave:

On 2023-07-23 10:33, Dave Carlin via gnucash-user wrote:
…I have recently moved my Gnucash installation from an old Windows 7 
pc to my new shiny windows 11.
… I wanted to continue with the various counters that I had been 
using, e.g. bill, invoice, employee, customer counts etc. So I had to 
manually enter the various counts into File >> Properties >> 
Counters.  All fine so far.
Now, every time I create a new Bill, Invoice, Customer etc the count 
resets back to zero and the next item I'm creating starts at 1.

…I'm running on Windows 11, MySQL 8.0


What version of GnuCash are you using on the shiny new Windows 11?

How did you install GnuCash? Did you run an installer, or did you copy 
the GnuCash application files from the old computer to the new?


And what option are you using to store your data file? XML, compressed 
XML, SQL backend?


Can you reproduce this problem on a new, largely empty GnuCash file? If 
so, then that file will be helpful for others who want to diagnose the 
problem.


I hope this helps to get you useful assistance.

Best regards,
    —Jim DeLaHunt

___
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] Transaction line debit/credit in split view

2023-07-23 Thread john
https://bugs.gnucash.org/show_bug.cgi?id=799041 coomplains that the transaction 
line in split view shows the amount for the anchor split in the register 
account in the Tot Debit or Tot Credit columns instead of the value in the 
transaction currency as is shown in the single-line view. He proposes that the 
transaction line in split view should also show the value in the transaction 
currency, that is shares * price.

Does anyone have an opinion about this?

Regards,
John Ralls


___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Jim DeLaHunt

Chris:

On 2023-07-23 05:55, Chris Green wrote:

You should record the cash income from the various collections etc to the
Assets:Current Assets:Cash via the appropriate Income: account as you receive
it (or as you count up the cash in the bags), preferably with the date
on which the collection took place. When you eventually come to make the
deposit into your current bank account, this is simply recorded as a transfer
between two asset accounts - it is no longer income, any more than paying
off your credit card bill from your current account needs to be accounted
for as Expenditure (in this case you are transferring money from an asset
account (your bank) to a liability account (your credit card).


So I need two sets of Income sub-accounts then.  One records the cash
deposits into Assets:Current Assets:Cash and the other ones record
donations made direct to Assets:Current Assets:Bank.…


Why do you need two sets of Income sub-accounts?  If there is an income 
sub-account for all donations of a certain type, be they cash donations 
at an event or cheques sent to the church, then use this same income 
sub-account in transactions involving cash deposits into Assets:Current 
Assets:Cash and donations made direct to Assets:Current Assets:Bank.



…The most important thing from my point of view is the ability to
present accounts to the diocese where all donations of a particular
type are collected together.… I need a single sub-account where I can see
*all* money of a particular type regardless of how it got there.…
If you want to show the diocese all donations of a particular type, then 
that single income sub-account for all donations of that type will have 
entries for "*all* money of a particular type regardless of how it got 
there".


As Stan Brown said, this is a simple situation, but this thread is 
having a hard time finding the words which will let the simplicity shine 
through.


Also, some of your questions seem to be actually about accounting and 
bookkeeping, rather than about using GnuCash. GnuCash claims to be an 
efficient way to do double-entry bookkeeping, but it does not claim to 
protect you from having to understand double-entry bookkeeping. If you 
have not already, I recommend that you:


 * read the entire GnuCash Tutorial and Concepts Guide
   ,
 * make a simple, largely empty GnuCash book file as a place to simply
   do experiments, so that you can try things without endangering your
   actual data, and
 * get an introductory book on accounting (maybe on accounting for
   churches and non-profits) and read a few chapters

I hope this helps clarify things for you.
    —Jim DeLaHUnt

___
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] Help with counters problem

2023-07-23 Thread Dave Carlin via gnucash-user

Hi there

Hope someone can help with an irritating problem.

I have recently moved my Gnucash installation from an old Windows 7 pc 
to my new shiny windows 11.
The old installation worked perfectly well, including all the 
customisations I have done over the years.


When transferring the data over I wanted to continue with the various 
counters that I had been using, e.g. bill, invoice, employee, customer 
counts etc.
So I had to manually enter the various counts into File >> Properties >> 
Counters.  All fine so far.
Now, every time I create a new Bill, Invoice, Customer etc the count 
resets back to zero and the next item I'm creating starts at 1.


I have tried several things, including pleading and begging. Nothing 
seems to work and I never get any warning or error messages.


So far all other settings and customisations seem to be working (e.g. 
bespoke reports, salutations, business details etc).


I'm running on Windows 11, MySQL 8.0

Any help or suggestions much appreciated

Cheers
Dave

___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Michael Hendry


> On 23 Jul 2023, at 12:02, Fred Bone  wrote:
> 
> But aren't you supposed to record each collection separately for GASDS 
> purposes? What happens if the two weeks are in different tax years?

Ah, I hadn’t thought about that aspect, but Chris had mentioned earlier that as 
his church is not a registered charity, and didn’t have to report to the 
charity authorities, just to the church and to the diocese. If he is claiming 
Gift Aid he would need to keep a record of all donations made by individuals 
who are eligible for Gift Aid and separate records for collections etc. where 
multiple small cash sums (under £30) are collected for a claim under the Gift 
Aid Small Donations Scheme. As the maximum income on which a GASDS claim can be 
made is 10 times a GA claim for the same period, up to a maximum of £8000, it’s 
important to get a minimum of £800 in Gift-Aid-Claimable donations.

The recording of these transactions is essentially the same, Cash and Cheques 
received should be recorded in the appropriate asset accounts as before, but 
with child accounts to separate the different GA/GASDS income when the time 
comes to get some cash out of HMRC (the taxman, for non-UK readers).

As Rotary Club Treasurer I have Income Accounts for (among others):

Income:Donations:GA:General (for general donations to the charity account)
Income:Donations:GA:Whisky Tasting (for donations made at a Whisky Tasting event
etc, and

Income:Donations:GASDS:Santa (for cash collections during our Santa’s Sleigh 
collections
Income:Donations:GASDS:WIshing Well (for cash retrieved from a wishing well 
we’ve installed at a local attraction).

and I follow the general instructions given by Stan Brown:

Upon receiving the money:
Debit to Cash
Credit to the appropriate Income account

Upon depositing the held checks and cash:
Debit to Banks
Credit to Cash

The advantage of doing all this spade-work as the money comes in is that I can 
quickly generate the information for the Gift Aid and GASDS claims when the 
time comes, using GnuCash reports.

Regards,

Michael
___
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] Trouble building 5.3

2023-07-23 Thread Simon Roberts
Oh, so the dependency is specific to that feature? That's good to know, I
have no idea what that feature is, which suggests I don't use it.

All that said, I now, as if by way of a nudge, a crisis with that server, I
might have to rebuild it anyway, in which case perhaps I will upgrade it to
22.04 and be done.

My fingers are crossed I can get the machine back up--obviously that just
became my priority. Weekend? What's that?

Thanks for the input folks,
Cheers,
Simon


On Sun, Jul 23, 2023 at 9:10 AM mjchurc...@aol.com 
wrote:

> If you don't use AQBanking, you can build with it turned off. That's what
> I did with another distro. Mike
>
> On Saturday, July 22, 2023 at 02:15:43 PM PDT, Simon Roberts <
> si...@dancingcloudservices.com> wrote:
>
>
> Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
> a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
> on this 20.04 "production" machine, the same process is failing. I don't
> want to upgrade this at this time if I can help it--it would disturb too
> many other things that are working smoothly.
>
> I did this:
>
> $ sudo apt-get build-dep gnucash
> Reading package lists... Done
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.
>
> (I'm not sure why it installed nothing, I don't think I built GNC on this
> before)
> But then when I run the cmake process with:
>
> $ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/
>
> It progresses a while before reporting:
>
> -- Checking for module 'gwenhywfar>=5.6.0'
> --  Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
> CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
> (message):
>   A required package was not found
>
> At the risk of stating the obvious, it seems I have the older version:
>
> $ sudo apt list libgwenhywfar\*
> Listing... Done
> libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
> libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
> libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
> libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
> libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]
>
> And it doesn't seem that 20.04 is willing to upgrade this.
>
> Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
> successfully? Or can anyone offer a workaround (e.g. is it perhaps
> practical to build the newer version of this library by hand?)
>
> Thanks for any ideas!
> Cheers,
> Simon
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> 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.
>


-- 
Simon Roberts
(303) 249 3613
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Michael or Penny Novack




What sort of account would the 'intermediate' account be?  It's not an
'income' because money from it doesn't go straight to the bank
account. I guess it could be called an Asset.  In fact I suppose an
Asset account called 'Cash in Hand' would make some sense.

The reality is that I only count up the money every month or so, we
only have one service every two weeks,  it's a very small community with a
dearth of people available to take services.  The Church Warden bags
up the collections teken at the services and also the contents of the
offertory box.  Then, at the end of the month, as and when I have
time, I unbag the money, add it all together to check the Church
Warden's sums (always correct!) and take it to the Post Office or bank
to deposit it.

What I want is a way to record in the 'Collections' and separate
'Offertory Box' income accounts the amounts for the collections
at services and from the offertory box.  These all arrive in the bank
account as a single transaction.

It would be of type "asset". It would be used for the debit side of 
transactions as received. The credit side would be some income account, 
collections plate, offertory box, etc.Does the church warden note down 
how much was from each source as he puts it into the bag?


Then when you finally get around to depositing into the bank account, 
that would be a TRANSFER between two accounts both of type asset.


Michael D Novack


___
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] Trouble building 5.3

2023-07-23 Thread mjchurchil--- via gnucash-user
 If you don't use AQBanking, you can build with it turned off. That's what I 
did with another distro. Mike

On Saturday, July 22, 2023 at 02:15:43 PM PDT, Simon Roberts 
 wrote:  
 
 Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
on this 20.04 "production" machine, the same process is failing. I don't
want to upgrade this at this time if I can help it--it would disturb too
many other things that are working smoothly.

I did this:

$ sudo apt-get build-dep gnucash
Reading package lists... Done
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.

(I'm not sure why it installed nothing, I don't think I built GNC on this
before)
But then when I run the cmake process with:

$ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/

It progresses a while before reporting:

-- Checking for module 'gwenhywfar>=5.6.0'
--  Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
(message):
  A required package was not found

At the risk of stating the obvious, it seems I have the older version:

$ sudo apt list libgwenhywfar\*
Listing... Done
libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]

And it doesn't seem that 20.04 is willing to upgrade this.

Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
successfully? Or can anyone offer a workaround (e.g. is it perhaps
practical to build the newer version of this library by hand?)

Thanks for any ideas!
Cheers,
Simon

-- 
Simon Roberts
(303) 249 3613
___
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.
  
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Stan Brown
On 2023-07-23 02:03, Chris Green wrote:
> If I add an Assets:Current Assets:Cash to record the various amounts
> from collections, offertory box, etc. before they are deposited how do
> they then get recorded as Income when the cash is moved from Assets:
> Current Assets:Cash to Assets:Current Assets:Bank ?

They don't, because they're not income when you deposit them. they are
income when you _receive_ them.

Upon receiving the money:
Debit to Cash
Credit to the appropriate Income account

Upon depositing the held checks and cash:
Debit to Banks
Credit to Cash

It really seems to me that you are making this much, much harder than it
needs to be. But I don't know the magic words that will make the actual
simplicity shine through.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Chris Green
On Sun, Jul 23, 2023 at 11:05:24AM +0100, Michael Hendry wrote:
> On 23 Jul 2023, at 10:03, Chris Green  wrote:
> 
> > 
> >> 
> 
> > Petty Cash is also used in the UK for this.
> 
> …but is primarily a mechanism used for staff to make small purchases of 
> office sundries where setting up an account with the vendor is unnecessary 
> and it’s not appropriate for the member of staff to have a company cheque 
> book or credit card. 
> 
That's what I meant.  We use the term Petty Cash in the UK in much the
same way as it seems to be used in the USA.

> 
> > 
> > In reality (as in my reply just now) I only record deposits once a
> > month or so.  However there is of course nothing at all to prevent me
> > putting the actual date of the service where the money was collected
> > for the entry in the Assets:Current:Cash account.
> > 
> > However I'm still not quite clear how the various accounts work
> > together.  At present I have Assets, Equity, Expenses and Income top
> > level accounts.  Income is split into such things as Collections,
> > Offertory Box, Fund Raising, etc.
> > 
> > If I add an Assets:Current Assets:Cash to record the various amounts
> > from collections, offertory box, etc. before they are deposited how do
> > they then get recorded as Income when the cash is moved from Assets:
> > Current Assets:Cash to Assets:Current Assets:Bank ?
> 
> You should record the cash income from the various collections etc to the 
> Assets:Current Assets:Cash via the appropriate Income: account as you receive 
> it (or as you count up the cash in the bags), preferably with the date 
> on which the collection took place. When you eventually come to make the 
> deposit into your current bank account, this is simply recorded as a transfer 
> between two asset accounts - it is no longer income, any more than paying 
> off your credit card bill from your current account needs to be accounted 
> for as Expenditure (in this case you are transferring money from an asset 
> account (your bank) to a liability account (your credit card). 
> 
So I need two sets of Income sub-accounts then.  One records the cash
deposits into Assets:Current Assets:Cash and the other ones record
donations made direct to Assets:Current Assets:Bank.  People don't use
cheques any more here (well, very rarely) so there's no parallel
Assets:Current Assets:Cheques awaiting deposit.

The most important thing from my point of view is the ability to
present accounts to the diocese where all donations of a particular
type are collected together.  The above would seem to make it
difficult to show, for example, all money made for a fund raising
event where some is cash and some is paid direct by donor to the
church bank account.  I need a single sub-account where I can see
*all* money of a particular type regardless of how it got there.

-- 
Chris Green
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Chris Green
On Sun, Jul 23, 2023 at 12:02:25PM +0100, Fred Bone wrote:
> On 23 July 2023 at 9:34, Chris Green said:
> 
> [...]
> > I simply want to be able to able to have (conceptually) a multi-line
> > entry in the income sub-account called 'Collections at services' which
> > records two (or maybe more) amounts of cash paid in at one time.
> 
> But aren't you supposed to record each collection separately for GASDS 
> purposes? What happens if the two weeks are in different tax years?
> 
This is in the UK, no requirement like the above for us.


> AIUI you should be counting each bagged-up collection separately. It's 
> then a simple matter to record it as a txn from "Collection Income" to 
> "Money awaiting deposit", plus (I assume) another from "Envelope Income" 
> (or is it someone else's job to reconcile envelope contents against 
> people's promises?).
> 
> Then at pay-in-to-the-bank time, you have one txn from "Money awaiting 
> deposit" to "Bank".
> 
> This ensures that your books record what happened when, which is after 
> all the whole point.
> 
> If I were doing it, I'd keep separate "Cash awaiting deposit" and 
> "Cheques awaiting deposit" subaccounts, but that's probably not 
> essential. It would, however, make it easier to double-check the figures 
> on the paying-in slip, which I why I adopt that approach in my role as 
> area treasurer of a small charity.
> 
Yes, but do I as a result have to have separate 'Income' sub-accounts
in both the "Money awaiting deposit" and the "Current Account" accounts?

If so it makes collecting all the income more messy if nothing else.

In reality we get very few cheques nowadays, people either give cash
in collections at services (or put in the offertory box) or they pay
donations direct into the church's bank account from their bank
accounts.

-- 
Chris Green
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Fred Bone
On 23 July 2023 at 9:34, Chris Green said:

[...]
> I simply want to be able to able to have (conceptually) a multi-line
> entry in the income sub-account called 'Collections at services' which
> records two (or maybe more) amounts of cash paid in at one time.

But aren't you supposed to record each collection separately for GASDS 
purposes? What happens if the two weeks are in different tax years?

AIUI you should be counting each bagged-up collection separately. It's 
then a simple matter to record it as a txn from "Collection Income" to 
"Money awaiting deposit", plus (I assume) another from "Envelope Income" 
(or is it someone else's job to reconcile envelope contents against 
people's promises?).

Then at pay-in-to-the-bank time, you have one txn from "Money awaiting 
deposit" to "Bank".

This ensures that your books record what happened when, which is after 
all the whole point.

If I were doing it, I'd keep separate "Cash awaiting deposit" and 
"Cheques awaiting deposit" subaccounts, but that's probably not 
essential. It would, however, make it easier to double-check the figures 
on the paying-in slip, which I why I adopt that approach in my role as 
area treasurer of a small charity.

___
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] Fwd: Re: strange lack of exchange rates in a new currency cash account

2023-07-23 Thread Scott Ellsworth
...sorry, accidentally didn't reply to all, so I'm forwarding my reply to the 
list

- Original message -
From: Scott Ellsworth 
To: john 
Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account
Date: Sunday, July 23, 2023 17:10

*Hi John,*

- Original message -
From: john 
To: Scott Ellsworth 
Cc: GnuCash user forum 
Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account
Date: Sunday, July 23, 2023 02:17
*Thank you for your help. **I've used Gnucash for over 15 years, but suddenly 
I'm running into my ignorance about some features:*
The simple solution is to fix that split and remove or fix the 0 price entries 
in the pricedb.
*I never even knew about the Price Database before. In there I saw one item for 
every day, and I see a non-zero price for only one day, the 20th. When I went 
to the dong account just now, went into every split of every transaction, and 
clicked Edit Exchange Rate on each one, I only found one that was blank. I 
don't think I've solved the problem by entering the rate for that transaction, 
because I still see the Account Summary telling me that my ₫2,394,000.00 is 
worth $0.00 after refreshing it, when I know that it's actually worth about 
$101.*
**

You should check your other VND transactions to make sure that there aren't any 
other 0-price splits. There's only one set of prices for any particular 
commodity pair so you'd have to make a new book to see different price behavior.
*I think I have this covered now based on what I said above, but the problem 
remains. Looking at the Price Database again now, I still see a non-zero price 
only for one day in spite of the correction I made.*

The more complicated problem is how did that 0-price split get created and why 
did that become the price for the day instead of one of the others. Would you 
be willing to post a transaction report of the VND account with Display 
optiions set to show date, date entered, accounts, shares, and prices  with one 
line per split? Leave off description, memo, and account to keep confidential 
what you spent the money on, that's irrelevant here.
*I'll be happy to do this, but I haven't figured out how to add those columns 
to the register view.*

*Be Well,***
* ***
*Scott***
 Scott Ellsworth || +1 (775) 386-2519 
On Jul 22, 2023, at 01:34, Scott Ellsworth  wrote:
> 
> Hi John,
> 
> Every transaction is big enough to equal more than one cent. And the dong 
> cash register starts with an ATM withdrawal of 2 million dong. 
> 
> In the Price Database, which I was not familiar with before, I see three 
> entries, two of which are at zero value. The Account Summary now shows 
> "₫540,780.00 $0.00" but the transactions do usually have dollar equivalent 
> values: When I look at my Food account I see that the most recent 
> transactions were worth $1.18, $0.25, and $38.53. But I notice one 
> transaction from the 19th, a split transaction where the Food component came 
> out to zero and the number fields are simply blank on that line, not with 
> zeroes shown. The other parts of the transaction were $6.19 spent from 
> Assets:Cash:vn dong balanced against $3.18 spent on Expenses:Health, so the 
> transaction obviously does not balance. When I go to the blank line for 
> Expenses:Food and click on Jump, nothing happens. But when I go to the 
> Cash:vn dong account and find that transaction, I see an amount for the food 
> component, 549,000 dong, which was missing in the Food account.
> 
> This is confusing. I hope my file is not corrupted, since my financial data 
> is important to me. And it's strange that even after I created a second dong 
> cash account to test, the new account had the same exact problems.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: john 
> To: Scott Ellsworth 
> Cc: GnuCash user forum 
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Friday, July 21, 2023 23:24
> 
> Scott,
> 
> Did you perhaps get the balance to  2M VND in small increments so that the 
> USD value of every transaction rounded to $0.00? That would have prevented 
> the price from being recorded, resulting in the symptoms you describe. If 
> you've been trying to use VND for several days you can look at the price 
> database entries to see if any of the earlier transactions recorded prices.
> 
> Regards,
> John Ralls
> 
> > On Jul 21, 2023, at 01:14, Scott Ellsworth  wrote:
> > 
> > Another strange thing: It might be starting to work normally now: I just 
> > entered a couple of transactions and accidentally entered the exchange rate 
> > as 23,600 instead of 1/23,6000. Now it's starting to show the dollar 
> > equivalent on the Account Summary, even after I went back and corrected the 
> > exchange rate on those two transactions. I'm not sure if it's fixed, but at 
> > least for right now it appears to be working normally 

Re: [GNC] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Michael Hendry
On 23 Jul 2023, at 10:03, Chris Green  wrote:

> 
>> 

> Petty Cash is also used in the UK for this.

…but is primarily a mechanism used for staff to make small purchases of office 
sundries where setting up an account with the vendor is unnecessary and it’s 
not appropriate for the member of staff to have a company cheque book or credit 
card.

In my past incarnation as an NHS family doctor, we also used Petty Cash to 
receive small cash payments for non-NHS reports, certificates etc, with the 
approval of our accountant. This generally meant that the total in the Petty 
Cash box gradually increased until the next visit to the bank to deposit 
cheques was made, and the surplus cash was deposited at the same time.

> 
> In reality (as in my reply just now) I only record deposits once a
> month or so.  However there is of course nothing at all to prevent me
> putting the actual date of the service where the money was collected
> for the entry in the Assets:Current:Cash account.
> 
> However I'm still not quite clear how the various accounts work
> together.  At present I have Assets, Equity, Expenses and Income top
> level accounts.  Income is split into such things as Collections,
> Offertory Box, Fund Raising, etc.
> 
> If I add an Assets:Current Assets:Cash to record the various amounts
> from collections, offertory box, etc. before they are deposited how do
> they then get recorded as Income when the cash is moved from Assets:
> Current Assets:Cash to Assets:Current Assets:Bank ?

You should record the cash income from the various collections etc to the 
Assets:Current Assets:Cash via the appropriate Income: account as you receive 
it (or as you count up the cash in the bags), preferably with the date on which 
the collection took place. When you eventually come to make the deposit into 
your current bank account, this is simply recorded as a transfer between two 
asset accounts - it is no longer income, any more than paying off your credit 
card bill from your current account needs to be accounted for as Expenditure 
(in this case you are transferring money from an asset account (your bank) to a 
liability account (your credit card).

Regards,

Michael
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread David Cousens
Chris 

It may be useful to have two income sub-accounts one for the collections and one
for the Offertory box. The entry would then
be 

Asset :Bank   debit x+y
Income:Offertory  credit x
Income:Collectionscredit y

If you needed to record the undeposited funds when received and the deposit when
made it would be

Asset:Undeposited Cash  debit x+y
Income:Offertory credit x
Income:Collections   credit y

then when the deposit is made

Asset :Bank debit x+y
Asset:Undeposited Cash credit x+y

David Cousens

On Sun, 2023-07-23 at 09:50 +0100, Chris Green wrote:
> On Sun, Jul 23, 2023 at 10:12:05AM +1000, Liz wrote:
> > On Sat, 22 Jul 2023 17:56:09 +0100
> > Chris Green  wrote:
> > 
> > > But what if one has cash from two collections to go to the same
> > > account. I.e.  a collection on 22nd July and a collection on 29th
> > > July both paid in at the same time?
> > 
> > One way of doing this is with an intermediate account. You take the
> > cash from 22nd July and put it in the intermediate account, which could
> > be called "undeposited funds" or "cash on hand". You do the
> > same with the cash from 29th July. On banking day you put the cash from
> > the cash tin in the bank, and move it in your books from the
> > intermediate account to the bank account.
> > 
> > Summary
> > Physical movement of funds
> > 
> > collection > count done > cash tin 
> > 2nd collection > count done > cash tin > count done again
> > 
> > cash tin > bank (and another count)
> > 
> > Recorded movement of funds
> > collection > cash on hand 
> > 2nd collection > cash on hand
> > cash on hand > bank
> > 
> What sort of account would the 'intermediate' account be?  It's not an
> 'income' because money from it doesn't go straight to the bank
> account. I guess it could be called an Asset.  In fact I suppose an
> Asset account called 'Cash in Hand' would make some sense.
> 
> The reality is that I only count up the money every month or so, we
> only have one service every two weeks,  it's a very small community with a
> dearth of people available to take services.  The Church Warden bags
> up the collections teken at the services and also the contents of the
> offertory box.  Then, at the end of the month, as and when I have
> time, I unbag the money, add it all together to check the Church
> Warden's sums (always correct!) and take it to the Post Office or bank
> to deposit it.
> 
> What I want is a way to record in the 'Collections' and separate
> 'Offertory Box' income accounts the amounts for the collections
> at services and from the offertory box.  These all arrive in the bank
> account as a single transaction.
> 

___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Chris Green
On Sat, Jul 22, 2023 at 06:03:33PM -0700, Stan Brown wrote:
> 
> 
> 
> On 2023-07-22 13:45, Michael Hendry wrote:
> > Record the collections individually as Assets:Current Assets:Cash received 
> from the appropriate Income: account, one on the 22nd July, the second 
> on the 29th. 
> 
> With this I think we all agree. I do, certainly.
> 
> > When you come to deposit the cash in the current account the cash> moves 
> from Assets:Current:Cash to Assets:Current:Bank - the original 
> > sources of the cash aren’t relevant at this point.
> > The same applies to Cheques Received - the reason the cheque was
> received is recorded as it is received, and a bunch of cheques can be
> paid into the current account without having to specify what the cheques
> are for.
> 
> Or perhaps both cash and checks could go into a single account,
> Assets:Deposits Pending. That would perhaps save confusion with a
> different Cash account, Petty Cash (American name for cash on hand
> intended for making small purchases).
> 
Petty Cash is also used in the UK for this.

In reality (as in my reply just now) I only record deposits once a
month or so.  However there is of course nothing at all to prevent me
putting the actual date of the service where the money was collected
for the entry in the Assets:Current:Cash account.

However I'm still not quite clear how the various accounts work
together.  At present I have Assets, Equity, Expenses and Income top
level accounts.  Income is split into such things as Collections,
Offertory Box, Fund Raising, etc.

If I add an Assets:Current Assets:Cash to record the various amounts
from collections, offertory box, etc. before they are deposited how do
they then get recorded as Income when the cash is moved from Assets:
Current Assets:Cash to Assets:Current Assets:Bank ?

-- 
Chris Green
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Chris Green
On Sun, Jul 23, 2023 at 10:12:05AM +1000, Liz wrote:
> On Sat, 22 Jul 2023 17:56:09 +0100
> Chris Green  wrote:
> 
> > But what if one has cash from two collections to go to the same
> > account. I.e.  a collection on 22nd July and a collection on 29th
> > July both paid in at the same time?
> 
> One way of doing this is with an intermediate account. You take the
> cash from 22nd July and put it in the intermediate account, which could
> be called "undeposited funds" or "cash on hand". You do the
> same with the cash from 29th July. On banking day you put the cash from
> the cash tin in the bank, and move it in your books from the
> intermediate account to the bank account.
> 
> Summary
> Physical movement of funds
> 
> collection > count done > cash tin 
> 2nd collection > count done > cash tin > count done again
> 
> cash tin > bank (and another count)
> 
> Recorded movement of funds
> collection > cash on hand 
> 2nd collection > cash on hand
> cash on hand > bank
> 
What sort of account would the 'intermediate' account be?  It's not an
'income' because money from it doesn't go straight to the bank
account. I guess it could be called an Asset.  In fact I suppose an
Asset account called 'Cash in Hand' would make some sense.

The reality is that I only count up the money every month or so, we
only have one service every two weeks,  it's a very small community with a
dearth of people available to take services.  The Church Warden bags
up the collections teken at the services and also the contents of the
offertory box.  Then, at the end of the month, as and when I have
time, I unbag the money, add it all together to check the Church
Warden's sums (always correct!) and take it to the Post Office or bank
to deposit it.

What I want is a way to record in the 'Collections' and separate
'Offertory Box' income accounts the amounts for the collections
at services and from the offertory box.  These all arrive in the bank
account as a single transaction.

-- 
Chris Green
___
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] How to record payments for several items paid with a single transaction?

2023-07-23 Thread Chris Green
On Sat, Jul 22, 2023 at 05:50:47PM -0400, Michael or Penny Novack wrote:
> 
> > But what if one has cash from two collections to go to the same account.
> > I.e.  a collection on 22nd July and a collection on 29th July both
> > paid in at the same time?
> >
> First of all, you are perhaps confusing when money/cash/check received 
> with when deposited.
> 
> Let's say the following events:
> 
> a) 7/14   check $100 for building fund
> 
> b) 7/15   check $50   general donation
> 
> c) 7/16   collection plate$47.45
> 
> d) 7/17   deposited these checks and cash to the bank account
> 
> The ley thing to keep in mind is that the bank deposit date has nothing 
> to do with when "cash" was received. There are FOUR separate events 
> here, three receipts of cash (if normally no "cash box" might call tat 
> account "undepositied funds") and each of these credited to the 
> appropriate income account and then a fourth transaction transferring 
> the undeposaited funds to the bank account.
> 
> Is the source of confusion that you are e=required to list each check 
> separately on the deposit ticket? THAT has nothing to do with your books 
> (nor is it reflected in your bank statement. Think of that as just 
> rechecking your sums.
> 
I suspect you are suggesting that there should be an account called
'cash in hand' or something similar.  That doesn't exist and isn't
going to exist, for my trivially simple accounting system (which
satisfies both the accountant and the Diocese) it just complicates
things.

I simply want to be able to able to have (conceptually) a multi-line
entry in the income sub-account called 'Collections at services' which
records two (or maybe more) amounts of cash paid in at one time.

-- 
Chris Green
___
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] Wells Fargo OFX

2023-07-23 Thread David T. via gnucash-user
I'll take the contrarian position and note that there are more ways to 
synchronize your account with the bank's. Some argue that using the bank to 
keep your books up to date leaves you dependent entirely on the bank for 
accuracy. I enter the transactions for my family's activities manually, and 
while it gets tedious at times, it does give me a chance to review the 
transactions and have a check on what we are spending money on. And generally, 
it goes pretty quickly anyway. 

⁣David T. ​

On Jul 23, 2023, 6:12 AM, at 6:12 AM, Brad Morrison  
wrote:
>Hi Chris/all,
>
>Did you already review the information & links from my last email 
>responding to your OFX/online banking issues?
>
>https://lists.gnucash.org/pipermail/gnucash-user/2023-July/107875.html
>
>If so, did you have more specific questions?
>
>Thanks,
>
>Brad
>
>
>On 7/22/23 19:13, Chris Miller wrote:
>> Hi Folks,
>> I bank with Wells Fargo and have done so for 30 years. I've used
>> QuickBooks and Quicken for most of that time and they have worked
>out
>> well. Regardless, I am not a fan of Intuit.
>> I'm investigating GnuCash, and the thing I find most important is
>being
>> able to synchronize my accounts with Wells Fargo. However I'm not
>> finding much advice on how to set up OFX.
>> Does anybody have experience with this? Does anybody have advice
>for me
>> on how to do it, or if I should do it.
>> Thanks for the help,
>> Chris.
>> Laboriously sent to you from my ... do you really care?
>> ___
>> 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.
>>
>___
>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.
___
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.