[IUG] monthly invoice reconcilliation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Date: Sat, 12 Nov 2011 00:53:13 +0000
- From: "Kevin Merriman (kmrriman)" <kmrriman at memphis dot edu>
- Subject: [IUG] monthly invoice reconcilliation
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?
Kevin W. Merriman
Head of Collection Management
126 Ned R. McWherter Library
University of Memphis
Memphis, TN 38152-3250
Email: kevin dot merriman at memphis dot edu
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--- StripMime Report -- processed MIME parts ---
text/plain (text body -- kept)