[Rodopi] Rodopi AR Question

[Dessa B. Hix]

Title: Rodopi AR Question

When I use the phrase Total Payments, I'm referring to the Rodopi P&A report called Payments Total.  Every transaction in Rodopi (including any debit or credit adjustments) will appear on either Payments Total, Recurring Sales Total, or Non-Recurring Sales Total.  The sum of those for a given period added to the AR total at the beginning of the period will give you AR for the end of the period, in my experience.  If you use customized reports that don't include every transaction type, be sure that the total of your individual reports equals the three Rodopi Total reports.  If that doesn't equal, AR can't equal.   I chose not to use the Accrual Accounting option because I wasn't sure what Rodopi would do with it--I just didn't trust non-accountants to write software that sophisticated.  It could certainly be the problem.   Dessa Hix ----- Original Message ----- From: Penny McLaughlin To: [EMAIL PROTECTED] Sent: Friday, May 14, 2004 10:36 AM Subject: [Rodopi] Rodopi AR Question Dessa:   How about debit or credit adjustments�should they be taken into consideration?  I am having the same problem as the gentleman and have yet to figure it out.  I wonder if it is because we are both using accrual accounting?   Penny   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dessa B. Hix Sent: Friday, May 14, 2004 7:49 AM To: [EMAIL PROTECTED] Subject: [Rodopi] Rodopi AR Question   I have been told that The sum of the open AR and closed AR does not always equal the AR report that includes all accounts.  I never print them separately, so I can't say for sure.  We do not use Accrual Accounting (under Configuration>Billing Configuration>Billing policies).  I can always balance AR, unless a customer has been upgraded to a plan that includes a discount, which causes Rodopi to change history!  (When this happens, Rodopi gives the customer a discount with an effective date in the past.  My senior systems administrator was always able to find the transaction with an entry date in the current month but an effective date sometime in the past, and he would delete the entry, which restored AR to its correct balance.)   Compare the two AR figures you have printed with the AR that shows all accounts.  That number, plus Non-recurring and Recurring sales for the month, less Total Payments for the month, will equal current AR in my experience.  If you run an AR report today for any date in the past and it is different from the report you printed in the past, discounts may be your problem.   Dessa Hix ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 6:08 PM Subject: [Rodopi] Rodopi AR Question   Hi all!  It's been a long time since I posted to the list but I have recently had a difficult time figuring something out and I know there are some experts here that might send me in the right direction.  This may seem pretty basic, but I just can't get the numbers to add up. On the first of each month, we print both opened and closed accounts receivable reports.  We also print recurring and non-recurring sales reports for the prior month, as well as the payments report.  When I take the prior month's two AR report totals, add the two sales reports totals for the prior month, and subtract the total payments for the prior month, why does this total not equal the balances on a beginning of the next month's AR reports?  Similarly, if I take the AR balance on the beginning of a month, add all of the DebitMovements for the month and subtract all the CreditMovements for the month, shouldn't the result equal the end of month AR balance?  Taking the Rodopi reports or the data straight from the database gives me the same result which doesn't match the Rodopi AR balance as I think it should.  Am I missing something here?  I have been working on tweaking our company's accounting processes and discovered that our bookkeeper was just putting an adjusting entry to a clearing account to balance the AR in Quickbooks to the AR in Rodopi but since we are already putting all of the sales and payment transactions from Rodopi into Quickbooks, I would think this should always match but now I see it doesn't even add up within Rodopi.  Any help would be greatly appreciated.  TIA! John Prather, CEO Brand X Networks, Inc. "The standard against which all others are measured" Quality VISP and Outsourced Support Services 559.420.5210 voice 559.490.8630 fax