Reconciliation of expenses with external university ledgers

MSAccess with tables derived from the following sources: OLE: Invoice line items: ID, Price (including all additional expenses such as s&h charged to a particular po), UFAS account (external university account number and subaccount), Invoice Number, Invoice date, Vendor Name, Vendor number, PO number, Account (fund code); ILS App: AP voucher number (accounts payable voucher number), Pay date, check number AP voucher number assigned automatically within ILS App, check/payment document number returned by campus system Business Objects: SLAcct6 No (University account number), Acct Short Name (Account Name), Batch Ref No, Entry Cd Desc (Entry Code Description), Entry Cd (Entry Code), Trans Amt (Amount), Trans SubAcct No (Subaccount number), Trans Desc (Transaction Description), Post Mo (post month), Post Day, Trans No (Transaction Number), Trans Control No (Control number, usually the AP voucher number), Account and subaccount (Concatenation of SLAcct6 No and Trans SubAcct No)