I've just finally found the 'reply to all' feature of yahoo... I'm getting
there..
That's interesting about the mail merge. I will look into it. Thanks.
Sound like it might be the thing. Bit of a hassle setting up the document but
from then on....
Meanwhile I'll play with gnucash. Learn a bit. Make an account for him.
Credit with his payments. I or gnucash will debit cash at bank I suppose.
And need another account for what he owes? That increments every week - can't
be done is what I've learned here? And that would be an 'accounts receivable'
account?
Where's the double entry for that? If it increments $200 for rent where's the
other entry? In his actual account? Credit acc. rec. and debit his account?
Then if that's so how does it get wiped out? He pays: I credit his account,
good, balance goes to zero. I debit cash at banks. Good, the two entries
match.
But the incremented 'accounts payable' remains with the credited $200 and
they're just mounting up.
Is that how it works?
On Tuesday, 8 March 2022, 09:57:35 am ACDT, D. <sunfis...@yahoo.com> wrote:
With your system, you could use your spreadsheet as a data source for a Word
mail merge document that would fill in the receipt information from the
spreadsheet. No editing necessary, just process the single entry to a new
document (or pdf). Probably could have a calculated cell in Excel for balance
due as well.
It ain't Gnucash, but it might make you happier...
DavidFrom: arthur brogard via gnucash-user
Sent: Mon Mar 07 14:35:44 EST 2022
To: "gnucash-u...@lists.gnucash.org"
Subject: [GNC] Subject: Re: Keeping tenant accounts on Gnucash - periodic 'rent
owing' ?
Thanks for these inputs. Hope I haven't done anything wrong. I'm still
blundering around trying to understand how to work the mailing list thing.
It all looks too complicated to me. Not worth the hassle.
I'll tell you what I"ve got right now:
I have a spreadsheet that I enter money received, date received, payer
into. It shows me then immediately which weeks rents have been pad and what the
balance is at that rent day.
If they've paid money for 'other', i.e. not rent money, I enter that amount
into 'other' and only the rent amount into rent.
The 'other' bit is not automated at all. I have to eyeball it and calculate
balance each time.
So I enter their payment in there and see what balances I've got.
Then I go to Word and pick up the last receipt I sent them and I modify it to
suit this week's numbers. And save it with the date of it. Hence I've got a
record of every receipt sent and I've got the spreadsheet.
The receipts, I know, are not required by law because they pay by direct
deposit. But I prefer to do it that way.
Now the pain is modifying that receipt.
If I could have an account where I simply enter the receipt and it shows me the
balance and I print that out as a receipt that'd be great.
That account would have to have automatically incremented the 'amount due' as
the real life dates passed.
Well, two balances: the rent and the 'other'.
That's all I'm after.
When I asked I really thought I'd get a reply saying that all such cases of
meeting period payments, recording them, printing out statements of account and
receipts are done by 'such and such' software or 'this and that' feature of
gnucash.
I realise (now) I'm making things abnormal in that my 'receipt' is really a
receipt AND a statement, isn't it?
A plain receipt would be easy as pie.
No. I need more than that. Everything has to be crystal clear to this tenant.
What he's paid for rent, what for other, what the balances are when the next
payment is due, which weeks have been paid for.
What I will do is start using gnucash with my present state of knowledge and
just find out what happens. See how I go.
I'll use cash accounting I guess. See no need for accrual as best I hazily
remember my accounting. (It was over 20 years ago).
Do we have to tell gnucash which we're using or its all in how we enter things?
Thanks for all the interest and help.
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.
_______________________________________________
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.
