What it looks like today
- · Export aging from the ERP into Excel.
- · Download payments from the payment provider.
- · Pull open tickets from the support system.
- · VLOOKUP on customer code to match the three.
- · Re-key the matches into the close working file.
- · Hope the codes line up across systems.
- Four hours, two coffees, one VLOOKUP error the auditor will ask about.