[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to handle periodic cash reciepts vs. non-periodic accounts payable?

On Mon, 2006-09-25 at 13:56 -0400, Richard Ellis wrote:
> What I can't quite deduce is an easy way to enter the cash reciept
> from the tenant each bi-week and have it automatically "close" the AR
> transactions as time goes by and the bi-weekly reciepts "fill" the
> outstanding AR rent transactions.
> I tried "spreading" the bi-weekly payment out among outstanding AR
> transactions, but eventually I end up with a negative AR payment due
> when the tenant is "ahead" of the monthly rent (because I would not
> have entered next months AR transaction yet), which then starts to
> get either LSMB or me confused and messes up the totals in later
> months.

This is the way I would do it. When the tenant is "ahead" over pay the
current month. When you do that LSMB will create a new AP transaction
with just a payment (a credit) for the amount you over pay. When the
next bi-weekly payment comes you can apply the credit plus the mornal
payment to the new monthly transaction.
> I've also tried simply inputting the bi-weekly payment as a cash
> reciept not linked to any particular AR rent transaction.  This works
> better in that the totals do not get out of whack in later dates, and
> I don't get confused as to what I've done, but then LSMB thinks that
> all the AR transactions for the montly rents are "open", even though
> in the Outstanding and AR Aging reports it shows no total due.

You could go this way too. You just have to create a $0.00 receipt that
"pays" the monthly transactions with the credits created by the
bi-weekly payments every so often. The other way just does this as you
go without creating a bunch of unnecessary AP transactions.

Tony Fraser
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398