Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-04-03 Thread arthur brogard via gnucash-user
I am just  making this late post only to say thanks for all the input and 
inform that my silence indicates my brow furrowed attempts at understanding and 
implementing.
I hope no one thinks I am rudely and ungratefully ignoring their help.  :)

On Saturday, 5 March 2022, 06:51:20 pm ACDT, flywire  
wrote:  
 
 Excellent question Arthur. This isn't a budget issue and you have no idea if 
tenants are in front or behind unless you compare it to payments due. Adrien 
seems to have presented the GnuCash features the best using a scheduled A/R.
I've used a different approach with quickbooks for this purpose because it has 
classes allowing one set of accounts to be tagged to different tenants but it 
should be equivalent with GnuCash. Accounts include: Income/rent, bond 
(contra), Expense/water (partially reimbursable), various misc income and 
expenditure relating to tenants. It's easy to miss seldom used accounts.
My concern is A/R is a lot of work just to get tenant statements if it's not 
used elsewhere. It is similar to the issue raised last month regarding tracking 
vehicles except for the regular rent due: 
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099785.html As 
described GnuCash has filtering on tags (eg report a single tenant) but no 
grouping (eg reports for every tenant and everything else). This is important 
to ensure all transactions are accounted for with tags.
Alternative Process:1. Upload bank transactions to GnuCash2. In GnuCash terms, 
run a transaction report sorted by say date and split notes (assuming it 
contains a tag) with payments3. Open report in a spreadsheet with sheets for 
each tenant having: Date, Due, Payments, Balance Owing4. Append date and 
payments to each tenants sheet5. Append date and amount due for each period6. 
Sort by date and payments then copy balance owing formula down for running 
total7. Check header and footer then print rental statement
The spreadsheet ends up as a template that is updated. It's a simple process 
but it's manual so it carries a risk of mistakes. While GnuCash doesn't support 
grouping in reports the advantage of open source is the whole thing could 
easily be automated under piecash to generate reports.
A dozen transactions would make a handy demo dataset.  
___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread flywire
https://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_print_a_Rental_Statement_for_my_Tenant.3F

A start.

>
___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread Adrien Monteleone

On 3/7/22 5:06 AM, flywire wrote:
An invoice must be prepared
for every rent due transaction and the payment processed. 
The 'preparing' is only the first time. After that, you just hit 
'Duplicate' and enter the new posting date.


'Processing Payment' is how you apply a specific payment to a specific 
invoice. It is also very little work. If importing actual payments from 
the bank, then one need 'Assign as Payment' after import. The process is 
otherwise the same.


That's an

incredible amount of manual processing for a simple schedule when, for
example, dates must be entered for invoices without seeing a list of
current invoices


I'm not sure what you mean by 'must be entered without seeing a current 
list'. If you are charging next months/weeks rent, you know the due 
date. You don't need a list of previous due dates. But if you want one, 
that exists too. It is called 'Bills Due Reminder' and there is one for 
AR and one for AP. And you can keep that window open so you can always 
see at a glance which rental invoices haven't been paid.


and payment amounts without seeing the deposit in the
bank account. 
If they haven't been received they shouldn't be entered. That's the same 
with cash or accrual. But once received, you have the money, so either 
manually enter a payment, or 'Process Payment' depending on method.


Especially so when tenant deposit dates and amounts don't

match invoices.


The Process Payment/Assign Payment window shows you which rental 
invoices haven't been paid. You get to choose which one to apply it to. 
And precisely because they won't match, the Business Features help you 
keep track of which applies to which. The Customer Report can even show 
you a column with that detail so you and the tenant can see which rent 
periods were paid and on what dates with which payments.


Every manual process is a risk and eventually, an error occurs. For me,
GnuCash would work well for your rental accounting but the process is too
complex involving too much risk just using the features of GnuCash to
produce a rental statement. In time I'd be interested to know what you
settle on.


I'd be interested to.

And please don't mistake my above comments. I'm not trying to stump for 
a particular method. I just want to clear up what I see are 
misconceptions about the workload involved or how the features work that 
I've observed and experienced while using them.


I do agree with your observation, the Guide could maybe use some 
attention in this matter. Better still, the Wiki is a great place for 
such 'use case' tutorials. I have some other Wiki stuff on the back 
burner, but once I get that out of the way, I might see about adding a 
page for this type of situation with screenshots. (if someone doesn't 
beat me to it)


Regards,
Adrien

___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-07 Thread flywire
Arthur,

Your original message was clarified to be about automatically posting
weekly rent so a rental statement can be produced with the balance of the
account at that date. This is a very simple schedule of regular dates and
amounts but GnuCash can't do it without manual workarounds. (Interestingly
it calculates much more complicated loan repayments.)

In a recent message, you replied "use the business features might be the
way to go" with Accounts Receivable. Do you understand the comment Michael
made about Accounts Receivable only working when accrual accounting is
used? In cash accounting income is recorded when payment is made but once
an invoice is posted under accrual accounting it is recorded as income. If
accrual accounting is used there is no way to know with say a normal profit
and loss report if the income has been received (see attached
TransactionReport.txt). This is a problem if you use cash accounting for a
personal tax return.

I don't think weekly rental statements are realistic so I've used 4 weekly
with the Business Account template, and the attached reports are for the
following test scenario:
* Tenant T Smith commenced 01 Mar 2020 with a lease at $250 pw payable
every 4 weeks.
* Tenant deposits into bank account: 06 Mar 2020 $750, 28 Apr 2020 $2000
* Reports are run 15 May 2020
* Just a mention that some users might have both Expense:Rent and
Income:Rent accounts which is a bad idea because eventually, they are
likely to inadvertently use the wrong account

I've never used GnuCash Business Finances so this was a good opportunity
for a first impression. GnuCash has a good tutorial for Personal Finances
but there's no equivalent for Business Finance. An invoice must be prepared
for every rent due transaction and the payment processed. That's an
incredible amount of manual processing for a simple schedule when, for
example, dates must be entered for invoices without seeing a list of
current invoices, and payment amounts without seeing the deposit in the
bank account. Especially so when tenant deposit dates and amounts don't
match invoices.

Every manual process is a risk and eventually, an error occurs. For me,
GnuCash would work well for your rental accounting but the process is too
complex involving too much risk just using the features of GnuCash to
produce a rental statement. In time I'd be interested to know what you
settle on.

>
Customer Report

 15/05/2020
T Smith

Date Range:
   Date Due Date   ReferenceTypeDescriptionDebitsCredits
 Balance
01/03/2020 01/03/2020 01 Invoice$1,000.00  
$1,000.00
06/03/2020   Payment $750.00
 $250.00
29/03/2020 29/03/2020 02 Invoice$1,000.00  
$1,250.00
26/04/2020 26/04/2020 03 Invoice$1,000.00  
$2,250.00
28/04/2020   Payment   $2,000.00
 $250.00
Period Total$3,000.00  $2,750.00
 $250.00
Total Due   
 $250.00
Pre-Payment  Current   0-30 days 31-60 days 61-90 days  91+ days Total
 $0.00$250.00  $0.00  $0.00  $0.00  $0.00$250.00Transaction Report

From 01/01/2020 to 15/05/2020

  DateNum Description Transfer from/to Debit
 Credit

Assets:Accounts Receivable
   01/03/2020   1 T Smith Income:Rent$1,000.00
   06/03/2020 T Smith Assets:Current Assets:Checking Account
  $750.00
   29/03/2020   2 T Smith Income:Rent$1,000.00
   26/04/2020   3 T Smith Income:Rent$1,000.00
   28/04/2020 T Smith Assets:Current Assets:Checking Account
$2,000.00
   Total For Accounts Receivable   $250.00

Assets:Current Assets:Checking Account
   06/03/2020 T Smith Assets:Accounts Receivable   $750.00
   28/04/2020 T Smith Assets:Accounts Receivable $2,000.00
   Total For Checking Account   
$2,750.00

Income:Rent
   01/03/2020   1 T Smith Assets:Accounts Receivable
$1,000.00
   29/03/2020   2 T Smith Assets:Accounts Receivable
$1,000.00
   26/04/2020   3 T Smith Assets:Accounts Receivable
$1,000.00
   Total For Rent   
$3,000.00

Grand Total 
$0.00___
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 

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-05 Thread Adrien Monteleone

And on that note,

I highly stress to anyone getting started (or even old hands) to not try 
to artificially combine receipts for convenience. You could if you 
wanted to, but I guarantee, you'll want to 'refactor' some of those line 
items one day, or wish you could.


Just enter receipts as multi-split transactions, line by line, with 
detailed info in the Memo fields. That way, if you ever want to move 
something to a different account in the future, it is possible.


The added bonus is you don't have to do math. GnuCash adds up the 
receipt for you.


If you combine fish with tires today, because you bought them on the 
same visit to Costco, you won't be able to split them up into Groceries 
& Auto 6 months from now.


If you insist on not doing separate line items, recording at least a 
small description for each and their respective amounts in the memo will 
help, but this gets cumbersome any but the simplest of purchases.


While this may sound nuts to some, you'd be surprised how 'auto-fill' on 
a new transaction to any particular store, magically needs little 
editing from visit to visit. It isn't like you're doing lots of data 
entry after a month or so of receipts.


And when you realize tracking Auto vs. Groceries is more important than 
where you bought them, you'll thank me later...


Regards,
Adrien

On 3/5/22 3:13 AM, Liz wrote:

If you are not sure about the expenses, make lots of expense
subaccounts to keep them in general categories, and rationalise them
when you have had a chat with your accountant. In GnuCash its easy to
join subaccounts and tedious to split them.


___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-05 Thread Adrien Monteleone

On 3/5/22 2:20 AM, flywire wrote:

My concern is A/R is a lot of work just to get tenant statements if it's
not used elsewhere.

It is similar to the issue raised last month regarding

tracking vehicles except for the regular rent due:
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099785.html
As described GnuCash has filtering on tags (eg report a single tenant) but
no grouping (eg reports for every tenant and everything else). This is
important to ensure all transactions are accounted for with tags.


As long as you aren't trying to track multiple 'properties' and generate 
separate P for each from a single book, there is little work 
involved. (the 'GnuCash' way here would be to use separate books for 
each property, then have a consolidated book for the few remaining 
entries, otherwise, yes, a tag system or other means would have to be 
employed)


I use the Business Features for AR with 3 clients, and AP with 7 vendors 
that issue recurring bills. (3 of which are monthly, 1 semi-annual, 3 
annual)


One could certainly handle many more, but high-volume auto-recurrence 
isn't yet built in without a bit of creative thinking. (that's another 
bug & thread concerning Scheduled Invoices)


However, there's nothing 'elsewhere' you need to do things for AR to 
work. Assuming you've got your accounts created:


1. Set up Customer (Tenant)
2. Create and post Invoice for 'rent'
3. Send 'Customer Report' statement of account
4. Process Payment, applying it to the invoice
5. repeat steps 2-4 as needed (#3 can be done at any time)



Alternative Process:
1. Upload bank transactions to GnuCash
2. In GnuCash terms, run a transaction report sorted by say date and split
notes (assuming it contains a tag) with payments
3. Open report in a spreadsheet with sheets for each tenant having: Date,
Due, Payments, Balance Owing
4. Append date and payments to each tenants sheet
5. Append date and amount due for each period
6. Sort by date and payments then copy balance owing formula down for
running total
7. Check header and footer then print rental statement

The spreadsheet ends up as a template that is updated. It's a
simple process but it's manual so it carries a risk of mistakes. While
GnuCash doesn't support grouping in reports the advantage of open source is
the whole thing could easily be automated under piecash to generate reports.


If the P/Income Statement had the filter options of the Transaction 
Report, life would be much easier. Then you could just filter for your 
tag, and get a custom statement for just those transactions.


I filed an enhancement request specifically for this: 
https://bugs.gnucash.org/show_bug.cgi?id=798469


There is also the more generic RFE here: 
https://bugs.gnucash.org/show_bug.cgi?id=113772


I'm not sure how difficult sorting (grouping) a Transaction Report by a 
tags would be, since tags aren't officially implemented, and can appear 
in a number of fields. Otherwise, I'd file an RFE on that too, which 
would likely satisfy many uses cases.


Regards,
Adrien

___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-05 Thread Liz
On Fri, 4 Mar 2022 19:26:04 -0500
Glenn Fowler  wrote:

> Hi,
> 
> I use GnuCash for rental properties as well. Setup your accounts under
> expenses for repairs, insurance, utilities, etc. In my case, I setup a
> recurring transaction for rental income. Then, you only need to make
> changes as needed instead of doing it manually every month.

You need to have some idea on the tax implications of your expenses.
In AU, this is where we start to rival North American sales tax ;)

So some expenses are recurring - like rates and insurance and are tax
deductible
Some expenses are general maintenance - the bills from the plumber and
electrician for callouts and are tax deductible
Some expenses are capital - when you decide to replace the kitchen
because it is wear and tear and scruffy, but not if it is seriously
damaged by floods (topical here), that would be maintenance or on the
insurance.

Some expenses can be sent back to the tenant to pay (here we charge
water usage to the tenant, but not if you didn't fix the leaky taps or
cistern)

Whether interest charges on the mortgage you have over the property are
expenses which are tax deductible or capital expenses depends on the
flavour of government - it seems to oscillate slowly here.

If you are not sure about the expenses, make lots of expense
subaccounts to keep them in general categories, and rationalise them
when you have had a chat with your accountant. In GnuCash its easy to
join subaccounts and tedious to split them.

Liz
___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-05 Thread flywire
Excellent question Arthur. This isn't a budget issue and you have no idea
if tenants are in front or behind unless you compare it to payments
due. Adrien seems to have presented the GnuCash features the best using a
scheduled A/R.

I've used a different approach with quickbooks for this purpose because it
has classes allowing one set of accounts to be tagged to different tenants
but it should be equivalent with GnuCash. Accounts include: Income/rent,
bond (contra), Expense/water (partially reimbursable), various misc income
and expenditure relating to tenants. It's easy to miss seldom used accounts.

My concern is A/R is a lot of work just to get tenant statements if it's
not used elsewhere. It is similar to the issue raised last month regarding
tracking vehicles except for the regular rent due:
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099785.html
As described GnuCash has filtering on tags (eg report a single tenant) but
no grouping (eg reports for every tenant and everything else). This is
important to ensure all transactions are accounted for with tags.

Alternative Process:
1. Upload bank transactions to GnuCash
2. In GnuCash terms, run a transaction report sorted by say date and split
notes (assuming it contains a tag) with payments
3. Open report in a spreadsheet with sheets for each tenant having: Date,
Due, Payments, Balance Owing
4. Append date and payments to each tenants sheet
5. Append date and amount due for each period
6. Sort by date and payments then copy balance owing formula down for
running total
7. Check header and footer then print rental statement

The spreadsheet ends up as a template that is updated. It's a
simple process but it's manual so it carries a risk of mistakes. While
GnuCash doesn't support grouping in reports the advantage of open source is
the whole thing could easily be automated under piecash to generate reports.

A dozen transactions would make a handy demo dataset.
___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread Adrien Monteleone

Arthur,

Yes. You can do this, but you'll need to decide based on your situation 
the best workflow.


What you are describing is Accounts Receivable (AR). The Rent is due at 
a certain date and thus owing to you. Ideally, you want to 'book' the 
rent payment as due in the AR account as of that due date.


Here is what that transaction would look like:

dr. Accounts Receivable
cr. Income/Revenue:Rent (not sure how you've named this account)

The amount for each 'split' or each 'side' of the transaction should be 
equal. Money is thus 'flowing' from your Income/Revenue account, 'to' 
AR. (an asset account)


When you receive payments, you would decrease AR and increase the 
respective asset account. (Cash/Bank, etc.) thus:


dr. Cash/Bank
cr. Accounts Receivable

-

Now, this is just a general overview. And in this simple case, you 
aren't separately tracking individual tenants.


In order to do so, you have to make a choice as to how in GnuCash you 
are going to accomplish this. Each method has its benefits and drawbacks.


1. Manually for everything.
2. Using Scheduled Transactions (with careful attention to auto-firing 
and previewing/editing before they are posted)

3. Using the Business Features

Which one you choose will more than likely be dictated by how many 
tenants (and properties) you have.


If it is more than 5-10, maybe even more than just 5, I'd skip #1.

#2 can be set up easily enough, but better to use this for a small # of 
tenants. Maybe less than 20. (and that may be too much) The reason here 
is that you'd need a separate sub-account of AR for each tenant, create 
the SX to apply to those subaccounts, and track payments somewhat 
manually. (though you can craft reports to help)


#3 is probably the way to go, but you don't get 'automatic' postings. 
You *can* however, import 'invoices' for 'rent due' an a regular basis 
for all tenants at once. If you have just a handful of tenants, you can 
manually use the 'Duplicate' function to repeat previous 'rent invoices'.


In this scenario, 'Tenants' are 'Customers'.

Using the Business Features this way, will allow you to print 'Customer 
Reports' which are the same as 'Account Statements' *and* those reports 
can show which payments applied to which period's rent.


Read over the Help & Tutorial documents concerning setting up your 
Customers and Invoices.


If you run into any snags or have questions, chime back in and we'll try 
to speed you on your way.



*IMPORTANT - avoid making manual or SX entried to the system-provided AR 
account. Leave that alone for the Business Features to deal with. If you 
need to make manual entries, create another account called AR-Other or 
similar and make it of 'type' Asset *NOT* of type A/Receivable. (there 
can be only one of the A/Receivable type accounts) Then if you are 
manually tracking tenants, create additional 'asset' type accounts as 
children of AR-Other.


-
As for over/pre-payments, when you Process Payment from a Customer, you 
get the option to apply it to an invoice, or not. If not, it is 
considered a pre-payment and can be applied later. (by using the same 
Process Payment window again, but this time, simply linking the existing 
pre-payment to the new invoice)


If an over-payment, the remainder will be available to apply to a future 
invoice in the same way.



Regards,
Adrien

On 3/4/22 5:44 PM, arthur brogard via gnucash-user wrote:

No. Sorry. Didn't put the question right.  I mean automatic post to the account 
showing what's owing so that I can see (and print out) at any time (on week by 
week steps) the balance of the account at that date.
Because in fact they're frequently in the red.
And frequently in front, ironically, because they never match payments up with 
owings.  So when they come from behind they may finish up with balance of an 
amount like maybe $27.50 ,  not enough for a week's rent but nevertheless by 
law I must consider it rental money.
I guess if we credit their account with the monies they pay in then I'd be 
talking about an automatic debit of the rent amount each week.
Would that be right?  Save me the trouble of entering it on the due date every 
week.
Or am I going about it all wrong?


___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread Glenn Fowler
Hi,

I use GnuCash for rental properties as well. Setup your accounts under
expenses for repairs, insurance, utilities, etc. In my case, I setup a
recurring transaction for rental income. Then, you only need to make
changes as needed instead of doing it manually every month.



On Fri, Mar 4, 2022 at 6:15 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 3/4/2022 4:46 PM, arthur brogard via gnucash-user wrote:
> > We intend to start using gnucash to keep an account of our rental
> property.
> > This is our first for everything: having a rental, keeping accounts,
> using gnucash.
> > We can open an account for the property and enter all amounts received
> as we get them.
> > We can open another for other expenses such as water, I guess.
> > Can we somehow set it up so that the rent due every week is posted to
> that rent account automatically?
>
> What Derek said ,,, The "general ledger"is a record of transactions
> that have happened. Gnucash also can produce "budget" reports and ":cash
> flow" reports.
>
> Is this some sort of situation where there is close to certainty that
> the rent WILL arrive as scheduled? That's the only situation where I
> might be tempted to make that an automatic scheduled transaction << say
> some agency is paying the rent on behalf of this tenant >>
>
> 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
> 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.


Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread arthur brogard via gnucash-user
No. Sorry. Didn't put the question right.  I mean automatic post to the account 
showing what's owing so that I can see (and print out) at any time (on week by 
week steps) the balance of the account at that date.
Because in fact they're frequently in the red.
And frequently in front, ironically, because they never match payments up with 
owings.  So when they come from behind they may finish up with balance of an 
amount like maybe $27.50 ,  not enough for a week's rent but nevertheless by 
law I must consider it rental money.
I guess if we credit their account with the monies they pay in then I'd be 
talking about an automatic debit of the rent amount each week.
Would that be right?  Save me the trouble of entering it on the due date every 
week.
Or am I going about it all wrong?

 

On Saturday, 5 March 2022, 08:28:56 am ACDT, Derek Atkins  
wrote:  
 
 Hi,

On Fri, March 4, 2022 4:46 pm, arthur brogard via gnucash-user wrote:
>
> We intend to start using gnucash to keep an account of our rental
> property.
> This is our first for everything: having a rental, keeping accounts, using
> gnucash.
> We can open an account for the property and enter all amounts received as
> we get them.
> We can open another for other expenses such as water, I guess.
> Can we somehow set it up so that the rent due every week is posted to that
> rent account automatically?

Sure, you can set up a scheduled transaction to record it, but that of
course assumes that the rent check DOES come every week...

> :)

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
      Derek Atkins                617-623-3745
      de...@ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant

  
___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread Michael or Penny Novack

On 3/4/2022 4:46 PM, arthur brogard via gnucash-user wrote:

We intend to start using gnucash to keep an account of our rental property.
This is our first for everything: having a rental, keeping accounts, using 
gnucash.
We can open an account for the property and enter all amounts received as we 
get them.
We can open another for other expenses such as water, I guess.
Can we somehow set it up so that the rent due every week is posted to that rent 
account automatically?


What Derek said ,,, The "general ledger"is a record of transactions 
that have happened. Gnucash also can produce "budget" reports and ":cash 
flow" reports.


Is this some sort of situation where there is close to certainty that 
the rent WILL arrive as scheduled? That's the only situation where I 
might be tempted to make that an automatic scheduled transaction << say 
some agency is paying the rent on behalf of this tenant >>


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
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread Derek Atkins
Hi,

On Fri, March 4, 2022 4:46 pm, arthur brogard via gnucash-user wrote:
>
> We intend to start using gnucash to keep an account of our rental
> property.
> This is our first for everything: having a rental, keeping accounts, using
> gnucash.
> We can open an account for the property and enter all amounts received as
> we get them.
> We can open another for other expenses such as water, I guess.
> Can we somehow set it up so that the rent due every week is posted to that
> rent account automatically?

Sure, you can set up a scheduled transaction to record it, but that of
course assumes that the rent check DOES come every week...

> :)

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

2022-03-04 Thread arthur brogard via gnucash-user


We intend to start using gnucash to keep an account of our rental property.
This is our first for everything: having a rental, keeping accounts, using 
gnucash.
We can open an account for the property and enter all amounts received as we 
get them.
We can open another for other expenses such as water, I guess.
Can we somehow set it up so that the rent due every week is posted to that rent 
account automatically?
:)
___
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.