BAI file imported for checks that were not cut from Munis

Description of Issue
  • I need to be able to match imported bank items to legacy checks that were issued in a different system and are not in Munis
  • Cash has already been impacted for these checks
Context
  • Legacy checks
  • Bank Reconciliation 
  • BAI Import
  • Matching
  • Implementation
Cause

Checks were issued from a legacy system and the transactions have already impacted cash. 

Resolution
  1. Create Vendor number as a one-time-pay number = “OUTSTANDING LEGACY” or similar
  2. Create an AP Invoice Import file with Payment Type = Direct Disbursement and the check numbers of the legacy checks and amounts.  Use a miscellaneous expense account (one that is either has enough budget, or is unbudgeted) or a balance sheet account.
  3. Post the invoices (API)  and run Cash Disbursements (APP) journals.  This gets the checks onto the check table.
  4. Reverse the API journal and APP journal in the Journal Reversals program. This makes it so that there is  no GL impact for the checks. The checks will remain on the check table as outstanding and can be matched and/or cleared. 
Additional Information