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
