I am having difficulty reconciling the Open Invoice Report. Theoretically, I should be able to take the beginning Open Invoice Report, add vouchers and subtract payments listed on the Account Distribution Report, and come up with the ending Open Invoice Report. This never works. I am sure that I am merely having difficulty with the correct dates. There are so many different dates to choose from. Can anyone give me an example of what he or she does to reconcile this report? Thanks. Angie Markert [i]--- Edited at 10/16/2007 2:15:56 PM by Angie Markert[/i]

We always have trouble reconciling the open invoice report to our general ledger account. We will sometimes post an invoice in a future period and pay currently (like paying early for health insurance). This will post the gl correctly, however, the invoice won't show because it won't be in the period selected and the payment won't show as a negative. (These items we just know.)We also find inconsistencies that occur when we have to void a check and delete an invoice which cross over a period. I use query to find these anomolies. I hate to admit it, but when we started with Blackbaud, we actually had to download the entire year's activity from our general ledger accounts payable account, print beginning and ending year's open invoice reports, delete offseting dr's and cr's (invoices and their corresponding payments, match payments to the beginning trial balance and invoice additions to the ending trial balance and see what is left in the general ledger. 30 staff hours later, this is how we found the various reconciling items. Kathy Purcell CFO YWCA of Minneapolis Kathy Purcell CFO

We have had no trouble balancing our open invoice report; however, you do have to be "super" disciplined to have the reports work for you properly. i.e. we found issues such as posting invoices in next month and then paying early in this month and thus creating a reconciling item. we dont do that now and our reports reconcile to the penny. one thing that remains a reconciling item that BB hasnt fixed is if you delete a posted invoice the GL will not show you the unposted deletion on the GL report (until you post it of course). a small issue they have acknowledged. other than that it seems to work for us.

We have found that a combination of the Open Invoice report (run as of month end) and a Vendor Activity Report (run for next period) will reconcile to the general ledger. We, too, post invoices in the next period and pay them in the current period. The Vendor Activity Report will show those. Those payments (ignore any unpaid future invoices) plus the open invoice report equals the g/l balance. If you have unapplied credit memos, you do need to remember to tweak the open invoice report to include them.