BravoTran’s Standard CASS spreadsheet transformer requires either the “XLS” or the “HOT as XLS” report to work. BravoTran supports the following Standard CASS strategies for either format:

1. One invoice – whole spreadsheet is transformed into one invoice in BravoTran (default).
2. One invoice per airline – spreadsheet will be transformed into one invoice per airline, useful if you want to assign each invoice to a different creditor.
3. One invoice per row – spreadsheet will be transformed into one invoice per row, useful if you want to assign to different creditors and want invoices to post without waiting for approvals for other rows.

Regardless of format, BravoTran will need to do the following before sending in the first one:

1. Make sure it’s in either “XLS” or “HOT As XLS” format
2. Configure Standard CASS Strategy in BravoTran
3. Optionally import a spreadsheet of airline codes to CW1 org codes so the vendor gets assigned correctly automatically – only if assigning to different vendors
4. Test with a spreadsheet with 3-4 rows

XLS Format

Where to find the “XLS” report:

Example report:

Standard CASS Basic XLS Example.xls

HOT As XLS Format

Where to find the “HOT as XLS” report:

Example report:

CASS HOT XLS Example.xls