[IUG] monthly invoice reconcilliation

["Kevin Merriman (kmrriman)" <kmrriman at memphis dot edu>]

Hi,

Would anyone be willing to share procedures for monthly invoice reconciliation?
Now, the best I can come up with is looking up each vendor and
going to the invoice tab to compare with my accounts payable statement.

I tried a list but the output from a list is difficult to read because it looks like this:
"Subtotal: -$345.00 Total: -$345.00 Shipping: $0.00 Tax: $0.00 Discount: $0.00"
the EDI invoices have total before subtotal so even in Excel, it's difficult to break up the sub-fields.

I would just like a single list or spreadsheet with fields for
vendors, funds (would external funds be too much to ask), and totals.

I'm thinking "print vouchers" might be the ticket but
I cannot figure the relationship of the record numbers (1-8232)
to my last printed voucher number of 5299.

Please, how do other ACQ folks reconcile?

Kind regards,

Kevin

~~~~~~~~~~~~~~~~~~~
Kevin W. Merriman
Head of Collection Management
126 Ned R. McWherter Library
Room 303-C
University of Memphis
Memphis, TN 38152-3250

http://www.linkedin.com/in/kevmerriman
Email: kevin dot merriman at memphis dot edu
Phone:  901-678-4400
Fax:  901-678-8218


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---